Chat now with support

Get Live Help
Complete Registration

Sign In

Request Pricing

Contact Sales

NetVault Plug-in for Oracle 10.0.5 - User Guide

Table of Contents

Introducing Dell™ NetVault™ Backup Plug-in for Oracle®

Dell NetVault Backup Plug-in for Oracle: at a glance Key benefits Feature summary Target audience Recommended additional reading

Defining a backup strategy

Defining a strategy: overview Reviewing the available backup methods

Recovery Manager (RMAN) backup method

Reviewing the supported Oracle file types Defining an RMAN backup strategy

Reviewing the RMAN Tablespace and Datafile backup types Reviewing the Control File backup types Reviewing the other backup types

Flash Recovery Area (FRA) backups

Developing a Recovery Catalog backup strategy Examples of backup sequences Defining a Backup Destination strategy

Oracle Flashback technology

Installing and removing the plug-in

Prerequisites Prerequisites for RMAN backups

Determining the Oracle SID and Home directory in a non-RAC environment Creating the RMAN repository Registering the target database Enabling Control File Autobackups Enabling Flashback Database Enabling Block Change Tracking

Recommended configuration for a single-instance non-RAC environment Installing the plug-in Removing the plug-in

Configuring the plug-in

Configuring a default Target Set for RMAN backups Configuring default settings Adding a database

Editing database information Setting the database password Removing a saved password Removing a database Viewing database details Using RMAN Post-Backup Scripts

Language support

Backing up data

Performing User Managed backups

Selecting backup options Finalizing and submitting the job

Performing RMAN backups

Setting backup options Finalizing and submitting the job

Backing up Oracle ACFS

Using the Oracle® Flashback Database

Flashback Database: an overview Viewing Flashback Database status Flashback Database options Flashback Database restrictions Restoring data with the plug-in and Flashback Database

Restoring and recovering data: an overview

Recovering datafiles and archive logs

Recovering datafiles and archive logs Restoring Control Files

Understanding RMAN recovery

Choosing between Incremental Backups and Redo Logs Choosing the restore source Datafile media recovery Block Media Recovery

Performing User Managed restores

Selecting data for a restore Finalizing and submitting the job Recovering the database

Using advanced User Managed restore procedures

Renaming or relocating Control File, Datafile, or individual Archived Log files Renaming or relocating the Archive Log Directory

Performing RMAN restores

Setting restore options

Setting the Pre-Restore and general Restore Options Setting recovery options Setting Block Media Recovery options Setting Post Recovery options Setting Destination Details Setting the Recovery Catalog details Setting the Clone Database options Setting Generate RMAN Script options

Finalizing and submitting the job

Using RMAN types of recovery in a non-RAC environment

Recovering individual datafiles and tablespaces to the same server Recovering Whole Database to same server Performing disaster recovery with RMAN

Retrieving a Control File manually

Using advanced procedures with RMAN restores

Duplicating a database in a non-RAC environment

Restoring a Duplicate Database to the same server Restoring a Duplicate Database to an alternate server with the same directory structure Restoring a Duplicate Database to an alternate server with an alternate directory structure

Performing 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

Maintaining the Recovery Catalog

Resynchronizing the Recovery Catalog

Using the RMAN CLI

CLI-based RMAN backups and restores: an overview Prerequisites for CLI-based backups and restores Performing CLI-based backups

More parameters: the "format" clause More parameters: the "send" and "PARMS" clauses Querying the NetVault Backup media name

Performing CLI-based restores

Using the Plug-in with Oracle® RAC

Oracle RACs: an overview Recommended additional reading Defining a deployment strategy

RMAN restore process for RAC environment

Licensing Installing the plug-in in a RAC environment

Installation prerequisites Installing the plug-in

Configuring the plug-in

Determining the local Oracle SID and Home directory in a RAC environment Adding a database to the plug-in

Backing up data Restoring data in a RAC environment

Restoring SPFILE in a RAC environment Restoring Control Files in a RAC environment Performing disaster recovery in a RAC environment Performing restores after node failure Duplicating a database in a RAC environment

Post-restore procedure

