oracle恢复案例：rename一个数据文件后做不完全恢复 - 数据库编程

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>

oracle恢复案例：rename一个数据文件后做不完全恢复(二)