| Recovering database from archive log files [message #311658] |
Sat, 05 April 2008 09:29  |
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 #311668 is a reply to message #311658] |
Sat, 05 April 2008 10:57  |
 |
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 #311672 is a reply to message #311671] |
Sat, 05 April 2008 11:08 |
|
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 #311674 is a reply to message #311658] |
Sat, 05 April 2008 11:12 |
 |
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?
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
