redofile/redo01a.log
2
/disk1/metro/redofile/redo02a.log
3
/disk1/metro/redofile/redo03a.log
6 rows selected.
SQL> recover database using backup controlfile;
ORA-00279: change 861998 generated at 05/29/2014 15:02:17 needed for thread 1
ORA-00289: suggestion : /u01/app/oracle/arch1/1_15_848741495.dbf
ORA-00280: change 861998 for thread 1 is in sequence #15
Specify log: {=suggested | filename | AUTO | CANCEL}
/disk1/metro/redofile/redo02a.log //输入查找到sequence号为15对应的日志
Log applied.
Media recovery complete.
SQL> select checkpoint_change# from v$datafile_header; //恢复完成后检查点的SCN
CHECKPOINT_CHANGE#
------------------
863385
863385
863385
863385
863385
SQL> alter database open
2 ;
alter database open
*
ERROR at line 1:
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
SQL> alter database open resetlogs; //使用resetlogs打开库
Database altered.
SQL> select name from v$datafile //查看数据文件信息
2 ;
NAME
--------------------------------------------------------------------------------
+DATA/metro/datafile/system.257.848858337
/u01/app/oracle/oradata/metro/undotbs01.dbf
/u01/app/oracle/oradata/metro/sysaux01.dbf
/u01/app/oracle/oradata/metro/users01.dbf
/u01/app/oracle/oradata/metro/example01.dbf
SQL>
|