-
standby database recovery error
Hi
I am getting the following error while using the following command.
our standby database was not operational for the last 2 months for some issues, but I am starting it now after copying all from the primary server.
all the arcive files are moved out of the ARCHIVE folder and I have only this month's archive files in the folder.
I need to start this in readonly mode and show them that the standby is working.
How do I recover to date and start it? could some body give me any clue!!!
-----------------------------------------------------
SQL> recover standby database;
ORA-00279: change 7524911449 generated at 04/24/2007 18:13:58 needed for thread
1
ORA-00289: suggestion : G:\ARCHIVE\ARC51607_0557592862.001
ORA-00280: change 7524911449 for thread 1 is in sequence #251607
ORA-00308: cannot open archived log 'G:\ARCHIVE\ARC51607_0557592862.001'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01195: online backup of file 1 needs more recovery to be consistent
ORA-01110: data file 1: 'E:\ORACLE\ORADATA\SYSTEM01.DBF'
---------------------------------------------------------------
Thanks in advance
BSR
-
It looks like there is an archivelog gap and those archive logs are missing. ( see Oracle is looking for a file created on ORA-00279: change 7524911449 generated at 04/24/2007 ). Check this archivelog availability, and if not existing, re-create the Standby DB back again.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|