CREATE CONTROLFILE REUSE DATABASE "DB" NORESETLOGS FORCE LOGGING ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 292
LOGFILE
GROUP 1 (
'/u01/app/oracle/oradata/DB/onlinelog/o1_mf_1_8vpmdkl9_.log',
'/u01/app/oracle/flash_recovery_area/DB/onlinelog/o1_mf_1_8vpmdryt_.log'
) SIZE 512M BLOCKSIZE 512,
GROUP 2 (
'/u01/app/oracle/oradata/DB/onlinelog/o1_mf_2_8vpmfqmw_.log',
'/u01/app/oracle/flash_recovery_area/DB/onlinelog/o1_mf_2_8vpmhk2z_.log'
) SIZE 512M BLOCKSIZE 512,
GROUP 3 (
'/u01/app/oracle/oradata/DB/onlinelog/o1_mf_3_8vpmjgoq_.log',
'/u01/app/oracle/flash_recovery_area/DB/onlinelog/o1_mf_3_8vpmkm9x_.log'
) SIZE 512M BLOCKSIZE 512
--STANDBY LOGFILE
-- GROUP 4 (
-- '/u01/app/oracle/oradata/DB1/onlinelog/o1_mf_4_8vpq6nvy_.log',
-- '/u01/app/oracle/flash_recovery_area/DB1/onlinelog/o1_mf_4_8vpq7wk8_.log'
-- ) SIZE 512M BLOCKSIZE 512,
-- GROUP 5 (
-- '/u01/app/oracle/oradata/DB1/onlinelog/o1_mf_5_8vpqbh6s_.log',
-- '/u01/app/oracle/flash_recovery_area/DB1/onlinelog/o1_mf_5_8vpqcmbj_.log'
-- ) SIZE 512M BLOCKSIZE 512,
-- GROUP 6 (
-- '/u01/app/oracle/oradata/DB1/onlinelog/o1_mf_6_8vpqf3rz_.log',
-- '/u01/app/oracle/flash_recovery_area/DB1/onlinelog/o1_mf_6_8vpqfv5w_.log'
-- ) SIZE 512M BLOCKSIZE 512,
-- GROUP 7 (
-- '/u01/app/oracle/oradata/DB1/onlinelog/o1_mf_7_8vpqgw0j_.log',
-- '/u01/app/oracle/flash_recovery_area/DB1/onlinelog/o1_mf_7_8vpqhcql_.log'
-- ) SIZE 512M BLOCKSIZE 512
DATAFILE
'/u01/app/oracle/oradata/DB/datafile/o1_mf_system_8vpm8hf3_.dbf',
'/u01/app/oracle/oradata/DB/datafile/o1_mf_sysaux_8vpm8hjq_.dbf',
'/u01/app/oracle/oradata/DB/datafile/o1_mf_undotbs1_8vpm8hl4_.dbf',
'/u01/app/oracle/oradata/DB/datafile/o1_mf_users_8vpm8hn1_.dbf'
CHARACTER SET ZHS16GBK;
SQL> shutdown immediate
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> startup nomount
ORACLE instance started.
Total System Global Area 1.3362E+10 bytes
Fixed Size 2217952 bytes
Variable Size 6777997344 bytes
Database Buffers 6576668672 bytes
Redo Buffers 4960256 bytes
SQL> @/tmp/1.ctl;
Control file created.
5：重建控制文件后，对数据库进行recover，成功打开数据库
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1:
'/u01/app/oracle/oradata/DB/datafile/o1_mf_system_8vpm8hf3_.dbf'
SQL> recover database;
Media recovery complete.
SQL> alter database open;
Database altered.
SQL> select open_mode,database_role from v$database;
OPEN_MODE DATABASE_ROLE
-------------------- ----------------
READ WRITE PRIMARY
6：通过观察alert日志，添加临时表空间数据文件
[oracle@db1 ~]$ tail -f alert_db.log
Errors in file /u01/app/oracle/diag/rdbms/db1/db/trace/db_m001_381.trc:
ORA-25153: Temporary Tablespace is Empty
Mon Jun 17 17:17:25 2013
Errors in file /u01/app/oracle/diag/rdbms/db1/db/trace/db_j007_400.trc:
ORA-25153: Temporary Tablespace is Empty
Errors in file /u01/app/oracle/diag/rdbms/db1/db/trace/db_j007_400.trc:
ORA-12012: error on auto execute of job 12696
ORA-25153: Temporary Tablespace is Empty
ORA-06512: at "DBSNMP.BSLN_INTERNAL", line 2073
ORA-06512: at line 1
Mon Jun 17 17:18:20 2013
alter tablespace temp add tempfile
Completed: alter table