IT猫扑网：您身边最放心的安全下载站！ 最新更新|软件分类|软件专题|手机版|论坛转贴|软件发布

您当前所在位置：首页 → 数据库 → Oracle → Rman Crosscheck删除失效归档

Rman Crosscheck删除失效归档

时间：2015/6/28来源：IT猫扑网作者：网管联盟我要评论(0)

    当手工删除了归档日志以后，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

.....

    3.简要介绍一下report obsolete命令

    使用report obsolete命令报告过期备份

RMAN> report obsolete;

RMAN retention policy will be applied to the command

RMAN retention policy is set to redundancy 1

Report of obsolete backups and copies

Type     Key    Completion Time    Filename/Handle

-------------------- ------ ------------------ --------------------

Backup Set     125    01-NOV-04  

  Backup Piece 125    01-NOV-04    /data1/oracle/orabak/full_1_541045804

Backup Set     131    04-NOV-04  

  Backup Piece 131    04-NOV-04    /data1/oracle/orabak/full_AVATAR2_20041104_131

....

Backup Set     173    06-DEC-04  

  Backup Piece 173    06-DEC-04    /data1/oracle/orabak/full_AVATAR2_20041206_173

Backup Set     179    11-DEC-04  

  Backup Piece 179    11-DEC-04    /data1/oracle/orabak/arch544588206.arc

.....

  Backup Piece 189    17-DEC-04    /data1/oracle/orabak/arch545106606.arc

Backup Set     190    17-DEC-04  

  Backup Piece

关键词标签：Rman Crosscheck

相关阅读

文章评论
发表评论

热门文章 Oracle中使用alter table来增加,删除,修改列Oracle中使用alter table来增加,删除,修改列oracle中使用SQL语句修改字段类型-oracle修oracle中使用SQL语句修改字段类型-oracle修使用低权限Oracle数据库账户得到管理员权限使用低权限Oracle数据库账户得到管理员权限Oracle对user的访问控制Oracle对user的访问控制

相关下载

人气排行 ORACLE SQL 判断字符串是否为数字的语句Oracle中使用alter table来增加,删除,修改列的语法ORACLE和SQL语法区别归纳(1)oracle grant 授权语句如何加速Oracle大批量数据处理Oracle删除表的几种方法ORACLE修改IP地址后如何能够使用Oracle 10g创建表空间和用户并指定权限