ALTER TABLESPACE TEMP ADD TEMPFILE '/u01/oradata/practice/temp01.dbf' REUSE;
在sqlplus下执行创建控制文件脚本，数据库会启动到open状态并添加临时表空间文件。
SYS@practice >@create_controlfile.sql
Control file created.
PL/SQL procedure successfully completed.
Media recovery complete.
System altered.
Database altered.
Tablespace altered.
此时数据库已经处于read write状态也就是open状态了
SYS@practice >select open_mode from v$database;
OPEN_MODE
--------------------
READ WRITE
查看当前日志的序列号，没有被重置。
SYS@practice >select group#,sequence#,archived,status,first_change#,next_change# from v$log;
GROUP# SEQUENCE# ARC STATUS FIRST_CHANGE# NEXT_CHANGE#
---------- ---------- --- ---------------- ------------- ------------
1 4 YES INACTIVE 1030130 1050296
2 5 NO CURRENT 1050296 2.8147E+14
3 3 YES INACTIVE 1030117 1030130
查看临时表数据文件也被创建出来了。
SYS@practice >select name from v$tempfile;
NAME
--------------------------------------------------------------------------------
/u01/oradata/practice/temp01.dbf
7，重新识别控制文件的备份信息和配置信息
此时的控制文件中没有之前备份过控制文件的信息
RMAN> list backup of controlfile;
using target database control file instead of recovery catalog
specification does not match any backup in the repository
从闪回恢复区重新注册备份信息
RMAN> catalog db_recovery_file_dest;
从执行过数据库全备份的地址注册备份信息
RMAN> catalog start with '/home/oracle/';
再次列出备份过的控制文件，可以看到已经全部注册成功
RMAN> list backup of controlfile;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
1 Full 9.67M DISK 00:00:00 06-OCT-14
BP Key: 1 Status: AVAILABLE Compressed: NO Tag: TAG20141006T175610
Piece Name: /u01/fast_recovery_area/PRACTICE/autobackup/2014_10_06/o1_mf_s_860262970_b363zt2x_.bkp
Control File Included: Ckp SCN: 1051644 Ckp time: 06-OCT-14
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
3 Full 9.33M DISK 00:00:00 06-OCT-14
BP Key: 3 Status: AVAILABLE Compressed: NO Tag: TAG20141006T132827
Piece Name: /u01/fast_recovery_area/PRACTICE/backupset/2014_10_06/o1_mf_ncnnf_TAG20141006T132827_b35n9w39_.bkp
Control File Included: Ckp SCN: 1005439 Ckp time: 06-OCT-14
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
7 Full 9.33M DISK 00:00:00 06-OCT-14
BP Key: 7 Status: AVAILABLE Compressed: NO Tag: TAG20141006T143909
Piece Name: /home/oracle/full_PRACTICE_9_20141006_1.bak
Control File Included: Ckp SCN: 1013438 Ckp time: 06-OCT-14
本次实验到此结束。