BP Key: 191 Status: AVAILABLE Compressed: NO Tag: TAG20111219T144042 Piece Name: /opt/oracle/flash_recovery_area/YANGDB/backupset/2011_12_19/o1_mf_annnn_TAG20111219T144042_7gxq3b2n_.bkp List of Archived Logs in backup set 191 Thrd Seq Low SCN Low Time Next SCN Next Time --- --- ...
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; 列出...
RMAN> list backup of archivelog until scn 22727813497; RMAN> list backup of archivelog from scn 22727031113 until scn 22727268951; RMAN> list backup of archivelog from logseq 25432; RMAN> list backup of archivelog until logseq 25432; RMAN> list backup of archivelog from logseq 25426 until logseq ...
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 of archivelog from logseq 25432; RMAN> list backup of ...
RMAN> list backupset tage 'TAG20160811T000724' 列出所有备份的控制文件信息 RMAN> list backup of controlfile; 列出备份的spfile文件信息 RMAN> list backup of spfile; 查看已备份的归档日志信息 RMAN> list backup of archivelog all; RMAN> list backup of archivelog from scn 22727871375; ...
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; ...
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; ...
オブジェクトを指定しなければ、LISTではデフォルトでOF DATABASE CONTROLFILE ARCHIVELOG ALLが使用されます。 ノート: LIST BACKUP ... LIKEコマンドは有効ではありません。ただし、LIST BACKUP OF ARCHIVELOG LIKEのみは有効です。 関連項目: 「listObjList」を参照してください listBackup...
16RMAN>listbackup;ListofBackupSets===BSKeyTypeLV Size DeviceTypeElapsedTimeCompletionTime--- --- -- --- --- --- ---5Full202.54MDISK00:00:1105-SEP-16BPKey:5Status: AVAILABLE Compressed:NOTag: TAG20160905T152357 Piece Name:/u01/app/database/dbs/06rf26kf_1_1 ListofDatafilesinbackupset...