Success on RESTORE but failed on RECOVER-- need help
975524Nov 21 2012 — edited Nov 24 2012I was able to execute "restore database" command and it went successfully.
But when I execute "recover database" it stops with error
RMAN-08187: WARNING: media recovery until SCN 1155620136 complete
archived log file name=/oracle/oradsk3/archivelogs/1_94646_700099109.dbf thread=1 sequence=94647
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 11/19/2012 05:55:32
ORA-00283: recovery session canceled due to errors
RMAN-11003: failure during parse/execution of SQL statement: alter database recover logfile '/oracle/oradsk3/archivelogs/1_94646_700099109.dbf'
ORA-00283: recovery session canceled due to errors
ORA-01112: media recovery not started
RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 94647 and starting SCN of 1155620136
Although i have this error I can successfully startup my database without a problem. But on our ERP application, it encounters errors such as below
Error : SQLState QP99P: database error 376 (error 1376) (rcdset.readkastset() in object ....
Fatal error : Error 1376 (database error 376) on select
What should I be rectifying to fix this?
By the way, im a newbie to oracle database. Hope somebody could help me on this.
Below are the commands i did:
commands:
1) rman --> enter
2) connect target / --> enter
3) delete expired backup; --> enter # this will delete all the expired backup set on the controlfile
4) catalog start with '/oracle/RMAN'; --> enter # this will catalog all files in directory
5) restore database preview; --> enter # this will test restore the backup sets on the database, no actual restoration, test only.
6) restore database validate;
7) restore archivelog all validate;
8) shutdown;
9) startup nomount;
10) mount database;
11) list incarnation;
12) reset database to incarnation 1; - chnage to the old incarnation.
13) restore database;
14) recover database;
15) Alter database open resetlogs;