1 2 Previous Next 20 Replies Latest reply: Apr 30, 2013 4:51 AM by yxes2013 Go to original post RSS
      • 15. Re: What contains the autobackup folder?
        yxes2013
        Thanks salman,
        RMAN> list backup;
        
        
        List of Backup Sets
        ===================
        
        BS Key  Type LV Size       Device Type Elapsed Time Completion Time
        ------- ---- -- ---------- ----------- ------------ ---------------
        4       Full    7.05M      DISK        00:00:01     27-FEB-13
                BP Key: 4   Status: AVAILABLE  Compressed: NO  Tag: TAG20130227T212954
                Piece Name: /usr/tmp/GS/test1/X.dbvisit.abc123.test1.standbycontrolfile
          Standby Control File Included: Ckp SCN: 937225       Ckp time: 27-FEB-13
        
        BS Key  Type LV Size       Device Type Elapsed Time Completion Time
        ------- ---- -- ---------- ----------- ------------ ---------------
        5       Full    7.05M      DISK        00:00:01     27-FEB-13
                BP Key: 5   Status: AVAILABLE  Compressed: NO  Tag: TAG20130227T145223
                Piece Name: /usr/tmp/GS/test1/X.dbvisit.abc124.test1.standbycontrolfile
          Standby Control File Included: Ckp SCN: 959823       Ckp time: 27-FEB-13
        
        BS Key  Type LV Size       Device Type Elapsed Time Completion Time
        ------- ---- -- ---------- ----------- ------------ ---------------
        6       Full    7.05M      DISK        00:00:00     01-MAR-13
                BP Key: 6   Status: AVAILABLE  Compressed: NO  Tag: TAG20130301T182438
                Piece Name: /usr/tmp/GS/test1/X.dbvisit.abc125.test1.standbycontrolfile
          Standby Control File Included: Ckp SCN: 1550323      Ckp time: 01-MAR-13
        
        BS Key  Type LV Size       Device Type Elapsed Time Completion Time
        ------- ---- -- ---------- ----------- ------------ ---------------
        7       Full    7.05M      DISK        00:00:01     01-MAR-13
                BP Key: 7   Status: AVAILABLE  Compressed: NO  Tag: TAG20130301T104547
                Piece Name: /usr/tmp/GS/test1/X.dbvisit.abc126.test1.standbycontrolfile
          Standby Control File Included: Ckp SCN: 1571773      Ckp time: 01-MAR-13
        
        BS Key  Size       Device Type Elapsed Time Completion Time
        ------- ---------- ----------- ------------ ---------------
        26      3.98M      DISK        00:00:02     30-APR-13
                BP Key: 26   Status: AVAILABLE  Compressed: NO  Tag: TAG20130430T143908
                Piece Name: /u01/app/oracle/flash_recovery_area/TEST1/backupset/2013_04_30/o1_mf_annnn_TAG20130430T143908_8qysrfvq_.bkp
        
          List of Archived Logs in backup set 26
          Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
          ---- ------- ---------- --------- ---------- ---------
          1    770     3854100    30-APR-13 3856251    30-APR-13
          1    771     3856251    30-APR-13 3856256    30-APR-13
          1    772     3856256    30-APR-13 3858296    30-APR-13
          1    773     3858296    30-APR-13 3858301    30-APR-13
        
        BS Key  Type LV Size       Device Type Elapsed Time Completion Time
        ------- ---- -- ---------- ----------- ------------ ---------------
        32      Full    4.08G      DISK        00:02:51     30-APR-13
                BP Key: 32   Status: AVAILABLE  Compressed: NO  Tag: TAG20130430T151808
                Piece Name: /u01/app/oracle/flash_recovery_area/TEST1/backupset/2013_04_30/o1_mf_nnndf_TAG20130430T151808_8qyw1k11_.bkp
          List of Datafiles in backup set 32
          File LV Type Ckp SCN    Ckp Time  Name
          ---- -- ---- ---------- --------- ----
          1       Full 3859870    30-APR-13 /u01/app/oracle/oradata/test1/system01.dbf
          2       Full 3859870    30-APR-13 /u01/app/oracle/oradata/test1/undotbs01.dbf
          3       Full 3859870    30-APR-13 /u01/app/oracle/oradata/test1/sysaux01.dbf
          4       Full 3859870    30-APR-13 /u01/app/oracle/oradata/test1/users01.dbf
          5       Full 3859870    30-APR-13 /u01/app/oracle/oradata/test1/example01.dbf
          6       Full 3859870    30-APR-13 /u01/app/oracle/oradata/test1/smttdata.dbf
        
        BS Key  Size       Device Type Elapsed Time Completion Time
        ------- ---------- ----------- ------------ ---------------
        34      1.71M      DISK        00:00:02     30-APR-13
                BP Key: 34   Status: AVAILABLE  Compressed: NO  Tag: TAG20130430T152107
                Piece Name: /u01/app/oracle/flash_recovery_area/TEST1/backupset/2013_04_30/o1_mf_annnn_TAG20130430T152107_8qyw74ql_.bkp
        
          List of Archived Logs in backup set 34
          Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
          ---- ------- ---------- --------- ---------- ---------
          1    774     3858301    30-APR-13 3858988    30-APR-13
          1    775     3858988    30-APR-13 3858993    30-APR-13
          1    776     3858993    30-APR-13 3859998    30-APR-13
          1    777     3859998    30-APR-13 3860003    30-APR-13
        
        BS Key  Type LV Size       Device Type Elapsed Time Completion Time
        ------- ---- -- ---------- ----------- ------------ ---------------
        35      Full    8.08M      DISK        00:00:01     30-APR-13
                BP Key: 35   Status: AVAILABLE  Compressed: NO  Tag: TAG20130430T152109
                Piece Name: /u01/app/oracle/flash_recovery_area/TEST1/autobackup/2013_04_30/o1_mf_s_814116069_8qyw7614_.bkp
          Control File Included: Ckp SCN: 3860009      Ckp time: 30-APR-13
          SPFILE Included: Modification time: 30-APR-13
        
        RMAN>
        Where can I find the "small one" info?
        • 16. Re: What contains the autobackup folder?
          Salman Qureshi
          What about "list backup of archivelog" ?

          Salman
          • 17. Re: What contains the autobackup folder?
            Mahir M. Quluzade
            Controlfile backups size *7.05M*
             RMAN list backup;
             
             
             List of Backup Sets
            
            
             BS Key  Type LV Size       Device Type Elapsed Time Completion Time
             ------- ---- -- ---------- ----------- ------------ ---------------
             4       Full    *7.05M*      DISK        00:00:01     27-FEB-13
                     BP Key: 4   Status: AVAILABLE  Compressed: NO  Tag: TAG20130227T212954
                     Piece Name: /usr/tmp/GS/test1/X.dbvisit.abc123.test1.standbycontrolfile
               Standby Control File Included: Ckp SCN: 937225       Ckp time: 27-FEB-13
             
             BS Key  Type LV Size       Device Type Elapsed Time Completion Time
             ------- ---- -- ---------- ----------- ------------ ---------------
             5       Full    7.05M      DISK        00:00:01     27-FEB-13
                     BP Key: 5   Status: AVAILABLE  Compressed: NO  Tag: TAG20130227T145223
                     Piece Name: /usr/tmp/GS/test1/X.dbvisit.abc124.test1.standbycontrolfile
               Standby Control File Included: Ckp SCN: 959823       Ckp time: 27-FEB-13
             
             BS Key  Type LV Size       Device Type Elapsed Time Completion Time
             ------- ---- -- ---------- ----------- ------------ ---------------
             6       Full    7.05M      DISK        00:00:00     01-MAR-13
                     BP Key: 6   Status: AVAILABLE  Compressed: NO  Tag: TAG20130301T182438
                     Piece Name: /usr/tmp/GS/test1/X.dbvisit.abc125.test1.standbycontrolfile
               Standby Control File Included: Ckp SCN: 1550323      Ckp time: 01-MAR-13
             
             BS Key  Type LV Size       Device Type Elapsed Time Completion Time
             ------- ---- -- ---------- ----------- ------------ ---------------
             7       Full    7.05M      DISK        00:00:01     01-MAR-13
                     BP Key: 7   Status: AVAILABLE  Compressed: NO  Tag: TAG20130301T104547
                     Piece Name: /usr/tmp/GS/test1/X.dbvisit.abc126.test1.standbycontrolfile
               Standby Control File Included: Ckp SCN: 1571773      Ckp time: 01-MAR-13
             
            Archived logs (770 - 773) backup size *3.98M*
             BS Key  Size       Device Type Elapsed Time Completion Time
             ------- ---------- ----------- ------------ ---------------
             26      3.98M      DISK        00:00:02     30-APR-13
                     BP Key: 26   Status: AVAILABLE  Compressed: NO  Tag: TAG20130430T143908
                     Piece Name: /u01/app/oracle/flash_recovery_area/TEST1/backupset/2013_04_30/o1_mf_annnn_TAG20130430T143908_8qysrfvq_.bkp
             
               List of Archived Logs in backup set 26
               Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
               ---- ------- ---------- --------- ---------- ---------
               1    770     3854100    30-APR-13 3856251    30-APR-13
               1    771     3856251    30-APR-13 3856256    30-APR-13
               1    772     3856256    30-APR-13 3858296    30-APR-13
               1    773     3858296    30-APR-13 3858301    30-APR-13
             
            Data files backup size : *4.08G*
             BS Key  Type LV Size       Device Type Elapsed Time Completion Time
             ------- ---- -- ---------- ----------- ------------ ---------------
             32      Full    4.08G      DISK        00:02:51     30-APR-13
                     BP Key: 32   Status: AVAILABLE  Compressed: NO  Tag: TAG20130430T151808
                     Piece Name: /u01/app/oracle/flash_recovery_area/TEST1/backupset/2013_04_30/o1_mf_nnndf_TAG20130430T151808_8qyw1k11_.bkp
               List of Datafiles in backup set 32
               File LV Type Ckp SCN    Ckp Time  Name
               ---- -- ---- ---------- --------- ----
               1       Full 3859870    30-APR-13 /u01/app/oracle/oradata/test1/system01.dbf
               2       Full 3859870    30-APR-13 /u01/app/oracle/oradata/test1/undotbs01.dbf
               3       Full 3859870    30-APR-13 /u01/app/oracle/oradata/test1/sysaux01.dbf
               4       Full 3859870    30-APR-13 /u01/app/oracle/oradata/test1/users01.dbf
               5       Full 3859870    30-APR-13 /u01/app/oracle/oradata/test1/example01.dbf
               6       Full 3859870    30-APR-13 /u01/app/oracle/oradata/test1/smttdata.dbf
             
            Archived logs (774-777) backup size : *1.71M*
             BS Key  Size       Device Type Elapsed Time Completion Time
             ------- ---------- ----------- ------------ ---------------
             34      1.71M      DISK        00:00:02     30-APR-13
                     BP Key: 34   Status: AVAILABLE  Compressed: NO  Tag: TAG20130430T152107
                     Piece Name: /u01/app/oracle/flash_recovery_area/TEST1/backupset/2013_04_30/o1_mf_annnn_TAG20130430T152107_8qyw74ql_.bkp
             
               List of Archived Logs in backup set 34
               Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
               ---- ------- ---------- --------- ---------- ---------
               1    774     3858301    30-APR-13 3858988    30-APR-13
               1    775     3858988    30-APR-13 3858993    30-APR-13
               1    776     3858993    30-APR-13 3859998    30-APR-13
               1    777     3859998    30-APR-13 3860003    30-APR-13
            Controlfile and SPFILE autoback Size : *8.08M*
             
            
             BS Key  Type LV Size       Device Type Elapsed Time Completion Time
             ------- ---- -- ---------- ----------- ------------ ---------------
             35      Full    8.08M      DISK        00:00:01     30-APR-13
                     BP Key: 35   Status: AVAILABLE  Compressed: NO  Tag: TAG20130430T152109
                     Piece Name: /u01/app/oracle/flash_recovery_area/TEST1/autobackup/2013_04_30/o1_mf_s_814116069_8qyw7614_.bkp
               Control File Included: Ckp SCN: 3860009      Ckp time: 30-APR-13
               SPFILE Included: Modification time: 30-APR-13
             
             RMAN
             
            I wrote you backups files and sizes.


            Regards
            Mahir M. Quluzade

            Edited by: Mahir M. Quluzade on Apr 30, 2013 2:02 PM
            • 18. Re: What contains the autobackup folder?
              Hemant K Chitale
              Where can I find the "small one" info?
              Its STARING YOU IN THE FACE. If you care to read the output of your command.


              Hemant K Chitale
              • 19. Re: What contains the autobackup folder?
                yxes2013
                Thanks hem,
                Its STARING YOU IN THE FACE. If you care to read the output of your command.
                Sorry, im color-blind...they look identical to me, they hurt my eyes staring :(
                • 20. Re: What contains the autobackup folder?
                  yxes2013
                  What about "list backup of archivelog" ?
                  Wait... I am testing recovery and still on going....


                  Thanks
                  1 2 Previous Next