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 archivelog all查不到,但在第三方备份软件中仍然可以查到。
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 ...
list backup of archivelog all; list backup of archivelog from scn ...; list backup of archivelog until scn ...; list backup of archivelog from sequence ..; list backup of archivelog until time 'sysdate-10'; list backup of archivelog {all, from, high, like, logseq, low, scn, sequence,...
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'; ...
tablespace user01; 列出特定表空间的所有数据文件备份集；3.2、RMAN> list backup of controlfile 列出控制文件备份集;3.3、RMAN> list backup of archivelog all 列出归档日志备份集详细信息; RMAN>list archivelog all; 列出归档日志备份集简要信息3.4、RMAN> list backup ...
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 backup of archivelog from logseq 25426 until logseq 25428; 列出所有的归档日志 RMAN> list archivelog all; 列出所有失效的归档日志 RMAN>list expired archivelog all; 列出指定表空间的备份信息 RMAN> list copy of tablespace 'SYSTEM'; ...
List backup of database summary; List expired backup of archivelog all summary; List backup of tablespace users summary; 1.2.2 按备份类型列出备份 可以使用list backup by file 命令列出每个备份集和备份集片。它可以按数据文件备份,归档日志备份,控制文件和spfile文件备份列出备份信息。 如: ...
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; ...