This discussion is archived
7 Replies Latest reply: Nov 14, 2012 9:44 AM by mseberg RSS

RMAN backup to 3 different locations

925739 Newbie
Currently Being Moderated
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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points