7 Replies Latest reply: Nov 14, 2012 11:44 AM by mseberg RSS

    RMAN backup to 3 different locations

    925739
      Hi,
      I'm trying to backup my database to 3 different locations. If one location is unavailiable backup fails. Is there a possibility to make backup to other 2 locations when one is unavailiable? For example second location from following code is unavailiable. Here is my code:
      RUN
      {
      CONFIGURE DEVICE TYPE DISK PARALLELISM 1;
      CONFIGURE DEFAULT DEVICE TYPE TO DISK;
      CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/backup/location1/%d_DB_%u_%s_%p', '/backup/location2/%d_DB_%u_%s_%p', '/backup/location3/%d_DB_%u_%s_%p';
      CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 3;
      CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 3;
      BACKUP DATABASE PLUS ARCHIVELOG SKIP INACCESSIBLE;
      }
        • 1. Re: RMAN backup to 3 different locations
          mseberg
          Hello;

          No, I don't believe that will work and will probably cause an I/O issue.

          Even if that setup works how would RMAN measure failure?

          h2. Changing my answer

          Looks like you are OK.

          They show two in the example.

          Duplexing Backup Sets with CONFIGURE BACKUP COPIES (Chapter 10 )

          CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/disk1/%U', '/disk2/%U';

          Oracle® Database Backup and Recovery User's Guide 11g Release 2 (11.2) E10642-03



          Other Options

          Standby database.
          One location for backup then copy on success.

          Best Regards

          mseberg

          Edited by: mseberg on Nov 14, 2012 10:41 AM

          Edited by: mseberg on Nov 14, 2012 10:41 AM
          • 2. Re: RMAN backup to 3 different locations
            925739
            Sorry but you didnt help me. Does anyone know if there is a possibility to, i dont know, skip failed location? Or maybe there is other possibility to make 3 identical backupsets using one rman configuration?
            • 3. Re: RMAN backup to 3 different locations
              Shivananda Rao
              922736 wrote:
              Sorry but you didnt help me. Does anyone know if there is a possibility to, i dont know, skip failed location? Or maybe there is other possibility to make 3 identical backupsets using one rman configuration?
              Let me check on the 1st part of your question. Regarding the 2nd part (identical backupsets), may be this may help you out:
              BACKUP DEVICE TYPE DISK
              COPIES 3
              DATABASE
              FORMAT '/disk1/db_%U', '/disk2/db_%U, /disk3/db_%U';
              Note: Duplexing cannot be used when creating files in the flash recovery area.
              • 4. Re: RMAN backup to 3 different locations
                925739
                But when I use CONFIGURE is it not the same?
                CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/backup/location1/%d_DB_%u_%s_%p', '/backup/location2/%d_DB_%u_%s_%p', '/backup/location3/%d_DB_%u_%s_%p';
                CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 3;
                CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 3;
                • 5. Re: RMAN backup to 3 different locations
                  mseberg
                  No need to be sorry.

                  The book says :

                  RMAN can make up to four copies of a backup set simultaneously, each an exact duplicate of the others.

                  According to the document its really only one copy with different locations.

                  There's nothing in the document that I can see about failed locations.

                  So I'm thinking at the very least RMAN will throw an error.

                  Worth a look

                  RMAN: How to Change the Backupset's Location [ID 223569.1]

                  Best Regards

                  mseberg
                  • 6. Re: RMAN backup to 3 different locations
                    Shivananda Rao
                    Hello,

                    I don't think that it is possible for RMAN to proceed even if one of the location mentioned for backup is unavailalble. RMAN would throw out an error and would not proceed further.
                    • 7. Re: RMAN backup to 3 different locations
                      mseberg
                      Hello again;

                      I was able to find an example of your other question :
                      If you specify a nonexistent directory, RMAN displays output such as the following:
                      
                      RMAN-00571: ===========================================================
                      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
                      RMAN-00571: ===========================================================
                      RMAN-03009: failure of backup command on ORA_DISK_1 channel at 08/29/2001 
                                  14:36:04
                      ORA-19504: failed to create file "/nosuchdisk/0cd2momi_1_1"
                      ORA-27040: skgfrcre: create error, unable to create file
                      SVR4 Error: 2: No such file or directory
                      Source

                      Spreading a Backup Across Multiple Disk Drives: Example

                      Database Backup and Recovery Advanced User's Guide


                      So it really looks like it errors, ORA-19504 appears to be the key.

                      Unable to find any Oracle note regarding skip. Interesting question.

                      Best Regards

                      mseberg