Restoring from Data Protector managed control file backup

Idea ID 1662943

Restoring from Data Protector managed control file backup

Actual Behavior

DP10.04

When restoring oracle control from Data Protector managed control file backup of Data Protector GUI, the control files are restored to the default Data Protector temporary files directory, then executing RMAN script to restore the file where the temporary files.

*************************************

Restoring from Data Protector managed control file backup (CONTROLFILE FROM DP MANAGED BACKUP)
The control file was backed up automatically by ob2rman.pl at the end of a backup session, unless the option Disable Data Protector managed control file backup was selected.
The recovery catalog is not required for this restore option.
The control files (ctrl DB_NAME.dbf) are restored to the default Data Protector temporary files directory.
NOTE:
In Oracle Real Application Clusters (RAC) environments with Oracle versions 11.2.0.2 and later, the control files are created at, backed up from, and restored to the location defined by the OB2_DPMCTL_SHRLOC variable. This directory must reside on a shared disk and be accessible from all RAC nodes in order for restore sessions to succeed.

After the restore, execute the following script:
run {

allocate channel 'dev0' type disk;

restore controlfile from 'TMP_FILENAME';

release channel 'dev0';

}
Where TMP_FILENAME is the location to which the file was restored.

*************************************

 

When the client tests the restore control file from the RAC environment to the oracle stand-alone machine, the session report displays the following information:

[Major] From: OB2BAR_DMA@dptest02 "catalog" Time: 8/12/2018 9:25:48 AM
Failed to restore file '/var/opt/omni/tmp/ctrl_catalog_20279.dbf'.

In fact, the file has been restored to the database operating system, and it also needs to execute the restore control file from '/var/opt/omni/ restored control file';
Looking at the debug log, customer found a similar error, which is a mistake when changing file permissions:
2018-07-26 17:37:06.021 OB2BAR_DMA.2430.0 ["/integ/dma/dmautils.c $Rev: 55015 $ $Date:: 2016-10-06 07:01:23 ":629] A.10.03 b182
Chown(/var/opt/omni/tmp/ctrl_db11g_2417.dbf, 500, 500) failed with err=-1

So customer thinks that the operation of restoring the control file to the temporary directory does not need to exist, he hopes to directly restore control files to the oracle database, or do not display the error message in the restore session report.

2 Comments
Micro Focus Contributor
Micro Focus Contributor
Status changed to: Waiting for Votes
 
Micro Focus Expert
Micro Focus Expert
Status changed to: Declined

@Nan 

based on the number of votes we see this request is not supported by enough interest and is not considered for integration. You may want to check with support for integration behavior.

It is therefore declined.

The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.