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 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, time, until}; 1.List当前RMAN...
RMAN> list backup of spfile; 查看已备份的归档日志信息 RMAN> list backup of archivelog all; RMAN> list backup of archivelog from scn 22727871375; RMAN> list backup of archivelog until scn 22727813497; RMAN> list backup of archivelog from scn 22727031113 until scn 22727268951; RMAN> list 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'; ...
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...
crosscheck backup of controlfile; crosscheck backup tag='SAT_BACKUP'; crosscheck backup completed after 'sysdate - 2' crosscheck backup completed between 'sysdate - 5' and 'sysdate -2 ' crosscheck backup device type sbt; crosscheck archivelog all; ...
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文件备份列出备份信息。 如: ...
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 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; ...