Oracle Tips by Burleson

Oracle Dataguard
Chapter 9 - Recovery Manager and Data Guard

Backup of a RAC Grid Using RMAN

run {
    allocate channel fs1 type disk
format='/oracle/stdbydb/bkp/%u.%p';
    backup
         incremental level = 0
         filesperset = 3
         database plus archivelog
         tag = 'level0Backup_OfStandby';
}

• The script will complete with the following warning:

“RMAN-06497: WARNING: controlfile is not current, controlfile autobackup skipped released channel: fs1”

• This warning shows up because the control file is a standby control file. This warning can be ignored because a backup of the standby control file is not usable in any sense for recovery.

To learn more about the backup of a standby database using RMAN, refer to Oracle 9i Recovery Manager User’s Guide Release 2 (9.2), which provides a great deal of information on this subject.

Conclusion

The primary focus of this chapter was to introduce the concept of using Recovery Manager for physical standby database creation. The following topics were discussed in detail:

• Key Recovery Manager concepts and the explanation of RMAN terminology used throughout this chapter have been provided.
   

• Details on creating a physical RAC Grid using a backup set or image copies of the primary database were included.
   

• A step-by-step guide and a few sample scripts have been provided to assist when creating a physical RAC Grid using RMAN.
   

• The backup procedure for standby databases using RMAN was detailed.

Refer to Oracle 9i Recovery Manager User’s Guide Release 2 (9.2), which provides much more additional information on this subject.