HOW TO RECOVER DATABSE FROM ARCHIVE LOGS [message #311066] |
Thu, 03 April 2008 05:43 |
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.
|
|
|
|
|