首頁 > 開發者 > 數據庫管理員

rman備份archivelog出現ORA-19625

來源：互聯網
上載者：User
創建阿里雲帳戶，並獲得超過 40 款產品的免費試用版；而企業帳戶則可以享有總值 $1200 的免費試用版。立即註冊！

rman備份archivelog時出現以下錯誤：

RMAN> backup archivelog all delete input;

Starting backup at 14-APR-14

current log archived

using channel ORA_DISK_1

using channel ORA_DISK_2

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of backup command at 04/14/2014 18:40:23

RMAN-06059: expected archived log not found, loss of archived log compromises recoverability
 
ORA-19625: error identifying file /home/Oracle/PROD/1_2_844469007.dbf

ORA-27037: unable to obtain file status

Linux Error: 2: No such file or directory

Additional information: 3

--------------------------------------分割線 --------------------------------------

推薦閱讀：

RMAN 配置歸檔日誌刪除策略

Oracle基礎教程之通過RMAN複製資料庫

RMAN備份策略制定參考內容

RMAN備份學習筆記

OracleDatabase Backup加密 RMAN加密

--------------------------------------分割線 --------------------------------------

網上查了出錯原因是由於作業系統下刪除了這個歸檔日誌，這個日誌還沒備份過，rman去備份的時候，找不到這個歸檔就出錯了。可使用change archivelog all crosscheck命令來解決此問題，如下：
 
RMAN> change archivelog all crosscheck;

released channel: ORA_DISK_1

released channel: ORA_DISK_2

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=43 device type=DISK

allocated channel: ORA_DISK_2

channel ORA_DISK_2: SID=45 device type=DISK

validation succeeded for archived log

archived log file name=/home/oracle/PROD/1_16_827176743.dbf RECID=1 STAMP=844399662
 
validation succeeded for archived log

archived log file name=/home/oracle/PROD/1_17_827176743.dbf RECID=2 STAMP=844460245
 
validation succeeded for archived log

archived log file name=/home/oracle/PROD/1_18_827176743.dbf RECID=3 STAMP=844461320
 
validation succeeded for archived log

archived log file name=/home/oracle/PROD/1_19_827176743.dbf RECID=4 STAMP=844461426
 
validation succeeded for archived log

archived log file name=/home/oracle/PROD/1_20_827176743.dbf RECID=5 STAMP=844461580
 
validation succeeded for archived log

archived log file name=/home/oracle/PROD/1_21_827176743.dbf RECID=6 STAMP=844461592
 
validation succeeded for archived log

archived log file name=/home/oracle/PROD/1_22_827176743.dbf RECID=7 STAMP=844461696
 
validation succeeded for archived log

archived log file name=/home/oracle/PROD/1_23_827176743.dbf RECID=8 STAMP=844462037
 
validation succeeded for archived log

archived log file name=/home/oracle/PROD/1_24_827176743.dbf RECID=9 STAMP=844462165
 
validation succeeded for archived log

archived log file name=/home/oracle/PROD/1_25_827176743.dbf RECID=10 STAMP=844462279
 
validation succeeded for archived log

archived log file name=/home/oracle/PROD/1_26_827176743.dbf RECID=11 STAMP=844462409
 
validation succeeded for archived log

archived log file name=/home/oracle/PROD/1_27_827176743.dbf RECID=12 STAMP=844465108
 
validation succeeded for archived log

archived log file name=/home/oracle/PROD/1_28_827176743.dbf RECID=13 STAMP=844469010
 
validation succeeded for archived log

archived log file name=/home/oracle/PROD/1_1_844532679.dbf RECID=16 STAMP=844533450
 
validation succeeded for archived log

archived log file name=/home/oracle/PROD/1_2_844532679.dbf RECID=19 STAMP=844537684
 
validation succeeded for archived log

archived log file name=/home/oracle/PROD/1_2_844532679.dbf RECID=17 STAMP=844533553
 
validation succeeded for archived log

archived log file name=/home/oracle/PROD/1_3_844532679.dbf RECID=20 STAMP=844537685
 
validation succeeded for archived log

archived log file name=/home/oracle/PROD/1_4_844532679.dbf RECID=18 STAMP=844537684
 
