Hello,
I started experimenting with RMAN as another means for backup (currently we use storage backup). I'm running few tests every day to check the overhead and time it takes, and also check the storage space needed for our system.
At first all seem well, I tested few default options, and then started configure the RMAN to better suite our needs.
The problem:
During my last tests I found out that RMAN is backing up my database twice, but I could not figure out where I configure it to run that way.
I even set a vanilla database with same configurations, but it produced only one backup set.
I'm attaching the configuration of my RMAN test environment, and hopefully someone will be able to point where I configured RMAN to do 2 backup sets.
RMAN> show all;
RMAN configuration parameters for database with db_unique_name MSCA are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
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 BACKUP TYPE TO COMPRESSED BACKUPSET PARALLELISM 1;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT '/oracle/MSCA/db/rman_bkup/MSCA/df_%d_%T_%U.rmn' MAXPIECESIZE 10 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 '/oracle/MSCA/db/rman_bkup/msca_dbs/snapcf_MSCA.f';
Here is the output from the end of backup set 1. You can see it took 2 hours, and then immediately it starts another backup job (highlight in RED)
channel ORA_DISK_1: finished piece 5 at 02-SEP-14
piece handle=/oracle/MSCA/db/rman_bkup/MSCA/df_MSCA_20140902_09phg6h0_5_1.rmn tag=TAG20140902T115927 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 02:05:08
channel ORA_DISK_1: starting compressed full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
Thanks
Saar