rman 的crosscheck命令問題!
執行的時候報:
RMAN> crosscheck backup;
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=115 devtype=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: sid=135 devtype=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: sid=76 devtype=DISK
allocated channel: ORA_DISK_4
channel ORA_DISK_4: sid=64 devtype=DISK
released channel: ORA_DISK_1
released channel: ORA_DISK_2
released channel: ORA_DISK_3
released channel: ORA_DISK_4
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of crosscheck command at 10/31/2007 18:05:56
ORA-19554: error allocating device, device type: SBT_TAPE, device name:
ORA-27211: Failed to load Media Management Library
RMAN>
rman配置資訊:
RMAN> show all;
using target database control file instead of recovery catalog
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE 'SBT_TAPE' BACKUP TYPE TO COMPRESSED BACKUPSET PARALLELISM 1;
CONFIGURE DEVICE TYPE DISK PARALLELISM 4 BACKUP TYPE TO COMPRESSED BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
正確的做法:
run {
allocate channel ch1 type disk;
CROSSCHECK BACKUPSET;
CROSSCHECK COPY;
}
在此感謝在http://www.itpub.net/883477.html所有參與的人。
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/312079/viewspace-245795/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- RMAN CROSSCHECK命令小bug(轉)ROS
- Oracle RMAN 的 show,list,crosscheck,delete命令整理OracleROSdelete
- 轉載-RMAN下CROSSCHECK命令詳解ROS
- RMAN Crosscheck 和 Delete 命令的 2 個例項ROSdelete
- RMAN Crosscheck 和 Delete 命令的2個例項ROSdelete
- rman crosscheck作用ROS
- 正確使用rman crosscheckROS
- Oracle RMAN的show,list,crosscheck,deleteOracleROSdelete
- RMAN命令configure,report,list,crosscheck,delete的使用方法ROSdelete
- CROSSCHECK命令使用ROS
- RMAN的crosscheck和obsolete的用法ROS
- rman report list crosscheck deleteROSdelete
- 轉:正確使用rman crosscheckROS
- Rman Crosscheck刪除失效歸檔ROS
- 使用RMAN CROSSCHECK 更新檔案狀態ROS
- RMAN備份list report crosscheck validate change delete 和恢復命令例項ROSdelete
- 測試rman transport tablespace命令時遇著的小問題~~
- Rman Crosscheck刪除失效歸檔-備份恢復ROS
- Oracle OCP IZ0-053 Q682(Rman Crosscheck)OracleROS
- Oracle 8i 與 oracle 9 下 RMAN 中 CROSSCHECK 使用的差異OracleROS
- linux下使用rman的問題Linux
- rman 命令
- RMAN命令
- RMAN-05001,RMAN-05500 問題解決
- crosscheck archivelog all;crosscheck backup of區別ROSHive
- RMAN處理split block問題BloC
- 【RMAN】使用RMAN duplicate複製同機資料庫遇到的問題資料庫
- rman在linux下的一個問題Linux
- RMAN命令大全
- rman(2)--命令
- RMAN命令整理
- {HELP}sar命令的問題(轉)
- 使用RMAN report need backup命令檢查備份時遇到一個詭異的問題
- RMAN中常用的命令(一)
- RMAN常用的命令和操作
- RMAN常用的命令和操作:
- rman中的catalog命令!
- rman的一些命令