Oracle databases Online backup

[Ialahmad]

Hi ALL;

In my Netbackup system I have three oracle(KMDB,HBDB,COLLABDB) Databases installed on one client Server (JAW-BMR) I upgrade Netbackup client agent on JAW-BMR, and upgrade Oracle database agent and do new link.

this week weekly online backup run but I note something error in policy name of allocated channels like this:-

JOB ID	TYPE	JOB STATE	START TIME	STATUS	POLICY	SCHEDULE	CLIENT
615254	Backup	Done	3/7/2010 11:10	0	MASTER_ORACLE_KMDB	Weekly_Full_Archive	JAW-BMR
615253	Backup	Done	3/7/2010 11:09	0	MASTER_ORACLE_KMDB	Weekly_Full_Archive	JAW-BMR
615252	Backup	Done	3/7/2010 11:07	0	MASTER_ORACLE_KMDB	Weekly_Full_Archive	JAW-BMR
615251	Backup	Done	3/7/2010 10:44	0	MASTER_ORACLE_KMDB	Weekly_Full_Online	JAW-BMR
615250	Backup	Done	3/7/2010 10:40	0	MASTER_ORACLE_KMDB	Weekly_Full_Archive	JAW-BMR
615248	Backup	Done	3/7/2010 10:25	0	MASTER_ORACLE_KMDB	Weekly_Full_Online	JAW-BMR
615249	Backup	Done	3/7/2010 10:25	0	MASTER_ORACLE_KMDB	Weekly_Full_Online	JAW-BMR
615246	Backup	Done	3/7/2010 10:25	0	MASTER_ORACLE_KMDB	Weekly_Full_Online	JAW-BMR
615247	Backup	Done	3/7/2010 10:25	0	MASTER_ORACLE_KMDB	Weekly_Full_Online	JAW-BMR
615245	Backup	Done	3/7/2010 10:23	0	MASTER_ORACLE_HBDB	Weekly_Full_Online_Sched	JAW-BMR
615244	Backup	Done	3/7/2010 10:23	0	MASTER_ORACLE_COLLABDB	Weekly_Full_Online_Sched	JAW-BMR
615243	Backup	Done	3/7/2010 10:12	0	MASTER_ORACLE_KMDB	Weekly_Full_Archive	JAW-BMR
615242	Backup	Done	3/7/2010 10:11	0	MASTER_ORACLE_KMDB	Weekly_Full_Archive	JAW-BMR
615240	Backup	Done	3/7/2010 10:05	0	MASTER_ORACLE_KMDB	Weekly_Full_Online	JAW-BMR
615241	Backup	Done	3/7/2010 10:05	0	MASTER_ORACLE_KMDB	Weekly_Full_Online	JAW-BMR
615239	Backup	Done	3/7/2010 10:02	0	MASTER_ORACLE_KMDB	Weekly_Full_Online_Sched	JAW-BMR

I check the log file for each Oracle Database backup with DBA, backup policy KMDB backup KMDB database files ,backup policy HBDB backup HBDB database files and Backup policy COLLABDB backup COLLABDB database files.

So Please I need your advice to solve this problem.

[Marianne]

Hard-code the Policy name in the Rman script.
Have a look at this TechNote - it applies to all versions of NBU: http://seer.entsupport.symantec.com/docs/267589.htm

[Ialahmad · Accepted solution]

Thank you Marianne,
problem solved.
by editing RMAN script and adding SEND policy name using SEND command;

RUN {

ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';

SEND 'NB_ORA_POLICY=${NB_ORA_POLICY}, NB_ORA_SCHED=${ARCH_SCHED}';

BACKUP

    SKIP INACCESSIBLE

    FILESPERSET 10

    FORMAT 'archbk_%s_%p_%t'

  ARCHIVELOG ALL DELETE INPUT;

  # ARCHIVELOG ALL ;

RELEASE CHANNEL ch00;

}