Oracle "bplist -keyword" works "bplist -k" does not

Question

We were trying to confirm some Oracle backups using "bplist -C client -t 4 -R -k policy" are were horrified to find many of the expected files were not there.&nbsp; Netbackup logs shows Status 0 for recent jobs. Oracle RMAN&nbsp;logs&nbsp;indicates no trouble either.&nbsp; Client and server are running Netbackup 6.0MP7 and Solaris 9.&nbsp; Same result as oracle user or as root.&nbsp;

It finally occured to me to try bplist without the policy name "bplist -C client -t 4 -R" and --&nbsp;whew! --&nbsp;the files were indeed listed.&nbsp;&nbsp; But that includes ALL of the database backups on the client, not just the one we wanted for this task.&nbsp;

Then I added a keyword to the Oracle policies and tried "bplist -C client -t 4 -R -keyword key" and that produces the desired result.&nbsp;&nbsp;&nbsp; Anyone seen this?&nbsp; Why does "bplist -keyword" work and "bplist -k" does not, at least not consistently?

Thanks in advance for your response &amp; suggestions.

crz · Answer

The "-k"&nbsp;command line switch is case-sensitive. &nbsp;Are you sure you're EXACTLY&nbsp;matching the name of the policy as it's defined on the master?

For example:

This may work...
# bplist -C&nbsp;client -t 0 -R -k example
/home/CRZ/
/home/CRZ/
/home/CRZ/
/home/CRZ/

...but using an all-caps policy name returns the dreaded "nothin'" result:
# bplist -C&nbsp;client -t 0 -R -k EXAMPLE
EXIT STATUS 227: no entity was found

will_restore · Answer

But the trouble is we get SOME of the files using "-k" and ALL&nbsp;of the files using "-keyword".&nbsp;

Interesting (to me at least) since I just added the keyword to the policies that it picks up even the older backups, but "-k" is just hit or miss.&nbsp; Specify the policy and it shows last month's files but not this weekend's, or vice versa. :(

crz · Answer

I&nbsp;think you can only "-k"&nbsp;with one policy name.&nbsp; If there's more than one policy in play here, "-keyword"&nbsp;may be picking up all of them (since the absence of "-k"&nbsp;means "check out every policy")&nbsp;- I&nbsp;see you said you added the keyword to the plural policIES so I'm wondering if maybe it's something where you're expecting&nbsp;results from a particualr policy, but in reality some other policy is handling what you're looking for.

Otherwise, I'm stumped.&nbsp; (Maybe.)&nbsp;&nbsp;:)

will_restore · Answer

some sample output:
bplist -C client -t 4 -R -k PROD
/bk_1001
/al_1002
/cntrl_1003

bplist -C client -t 4 -R -k TEST
/bk_2100
/bk_2101
/al_2102
/cntrl_2103

But we are expecting /bk_0905, and after&nbsp;updating policy "PROD" to add keyword "FOOBAR":
bplist -C client -t 4 -R -keyword FOOBAR
/bk_0900
/bk_0901
/bk_0902
/bk_0903
/bk_0904
/bk_0905
&lt;snip&gt;
/bk_1001
/al_1002
/cntrl_1003

Hey!&nbsp; It's there after all.&nbsp; Now just to double check:
bplist -C client -t 4 -R -keyword FOOBAR&nbsp; /bk_0905
/bk_0905

bplist -C client -t 4 -R -k PROD&nbsp; /bk_0905
EXIT STATUS 227: no entity was found

will_restore · Answer

is the RMAN&nbsp;logs said it was backed up.&nbsp; But we couldn't find it initally because the bplist -k option masked it.&nbsp;

Note the new keywords are unique to each Netbackup policy and seem to work fine, providing the proper file list for each database instance, where the policy selection option shows just a subset.

update: checked a few more servers and those with multiple Oracle instances exhibit the same quirk - "bplist -keyword" displays proper file list while "bplist -k" does not.&nbsp; The server with just one Oracle instance shows same result with either "bplist -k" or "bplist -keyword".&nbsp; Hmmm.&nbsp;

Forum Discussion

Oracle "bplist -keyword" works "bplist -k" does not

Related Content

bplist shows control file backup but rman "restore controlfile" fails with file not found

Netbackup 8.1: bplist generates error "EXIT STATUS 227: no entity was found"

FreeBSD-client under 6.5.x - /libexec/ld-elf.so.1: ./bplist: Undefined symbol "__h_error"

creative license for "Keyword Phrase"

Re: Symantec netbackup command