4 Replies Latest reply: Nov 14, 2012 11:56 AM by Shivananda Rao RSS

    Identify Backup Pieces

    895327
      Just took a backup so I can move my database to another new server running a fresh installation of 11g R2. I did:
      backup full as compressed backupset database plus archivelog delete input;
      Now I check to see the backups:
      RMAN> list backup of database 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
      ------- -- -- - ----------- --------------- ------- ------- ---------- ---
      147     B  F  A DISK        08-NOV-12       1       1       YES        TAG20121108T171127
      149     B  F  A DISK        09-NOV-12       1       1       YES        TAG20121109T091126
      So I'm guessing my entire database is on key 149 which I backed up Friday 11/9. Now I need to verify where this file is so I can move it to the new server:
      RMAN> list backupset 149;
      
      
      List of Backup Sets
      ===================
      
      
      BS Key  Type LV Size       Device Type Elapsed Time Completion Time
      ------- ---- -- ---------- ----------- ------------ ---------------
      149     Full    2.22G      DISK        00:28:32     09-NOV-12      
              BP Key: 149   Status: AVAILABLE  Compressed: YES  Tag: TAG20121109T091126
              Piece Name: /oracle/u01/app/oracle/backup/7anps3hu_1_1
        List of Datafiles in backup set 149
        File LV Type Ckp SCN    Ckp Time  Name
        ---- -- ---- ---------- --------- ----
        1       Full 175726639  09-NOV-12 /oracle/u01/app/oracle/oradata/cqdb/system01.dbf
        2       Full 175726639  09-NOV-12 /oracle/u01/app/oracle/oradata/cqdb/sysaux01.dbf
        3       Full 175726639  09-NOV-12 /oracle/u01/app/oracle/oradata/cqdb/undotbs01.dbf
        4       Full 175726639  09-NOV-12 /oracle/u01/app/oracle/oradata/cqdb/users01.dbf
        5       Full 175726639  09-NOV-12 /oracle/u01/app/oracle/oradata/cqdb/CQ_REPOSITORY_TBSP
        6       Full 175726639  09-NOV-12 /oracle/u01/app/oracle/oradata/cqdb/CQ_USER_TBSP
        7       Full 175726639  09-NOV-12 /oracle/u01/app/oracle/oradata/cqdb/CQ_TEST_TBSP
        8       Full 175726639  09-NOV-12 /oracle/u01/app/oracle/oradata/cqdb/CQ_TEST1_TBSP
        9       Full 175726639  09-NOV-12 /oracle/u01/app/oracle/oradata/cqdb/CQ_TEST2_TBSP
        10      Full 175726639  09-NOV-12 /oracle/u01/app/oracle/oradata/cqdb/CQ1_PTR_TBSP
        11      Full 175726639  09-NOV-12 /oracle/u01/app/oracle/oradata/cqdb/CQ1_AI_TBSP
        12      Full 175726639  09-NOV-12 /oracle/u01/app/oracle/oradata/cqdb/CQ1_PR_TBSP
        13      Full 175726639  09-NOV-12 /oracle/u01/app/oracle/oradata/cqdb/CQ1_PM_TBSP
        14      Full 175726639  09-NOV-12 /oracle/u01/app/oracle/oradata/cqdb/CQ1_AW_TBSP
        15      Full 175726639  09-NOV-12 /oracle/u01/app/oracle/oradata/cqdb/CQ1_FCS_TBSP
        16      Full 175726639  09-NOV-12 /oracle/u01/app/oracle/oradata/cqdb/CQ1_FCSPTR
        17      Full 175726639  09-NOV-12 /oracle/u01/app/oracle/oradata/cqdb/CQ1_FCSPR
        18      Full 175726639  09-NOV-12 /oracle/u01/app/oracle/oradata/cqdb/CQ1_CTIA_BCR_TBSP
        19      Full 175726639  09-NOV-12 /oracle/u01/app/oracle/oradata/cqdb/CQ1_FCS_BCR_TBSP
        20      Full 175726639  09-NOV-12 /oracle/u01/app/oracle/oradata/cqdb/CQ1_SP
        21      Full 175726639  09-NOV-12 /oracle/u01/app/oracle/oradata/cqdb/CQ1_LMSTS_TBSP
        22      Full 175726639  09-NOV-12 /oracle/u01/app/oracle/oradata/cqdb/CQ1_FCS_PTR_TBSP
        23      Full 175726639  09-NOV-12 /oracle/u01/app/oracle/oradata/cqdb/CTS_TBSP
        24      Full 175726639  09-NOV-12 /oracle/u01/app/oracle/oradata/cqdb/CQSCHEMA
        25      Full 175726639  09-NOV-12 /oracle/u01/app/oracle/oradata/cqdb/CTCPPR
        26      Full 175726639  09-NOV-12 /oracle/u01/app/oracle/oradata/cqdb/ts_duke_data_1_TBSP
        27      Full 175726639  09-NOV-12 /oracle/u01/app/oracle/oradata/cqdb/ts_duke_index_1_TBSP
        28      Full 175726639  09-NOV-12 /oracle/u01/app/oracle/oradata/cqdb/ts_castle_data_1_TBSP
        29      Full 175726639  09-NOV-12 /oracle/u01/app/oracle/oradata/cqdb/ts_gdtest_data_TBSP
        30      Full 175726639  09-NOV-12 /oracle/u01/app/oracle/oradata/cqdb/CPM_REPOSITORY_TBSP
      So based on the above, I can assume that the file with all my database data is '/oracle/u01/app/oracle/backup/7anps3hu_1_1', right?

      Now I need to move over the 'archivelogs' to the new database server, right?
      RMAN> list backup of archivelog all summary;
      
      
      List of Backups
      ===============
      Key     TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
      ------- -- -- - ----------- --------------- ------- ------- ---------- ---
      148     B  A  A DISK        09-NOV-12       1       1       YES        TAG20121109T091032
      150     B  A  A DISK        09-NOV-12       1       1       YES        TAG20121109T094014
      Not sure why their are two taken Friday but according to this command, my exact file I need to move would be:
      RMAN> list backupset 150;
      
      
      List of Backup Sets
      ===================
      
      
      BS Key  Size       Device Type Elapsed Time Completion Time
      ------- ---------- ----------- ------------ ---------------
      150     1.17M      DISK        00:00:02     09-NOV-12      
              BP Key: 150   Status: AVAILABLE  Compressed: YES  Tag: TAG20121109T094014
              Piece Name: /oracle/u01/app/oracle/backup/7bnps57u_1_1
      
        List of Archived Logs in backup set 150
        Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
        ---- ------- ---------- --------- ---------- ---------
        1    3128    175726589  09-NOV-12 175728280  09-NOV-12
      So what is key '148'? Do I need that file and should it be moved over to the new server?

      Then the 'controlfile' from the production server:
      RMAN> list backup of controlfile summary;
      
      
      List of Backups
      ===============
      Key     TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
      ------- -- -- - ----------- --------------- ------- ------- ---------- ---
      145     B  F  A DISK        08-NOV-12       1       1       NO         TAG20121108T091040
      151     B  F  A DISK        09-NOV-12       1       1       NO         TAG20121109T094019
      I view the control file key '151' to locate the specific / exact file I need to move over to the new server:
      RMAN> list backupset 151;
      
      
      List of Backup Sets
      ===================
      
      
      BS Key  Type LV Size       Device Type Elapsed Time Completion Time
      ------- ---- -- ---------- ----------- ------------ ---------------
      151     Full    9.92M      DISK        00:00:11     09-NOV-12      
              BP Key: 151   Status: AVAILABLE  Compressed: NO  Tag: TAG20121109T094019
              Piece Name: /oracle/u01/app/oracle/backup/CQDB/autobackup/2012_11_09/o1_mf_s_798889219_89t5gxmw_.bkp
        Control File Included: Ckp SCN: 175728301    Ckp time: 09-NOV-12
        SPFILE Included: Modification time: 09-NOV-12
        SPFILE db_unique_name: CQDB
      So based on everything above, do I only need those 3 specific files moved over (possibly 4)?

      1. /oracle/u01/app/oracle/backup/7anps3hu_1_1 = backup set (data)
      2. /oracle/u01/app/oracle/backup/CQDB/autobackup/2012_11_09/o1_mf_s_798889219_89t5gxmw_.bkp = controlfile
      3. /oracle/u01/app/oracle/backup/7bnps57u_1_1 = archievelogs

      Does that look correct above or am I wrong / missing files from my backup to recover my database on a new 11g R2 server?
        • 2. Re: Identify Backup Pieces
          Shivananda Rao
          Hello,

          I feel that you require the backupset keys from 147 to 151.

          Check what are the archives available in the BS Key 148 as 150 is having archives of only 1 archive which I feel that it was the new archive generated at the time of backup. So, I feel 148 is also essential.
          • 3. Re: Identify Backup Pieces
            895327
            Shivananda Rao wrote:
            I feel that you require the backupset keys from 147 to 151.

            Check what are the archives available in the BS Key 148 as 150 is having archives of only 1 archive which I feel that it was the new archive generated at the time of backup. So, I feel 148 is also essential.
            When I view BS Key 148, I see the following:
            RMAN> list backupset 148;
            
            
            List of Backup Sets
            ===================
            
            
            BS Key  Size       Device Type Elapsed Time Completion Time
            ------- ---------- ----------- ------------ ---------------
            148     64.85M     DISK        00:00:41     09-NOV-12      
                    BP Key: 148   Status: AVAILABLE  Compressed: YES  Tag: TAG20121109T091032
                    Piece Name: /oracle/u01/app/oracle/backup/79nps3g9_1_1
            
              List of Archived Logs in backup set 148
              Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
              ---- ------- ---------- --------- ---------- ---------
              1    3121    175636560  08-NOV-12 175638354  08-NOV-12
              1    3122    175638354  08-NOV-12 175648982  08-NOV-12
              1    3123    175648982  08-NOV-12 175662321  08-NOV-12
              1    3124    175662321  08-NOV-12 175677060  08-NOV-12
              1    3125    175677060  08-NOV-12 175689302  09-NOV-12
              1    3126    175689302  09-NOV-12 175716437  09-NOV-12
              1    3127    175716437  09-NOV-12 175726589  09-NOV-12
            So you're saying I WILL need BS Key 148 & 150 or based on the output above, just BS Key 148?
            • 4. Re: Identify Backup Pieces
              Shivananda Rao
              Both 148 and 150 are required. You can see that the BS key 148 has the bakcup of archives sequence till 3127 and 150 contains the backup of archivelog sequence 3128. So both are essentially required.

              If you feel that your question has been answered, please cosnider closing the thread by marking it as answered.