Veritas NetBackup™ for Oracle Administrator's Guide
- NetBackup for Oracle QuickStart
- Installing NetBackup for Oracle
- About linking Oracle RMAN with NetBackup for UNIX
- Linking Oracle RMAN with NetBackup on UNIX platforms
- Oracle policy configuration
- Preparing for NetBackup for Oracle configuration
- Instance management for an Oracle Intelligent Policy
- About Oracle Intelligent Policies (OIP)
- About script- or template-based Oracle policies
- About adding backup selections to an Oracle policy
- About configuring the run-time environment
- About creating templates and shell scripts
- About creating RMAN scripts manually
- Performing backups and restores of Oracle
- About NetBackup for Oracle backups
- About NetBackup for Oracle restores
- Redirecting a restore to a different client
- Using NetBackup for Oracle in a Microsoft Windows cluster environment
- Guided Recovery
- Troubleshooting Guided Recovery
- NetBackup for Oracle with Snapshot Client
- About NetBackup for Oracle with Snapshot Client
- How NetBackup for Oracle with Snapshot Client works
- About configuring Snapshot Client with NetBackup for Oracle
- Restoring NetBackup for Oracle from a snapshot backup
- About NetBackup for Oracle restores of volumes and file systems using snapshot rollback
- About configuring NetBackup for Oracle block-level incremental backups on UNIX
- About Snapshot Client effects
- About Oracle support for Replication Director
- Troubleshooting RMAN backup or restore errors
- Appendix A. Real Application Clusters
- Appendix B. Best practices for protecting Oracle RAC with NetBackup
- Appendix C. Deduplication best practices
- Appendix D. Snapshot Client support of SFRAC
- Appendix E. Script-based block-level incremental (BLI) backups without RMAN on UNIX and Linux systems
- Verifying installation requirements for BLI backups without RMAN
- Creating NetBackup policies for script-based BLI backup
- Creating notify scripts for BLI backups
- Performing backups and restores
- About troubleshooting backup or restore errors
- Appendix F. XML Archiver
- NetBackup for Oracle XML export and XML import
- About XML export templates and shell scripts
- Performing an XML export archive
- Restoring an XML export archive
- About redirecting a restore of an XML export archive to a different client
- Troubleshooting XML export or XML import errors
- Appendix G. Register authorized locations
Performing a rollback restore in an SFRAC environment
The following procedure describes the manual steps that are needed to restore volumes and file systems by using the snapshot rollback method in an SFRAC environment.
A typical host deployment for running NetBackup for Oracle in an SFRAC environment is as follows: Host A and Host B are in the cluster and Host C is used as an alternate client. The instant recovery snapshot is taken using the Oracle policy and the Hardware Snapshot FIM (frozen image method).
The application I/O stack is built upon the hardware array of VxVM (CVM) and VxFS (CFS).
The Veritas Cluster Server (VCS) controls the Oracle RAC database and other required essential resources such as shared storage. VCS defines and manages its resources as a single unit called a service group. A service group contains all the necessary components and resources of an application.
The following are entities in the VCS that monitor the application I/O stack:
CFSMount contains the mount points (cfs) where data files, archive logs, and control files are stored.
CVMVolDg contains all the Volume Groups (cvm) configured on top of the various array LUNs that participate in the hardware snapshot.
The Database Resource Group contains the database instance and assists in failover.
To perform a rollback restore in the SFRAC environment
- Ensure that you previously created a virtual IP for the clustered node. Point that virtual IP to the master node of the cluster.
- On all the clustered nodes, take the VCS database service group (Oracle, CFSMount, and CVMVolDg resources) offline by using the following command:
# hagrp -offline <DB_Service_Group> -any
- Freeze the database service group.
# hagrp -freeze <DB_Service_Group>
- Mount the CFSMount points manually outside VCS on the master node. This action helps when you start the database in mount state.
# mount -F vxfs -o cluster <mntPt>
- Start the database with mount option on the clustered master node using one of these options:
# sqlplus /as sysdba # startup mount;
# sqlplus /as sysbackup # startup mount;
- Run the rollback restore operation from the RMAN script or the client GUI. A sample RMAN script file (
hot_database_backup_proc) is located in the following directory path:
To perform PIT rollback, add the following parameter to the script:
- Unmount the CFS on the master node.
# umount <mntPt>
- Unfreeze the VCS database service group.
# hagrp -unfreeze <DB_Service_Group>
- On all the clustered nodes, take the VCS database service group (Oracle, CFSMount, and CVMVolDg resources) back online:
# hagrp -online <DB_Service_Group> -any