Chat now with support
Chat with Support

NetVault Plug-in for Oracle 11.3 - 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 Troubleshooting

Enabling Control File Autobackups

Control File Autobackups are required for disaster recovery with the plug-in. For more information on Control File Autobackups, see Reviewing the Control File backup types. For more information on multi-instance RAC databases, see Enabling Control File Autobackups in a RAC environment.

You can turn on the Autobackup feature by running the following commands from the RMAN command-line utility:

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

Flashback Database uses its own logging mechanism, creating Flashback Logs and storing them in the FRA. You can only use Flashback Database if Flashback Logs are available. To take advantage of this feature, set up your database in advance to create Flashback Logs.

Determining whether Flashback Database is enabled

1
Start SQL*Plus, and connect with administrator privileges to the database.
sqlplus SYS/<password>@<connect_identifier> AS SYSDBA

To enable Flashback Database, first configure an FRA. For more information, see Enabling the Flash Recovery Area in the Oracle Database Backup and Recovery User’s Guide.

Setting a retention target

After ensuring that FRA is configured, perform the following steps to set a flashback retention target. This retention target specifies how far back you can rewind a database with Flashback Database. From the target time onwards, the database regularly copies images of every changed block in the datafiles to the Flashback Logs.

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:
Related Documents