validation succeeded for archived log

archived log file name=/home/oracle/PROD/1_1_844537684.dbf RECID=23 STAMP=844605032
 
validation succeeded for archived log

archived log file name=/home/oracle/PROD/1_1_844537684.dbf RECID=21 STAMP=844575254
 
validation succeeded for archived log

archived log file name=/home/oracle/PROD/1_2_844537684.dbf RECID=24 STAMP=844605033
 
validation succeeded for archived log

archived log file name=/home/oracle/PROD/1_2_844537684.dbf RECID=22 STAMP=844581004
 
validation succeeded for archived log

archived log file name=/home/oracle/PROD/1_3_844537684.dbf RECID=25 STAMP=844605034
 
validation succeeded for archived log

archived log file name=/home/oracle/PROD/1_1_844469007.dbf RECID=14 STAMP=844530587
 
validation succeeded for archived log

archived log file name=/home/oracle/PROD/1_1_844605031.dbf RECID=26 STAMP=844670045
 
validation succeeded for archived log

archived log file name=/home/oracle/PROD/1_2_844605031.dbf RECID=27 STAMP=844797748
 
validation succeeded for archived log

archived log file name=/home/oracle/PROD/1_3_844605031.dbf RECID=28 STAMP=844841532
 
validation succeeded for archived log

archived log file name=/home/oracle/PROD/1_4_844605031.dbf RECID=29 STAMP=844847317
 
validation succeeded for archived log

archived log file name=/home/oracle/PROD/1_5_844605031.dbf RECID=30 STAMP=844855807
 
validation succeeded for archived log

archived log file name=/home/oracle/PROD/1_6_844605031.dbf RECID=31 STAMP=844855838
 
validation succeeded for archived log

archived log file name=/home/oracle/PROD/1_7_844605031.dbf RECID=32 STAMP=844886422
 
validation succeeded for archived log

archived log file name=/home/oracle/PROD/1_8_844605031.dbf RECID=33 STAMP=844886590
 
validation succeeded for archived log

archived log file name=/home/oracle/PROD/1_9_844605031.dbf RECID=34 STAMP=844886622
 
Crosschecked 33 objects

 

validation failed for archived log

archived log file name=/home/oracle/PROD/1_2_844469007.dbf RECID=15 STAMP=844530793
 
Crosschecked 1 objects

--再次執行archivelog的rman備份就成功了，如下：

RMAN> backup archivelog all delete input;

 

Starting backup at 14-APR-14

current log archived

using channel ORA_DISK_1

using channel ORA_DISK_2

channel ORA_DISK_1: starting compressed archived log backup set

channel ORA_DISK_1: specifying archived log(s) in backup set

input archived log thread=1 sequence=16 RECID=1 STAMP=844399662

input archived log thread=1 sequence=17 RECID=2 STAMP=844460245

input archived log thread=1 sequence=18 RECID=3 STAMP=844461320

channel ORA_DISK_1: starting piece 1 at 14-APR-14

channel ORA_DISK_2: starting compressed archived log backup set

channel ORA_DISK_2: specifying archived log(s) in backup set

input archived log thread=1 sequence=1 RECID=16 STAMP=844533450

channel ORA_DISK_2: starting piece 1 at 14-APR-14

channel ORA_DISK_2: finished piece 1 at 14-APR-14

piece handle=/home/oracle/backup/PROD_20140414_1bp5ntq0_1_1.bak tag=TAG20140414T190432 comment=NONE
 
channel ORA_DISK_2: backup set complete, elapsed time: 00:00:02

channel ORA_DISK_2: deleting archived log(s)

archived log file name=/home/oracle/PROD/1_1_844532679.dbf RECID=16 STAMP=844533450
 
channel ORA_DISK_2: starting compressed archived log backup set

channel ORA_DISK_2: specifying archived log(s) in backup set

input archived log thread=1 sequence=19 RECID=4 STAMP=844461426

input archived log thread=1 sequence=20 RECID=5 STAMP=844461580

input archived log thread=1 sequence=21 RECID=6 STAMP=844461592

