need know about parent job

[RajkumarBaniwal]

Hi experts,

Having two queries

1. My FTP(VM) server, whose backup is running through netbackup client(not through Netbackup VM).Now I started backup with mutilple streaming for all drives i.e. C,D,E,F, Backup of F drive (child stream) is failed with 156 (snapshot error encountered) and I restarted that job and then its completed but at last parent job failed with 156 error, In BAR, backup of all drives is available. Now can anyone please let me know wheteher this backup can be considered as successful?

2. One RMAN backup whose parent job failed with 6 error code due to mount point inconsistency (I/O error), but some of its child job completed and wrote data to media. This backup is of no use. As per my knowledge, completed child jobs data should be expired automatically if its parent job failed, but Now as per client backup report on master server, its showing completed child jobs.

Master server Solaris 10, netbackup 7.1.0.3

Media server Solaris 10, netbackup 7.1.0.3

FTP server : Win2003 

Db server: Solaris 10, Oracle 11G

[RiaanBadenhorst]

1. Your FS backup is valid
2. You can expire those images. NetBackup depends on oracle to send it the "set" of data stream which make up the database. If something happens to a stream you have a broken set, so it probably of no use (at least for full recovery). I would run the backup again.

[RajkumarBaniwal]

thanks Riaan,

1.Need to know why this parent job is failed while all its child job completed. and also its failed with 156 error while backup is through netbackup client.

2. Can Netbackup not automatically expire those images?

[RiaanBadenhorst · Accepted solution]

1. Post the detailed status of the parents jobs
2. That question was answered here https://www-secure.symantec.com/connect/forums/oracle-db-backups-using-excess-media (they should disappear after 24 hours)

[RajkumarBaniwal]

1.

7/23/2014 6:00:06 PM - granted resource UNF014
7/23/2014 6:00:06 PM - granted resource HP.ULTRIUM4-SCSI.002
7/23/2014 6:00:06 PM - granted resource gnnbkp01-hcart-robot-tld-0
7/23/2014 6:00:24 PM - estimated 43624 Kbytes needed
7/23/2014 6:00:24 PM - begin Parent Job
7/23/2014 6:00:24 PM - begin Snapshot, Start Notify Script
7/23/2014 6:00:24 PM - Info RUNCMD(pid=9586) started            
7/23/2014 6:00:24 PM - Info RUNCMD(pid=9586) exiting with status: 0         
Status 0
7/23/2014 6:00:24 PM - end Snapshot, Start Notify Script; elapsed time: 00:00:00
7/23/2014 6:00:24 PM - begin Snapshot, Step By Condition
Status 0
7/23/2014 6:00:24 PM - end Snapshot, Step By Condition; elapsed time: 00:00:00
7/23/2014 6:00:24 PM - begin Snapshot, Stream Discovery
Status 0
7/23/2014 6:00:24 PM - end Snapshot, Stream Discovery; elapsed time: 00:00:00
7/23/2014 6:00:24 PM - begin Snapshot, Read File List
Status 0
7/23/2014 6:00:24 PM - end Snapshot, Read File List; elapsed time: 00:00:00
7/23/2014 6:00:24 PM - begin Snapshot, Create Snapshot
7/23/2014 6:00:24 PM - started
7/23/2014 6:00:25 PM - started process bpbrm (9594)
7/23/2014 6:00:27 PM - Info bpbrm(pid=9594) gnnftp01-bkp is the host to backup data from     
7/23/2014 6:00:27 PM - Info bpbrm(pid=9594) reading file list from client        
7/23/2014 6:00:27 PM - Info bpbrm(pid=9594) start bpfis on client         
7/23/2014 6:00:27 PM - begin Create Snapshot
7/23/2014 6:00:29 PM - Info bpfis(pid=3804) Backup started           
7/23/2014 6:03:10 PM - Info bpfis(pid=3804) done. status: 0          
7/23/2014 6:03:10 PM - end Create Snapshot; elapsed time: 00:02:43
7/23/2014 6:03:11 PM - Info bpfis(pid=0) done. status: 0: the requested operation was successfully completed    
7/23/2014 6:03:11 PM - end writing
Status 0
7/23/2014 6:03:11 PM - end Snapshot, Create Snapshot; elapsed time: 00:02:47
7/23/2014 6:03:12 PM - begin Snapshot, Policy Execution Manager Preprocessed
Status 156
7/24/2014 4:54:16 AM - end Snapshot, Policy Execution Manager Preprocessed; elapsed time: 10:51:04
7/24/2014 4:54:16 AM - begin Snapshot, Stop On Error
Status 0
7/24/2014 4:54:16 AM - end Snapshot, Stop On Error; elapsed time: 00:00:00
7/24/2014 4:54:16 AM - begin Snapshot, Delete Snapshot On Exit
7/24/2014 4:54:16 AM - begin Snapshot, Delete Snapshot On Exit
7/24/2014 4:54:16 AM - started process bpbrm (3022)
7/24/2014 4:54:28 AM - end writing
Status 0
7/24/2014 4:54:28 AM - end Snapshot, Delete Snapshot On Exit; elapsed time: 00:00:12
7/24/2014 4:54:28 AM - begin Snapshot, End Notify Script
7/24/2014 4:54:29 AM - Info RUNCMD(pid=3045) started            
7/24/2014 4:54:29 AM - Info RUNCMD(pid=3045) exiting with status: 0         
Status 0
7/24/2014 4:54:29 AM - end Snapshot, End Notify Script; elapsed time: 00:00:01
Status 156
7/24/2014 4:54:29 AM - end Snapshot, Delete Snapshot On Exit; elapsed time: 00:00:13
snapshot error encountered(156)

2. Thanks I got answer for my second query.

[RamNagalla]

in oracle backup set , out of 10 jobs if 9 jobs got successfull and 1 job got failed.. it can not be used for Full recovery.

but since all 9 jobs are successfull netbackup will not remove them untill it met the set retenction period..

in your case.. Netbackup does not remove them, since the job is marked as successfull in netbackup for that specific stream.

you have to find the related streams and expire them manually.

[RiaanBadenhorst]

Hi,

Lets back up one minute here. First you said

1. My FTP(VM) server, whose backup is running through netbackup client(not through Netbackup VM).Now I started backup with mutilple streaming for all drives i.e. C,D,E,F, Backup of F drive (child stream) is failed with 156 (snapshot error encountered) and I restarted that job and then its completed but at last parent job failed with 156 error, In BAR, backup of all drives is available. Now can anyone please let me know wheteher this backup can be considered as successful?

Then you say

1.Need to know why this parent job is failed while all its child job completed. and also its failed with 156 error while backup is through netbackup client.

So did all the child jobs complete (without rerun) or did one fail?

If you've posted the parent job from the session where F failed, then yes, it would say it got a 156, because F did. It wont change after you run the child job again.