Recovery To Another Database

[kwil38]

I'm testing my backup and recovery strategy and am stuck on the following scenerio -

The production server crashes and I have to recover a database named 'prod' onto another server and a database called 'test'.

I have successfully recovered from the last cold backup by restoring the datafiles to the test server, tweaking the parameters in init.ora to refer to 'test' instead of 'prod', and creating a new controlfile for the 'test' database. I open the database with the resetlogs option.

Now to the problem - I want to apply archive logs to the database to bring it up to date. However since I opened the database with the resetlogs option (which has to be done when creating a new controlfile), recovery wants the logfile beginning with sequence #1 and the logfile I have begins with sequence #1841.

How can I apply these archive logs? Or am I going about the whole recovery process wrong?

Any help would be greatly appreciated!

Thanks,
Kent

 

[markrem]

Do not open the database until after you have rolled forward. Try this:
startup nomount
create the new control file
alter database mount
set autorecovery on
recover database until cancel
alter database open reset logs using backup controlfile.

MarkRem
Author, Oracle Database 10g: From Nuts to Soup

http://www.remidata.com/book_nuts2soup.htm

 

[kwil38]

Worked perfectly! Thanks a lot!