input archived log thread=1 sequence=22 RECID=7 STAMP=844461696

input archived log thread=1 sequence=23 RECID=8 STAMP=844462037

input archived log thread=1 sequence=24 RECID=9 STAMP=844462165

input archived log thread=1 sequence=25 RECID=10 STAMP=844462279

channel ORA_DISK_2: starting piece 1 at 14-APR-14

channel ORA_DISK_1: finished piece 1 at 14-APR-14

piece handle=/home/oracle/backup/PROD_20140414_1ap5ntq0_1_1.bak tag=TAG20140414T190432 comment=NONE
 
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03

channel ORA_DISK_1: deleting archived log(s)

archived log file name=/home/oracle/PROD/1_16_827176743.dbf RECID=1 STAMP=844399662
 
archived log file name=/home/oracle/PROD/1_17_827176743.dbf RECID=2 STAMP=844460245
 
archived log file name=/home/oracle/PROD/1_18_827176743.dbf RECID=3 STAMP=844461320
 
channel ORA_DISK_1: starting compressed archived log backup set

channel ORA_DISK_1: specifying archived log(s) in backup set

input archived log thread=1 sequence=2 RECID=19 STAMP=844537684

input archived log thread=1 sequence=3 RECID=20 STAMP=844537685

channel ORA_DISK_1: starting piece 1 at 14-APR-14

channel ORA_DISK_2: finished piece 1 at 14-APR-14

piece handle=/home/oracle/backup/PROD_20140414_1cp5ntq3_1_1.bak tag=TAG20140414T190432 comment=NONE
 
channel ORA_DISK_2: backup set complete, elapsed time: 00:00:00

channel ORA_DISK_2: deleting archived log(s)

archived log file name=/home/oracle/PROD/1_19_827176743.dbf RECID=4 STAMP=844461426
 
archived log file name=/home/oracle/PROD/1_20_827176743.dbf RECID=5 STAMP=844461580
 
archived log file name=/home/oracle/PROD/1_21_827176743.dbf RECID=6 STAMP=844461592
 
archived log file name=/home/oracle/PROD/1_22_827176743.dbf RECID=7 STAMP=844461696
 
archived log file name=/home/oracle/PROD/1_23_827176743.dbf RECID=8 STAMP=844462037
 
archived log file name=/home/oracle/PROD/1_24_827176743.dbf RECID=9 STAMP=844462165
 
archived log file name=/home/oracle/PROD/1_25_827176743.dbf RECID=10 STAMP=844462279
 
channel ORA_DISK_2: starting compressed archived log backup set

channel ORA_DISK_2: specifying archived log(s) in backup set

input archived log thread=1 sequence=26 RECID=11 STAMP=844462409

input archived log thread=1 sequence=27 RECID=12 STAMP=844465108

channel ORA_DISK_2: starting piece 1 at 14-APR-14

channel ORA_DISK_1: finished piece 1 at 14-APR-14

piece handle=/home/oracle/backup/PROD_20140414_1dp5ntq3_1_1.bak tag=TAG20140414T190432 comment=NONE
 
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:00

channel ORA_DISK_1: deleting archived log(s)

archived log file name=/home/oracle/PROD/1_2_844532679.dbf RECID=19 STAMP=844537684
 
archived log file name=/home/oracle/PROD/1_3_844532679.dbf RECID=20 STAMP=844537685
 
channel ORA_DISK_1: starting compressed archived log backup set

channel ORA_DISK_1: specifying archived log(s) in backup set

input archived log thread=1 sequence=4 RECID=18 STAMP=844537684

channel ORA_DISK_1: starting piece 1 at 14-APR-14

channel ORA_DISK_2: finished piece 1 at 14-APR-14

piece handle=/home/oracle/backup/PROD_20140414_1ep5ntq3_1_1.bak tag=TAG20140414T190432 comment=NONE
 
channel ORA_DISK_2: backup set complete, elapsed time: 00:00:01

channel ORA_DISK_2: deleting archived log(s)

archived log file name=/home/oracle/PROD/1_26_827176743.dbf RECID=11 STAMP=844462409
 
archived log file name=/home/oracle/PROD/1_27_827176743.dbf RECID=12 STAMP=844465108
 
