Tuesday 1 January 2008

Oracle DBA : Backup on Tape Drive

For oracle DBA, here are some cases on Tape Drive Backup:

You want to take backup on tape drive but rman always store the backup on a default location

  1. how can we take backup on tape drive, should we have to install any extra softwares for tape drive or rman handle it itself?

    You need thrid party Media managment software like veritas ,omnibackup,tivoli for backing up to tape.If you don't already have Media Management software, you can consider Oracle Secure Backup as a free alternative (assuming you are backing up one server to one tape drive).
  2. how can we set the tape drive as our default location for backup?
    how can we take backup on specified location e.g. d:\backup and how can we set this location as default location for backup?
    To set the tape drive as the default, see Configuring the Default Device Type for Backups.

    If you want the tape drive to be the default backup location, then you'll have to allocate a disk channel to produce backups to d:\backup. You can configure the disk format as CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT 'd:\backups'; and then allocate a disk channel during backup (Manually Overriding Configured Channels).