Database Software

Hi folks,

We are using Oracle Exadata V2 storage software. Our Database size is 5 TB. We are using HP Data Protector as MML for tape backups.

We run weekly full database backup and daily incremental backups (with no compression) but the full backup is taking more than 20 hours to finish the backup. As per Oracle Exadata Best Prectices Document this should not take more than 3-4 hours (max).

Could anyone have idea why its taking so long time, or you are also facing the same issue?

Below is the complete script to run the backup job:

BARLIST "Oracle_VIVADW_Backup"
OWNER "root" "viva.com.kw" "dw0101-vip.viva.com.kw"
DYNAMIC 1 5
DEVICE "HP:Ultrium 4-SCSI_1_production1"
{
-sync
-pool "Oracle DataBase Backup"
-prealloc
"0100007f:4cbac0db:7da9:0009"
"0100007f:4cbac149:7da9:000a"
"0100007f:4cbac1b6:7da9:000b"
"0100007f:4cbac23f:7da9:000c"
"0100007f:4cbac2af:7da9:000d"
"0100007f:4cbac31e:7da9:000e"
"0100007f:4cbac38a:7da9:000f"
"0100007f:4cbac3fe:7da9:0010"
"0100007f:4cbac46e:7da9:0011"
"0100007f:4cbac4dd:7da9:0012"
"0100007f:4cbac549:7da9:0013"
"0100007f:4cbac5bd:7da9:0014"
"0100007f:4cbac62d:7da9:0015"
"0100007f:4cbac69c:7da9:0016"
"0100007f:4cbac709:7da9:0017"
}

CLIENT "vivadw" dw0101-vip.viva.com.kw
{
-exec ob2rman.exe
-args {
"-backup"
}
-input {
"run {"
"allocate channel 'dev_0' type 'sbt_tape'"
" parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=vivadw,OB2BARLIST=Oracle_VIVADW_Backup)';"
"allocate channel 'dev_1' type 'sbt_tape'"
" parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=vivadw,OB2BARLIST=Oracle_VIVADW_Backup)';"
"allocate channel 'dev_2' type 'sbt_tape'"
" parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=vivadw,OB2BARLIST=Oracle_VIVADW_Backup)';"
"allocate channel 'dev_3' type 'sbt_tape'"
" parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=vivadw,OB2BARLIST=Oracle_VIVADW_Backup)';"
"allocate channel 'dev_4' type 'sbt_tape'"
" parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=vivadw,OB2BARLIST=Oracle_VIVADW_Backup)';"
"allocate channel 'dev_5' type 'sbt_tape'"
" parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=vivadw,OB2BARLIST=Oracle_VIVADW_Backup)';"
"allocate channel 'dev_6' type 'sbt_tape'"
" parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=vivadw,OB2BARLIST=Oracle_VIVADW_Backup)';"
"allocate channel 'dev_7' type 'sbt_tape'"
" parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=vivadw,OB2BARLIST=Oracle_VIVADW_Backup)';"
"sql 'alter system archive log current';"
"backup incremental level <incr_level>"
" format 'Oracle_VIVADW_Backup<vivadw_%s:%t:%p>.dbf'"
" database;"
"backup"
" format 'Oracle_VIVADW_Backup<vivadw_%s:%t:%p>.dbf'"
" archivelog all;"
"backup"
" format 'Oracle_VIVADW_Backup<vivadw_%s:%t:%p>.dbf'"
" recovery area;"
"backup"
" format 'Oracle_VIVADW_Backup<vivadw_%s:%t:%p>.dbf'"
" current controlfile;"
"}"
}
-public
} -protect weeks 1

Please suggest.

Regards.