恢復案例：無歸檔，掉電，控制檔案全部丟失恢復

1、檢視測試表資料：
SQL> select * from t;

         A
----------
         1
         2
         4
         3
         5
         6

6 rows selected.

[@more@]

SQL> insert into t values(7);

1 row created.

SQL> commit;

Commit complete.
2、模擬例項掉電，控制檔案全部丟失：
SQL> shutdown abort
ORACLE instance shut down.
SQL> host net stop oracleservicexue
OracleServiceXUE 服務正在停止...
OracleServiceXUE 服務已成功停止。

SQL> host del d:oracleoradataxue*.ctl

SQL> host net start oracleservicexue
OracleServiceXUE 服務正在啟動 .....
OracleServiceXUE 服務已經啟動成功。

3、啟動，報錯：
SQL> conn/as sysdba
Connected to an idle instance.
SQL> startup
ORACLE instance started.

Total System Global Area   64035360 bytes
Fixed Size                   453152 bytes
Variable Size              41943040 bytes
Database Buffers           20971520 bytes
Redo Buffers                 667648 bytes
ORA-00205: error in identifying controlfile, check alert log for more info
4、重建控制檔案並進行恢復：
SQL> create controlfile reuse database XUE noresetlogs noarchivelog
  2  logfile
  3  group 1 'd:oracleoradataxueredo01.log',
  4  group 2 'd:oracleoradataxueredo02.log'
  5  datafile
  6  'd:oracleoradataxuesystem01.dbf',
  7  'd:oracleoradataxueundotbs01.dbf',
  8  'd:oracleoradataxueusers01.dbf',
  9  'd:oracleoradataxuetools01.dbf',
 10  'd:oracleoradataxueindx01.dbf'
 11  character set zhs16gbk;

Control file created.

SQL> recover database;
Media recovery complete.
5、開啟資料庫，驗證恢復成功：
SQL> alter database open;

Database altered.

SQL> select * from t;

         A
----------
         1
         2
         4
         3
         5
         6
         7

7 rows selected.