channel ORA_DISK_2: starting compressed archived log backup set

channel ORA_DISK_2: specifying archived log(s) in backup set

input archived log thread=1 sequence=1 RECID=23 STAMP=844605032

channel ORA_DISK_2: starting piece 1 at 14-APR-14

channel ORA_DISK_1: finished piece 1 at 14-APR-14

piece handle=/home/oracle/backup/PROD_20140414_1fp5ntq4_1_1.bak tag=TAG20140414T190432 comment=NONE
 
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:00

channel ORA_DISK_1: deleting archived log(s)

archived log file name=/home/oracle/PROD/1_4_844532679.dbf RECID=18 STAMP=844537684
 
channel ORA_DISK_1: starting compressed archived log backup set

channel ORA_DISK_1: specifying archived log(s) in backup set

input archived log thread=1 sequence=28 RECID=13 STAMP=844469010

channel ORA_DISK_1: starting piece 1 at 14-APR-14

channel ORA_DISK_1: finished piece 1 at 14-APR-14

piece handle=/home/oracle/backup/PROD_20140414_1hp5ntq4_1_1.bak tag=TAG20140414T190432 comment=NONE
 
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:04

channel ORA_DISK_1: deleting archived log(s)

archived log file name=/home/oracle/PROD/1_28_827176743.dbf RECID=13 STAMP=844469010
 
channel ORA_DISK_1: starting compressed archived log backup set

channel ORA_DISK_1: specifying archived log(s) in backup set

input archived log thread=1 sequence=1 RECID=14 STAMP=844530587

channel ORA_DISK_1: starting piece 1 at 14-APR-14

channel ORA_DISK_2: finished piece 1 at 14-APR-14

piece handle=/home/oracle/backup/PROD_20140414_1gp5ntq4_1_1.bak tag=TAG20140414T190432 comment=NONE
 
channel ORA_DISK_2: backup set complete, elapsed time: 00:00:04

channel ORA_DISK_2: deleting archived log(s)

archived log file name=/home/oracle/PROD/1_1_844537684.dbf RECID=23 STAMP=844605032
 
channel ORA_DISK_2: starting compressed archived log backup set

channel ORA_DISK_2: specifying archived log(s) in backup set

input archived log thread=1 sequence=2 RECID=24 STAMP=844605033

input archived log thread=1 sequence=3 RECID=25 STAMP=844605034

channel ORA_DISK_2: starting piece 1 at 14-APR-14

channel ORA_DISK_1: finished piece 1 at 14-APR-14

piece handle=/home/oracle/backup/PROD_20140414_1ip5ntq8_1_1.bak tag=TAG20140414T190432 comment=NONE
 
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:08

channel ORA_DISK_1: deleting archived log(s)

archived log file name=/home/oracle/PROD/1_1_844469007.dbf RECID=14 STAMP=844530587
 
channel ORA_DISK_1: starting compressed archived log backup set

channel ORA_DISK_1: specifying archived log(s) in backup set

input archived log thread=1 sequence=1 RECID=26 STAMP=844670045

input archived log thread=1 sequence=2 RECID=27 STAMP=844797748

input archived log thread=1 sequence=3 RECID=28 STAMP=844841532

channel ORA_DISK_1: starting piece 1 at 14-APR-14

channel ORA_DISK_2: finished piece 1 at 14-APR-14

piece handle=/home/oracle/backup/PROD_20140414_1jp5ntq8_1_1.bak tag=TAG20140414T190432 comment=NONE
 
channel ORA_DISK_2: backup set complete, elapsed time: 00:00:07

channel ORA_DISK_2: deleting archived log(s)

archived log file name=/home/oracle/PROD/1_2_844537684.dbf RECID=24 STAMP=844605033
 
archived log file name=/home/oracle/PROD/1_3_844537684.dbf RECID=25 STAMP=844605034
 
channel ORA_DISK_2: starting compressed archived log backup set

channel ORA_DISK_2: specifying archived log(s) in backup set

input archived log thread=1 sequence=4 RECID=29 STAMP=844847317

input archived log thread=1 sequence=5 RECID=30 STAMP=844855807

