11-23-2022 01:59 AM
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;
11-23-2022 03:21 AM
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