ALTER TABLESPACETEMP1 ADD TEMPFILE '/u01/app/oracle/oradata/PROD/disk1/temp1_01_grp.dbf'
SIZE 20971520 REUSE AUTOEXTEND ON NEXT 8192 MAXSIZE 32767M;
ALTER TABLESPACETEMP2 ADD TEMPFILE '/u01/app/oracle/oradata/PROD/disk1/temp2_01_grp.dbf'
SIZE 20971520 REUSE AUTOEXTEND ON NEXT 8192 MAXSIZE 32767M;
-- End oftempfile additions.
--
*** 2014-03-1520:18:32.065
*** 2014-03-1520:18:32.065 60679 kcrr.c
ARCH: Archivaldisabled due to shutdown: 1089
*** 2014-03-1520:18:32.082 60679 kcrr.c
ARCH: Archivaldisabled due to shutdown: 1089
4、编辑这个trace文件,我们就可以获得创建控制文件的脚本.
根据数据库不同状况，你可以选择是使用RESETLOGS/NORESETLOGS来重建控制文件
我们获得以下脚本:
[oracle@standby tools]$ cat createctlf.sql
STARTUP NOMOUNT
CREATECONTROLFILE REUSE DATABASE "PROD" NORESETLOGS ARCHIVELOG
MAXLOGFILES 30
MAXLOGMEMBERS 4
MAXDATAFILES 100
MAXINSTANCES 1
MAXLOGHISTORY 292
LOGFILE
GROUP 1 (
'/u01/app/oracle/oradata/PROD/disk1/redo01.log',
'/u01/app/oracle/oradata/PROD/disk2/redo01_b.log'
) SIZE 100M,
GROUP 2 (
'/u01/app/oracle/oradata/PROD/disk1/redo02.log',
'/u01/app/oracle/oradata/PROD/disk2/redo02_b.log'
) SIZE 100M,
GROUP 3 (
'/u01/app/oracle/oradata/PROD/disk1/redo03.log',
'/u01/app/oracle/oradata/PROD/disk2/redo03_b.log'
) SIZE 100M,
GROUP 4 (
'/u01/app/oracle/oradata/PROD/disk1/redo04_a.log',
'/u01/app/oracle/oradata/PROD/disk2/redo04_b.log'
) SIZE 100M
-- STANDBYLOGFILE
DATAFILE
'/u01/app/oracle/oradata/PROD/disk1/system01.dbf',
'/u01/app/oracle/oradata/PROD/disk1/undotbs01.dbf',
'/u01/app/oracle/oradata/PROD/disk1/sysaux01.dbf',
'/u01/app/oracle/oradata/PROD/disk1/EXAMPLE_01.dbf',
'/u01/app/oracle/oradata/PROD/disk3/USERS_01.dbf',
'/u01/app/oracle/oradata/PROD/disk5/dds_01.dbf'
CHARACTER SET US7ASCII;
RECOVERDATABASE;
ALTER SYSTEMARCHIVE LOG ALL;
ALTER DATABASEOPEN;
ALTER TABLESPACETEMP01 ADD TEMPFILE '/u01/app/oracle/oradata/PROD/disk1/temp01.dbf'
SIZE 20971520 REUSE AUTOEXTEND ON NEXT 8192 MAXSIZE 32767M;
ALTER TABLESPACETEMP1 ADD TEMPFILE '/u01/app/oracle/oradata/PROD/disk1/temp1_01_grp.dbf'
SIZE 20971520 REUSE AUTOEXTEND ON NEXT 8192 MAXSIZE 32767M;
ALTER TABLESPACETEMP2 ADD TEMPFILE '/u01/app/oracle/oradata/PROD/disk1/temp2_01_grp.dbf'
SIZE 20971520 REUSE AUTOEXTEND ON NEXT 8192 MAXSIZE 32767M;
5、运行此脚本即可重建控制文件:
SYS@PROD>startupnomount;
ORACLE instancestarted.
Total SystemGlobal Area 419430400 bytes
Fixed Size 1219784 bytes
VariableSize 121635640 bytes
DatabaseBuffers 293601280 bytes
RedoBuffers 2973696 bytes
SYS@PROD>CREATECONTROLFILE REUSE DATABASE "PROD" NORESETLOGS ARCHIVELOG
MAXLOGFILES 30
MAXLOGMEMBERS 4
MAXDATAFILES 100
MAXINSTANCES 1
MAXLOGHISTORY 292
LOGFILE
GROUP 1 (
'/u01/app/oracle/oradata/PROD/disk1/redo01.log',
'/u01/app/oracle/oradata/PROD/disk2/redo01_b.log'
) SIZE 100M,
GROUP 2 (
'/u01/app/oracle/oradata/PROD/disk1/redo02.log',
'/u01/app/oracle/oradata/PROD/disk2/redo02_b.log'
) SIZE 100M,
GROUP 3 (
'/u01/app/oracle/oradata/PROD/disk1/redo03.log',
'/u01/app/oracle/oradata/PROD/disk2/redo03_b.log'
) SIZE 100M,
GROUP 4 (
'/u01/app/oracle/oradata/PROD/disk1/redo04_a.log',
'/u01/app/oracle/oradata/PROD/disk2/redo04_b.log'
) SIZE 100M
-- STANDBYLOGFILE
DATAFILE
'/u01/app/oracle/oradata/PROD/disk1/system01.dbf',
'/u01/ap