ORA-19625 rman備份錯誤不能備份
current log archived
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 01/02/2014 02:03:44
RMAN-06059: expected archived log not found, lost of archived log compromises recoverability
ORA-19625: error identifying file /archive/1_2615_784054258.dbf
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
====解決辦法
Last login: Thu Jan 2 09:51:24 2014 from 172.18.88.23
[[email protected] ~]# su - oracle
[[email protected] ~]$ rman
Recovery Manager: Release 10.2.0.4.0 - Production on Thu Jan 2 10:58:02 2014
Copyright (c) 1982, 2007, Oracle. All rights reserved.
RMAN> connect target /
connected to target database: testdb (DBID=4150210929)
RMAN> crosscheck archivelog all;
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=362 devtype=DISK
validation failed for archived log
archive log filename=/archive/1_2615_784054258.dbf recid=2615 stamp=834483641
validation failed for archived log
archive log filename=/archive/1_2616_784054258.dbf recid=2616 stamp=834414955
validation failed for archived log
archive log filename=/archive/1_2617_784054258.dbf recid=2617 stamp=834430988
validation failed for archived log
archive log filename=/archive/1_2618_784054258.dbf recid=2618 stamp=834512448
validation failed for archived log
archive log filename=/archive/1_2619_784054258.dbf recid=2619 stamp=834530438
validation failed for archived log
archive log filename=/archive/1_2620_784054258.dbf recid=2620 stamp=834555658
validation failed for archived log
archive log filename=/archive/1_2621_784054258.dbf recid=2621 stamp=834588004
validation failed for archived log
archive log filename=/archive/1_2622_784054258.dbf recid=2622 stamp=834616816
validation failed for archived log
archive log filename=/archive/1_2623_784054258.dbf recid=2623 stamp=834645655
validation failed for archived log
archive log filename=/archive/1_2624_784054258.dbf recid=2624 stamp=834658191
validation failed for archived log
archive log filename=/archive/1_2625_784054258.dbf recid=2625 stamp=834702995
validation failed for archived log
archive log filename=/archive/1_2626_784054258.dbf recid=2626 stamp=834714014
validation failed for archived log
archive log filename=/archive/1_2627_784054258.dbf recid=2627 stamp=834737243
validation failed for archived log
archive log filename=/archive/1_2628_784054258.dbf recid=2628 stamp=834767562
validation failed for archived log
archive log filename=/archive/1_2629_784054258.dbf recid=2629 stamp=834809097
validation failed for archived log
archive log filename=/archive/1_2630_784054258.dbf recid=2630 stamp=834825211
validation failed for archived log
archive log filename=/archive/1_2631_784054258.dbf recid=2631 stamp=834866600
validation failed for archived log
archive log filename=/archive/1_2632_784054258.dbf recid=2632 stamp=834910089
validation failed for archived log
archive log filename=/archive/1_2633_784054258.dbf recid=2633 stamp=834925879
validation failed for archived log
archive log filename=/archive/1_2634_784054258.dbf recid=2634 stamp=834962410
validation failed for archived log
archive log filename=/archive/1_2635_784054258.dbf recid=2635 stamp=834969894
validation failed for archived log
archive log filename=/archive/1_2636_784054258.dbf recid=2636 stamp=835101718
validation failed for archived log
archive log filename=/archive/1_2637_784054258.dbf recid=2637 stamp=835101857
validation failed for archived log
archive log filename=/archive/1_2638_784054258.dbf recid=2638 stamp=835101898
validation failed for archived log
archive log filename=/archive/1_2639_784054258.dbf recid=2639 stamp=835013837
validation failed for archived log
archive log filename=/archive/1_2640_784054258.dbf recid=2640 stamp=835059628
validation failed for archived log
archive log filename=/archive/1_2641_784054258.dbf recid=2641 stamp=835135220
validation failed for archived log
archive log filename=/archive/1_2642_784054258.dbf recid=2642 stamp=835153971
validation succeeded for archived log
archive log filename=/archive/1_2663_784054258.dbf recid=2663 stamp=835754624
Crosschecked 29 objects
RMAN> delete expired archivelog all;
released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=362 devtype=DISK
List of Archived Log Copies
Key Thrd Seq S Low Time Name
------- ---- ------- - --------- ----
2615 1 2615 X 18-DEC-13 /archive/1_2615_784054258.dbf
2616 1 2616 X 18-DEC-13 /archive/1_2616_784054258.dbf
2617 1 2617 X 17-DEC-13 /archive/1_2617_784054258.dbf
2618 1 2618 X 17-DEC-13 /archive/1_2618_784054258.dbf
2619 1 2619 X 18-DEC-13 /archive/1_2619_784054258.dbf
2620 1 2620 X 18-DEC-13 /archive/1_2620_784054258.dbf
2621 1 2621 X 19-DEC-13 /archive/1_2621_784054258.dbf
2622 1 2622 X 19-DEC-13 /archive/1_2622_784054258.dbf
2623 1 2623 X 19-DEC-13 /archive/1_2623_784054258.dbf
2624 1 2624 X 20-DEC-13 /archive/1_2624_784054258.dbf
2625 1 2625 X 20-DEC-13 /archive/1_2625_784054258.dbf
2626 1 2626 X 20-DEC-13 /archive/1_2626_784054258.dbf
2627 1 2627 X 21-DEC-13 /archive/1_2627_784054258.dbf
2628 1 2628 X 21-DEC-13 /archive/1_2628_784054258.dbf
2629 1 2629 X 21-DEC-13 /archive/1_2629_784054258.dbf
2630 1 2630 X 22-DEC-13 /archive/1_2630_784054258.dbf
2631 1 2631 X 22-DEC-13 /archive/1_2631_784054258.dbf
2632 1 2632 X 22-DEC-13 /archive/1_2632_784054258.dbf
2633 1 2633 X 23-DEC-13 /archive/1_2633_784054258.dbf
2634 1 2634 X 23-DEC-13 /archive/1_2634_784054258.dbf
2635 1 2635 X 23-DEC-13 /archive/1_2635_784054258.dbf
2636 1 2636 X 24-DEC-13 /archive/1_2636_784054258.dbf
2637 1 2637 X 25-DEC-13 /archive/1_2637_784054258.dbf
2638 1 2638 X 25-DEC-13 /archive/1_2638_784054258.dbf
2639 1 2639 X 25-DEC-13 /archive/1_2639_784054258.dbf
2640 1 2640 X 24-DEC-13 /archive/1_2640_784054258.dbf
2641 1 2641 X 25-DEC-13 /archive/1_2641_784054258.dbf
2642 1 2642 X 25-DEC-13 /archive/1_2642_784054258.dbf
Do you really want to delete the above objects (enter YES or NO)? y
deleted archive log
archive log filename=/archive/1_2615_784054258.dbf recid=2615 stamp=834483641
deleted archive log
archive log filename=/archive/1_2616_784054258.dbf recid=2616 stamp=834414955
deleted archive log
archive log filename=/archive/1_2617_784054258.dbf recid=2617 stamp=834430988
deleted archive log
archive log filename=/archive/1_2618_784054258.dbf recid=2618 stamp=834512448
deleted archive log
archive log filename=/archive/1_2619_784054258.dbf recid=2619 stamp=834530438
deleted archive log
archive log filename=/archive/1_2620_784054258.dbf recid=2620 stamp=834555658
deleted archive log
archive log filename=/archive/1_2621_784054258.dbf recid=2621 stamp=834588004
deleted archive log
archive log filename=/archive/1_2622_784054258.dbf recid=2622 stamp=834616816
deleted archive log
archive log filename=/archive/1_2623_784054258.dbf recid=2623 stamp=834645655
deleted archive log
archive log filename=/archive/1_2624_784054258.dbf recid=2624 stamp=834658191
deleted archive log
archive log filename=/archive/1_2625_784054258.dbf recid=2625 stamp=834702995
deleted archive log
archive log filename=/archive/1_2626_784054258.dbf recid=2626 stamp=834714014
deleted archive log
archive log filename=/archive/1_2627_784054258.dbf recid=2627 stamp=834737243
deleted archive log
archive log filename=/archive/1_2628_784054258.dbf recid=2628 stamp=834767562
deleted archive log
archive log filename=/archive/1_2629_784054258.dbf recid=2629 stamp=834809097
deleted archive log
archive log filename=/archive/1_2630_784054258.dbf recid=2630 stamp=834825211
deleted archive log
archive log filename=/archive/1_2631_784054258.dbf recid=2631 stamp=834866600
deleted archive log
archive log filename=/archive/1_2632_784054258.dbf recid=2632 stamp=834910089
deleted archive log
archive log filename=/archive/1_2633_784054258.dbf recid=2633 stamp=834925879
deleted archive log
archive log filename=/archive/1_2634_784054258.dbf recid=2634 stamp=834962410
deleted archive log
archive log filename=/archive/1_2635_784054258.dbf recid=2635 stamp=834969894
deleted archive log
archive log filename=/archive/1_2636_784054258.dbf recid=2636 stamp=835101718
deleted archive log
archive log filename=/archive/1_2637_784054258.dbf recid=2637 stamp=835101857
deleted archive log
archive log filename=/archive/1_2638_784054258.dbf recid=2638 stamp=835101898
deleted archive log
archive log filename=/archive/1_2639_784054258.dbf recid=2639 stamp=835013837
deleted archive log
archive log filename=/archive/1_2640_784054258.dbf recid=2640 stamp=835059628
deleted archive log
archive log filename=/archive/1_2641_784054258.dbf recid=2641 stamp=835135220
deleted archive log
archive log filename=/archive/1_2642_784054258.dbf recid=2642 stamp=835153971
Deleted 28 EXPIRED objects
RMAN> quit
再備份即ok
=======================================================================================================================
正确使用rman crosscheck
crosscheck archivelog all 用RMAN的備份中(Veritas等備份軟體由于歸檔日志的異常導緻歸檔日志備份失敗)是經常碰到的,解決方法也是非常解單,就是執行2條RMAN的指令:
1. 進入rman
2. connect target /
3. crosscheck archivelog all; //檢查控制檔案和實際實體檔案的差别。
4. delete expired archivelog all; //同步控制檔案的資訊和實際實體檔案的資訊。
===========================
這2條指令做什麼事情,原理是什麼。下面說明一下:
在controlfile中記錄着每一個archivelog的相關資訊,當我們在OS下把這些實體檔案delete掉或異常變動後,在controlfile中仍然記錄着這些archivelog的資訊,當我們手工清除archive目錄下的檔案後,這些記錄并沒有被我們從controlfile中清除掉,也就是oracle并不知道這些檔案已經不存在了!這時候我們要做手工的清除。 crosscheck archivelog all;的作用就是檢查控制檔案和實際實體檔案的差别。
delete expired archivelog all;就是同步控制檔案的資訊和實際實體檔案的資訊。 如果單獨執行crosscheck而沒有執行delete那麼備份還是失敗的,原因是那些控制檔案的資訊和實際的資訊還是不同。 crosscheck backupset crosscheck backupset 是檢查備份集和實際的檔案 1 備份集有兩種狀态A(Available,RMAN認為該項存在于備份媒體上)X(Expired,備份存在于控制檔案或恢複目錄中,但是并沒有實體存在于備份媒體上)
2 crosscheck 的目的是檢查RMAN 的目錄以及實體檔案,如果實體檔案不存在于媒體上,将标記為Expired。如果實體檔案存在,将維持Available。如果原先标記為Expired的備份集再次存在于備份媒體上(如恢複了損壞的磁盤驅動器後),crosscheck将把狀态重新從Expired标記回Available。
3 crosscheck 輸出分兩部分。第一部分列出确定存在于備份媒體上的所有備份集片,第二部分列出不存在于備份媒體上的備份集片,并将其标記為Expired。當設定備份儲存政策後,一個備份過期,crosscheck之後标記為丢棄的備份狀态依舊為availabel,要删除丢棄備份delete obsolete itpub一執行個體
我的一個Unix下 oracle資料庫在遷移當中一個歸檔檔案丢失了,rman備份歸檔日志時提示 某個歸檔日志找不到, 請問如何在不停止oracle資料庫情況下 截斷歸檔日志,重新開始新的歸檔!
crosscheck archivelog all
delete archivelog all;