Oracle RMAN backups fail when controlfile and spfile autobackups start, all datafiles and logs have been successfully backed up but when the autobackup subjob starts, the backup hangs with no data transfer.
The last line seen in the log is:
-----------------
Starting Control File and SPFILE Autobackup at DD-MMM-YY
-----------------
This only occurs on systems where the RMAN setting CONFIGURE CONTROLFILE AUTOBACKUP is ON.
When using the "autobackup controlfile" RMAN option, the Oracle database will try to backup the controlfile every time there is a structural change in the database that requires a new copy of the controlfile for recovery. Such event as a simple backup of the Oracle datafiles or archived logs. Because this backup is spawned by the RMAN process itself and not NetVault, it launches a CLI backup rather than a GUI driven backup, therefore the CLI options have to be set to tell RMAN where to access the backup media. Proper configuration of the Oracle APM is needed.
1) In RMAN CLI, make sure CONFIGURE CONTROLFILE AUTOBACKUP is ON.
2) In the NetVault Backup Web UI, click Create Backup Job, and click Create New next to the Selections list.
3) Open the Oracle client node, and select Plug-in for Oracle, then from the Actions list, select Configure.
4) Make sure that the following fields are populated, the values are CASE SENSITIVE:
a) "NetVault Backup Server" : Set to the NetVault name of the Netvault server (not the hostname)
b) "Do Restore from NetVault: Backup Server" : Set to NetVault name of the NetVault Server.
c) "Restore Backup taken from NetVault: Backup Client" : Set to the NetVault name of the Client to restore in case of a restore
d) "CLI Backup/Autobackup Advanced Options Set" : Set to an already created Advanced Option set to use for Autobackups
e) "CLI Backup/Autobackup Target Set" : Set to an already created Target set to use for Autobackups
5) Click OK
6) Back to the Create Backup Job page, select the Plug-in for Oracle and select OPEN
7) Select the Oracle database and click the Actions menu to select 'Edit Database'
8) Go to the "RMAN Details" tab and click "Control File Autobackup Enabled (Disables Manual Control File and SPFILE Backups)"
9) Click OK.
The hanging job will need to be aborted and re-run for these options to take effect.
With RMAN configured to perform autobackups and the NetVault Plug-in for Oracle configured to receive the autobackups, next time an Oracle backup is taken, an autobackup subjob will be created to backup the Control File and SPFILE that should complete successfully.
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center