Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Success on RESTORE but failed on RECOVER-- need help

975524Nov 21 2012 — edited Nov 24 2012
I 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;
This post has been answered by Hemant K Chitale on Nov 22 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 22 2012
Added on Nov 21 2012
30 comments
4,591 views