Date - 02/2008
Affected Product & Version - NetVault: Backup 7.4.5, 8.0
Affected Module & Version - APM for Oracle (Version 5.0, 5.1)
OS Version - All Supported Unix/Linux OS
Application Information - Oracle 9.2.x, 10.1.x, 10.2.x
Description:
If the controlfile is included in an Oracle backup, a snapshot of the controlfile is created to ensure consistency. After the backup, the snapshot is released.
However, if for some reason the controlfile backup hangs the snapshot will not release, causing subsequent controlfile jobs to fail.
Below are the Instructions to kill the Oracle process holding on the controlfile snapshot,
Symptoms:
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 ". 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".
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center