立即与支持人员聊天
与支持团队交流

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

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.
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:

Recovering datafiles and archive logs

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.
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:

Recovering datafiles and archive logs

ALTER TABLESPACE <Tablespace Name> OFFLINE;
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>
ALTER TABLESPACE <Tablespace Name> ONLINE;
相关文档

The document was helpful.

选择评级

I easily found the information I needed.

选择评级