OraFAQ Forum: Backup & Recovery » Need to reproduce live server backup on test machine

Home » RDBMS Server » Backup & Recovery » Need to reproduce live server backup on test machine (windows, oracle 8.1.7)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Need to reproduce live server backup on test machine [message #484966]

Sat, 04 December 2010 08:03

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,

Report message to a moderator

Re: Need to reproduce live server backup on test machine [message #484967 is a reply to message #484966]

Sat, 04 December 2010 08:09

Mahesh Rajendran
Messages: 10708
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

Report message to a moderator

Re: Need to reproduce live server backup on test machine [message #484969 is a reply to message #484967]

Sat, 04 December 2010 09:32

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,

Report message to a moderator

Re: Need to reproduce live server backup on test machine [message #484971 is a reply to message #484969]

Sat, 04 December 2010 09:47

Mahesh Rajendran
Messages: 10708
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.

Report message to a moderator

Re: Need to reproduce live server backup on test machine [message #484974 is a reply to message #484971]

Sat, 04 December 2010 10:53

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.

Report message to a moderator

Re: Need to reproduce live server backup on test machine [message #484975 is a reply to message #484974]

Sat, 04 December 2010 11:21

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

Report message to a moderator

Re: Need to reproduce live server backup on test machine [message #485156 is a reply to message #484975]

Mon, 06 December 2010 08:46

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.

Report message to a moderator

Re: Need to reproduce live server backup on test machine [message #485263 is a reply to message #485156]

Tue, 07 December 2010 01:53

ateeqrahman786
Messages: 52
Registered: December 2009
Location: Hyderabad,India

Member

Its a hot backup situation.

Report message to a moderator

Previous Topic:	flash recovery area
Next Topic:	Backups are not created in FRA

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Nov 24 19:00:05 CST 2024