Forum Discussion

santave's avatar
santave
Level 4
11 years ago

RAC Oracle backup script and config

Hi, I have 3 nodes configured as oracle RAC (infdb1, infdb2 and infdb3) PFA tnsnames.ora and hosts files configuration. I would like to backup and restore with Failover VIP exists an...
7.5
Backing Up
Backup and Recovery
Linux
NetBackup
  • Yasuhisa_Ishika's avatar
    Yasuhisa_Ishika
    11 years ago

    Two points to be considered for RAC .

    One is policy configuration. There are 2 major options: single policy configuration(Automatic and Application Backup schedule on single policy) and two policy configuration(one have Automatic Backup schedule, and another have Application Backup schedule).

    Another point to be considerd is how to allocate channels. 

    These considerations are detailed in Guide. Please check  "Example RAC configuration: Failover VIP exists and backup is load balanced" in NetBackup 7.5 for Oracle Administrator'sGuide.
     
    http://www.symantec.com/docs/DOC5175

    To backup DBs and archive logs, start with sample script placed in /usr/openv/netbackup/ext/db_ext/oracle/samples/rman/. Replace "ALLOCATE CHANNEL" statement with those suggested in Guide. "RELEASE CHANNEL" statement is also required.

    If you do not want to backup DB or control files, remove lines related to these objects from RMAN command section in your script.

Yasuhisa_Ishika's avatar
Yasuhisa_Ishika
Level 6
11 years ago

 

1. You mean, 1 policy for DB Data backup and 1 policy for archivelogs only? Both can't be in 1 policy?

NetBackup for Oracle requires two type of schedule - Automatic Backup & Application Backup. In Automatic Backup schedule, NetBackup just kicks backup script(or initiate RMAN command generated from template). Do not handle any backup operation in it. On the other hand, in Application Backup, NetBackup accepts backup requests from Oracle. When BACKUP commands is issued with SBT channel in RMAN, Oracle pass backup data through SBT and request NetBackup to store backup data into storage unit.

Following single policy configuration in RAC backup, you create one policy with both schedule. Or, following two policy configuration, you create two policy - one has only Automatic Backup schedule, and one has only Application Backup schedule. The former just kicks backup script, and the later handles all backup data from Oracle. These two policies are not deviced by type of Oracle DB object but by role of schedule in NetBackup.

2. How about the tnsname file, since my DB admin used PRECONNECT method.
Any necessary changes in this file to perfom load balance backup?

As shown in ALLOCATE CHANNEL example of Guide, you need node-specific name for erach node. But this tnsname.ora has SCAN adress only. You need to add entries of each node so that RMAN can connect to each node explicitly with dedicated name of each VIP. I'm not so familiar with Oracle, so for more detail, please show your DBAs the Guide and talk with them.

3. Also, how's the bp.conf configuration?

If I remember right, no need to modify bp.conf.