重建控制文件

没有备份恢复控制文件，只能启动库到nomount状态，然后create control创建一个新的控制文件。

dba必须知道4个信息才能正确的创建：数据库名、在线日志路径及其大小、在线的可读/写数据文件路径、数据库字符集。

SQL>STARTUP NOMOUNT
SQL>CREATE CONTROLFILE REUSE DATABASE “ORCL” NORESETLOGS ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 292
LOGFILE
GROUP 1 ‘/u01/app/oracle/oradata/orcl/redo01.log’ SIZE 50M BLOCKSIZE 512,
GROUP 2 ‘/u01/app/oracle/oradata/orcl/redo02.log’ SIZE 50M BLOCKSIZE 512,
GROUP 3 ‘/u01/app/oracle/oradata/orcl/redo03.log’ SIZE 50M BLOCKSIZE 512
– STANDBY LOGFILE
DATAFILE
‘/u01/app/oracle/oradata/orcl/system01.dbf’,
‘/u01/app/oracle/oradata/orcl/sysaux01.dbf’,
‘/u01/app/oracle/oradata/orcl/undotbs01.dbf’,
‘/u01/app/oracle/oradata/orcl/users01.dbf’,
‘/u01/app/oracle/oradata/orcl/test01.dbf’
CHARACTER SET AL32UTF8
;

SQL> recover database;
SQL> alter database open;
SQL> select * from v$tempfile;
##添加临时表空间
SQL> ALTER TABLESPACE TEMP ADD TEMPFILE ‘/u01/app/oracle/oradata/orcl/temp01.dbf’ SIZE 61865984 REUSE AUTOEXTEND ON NEXT 655360 MAXSIZE 32767M;