Oracle Database Discussions

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!

recover database until time

562943Mar 12 2008 — edited Mar 13 2008

recover database until time using backup controlfile is not working it is taking current log file only
to recover upto perticular time what to do

i used recover database using backup controlfile until time 'time'

iam getting this msg

SQL> recover database using backup controlfile until time '28-Feb-2008 10:00:00'
ORA-00279: change 339559282 generated at 03/09/2008 12:23:01 needed for thread
1
ORA-00289: suggestion : F:\ORA9IAS\RDBMS\ARC01901.001
ORA-00280: change 339559282 for thread 1 is in sequence #1901

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
f:\ora9ias\oradata\iasdb\redo02.log
ORA-00310: archived log contains sequence 1899; sequence 1901 required
ORA-00334: archived log: 'F:\ORA9IAS\ORADATA\IASDB\REDO02.LOG'

ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: 'F:\ORA9IAS\ORADATA\IASDB\SYSTEM01.DBF'

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 10 2008

Added on Mar 12 2008

#general-database-discussions

12 comments

44,067 views