敗家貓

測試一下rman的增強的地方，發現還不錯，應該可以少一些電話幫助了
下面是我測試controlfile失去一個的情況

RMAN> list failure;

List of Database Failures
=========================

Failure ID Priority Status    Time Detected Summary
---------- -------- --------- ------------- -------
88         CRITICAL OPEN      26-NOV-08     Control file /opt/oracle/oradata/o102/control01.ctl is missing

RMAN> advise failure;

List of Database Failures
=========================

Failure ID Priority Status    Time Detected Summary
---------- -------- --------- ------------- -------
88         CRITICAL OPEN      26-NOV-08     Control file /opt/oracle/oradata/o102/control01.ctl is missing

analyzing automatic repair options; this may take some time
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=151 device type=DISK
analyzing automatic repair options complete

Mandatory Manual Actions
========================
no manual actions available

Optional Manual Actions
=======================
no manual actions available

Automated Repair Options
========================
Option Repair Description
------ ------------------
1      Use a multiplexed copy to restore control file /opt/oracle/oradata/o102/control01.ctl  
  Strategy: The repair includes complete media recovery with no data loss
  Repair script: /opt/oracle/diag/rdbms/o102/o102/hm/reco_2122223295.hm

RMAN> repair failure;

Strategy: The repair includes complete media recovery with no data loss
Repair script: /opt/oracle/diag/rdbms/o102/o102/hm/reco_2122223295.hm

contents of repair script:
   # restore control file using multiplexed copy
   restore controlfile from '/opt/oracle/oradata/o102/control02.ctl';
   sql 'alter database mount';

Do you really want to execute the above repair (enter YES or NO)? YES
executing repair script

Starting restore at 26-NOV-08
using channel ORA_DISK_1

channel ORA_DISK_1: copied control file copy
output file name=/opt/oracle/oradata/o102/control01.ctl
output file name=/opt/oracle/oradata/o102/control02.ctl
output file name=/opt/oracle/oradata/o102/control03.ctl
Finished restore at 26-NOV-08

sql statement: alter database mount
released channel: ORA_DISK_1
repair failure complete

Do you want to open the database (enter YES or NO)? YES
database opened