3 Replies Latest reply: Feb 6, 2013 10:34 PM by ursusca RSS

    RMAN Backup to Disk in a RAC cluster...?

    raindog
      We have a two-node RAC cluster, using Linux and ASM. Pretty typical setup.

      We are backing up to disk via RMAN. Right now, that filesystem is mounted on node #1. It's a SAN volume but is not presently clustered.

      My questions...

      (1) Is it best practice that only one node out of the cluster performs the backups?

      (2) Or is there a config where all nodes participate in the backup?

      My concerns are what happens when node #1 fails (presumably we'd have to mount the volume on node #2), and also the asymmetrical load during backups.

      Thank you!
        • 1. Re: RMAN Backup to Disk in a RAC cluster...?
          mseberg
          Hello;

          Managing backup and recovery for RAC databases is no different from managing those for single-instance databases.

          RMAN backs up the database not the individual instance.

          This may help :

          http://www.databasejournal.com/features/oracle/article.php/3665211/Oracle-RAC-Administration--Backing-up-your-RAC-with-RMAN.htm

          Instance Recovery in Oracle RAC

          http://docs.oracle.com/cd/E11882_01/rac.112/e16795/backup.htm#i492578

          Best Regards

          mseberg
          • 2. Re: RMAN Backup to Disk in a RAC cluster...?
            brunors
            Hi,

            see this article <http://docs.oracle.com/cd/B10500_01/rac.920/a96596/backup.htm> the best practice is "best practice is not to specify the DELETE ALL INPUT or DELETE INPUT clauses on the BACKUP command. Instead, use the DELETE command.", but about your question i dont found.

            Hugs, Bruno Reis.
            www.brunors.com
            • 3. Re: RMAN Backup to Disk in a RAC cluster...?
              ursusca
              (1) Is it best practice that only one node out of the cluster performs the backups? - it depends on your application

              (2) Or is there a config where all nodes participate in the backup? - you can allocate channels by running commands similar to the following:

              ALLOCATE CHANNEL DEVICE TYPE .... CONNECT '@rac1'
              ALLOCATE CHANNEL DEVICE TYPE .... CONNECT '@rac2'

              But the point is that the backup should be available to restore for any node.