| Why do I have multiple backup sets for a single 'backup database' [message #601339] |
Tue, 19 November 2013 14:57  |
 |
markhooper99
Messages: 19
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
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
