oracle 恢复完全删除的控制文件

执行下面的语句

STARTUP NOMOUNT
CREATE CONTROLFILE REUSE DATABASE "orcl" RESETLOGS ARCHIVELOG
-- SET STANDBY TO MAXIMIZE PERFORMANCE
MAXLOGFILES 5
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 1
MAXLOGHISTORY 226
LOGFILE
GROUP 1 '/data/oracle/oradata/orcl/redo01.log' SIZE 10M,
GROUP 2 '/data/oracle/oradata/orcl/redo02.log' SIZE 10M,
GROUP 3 '/data/oracle/oradata/orcl/redo03.log' SIZE 10M
-- STANDBY LOGFILE
DATAFILE
'/data/oracle/oradata/orcl/system01.dbf',
'/data/oracle/oradata/orcl/undotbs01.dbf',
'/data/oracle/oradata/orcl/users01.dbf'
CHARACTER SET US7ASCII;

启动到mount 状态

Control file created.

SQL> select status from v$instance;

STATUS
------------
MOUNTED

SQL> alter database open resetlogs;