list archivelog all 是列出控制文件中记录的未被rman delete 命令删除的手工删除的日志文件,如果手工删除之后使用list命令对应的日志文件的status为标记为X! 模拟删除日志yangdb_1_192_762800109.log oracle@rac3:/opt/oracle/yangdb_arch>mv yangdb_1_192_762800109.log /tmp/ crosscheck 命令检查归档日志的信息:...
list backup of tablespace tablespace_name;--表空间对应的backup 2.5归档日志: list backup of archivelog {all, from, high, like, logseq, low, scn, sequence, time, until}; list backup of archivelog all; list backup of archivelog until time 'sysdate-1'; list backup of archivelog from sequence ...
4.18、RMAN> crosscheck archivelog all; 4.19、RMAN> crosscheck archivelog like '%ARC00012.001' 4.20、RMAN> crosscheck archivelog from sequence 12; 4.21、RMAN> crosscheck archivelog until sequence 522; 5、DELETE:删除备份 5.1、RMAN> delete obsolete; 删除陈旧备份; 5.2、RMAN> delete expired backup; ...
RMAN> list recoverable backup of database; 1.2.5 列出到期的备份 执行list expired backup命令可以列出到期的备份,该命令也可以获得到期的表空间和数据文件的备份列表,如果插入正确的关键字(如: list expired backup of datafile 3 或者 list expired backup of archivelog all),则可以获得到期的归档日志备份和控制...
RMAN> list backup of archivelog from logseq 25426 until logseq 25428; 列出所有的归档日志 RMAN> list archivelog all; 列出所有失效的归档日志 RMAN>list expired archivelog all; 列出指定表空间的备份信息 RMAN> list copy of tablespace 'SYSTEM'; ...
crosscheck archivelog all; crosscheck archivelog like '%ARC00012.001' crosscheck archivelog from sequence 12; crosscheck archivelog until sequence 522; RMAN的validate命令 1 validate命令验证备份集片是否能够被还原 2 list backup summary;得到了备份集得主键ID如40,然后validate backupset 40; RMAN的备份保存策...
rman>list archivelog all; 用list backup of archivelog all命令可查看更详细的归档日志备份。 2.8 列出控制文件和服务器参数文件备份 rman>list backup of controlfile; 3.列出映像副本 列出所有的映像副本使用list copy; 3.1列出数据文件副本 rman>list copy of database; ...
rman>List expired backup; list expired backup of datafile 3或list expired backup of archivelog all,可获得到期的归档日志备份和控制文件/服务参数文件自动备份列表。 2.6按表空间名和数据文件号列出备份 rman>list backup of tablespace users; rman>list backup of datafile 3; ...
to audit my logic to verify that the files I have remotely are managed correctly by my homegrown scripts. "list backup of archivelog all" does tell me what I want to know, but it's messy because of the different tags. Really it's the cleanup of the remote site I'm trying to verify...
RMAN> LIST BACKUP OF DATAFILE 4; Alternatively specify the datafile name. For example: RMAN> LIST BACKUP OF DATAFILE '/u01/app/oradata/TEST/users01.dbf'; To list all existing archivelog backups use: RMAN> LIST BACKUP OF ARCHIVELOG ALL; ...