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> cros...
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 incarnation; ...
RMAN> list backup of database; 列出所有数据文件的备份集; RMAN> list backup of tablespace user01; 列出特定表空间的所有数据文件备份集; 3.2、RMAN> list backup of controlfile 列出控制文件备份集; 3.3、RMAN> list backup of archivelog all 列出归档日志备份集详细信息; RMAN>list 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, time, until}; 1.List当前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'; ...
crosscheck archivelog from sequence 12; crosscheck archivelog until sequence 522; RMAN的validate命令 1 validate命令验证备份集片是否能够被还原 2 list backup summary;得到了备份集得主键ID如40,然后validate backupset 40; RMAN的备份保存策略以及change ,delete命令 ...
So, what I want to ask rman is, "what is the last archivelog in the oldest backupset?" All logs older than that can be removed from my remote backup.
RMAN> ALLOCATE CHANNEL FOR MAINTENANCE DEVICE TYPE sbt; allocated channel: ORA_MAINT_SBT_TAPE_1 channel ORA_MAINT_SBT_TAPE_1: SID=103 device type=SBT_TAPE channel ORA_MAINT_SBT_TAPE_1: Oracle Secure Backup RMAN> CROSSCHECK BACKUP OF SPFILE ARCHIVELOG FROM TIME 'SYSDATE-90'; crosschecked b...
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; ...
List expired backup of archivelog all summary; List backup of tablespace users summary; 1.2.2 按备份类型列出备份 可以使用list backup by file 命令列出每个备份集和备份集片。它可以按数据文件备份,归档日志备份,控制文件和spfile文件备份列出备份信息。 如: ...