This is an archive version of the document. To get the most up-to-date information, see the current version.

Restore of Control File from Autobackup

You may need to restore the Oracle database control file in the following cases:

If you want to restore the database to a new location where the control file does not exist
If the database control file is lost or corrupted

If you use Veeam Plug-in for Oracle RMAN and want to restore the Oracle database control file from autobackup, the autobackup format must be set to the SBT_TAPE device type.

To check if persistent configuration for the control file autobackup format is set to the SBT_TAPE device type, you can run the SHOW ALL or SHOW CONTROLFILE AUTOBACKUP FORMAT commands in the RMAN console. If the persistent configuration is set, you don't need to set the control file autobackup format before the restore command. If it is not set, you must run the SET CONTROLFILE AUTOBACKUP command before the restore process. See the following examples.

Note

To restore the control file from autobackup, the database must be in the NOMOUNT state.

Restoring Control File if Persistent Configuration Setting is NOT Set

If the persistent configuration for the control file autobackup format is NOT set to the SBT_TAPE device type, you must set the autobackup format before running the control file restore.

RUN {

ALLOCATE CHANNEL c0 DEVICE TYPE sbt PARMS 'SBT_LIBRARY=/opt/veeam/VeeamPluginforOracleRMAN/libOracleRMANPlugin.so';

SET CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE 'SBT_TAPE' TO '%F_RMAN_AUTOBACKUP.vab';

RESTORE controlfile FROM 'c-4097408439-20200410-00_RMAN_AUTOBACKUP.vab';

}

EXIT;

Restoring Control File if Persistent Configuration Setting is Set

If persistent configuration for the control file autobackup format is set to the SBT_TAPE device type, you must set the autobackup format before running the control file restore. To restore the control file, run the following script in the RMAN console:

RUN {

ALLOCATE CHANNEL c0 DEVICE TYPE sbt PARMS 'SBT_LIBRARY=/opt/veeam/VeeamPluginforOracleRMAN/libOracleRMANPlugin.so';

RESTORE controlfile FROM 'c-4097408439-20200410-00_RMAN_AUTOBACKUP.vab';

}

EXIT;