cancel
Showing results for 
Search instead for 
Did you mean: 

change initial template for rman for oracle backup netbackup

jjbescond
Level 2

hello ,

do you know if it's possible to add or modify a command to the rman script when is generate by netbackup to make a  full or archive backup oracle

i need to add  :   alter session set optimizer_mode=RULE;

before :

BACKUP
 INCREMENTAL LEVEL=1 CUMULATIVE
    FORMAT 'bk_d%d_u%u_s%s_p%p_t%t'
    DATABASE;

1 REPLY 1

Michal_Mikulik1
Moderator
Moderator
Partner    VIP    Accredited Certified

Hello,

you can add anything you need to the backup script. I am curious what is a purpose here. Have you so many datafiles/backupsets etc. that you need to optimize underlying metadata queiries? Also, when you use recovery catalog, you should probably optimize rman db session, not target db session. Not sure how to accomplish this.

Regards

Michal