Oracle Database Restore
Restoring an Oracle database is crucial for recovering data after an incident, ensuring the continuity and integrity of business operations. Catalogic DPX offers a flexible and efficient approach to Oracle database restores, supporting various recovery options to meet your specific needs.
Creating an Oracle DB Restore Job
In the main web interface view, go to Job Manager in the sidebar. Then select the New Restore Job button.
Select Application Restore and Click Next.
The Object to Restore view shows all Application nodes that you backed up. The available objects to restore can be sorted by Name, Type, associated Job Name, or the backup Date/Time. Locate and select the node containing the Oracle DB you want to restore and click Next.
Tip. Restoring an Oracle DB object will include all local volumes referenced by the object, potentially increasing the restore size.
Choose the appropriate recovery point from the available backups of the selected node.
In the File Browsing step, choose the specific databases you wish to restore. DPX allows for granular selection, enabling you to restore individual databases. Select all databases you want to restore and click Next.
When browsing the file tree of a block backup for Oracle DB, you will see two separate directories: Physical View and Logical View. The physical view represents the actual physical implementation of the database on the storage system, while the logical view provides a structured representation of the database objects and their relationships.
In the Options step, specify the Job Name. The name may be up to 64 characters long and may only contain letters, digits and
-
_
characters.Specify job options. You can use the following options:
Basic Job Options
Delete the restore job on successful completion
Job e-mail notification
Oracle Options
Oracle Restore Mode
When performing Oracle logical view restores, you can choose from the following modes:
Oracle Files Quick Restore Root Directory
Specify a complete directory path to be used as the root directory for all mappings during a Quick Restore for Oracle. If this value is not set, it defaults to:
For Windows:
product-directory/mount/BEXrmancat_jobid/nodename/dbname
For UNIX:
/tmp/BEXrmancat_jobid/nodename/dbname
Oracle Home
This option is used when cloning Oracle databases. Specify the Oracle_Home
on the target node where the cloned database will reside.
Oracle UNIX User Name
When cloning Oracle databases on a UNIX target node, supply the user name of the owner of the Oracle installation on the restore destination node. If this field is not populated, the default value oracle
will be used.
Oracle Instance Password
For cloning Oracle databases on a Windows target node, provide a password to create an Oracle instance on the target node. If this field is not populated, the default value sysadmin
is used.
Note. The Oracle Instance Password may appear in clear text in certain files and modules. Once cloning is complete, the password must be changed by the user.
Oracle Database Open Option
This option is used with the cloning of Oracle databases. It allows you to control whether the cloned Oracle database should be opened and in what mode. The available options are:
See also. To learn more about other available options, see Advanced Job Options.
Click Next. Review the summary of your job and click Save. You will see the Run Job prompt.
Click Yes to run the job immediately, or No if you want to run it later from the Job Manager.