Monday , May 27 2019
Home / HP Data Protector / Deployment / Fail to restore of Data Protector managed control file backup

Fail to restore of Data Protector managed control file backup

When you plan to restore Oracle database, in both standalone or RAC environment, you might face issue with restore of Data Protector managed control file backup.

Detail error code:

[Major] From: OB2BAR_DMA@oralxnode01.testlab.local “racdb” Time: 4/7/2016 8:30:51 AM
Failed to restore file ‘/var/opt/omni/tmp/ctrl_racdb_4793.dbf’.

[Normal] From: OB2BAR_DMA@oralxnode01.testlab.local “racdb” Time: 4/7/2016 8:30:51 AM
Restore Profile:

Run Time ……….. 0:00:07
Restore Speed …… 2.54 MB/s

[Normal] From: OB2BAR_DMA@oralxnode01.testlab.local “racdb” Time: 4/7/2016 8:30:51 AM
Completed OB2BAR Restore: oralxnode01-vip.testlab.local:racdb DP Managed Control File Backup “Oracle8”

[Major] From: OB2BAR_DMA@oralxnode01.testlab.local “racdb” Time: 4/7/2016 8:30:51 AM
Aborting connection to RSM. Abort code -7.

[Major] From: ob2rman@oralxnode01.testlab.local “racdb” Time: 04/06/2016 09:30:52 PM
[12:8010] Internal error.

[Major] From: ob2rman@oralxnode01.testlab.local “racdb” Time: 04/06/2016 09:30:52 PM
Restore of Data Protector managed control file backup failed.

[Major] From: ob2rman@oralxnode01.testlab.local “racdb” Time: 04/06/2016 09:30:52 PM
Restore of target database failed.

Suggestion to check:

  1. Make sure target oracle database server must be in “No mount state”
  2. You can test by sqlplus to see:SQL> select * from v$thread;
    SQL> archive log list;
    ORA-01507: database not mounted
  3. Make sure listener was properly/ready on target Oracle host

Enable DP debug GUI with range: 1-500,C:10000,T:1000 control.txt

On Oracle hosts, add on omnirc debug value:

OB2DBGDIR=/yourlocation (make sure this have full permission to write)

OB2DBG=1-500,C:10000,T:1000 control.txt

4. Restart GUI/Inet service on CM and run GUI 1 time only

5. Reproduce issue and collect full session report and debug file at /yourcation

Findings:

On debug file:

DEBUGGING STARTED
PROGNAME: OB2BAR
VERSION: A.09.00 Build 104
RANGES: 1-500,C:10000,T:1000,ID:5236
SELECT:
FILE: /DP_DEBUG/OB2DBG_5236__OB2BAR_oralxnode01.testlab.local_5236_control.txt

[ 99] 2016-04-06 21:53:52.422 (“/cs/csa/mcsa.c $Rev: 48979 $ $Date:: 2015-06-29 18:05:49”:266)
[ 99] ===>> (3) MCsaInitEx {
[ 99] Args: host:dcpr01.testlab.local, user:oracle, group:oinstall

[ 99] 2016-04-06 21:54:37.458 (“/integ/dma/dmautils.c $Rev: 47816 $ $Date:: 2015-04-13 09:59:41”:587)
[ 99] ===>> (2) DMA_SetFileAttributes {
[ 99] [ -2] 2016-04-06 21:54:37.458 (“/integ/dma/dmautils.c $Rev: 47816 $ $Date:: 2015-04-13 09:59:41”:622)
[ -2] chown(/var/opt/omni/tmp/ctrl_racdb_5226.dbf, 1101, 1200) failed with err=-1
[ 99] 2016-04-06 21:54:37.458 (“/integ/dma/dmautils.c $Rev: 47816 $ $Date:: 2015-04-13 09:59:41”:628)
[ 99] <<=== (2) } /* DMA_SetFileAttributes */
[ 99] [ 99] 2016-04-06 21:54:37.458 (“/integ/dma/restore.c $Rev: 47816 $ $Date:: 2015-04-13 09:59:41”:193)
[ 99] <<=== (1) } /* DMA_RestoreFile */
[ 99] RetVal: (int) -1
[ 99] [130] 2016-04-06 21:54:37.458 (“/integ/dma/restore.c $Rev: 47816 $ $Date:: 2015-04-13 09:59:41”:768)
[130] [DoRestore] Restore error: marked 0, syserr 0
[100] *************** NlsPackMessage [START] ***************
[100] Message [144:239] [100] Let’s collect data from stack …
[100] Simple message = /var/opt/omni/tmp/ctrl_racdb_5226.dbf
[100] Returned message (RetVal): 15 [144:239] /var/opt/omni/tmp/ctrl_racdb_5226.dbf

-> This means user which set in DP GUI Oracle restore is oracle:oinstall and dont have full rights to write on folder:

/var/opt/omni/tmp

Solution:

  1. Make sure /var/opt/omni/tmp has set full permission for user used to restore Oracle: oracle:oinstall
  2. Or you can put root user during restore

Ex: root:root

About admin

Check Also

Easy steps to build your own Oracle Linux RAC 11g R2

LAB requirements Setup /etc/hosts file on both RAC nodes #Public network 190.168.10.161 oralxnode01dr.testlab.local oralxnode01dr 190.168.10.162 …

Leave a Reply