Chat now with support
Chat with 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

Restore fails

 
Table 6. Troubleshooting restore failures
Error
Explanation
•
ORA-19511: Error received from media manager, error text: SBT error=7011, errno=1, sbtopen: system error
•
ORA-19511: Error received from media manager layer, error text: SBT error= 7063, errno = 0, sbtread: i/o error
•
ORA-27007: failed to open file
•
ORA-27012: Read from file failed
Ensure that NetVault Backup Server and Do Restore from NetVault Backup Server settings are defined as detailed in Configuring default settings.
•
RMAN-03002: failure of Duplicate Db command at <date_hour>
•
RMAN-03015: error occurred in stored script Memory Script
•
RMAN-06054: media recovery requesting unknown log: thread <number> scn <number>
On Oracle® 9i, the plug-in’s Clone Database operation might complete with errors due to RMAN attempting to apply a log beyond the available logs in the backup stream.
RMAN-06054: media recovery requesting unknown log: thread <n> seq 40 scn <n>
This error might occur while performing a Clone Database operation. This error results because the old Control File has no record of the new archive log. Running the RMAN command ALTER DATABASE OPEN RESETLOGS brings the database online.
Warning (.. ..) Data Plug-in (… …) Failed with exit code 5
This warning appears if Block Media Recovery is selected with Oracle 11g databases. In spite of the “failed” message, the recovery completes with success and full access to the Oracle recovered data is granted.
The code 5 is a warning issued by Oracle 11g to let you know that recovery is necessary. Because the plug-in already includes the RMAN recovery command while performing Block Media Recovery, this message can be ignored.

Glossary

A
Automatic Storage Management (ASM)
Integrated File System and Volume Manager expressly built for Oracle® database files.
B
backup piece
Backup file generated by RMAN. Backup pieces are written in a proprietary format that can only be created or restored by RMAN and are stored in a logical container called a backup set.
backup set
Backup of one or more datafiles, Control Files, SPFILE, and archived redo log files. Each backup set consists of one or more binary files called backup pieces. By default, a backup set consists of only one backup piece.
Block Media Recovery
Recovers only the damaged or corrupted blocks within a datafile using RMAN and leaves the affected datafiles online.
C
Complete Recovery
Recovers the database to the most recent time without the loss of any committed transactions. Typically, you perform Complete Recovery when media failure damages one or more datafiles or Control Files.
Cumulative Incremental Backup
Incremental Backup that backs up all the blocks changed since the most recent backup at Level 0. When recovering with Cumulative Incremental Backups, only the most recent Cumulative Incremental Backup needs to be applied.
D
Database Point-in-Time Recovery (DBPITR)
Recovers an entire database to a specified past target time, SCN, or log sequence number.
Data Guard
Distributed computing system that prevents or minimizes losses due to unplanned events such as human errors, environmental disasters, or data corruption, as well as to planned downtime due to routine maintenance tasks.
database identification (DBID)
An internal, uniquely generated number that differentiates databases. Oracle creates this number automatically when you create the database. The DBID is needed during disaster recovery scenarios.
Differential Incremental Backup
Incremental Backup that backs up all blocks that have changed since the most recent backup at Level 1 or Level 0. Differential Backups are the default type of Incremental Backup. When recovering using Differential Incremental Backups, the plug-in must apply all Differential Incremental Level 1 Backups since the restored tablespace backup.
Duplicate Database
Database created from target database backups using the RMAN duplicate command.
F
Flashback Database
Return of the whole database to a prior consistent SCN. A database flashback is different from traditional media recovery because it does not involve the restore of physical files, instead restoring your current datafiles to past states using saved images of changed data blocks.
Flash Recovery Area (FRA)
Optional disk location that you can use to store recovery-related files such as Control File and online redo log copies, archived redo log files, flashback logs, and RMAN backups. Oracle and RMAN manage the files in the FRA automatically.
I
instance
Combination of background processes and memory buffers.
L
log sequence number (LSN)
Number that uniquely identifies a set of redo records in a redo log file. When Oracle fills one online redo log file and switches to a different one, Oracle automatically assigns the new file a log sequence number.
O
Oracle Clusterware
Portable cluster-management solution that is integrated with the Oracle database.
P
parallelism
Allocating multiple channels for simultaneous RMAN backup and recovery operations. Allows a single job to read or write multiple backup sets in parallel. The number of channels should be less than or equal (<=) to the number of drives for the backup devices.
R
Real Application Clusters (RAC)
Support for the transparent deployment of a single database across a cluster of servers, providing fault tolerance from hardware failures or planned outages.
recovery
Recovering a datafile is taking a restored copy of the datafile and applying to it changes recorded in the database’s archived and online redo logs. Term is frequently used to encompass both the restore and recovery processes.
Recovery Manager (RMAN)
Preferred utility for backup and recovery of Oracle databases. RMAN backups provide maximum reliability while providing the most flexibility when defining a backup strategy. Support for a range of backup types and options available with Oracle's RMAN tool are provided. Also included is the ability to perform a number of recovery scenarios with less reliance on human interaction and DBA expertise.
RMAN also reduces the administrative work associated with your backup strategy by maintaining an extensive record of metadata about backups, archive logs, and its own activities. This information is known as the RMAN repository. In restore operations, RMAN uses this information to eliminate the need to identify backup files for use in restores in most situations.
resetlogs
Method for opening a database, which is required after incomplete recovery or recovery with a backup Control File. OPEN RESETLOGS resets the log sequence number to 1, and clears the online redo logs.
Backups from before the OPEN RESETLOGS operation remain valid and can be used along with backups taken after the OPEN RESETLOGS operation to repair any damage to the database.
restore
Retrieve a datafile or Control File onto disk from a backup location on tape, disk, or other media, and make it available to the database server.
S
system change number (SCN)
Stamp that defines a committed version of a database at a specific point. Oracle assigns every committed transaction a unique SCN.
System Global Area (SGA)
Memory region within main memory used to store data for fast access.
U
User Managed backup method
Files that make up the database are fundamentally backed up and restored with a mixture of host OS commands and SQL*Plus backup- and recovery-related capabilities.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating