controlfile 丢失恢复

1 从现有的控制文件恢复（unmount状态时恢复）

1.1 rman target /

1.2 restore controlfile from '/u01/app/oracle/oradata/db01/control01.ctl';

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

Starting restore at 08-JUN-13
using channel ORA_DISK_1

channel ORA_DISK_1: copied control file copy
output file name=/u01/app/oracle/oradata/db01/control01.ctl
output file name=/u01/app/oracle/flash_recovery_area/db01/control02.ctl
output file name=/u01/app/oracle/oradata/db01/control03.ctl
Finished restore at 08-JUN-13
---------------------------------------------------------------------------------------------------
2 拷贝现有的文件(关闭数据库时拷贝)

2.1 shutdown abort

2.2 cp /u01/app/oracle/oradata/db01/control01.ctl /u01/app/oracle/oradata/db01/control03.ctl

2.3 startup