Tchater maintenant avec le support
Tchattez avec un ingénieur du support

NetVault Plug-in for Oracle 12.2 - User Guide

Introducing Quest® NetVault® Backup Plug-in  for Oracle Defining a backup strategy Installing and removing the plug-in Configuring the plug-in Backing up data Using the Oracle Flashback Database Restoring data
Restoring and recovering data: an overview Performing User Managed restores Using advanced User Managed restore procedures Performing RMAN restores Using RMAN types of recovery in a non-RAC environment Using advanced procedures with RMAN restores
Maintaining the Recovery Catalog Using the RMAN CLI Using the Plug-in with Oracle RAC Using the Plug-in in a failover cluster environment Using the plug-in with Oracle Data Guard Using the plug-in with Oracle Container Databases (CDBs) and Pluggable Databases (PDBs) Troubleshooting

Recovering a Whole Database to the same RAC environment

This type of recovery is performed when the current Control File and SPFILE are intact but all the datafiles are damaged or lost. You can perform a Complete Recovery or recover the database to a specific point. Following is an overview of the process to recover the whole database in a RAC environment.

2
Set the ORACLE_SID environment variable to the local instance.
3
Start SQL*Plus, and connect with administrator privileges to the local instance.
6
Disable the CLUSTER_DATABASE initialization parameter for the local instance.
8
Exit SQL*Plus.
> srvctl STOP DATABASE -d <database_name> -o abort
11
Start SQL*Plus, and connect with administrator privileges to the local instance.
12
In SQL*Plus, start the local instance with the MOUNT option.
13
On the Create Restore Job — Choose Saveset page, find the latest available backup that included all the tablespaces, and click Next.
14
On the Create Selection Set page, select the Whole Database node, and click Edit Plugin Options.
15
Click the Restore Options tab, and select the applicable options:
To include read-only datafiles in the restore and recovery process, select Check Read-Only Datafiles and Restore if Necessary and Check Read-Only Datafiles and Recover if Not Current. The read-only files are included only if they are needed to complete recovery. If they are not damaged, RMAN omits them.
Perform Complete Recovery: Recovers the database to the current time, that is, to the last committed transaction available in the archived and online redo logs.
Perform Database Point-in-Time Recovery: Recovers the database to a specific point whether it be a specific time, log sequence number, or SCN.
17
On the Recovery Catalog tab, select the Use Catalog option, and specify the Recovery Catalog connection details.
18
Complete the Target Client, Schedule, and Advanced Options tabs, and submit the job.
20
Start SQL*Plus, and connect with administrator privileges to the local instance.
21
Enable the CLUSTER_DATABASE initialization parameter for the local instance.
23
Exit SQL*Plus.

Restoring SPFILE in a RAC environment

Because Control File Autobackups are a prerequisite in a multi-instance RAC environment, the SPFILE is backed up with the Control File whenever an Autobackup is performed. The SPFILE is restored from the Autobackup to the default location; for more information, see the following steps. If the instance is already started with the server parameter file, you cannot overwrite the existing server parameter file. For more information on restoring an SPFILE to a non-default location, see the Oracle Database Backup and Recovery Basics guide.

2
Set the ORACLE_SID environment variable to the local instance.
3
Start SQL*Plus, and connect with administrator privileges to the local instance.
6
Disable the CLUSTER_DATABASE initialization parameter for the local instance.
8
Exit SQL*Plus.
>srvctl STOP DATABASE -d <database_name> -o abort
>rman TARGET / CATALOG rman/<password>@<connect_identifier for catalog>
12
SET DBID <DBID>;
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 Control Files in a RAC environment

Restoring the Control File should only be performed in the following cases:

Because Control File Autobackups are a prerequisite in a multi-instance RAC environment, perform the following steps to restore the Control Files from the Autobackup.

2
Set the ORACLE_SID environment variable to the local instance.
3
Start SQL*Plus, and connect with administrator privileges to the local instance.
6
Disable the CLUSTER_DATABASE initialization parameter for the local instance.
8
Exit SQL*Plus.
>srvctl STOP DATABASE -d <database_name> -o abort
12
SET DBID <DBID>;
15
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.

Performing disaster recovery in a RAC environment

Disaster recovery includes the restore and recovery of a multi-instance RAC database after a complete media failure of all the shared storage including the current Control Files, all online redo log files, all parameter files, and the Recovery Catalog. To perform a disaster recovery, you need the minimum required set of backups; the minimum includes the backups of all the datafiles, some archived redo logs generated after the time of the backup, and at least one Autobackup of the Control File.

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.

The following procedure details the steps to perform disaster recovery to the same RAC environment where the source database resided. This procedure would be used in the scenario in which a complete media failure of the shared storage occurred and the damaged shared storage was rebuilt using the same configuration or new shared storage was configured imitating the original shared storage’s configuration.

For variations on the following disaster recovery procedure, see Performing Disaster Recovery in the Oracle Database Backup and Recovery Advanced User’s Guide.

Documents connexes

The document was helpful.

Sélectionner une évaluation

I easily found the information I needed.

Sélectionner une évaluation