系统环境：
操作系统： Linux RH6
案例分析：
Oracle数据库中所有的控制文件被意外破坏，非归档的库，在有trace备份的情况下，重建控制文件。
1、控制文件trace脚本
[oracle@rh6 ~]$ cat crctr.sql
CREATE CONTROLFILE REUSE DATABASE "TEST3" NORESETLOGS? NOARCHIVELOG
? ? MAXLOGFILES 10
? ? MAXLOGMEMBERS 5
? ? MAXDATAFILES 300
? ? MAXINSTANCES 1
? ? MAXLOGHISTORY 292
LOGFILE
? GROUP 1 '/u01/app/oracle/oradata/test3/redo01a.log'? SIZE 100M BLOCKSIZE 512,
? GROUP 2 '/u01/app/oracle/oradata/test3/redo02a.log'? SIZE 100M BLOCKSIZE 512
-- STANDBY LOGFILE
DATAFILE
? '/u01/app/oracle/oradata/test3/system01.dbf',
? '/u01/app/oracle/oradata/test3/sysaux01.dbf',
? '/u01/app/oracle/oradata/test3/undotbs01.dbf',
? '/u01/app/oracle/oradata/test3/users01.dbf'
CHARACTER SET ZHS16GBK；
2、启动Instance到nomount，重建controlfile
10:59:05 SYS@ test3 >startup nomount;
ORACLE instance started.
Total System Global Area? 313860096 bytes
Fixed Size? ? ? ? ? ? ? ? ? 1336232 bytes
Variable Size? ? ? ? ? ? 213912664 bytes
Database Buffers? ? ? ? ? 92274688 bytes
Redo Buffers? ? ? ? ? ? ? ? 6336512 bytes
?
10:59:41 SYS@ test3 >@/home/oracle/crctr.sql
Control file created.
3、告警日志
......
CREATE CONTROLFILE REUSE DATABASE "TEST3" NORESETLOGS? NOARCHIVELOG
? ? MAXLOGFILES 10
? ? MAXLOGMEMBERS 5
? ? MAXDATAFILES 300
? ? MAXINSTANCES 1
? ? MAXLOGHISTORY 292
LOGFILE
? GROUP 1 '/u01/app/oracle/oradata/test3/redo01a.log'? SIZE 100M BLOCKSIZE 512,
? GROUP 2 '/u01/app/oracle/oradata/test3/redo02a.log'? SIZE 100M BLOCKSIZE 512
-- STANDBY LOGFILE
DATAFILE
? '/u01/app/oracle/oradata/test3/system01.dbf',
? '/u01/app/oracle/oradata/test3/sysaux01.dbf',
? '/u01/app/oracle/oradata/test3/undotbs01.dbf',
? '/u01/app/oracle/oradata/test3/users01.dbf'
CHARACTER SET ZHS16GBK
WARNING: Default Temporary Tablespace not specified in CREATE DATABASE command
Default Temporary Tablespace will be necessary for a locally managed database in future release
Wed Jan 07 11:00:02 2015
Successful mount of redo thread 1, with mount id 991126251
?
Completed: CREATE CONTROLFILE REUSE DATABASE "TEST3" NORESETLOGS? NOARCHIVELOG
? ? MAXLOGFILES 10
? ? MAXLOGMEMBERS 5
? ? MAXDATAFILES 300
? ? MAXINSTANCES 1
? ? MAXLOGHISTORY 292
LOGFILE
? GROUP 1 '/u01/app/oracle/oradata/test3/redo01a.log'? SIZE 100M BLOCKSIZE 512,
? GROUP 2 '/u01/app/oracle/oradata/test3/redo02a.log'? SIZE 100M BLOCKSIZE 512
-- STANDBY LOGFILE
DATAFILE
? '/u01/app/oracle/oradata/test3/system01.dbf',
? '/u01/app/oracle/oradata/test3/sysaux01.dbf',
? '/u01/app/oracle/oradata/test3/undotbs01.dbf',
? '/u01/app/oracle/oradata/test3/users01.dbf'
CHARACTER SET ZHS16GBK
Wed Jan 07 11:00:59 2015
......
3、查看数据库状态
11:00:03 SYS@ test3 >select status from v$instance;
STATUS
------------
MOUNTED
?
11:00:27 SYS@ test3 >select file#,name ,checkpoint_change# from v$datafile;
? ? FILE# NAME? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? CHECKPOINT_CHANGE#
---------- -------------------------------------------------- ------------------
? ? ? ? 1 /u01/app/oracle/oradata/test3/system01.dbf? ? ? ? ? ? ? ? ? ? 333365
? ? ? ? 2 /u01/app/oracle/oradata/test3/sysaux01.dbf? ? ? ? ? ? ? ? ? ? 333365
? ? ? ? 3 /u01/app/oracle/oradata/test3/undotbs01.dbf? ? ? ? ? ? ? ? ? ? 333365
? ? ? ? 4 /u01/app/oracle/oradata/test3/users01.dbf? ? ? ? ? ? ? ? ? ? ? 333365
?
11:00:46 SYS@ test3 >select file#,name ,checkpoint_change# from v$datafile_header;
? ? FILE# NAME? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? CHECKPOINT_CHANGE#
---------- -------------------------------------------------- ------------------
? ? ? ? 1 /u01/ap