【若泽大数据】Oracle控制文件删除一个如何恢复，删除所有控制文件如何恢复

少了一个控制文件如何恢复

SQL> show parameter control;

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

control_file_record_keep_time integer 7

control_files string /u01/app/oracle/oradata/PROD/d

isk1/control01.ctl, /u01/app/o

racle/oradata/PROD/disk2/contr

ol01.ctl, /u01/app/oracle/orad

ata/PROD/disk3/control01.ctl

SQL> select name from v$controlfile;

NAME

--------------------------------------------------

/u01/app/oracle/oradata/PROD/disk1/control01.ctl

/u01/app/oracle/oradata/PROD/disk2/control01.ctl

/u01/app/oracle/oradata/PROD/disk3/control01.ctl

SQL> alter system set control_files='/u01/app/oracle/oradata/PROD/disk1/control01.ctl','/u01/app/oracle/oradata/PROD/disk2/control01.ctl','/u01/app/oracle/oradata/PROD/disk3/control01.ctl' scope=spfile...

2

SQL>

SQL> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup

ORACLE instance started.

Total System Global Area 419430400 bytes

Fixed Size 1219760 bytes

Variable Size 121635664 bytes

Database Buffers 293601280 bytes

Redo Buffers 2973696 bytes

Database mounted.

Database opened.

SQL> show parameter control;

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

control_file_record_keep_time integer 7

control_files string /u01/app/oracle/oradata/PROD/d

isk1/control01.ctl, /u01/app/o </