Database Software

Hi All,

We have around 3 TB size of Database, Currently RMAN backup is taking around 30 hours to complete full backup.

Can you guys please give some suggestion on how can I reduce this backup time. 30 hours is too much.

Below is script which I am running for baking up database.


ORACLE_SID=TEST; export ORACLE_SID
ORACLE_HOME=/opt/oracle/product/11.2.0; export ORACLE_HOME
PATH=$ORACLE_HOME/bin:$PATH; export PATH
NLS_DATE_FORMAT='DD-MON-YYYY HH24:MI:SS'; export NLS_DATE_FORMAT
DATE=$(/usr/bin/date +%Y-%m-%d); export DATE

rman target / msglog /var/tmp/backup_rman_${ORACLE_SID}_hot_${DATE}.log << EOF
run {
ALLOCATE CHANNEL c1 DEVICE TYPE sbt;
BACKUP DATABASE PLUS ARCHIVELOG;
RELEASE CHANNEL c1;
}EXIT;
EOF


Above scripts I ran just for test purpose. Below is rman option for this DATABASE.

RMAN> show all;

using target database control file instead of recovery catalog
RMAN configuration parameters for database with db_unique_name TEST are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/snaps/%d/controlfile_backup_%d_%F';
CONFIGURE DEVICE TYPE DISK PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
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 '/snaps/%d/%d_%U';
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 '/opt/oracle/product/11.2.0/dbs/snapcf_TEST.f'; # default

I am on Solaris 10.

Oracle Solaris 10 9/10 s10s_u9wos_14a SPARC

Please give some usefull suggestion so I can reduce backup time. Please let me know if I can use any other option other than RMAN to backup it up.

Regards.