11-24-2016 10:22 PM
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)
Solved! Go to Solution.
11-26-2016 10:13 PM - edited 11-26-2016 10:51 PM
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,
11-24-2016 11:06 PM
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?
11-25-2016 02:32 AM - edited 11-25-2016 02:49 AM
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,
11-25-2016 02:40 AM - edited 11-25-2016 02:45 AM
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,
11-26-2016 05:54 PM
11-26-2016 10:13 PM - edited 11-26-2016 10:51 PM
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,
12-16-2016 03:10 PM
resolved by ORA team issue with script