LOSS OF A CONTROL FILE

默认设了镜像，数据库关了，把镜像拷过来即可。

RMAN>restore controlfile from '/bakup/controlfile.bak'

Loss of Individual controlfile

SQL>start up;

ORA-00205:error in identify control file

SQL>! cp /u01......

SQL>alter database mount;

SQL>alter database open;

Loss of all control file:

SQL>start up;

ORA-00205:error in identify control file;

SQL>host ls  -lt /u01/app/oracle/diag/rdbms/ora11/trace/*.trc

SQL>create controlfile database ora11 noresetlogs

2 logfile

3 group 1 '/u01/app/oracle/oradata/ora11/redo01.log',

4 group 2  '/u01/app/oracle/oradata/ora11/redo02.log',

5 datafile

6 '/u01/app/oracle/oradata/ora11/system01.dbf',

7 '/u01/app/oracle/oradata/ora11/undotbs01.dbf',

8'/u01/app/oracle/oradata/ora11/sysaux01,dbf',

9 '/u01/app/oracle/oradata/ora11/users01.dbf',

10  '/u01/app/oracle/oradata/ora11/example01.dbf'

11 character set zhs16gbk;

SQL>alter database open;