Disaster Recovery - Oracle iDataAgent

Table of Contents

Planning for a Disaster Recovery

Rebuilding the Operating System

Restoring the Oracle Database

Planning for a Disaster Recovery

Before you begin a disaster recovery, make sure to perform the following:

• Perform frequent Oracle backups with control files and the latest file system.
• Make sure that the recovery catalog is available on a separate computer.

Rebuilding the Operating System

In the case of disaster recovery, where a full system restore is required, you must first rebuild the system to exactly the state as it existed before the problem. Use the following steps to rebuild the operating system:

1. Rebuild the hardware if needed.
2. Install the same version of the operating system with the same patches that were previously installed.
3. Edit the host file of the client to include the CommServe name.
4. Install the File System iDataAgent on the client.
5. Perform a full system restore of the File System iDataAgent. This will restore the Oracle application available under the <oracle install> directory. If there are any problems with the Oracle iDataAgent, we recommend that you un-install and re-install the software in the same drive as it was previously installed. Use the same installation parameters, passwords, and backup type settings as were previously used. In addition to restoring your operating system, this operation will restore the Oracle application files and the Oracle iDataAgent.
6. Make sure to exclude the Oracle Database files while performing the file system backup. You can achieve this by setting a backup filter for .dbf files in the appropriate file system subclients.
7. Reboot the computer.
8. Manually copy the init<SID>.ora file on to the computer you are rebuilding.
9. Perform the following steps if the recovery catalog is on the same computer that you are rebuilding:
   • Create the recovery catalog database as it existed before the crash.
   • Create the user who was the owner of the recovery catalog with the same user privileges that existed for the user.
   • Import the user which was exported to a flat file and was backed up as a part of the file system using the Oracle Import command.
10. Start the database in the NOMOUNT mode.

Restoring the Oracle Database

1.	From the CommCell Browser, navigate to Client Computers | <Client> | Oracle. Right-click the <Instance> point to All Tasks and then click Restore.
2.	Select the name of the client computer from the Destination Client list. Clear Recover check box. Select Restore Archive Log check box. Select Restore Control File check box. Verify that the Status of the database is displayed as STARTED Click Advanced.
3.	Click the Restore tab. Ensure that the Restore Data with From the Latest Backup and Restore Archive Log  with All options are selected.
4.	Click the Control&SP files tab. Ensure that the Restore Control File with From Auto Backup options are selected.
5.	Click the Options tab. Select the Switch Database mode for Restore check box. Click OK.
6.	From the CommCell Browser, navigate to Client Computers | <Client> | Oracle. Right-click the <Instance> point to All Tasks and then click Restore.
7.	Select the name of the client computer from the Destination Client list. Clear the Restore Data check box. Click Advanced.
8.	Click Recover tab. Ensure that the Recover with Current Time options are selected. Click OK.
9.	You can monitor the progress of the restore job in the Job Controller.
10.	Once the restore job has completed, right-click the agent and click View | Restore History.
11.	Click OK.
12.	Once the database is restored, verify that the restored database and log files are available in the original location. After the Database is restored, perform a full backup of the Oracle Database.