oracle uncatalog資料庫備份檔案

 col FNAME for a150

 select fname, df_checkpoint_change# from v$backup_files where fname like '/obmnt%';

 

UNCATALOG 失敗：

 

# 手工複製備份的檔案到相同路徑 再次註冊：

RMAN> catalog datafilecopy '/obmnt/v-qbreokex/db/OAP/ob_data_D-OAP_I-2682516741_TS-MOCPRDNEW_DATA_FNO-13_e0vlijf8' level 0 tag 'OAP_OB_';

 

cataloged datafile copy

datafile copy file name=/obmnt/v-qbreokex/db/OAP/ob_data_D-OAP_I-2682516741_TS-MOCPRDNEW_DATA_FNO-13_e0vlijf8 RECID=1735 STAMP=1065118561

 

 

# 再次 UNCATALOG

RMAN>  change copy of database  like '/obmnt/v-qbreokex/db/OAP%' uncatalog; 

 

uncataloged datafile copy

datafile copy file name=/obmnt/v-qbreokex/db/OAP/ob_data_D-OAP_I-2682516741_TS-MOCPRDNEW_DATA_FNO-13_e0vlijf8 RECID=1735 STAMP=1065118561

Uncataloged 1 objects

 

完成！