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

NetVault Plug-in for Oracle 10.0.5 - 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-in in a failover cluster environment Using the plug-in with Oracle® Data Guard Troubleshooting Glossary

Creating the RMAN repository

As discussed in Choosing the location for the RMAN repository, for an RMAN backup strategy you must first choose a location for the RMAN repository. By default, this repository is maintained in the Control File. However, for larger or more mission-critical databases, create a Recovery Catalog database that can store a much longer history than the Control File.
1
Start SQL*Plus, and connect with administrator privileges to the database that will contain the Recovery Catalog.
sqlplus SYS/<password>@<connect_identifier> AS SYSDBA
3
Grant the RECOVERY_CATALOG_OWNER role to the schema owner.
4
Grant the CONNECT role to the rman user.
After creating the catalog owner, create the catalog tables with the RMAN CREATE CATALOG command. This command creates the catalog in the default tablespace of the catalog owner.
> rman CONNECT CATALOG rman/<password>@<connect_identifier_for_catalog>
2
Run the CREATE CATALOG command to create the catalog.
CREATE CATALOG TABLESPACE <tablespace_name>;

Registering the target database

> rman TARGET / CATALOG rman/<password>@<connect_identifier_for_catalog>

Enabling Control File Autobackups

> rman TARGET / CATALOG rman/<password>@<connect_identifier for catalog>
TYPE <device type> TO '<string>'

Enabling Flashback Database

Flashback Database lets you rewind an Oracle® database to a previous time to correct problems caused by logical data corruptions or user errors as long as the datafiles are intact. For more information on Flashback Database, see Oracle Flashback technology.
1
Start SQL*Plus, and connect with administrator privileges to the database.
sqlplus SYS/<password>@<connect_identifier> AS SYSDBA
To enable Flashback Database, you must first configure an FRA. For more information, see Enabling the Flash Recovery Area in the Oracle Database Backup and Recovery User’s Guide.
1
Start SQL*Plus, and connect with administrator privileges to the database.
sqlplus SYS/<password> AS SYSDBA
3
Optionally, set the DB_FLASHBACK_RETENTION_TARGET to the length of the desired flashback window in minutes.
By default, DB_FLASHBACK_RETENTION_TARGET is set to one day (1440 minutes). To set the flashback window, issue the following commands:
Documents connexes

The document was helpful.

Sélectionner une évaluation

I easily found the information I needed.

Sélectionner une évaluation