Chat now with support
Chat mit Support

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

Unable to add a database

Problem
When attempting to add a database to the plug-in, the following error appears:
Invalid Credentials.
Unable to configure plugin to connect to this database.
Possible Cause
Connection to the database cannot be established due to LDAP failure.
Resolution
Disable LDAP, and try adding the database again.

Backup fails

This section describes some common errors and their solutions. In those cases where an error occurs and is not described in this table, obtain the Oracle Database error number from the NetVault Backup Logs, and then refer to the relevant Oracle documentation for the resolution.
 
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
1
Abort the hung backup job.
2
Remove the lock on the Control File.
a
Start SQL*Plus, and connect with administrator privileges to the local instance.
SQLPLUS SYS AS SYSDBA
b
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>
c
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
-------- -------------------
130 12118
132 5643
133 3184
134 3100
135 12116
d
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 =>
3
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.
Verwandte Dokumente

The document was helpful.

Bewertung auswählen

I easily found the information I needed.

Bewertung auswählen