Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

oracle backup template is not running on "oracle enterprise linux" OEL client

Created: 11 May 2013 | 10 comments

Hi all,

i am having the following environment:
NBU 7.5.0.3 master server running on Solaris 10 X64 machine
NBU 7.5 client on OEL machine  running OEL 6.3
oracle DB is 11gr2

steps i followed to take the backup:
1- I installed the client from the UNIX_Client.tar file on the OEL client
2- shutdown the databse to execute the oracle-link script
3- ./oracle-link.sh was successfull
4- creating a template through the ./jbpSA through the client interface, i accessed the oracle instance with a user that has sysdba privileges.
5- create the policy and putting in the backup selection the template that i created before

whenever i run the policy, the job started and seems to be hang at the follwing prompt:
"waiting for chiled process",
i left that for more than 4 hours but nothing happened.
below is the output from the job details window:

05/11/2013 16:29:35 - Info bpbrm (pid=10802) Client123 is the host to backup data from
05/11/2013 16:29:35 - Info bpbrm (pid=10802) reading file list from client
05/11/2013 16:29:36 - Info bpbrm (pid=10802) starting bphdb on client
05/11/2013 16:29:36 - Info bphdb (pid=12856) Backup started
05/11/2013 16:29:36 - Info bphdb (pid=12856) Processing 3a44424e414d453a4d494d49523a4442484f4d453a2f7530332f6170702f6f7261636c652f70726f647563742f31312e322e302f64625f313a44424e45544e414d453a4d494d4952:DBTEMPLATENAME:oracleMIMER3.tpl
05/11/2013 16:29:36 - Info bphdb (pid=12856) Waiting for the child status
05/11/2013 16:29:34 - Info nbjm (pid=27293) starting backup job (jobid=39673) for client Client123, policy mimir, schedule Full
05/11/2013 16:29:34 - Info nbjm (pid=27293) requesting MEDIA_SERVER_WITH_ATTRIBUTES resources from RB for backup job (jobid=39673, request id:{D20AB630-BA3E-11E2-96B3-00269E9C1838})
05/11/2013 16:29:34 - requesting resource SL500-Bserver-hcart-robot-tld-0
05/11/2013 16:29:34 - requesting resource SL500-Bserver.NBU_CLIENT.MAXJOBS.Client123
05/11/2013 16:29:34 - requesting resource SL500-Bserver.NBU_POLICY.MAXJOBS.mimir
05/11/2013 16:29:34 - granted resource  SL500-Bserver.NBU_CLIENT.MAXJOBS.Client123
05/11/2013 16:29:34 - granted resource  SL500-Bserver.NBU_POLICY.MAXJOBS.mimir
05/11/2013 16:29:34 - granted resource  SL500-Bserver-hcart-robot-tld-0
05/11/2013 16:29:35 - estimated 0 kbytes needed
05/11/2013 16:29:35 - Info nbjm (pid=27293) started backup (backupid=Client123_1368278974) job for client Client123, policy mimir, schedule Full on storage unit SL500-Bserver-hcart-robot-tld-0
05/11/2013 16:29:35 - started process bpbrm (pid=10802)
05/11/2013 16:29:35 - connecting
05/11/2013 16:29:36 - connected; connect time: 0:00:00
 
any help please.
thank you
Operating Systems:

Comments 10 CommentsJump to latest comment

Marianne's picture

Please show us the policy config.

On master server, run :
bppllist <policy-name> -U

On client, create all of the following log folders under /usr/openv/netbackup/logs:

bpcd dbclient bphdb

Change permissions on dbclient and bphdb to 777.

Please rename client logs to reflect process name (e.g. bpcd.txt) and post as File attachments.

Supporting Storage Foundation and VCS on Unix and Windows as well as NetBackup on Unix and Windows
Handy NBU Links

grigori's picture

Hi Marianne,

thank you for your reply,
I have attached the files you requested, please note that nothing is in the /dbclient so I attached bpcd files and bphdb.

also below is the output of the bppllist:

bppllist mimir -U
------------------------------------------------------------
 
Policy Name:       mimir
 
  Policy Type:         Oracle
  Active:              yes
  Effective date:      05/08/2013 16:54:52
  Block Incremental:   no
  Mult. Data Streams:  no
  Client Encrypt:      no
  Checkpoint:          no
  Policy Priority:     0
  Max Jobs/Policy:     Unlimited
  Disaster Recovery:   0
  Collect BMR info:    no
  Residence:           SL500-Bserver-hcart-robot-tld-0
  Volume Pool:         MIMER-pool
  Server Group:        *ANY*
  Keyword:             (none specified)
  Data Classification:       -
  Residence is Storage Lifecycle Policy:    no
  Application Discovery:      no
  Discovery Lifetime:      0 seconds
