Oracle alternate client restore fails with error 7502 - Backup file not found in NetBackup catalog.

Problem

Error=7502 was encountered when performing a redirected alternate client Oracle restore. Customer is using a different Oracle user account during restore than what was originally used to perform the backup.

Error Message

Check the following similar error messages in the destination client DBCLIENT  log:

<2> bsa_bplist: Request = orasup orasup ORADB1_bkp ORADB1_bkp NYCTSTEBSDBS1_bkp NONE 0  3 999 819936000 1296872408 4 4 1 1 1 0 4 5027 5027 4 0 en_US.UTF-8 en_US.UTF-8 en_US.UTF-8 en_US.UTF-8 en_US.UTF-8 0 2 0 0 0
<4> bsa_bplist: Filepath = /cntrl_2196_1_758409608
<2> dbc_get_string: Output = EXIT STATUS 227
<8> VxBSAQueryObject: WRN - Query unsuccessful for client ORADB1_bkp
<4> get_client_alias_list: entering get_client_alias_list.
<4> get_client_alias_list: Using cached alias list.
<4> VxBSAQueryObject: INF - No match was found for query
<2> xbsa_QueryObject: INF - leaving (17)
<2> int_FindBackupImage: INF - cntrl_2196_1_758409608 not found
<16> int_StartJob: ERR - Backup file <cntrl_2196_1_758409608> not found in NetBackup catalog
<2> sbterror: INF - Error=7502: Backup file <cntrl_2196_1_758409608> not found in NetBackup catalog

Cause

The Oracle user initiating the restore on the alternate server, is not similar to the oracle user or part of the same group to the oracle user from the source Oracle client.
Due to this, the oracle user on the alternate server cannot access the backup images from the NetBackup catalog.

Solution

1. Make sure that the oracle user on the alternate server is same, or part of the same group of the oracle user which was used to perform backup on the source Oracle client.
Example: If the backup on source oracle client was done using username "oradev" and was part of group "oracle", then make sure on the alternate server, we are using the same "oradev" user for the restore. If we cannot use "oradev" user on the alternate server, then the new user should atleast be part of the "oracle" group so that it can access the NetBackup catalog(backup images) from the master server.

2. The easiest way to determine the owner and group of the backup images in question is to run the bplist command from the master server while logged in as root. Once the proper Oracle user and group has been identified, run the same bplist command on the destination/target Oracle server while logged in as that Oracle user account.

Here is a sample bplist command:

bplist -C <source_Oracle_server_hostname> -t  4 -l -R / > /tmp/bplist.out

Examine the bplist output and search for the backup piece that showed an error from the dbclient log or the RMAN restore script output.

Keep in mind that the username is case sensitive, even on Windows.  The 'oracle' user in the following two sample outputs is different:

C:\Program Files\Veritas\NetBackup\bin\bplist -C <my_oracle_client_name> -t 4 -l -R /

-rw-rw---- oracle    oinstall    532414464 Feb 25 17:20 bk_560_1_1001168446:\
-rw-rw---- oracle    oinstall    805306368 Feb 25 17:20 bk_559_1_1001168446:\
-rw-rw---- oracle    oinstall     10485760 Feb 25 15:52 c-1765188747-20190225-02:\

C:\Program Files\Veritas\NetBackup\bin\bplist -C <my_oracle_client_name> -t 4 -l -R /

-rw-rw---- Oracle    oinstall      8126464 Feb 20 08:13 al_520_1_1000703604:\
-rw-rw---- Oracle    oinstall     10485760 Feb 20 08:12 c-1765188747-20190220-00:\
-rw-rw---- Oracle    oinstall    804519936 Feb 20 08:12 bk_517_1_1000703522:\

Note that the former is 'oracle' in all lower case.  The latter is 'Oracle' with an UPPER CASE 'O'. 

3. In the first example, the bplist output shows us that the backup was done using "oracle" user which is part of "oinstall" group.

4. Now, when we initiate a restore on an alternate server, we need to have the same "oracle" user to run the restore, or if its a different user name, then it should be part of the "oinstall" group, so that it has read permissions to fetch the backup images from NetBackup catalog.

NOTE: Here -l is lower case L - not to be confused with -I upper case i

Veritas NetBackup™ Commands Reference Guide