cancel
Showing results forΒ 
Search instead forΒ 
Did you mean:Β 

Backup Oracle Failed

ducanhct
Level 3

Hi Everyone,

Today, I have configure Netbackup for Oracle but I have issue

This is my step config Oracle:

Step 1: I create link Oracle with Netbackup

 

[root@DC-DOCDB01 ~]# su - oracle
Last login: Mon Jan 29 15:02:10 ICT 2018 from 10.62.225.123 on pts/1
[oracle@DC-DOCDB01 ~]$ /usr/openv/netbackup/bin/oracle_link 
Tue Jan 30 14:25:03 ICT 2018
All Oracle instances should be shutdown before running this script.

Please log into the Unix system as the Oracle owner for running this script

Do you want to continue? (y/n) [n] y


LIBOBK path: /usr/openv/netbackup/bin
ORACLE_HOME: /u01/app/oracle/12.1.0/db
Oracle version: 12.1.0.2.0
Platform type: x86_64
Linking LIBOBK:
ln -s /usr/openv/netbackup/bin/libobk.so64 /u01/app/oracle/12.1.0/db/lib/libobk.so
Done

Please check the trace file located in /tmp/make_trace.28294 
to make sure the linking process was successful.
[oracle@DC-DOCDB01 ~]$

Step 2:

I configure

2018-01-30_15-13_1.png

2018-01-30_16-03_2.png

And save template name

2018-01-30_16-12_3.png

Step 3: On Netbackup Admin Console I create Job backup Oracle

- Add client

- Browse file Template

2018-01-30_16-31_4.png

But when I start Manual Backup. I see my job backup fail and I check log backup

Jan 30, 2018 5:24:32 PM - Info bpbrm (pid=38345) DC-DOCDB02.sav.local is the host to backup data from
Jan 30, 2018 5:24:32 PM - Info bpbrm (pid=38345) reading file list for client
Jan 30, 2018 5:24:33 PM - Info bpbrm (pid=38345) starting bphdb on client
Jan 30, 2018 5:24:33 PM - Info bphdb (pid=38365) Backup started
Jan 30, 2018 5:24:33 PM - Info bphdb (pid=38365) Processing 3a44424e414d453a68736b7464623a4442484f4d453a2f7530312f6170702f6f7261636c652f31322e312e302f64623a44424e45544e414d453a48534b5444425f424b:DBTEMPLATENAME:docdb02_template.tpl
Jan 30, 2018 5:24:33 PM - Info bphdb (pid=38365) Waiting for the child status
Jan 30, 2018 5:24:45 PM - Info nbjm (pid=1432) starting backup job (jobid=108) for client DC-DOCDB02.sav.local, policy BK_DOCDB02, schedule fullbk
Jan 30, 2018 5:24:45 PM - Info nbjm (pid=1432) requesting MEDIA_SERVER_WITH_ATTRIBUTES resources from RB for backup job (jobid=108, request id:{10A6743C-3454-4BED-8705-E94B51FE2DC8})
Jan 30, 2018 5:24:45 PM - requesting resource  DC-DOCDB02-hcart3-robot-tld-0
Jan 30, 2018 5:24:45 PM - requesting resource  dc-backup01.sav.local.NBU_CLIENT.MAXJOBS.DC-DOCDB02.sav.local
Jan 30, 2018 5:24:45 PM - requesting resource  dc-backup01.sav.local.NBU_POLICY.MAXJOBS.BK_DOCDB02
Jan 30, 2018 5:24:45 PM - granted resource  dc-backup01.sav.local.NBU_CLIENT.MAXJOBS.DC-DOCDB02.sav.local
Jan 30, 2018 5:24:45 PM - granted resource  dc-backup01.sav.local.NBU_POLICY.MAXJOBS.BK_DOCDB02
Jan 30, 2018 5:24:45 PM - granted resource  DC-DOCDB02-hcart3-robot-tld-0
Jan 30, 2018 5:24:45 PM - estimated 0 kbytes needed
Jan 30, 2018 5:24:45 PM - Info nbjm (pid=1432) started backup (backupid=DC-DOCDB02.sav.local_1517307885) job for client DC-DOCDB02.sav.local, policy BK_DOCDB02, schedule fullbk on storage unit DC-DOCDB02-hcart3-robot-tld-0
Jan 30, 2018 5:24:47 PM - started process bpbrm (pid=38345)
Jan 30, 2018 5:24:47 PM - connecting
Jan 30, 2018 5:24:47 PM - connected; connect time: 0:00:00
Jan 30, 2018 5:24:46 PM - Error bpbrm (pid=38345) from client DC-DOCDB02.sav.local: ERR - Script exited with status = 1 <the requested operation was partially successful>
Jan 30, 2018 5:24:46 PM - Error bpbrm (pid=38345) from client DC-DOCDB02.sav.local: ERR - bphdb exit status = 6: the backup failed to back up the requested files
Jan 30, 2018 5:24:46 PM - Info bphdb (pid=38365) done. status: 6: the backup failed to back up the requested files
Jan 30, 2018 5:25:01 PM - end writing
the backup failed to back up the requested files  (6)

Everyone, help me pls!

 

 

 

6 REPLIES 6

Michal_Mikulik1
Moderator
Moderator
Partner    VIP    Accredited Certified

Hello,

create the following directory on the Oracle client , reattempt the backup, and then review/send logs created in the directory:

/usr/openv/netbackup/logs/dbclient

Regards

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified

Status 6 means that the script is failing on the client side.

The database that you have selected seems to be in READ ONLY mode. Is that correct?

Please have a look at this TN for requirements to perform hot database backups:
https://www.veritas.com/support/en_US/article.000011425

If all is good on Oracle side, you can copy the template from the master server to a script on the client. Review the script carefully and ensure all parameters are correct. Check that an output file is specified in the script where Oracle rman can write output.
Ensure that /usr/openv/netbackup/logs/dbclient folder exists with 777 permissions.
Run the script on the client as oracle user. Review rman output file and dbclient log.

 

Better option is to config Oracle Intelligent Policy as per this section in NBU for Oracle Guide: 
https://www.veritas.com/content/support/en_US/doc/124801971-127135984-0/v121719017-127135984

Thank to support

Let me create folder and re-backup job

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified

Please check out this TN before trying again: https://www.veritas.com/support/en_US/article.000011425

 

Nicolai
Moderator
Moderator
Partner    VIP   

I can only recommend using Intelligent Policies for Oracle, its very easy to use and setup.

Also try to create :

\netbackup\logs\bpdbsbora

With a bit of luck rman out put may be present in that log file.

See :

https://www.mass.dk/netbackup-quick-hints/rman-input-output-using-intelligent-polices-in-netbackup-7...

In case you attempt the backup with script for testing purpose instead of the template or OIP and it fails then the bphdb folder is needed on the client machine for script related outputs.. bpdbsbora would only apply for OIP or templates.. If the script is not able to connect to Rman then probably the dbclient folder would be empty after the failure