This discussion is archived
4 Replies Latest reply: Nov 14, 2012 9:56 AM by Shivananda Rao RSS

Identify Backup Pieces

895327 Newbie
Currently Being Moderated
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?
  • 1. Re: Identify Backup Pieces
    Acooper Explorer
    Currently Being Moderated
  • 2. Re: Identify Backup Pieces
    Shivananda Rao Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points