手動刪除了歸檔日誌後,rman備份出現問題解決

shilei1發表於2011-10-11
開始備份:
RMAN> RUN {
2> ALLOCATE CHANNEL CH1 DEVICE TYPE DISK;
3> ALLOCATE CHANNEL CH2 DEVICE TYPE DISK;
4> BACKUP DATABASE
5>  SKIP INACCESSIBLE
6>  FILESPERSET 10
7> INCLUDE CURRENT CONTROLFILE
8>    PLUS ARCHIVELOG FILESPERSET 20
9>    DELETE ALL INPUT;
10> RELEASE CHANNEL CH1;
11> RELEASE CHANNEL CH2;
12> CROSSCHECK BACKUPSET;
13> DELETE NOPROMPT OBSOLETE;
14> }

released channel: ORA_DISK_1
allocated channel: CH1
channel CH1: SID=1154 instance=mdstest1 device type=DISK

allocated channel: CH2
channel CH2: SID=585 instance=mdstest1 device type=DISK


Starting backup at 2011-10-11 16:40:50
current log archived
released channel: CH1
released channel: CH2
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup plus archivelog command at 10/11/2011 16:41:01
RMAN-06059: expected archived log not found, loss of archived log compromises recoverability
ORA-19625: error identifying file +FRA/mdstest/archivelog/2011_07_26/thread_1_seq_6.271.757519769
ORA-17503: ksfdopn:2 Failed to open file +FRA/mdstest/archivelog/2011_07_26/thread_1_seq_6.271.757519769
ORA-15012: ASM file '+FRA/mdstest/archivelog/2011_07_26/thread_1_seq_6.271.757519769' does not exist

原因是前期手動的刪除了asm裡的歸檔日誌。

處理方案:
RMAN> crosscheck archivelog all;

allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1154 instance=mdstest1 device type=DISK
validation failed for archived log
archived log file name=+FRA/mdstest/archivelog/2011_07_26/thread_1_seq_6.271.757519769 RECID=40 STAMP=757519778
validation failed for archived log
archived log file name=+FRA/mdstest/archivelog/2011_07_31/thread_1_seq_7.268.757934067 RECID=41 STAMP=757934078
validation failed for archived log
archived log file name=+FRA/mdstest/archivelog/2011_08_03/thread_1_seq_8.265.758214047 RECID=42 STAMP=758214066
validation failed for archived log
archived log file name=+FRA/mdstest/archivelog/2011_08_05/thread_1_seq_9.273.758369731 RECID=46 STAMP=758369738
validation failed for archived log
archived log file name=+FRA/mdstest/archivelog/2011_08_05/thread_1_seq_10.287.758372347 RECID=49 STAMP=758372346
validation failed for archived log
archived log file name=+FRA/mdstest/archivelog/2011_08_07/thread_1_seq_11.289.758560159 RECID=51 STAMP=758560158
validation failed for archived log
archived log file name=+FRA/mdstest/archivelog/2011_08_07/thread_1_seq_12.290.758560163 RECID=52 STAMP=758560163
validation failed for archived log
archived log file name=+FRA/mdstest/archivelog/2011_08_11/thread_1_seq_13.292.758888507 RECID=54 STAMP=758888519
validation failed for archived log
archived log file name=+FRA/mdstest/archivelog/2011_08_11/thread_1_seq_14.293.758888523 RECID=55 STAMP=758888523
validation failed for archived log
archived log file name=+FRA/mdstest/archivelog/2011_08_14/thread_1_seq_15.294.759132039 RECID=57 STAMP=759132052
validation failed for archived log
archived log file name=+FRA/mdstest/archivelog/2011_08_15/thread_1_seq_16.296.759253505 RECID=58 STAMP=759253508
validation failed for archived log
archived log file name=+FRA/mdstest/archivelog/2011_08_24/thread_1_seq_17.300.760007801 RECID=62 STAMP=760007812
validation failed for archived log
archived log file name=+FRA/mdstest/archivelog/2011_08_30/thread_1_seq_18.302.760554029 RECID=64 STAMP=760554039
validation failed for archived log
archived log file name=+FRA/mdstest/archivelog/2011_09_04/thread_1_seq_19.304.760982421 RECID=66 STAMP=760982432
validation failed for archived log
archived log file name=+FRA/mdstest/archivelog/2011_09_10/thread_1_seq_20.306.761472033 RECID=68 STAMP=761472042
validation failed for archived log
archived log file name=+FRA/mdstest/archivelog/2011_09_15/thread_1_seq_21.309.761954465 RECID=71 STAMP=761954473
validation failed for archived log
archived log file name=+FRA/mdstest/archivelog/2011_09_21/thread_1_seq_22.311.762472839 RECID=73 STAMP=762472849
validation failed for archived log
archived log file name=+FRA/mdstest/archivelog/2011_09_27/thread_1_seq_23.314.762991227 RECID=76 STAMP=762991239
validation succeeded for archived log
archived log file name=+FRA/mdstest/archivelog/2011_10_02/thread_1_seq_24.316.763454847 RECID=78 STAMP=763454858
validation succeeded for archived log
archived log file name=+FRA/mdstest/archivelog/2011_10_05/thread_1_seq_25.317.763707619 RECID=79 STAMP=763707629
validation succeeded for archived log
archived log file name=+FRA/mdstest/archivelog/2011_10_09/thread_1_seq_26.319.764056817 RECID=81 STAMP=764056828
validation succeeded for archived log
archived log file name=+FRA/mdstest/archivelog/2011_10_10/thread_1_seq_27.320.764174661 RECID=82 STAMP=764174663
validation succeeded for archived log
archived log file name=+FRA/mdstest/archivelog/2011_10_10/thread_1_seq_28.323.764177457 RECID=85 STAMP=764177457
validation succeeded for archived log
archived log file name=+FRA/mdstest/archivelog/2011_10_10/thread_1_seq_29.325.764181523 RECID=87 STAMP=764181523
validation succeeded for archived log
archived log file name=+FRA/mdstest/archivelog/2011_10_10/thread_1_seq_30.328.764182235 RECID=90 STAMP=764182235
validation succeeded for archived log
archived log file name=+FRA/mdstest/archivelog/2011_10_10/thread_1_seq_31.329.764182237 RECID=91 STAMP=764182236
validation succeeded for archived log
archived log file name=+FRA/mdstest/archivelog/2011_10_11/thread_1_seq_32.275.764268051 RECID=92 STAMP=764268056
validation failed for archived log
archived log file name=+FRA/mdstest/archivelog/2011_08_03/thread_2_seq_4.282.758214049 RECID=43 STAMP=758214065
validation failed for archived log
archived log file name=+FRA/mdstest/archivelog/2011_08_05/thread_2_seq_5.274.758369731 RECID=44 STAMP=758369731
validation failed for archived log
archived log file name=+FRA/mdstest/archivelog/2011_08_05/thread_2_seq_6.284.758369731 RECID=45 STAMP=758369731
validation failed for archived log
archived log file name=+FRA/mdstest/archivelog/2011_08_05/thread_2_seq_7.285.758372345 RECID=47 STAMP=758372345
validation failed for archived log
archived log file name=+FRA/mdstest/archivelog/2011_08_05/thread_2_seq_8.286.758372347 RECID=48 STAMP=758372346
validation failed for archived log
archived log file name=+FRA/mdstest/archivelog/2011_08_05/thread_2_seq_9.288.758398153 RECID=50 STAMP=758398154
validation failed for archived log
archived log file name=+FRA/mdstest/archivelog/2011_08_10/thread_2_seq_10.291.758833563 RECID=53 STAMP=758833573
validation failed for archived log
archived log file name=+FRA/mdstest/archivelog/2011_08_14/thread_2_seq_11.295.759132041 RECID=56 STAMP=759132046
validation failed for archived log
archived log file name=+FRA/mdstest/archivelog/2011_08_20/thread_2_seq_12.297.759681773 RECID=59 STAMP=759681773
validation failed for archived log
archived log file name=+FRA/mdstest/archivelog/2011_08_20/thread_2_seq_13.298.759681775 RECID=60 STAMP=759681774
validation failed for archived log
archived log file name=+FRA/mdstest/archivelog/2011_08_24/thread_2_seq_14.299.760007795 RECID=61 STAMP=760007809
validation failed for archived log
archived log file name=+FRA/mdstest/archivelog/2011_08_30/thread_2_seq_15.301.760526541 RECID=63 STAMP=760526549
validation failed for archived log
archived log file name=+FRA/mdstest/archivelog/2011_09_03/thread_2_seq_16.303.760889423 RECID=65 STAMP=760889436
validation failed for archived log
archived log file name=+FRA/mdstest/archivelog/2011_09_07/thread_2_seq_17.305.761265039 RECID=67 STAMP=761265053
validation failed for archived log
archived log file name=+FRA/mdstest/archivelog/2011_09_11/thread_2_seq_18.307.761562245 RECID=69 STAMP=761562254
validation failed for archived log
archived log file name=+FRA/mdstest/archivelog/2011_09_15/thread_2_seq_19.308.761908087 RECID=70 STAMP=761908102
validation failed for archived log
archived log file name=+FRA/mdstest/archivelog/2011_09_19/thread_2_seq_20.310.762253925 RECID=72 STAMP=762253936
validation failed for archived log
archived log file name=+FRA/mdstest/archivelog/2011_09_23/thread_2_seq_21.312.762599773 RECID=74 STAMP=762599787
validation failed for archived log
archived log file name=+FRA/mdstest/archivelog/2011_09_27/thread_2_seq_22.313.762912005 RECID=75 STAMP=762912017
validation succeeded for archived log
archived log file name=+FRA/mdstest/archivelog/2011_10_01/thread_2_seq_23.315.763398025 RECID=77 STAMP=763398034
validation succeeded for archived log
archived log file name=+FRA/mdstest/archivelog/2011_10_08/thread_2_seq_24.318.763981299 RECID=80 STAMP=763981307
validation succeeded for archived log
archived log file name=+FRA/mdstest/archivelog/2011_10_10/thread_2_seq_25.321.764174829 RECID=83 STAMP=764174838
validation succeeded for archived log
archived log file name=+FRA/mdstest/archivelog/2011_10_10/thread_2_seq_26.322.764174837 RECID=84 STAMP=764174836
validation succeeded for archived log
archived log file name=+FRA/mdstest/archivelog/2011_10_10/thread_2_seq_27.324.764180827 RECID=86 STAMP=764180827
validation succeeded for archived log
archived log file name=+FRA/mdstest/archivelog/2011_10_10/thread_2_seq_28.326.764181569 RECID=88 STAMP=764181568
validation succeeded for archived log
archived log file name=+FRA/mdstest/archivelog/2011_10_10/thread_2_seq_29.327.764181565 RECID=89 STAMP=764181565
validation succeeded for archived log
archived log file name=+FRA/mdstest/archivelog/2011_10_11/thread_2_seq_30.267.764268047 RECID=93 STAMP=764268056
Crosschecked 54 objects


RMAN> RUN {
2> ALLOCATE CHANNEL CH1 DEVICE TYPE DISK;
3> ALLOCATE CHANNEL CH2 DEVICE TYPE DISK;
4> BACKUP DATABASE
5>  SKIP INACCESSIBLE
6>  FILESPERSET 10
7> INCLUDE CURRENT CONTROLFILE
8>    PLUS ARCHIVELOG FILESPERSET 20
9>    DELETE ALL INPUT;
10> RELEASE CHANNEL CH1;
11> RELEASE CHANNEL CH2;
12> CROSSCHECK BACKUPSET;
13> DELETE NOPROMPT OBSOLETE;
14> }

released channel: ORA_DISK_1
allocated channel: CH1
channel CH1: SID=1154 instance=mdstest1 device type=DISK

allocated channel: CH2
channel CH2: SID=585 instance=mdstest1 device type=DISK


Starting backup at 2011-10-11 16:45:48
current log archived
channel CH1: starting archived log backup set
channel CH1: specifying archived log(s) in backup set


最後備份成功。

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/196700/viewspace-708979/,如需轉載,請註明出處,否則將追究法律責任。

相關文章