4.4、RMAN> crosscheck backup of datafile 4 核对特定数据文件的备份集; 4.5、RMAN> crosscheck backup of controlfile 核对控制文件的备份集; 4.6、RMAN> crosscheck backup of spfile 核对SPFILE的备份集; 4.7、RMAN> crosscheck backup of archivelog sequence 3 核对归档日志的备份集; 4.8、RMAN> crosscheck ...
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 copy of archivelog until sequence 12; 2. List相关文件的信息 list backup of {archivelog, controlfile, database, datafile, spfile, tablespace}; list backup of database; --full,incremental,tablespace,datafile 2.1服务器参数文件: list backup of spfile; 2.2控制文件: list backup of controlfile;...
list backup of controlfile; list backup datafile n,n,n; list backup tablespace tablespace_name; 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 ...
提问:为什么有的备份归档日志用list backup of archivelog all查不到,但在第三方备份软件中可以查到? 回答:基于nocatalog的备份管理方式,是将RMAN的备份信息放在控制文件中,由于控制文件的大小不能无限增大,所以在控制文件中只能保留一段时间的备份与恢复信息,而这个时间的控制,由一个参数为参考依据,这个参数就是contro...
List expired backup of archivelog all summary; List backup of tablespace users summary; 1.2.2 按备份类型列出备份 可以使用list backup by file 命令列出每个备份集和备份集片。它可以按数据文件备份,归档日志备份,控制文件和spfile文件备份列出备份信息。 如: ...
02.06 list backup of spfile; 02.07 list backup of archivelog all; list backup of archivelog like '%.log'; list backup of archivelog from time 'sysdate-14'; list backup of archivelog until time 'sysdate-7'; list backup of archivelog from time 'sysdate-14' until time 'sysdate-7'; ...
RMAN>CROSSCHECK BACKUP OF SPFILE; 7、核对归档日志的备份集 RMAN>CROSSCHECK BACKUP OF ARCHIVELOG SEQUENCE 3; 8、核对所有映像副本 RMAN>CROSSCHECK COPY; 9、核对所有数据文件的映像副本 RMAN>CROSSCHECK COPY OF DATABASE; 10、核对特定表空间的映像副本 ...
crosscheck archivelog until sequence 522; RMAN的validate命令 1 validate命令验证备份集片是否能够被还原 2 list backup summary;得到了备份集得主键ID如40,然后validate backupset 40; RMAN的备份保存策略以及change ,delete命令 0.带delete参数的change命令删除备份集,从备份介质,并且从控制文件和恢复目录中删除。
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; ...