Home » RDBMS Server » Backup & Recovery » Recovering database from archive log files (Oracle 10g, HPUX)
Recovering database from archive log files [message #311658] Sat, 05 April 2008 09:29 Go to next message
MELAKU
Messages: 32
Registered: April 2007
Location: ETHIOPIA
Member
Hi Experts,

I have taken cold back from my production databse and restore it on my test database server. The databse starts up properly and correctly. Now later, I copied the archived log file of the production server to my test server. I put these copied archive log files on the direct path of my test server where I define the log_archive_dest_1 on init file of the test database. Now, I was trying to use RESTORE DATABASE and RECOVER DATABASE to start the database from these copied archive files. It seems the command working, but when I ceck the records, they are all records found on the cold back up. The archive log file transactions are not included. I need your help as to how I can open this test database from the copied archive log files?

Thank you
Melaku K.
Re: Recovering database from archive log files [message #311659 is a reply to message #311658] Sat, 05 April 2008 09:35 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
There is a NOTE on Metalink that enumerates the steps.
I am aware of at least 2 different way to have Oracle apply the redo logfiles.
Re: Recovering database from archive log files [message #311662 is a reply to message #311659] Sat, 05 April 2008 10:20 Go to previous messageGo to next message
MELAKU
Messages: 32
Registered: April 2007
Location: ETHIOPIA
Member
Can you write for me the link please. I need it badly

Melaku K.
Re: Recovering database from archive log files [message #311664 is a reply to message #311662] Sat, 05 April 2008 10:44 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
If you restored your cold backup on the "new" server and started the "new" database up, then you can't go back now and try to apply archive logs from the primary to the "new" server's database.
Re: Recovering database from archive log files [message #311668 is a reply to message #311658] Sat, 05 April 2008 10:57 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Subject:  Recovery Roll Forward Archivelog Using Backup Controlfile 
  Doc ID:  Note:69468.1 Type:  BULLETIN 
  Last Revision Date:  03-DEC-2007 Status:  PUBLISHED 

This test scenario demonstrates how to apply archivelog files to a clean but old backup.


I am amazed at how many folks can't/won't/don't use SEARCH functions on the InterNet!

[Updated on: Sat, 05 April 2008 10:58] by Moderator

Report message to a moderator

Re: Recovering database from archive log files [message #311669 is a reply to message #311668] Sat, 05 April 2008 10:58 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Yes, but the OP said he started up the "new" database already.
Re: Recovering database from archive log files [message #311670 is a reply to message #311669] Sat, 05 April 2008 10:59 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
ebrian wrote on Sat, 05 April 2008 08:58
Yes, but the OP said he started up the "new" database already.

Yes, but OP can restore again, again from cold back & apply redos.
Re: Recovering database from archive log files [message #311671 is a reply to message #311670] Sat, 05 April 2008 11:02 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
But the SCN's would be out of sync.
Re: Recovering database from archive log files [message #311672 is a reply to message #311671] Sat, 05 April 2008 11:08 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
ebrian wrote on Sat, 05 April 2008 09:02
But the SCN's would be out of sync.


I agree that the archived redo can NOT be applied after the DB has been fully opened (SQL> STARTUP).

If OP restores again, again, again from cold backup & follows steps in NOTE above,
then subsequent archived redo logfiles can be applied to "roll forward" the database instance & essentially do a Point In Time Recovery.

[Updated on: Sat, 05 April 2008 11:08] by Moderator

Report message to a moderator

Re: Recovering database from archive log files [message #311673 is a reply to message #311672] Sat, 05 April 2008 11:10 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Absolutely, and as you mentioned, the doc you referenced above should walk the OP right through the process.
Re: Recovering database from archive log files [message #311674 is a reply to message #311658] Sat, 05 April 2008 11:12 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
I'd be curious to what the OP means by the following statement:
MELAKU wrote on Sat, 05 April 2008 10:29
Now, I was trying to use RESTORE DATABASE and RECOVER DATABASE to start the database from these copied archive files. It seems the command working, but when I ceck the records, they are all records found on the cold back up. The archive log file transactions are not included. I need your help as to how I can open this test database from the copied archive log files?

Previous Topic: rman is hanging
Next Topic: error RMAN ora-01031
Goto Forum:
  


Current Time: Mon Dec 02 08:40:15 CST 2024