Database Recovery using Logfile without taking backup
ORACLE instance started.
Total System Global Area 1068937216 bytes
Fixed Size 2166536 bytes
Variable Size 457179384 bytes
Database Buffers 595591168 bytes
Redo Buffers 14000128 bytes
Database mounted.
ORA-01113: file 181 needs media recovery
ORA-01110: data file 181: '/sr12/d02/oracle/sr12/db/apps_st/data/tx_data51.dbf'
SQL> recover database using backup controlfile until cancel;
ORA-00279: change 10132238055147 generated at 06/13/2013 11:32:44 needed for
thread 1
ORA-00289: suggestion :
/sr12/d02/oracle/sr12/db/apps_st/data/archive/1_483_776833270.dbf
ORA-00280: change 10132238055147 for thread 1 is in sequence #483
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
auto
ORA-00308: cannot open archived log
'/sr12/d02/oracle/sr12/db/apps_st/data/archive/1_483_776833270.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-00308: cannot open archived log
'/sr12/d02/oracle/sr12/db/apps_st/data/archive/1_483_776833270.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
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: '/sr12/d02/oracle/sr12/db/apps_st/data/sys1.dbf'
SQL> recover database using backup controlfile until cancel;
ORA-00279: change 10132238055147 generated at 06/13/2013 11:32:44 needed for
thread 1
ORA-00289: suggestion :
/sr12/d02/oracle/sr12/db/apps_st/data/archive/1_483_776833270.dbf
ORA-00280: change 10132238055147 for thread 1 is in sequence #483
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
/sr12/d02/oracle/sr12/db/apps_st/data/log1.dbf
ORA-00279: change 10132238085255 generated at 06/13/2013 11:39:47 needed for
thread 1
ORA-00289: suggestion :
/sr12/d02/oracle/sr12/db/apps_st/data/archive/1_484_776833270.dbf
ORA-00280: change 10132238085255 for thread 1 is in sequence #484
ORA-00278: log file '/sr12/d02/oracle/sr12/db/apps_st/data/log1.dbf' no longer
needed for this recovery
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
/sr12/d02/oracle/sr12/db/apps_st/data/log2.dbf
ORA-00310: archived log contains sequence 482; sequence 484 required
ORA-00334: archived log: '/sr12/d02/oracle/sr12/db/apps_st/data/log2.dbf'
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: '/sr12/d02/oracle/sr12/db/apps_st/data/sys1.dbf'
SQL> recover database using backup controlfile until cancel;
ORA-00279: change 10132238085255 generated at 06/13/2013 11:39:47 needed for
thread 1
ORA-00289: suggestion :
/sr12/d02/oracle/sr12/db/apps_st/data/archive/1_484_776833270.dbf
ORA-00280: change 10132238085255 for thread 1 is in sequence #484
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
/sr12/d02/oracle/sr12/db/apps_st/data/log3.dbf
Log applied.
Media recovery complete.
SQL> alter database open resetlogs;
Database altered.
SQL>
No comments:
Post a Comment