Blogs › inforadar's blog

Oracle:Example of Media Recovery using online redo logs

Submitted by inforadar on Thu, 06/03/2010 - 22:47

 

oracle@myserver.dbalifeline.com>mydb>sqlplus “/as sysdba”

SQL*Plus: Release 10.2.0.3.0 - Production on Fri May 23 11:46:40 2008

Copyright (c) 1982, 2006, Oracle. All Rights Reserved.

Connected to an idle instance.

SQL> @cr_ctl2 
ORACLE instance started.

Total System Global Area 8556380160 bytes 
Fixed Size 2086416 bytes 
Variable Size 1358957040 bytes 
Database Buffers 7180648448 bytes 
Redo Buffers 14688256 bytes

Control file created.

SQL> alter database open; 
alter database open 
* 
ERROR at line 1: 
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

SQL> alter database open resetlogs; 
alter database open resetlogs 
* 
ERROR at line 1: 
ORA-01194: file 1 needs more recovery to be consistent 
ORA-01110: data file 1: ‘/backup/oracle/mydb/system.df01.dbf’

SQL> recover database; 
ORA-00283: recovery session canceled due to errors 
ORA-01610: recovery using the BACKUP CONTROLFILE option must be done

SQL> recover database using backup controlfile; 
ORA-00279: change 13305029569 generated at 05/23/2008 09:58:06 needed for 
thread 1 
ORA-00289: suggestion : 
/backup/oracle/mydb/admin/archive/log/arch_1_655465363_2.dbf 
ORA-00280: change 13305029569 for thread 1 is in sequence #2

Specify log: {<RET>=suggested | filename | AUTO | CANCEL} 
CANCEL 
Media recovery cancelled. 
SQL> alter database open; 
alter database open 
* 
ERROR at line 1: 
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

SQL> alter database open resetlogs; 
alter database open resetlogs 
* 
ERROR at line 1: 
ORA-01113: file 1 needs media recovery 
ORA-01110: data file 1: ‘/backup/oracle/mydb/system.df01.dbf’

SQL> recover database using backup controlfile; 
ORA-00279: change 13305029569 generated at 05/23/2008 09:58:06 needed for 
thread 1 
ORA-00289: suggestion : 
/backup/oracle/mydb/admin/archive/log/arch_1_655465363_2.dbf 
ORA-00280: change 13305029569 for thread 1 is in sequence #2

Specify log: {<RET>=suggested | filename | AUTO | CANCEL} 
/backup/oracle/mydb/redo11.log 
Log applied. 
Media recovery complete. 
SQL> alter database open resetlogs;

Database altered.

SQL>