您當(dāng)前所在位置：
首頁 →
數(shù)據(jù)庫 →
Oracle →
Rman Crosscheck刪除失效歸檔
Rman Crosscheck刪除失效歸檔
時間：2015-06-28 00:00:00
來源：IT貓撲網(wǎng)
作者：網(wǎng)管聯(lián)盟
我要評論(0)
??? 當(dāng)手工刪除了歸檔日志以后，Rman備份會檢測到日志缺失，從而無法進(jìn)一步繼續(xù)執(zhí)行。
??? 所以此時需要手工執(zhí)行crosscheck過程，之后Rman備份可以恢復(fù)正常。
??? 1.Crosscheck日志
$ rman target /
Recovery Manager: Release 9.2.0.4.0 - 64bit Production
Copyright (c) 1995, 2002, Oracle Corporation.? All rights reserved.
connected to target database: AVATAR2 (DBID=2480694409)
RMAN> crosscheck archivelog all;
using target database controlfile instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=25 devtype=DISK
validation failed for archived log
archive log filename=/opt/oracle/oradata/avatar2/archive/1_2714.dbf recid=2702 stamp=545107659
validation failed for archived log
archive log filename=/opt/oracle/oradata/avatar2/archive/1_2715.dbf recid=2703 stamp=545108268
...........
validation failed for archived log
archive log filename=/opt/oracle/oradata/avatar2/archive/1_2985.dbf recid=2973 stamp=545399327
validation succeeded for archived log
archive log filename=/opt/oracle/oradata/avatar2/archive/1_2986.dbf recid=2974 stamp=545400820
validation succeeded for archived log
archive log filename=/opt/oracle/oradata/avatar2/archive/1_2987.dbf recid=2975 stamp=545401757
validation succeeded for archived log
archive log filename=/opt/oracle/oradata/avatar2/archive/1_2988.dbf recid=2976 stamp=545402716
validation succeeded for archived log
archive log filename=/opt/oracle/oradata/avatar2/archive/1_2989.dbf recid=2977 stamp=545403661
validation succeeded for archived log
archive log filename=/opt/oracle/oradata/avatar2/archive/1_2990.dbf recid=2978 stamp=545404946
validation succeeded for archived log
archive log filename=/opt/oracle/oradata/avatar2/archive/1_2991.dbf recid=2979 stamp=545406220
Crosschecked 278 objects
RMAN> |
??? 2.使用delete expired archivelog all 命令刪除所有過期歸檔日志：
RMAN> delete expired archivelog all;
released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=12 devtype=DISK
List of Archived Log Copies
Key???? Thrd Seq???? S Low Time? Name
------- ---- ------- - --------- ----
376???? 1??? 2714???? X 23-NOV-04 =/opt/oracle/oradata/avatar2/archive/1_2714.dbf
..... |
??? 3.簡要介紹一下report obsolete命令
??? 使用report obsolete命令報告過期備份
Oracle中使用alter table來增加,刪除,修改列的語法
oracle中使用SQL語句修改字段類型-oracle修改SQL語句案例