Welcome 微信登录

首页 / 数据库 / MySQL / Oracle相关：Rman Crosscheck删除失效归档

当手工删除了归档日志以后，Rman备份会检测到日志缺失，从而无法进一步继续执行。     所以此时需要手工执行crosscheck过程，之后Rman备份可以恢复正常。    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

.....
  • 1
  • 2
  • 下一页
Sun推针对MySQL的新系统和存储解决方案Oracle中CHAR类型自动补足空格的问题解决相关资讯      Oracle教程 
  • Oracle中纯数字的varchar2类型和  （07/29/2015 07:20:43）
  • Oracle教程：Oracle中查看DBLink密  （07/29/2015 07:16:55）
  • [Oracle] SQL*Loader 详细使用教程  （08/11/2013 21:30:36）
  • Oracle教程：Oracle中kill死锁进程  （07/29/2015 07:18:28）
  • Oracle教程：ORA-25153 临时表空间  （07/29/2015 07:13:37）
  • Oracle教程之管理安全和资源  （04/08/2013 11:39:32）
本文评论 查看全部评论 （0）
表情： 姓名： 字数