Using the Plug-in in a failover cluster environment

Oracle Server Fail Safe Failover Clustering: an overview Installing the plug-in

Installing the software

Licensing the plug-in Configuring the plug-in and adding a database Backing up data Restoring data

Using the plug-in with Oracle® Data Guard

Oracle® Data Guard: an overview Defining a deployment strategy

Back up from both Primary and Standby Back up from Standby only

Single-instance to single-instance Data Guard deployment Multi-instance RAC to single-instance Data Guard deployment Multi-instance RAC to multi-instance RAC Data Guard deployment

Installing the plug-in in a Data Guard environment

Optional RMAN configuration settings

Optional RMAN configuration settings

Installing the plug-in

Backing up data

Creating a User Defined Backup Tag Performing manual backups of Control File and SPFILE

Configuring a restore to an alternate server in a Data Guard environment Restoring data to an alternate server in a Data Guard environment Recovering Whole Database to Primary Database Server

Troubleshooting

NetVault Backup 10.x service (netvault-pgsql) does not start on Windows Unable to add a database Backup fails Backup job hangs Restore fails

Target audience

While advanced Oracle® DBA skills are not required to create and run routine backup operations, they are required for defining the Oracle database backup-and-recovery strategy.

Recommended additional reading

•

NetVault Backup documentation

•

Dell NetVault Backup Installation Guide: This guide provides details on installing the NetVault Backup Server and Client software.

•

Dell NetVault Backup Administrator’s Guide: This guide explains how to use NetVault Backup and describes the functionality common to all plug-ins.

•

Dell NetVault Backup CLI Reference Guide: This guide provides a description of the command-line utilities.

You can download these guides from http://quest.com/support/.


	IMPORTANT: Starting with 10.0.0, NetVault Backup provides a WebUI to configure, manage, and monitor your NetVault Backup system and installed plug-ins. The procedures described in the user’s guide for this version of the plug-in are intended for the new WebUI. For procedures based on the NetVault Backup Console (user interface available with NetVault Backup 9.x), see the documentation for an earlier version of the plug-in.

•

Oracle® Database documentation

•

Oracle Database Backup and Recovery User’s Guide

•

Oracle Database Backup and Recovery Basics

•

Oracle Database Backup and Recovery Reference

•

Oracle Database Backup and Recovery Advanced User's Guide

The Oracle Documentation Libraries can be found at the following links:

•

Oracle 12.1x: http://www.oracle.com/pls/db121/homepage

•

Oracle 11.2x: http://www.oracle.com/pls/db112/homepage

•

Oracle 11.1x: http://www.oracle.com/pls/db111/homepage

•

Oracle 10.2x: http://www.oracle.com/pls/db102/homepage

•

Oracle 10.1x: http://www.oracle.com/pls/db10g/portal.portal_demo3?selected=1

•

Oracle 9.2: http://www.oracle.com/pls/db92/db92.docindex?remark=homepage

Defining a backup strategy

•

Defining a strategy: overview

•

Reviewing the available backup methods

•

Reviewing the supported Oracle file types

•

Defining an RMAN backup strategy

•

Oracle Flashback technology

Defining a strategy: overview

The primary objective of backing up data is to recover from the damage caused by a failure and resume normal operations as quickly as possible. This recovery can be accomplished only if you have a well-designed backup-and-recovery strategy that maximizes data protection and minimizes data loss.

To formulate an efficient strategy, begin with your recovery strategy, which defines your recovery requirements, and the recovery techniques you use to recover from various failure modes, such as media failure, user error, data corruption, and complete loss of the Oracle® Database Server.

Each restore and recovery requirement imposes requirements on your backup strategy. After you have decided on your recovery strategy, you can plan your backup strategy, which will define your backup requirements, including:

•

Oracle features you use to take, store, and manage your backups

•

Backup types you implement

•

Intervals at which you schedule these backups

•

Situations in which you back up the data outside the regular schedule

Typically, when defining a backup strategy, you face a trade-off between mean time to recover (MTTR) and backup space usage.

The sections that follow provide information and guidelines that can help you formulate a backup strategy for use with the plug-in.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating

© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center