ORA-19633: controlfile record 2290 is out of sync with recovery catalog


當要刪除過期的備份記錄時,出現ERROR,訊息如下:

RMAN> DELETE FORCE NOPROMPT OBSOLETE;

(略…)

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of delete command on ORA_DISK_1 channel at 08/26/2008 09:51:48
ORA-19633: controlfile record 2290 is out of sync with recovery catalog

Recovery Manager complete.


意思大概為CONTROLFILE內備份記錄的日期與CATALOG所記錄的日期不同。



解決方法如下:

1.連上TARGER與CATALOG

    # rman target sys/XXXXX@AA catalog rman/XXXXX@AA

2.執行同步指令

    RMAN> resync catalog;

    starting full resync of recovery catalog
    full resync complete

利用Plink替代Putty來建立Script