Home » RDBMS Server » Backup & Recovery » Need to reproduce live server backup on test machine (windows, oracle 8.1.7)
Need to reproduce live server backup on test machine [message #484966] Sat, 04 December 2010 08:03 Go to next message
ateeqrahman786
Messages: 52
Registered: December 2009
Location: Hyderabad,India
Member
Hi,

We are using the setup as below.

The database backup (O/S Copy) is copied to a local drive on the live server (A). This backup is the copied on another machine (B) which is used as test database.

Now,I am planning to use RMAN as backup tool. Since the RMAN backup's are stored in RMAN format, how could i reproduce this in another machine.

Please suggest as i need last day's data for testing purpose. I can't use Dataguard as the test server is not same as live server.


Please suggest an alternative,

Best Regards,


Re: Need to reproduce live server backup on test machine [message #484967 is a reply to message #484966] Sat, 04 December 2010 08:09 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
You can just restore in a new host
or
duplicate the database.
http://download.oracle.com/docs/cd/A87860_01/doc/server.817/a76990/toc.htm
Re: Need to reproduce live server backup on test machine [message #484969 is a reply to message #484967] Sat, 04 December 2010 09:32 Go to previous messageGo to next message
ateeqrahman786
Messages: 52
Registered: December 2009
Location: Hyderabad,India
Member
Since i need to update the test database regularly, is the option of duplicate database via RMAN feasible? Is there any alternative method..

Thanks,

Re: Need to reproduce live server backup on test machine [message #484971 is a reply to message #484969] Sat, 04 December 2010 09:47 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>Since i need to update the test database regularly
Depends on volume of Datbase.
If volume is less, export/import will do.
Still RMAN duplication is way faster as it just involves restoring to a point-in-time. You can restore a whole database or select tablespaces.
And all these are done without shutting down the production database and can be scripted.
Re: Need to reproduce live server backup on test machine [message #484974 is a reply to message #484971] Sat, 04 December 2010 10:53 Go to previous messageGo to next message
ateeqrahman786
Messages: 52
Registered: December 2009
Location: Hyderabad,India
Member
Do i need a catalog for creating a Duplicate database? Since the target and the duplicate database has same directory structure, i guess there will be less work in duplicating.

Thanks for your help.
Re: Need to reproduce live server backup on test machine [message #484975 is a reply to message #484974] Sat, 04 December 2010 11:21 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
when all else fail Read The Fine Manual

http://download.oracle.com/docs/cd/A87860_01/doc/server.817/a76993/intro.htm#430434
Re: Need to reproduce live server backup on test machine [message #485156 is a reply to message #484975] Mon, 06 December 2010 08:46 Go to previous messageGo to next message
kudur_kv
Messages: 75
Registered: February 2005
Member
I'd suggest that you set up a cronjob or a scheduled job (windows) for the same actions that you'd do if you were doing it manually.

1. delete all old backups
2. delete all of the current DB files
3. copy all the necessary backup files from the prod server
4. Run the duplicate DB command again.
Re: Need to reproduce live server backup on test machine [message #485263 is a reply to message #485156] Tue, 07 December 2010 01:53 Go to previous message
ateeqrahman786
Messages: 52
Registered: December 2009
Location: Hyderabad,India
Member
Its a hot backup situation.
Previous Topic: flash recovery area
Next Topic: Backups are not created in FRA
Goto Forum:
  


Current Time: Thu Mar 28 14:13:58 CDT 2024