Chat now with support
Chat with Support

NetVault Plug-in for Oracle 7.1 - User Guide

Introducing Dell™ 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-inin a failover cluster environment Using the plug-in with Oracle Data Guard Troubleshooting Glossary About Dell

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

Restoring and recovering data – an overview

Reconstructing the contents of all or part of a database from a backup typically involves two phases: Restore and Recovery. Restoring is the process of retrieving a copy of the datafile from a backup. Recovery is the process of reapplying changes to the file since the backup from the archived and online redo logs, to bring the database to a desired SCN (typically the present, or the point-of failure).
Based on your backup method, follow the instructions in the relevant section for successfully performing data restoration using Plug‑in for Oracle.
Understanding User Managed recovery
When a User Managed backup strategy has been implemented, the recovery process must be managed by the DBA. This includes the following tasks:
•
Determining what needs to be recovered.
•
Restoring the needed files with the plug-in.
•
Performing the recovery process manually outside the plug-in by issuing a series of SQL*Plus commands.
The following sections provide an overview of the User Managed recovery process. For more information, refer to About User-Managed Restore Operation in the Oracle Database Backup and Recovery Advanced User’s Guide or to Performing User-Managed Backup and Recovery in the Oracle Database Backup and Recovery User’s Guide.
•
Determining which datafiles require recovery
•
Recovering datafiles and archive logs
•
Restoring Control Files
Determining which datafiles require recovery
When a media failure or data corruption has occurred, you can use the following SQL*Plus query to determine which datafiles need recovery. This command will work only when the database is in an OPEN state:
SELECT FILE#, ERROR, ONLINE_STATUS, CHANGE#, TIME FROM V$RECOVER_FILE;

Recovering datafiles and archive logs

Reconstructing the contents of all or part of a database from a backup typically involves two phases: Restore and Recovery. Restoring is the process of retrieving a copy of the datafile from a backup. Recovery is the process of reapplying changes to the file since the backup from the archived and online redo logs, to bring the database to a desired SCN (typically the present, or the point-of failure).
Based on your backup method, follow the instructions in the relevant section for successfully performing data restoration using Plug‑in for Oracle.
Understanding User Managed recovery
When a User Managed backup strategy has been implemented, the recovery process must be managed by the DBA. This includes the following tasks:
•
Determining what needs to be recovered.
•
Restoring the needed files with the plug-in.
•
Performing the recovery process manually outside the plug-in by issuing a series of SQL*Plus commands.
The following sections provide an overview of the User Managed recovery process. For more information, refer to About User-Managed Restore Operation in the Oracle Database Backup and Recovery Advanced User’s Guide or to Performing User-Managed Backup and Recovery in the Oracle Database Backup and Recovery User’s Guide.
•
Determining which datafiles require recovery
•
Recovering datafiles and archive logs
•
Restoring Control Files
Determining which datafiles require recovery
When a media failure or data corruption has occurred, you can use the following SQL*Plus query to determine which datafiles need recovery. This command will work only when the database is in an OPEN state:
SELECT FILE#, ERROR, ONLINE_STATUS, CHANGE#, TIME FROM V$RECOVER_FILE;

Recovering datafiles and archive logs

After the damaged datafiles have been identified, restore the last Full Backup of the datafiles and the backup of all archive logs generated since the last backup until the target recovery time. When you restore the datafiles, the existing files are replaced with the backed-up copy. Conversely, when you restore the archive logs, these files are copied to the original location so that they are available to the database during the recovery process.
The recovery of the damaged datafiles and the archive logs includes the following steps:
1
Connect to the database with SYSDBA privileges via the SQL*Plus utility.
SQLPLUS SYS AS SYSDBA
2
If the database is open, use the following command to alter all the tablespaces that will be recovered:
ALTER TABLESPACE <Tablespace Name> OFFLINE;
3
Use the plug-in to restore the damaged datafiles from the latest User Managed Full Backup saveset.
To restore datafiles to a different location, specify the new path during restore.
4
Use the plug-in to restore all the archive logs backups that have been completed since the User Managed Full Backup.
Restore the logs to the primary destination directory. If space is limited, use the Rename option to restore the logs to a different directory. For more information, see Using advanced User Managed restore procedures.
5
After the restoration is complete, use SQL*Plus to perform the recovery manually by issuing the following command for every tablespace that needs recovering:
RECOVER TABLESPACE <Tablespace Name>
6
Alter the recovered tablespaces online with the following SQL*Plus command:
ALTER TABLESPACE <Tablespace Name> ONLINE;
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating