Forum Discussion

jjbescond's avatar
jjbescond
Level 2
3 years ago

change initial template for rman for oracle backup netbackup

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;

  • Michal_Mikulik1's avatar
    Michal_Mikulik1
    Moderator
    3 years ago

    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