alter database create datafile

本实验是在备份了控制文件后新创建了一个表空间STRU,然后删除了所有控制文件，用备份的控制文件代替后的恢复过程
在resetlogs打开数据库时报下面错误
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: 'C:\APP\ADMINISTRATOR\ORADATA\ORCL\SYSTEM01.DBF'


SQL> select name from v$datafile;   


NAME
--------------------------------------------------------------------------------
C:\APP\ADMINISTRATOR\ORADATA\ORCL\SYSTEM01.DBF
C:\APP\ADMINISTRATOR\ORADATA\ORCL\SYSAUX01.DBF
C:\APP\ADMINISTRATOR\ORADATA\ORCL\UNDOTBS01.DBF
C:\APP\ADMINISTRATOR\ORADATA\ORCL\USERS01.DBF
C:\APP\ADMINISTRATOR\ORADATA\ORCL\EXAMPLE01.DBF
C:\APP\ADMINISTRATOR\ORADATA\ORCL\EPORT_TAB_S01.DBF
C:\APP\ADMINISTRATOR\ORADATA\ORCL\TS16K.DBF
C:\APP\ADMINISTRATOR\ORADATA\ORCL\TS01.DBF
C:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\DATABASE\UNNAMED00009


9 rows selected.




SQL> alter database create datafile 'C:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\DATABASE\UNNAMED00009' as 'C:\APP\ADMINISTRATOR\ORADATA\ORCL\STRU.DBF';


Database altered.


SQL> recover database using backup controlfile;
ORA-00279: change 2413396 generated at 01/05/2018 09:10:32 needed for thread 1
ORA-00289: suggestion :
C:\APP\ADMINISTRATOR\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2018_01_05\O1_MF_1_61_%
U_.ARC
ORA-00280: change 2413396 for thread 1 is in sequence #61




Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
C:\app\Administrator\oradata\orcl\REDO01.LOG
Log applied.
Media recovery complete.
SQL> ALTER DATABASE OPEN RESETLOGS;


Database altered.


SQL> select *
  2  from t1;


A
----------
11
12
13




SQL> select file_name
  2  from dba_data_files;


FILE_NAME
--------------------------------------------------------------------------------
C:\APP\ADMINISTRATOR\ORADATA\ORCL\USERS01.DBF
C:\APP\ADMINISTRATOR\ORADATA\ORCL\UNDOTBS01.DBF
C:\APP\ADMINISTRATOR\ORADATA\ORCL\SYSAUX01.DBF
C:\APP\ADMINISTRATOR\ORADATA\ORCL\SYSTEM01.DBF
C:\APP\ADMINISTRATOR\ORADATA\ORCL\EXAMPLE01.DBF
C:\APP\ADMINISTRATOR\ORADATA\ORCL\EPORT_TAB_S01.DBF
C:\APP\ADMINISTRATOR\ORADATA\ORCL\TS16K.DBF
C:\APP\ADMINISTRATOR\ORADATA\ORCL\TS01.DBF
C:\APP\ADMINISTRATOR\ORADATA\ORCL\STRU.DBF


9 rows selected.


SQL> select *
  2  from v$log;


    GROUP#    THREAD#  SEQUENCE#      BYTES  BLOCKSIZE    MEMBERS ARC
---------- ---------- ---------- ---------- ---------- ---------- ---
STATUS           FIRST_CHANGE# FIRST_TIME   NEXT_CHANGE# NEXT_TIME
---------------- ------------- ------------ ------------ ------------
         1          1          1   52428800        512          1 NO
CURRENT                2414015 05-JAN-18      2.8147E+14


         2          1          0   52428800        512          1 YES
UNUSED                       0                         0


         3          1          0   52428800        512          1 YES
UNUSED                       0                         0




SQL>  

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26870952/viewspace-2149728/，如需转载，请注明出处，否则将追究法律责任。