Results 1 to 3 of 3

Thread: RAC and RMAN

  1. #1
    Join Date
    Feb 2004
    Posts
    86

    Unanswered: RAC and RMAN

    I have 3 nodes in my RAC test environment with ASM with multiple instances. I want to perform an RMAN backup. Do I connect to my cluster or each instance?

  2. #2
    Join Date
    May 2006
    Posts
    132
    This should provide all the information you need (RMAN & RAC).

  3. #3
    Join Date
    Dec 2003
    Location
    Oklahoma, USA
    Posts
    354
    The note ebrian suggested is a good one... please note something though... the steps in the note assumes you are using the Enterprise Edition of the database.

    The command CONFIGURE DEVICE TYPE disk PARALLELISM <# of instances> is not valid for the Standard Edition. We found this out the hard way... I am at a client location and couldn't figure out why RMAN had a hard time finding all backups. The issue is that when RMAN runs, it is just like any other client the RAC database and the db will determine which instance you are actually connected to... If you are creating a backup in RMAN in this fashion, you never really know on which local file system the backup files will be located.

    If you don't have EE (which we will continue to "NOT" have) you will have to create some custom backup scripts. Something like this:

    RUN {
    CONFIGURE CHANNEL DEVICE TYPE disk CONNECT 'sys/pwd@inst1'
    BACKUP DATABASE PLUS ARCHIVELOG;
    }

    This will ensure that the files are stored on the instance you determine... In our case, as a "backup" to this process, we duplicated our backup scripts to run on both instances -- it has the added benefit of creating a backup copy.

    Hope this helps... and if you find another solution, please share.
    JoeB
    save disk space, use smaller fonts

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •