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>