Thứ Sáu, 3 tháng 12, 2021

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')";
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
=============================
* KHOÁ HỌC ORACLE DATABASE A-Z ENTERPRISE trực tiếp từ tôi giúp bạn bước đầu trở thành những chuyên gia DBA, đủ kinh nghiệm đi thi chứng chỉ OA/OCP, đặc biệt là rất nhiều kinh nghiệm, bí kíp thực chiến trên các hệ thống Core tại VN chỉ sau 1 khoá học.
* CÁCH ĐĂNG KÝ: Gõ (.) hoặc để lại số điện thoại hoặc inbox https://m.me/tranvanbinh.vn hoặc Hotline/Zalo 090.29.12.888
* Chi tiết tham khảo:
https://bit.ly/oaz_w
=============================
KẾT NỐI VỚI CHUYÊN GIA TRẦN VĂN BÌNH:
📧 Mail: binhoracle@gmail.com
☎️ Mobile: 0902912888
⚡️ Skype: tranbinh48ca
👨 Facebook: https://www.facebook.com/BinhOracleMaster
👨 Inbox Messenger: https://m.me/101036604657441 (profile)
👨 Fanpage: https://www.facebook.com/tranvanbinh.vn
👨 Inbox Fanpage: https://m.me/tranvanbinh.vn
👨👩 Group FB: https://www.facebook.com/groups/DBAVietNam
👨 Website: https://www.tranvanbinh.vn
👨 Blogger: https://tranvanbinhmaster.blogspot.com
🎬 Youtube: http://bit.ly/ytb_binhoraclemaster
👨 Tiktok: https://www.tiktok.com/@binhoraclemaster?lang=vi
👨 Linkin: https://www.linkedin.com/in/binhoracle
👨 Twitter: https://twitter.com/binhoracle
👨 Địa chỉ: Tòa nhà Sun Square - 21 Lê Đức Thọ - Phường Mỹ Đình 1 - Quận Nam Từ Liêm - TP.Hà Nội

=============================
học oracle database, Tự học Oracle, Tài liệu Oracle 12c tiếng Việt, Hướng dẫn sử dụng Oracle Database, Oracle SQL cơ bản, Oracle SQL là gì, Khóa học Oracle Hà Nội, Học chứng chỉ Oracle ở đầu, Khóa học Oracle online,khóa học pl/sql, học dba, học dba ở việt nam, khóa học dba, khóa học dba sql, tài liệu học dba oracle, Khóa học Oracle online, học oracle sql, học oracle ở đâu tphcm, học oracle bắt đầu từ đâu, học oracle ở hà nội, oracle database tutorial, oracle database 12c, oracle database là gì, oracle database 11g, oracle download, oracle database 19c, oracle dba tutorial, oracle tunning, sql tunning , oracle 12c, oracle multitenant, Container Databases (CDB), Pluggable Databases (PDB), oracle cloud, oracle security, oracle fga, audit_trail, oracle dataguard, oracle goldengate, mview, oracle exadata, oracle weblogic, middleware, hoc solaris, hoc linux, hoc aix, unix, oracle oca, oracle ocp, oracle ocm

ĐỌC NHIỀU

Trần Văn Bình - Oracle Database Master