Thursday 13 June 2013


Database Recovery using Logfile without taking backup

SQL> startup
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