Oracle 10g Grid Computing RAC Backup Procedures RMAN RAC CFS Single Tape Drive backup Multiple Tape Drive

Redneck

Dress Code

Oracle tuning

Oracle training

Oracle support

Remote Oracle

Oracle Tips by Burleson

Oracle10g Grid Computing with RAC
Chapter 13 - Oracle RAC Backup and Recovery

Backup Procedures for RMAN and RAC

We have discussed various aspects of the backup procedures using RMAN. In this section, let's tie them into a coherent set of backup procedures. Essentially, we will use RMAN scripts to perform a cluster file system backup with a single drive, a raw file system backup with multiple drives, and a raw file system backup with a single drive.

CFS Single Tape Drive backup

Perhaps the simplest RAC backup is the CFS backup using a single tape drive. Basically, one backup device and one channel are configured, and the backup command is ready to be issued. After connecting to both the RMAN catalog database and the target database, the following RMAN commands would be issued:

CONFIGURE DEVICE TYPE sbt PARALLELISM 1;
CONFIGURE DEFAULT DEVICE TYPE TO sbt;
BACKUP DATABASE PLUS ARCHVIELOG delete INPUT;

The backup set of commands is simple in a CFS single tape drive backup because all nodes can see all drives in the CFS array, which allows any node to backup the entire instance.

CFS Multiple Tape Drive Backup

If the RAC setup includes a tape drive on each node, or the backup is to a disk on each node, then the backup can be parallel (making it go faster), utilizing the entire available instance for the backup operation. For our example 2-node RAC setup, after connecting to the RMAN catalog and the target instance, these commands would be issued:

CONFIGURE DEVICE TYPE sbt PARALLELISM 2;
CONFIGURE DEFAULT DEVICE TYPE sbt;
CONFIGURE CHANNEL 1 DEVICE TYPE sbt CONNECT 'SYS/kr87m@v10g1';
CONFIGURE CHANNEL 2 DEVICE TYPE sbt CONNECT 'SYS/kr87m@v10g2';

Note: If you are using a device type of DISK, substitute DISK for sbt and specify the path to the backup directory as a part of the CHANNEL configuration. For example:

CONFIGURE CHANNEL 1 TYPE disk FORMAT '/u01/backup/v10g_rac1/b_%u_%p_%c' CONNECT 'sys/kr87m@v10g1';

As already mentioned, this configuration need only be specified once unless something happens to the RMAN catalog. Once the configuration is set, the command to perform the backup is fairly simple:

BACKUP DATABASE PLUS ARCHIVELOG delete INPUT;

There is also provision for a control file backup.

BACKUP DATABASE INCLUDE CURRENT CONTROLFILE PLUS ARCHIVE LOG delete INPUT;

For more information, see the book Oracle 11g Grid and Real Application Clusters - 30% off if you buy it directly from Rampant TechPress .

Written by top Oracle experts, this RAC book has a complete online code depot with ready to use RAC scripts.

Customized Oracle Training Classes

Burleson Consulting offers on-site Oracle courses year-round in a variety of Oracle topics. All on-site Oracle training can be custom fit to meet your specific training needs. For customized syllabus development or a price quote, please visit www.fast-track.cc or email .