Database Backup Job´s set

[Fabian_Schwarz]

Hi

I´m looking for any way to find the parent job and the child jobs in a Database Backup Job´s set.
(Command line)

[DPeaco]

Are you talking about an Oracle RMAN backup? Oracle Cold backup?

Need more info....details please.

[Fabian_Schwarz]

RMAN Backup.

[Marianne]

Maybe try  bpdbjobs -all_columns  (use awk to only extract the fields you want).

Sort the output by field36  (Parent job number).

If you only want Oracle policy type, you could test field22 for Policy type 4 (Oracle)

field22 = Policy type

0 = Standard (UNIX and Linux clients), 4 = Oracle, 6 = Informix-On-BAR, 7 = Sybase, 8 = MS-SharePoint portal server, 11 = DataTools-SQL-BackTrack, 13 = MS- Windows, 15 = MS-SQL-Server, 16 = MS-Exchange-Server, 17 = SAP, 18 = DB2, 19 = NDMP, 20 = FlashBackup, 25 = Lotus Notes, 29 = FlashBackup-Windows, 35 = NBU-Catalog, 39 = Enterprise_Vault, 40 = VMware, 41 = Hyper-V

All fields in Commands Ref Guide: https://www.veritas.com/support/en_US/doc/123533878-127136857-0/v123536850-127136857

[Fabian_Schwarz]

Is there any NBU command to extract all dat from a specified Job ? Bpdbjobs -all_columns command is too slow in my environment.

[Genericus]

All my RMAN backups have a parent schedule and a child schedule, and they are named Parent.Job and Child.Job

All my prod databases have their own policies.

So I can filter for policy contains XXX.DB and schedule contains parent and find the parent job.

This also allows me to exclude Child.Job from backup_exit notifications.

I have this note from olden times, havent run recently to find media for a restore.

To find media to restore for oracle clients by Oracle block file - ON THE CLIENT run this command:
/usr/openv/netbackup/bin/bpclntcmd -ml /db_717_1_662950820 -ct Oracle
# if you have dates you can add -s mm/dd/yy

Your oracle backups should send to an oracle log file, you might be able to find information there as well.

[Fabian_Schwarz]

In my environmtent field 36 doesn´t show the parent job...

sudo /usr/openv/netbackup/bin/admincmd/bpdbjobs -all_columns| awk -F"," '{ print $1,$36}' | more

13109741 STU_DISKPOOL_VDMSLZ001_ARCHIVE
13109740 STU_DISKPOOL_VDMSLZ001_ARCHIVE
13109739 STU_MS_LTO_SLX429
13109738
13109737
13109736 STU_IBM_LTO_SLX441
13109735 dgslmreas155_1529688762
13109734 dgslmreas155_1529688777
13109733
.
.
.

[Fabian_Schwarz]

Any help ???

[Marianne]

You will need to check NBU Command reference guide for your NBU version.

[Fabian_Schwarz]

Is there any way to extract the command embedded in the NBU´s Java form ? https://vox.veritas.com/legacyfs/online/veritasdata/users/user-1660151/parent.JPG