网创优客建站品牌官网
为成都网站建设公司企业提供高品质网站建设
热线:028-86922220
成都专业网站建设公司

定制建站费用3500元

符合中小企业对网站设计、功能常规化式的企业展示型网站建设

成都品牌网站建设

品牌网站建设费用6000元

本套餐主要针对企业品牌型网站、中高端设计、前端互动体验...

成都商城网站建设

商城网站建设费用8000元

商城网站建设因基本功能的需求不同费用上面也有很大的差别...

成都微信网站建设

手机微信网站建站3000元

手机微信网站开发、微信官网、微信商城网站...

建站知识

当前位置:首页 > 建站知识

rman的crosscheck命令

在操作系统上手动删除备份或归档,rman不会立即知晓此变更,所以需要crosscheck更新备份的状态。
手动rm归档日志
检查归档
RMAN> crosscheck archivelog all;
released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=18 device type=DISK
validation failed for archived log
archived log file name=/home/oracle/1_62_947085344.dbf RECID=5 STAMP=950278766
validation failed for archived log
archived log file name=/home/oracle/1_63_947085344.dbf RECID=6 STAMP=950279852
validation failed for archived log
archived log file name=/home/oracle/1_64_947085344.dbf RECID=7 STAMP=950455276
validation failed for archived log

archived log file name=/home/oracle/1_1_950712737.dbf RECID=72 STAMP=950712738
validation succeeded for archived log
archived log file name=/home/oracle/1_2_950712737.dbf RECID=73 STAMP=950713931
Crosschecked 60 objects


删除实效归档
RMAN> delete expired archivelog all;


released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=18 device type=DISK
List of Archived Log Copies for database with db_unique_name TEST
=====================================================================

Key     Thrd Seq     S Low Time           
------- ---- ------- - -------------------
5       1    62      X 2017-07-23 22:09:22
        Name: /home/oracle/1_62_947085344.dbf

6       1    63      X 2017-07-25 14:19:26
        Name: /home/oracle/1_63_947085344.dbf


7       1    64      X 2017-07-25 14:37:32
        Name: /home/oracle/1_64_947085344.dbf
。。。

71      1    119     X 2017-07-30 14:24:59
        Name: /home/oracle/1_119_947085344.dbf

72      1    1       X 2017-07-30 14:52:17
        Name: /home/oracle/1_1_950712737.dbf

73      1    2       X 2017-07-30 14:52:18
        Name: /home/oracle/1_2_950712737.dbf

Do you really want to delete the above objects (enter YES or NO)? yes
deleted archived log
archived log file name=/home/oracle/1_62_947085344.dbf RECID=5 STAMP=950278766
deleted archived log
archived log file name=/home/oracle/1_63_947085344.dbf RECID=6 STAMP=950279852
deleted archived log

STAMP=950711099
deleted archived log
archived log file name=/home/oracle/1_119_947085344.dbf RECID=71 STAMP=950712737
deleted archived log
archived log file name=/home/oracle/1_1_950712737.dbf RECID=72 STAMP=950712738
deleted archived log
archived log file name=/home/oracle/1_2_950712737.dbf RECID=73 STAMP=950713931
Deleted 60 EXPIRED objects

RMAN> list archivelog all;

specification does not match any archived log in the repository


网站标题:rman的crosscheck命令
分享URL:http://bjjierui.cn/article/gehgpd.html

其他资讯