| Standby Databse Error. PLEASE HELP !!!! [message #52545] |
Mon, 29 July 2002 09:30  |
Sarosh
Messages: 2
Registered: July 2002
|
Junior Member |
|
|
I am attempting to create a standby database for the first time and following the oracle documentation closely but I am getting stuck at the one point and am unable to go ahead . Please help!
My problem is when I am applying the current logs after successfully mounting standby database as seen below:
SVRMGR> alter database mount standby database;
Statement processed.
SVRMGR> recover standby database ;
ORA-00279: change 2939586 generated at 07/28/2002 01:09:33 needed for thread 5718
ORA-00289: suggestion : C:ORACLEORADATASTANDBYARCHIVESTANDBYT571S00362.ARC
ORA-00280: change 2939586 for thread 5718 is in sequence #362
Specify log: {=suggested | filename | AUTO | CANCEL}
CANCEL
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: 'C:ORACLEORADATASTANDBYSYSTEM01.DBF'
SVRMGR>
Someone please help!!!
|
|
|
|
| Re: Standby Databse Error. PLEASE HELP !!!! [message #52547 is a reply to message #52545] |
Mon, 29 July 2002 10:17  |
Grant
Messages: 578
Registered: January 2002
|
Senior Member |
|
|
Why are you caneling it? Let it finish. Here is the error code:
01152, 00000, "file %s was not restored from a sufficiently old backup "
// *Cause: An incomplete recovery session was started, but an insufficient
// number of logs were applied to make the database consistent. This
// file is still in the future of the last log applied. The most
// likely cause of this error is forgetting to restore the file
// from a backup before doing incomplete recovery.
// *Action: Either apply more logs until the database is consistent or
// restore the database file from an older backup and repeat recovery.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
