sys@BKT> select name from v$datafile ;
NAME
----------------------------------------------------------------------------------------------------
/u02/oradat/bkt/system01.dbf
/u02/oradat/bkt/sysaux01.dbf
/u02/oradat/bkt/undotbs01.dbf
/u02/oradat/bkt/users01.dbf
/u02/oradat/bkt/example01.dbf
/u02/oradat/bkt/test1_01.dbf
/u01/apps/oracle/product/11gr2/db_1/dbs/UNNAMED00007
7 rows selected.
offline以下再恢复
sys@BKT> alter database datafile 7offline ;
Database altered.
sys@BKT> recover database using backupcontrolfile ;
ORA-00279: change 1293752 generated at05/13/2013 14:42:44 needed for thread 1
ORA-00289: suggestion :/u02/flash_recovery_area/BKT/archivelog/2013_05_13/o1_mf_1_93_8s2qoprf_.arc
ORA-00280: change 1293752 for thread 1 isin sequence #93
Specify log: {
auto
ORA-00283: recovery session canceled due toerrors
ORA-01244: unnamed datafile(s) added tocontrol file by media recovery
ORA-01110: data file 8: '/u02/oradat/bkt/tbs201.dbf'
ORA-01112: media recovery not started
这时候最后一个数据文件也加回来了
sys@BKT> select name from v$datafile ;
NAME
----------------------------------------------------------------------------------------------------
/u02/oradat/bkt/system01.dbf
/u02/oradat/bkt/sysaux01.dbf
/u02/oradat/bkt/undotbs01.dbf
/u02/oradat/bkt/users01.dbf
/u02/oradat/bkt/example01.dbf
/u02/oradat/bkt/test1_01.dbf
/u01/apps/oracle/product/11gr2/db_1/dbs/UNNAMED00007
/u01/apps/oracle/product/11gr2/db_1/dbs/UNNAMED00008
8 rows selected.
因为是表空间是readonly的，数据文件这里需要修改一下名称
sys@BKT> alter database rename file'/u01/apps/oracle/product/11gr2/db_1/dbs/UNNAMED00008' to'/u02/oradat/bkt/tbs201.dbf' ;
Database altered.
sys@BKT> alter database rename file'/u01/apps/oracle/product/11gr2/db_1/dbs/UNNAMED00007' to '/u02/oradat/bkt/tbs101.dbf';
Database altered.
sys@BKT> alter database datafile 7online ;
Database altered.
再次恢复
sys@BKT> recover database using backup controlfile ;
ORA-00279: change 1294029 generated at05/13/2013 14:42:58 needed for thread 1
ORA-00289: suggestion :/u02/flash_recovery_area/BKT/archivelog/2013_05_13/o1_mf_1_93_8s2qoprf_.arc
ORA-00280: change 1294029 for thread 1 isin sequence #93
Specify log: {
auto
ORA-00279: change 1294568 generated at05/13/2013 14:44:22 needed for thread 1
ORA-00289: suggestion :/u02/flash_recovery_area/BKT/archivelog/2013_05_13/o1_mf_1_94_8s2qoqjj_.arc
ORA-00280: change 1294568 for thread 1 isin sequence #94
ORA-00278: log file'/u02/flash_recovery_area/BKT/archivelog/2013_05_13/o1_mf_1_93_8s2qoprf_.arc'
no longer needed for this recovery
ORA-00279: change 1294571 generated at05/13/2013 14:44:22 needed for thread 1
ORA-00289: suggestion :/u02/flash_recovery_area/BKT/archivelog/2013_05_13/o1_mf_1_95_8s2qovq1_.arc
ORA-00280: change 1294571 for thread 1 isin sequence #95
ORA-00278: log file'/u02/flash_recovery_area/BKT/archivelog/2013_05_13/o1_mf_1_94_8s2qoqjj_.arc'
no longer needed for this recovery
ORA-00279: change 1294574 generated at05/13/2013 14:44:27 needed for thread 1
ORA-00289: suggestion :/u02/flash_recovery_area/BKT/archivelog/2013_05_13/o1_mf_1_96_8s2qovsh_.arc
ORA-00280: change 1294574 for thread 1 isin sequence #96
ORA-00278: lo