cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted

Unable to find the oracle catalog in netbackup

Hi,

We are unable to find the catalog of the oracle monthly backup even we dont expire the catalog.

We use SLP as shown below:

We cannot see the 10 years retention duplication.

Thanks for help

Pbcom_SLP.png

 

Tags (2)
4 Replies
Highlighted

Re: Unable to find the oracle catalog in netbackup

Please run - "nbstlutil report" and check what is the status of this SLP. I guess it active but try to check if it has duplication that is pending.

Explore nbstlutil command's other options to verify status of the duplication jobs.

Highlighted

Re: Unable to find the oracle catalog in netbackup

Have you run the "bpclimagelist -U -client <client>" command to check to see what backup images are recorded for one of the Oracle clients? Review the additional options to specify a timeframe and possible backup type, policy name etc.

Assuming the backup was successful, the backup image will remain somewhere until ALL SLP operations are complete (so on the primary, or secondary storage via AIR even if the duplication to tape hasn't completed). 

If you are unable to understand what you see - post the output as a text file here and someone should be able to advise. 

Highlighted

Re: Unable to find the oracle catalog in netbackup

Hi 

This is the logs from bpclimagelist -U -client <client>

15:40:13.907 [13208.13812] <2> logparams: -U -policy Oracle_DB_EOMBackup_PS13ATMSDP
15:40:13.907 [13208.13812] <4> main: Verbosity is on
15:40:13.907 [13208.13812] <4> main: Language settings en en en en en
15:40:13.923 [13208.13812] <2> logconnections: BPRD CONNECT FROM 192.168.107.22.49694 TO 192.168.107.22.13720 fd = 496
15:40:13.923 [13208.13812] <2> bpclimagelist.exe: Request = ps13bmasap.ho.pbcom.int ps13bmasap.ho.pbcom.int ps13bmasap.ho.pbcom.int Oracle_DB_EOMBackup_PS13ATMSDP 0 9 1567845613 1583397613 en en en en en 2 0 13 0 0 0 0 0
15:40:13.923 [13208.13812] <2> send_request: start_date = 09/07/2019 16:40:13
15:40:13.923 [13208.13812] <2> send_request: end_date = 03/05/2020 16:40:13
15:40:16.403 [13208.13812] <2> send_request: done
15:40:16.403 [13208.13812] <16> main: send_request failed, status = 227

I monitor the backup and it was successful but i cannot find also the catalog for backup.

I would like to ask if the rman script have problem on this?

Highlighted

Re: Unable to find the oracle catalog in netbackup

@jjimenez2 

Can you confirm that the Policy type is Oracle?

If so, please show us output of :

bplist -C ps13atmsdb -s 02/27/2020 -e 03/01/2020 -t 4 -R /