Database Backup and Recovery (MOSC)

MOSC Banner

recovery issue in nonarchieve log mode database

edited Jan 27, 2010 12:20AM in Database Backup and Recovery (MOSC) 15 commentsAnswered
 Hi,
I am getting following erorr during recovery from my database server

I have build the control file from trace file.I have restore all the dbf files
from the backup and start the database in nomount state.Created the contril files.

recover database using backup controlfile until cancel;

ORA-00279: change 9794388996521 generated at 12/04/2009 07:13:42 needed for
thread 1
ORA-00289: suggestion : /apps/oracle/admin/XGVOLTST/arch/arch1_57500.arc
ORA-00280: change 9794388996521 for thread 1 is in sequence #57500


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

ORA-00308: cannot open archived log
'/apps/oracle/admin/XGVOLTST/arch/arch1_57500.arc'
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory

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