Oracle RMAN LIST commands ..
some usefull RMAN LIST commands . RMAN> list backup summary; RMAN> list backup of database; RMAN> list backup; RMAN> list backup of pluggable database anuj, anuj1; RMAN> list copy of datafile 2, 3 ,6 ; RMAN> list backup of datafile 4 summary; RMAN> list archivelog all; RMAN> list backup of archivelog all; RMAN> list copy of database archivelog all; RMAN> list incarnation; RMAN> list backup of controlfile; RMAN> list backup of spfile; RMAN> list backup by file; RMAN> list backup by file; RMAN> list backup of datafile 1; RMAN> list expired backup; RMAN> list expired backup summary; RMAN> list expired backup of archivelog all; RMAN> list expired backup of datafile 10; RMAN> list expired backup of archivelog all summary; RMAN> list failure; RMAN> list failure 641231 detail; RMAN> list backup of tablespace anuj summary; RMAN> list backup of tablespace test; RMAN> list backup of archivelog from sequence 55; RMAN> list backupset of datafile 1; RMAN> list recoverable backup; RMAN> LIST CONTROLFILECOPY "/tmp/cntrlfile.copy"; RMAN> LIST BACKUPSET OF DATAFILE 1; RMAN> LIST backup tag 'ORCLEE_FULL'; RMAN> LIST BACKUPPIECE ' '; RMAN> LIST BACKUP RECOVERABLE; RMAN> list backup of archivelog from scn 853145 until scn 854039; RMAN> LIST DATAFILECOPY '/u01/app/oracle/copy/users01.dbf'; RMAN> LIST COPY OF CONTROLFILE; RMAN> list archivelog all backed up 1 times to disk; RMAN> list backup of archivelog from scn 901427; RMAN> list incarnation of database anuj ; List of Database Incarnations DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time ------- ------- -------- ---------------- --- ---------- ---------- 1 1 ANUJ 3057090325 PARENT 1 25-DEC-16 16:28:05 2 2 ANUJ 3057090325 CURRENT 825576 25-DEC-16 18:25:29 =========== export NLS_DATE_FORMAT='DD-MON-YY HH24:MI:SS' list backup of archivelog all RMAN> LIST BACKUP OF ARCHIVELOG FROM SEQUENCE 220; RMAN>list backup of archivelog sequence 89961 thread 2; RMAN> LIST BACKUP OF ARCHIVELOG ; list backup of tablespace users ; list backup of database device type disk; list copy of database completed between '01-AUGUST-2017' and '08-AUGUST-2017'; list copy of database completed between '01-AUGUST-2017' and '08-AUGUST-2017'; list backup of database completed between '01-AUGUST-2017' and '08-AUGUST-2017'; xx RMAN> list backup of datafile; RMAN> list backupset tag 'T2017'; List of Backup Sets =================== BS Key Size Device Type Elapsed Time Completion Time ------- ---------- ----------- ------------ --------------- 184 299.57M DISK 00:00:42 17-AUG-17 BP Key: 184 Status: AVAILABLE Compressed: YES Tag: TAG20170817T010006 Piece Name: /dumps/ICRAC/20170817_icrac1_186_1_952218007 List of Archived Logs in backup set 184 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- --------- ---------- --------- 1 259 22824594 16-AUG-17 22847740 16-AUG-17 1 260 22847740 16-AUG-17 22934969 17-AUG-17 2 239 22723071 16-AUG-17 22847951 16-AUG-17 2 240 22847951 16-AUG-17 22923793 17-AUG-17 2 241 22923793 17-AUG-17 22935012 17-AUG-17 RMAN> LIST BACKUP OF ARCHIVELOG FROM TIME "SYSDATE-1"; List of Backup Sets =================== BS Key Size Device Type Elapsed Time Completion Time ------- ---------- ----------- ------------ --------------- 184 299.57M DISK 00:00:42 17-AUG-17 BP Key: 184 Status: AVAILABLE Compressed: YES Tag: TAG20170817T010006 Piece Name: /dumps/ICRAC/20170817_icrac1_186_1_952218007 List of Archived Logs in backup set 184 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- --------- ---------- --------- 1 257 22723067 16-AUG-17 22798860 16-AUG-17 1 258 22798860 16-AUG-17 22824594 16-AUG-17 1 259 22824594 16-AUG-17 22847740 16-AUG-17 1 260 22847740 16-AUG-17 22934969 17-AUG-17 2 239 22723071 16-AUG-17 22847951 16-AUG-17 2 240 22847951 16-AUG-17 22923793 17-AUG-17 2 241 22923793 17-AUG-17 22935012 17-AUG-17 full backup info RMAN> list backup of database summary completed after 'sysdate - 7'; List of Backups =============== Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag ------- -- -- - ----------- ------------------ ------- ------- ---------- --- 6 B F A DISK 02-SEP-17 13:10:39 1 1 YES ORCLEE_FULL RMAN> list backup of controlfile ; List of Backup Sets =================== BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ ------------------ 7 Full 9.36M DISK 00:00:01 02-SEP-17 13:10:50 BP Key: 7 Status: AVAILABLE Compressed: NO Tag: TAG20170902T131049 Piece Name: /u01/app/RmanBackup/c-3057090325-20170902-02 Control File Included: Ckp SCN: 854026 Ckp time: 02-SEP-17 13:10:49 ========== Recovery Manager complete. [oracle@oraasm11g ~]$ export NLS_DATE_FORMAT='DD-MON-YY HH24:MI:SS' [oracle@oraasm11g ~]$ rman target / RMAN> list incarnation of database anuj ; List of Database Incarnations DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time ------- ------- -------- ---------------- --- ---------- ---------- 1 1 ANUJ 3057090325 PARENT 1 25-DEC-16 16:28:05 2 2 ANUJ 3057090325 CURRENT 825576 25-DEC-16 18:25:29 RMAN> list backup summary; using target database control file instead of recovery catalog List of Backups =============== Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag ------- -- -- - ----------- --------------- ------- ------- ---------- --- 6 B F A DISK 02-SEP-17 1 1 YES ORCLEE_FULL 7 B F A DISK 02-SEP-17 1 1 NO TAG20170902T131049 8 B A A DISK 02-SEP-17 1 1 NO ORCLEE_ARCHIVE RMAN> list backup ; List of Backup Sets =================== BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 6 Full 223.16M DISK 00:00:45 02-SEP-17 BP Key: 6 Status: AVAILABLE Compressed: YES Tag: ORCLEE_FULL Piece Name: /u01/app/RmanBackup/ANUJ_20170902_11_1_FULL List of Datafiles in backup set 6 File LV Type Ckp SCN Ckp Time Name ---- -- ---- ---------- --------- ---- 1 Full 854000 02-SEP-17 +DATA/anuj/datafile/system.268.931544353 2 Full 854000 02-SEP-17 +DATA/anuj/datafile/sysaux.270.931544485 3 Full 854000 02-SEP-17 +DATA/anuj/datafile/undotbs1.269.931544399 4 Full 854000 02-SEP-17 +DATA/anuj/datafile/users.272.931544539 BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 7 Full 9.36M DISK 00:00:01 02-SEP-17 BP Key: 7 Status: AVAILABLE Compressed: NO Tag: TAG20170902T131049 Piece Name: /u01/app/RmanBackup/c-3057090325-20170902-02 SPFILE Included: Modification time: 02-SEP-17 SPFILE db_unique_name: ANUJ Control File Included: Ckp SCN: 854026 Ckp time: 02-SEP-17 BS Key Size Device Type Elapsed Time Completion Time ------- ---------- ----------- ------------ --------------- 8 291.50K DISK 00:00:00 02-SEP-17 BP Key: 8 Status: AVAILABLE Compressed: NO Tag: ORCLEE_ARCHIVE Piece Name: /u01/app/RmanBackup/ANUJ_20170902_13_1_ARCHIVE List of Archived Logs in backup set 8 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- --------- ---------- --------- 1 5 853145 02-SEP-17 853302 02-SEP-17 1 6 853302 02-SEP-17 853310 02-SEP-17 1 7 853310 02-SEP-17 854039 02-SEP-17 1 8 854039 02-SEP-17 854047 02-SEP-17 RMAN> list backup of database; List of Backup Sets =================== BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 6 Full 223.16M DISK 00:00:45 02-SEP-17 BP Key: 6 Status: AVAILABLE Compressed: YES Tag: ORCLEE_FULL Piece Name: /u01/app/RmanBackup/ANUJ_20170902_11_1_FULL List of Datafiles in backup set 6 File LV Type Ckp SCN Ckp Time Name ---- -- ---- ---------- --------- ---- 1 Full 854000 02-SEP-17 +DATA/anuj/datafile/system.268.931544353 2 Full 854000 02-SEP-17 +DATA/anuj/datafile/sysaux.270.931544485 3 Full 854000 02-SEP-17 +DATA/anuj/datafile/undotbs1.269.931544399 4 Full 854000 02-SEP-17 +DATA/anuj/datafile/users.272.931544539 RMAN> list backup; List of Backup Sets =================== BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 6 Full 223.16M DISK 00:00:45 02-SEP-17 BP Key: 6 Status: AVAILABLE Compressed: YES Tag: ORCLEE_FULL Piece Name: /u01/app/RmanBackup/ANUJ_20170902_11_1_FULL List of Datafiles in backup set 6 File LV Type Ckp SCN Ckp Time Name ---- -- ---- ---------- --------- ---- 1 Full 854000 02-SEP-17 +DATA/anuj/datafile/system.268.931544353 2 Full 854000 02-SEP-17 +DATA/anuj/datafile/sysaux.270.931544485 3 Full 854000 02-SEP-17 +DATA/anuj/datafile/undotbs1.269.931544399 4 Full 854000 02-SEP-17 +DATA/anuj/datafile/users.272.931544539 BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 7 Full 9.36M DISK 00:00:01 02-SEP-17 BP Key: 7 Status: AVAILABLE Compressed: NO Tag: TAG20170902T131049 Piece Name: /u01/app/RmanBackup/c-3057090325-20170902-02 SPFILE Included: Modification time: 02-SEP-17 SPFILE db_unique_name: ANUJ Control File Included: Ckp SCN: 854026 Ckp time: 02-SEP-17 BS Key Size Device Type Elapsed Time Completion Time ------- ---------- ----------- ------------ --------------- 8 291.50K DISK 00:00:00 02-SEP-17 BP Key: 8 Status: AVAILABLE Compressed: NO Tag: ORCLEE_ARCHIVE Piece Name: /u01/app/RmanBackup/ANUJ_20170902_13_1_ARCHIVE List of Archived Logs in backup set 8 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- --------- ---------- --------- 1 5 853145 02-SEP-17 853302 02-SEP-17 1 6 853302 02-SEP-17 853310 02-SEP-17 1 7 853310 02-SEP-17 854039 02-SEP-17 1 8 854039 02-SEP-17 854047 02-SEP-17 RMAN> list archivelog all; specification does not match any archived log in the repository RMAN> list backup of archivelog all; List of Backup Sets =================== BS Key Size Device Type Elapsed Time Completion Time ------- ---------- ----------- ------------ --------------- 8 291.50K DISK 00:00:00 02-SEP-17 BP Key: 8 Status: AVAILABLE Compressed: NO Tag: ORCLEE_ARCHIVE Piece Name: /u01/app/RmanBackup/ANUJ_20170902_13_1_ARCHIVE List of Archived Logs in backup set 8 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- --------- ---------- --------- 1 5 853145 02-SEP-17 853302 02-SEP-17 1 6 853302 02-SEP-17 853310 02-SEP-17 1 7 853310 02-SEP-17 854039 02-SEP-17 1 8 854039 02-SEP-17 854047 02-SEP-17 RMAN> list backup of archivelog from sequence 4; List of Backup Sets =================== BS Key Size Device Type Elapsed Time Completion Time ------- ---------- ----------- ------------ ------------------ 8 291.50K DISK 00:00:00 02-SEP-17 13:10:54 BP Key: 8 Status: AVAILABLE Compressed: NO Tag: ORCLEE_ARCHIVE Piece Name: /u01/app/RmanBackup/ANUJ_20170902_13_1_ARCHIVE List of Archived Logs in backup set 8 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- ------------------ ---------- --------- 1 5 853145 02-SEP-17 12:54:24 853302 02-SEP-17 12:58:27 1 6 853302 02-SEP-17 12:58:27 853310 02-SEP-17 12:58:27 1 7 853310 02-SEP-17 12:58:27 854039 02-SEP-17 13:10:52 1 8 854039 02-SEP-17 13:10:52 854047 02-SEP-17 13:10:54 RMAN> list incarnation; List of Database Incarnations DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time ------- ------- -------- ---------------- --- ---------- ---------- 1 1 ANUJ 3057090325 PARENT 1 25-DEC-16 2 2 ANUJ 3057090325 CURRENT 825576 25-DEC-16 RMAN> list backup of datafile 1; List of Backup Sets =================== BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 6 Full 223.16M DISK 00:00:45 02-SEP-17 BP Key: 6 Status: AVAILABLE Compressed: YES Tag: ORCLEE_FULL Piece Name: /u01/app/RmanBackup/ANUJ_20170902_11_1_FULL List of Datafiles in backup set 6 File LV Type Ckp SCN Ckp Time Name ---- -- ---- ---------- --------- ---- 1 Full 854000 02-SEP-17 +DATA/anuj/datafile/system.268.931544353 RMAN> list backup of controlfile ; List of Backup Sets =================== BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ ------------------ 7 Full 9.36M DISK 00:00:01 02-SEP-17 13:10:50 BP Key: 7 Status: AVAILABLE Compressed: NO Tag: TAG20170902T131049 Piece Name: /u01/app/RmanBackup/c-3057090325-20170902-02 Control File Included: Ckp SCN: 854026 Ckp time: 02-SEP-17 13:10:49 RMAN> list backup of spfile; List of Backup Sets =================== BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ ------------------ 7 Full 9.36M DISK 00:00:01 02-SEP-17 13:10:50 BP Key: 7 Status: AVAILABLE Compressed: NO Tag: TAG20170902T131049 Piece Name: /u01/app/RmanBackup/c-3057090325-20170902-02 SPFILE Included: Modification time: 02-SEP-17 12:53:04 SPFILE db_unique_name: ANUJ RMAN> list backup by file; List of Datafile Backups ======================== File Key TY LV S Ckp SCN Ckp Time #Pieces #Copies Compressed Tag ---- ------- - -- - ---------- ------------------ ------- ------- ---------- --- 1 6 B F A 854000 02-SEP-17 13:09:54 1 1 YES ORCLEE_FULL 2 6 B F A 854000 02-SEP-17 13:09:54 1 1 YES ORCLEE_FULL 3 6 B F A 854000 02-SEP-17 13:09:54 1 1 YES ORCLEE_FULL 4 6 B F A 854000 02-SEP-17 13:09:54 1 1 YES ORCLEE_FULL List of Archived Log Backups ============================ Thrd Seq Low SCN Low Time BS Key S #Pieces #Copies Compressed Tag ---- ------- ---------- ------------------ ------- - ------- ------- ---------- --- 1 5 853145 02-SEP-17 12:54:24 8 A 1 1 NO ORCLEE_ARCHIVE 1 6 853302 02-SEP-17 12:58:27 8 A 1 1 NO ORCLEE_ARCHIVE 1 7 853310 02-SEP-17 12:58:27 8 A 1 1 NO ORCLEE_ARCHIVE 1 8 854039 02-SEP-17 13:10:52 8 A 1 1 NO ORCLEE_ARCHIVE List of Control File Backups ============================ CF Ckp SCN Ckp Time BS Key S #Pieces #Copies Compressed Tag ---------- ------------------ ------- - ------- ------- ---------- --- 854026 02-SEP-17 13:10:49 7 A 1 1 NO TAG20170902T131049 List of SPFILE Backups ====================== Modification Time BS Key S #Pieces #Copies Compressed Tag ------------------ ------- - ------- ------- ---------- --- 02-SEP-17 12:53:04 7 A 1 1 NO TAG20170902T131049 RMAN> LIST backup tag 'ORCLEE_FULL'; List of Backup Sets =================== BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ ------------------ 6 Full 223.16M DISK 00:00:45 02-SEP-17 13:10:39 BP Key: 6 Status: AVAILABLE Compressed: YES Tag: ORCLEE_FULL Piece Name: /u01/app/RmanBackup/ANUJ_20170902_11_1_FULL List of Datafiles in backup set 6 File LV Type Ckp SCN Ckp Time Name ---- -- ---- ---------- ------------------ ---- 1 Full 854000 02-SEP-17 13:09:54 +DATA/anuj/datafile/system.268.931544353 2 Full 854000 02-SEP-17 13:09:54 +DATA/anuj/datafile/sysaux.270.931544485 3 Full 854000 02-SEP-17 13:09:54 +DATA/anuj/datafile/undotbs1.269.931544399 4 Full 854000 02-SEP-17 13:09:54 +DATA/anuj/datafile/users.272.931544539 RMAN> list recoverable backup; List of Backup Sets =================== BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ ------------------ 6 Full 223.16M DISK 00:00:45 02-SEP-17 13:10:39 BP Key: 6 Status: AVAILABLE Compressed: YES Tag: ORCLEE_FULL Piece Name: /u01/app/RmanBackup/ANUJ_20170902_11_1_FULL List of Datafiles in backup set 6 File LV Type Ckp SCN Ckp Time Name ---- -- ---- ---------- ------------------ ---- 1 Full 854000 02-SEP-17 13:09:54 +DATA/anuj/datafile/system.268.931544353 2 Full 854000 02-SEP-17 13:09:54 +DATA/anuj/datafile/sysaux.270.931544485 3 Full 854000 02-SEP-17 13:09:54 +DATA/anuj/datafile/undotbs1.269.931544399 4 Full 854000 02-SEP-17 13:09:54 +DATA/anuj/datafile/users.272.931544539 BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ ------------------ 7 Full 9.36M DISK 00:00:01 02-SEP-17 13:10:50 BP Key: 7 Status: AVAILABLE Compressed: NO Tag: TAG20170902T131049 Piece Name: /u01/app/RmanBackup/c-3057090325-20170902-02 SPFILE Included: Modification time: 02-SEP-17 12:53:04 SPFILE db_unique_name: ANUJ Control File Included: Ckp SCN: 854026 Ckp time: 02-SEP-17 13:10:49 BS Key Size Device Type Elapsed Time Completion Time ------- ---------- ----------- ------------ ------------------ 8 291.50K DISK 00:00:00 02-SEP-17 13:10:54 BP Key: 8 Status: AVAILABLE Compressed: NO Tag: ORCLEE_ARCHIVE Piece Name: /u01/app/RmanBackup/ANUJ_20170902_13_1_ARCHIVE List of Archived Logs in backup set 8 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- ------------------ ---------- --------- 1 5 853145 02-SEP-17 12:54:24 853302 02-SEP-17 12:58:27 1 6 853302 02-SEP-17 12:58:27 853310 02-SEP-17 12:58:27 1 7 853310 02-SEP-17 12:58:27 854039 02-SEP-17 13:10:52 1 8 854039 02-SEP-17 13:10:52 854047 02-SEP-17 13:10:54 RMAN> list backup of archivelog from scn 853145 until scn 854039; List of Backup Sets =================== BS Key Size Device Type Elapsed Time Completion Time ------- ---------- ----------- ------------ ------------------ 8 291.50K DISK 00:00:00 02-SEP-17 13:10:54 BP Key: 8 Status: AVAILABLE Compressed: NO Tag: ORCLEE_ARCHIVE Piece Name: /u01/app/RmanBackup/ANUJ_20170902_13_1_ARCHIVE List of Archived Logs in backup set 8 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- ------------------ ---------- --------- 1 5 853145 02-SEP-17 12:54:24 853302 02-SEP-17 12:58:27 1 6 853302 02-SEP-17 12:58:27 853310 02-SEP-17 12:58:27 1 7 853310 02-SEP-17 12:58:27 854039 02-SEP-17 13:10:52 RMAN> list backupset 8; List of Backup Sets =================== BS Key Size Device Type Elapsed Time Completion Time ------- ---------- ----------- ------------ ------------------ 8 291.50K DISK 00:00:00 02-SEP-17 13:10:54 BP Key: 8 Status: AVAILABLE Compressed: NO Tag: ORCLEE_ARCHIVE Piece Name: /u01/app/RmanBackup/ANUJ_20170902_13_1_ARCHIVE List of Archived Logs in backup set 8 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- ------------------ ---------- --------- 1 5 853145 02-SEP-17 12:54:24 853302 02-SEP-17 12:58:27 1 6 853302 02-SEP-17 12:58:27 853310 02-SEP-17 12:58:27 1 7 853310 02-SEP-17 12:58:27 854039 02-SEP-17 13:10:52 1 8 854039 02-SEP-17 13:10:52 854047 02-SEP-17 13:10:54 RMAN> list backup of datafile 1 completed between '01-sep-2017' and 'sysdate'; RMAN> list backup of datafile 1 completed between '01-sep-2017' and 'sysdate'; List of Backup Sets =================== BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ ------------------ 6 Full 223.16M DISK 00:00:45 02-SEP-17 13:10:39 BP Key: 6 Status: AVAILABLE Compressed: YES Tag: ORCLEE_FULL Piece Name: /u01/app/RmanBackup/ANUJ_20170902_11_1_FULL List of Datafiles in backup set 6 File LV Type Ckp SCN Ckp Time Name ---- -- ---- ---------- ------------------ ---- 1 Full 854000 02-SEP-17 13:09:54 +DATA/anuj/datafile/system.268.931544353 w List Command with Date ( All are tested ) RMAN> list backup of datafile 1 completed between '07-jan-2012' and 'sysdate'; RMAN> list backup of archivelog from time "to_date('01/08/2017 22:00:00', 'dd/mm/yyyy hh24:mi:ss')" until time "to_date('08/08/2017 04:00:00', 'dd/mm/yyyy hh24:mi:ss')"; RMAN> list backup of archivelog time between "to_date('01-AUG-2017 00:00:00','DD-MON-YYYY HH24:MI:SS')" and "to_date('08-AUG-2017 00:00:00','DD-MON-YYYY HH24:MI:SS')"; RMAN> list backup of archivelog time between "to_date('01/08/2017','dd/mm/yyyy')" and "to_date('09/08/2017','dd/mm/yyyy')"; RMAN> list backup of database completed between "to_date('01/08/2017','dd/mm/yyyy')" and "to_date('08/08/2017','dd/mm/yyyy')"; RMAN> list backup of archivelog from time "to_date('01-08-2017','mm-dd-yyyy')"; RMAN> list backup of database completed between 'sysdate -7' and 'sysdate'; RMAN> list backup completed between 'sysdate -14' and 'sysdate'; RMAN> list backup completed between 'sysdate -14' and 'sysdate -7'; RMAN> list backup of spfile time between "to_date('01-AUG-2017 00:00:00','DD-MON-YYYY HH24:MI:SS')" and "to_date('08-AUG-2017 00:00:00','DD-MON-YYYY HH24:MI:SS')"; RMAN> list backup of database completed between "to_date('06/17/2010','mm/dd/yyyy')" and "to_date('06/19/2010','mm/dd/yyyy')"; RMAN> list backup of database completed between "to_date('01/08/2017','dd/mm/yyyy')" and "to_date('09/08/2017','dd/mm/yyyy')"; RMAN> list backup of archivelog time between "to_date('20-MAR-2013 00:00:00','DD-MON-YYYY HH24:MI:SS')" and "to_date('25-MAR-2013 00:00:00','DD-MON-YYYY HH24:MI:SS')"; RMAN> list backup of archivelog time between "to_date('01/08/2017','dd/mm/yyyy')" and "to_date('09/09/2017','dd/mm/yyyy')"; RMAN> LIST backup of database completed after "to_date('01/08/2017','mm/dd/yyyy')"; RMAN> list backup of archivelog from time "to_date('01/08/2017 22:00:00', 'dd/mm/yyyy hh24:mi:ss')" until time "to_date('08/08/2017 04:00:00', 'dd/mm/yyyy hh24:mi:ss')"; RMAN> LIST BACKUP OF ARCHIVELOG FROM TIME "TO_DATE('08/16/2017 22:00:00', 'MM/DD/YYYY hh24:mi:ss')" UNTIL TIME "TO_DATE('08/17/2017 03:00:00', 'MM/DD/YYYY hh24:mi:ss')";
export NLS_DATE_FORMAT='DD-MON-YYYY HH24:MI:SS'
LIST BACKUP OF ARCHIVELOG FROM TIME "TO_DATE('06/17/2023 22:00:00', 'MM/DD/YYYY hh24:mi:ss')" UNTIL TIME "TO_DATE('06/18/2023 03:00:00', 'MM/DD/YYYY hh24:mi:ss')";
for SUMMARY
RMAN> LIST BACKUP SUMMARY COMPLETED BETWEEN "to_date('10-JAN-2022 05:00:00','DD-MON-YYYY HH24:MI:SS')" and "to_date('14-JAN-2022 07:00:00','DD-MON-YYYY HH24:MI:SS')";
RMAN> LIST BACKUP OF ARCHIVELOG FROM TIME 'sysdate-1' UNTIL TIME 'SYSDATE'; ======================== RMAN>report need backup days=2; RMAN> report unrecoverable; REPORT NEED BACKUP RECOVERY WINDOW OF n DAYS Displays objects requiring backup to satisfy a recovery window-based retention policy. REPORT NEED BACKUP REDUNDANCY n Displays objects requiring backup to satisfy a redundancy-based retention policy. REPORT NEED BACKUP DAYS n Displays files that require more than n days' worth of archived redo log files for recovery. REPORT NEED BACKUP INCREMENTAL n Displays files that require application of more than n incremental backups for recovery. RMAN> report schema ; RMAN-06139: WARNING: control file is not current for REPORT SCHEMA Report of database schema for database with db_unique_name ANUJ List of Permanent Datafiles =========================== File Size(MB) Tablespace RB segs Datafile Name ---- -------- -------------------- ------- ------------------------ 1 0 SYSTEM *** +DATA/anuj/datafile/system.268.931544353 2 0 SYSAUX *** +DATA/anuj/datafile/sysaux.270.931544485 3 0 UNDOTBS1 *** +DATA/anuj/datafile/undotbs1.269.931544399 4 0 USERS *** +DATA/anuj/datafile/users.272.931544539 List of Temporary Files ======================= File Size(MB) Tablespace Maxsize(MB) Tempfile Name ---- -------- -------------------- ----------- -------------------- 2 256 TEMP2 256 +DATA/anuj/tempfile/temp2.277.931545697
=========
RMAN> list backup of pluggable database 'PDB$SEED' summary;
using target database control file instead of recovery catalog
List of Backups
===============
Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- ------------------- ------- ------- ---------- ---
1967 B 0 A DISK 03-04-2022 02:08:44 1 1 YES TAG20220403T020100
1999 B 0 A DISK 10-04-2022 02:08:41 1 1 YES TAG20220410T020100
export NLS_DATE_FORMAT='dd-mm-yyyy hh24:mi:ss';
LIST BACKUP OF ARCHIVELOG TIME BETWEEN "to_date('27-MAR-2023 09:00:00','DD-MON-YYYY HH24:MI:SS')" and "to_date('28-MAR-2023 09:00:00','DD-MON-YYYY HH24:MI:SS')";
LIST BACKUP SUMMARY COMPLETED BETWEEN "to_date('27-MAR-2023 09:00:00','DD-MON-YYYY HH24:MI:SS')" and "to_date('28-MAR-2023 09:00:00','DD-MON-YYYY HH24:MI:SS')";
===
export NLS_DATE_FORMAT='DD/MM/YYYY hh24:mi:ss'
rman target / catalog prod_23/xxxx@rmancatalog
list backup of database completed between "to_date('01/04/2023','DD/MM/YYYY')" and "to_date('22/04/2023','DD/MM/YYYY')";
LIST backup of database completed after "to_date('01/04/2023','DD/MM/YYYY')";
list backup of datafile 1 completed after "to_date('01/04/2023','DD/MM/YYYY')";
list until time "to_date('01/04/2023','DD/MM/YYYY')" backupset of tablespace system;
list backup of tablespace system completed after "to_date('01/04/2023','DD/MM/YYYY')";
5 comments:
list backupset of database;
LIST RESTORE POINT restore_point_name;
LIST RESTORE POINT ALL;
run
{
allocate channel ch1 device type disk format '/u01/MRAC/%d_%s_%p_%c_%t.arc.bkp';
set archivelog destination to '/tmp';
restore archivelog logseq 36 thread 2;
release channel ch1;
}
tmp]$ date
Sun Jun 17 05:52:41 EDT 2018
tmp]$ pwd
/tmp
oracle oinstall 183991808 Jun 17 05:51 2_36_977670520.dbf
for archive log
LIST BACKUP OF ARCHIVELOG FROM SEQUENCE 36 thread 2;
LIST BACKUP OF ARCHIVELOG SEQUENCE 36 thread 2;
LIST BACKUP OF ARCHIVELOG FROM SEQUENCE 570799 summary ;
Hey, I read your review it is really awesome memorysafex-review
Post a Comment