Appendix

Default aliases

Name
Description

dbbackup

Changes directory to ${DMK_DBBACKUP}

rmanh

Oracle Recovery Manager with history

rmanc

Launch rman with a catalog or nocatalog connection. Works in combination with the “${DMK_ORA_ADMIN_SID}/etc/rman.cfg” catalog parameter

dmkhelp dbbackup

Display into the shell all default aliases/variables categorized by DMK_DBBACKUP

Default variables

Name
Description

DMK_DBBACKUP

Installation directory

Support Matrix

Operating System
Support Level
Oracle Releases

Oracle Enterprise Linux

Certified

Check the DMK Support matrix

Red Hat Enterprise Linux

Certified

Check the DMK Support matrix

Suse Enterprise Linux

Supported

Check the DMK Support matrix

IBM AIX

Supported (IBM & Intel)

Check the DMK Support matrix

Sun Solaris

Supported (ipc86 & SPARC)

Check the DMK Support matrix

HP-UX

Supported (Itanium)

Check the DMK Support matrix

Please contact the Support Team if your version isn’t available in the above matrix.

Templates RCV

The scripts are sorted under the respective Oracle release (i.e : oracle10, oracle11, oracle12) under the ${DMK_DBBACKUP}/templates/rcv” directory.

Script
Description

bck_arc.rcv

Backup all archived logs to a specific location and delete them.

bck_arc_fra.rcv

Backup all archived to the Fast Recovery Area without deleting them.

bck_arc_no_arc_del.rcv

Backup all archived logs to a specific location without deleting them.

bck_inc0_fra.rcv

Backup full of the database within the Fast Recovery Area.

bck_inc0.rcv

Backup full of the database to a specific location

bck_inc0_no_arc_del.rcv

Backup full of the database to a specific location without deleting the backed up archive logs

bck_inc1.rcv

Backup level 1 Incremental cumulative of the database to a specific locationIntended for large database with high retention periods

bck_inc1_no_arc_del.rcv

Backup level 1 Incremental cumulative of the database to a specific location with no deletion of archive logsIntended for large database with high retention periods

bck_inc0_no_arc_del_tape.rcv

Backup full of the database to tape with no deletion of archive logs

bck_inc1_no_arc_del_tape.rcv

Backup level 1 Incremental cumulative of the database to tape with no deletion of archive logsIntended for large database with high retention periods

bck_inc1_fra.rcv

Backup level1 Incremental cumulative of the database within the Fast Recovery Area.Intended for large database with high retention periods

bck_inc0.rcv

Backup full of the database to a specific location

bck_fra_disk.rcv

Backup the whole Fast Recovery Area to specific location on disk

bck_fra_tape.rcv

Backup the whole Fast Recovery Area to tape

mnt_obs.rcv

Delete obsolete backups (no more needed by the backup policy)

mnt_rst_validate.rcv

Check backup validity by simulating a restore operation

bck_inc0_no_arc_del_blck_chg_trk.rcv

Backup full of the database to a specific location without deleting the backed up archive logs. Block change tracking is enabled.

bck_inc1_no_arc_del_blck_chg_trk.rcv

Backup level 1 Incremental cumulative of the database to a specific location without deleting the backed up archive logs. Block change tracking is enabled.

change_arc_del_policy.rcv

To be used on standby databases only. Will change the archive log deletion policy configured for the standby. Block change tracking will be disabled.

incr_upd_bck_no_arc_del.rcv

Incrementally updated backups using copy files and recovering copy files. The script will also run an inc 1 backup, an archive log backup and a control file backup.

dbi services recommend following configuration:

  • Archive logs and database backup stored in the Fast Recovery Area

    • bck_arc_fra.rcv

    • bck_inc0_fra.rcv

  • Archive logs backup and database backups stored in a separate filesystem, but the Archive logs will not be deleted

    • bck_arc_no_arc_del.rcv

    • bck_inc0_no_arc_del.rcv

Archive logs and database backup stored in a separate filesystem (traditional way) is no more recommended and shall be avoided. However, following scripts are ready to use:

  • bck_arc.rcv

  • bck_inc0.rcv

Last updated