Chat now with support
Chat with 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

Performing table-level recovery

Table-level recovery (RECOVER TABLE) is an Oracle-based feature that is available starting with Oracle Database 12.1 Enterprise Edition. If you are using the applicable version of Oracle, you can use the plug-in to recover specific Oracle tables to a specific point.

Oracle Server recovers the tablespaces that contain the tables listed for recovery into an auxiliary instance. Oracle Server then uses data pump to export the table data from the auxiliary instance to the target instance.

 
* 
IMPORTANT: The examples shown throughout the following topics are based on using the fully automated version of the auxiliary instance. By using the automated method, the auxiliary instance is fully created and managed by the Oracle Server whenever a destination, that is, a directory in the file system, is provided.

To restore tablespaces to the auxiliary instance, you must provide backups of the system tablespaces, the tablespaces that contain the tables to recover, and the controlfile as it existed at the time of the backup.

The plug-in lets you take advantage of the automated recovery method using an auxiliary instance. For information regarding other methods of performing table-level recovery, see your Oracle documentation. These other methods let you use the RMAN command prompt to recover from backups created by the plug-in.

The following topics provide information for performing a table-level recovery:

•
Uses of table-level recovery
•
Table-level requirements and limitations
•
Configuring channels for table-level recovery
•
Performing table-level recovery from the RMAN CLI
•
Performing table-level recovery from the NetVault Backup WebUI

Uses of table-level recovery

Table-level recovery lets you recover one or more tables or table partitions to a specific point without affecting other tables or database objects. You can use backups created using the plug-in's RMAN backup method to accomplish this process. In addition to other recovery methods, table-level recovery is useful when you need to recover:

•
A few tables to a specific point.
•
Tables that were dropped and purged.
•
Tables that are logically corrupted.
•
A table for which the FLASHBACK TABLE command is unavailable; for example, the Flashback Table cannot rewind because of structural changes, or the target point is older than the undo point.

Table-level requirements and limitations

There are Oracle Database-specific limitations and requirements for performing this type of recovery. To perform recovery successfully, review the following requirements and limitations. For more information, including a complete list of constraints, see the table-level recovery information in your Oracle documentation.

•
Table-level recovery is available in the Enterprise Edition of Oracle Server 12.1 or later.
•
To use automated table-level recovery, the directory specified in the “Auxiliary Destination” clause must exist before running recovery. You can use an existing empty directory, or create a directory, if the directory exists before starting the process.
•
You must use the CONFIGURE command to configure the channels in RMAN. The auxiliary database uses the same channels as the target database.
•
Full backups of the tablespaces SYSTEM, SYSAUX, undo, that is, UNDOTBS1, and SYSEXT, if the SYSEXT tablespace is present, must exist. The tablespace that contains the table that is the target of the recovery must also exist.
•
You cannot use table-level recovery to recover: tables that belong to SYS, tables from the SYSTEM and SYSAUX tablespaces, or tables on standby databases.
•
You cannot use the “REMAP” clause to recover tables with named NOT NULL constraints.

Configuring channels for table-level recovery

To use the plug-in for recovery, configure SBT channels in RMAN. These channels connect RMAN and the NetVault Backup media management utilities. You can configure a default SBT channel, as well as additional channels of type SBT or DISK. To display the current RMAN configuration, run the following command from an RMAN prompt:

RMAN> SHOW ALL;

If no SBT channels are configured, that is, only settings for DISK channels exist, use the following command to instruct RMAN to add a set of settings for SBT channels:

RMAN> CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';

When these settings are added for SBT channels and a table-level recovery is run, at least one DISK channel and one SBT channel are available for the recovery process. The auxiliary instance uses the same channels that are available for the target instance.

You can also use the following command to add additional channels, if applicable:

RMAN> CONFIGURE CHANNEL <channelNumber> DEVICE TYPE sbt

For more information on configuring channels, see your Oracle documentation.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating