News

  1. Home
  2. All posts
All posts, Backup by Team Ajara

Oracle Database backup configurations.


Oracle DB backup configurations.

In this article we will see different media management layer configuration parameters in the run block.

To take backup of oracle database we use any one of the below mentioned tools as a media management layer (MML).

  1. Tivoli Storage manager
  2. Net backup
  3. Avamar
  4. Net worker
  5. DD-BOOST

We can take backup on Tape/ Data Domain by using above tools.

We can also take backup on disks/ZFS for which we don’t need additional parameters in the run block.

Disk backup configuration parameter in the run block

run
{
allocate channel ch1 type disk ;
backup incremental level 0 database tag Full_Bkp_15Days format ‘/u00/disk_backup/inc0_%d_s%s_p%p’ ;
release channel ch1;
}

 

Tivvoli Storage Manager Backup Configuration parameters in the run block

run
{
allocate channel t1 type ‘SBT_TAPE’ parms=’ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin64/tdpo_ORCLP.opt)’;backup incremental level 0
skip inaccessible
tag hot_db_bk_level0
filesperset 4
format ‘bk_%d_%s_%p_%t’
(database);release channel t1;
}

ZFS(DISK) Configuration parameters in the run block(on Exadata)

run
{
sql ‘alter system set “_backup_disk_bufcnt”=64 scope=memory’;
sql ‘alter system set “_backup_disk_bufsz”=1048576 scope=memory’;
allocate CHANNEL ch1 DEVICE TYPE DISK FORMAT ‘/zfssa/prod/backup01/ORCLP/bk_%d_%s_%p_%t’ ;
backup incremental level 0
section size 30G AS BACKUPSET
database
TAG=’ORCLP_DBFULL_BKP_$DT’;
release channel ch1;
}

Netbackup Configuration parameters in the run block

run
{
allocate channel t1 device type sbt
PARMS=’ENV=(SBT_LIBRARY=/usr/openv/netbackup/bin/libobk.so64.1,NB_ORA_CLIENT=$NB_ORA_CLIENT,NB_ORA_POLICY=$NB_ORA_POLICY)’ format “ORCLP_ARCH_%s_%p_%t”;
backup as backupset incremental level 0 database tag=’Sunday_Full_Bkp’ keep until time ‘SYSDATE + 30’ LOGS;
release channel t1;
}

 

Networker backup configuration parameters in the run block

run
{
allocate channel c1 type ‘SBT_TAPE’;
send ‘NSR_ENV=(NSR_SERVER=<Server_name>, NSR_DATA_VOLUME_POOL=<Pool_name>)’;
backup incremental level 0 tag “virtualdb_LVL0_30days” as compressed backupset database filesperset 128 Keep UNTIL TIME ‘SYSDATE+30’;
release channel c1;
}

 

Avamar backup configuration parameters in run block

run
{
allocate channel c1 type ‘SBT_TAPE’ PARMS=”SBT_LIBRARY=/usr/local/avamar/lib/libobk_avamar64.so” format ‘ORCLP_HOT_%s_%p_%t’;
send channel=’c1′ ‘”–cacheprefix=c1″ “–flagfile=$ORACLE_HOME/scripts/rman/my-avtar-flags.txt” “–bindir=/usr/local/avamar/bin” “–logfile=$ORACLE_HOME/scripts/rman/logs/c1_Level0_ORCLP_$DT_avtar.log”‘;
backup as backupset incremental level 0 database tag=’Sunday_Full_Bkp’ keep until time ‘SYSDATE + 35’ LOGS;
release channel c1;
}

 

DD_BOOST Backup parameters

run
{
ALLOCATE CHANNEL C1 DEVICE TYPE SBT_TAPE PARMS ‘BLKSIZE=1048576, SBT_LIBRARY=/opt/dpsapps/dbappagent/lib/lib64/libddboostora.so,SBT_PARMS=(CONFIG_FILE=/opt/dpsapps/dbappagent/config/oracle_ddbda.cfg)’ FORMAT ‘%d_%U’;
release channel C1:
}

 

DD_BOOST Restore  parameters

run
{
ALLOCATE CHANNEL C1 DEVICE TYPE SBT_TAPE PARMS ‘BLKSIZE=1048576, SBT_LIBRARY=/opt/dpsapps/dbappagent/lib/lib64/libddboostora.so,SBT_PARMS=(CONFIG_FILE=/opt/dpsapps/dbappagent/config/oracle_ddbda.cfg)’;
release channel C1:
}

 

See Also: