ORACLE RMAN 错误收集

现象：备份失败;

原因：备份空间用完了

解决方案：

1. 查看配置：show parameter db_recovery_file_dest_size;

2. 调大db_recovery_file_dest_size：alter system set db_recovery_file_dest_size=XXXG scope=BOTH;

或者：修改rman保存时间：configure retention policy to recovery window of XXXdays

 

RMAN-06207: WARNING: 2 objects could not be deleted for DISK channel(s)

RMAN-06208: to mismatched status. Use CROSSCHECK command to fix
RMAN-06210: List of Mismatched objects
RMAN-06211: ==========================
RMAN-06212: Object Type Filename/Handle
RMAN-06213:

RMAN-06214: Datafile Copy /u10/oraback/DPDEVUG/HOT/control1DPDEVUG.ctl
RMAN-06214: Datafile Copy /u10/oraback/DPDEVUG/HOT/control2DPDEVUG.ctl

解决方案：crosscheck controlfilecopy ‘/u10/oraback/DPDEVUG/HOT/control1DPDEVUG.ctl'

 

RMAN-03009: failure of backup command on c1 channel at 01/05/2012 06:03:14

ORA-19502: write error on file "/backup/dbtemp/bkp_20120105_5138_1.dbf", blockno 4775297 (blocksize=8192)

ORA-27072: File I/O error

Linux-x86_64 Error: 2: No such file or directory

Additional information: 4

Additional information: 4775297

Additional information: 712704

解决方案：

检查磁盘空间：df -h

 

检查RMAN备份信息：

1. rman target /

2. crosscheck archivelog all;

3. delete expired archivelog all;

4. crosscheck backupset;

5. delete expired backupset;

6. report obsolete;

7. delete obsolete;