β01-30-2018 04:09 AM
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
And save template name
Step 3: On Netbackup Admin Console I create Job backup Oracle
- Add client
- Browse file Template
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!
β01-30-2018 04:29 AM
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
β01-30-2018 04:44 AM
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
β01-30-2018 04:49 AM
Thank to support
Let me create folder and re-backup job
β01-30-2018 04:51 AM
Please check out this TN before trying again: https://www.veritas.com/support/en_US/article.000011425
β01-30-2018 06:46 AM
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 :
β01-30-2018 04:05 PM