Home » RDBMS Server » Backup & Recovery » Why do I have multiple backup sets for a single 'backup database' (11gR2, 11.2.0.3.4, Solaris 10)
Why do I have multiple backup sets for a single 'backup database' [message #601339] Tue, 19 November 2013 14:57 Go to next message
markhooper99
Messages: 7
Registered: October 2013
Location: Calgary
Junior Member
New to RMAN.
Finally got by our NFS mount issues *sigh* and were able to run a 'backup database' successfully for the first time.
I was puzzled by the results in that I see THREE backup sets where some of the datafiles ended up in the first backup set and others ended up in the second backup set, with the control file in the third set.
I'm curious as to why this happened - I was expecting a single backup set with all the files in that one set.
Is this splitting normal ? Thanks in advance.

Environment: Oracle Enterprise 11gR2 (11.2.0.3.4 on Solaris 10)

RMAN> show all;

starting full resync of recovery catalog
full resync complete
RMAN configuration parameters for database with db_unique_name HKAP are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT   '/u13/oracle/HKAP/rman_backup/ora_df%t_s%s_s%p' MAXPIECESIZE 30 G;
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/apps/oracle/product/v11203/dbs/snapcf_HKAP.f'; # default

RMAN> list backup summary;


List of Backups
===============
Key     TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- --------------- ------- ------- ---------- ---
28015   B  F  A DISK        15-NOV-13       24      1       NO         TAG20131115T180737
28016   B  F  A DISK        15-NOV-13       23      1       NO         TAG20131115T180737
28163   B  F  A DISK        15-NOV-13       1       1       NO         TAG20131115T223433

RMAN> list backup;


List of Backup Sets
===================


BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
28015   Full    696.14G    DISK        02:13:00     15-NOV-13
  List of Datafiles in backup set 28015
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1       Full 12843507670357 15-NOV-13 /u06/oracle/HKAP/system1.dbf
  2       Full 12843507670357 15-NOV-13 /u05/oracle/HKAP/undo1.dbf
  4       Full 12843507670357 15-NOV-13 /u05/oracle/HKAP/undo3.dbf
...snipped for brevity...
  89      Full 12843507670357 15-NOV-13 /u06/oracle/HKAP/INTERCHANGE_4M_12.dbf
  91      Full 12843507670357 15-NOV-13 /u07/oracle/HKAP/TOM_4M_1.dbf
  92      Full 12843507670357 15-NOV-13 /u07/oracle/HKAP/TOM_128M_1.dbf

  Backup Set Copy #1 of backup set 28015
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        02:13:00     15-NOV-13       NO         TAG20131115T180737

    List of Backup Pieces for backup set 28015 Copy #1
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    28017   1   AVAILABLE   /u13/oracle/HKAP/rman_backup/ora_df831578859_s13_s1
    28018   2   AVAILABLE   /u13/oracle/HKAP/rman_backup/ora_df831578859_s13_s2
    28019   3   AVAILABLE   /u13/oracle/HKAP/rman_backup/ora_df831578859_s13_s3
...snipped for brevity...
    28038   22  AVAILABLE   /u13/oracle/HKAP/rman_backup/ora_df831578859_s13_s22
    28039   23  AVAILABLE   /u13/oracle/HKAP/rman_backup/ora_df831578859_s13_s23
    28040   24  AVAILABLE   /u13/oracle/HKAP/rman_backup/ora_df831578859_s13_s24

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
28016   Full    686.27G    DISK        02:13:42     15-NOV-13
  List of Datafiles in backup set 28016
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  3       Full 12843507813196 15-NOV-13 /u05/oracle/HKAP/undo2.dbf
  6       Full 12843507813196 15-NOV-13 /u05/oracle/HKAP/undo4.dbf
  7       Full 12843507813196 15-NOV-13 /u06/oracle/HKAP/tools1.dbf
...snipped for brevity...
  88      Full 12843507813196 15-NOV-13 /u06/oracle/HKAP/DMASS38_data_128K_24.dbf
  90      Full 12843507813196 15-NOV-13 /u07/oracle/HKAP/TOM_128K_1.dbf
  93      Full 12843507813196 15-NOV-13 /u06/oracle/HKAP/DMASS38_data_128K_25.dbf

  Backup Set Copy #1 of backup set 28016
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        02:13:42     15-NOV-13       NO         TAG20131115T180737

    List of Backup Pieces for backup set 28016 Copy #1
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    28041   1   AVAILABLE   /u13/oracle/HKAP/rman_backup/ora_df831586846_s14_s1
    28042   2   AVAILABLE   /u13/oracle/HKAP/rman_backup/ora_df831586846_s14_s2
    28043   3   AVAILABLE   /u13/oracle/HKAP/rman_backup/ora_df831586846_s14_s3
...snipped for brevity...
    28061   21  AVAILABLE   /u13/oracle/HKAP/rman_backup/ora_df831586846_s14_s21
    28062   22  AVAILABLE   /u13/oracle/HKAP/rman_backup/ora_df831586846_s14_s22
    28063   23  AVAILABLE   /u13/oracle/HKAP/rman_backup/ora_df831586846_s14_s23

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
28163   Full    35.14M     DISK        00:00:02     15-NOV-13
        BP Key: 28210   Status: AVAILABLE  Compressed: NO  Tag: TAG20131115T223433
        Piece Name: /u01/apps/oracle/product/v11203/dbs/c-799225840-20131115-00
  Control File Included: Ckp SCN: 12843507962430   Ckp time: 15-NOV-13






Re: Why do I have multiple backup sets for a single 'backup database' [message #601378 is a reply to message #601339] Wed, 20 November 2013 04:31 Go to previous messageGo to next message
gazzag
Messages: 302
Registered: November 2010
Location: Bristol, UK
Senior Member
Essentially it is down to RMAN's own internal algorithm. However, the number and size of the backup sets can be controlled as described here.

HTH
-g
icon14.gif  Re: Why do I have multiple backup sets for a single 'backup database' [message #601407 is a reply to message #601378] Wed, 20 November 2013 10:19 Go to previous message
markhooper99
Messages: 7
Registered: October 2013
Location: Calgary
Junior Member
Thanks for your response.
It helped me understand the how the FILESPERSET value is calculated - now I get it Surprised
Previous Topic: Help using RMAN newbie
Next Topic: Partition table backup
Goto Forum:
  


Current Time: Tue Sep 02 22:59:04 CDT 2014

Total time taken to generate the page: 0.10863 seconds