ASC Application and attributes: (none defined)
 
  Granular Restore Info:  no
  Ignore Client Direct:  yes
Enable Metadata Indexing:  no
Index server name:  NULL
  Use Accelerator:  no
  HW/OS/Client:  Linux         RedHat2.6     Client123
 
  Include:  oracleMIMER3.tpl
 
  Schedule:              Full
    Type:                Automatic Full Backup
    Frequency:           every 7 days
    Maximum MPX:         1
    Synthetic:           0
    Checksum Change Detection: 0
    PFI Recovery:        0
    Retention Level:     9 (infinity)
    Number Copies:       1
    Fail on Error:       0
    Residence:           (specific storage unit not required)
    Volume Pool:         (same as policy volume pool)
    Server Group:        (same as specified for policy)
    Residence is Storage Lifecycle Policy:         0
    Schedule indexing:     0
    Daily Windows:
 
  Schedule:              Default-Application-Backup
    Type:                Application Backup
    Maximum MPX:         1
    Synthetic:           0
    Checksum Change Detection: 0
    PFI Recovery:        0
    Retention Level:     3 (1 month)
    Number Copies:       1
    Fail on Error:       0
    Residence:           (specific storage unit not required)
    Volume Pool:         (same as policy volume pool)
    Server Group:        (same as specified for policy)
    Residence is Storage Lifecycle Policy:         0
    Schedule indexing:     0
    Daily Windows:
          Sunday     00:00:00  -->  Sunday     24:00:00
          Monday     00:00:00  -->  Monday     24:00:00
          Tuesday    00:00:00  -->  Tuesday    24:00:00
          Wednesday  00:00:00  -->  Wednesday  24:00:00
          Thursday   00:00:00  -->  Thursday   24:00:00
          Friday     00:00:00  -->  Friday     24:00:00
          Saturday   00:00:00  -->  Saturday   24:00:00
AttachmentSize
bpcd.txt 64.7 KB
bphdb.txt 8.41 KB
grigori's picture

actually I didnt find anything strange in the files unless the entry that "prefix" the template name in the JO details:
3a44424e414d453a4d494d49523a4442484f4d453a2f7530332f6170702f6f7261636c652f70726f647563742f31312e322e302f64625f313a44424e45544e414d453a4d494d.
what do you think?
is there anything that I couldnt take care about?

Marianne's picture

In all honesty - no idea why the actual backup on the client is not starting.

At this point I would ask assistance from Oracle dba to see what happens if rman is used from cmd on the client to start the backup.

The other option is to log a support call...

Supporting Storage Foundation and VCS on Unix and Windows as well as NetBackup on Unix and Windows
Handy NBU Links

grigori's picture

thank you Marianne,

do you think there is any difference in policy setup configuration when the oracle database is of ASM structure? isnt it the same as backing up the normal Oracle DB?
 

Will Restore's picture
Schedule:              Full

 Daily Windows:

(nothing)

Does your policy really have no window defined in the Full schedule? 

Will Restore -- where there is a Will there is a way

grigori's picture

thanks wr,
the whole problem was in the link between netbackup and the oracle DB,

the oracle-link script didnt create the symbolik link of the "libobk.so" file, when i created the link the backup went smoothly
thanks all for your replies.

Marianne's picture

11 May:

3- ./oracle-link.sh was successfull

Today: 

the oracle-link script didnt create the symbolik link of the "libobk.so" file,

So then, there was no way we would know what the actual problem was....

If if rman was used from cmd on the client as per my suggestion on 13 May, it would become clear that the link was missing.

Glad you got it sorted!

Supporting Storage Foundation and VCS on Unix and Windows as well as NetBackup on Unix and Windows
Handy NBU Links

grigori's picture

it was strange for me also the script showed clearly that the link has been created successfully also when i looked into the log file it generated, at the end of it, it was clear that the script has been done successfully, my fault was by not checking the presence of the library file as i "trusted" the output of the script.
thanks again for the help :)

huanglao2002's picture

From my experience if oracle link failed, oracle backup will report job failed whith status code 6. The oracle backup job backup scripts output also report media manager layout  failed.

You can check the network connection between Client123 \ SL500-Bserver.

Please referenct http://www.symantec.com/business/support/index?page=content&id=TECH42657