Database Backup and Recovery (MOSC)

MOSC Banner

how to open db if recover is not successful?

edited Oct 23, 2009 9:32AM in Database Backup and Recovery (MOSC) 6 commentsAnswered
 i do backup and recover in our db ,

but unfortunately recover is not succesful,

SQL> RECOVER DATABASE USING BACKUP CONTROLFILE
ORA-00279: change 6379 generated at 10/22/2009 18:23:13 needed for thread 1
ORA-00289: suggestion : /opt/oracle/product/9.2/dbs/arch1_1.dbf
ORA-00280: change 6379 for thread 1 is in sequence #1


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

ORA-00308: cannot open archived log '/opt/oracle/product/9.2/dbs/arch1_1.dbf'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3

we want to save data in db, so i just want to open db temporary,exp our app data.

can oracle have any impliedly parameter to ignore the db file header consistently check ,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center