input archived log thread=1 sequence=6 RECID=31 STAMP=844855838

input archived log thread=1 sequence=7 RECID=32 STAMP=844886422

input archived log thread=1 sequence=8 RECID=33 STAMP=844886590

input archived log thread=1 sequence=9 RECID=34 STAMP=844886622

input archived log thread=1 sequence=10 RECID=35 STAMP=844887872

channel ORA_DISK_2: starting piece 1 at 14-APR-14

channel ORA_DISK_1: finished piece 1 at 14-APR-14

piece handle=/home/oracle/backup/PROD_20140414_1kp5ntqg_1_1.bak tag=TAG20140414T190432 comment=NONE
 
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:16

channel ORA_DISK_1: deleting archived log(s)

archived log file name=/home/oracle/PROD/1_1_844605031.dbf RECID=26 STAMP=844670045
 
archived log file name=/home/oracle/PROD/1_2_844605031.dbf RECID=27 STAMP=844797748
 
archived log file name=/home/oracle/PROD/1_3_844605031.dbf RECID=28 STAMP=844841532
 
channel ORA_DISK_2: finished piece 1 at 14-APR-14

piece handle=/home/oracle/backup/PROD_20140414_1lp5ntqh_1_1.bak tag=TAG20140414T190432 comment=NONE
 
channel ORA_DISK_2: backup set complete, elapsed time: 00:00:15

channel ORA_DISK_2: deleting archived log(s)

archived log file name=/home/oracle/PROD/1_4_844605031.dbf RECID=29 STAMP=844847317
 
archived log file name=/home/oracle/PROD/1_5_844605031.dbf RECID=30 STAMP=844855807
 
archived log file name=/home/oracle/PROD/1_6_844605031.dbf RECID=31 STAMP=844855838
 
archived log file name=/home/oracle/PROD/1_7_844605031.dbf RECID=32 STAMP=844886422
 
archived log file name=/home/oracle/PROD/1_8_844605031.dbf RECID=33 STAMP=844886590
 
archived log file name=/home/oracle/PROD/1_9_844605031.dbf RECID=34 STAMP=844886622
 
archived log file name=/home/oracle/PROD/1_10_844605031.dbf RECID=35 STAMP=844887872
 
Finished backup at 14-APR-14

 

Starting Control File Autobackup at 14-APR-14

piece handle=/home/oracle/backup/control/c-239015079-20140414-0d comment=NONE

Finished Control File Autobackup at 14-APR-14

注意：

crosscheck archivelog all：當手工刪除了資料庫的歸檔檔案後，需要用這個命令進行同步。（物理上刪除了歸檔日誌，但是控制檔案並不知道；因此需要交叉檢驗以同步資訊）
 
CROSSCHECK BACKUP：當手工刪除了RMAN的備份級時，需要使用的是這個命令：

他們的區別是同步的內容不同，一個是同步歸檔檔案的狀態，一個是同步RMAN備份資訊。

本文章原先以中文撰寫並發佈於 aliyun.com，亦設英文版本，僅作資訊用途。本網站不對文章的準確性，完整性或可靠性或其任何翻譯作出任何明示或暗示的陳述或保證。如對該文章有任何疑慮或投訴，請傳送電郵至 info-contact@alibabacloud.com 並提供相關疑慮或投訴的詳細說明。職員會於 5 個工作天內與您聯絡，一經驗證之後，即會刪除該侵權內容。

聯繫我們

該頁面正文內容均來源於網絡整理，並不代表阿里雲官方的觀點，該頁面所提到的產品和服務也與阿里云無關，如果該頁面內容對您造成了困擾，歡迎寫郵件給我們，收到郵件我們將在5個工作日內處理。

如果您發現本社區中有涉嫌抄襲的內容，歡迎發送郵件至： info-contact@alibabacloud.com 進行舉報並提供相關證據，工作人員會在 5 個工作天內聯絡您，一經查實，本站將立刻刪除涉嫌侵權內容。

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

Get Started for Free

  • Sales Support

    1 on 1 presale consultation

    Chat Contact Sales

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

    Open a Ticket

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.

    Learn More