rman_restore controlfile_and_autobackup之關係測試

1,如下表明：控制檔案完完情況下，恢復控制檔案從autobackup去找對應備份,所以你一定要形成配置spfile和controlfile自動備份的好習慣，不然，呵呵
RMAN> restore controlfile;

Starting restore at 30-JAN-10
using channel ORA_DISK_1

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 01/30/2010 20:55:50
RMAN-06563: control file or SPFILE must be restored using FROM AUTOBACKUP

2,再次證明，還是另外配置一個catalog庫吧，不然你直接用生產庫跑rman,哪就玩完了，呵呵，一旦生產庫的控制檔案沒了，而且你呢，沒搞備份，哈哈，你所作的所有備份沒有一點用



3,再次引錄一節我的小測試

RMAN> set dbid=3005679176;

executing command: SET DBID

RMAN> restore spfile to '/oracle/spfilecentos.ora' from autobackup;

Starting restore at 30-JAN-10
using channel ORA_DISK_1

recovery area destination: /oracle/flash_recovery_area
database name (or database unique name) used for search: CENTOS
channel ORA_DISK_1: no autobackups found in the recovery area
channel ORA_DISK_1: looking for autobackup on day: 20100130
channel ORA_DISK_1: looking for autobackup on day: 20100129
channel ORA_DISK_1: looking for autobackup on day: 20100128
channel ORA_DISK_1: looking for autobackup on day: 20100127
channel ORA_DISK_1: looking for autobackup on day: 20100126
channel ORA_DISK_1: looking for autobackup on day: 20100125
channel ORA_DISK_1: looking for autobackup on day: 20100124
channel ORA_DISK_1: no autobackup in 7 days found
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 01/30/2010 20:55:00
RMAN-06172: no autobackup found or specified handle is not a valid copy or piece


4,以上所作皆與data guard有關，為模擬主庫控制檔案完完，但之前對控制檔案作了備份