ORA-19506 ORA-27028 ORA-19511

[incognito1]

Here's the failed job logs from rman end. Having hard time to troubleshoot this issue. Please help to check

Bkup string input manually: [arch_del_daily]
Found NB Master Sevr: [undisclosed]
Found NB_ORA_CLIENT : [undisclosed]
### ERROR: NO valid policy FOUND for local instance
==> Checking the backup policy for RAC active remote instance(s)...
DBRMAN NAME@clientName: No Netbackup policy found for this remote instance
### ERROR: NO valid NB policy FOUND for this database

===============================================================
EXIT_CODE: [2]
RESULT : [FAILED:NO valid policy FOUND for this database]
DONE AT : [2016-11-24 15:42:37 UTC]
===============================================================

FROM NBU Console: 11/25/2016 00:52:19 - Error bpbrm (pid=955) from --------- ERR - Script exited with status = 1 11/25/2016 00:52:19 - Error bpbrm (pid=955) from client -------: ERR - bphdb exit status = 6: the backup failed to back up the requested files 11/25/2016 00:52:20 - Info bphdb (pid=15795) done. status: 6: the backup failed to back up the requested files 11/25/2016 00:52:20 - end writing the backup failed to back up the requested files (6)

[Marianne]

The error is very clear:

FAILED:NO valid policy FOUND for this database

What have you done to check for Oracle policy ?
Are you using local hostname to backup RAC or virtual hostname?

Do you have bprd log on the master server to see which IP address the backup request is coming from?
Can the master resolve this IP address to hostname that corresponds with Client name in Oracle policy?

Have you followed steps in NetBackup for Oracle Administrator's Guide   to configure scripts and policy for Oracle RAC? 

[Tousif]

Hello 

The oracle backup master server use automatic schedule to trigger the backup from master server. The script mentioned in backup selection in policy execute the script. The client check with NetBackup Master server about  valid policy and backup windows (Application Schedule) to continue the backup.

Now in your case the script have wrong policy name mentioned or not mentioned.

Open script on client machine and search for similar lines mentioned below.

allocate channel ch00 type 'SBT_TAPE';
allocate channel ch01 type 'SBT_TAPE';
SEND 'NB_ORA_CLIENT=ClientServer,NB_ORA_SERV=MasterServer,NB_ORA_POLICY=PolicyName';

 If it RAC:

Allocate channel ch00 type 'SBT_TAPE' PARMS='ENV=(NB_ORA_CLIENT=client-vip,NB_ORA_POLIC=PolicyName)' CONNECT='user/password@instancename';

Make sure the "NB_ORA_POLICY=" having correct policy name.

Thanks & Regards,

[Tousif]

Hello,

In your post you mentioned that:

==> Checking the backup policy for RAC active remote instance(s)..

As mentioned by Marianne, Please confirm about the RAC.

Please confirm instances running on client by using below command

ps -ef |grep pmon

Make sure the oracle user can able to connect rman for that instance.

Make sure the same SID mentioned in backup script.

Thanks & Regards,

[incognito1]

Other Databases running on this RAC using the same script: No issue on backup up $ ps -ef | grep pmon oracle 3323 1 0 Oct31 ? 00:16:56 ora_pmon_ oracle 8033 1 0 Nov17 ? 00:04:53 ora_pmon_ oracle 8979 1 0 2014 ? 07:31:39 asm_pmon_ oracle 11429 11177 0 20:04 pts/0 00:00:00 grep pmon oracle 15397 1 0 2014 ? 09:07:42 ora_pmon_ oracle 23469 1 0 2014 ? 08:18:47 ora_pmon_ oracle 28720 1 0 2015 ? 05:35:52 ora_pmon_

[Tousif · Accepted solution]

Hi,

I think the script not configured correctly for that instance.

Login to client machine and go to the script location (Backup Selection script).

Run the rman backup script using below command.

#bash -x <Script Name>.sh

It will show line the script stuck. 

Thanks & Regards,

[incognito1]

resolved by ORA team issue with script