バックアップの削除中に削除できません
5492 ワード
バックアップを行った後、バックアップファイルを削除してから、バックアップレコードを削除して、削除できません.次のように表示されます.
チェックを行い、期限切れのファイルをチェックしてから、もう一度削除すればいいです.
バックアップの場合、1つは物理バックアップであり、1つは論理バックアップである.
バックアップセットを表示するときに使用します.
ミラー・バックアップを表示するときに使用する手順は、次のとおりです.
期限切れのバックアップを削除するときに使用します.
RMAN> delete copy;
released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=145 devtype=DISK
specification does not match any archive log in the recovery catalog
List of Datafile Copies
Key File S Completion Time Ckp SCN Ckp Time Name
------- ---- - --------------- ---------- --------------- ----
17 1 A 13-JUN-14 634156 13-JUN-14 +KEL/ipap/datafile/system.257.850091431
19 2 A 13-JUN-14 634203 13-JUN-14 +KEL/ipap/datafile/undotbs1.258.850091543
18 3 A 13-JUN-14 634187 13-JUN-14 +KEL/ipap/datafile/sysaux.256.850091507
20 4 A 13-JUN-14 634205 13-JUN-14 +KEL/ipap/datafile/users.259.850091545
Do you really want to delete the above objects (enter YES or NO)? y
RMAN-06207: WARNING: 4 objects could not be deleted for DISK channel(s) due
RMAN-06208: to mismatched status. Use CROSSCHECK command to fix status
RMAN-06210: List of Mismatched objects
RMAN-06211: ==========================
RMAN-06212: Object Type Filename/Handle
RMAN-06213: --------------- ---------------------------------------------------
RMAN-06214: Datafile Copy +KEL/ipap/datafile/system.257.850091431
RMAN-06214: Datafile Copy +KEL/ipap/datafile/undotbs1.258.850091543
RMAN-06214: Datafile Copy +KEL/ipap/datafile/sysaux.256.850091507
RMAN-06214: Datafile Copy +KEL/ipap/datafile/users.259.850091545
チェックを行い、期限切れのファイルをチェックしてから、もう一度削除すればいいです.
RMAN> crosscheck copy;
released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=145 devtype=DISK
specification does not match any archive log in the recovery catalog
validation failed for datafile copy
datafile copy filename=+KEL/ipap/datafile/system.257.850091431 recid=17 stamp=850091498
validation failed for datafile copy
datafile copy filename=+KEL/ipap/datafile/undotbs1.258.850091543 recid=19 stamp=850091544
validation failed for datafile copy
datafile copy filename=+KEL/ipap/datafile/sysaux.256.850091507 recid=18 stamp=850091538
validation failed for datafile copy
datafile copy filename=+KEL/ipap/datafile/users.259.850091545 recid=20 stamp=850091545
Crosschecked 4 objects
RMAN> delete copy;
released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=145 devtype=DISK
specification does not match any archive log in the recovery catalog
List of Datafile Copies
Key File S Completion Time Ckp SCN Ckp Time Name
------- ---- - --------------- ---------- --------------- ----
17 1 X 13-JUN-14 634156 13-JUN-14 +KEL/ipap/datafile/system.257.850091431
19 2 X 13-JUN-14 634203 13-JUN-14 +KEL/ipap/datafile/undotbs1.258.850091543
18 3 X 13-JUN-14 634187 13-JUN-14 +KEL/ipap/datafile/sysaux.256.850091507
20 4 X 13-JUN-14 634205 13-JUN-14 +KEL/ipap/datafile/users.259.850091545
Do you really want to delete the above objects (enter YES or NO)? y
deleted datafile copy
datafile copy filename=+KEL/ipap/datafile/system.257.850091431 recid=17 stamp=850091498
deleted datafile copy
datafile copy filename=+KEL/ipap/datafile/undotbs1.258.850091543 recid=19 stamp=850091544
deleted datafile copy
datafile copy filename=+KEL/ipap/datafile/sysaux.256.850091507 recid=18 stamp=850091538
deleted datafile copy
datafile copy filename=+KEL/ipap/datafile/users.259.850091545 recid=20 stamp=850091545
Deleted 4 objects
バックアップの場合、1つは物理バックアップであり、1つは論理バックアップである.
バックアップセットを表示するときに使用します.
RMAN> list backup;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
3 Full 6.80M DISK 00:00:01 13-JUN-14
BP Key: 3 Status: AVAILABLE Compressed: NO Tag: TAG20140613T003226
Piece Name: /home/oracle/flash_recovery_area/IPAP/autobackup/2014_06_13/o1_mf_s_850091546_9sob8ck2_.bkp
Control File Included: Ckp SCN: 634210 Ckp time: 13-JUN-14
SPFILE Included: Modification time: 13-JUN-14
ミラー・バックアップを表示するときに使用する手順は、次のとおりです.
RMAN> list copy;
specification does not match any archive log in the recovery catalog
List of Datafile Copies
Key File S Completion Time Ckp SCN Ckp Time Name
------- ---- - --------------- ---------- --------------- ----
21 1 A 13-JUN-14 634486 13-JUN-14 +KEL/orcl
期限切れのバックアップを削除するときに使用します.
RMAN> delete expired copy;
released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=145 devtype=DISK
specification does not match any archive log in the recovery catalog
List of Datafile Copies
Key File S Completion Time Ckp SCN Ckp Time Name
------- ---- - --------------- ---------- --------------- ----
21 1 X 13-JUN-14 634486 13-JUN-14 +KEL/orcl
Do you really want to delete the above objects (enter YES or NO)? y
deleted datafile copy
datafile copy filename=+KEL/orcl recid=21 stamp=850092105
Deleted 1 EXPIRED objects
RMAN> delete expired backupset;
using channel ORA_DISK_1
RMAN> delete expired backup;
using channel ORA_DISK_1