1 |
From a terminal window, connect as the Oracle Software Owner to the node where Plug‑in for Oracle is installed. |
2 |
Set the ORACLE_SID environment variable to the local instance. |
3 |
Start SQL*Plus, and connect with administrator privileges to the local instance. |
5 |
Start the local instance with the NOMOUNT option. |
6 |
Disable the CLUSTER_DATABASE initialization parameter for the local instance. |
8 |
Exit SQL*Plus. |
12 |
Start the local instance with the FORCE NOMOUNT option. |
16 |
17 |
Start SQL*Plus, and connect with administrator privileges to the local instance. |
18 |
Enable the CLUSTER_DATABASE initialization parameter for the local instance. |
20 |
Exit SQL*Plus. |
Restoring the Control File should only be performed in the following cases:
• |
Oracle® Customer Support has advised that a Control File restore is required. |
1 |
From a terminal window, connect as the Oracle Software Owner to the node where Plug‑in for Oracle is installed. |
2 |
Set the ORACLE_SID environment variable to the local instance. |
3 |
Start SQL*Plus, and connect with administrator privileges to the local instance. |
5 |
Start the local instance with the NOMOUNT option. |
6 |
Disable the CLUSTER_DATABASE initialization parameter for the local instance. |
8 |
Exit SQL*Plus. |
12 |
Start the local instance with the FORCE NOMOUNT option. |
15 |
Open the database with the RESETLOGS option. |
16 |
17 |
Start SQL*Plus, and connect with administrator privileges to the local instance. |
18 |
Enable the CLUSTER_DATABASE initialization parameter for the local instance. |
20 |
Exit SQL*Plus. |
IMPORTANT: After restoring a Control File from an Autobackup, Quest recommends that you perform a Full or Incremental Level 0 backup with the entire database selected on the NetVault Backup Selections page. |
If your goal is to create a copy of your target database for ongoing use on a standby RAC environment or independent RAC environment, do not use these procedures. Instead, use the Duplicate Database backup type, which is designed for this purpose. For more information, see Duplicating a database in a RAC environment.
For variations on the following disaster recovery procedure, see Performing Disaster Recovery in the Oracle® Database Backup and Recovery Advanced User’s Guide.
To perform a disaster recovery without a Recovery Catalog, the following requirements must be met:
• |
Oracle® RAC environment in place: You must have a properly configured Oracle RAC environment that matches the configuration as specified Performing User Managed backups. In addition, the same version of the Oracle database software must be installed in the RAC environment as it existed on the damaged RAC environment. The ORACLE_HOME should be identical on both the original and new node. You do not have to create the database, but you do need to configure Oracle Net Services and ASM for shared storage. |
• |
NetVault Backup software and the Plug‑in for Oracle installed: The same version of NetVault Backup software and the plug-in must be installed on one of the nodes in the RAC using the same NetVault Machine Name as previously defined for the RAC environment. Ensure that the plug-in default attributes are defined as specified in Configuring default attributes. |
• |
DBID of the source database identified: Identify the DBID of the damaged database. If the DBID was not recorded as part of the initial plug-in installation, you can obtain the DBID by examining the NetVault Backup binary logs for RMAN-based backups of the source database. The DBID is also available on the Details dialog box or the Backup Contents tab. |
• |
Default Location for SPFILE must exist: The default location in the ASM shared storage must exist before performing the following steps. Failure to ensure that the default location exists results in an ORA-17502 Failed to create file error during the SPFILE restore. Additionally, the SPFILE location should be detailed in the PFILE with the SPFILE parameter. |
• |
Backups of all tablespaces made available: Verify that you have the latest backups of all the tablespaces. |
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Termini di utilizzo Privacy Cookie Preference Center