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命令-创新互联
本文路径:http://scyanting.com/article/spged.html
手动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命令-创新互联
本文路径:http://scyanting.com/article/spged.html