NetVault Plug-in for Oracle 7.1

Table 7. Troubleshooting backup failures
Error	Explanation
ORA-00245: control file backup operation failed	For RAC environments that use Oracle 11g Release 2 or later, you must ensure that the snapshot Control File is shared by all nodes in the RAC database. Check the CONFIGURE SNAPSHOT CONTROLFILE NAME TO parameter to determine the current setting. For more information, see Installation prerequisites.
ORA-01031: insufficient privileges on Oracle Backup error	User name specified in the Oracle SYSDBA User Name of the Add (or Edit) Oracle Database dialog must have SYSDBA privileges, be included in the Oracle Password File, or be a member of the ORA_DBA OS group. Additionally, if the SYSDBA user is specified in the Oracle Password File, the Use Oracle Password File Authentication option should be selected in the plug-in’s Configure dialog.
Failed to Connect to Database or ORA-01034: Oracle is not available	Oracle Instance specified in the Oracle SID field of the Add (or Edit) Oracle Database dialog must be in an OPEN state. The instance must be in an OPEN state to perform backup.
ORA-01123: Cannot start online backup; media recovery not enabled	Oracle Instance is not running in ARCHIVELOG mode as specified in Prerequisites.
RMAN-06062: cannot backup SPFILE because the instance was not started with SPFILE	If either Control File Autobackup Enabled or Use RMAN Commands to backup SPFILE are selected on the Add (or Edit) Oracle Database dialog, the database must be started with an SPFILE. Create an SPFILE and restart the instance using the SPFILE or use the Edit Oracle Database option to clear these two options and insert the path for the PFILE in the Parameter File(s) Path field.
RMAN-06180: incremental backups require Enterprise Edition	With Oracle 9i, support for Incremental Backups is limited to Oracle Enterprise Edition. For editions other than Oracle Enterprise Edition on Oracle 9i, Incremental Cumulative and Incremental Differential backups are not supported. Select either Full or Incremental Level 0 for the Backup Type.
RMAN-06181: multiple channels require Enterprise Edition	With Oracle 9i, support for multiple channels during backups and restores is limited to Oracle Enterprise Edition. For editions other than Oracle Enterprise Edition on Oracle 9i, ensure that Number of Channels is set to 1.
Failed to backup all data	If the SYSDBA password has been changed on the Oracle Server, it must be updated in the plug-in’s Database Configuration. For more information, see Removing a saved password.
Flash Recovery Area Backup Fails with 'specification does not match any datafile copy in the repository' or 'specification does not match any backup set in the repository' errors.	A Flash Recovery Area backup was performed, however, the FRA does not contain any recovery files for previous backups that were performed with a Backup Destination of Disk or Both Tape and Disk. You must use the FRA as a Backup Destination before you can perform a backup of the FRA with the Flash Recovery Area backup type.

Backup job hangs

Problem

There is a lock on the Control File and a backup job hangs at log output: “Log Message: Starting Control File and SPFILE Autobackup at <date>.” Or this job is aborted and a subsequent backup job completes with an error message in the log of the job: “ORA-00230: operation disallowed: snapshot control file enqueue unavailable.”

Possible causes

•

Plug‑in for Oracle has not been properly configured; that is, the NetVault Backup Server field has not been set on the Configure dialog.

•

Control File Autobackup has been enabled without proper configuration of the plug-in.

Resolution

Abort the hung backup job.

Remove the lock on the Control File.

Start SQL*Plus, and connect with administrator privileges to the local instance.

SQLPLUS SYS AS SYSDBA

Verify that there is a lock on the Control File, and obtain the offending SID with the following query:

SELECT s.SID, USERNAME AS "User"

FROM V$SESSION s,V$ENQUEUE_LOCK l WHERE l.SID = s.SID

AND l.TYPE = 'CF' AND l.ID1 = 0 AND l.ID2 = 2;

In the following example, the offending SID is 133.

SQL> SELECT s.SID, USERNAME AS "User" FROM V$SESSION s,

V$ENQUEUE_LOCK l WHERE l.SID = s.SID AND l.TYPE =

'CF' AND L.ID1 = 0 AND l.ID2 = 2;

SID User

-------- -------------------

133 SYS

SQL>

Obtain the Process ID (SPID) that matches the SID with the following query:

SELECT s.sid,p.spid

FROM v$process p, v$session s

WHERE p.addr = s.paddr order by s.sid;

In the following example, the offending SPID is 3184.

SQL> SELECT s.sid,p.spid FROM v$process p, v$session s

WHERE p.addr = s.paddr order by s.sid;

SID SPID

-------- -------------------

Exit SQL*Plus, and stop the Process in the OS shell:

Kill -9 <spid>

Example:

SQL> exit

Disconnected from Oracle Database 10g Enterprise Edition

10.2.0.1.0 - 64 bit Production

With the Partitioning, Real Application Clusters, OLAP and

Data Mining options

izmir:/export/home/o10g => kill -9 3184

izmir:/export/home/o10g =>

Ensure that the NetVault Backup Server and Do Restore from NetVault Backup Server fields are defined in the default attributes as detailed in Configuring default settings.

Restore fails

Table 8. 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 will bring 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.

Please select your product:

To serve you better, please complete the Purpose of your Chat:

Recommended Solutions for Your Problem

NetVault Plug-in for Oracle 7.1 - User Guide

Unable to add a database

Backup fails

Backup job hangs

Restore fails