This discussion is archived
7 Replies Latest reply: Oct 11, 2012 12:04 PM by vlethakula RSS

External Backup

scottjhn Newbie
Currently Being Moderated
Oracle 11g on Linux.

The FRA is configured based on ASM diskgroup +FRA.  The backups are scheduled to be saved there at 2:00am daily.

Now I want to backup the db to a second location (external USB hard drive), in addition to the FRA.  So I'll get two copies of the backups, one on the FRA diskgroup and another on the external hard drive.

1) How should I configure the RMAN to achieve this goal (of additional backups to the external drive)?

2) Will the next day's backup over-write the earlier day's backup? or Just add additional new backup files to the drive (Assume I use the default setting which I believe is the full database backup)?


Thanks
  • 1. Re: External Backup
    Levi-Pereira Guru
    Currently Being Moderated
    See this thread:
    {thread:id=2437962}
  • 2. Re: External Backup
    vlethakula Expert
    Currently Being Moderated
    Use the below command:

    BACKUP DEVICE TYPE DISK COPIES 2 DATABASE FORMAT '+FRA/%U','?/%U';

    http://web.njit.edu/info/limpid/DOC/backup.102/b14191/rcmconc1003.htm
  • 3. Re: External Backup
    scottjhn Newbie
    Currently Being Moderated
    If the FRA is based on an ASM disk group while the external disk is non-ASM disk, in this case, can I still use the BACKUP BACKUPSET command to copy the backup files on the +FRA disk group to the external non-ASK disk?                                                                                                                                                                                                                                                                                                                                                                                                                                                       
  • 4. Re: External Backup
    Shivananda Rao Guru
    Currently Being Moderated
    scottjhn wrote:
    If the FRA is based on an ASM disk group while the external disk is non-ASM disk, in this case, can I still use the BACKUP BACKUPSET command to copy the backup files on the +FRA disk group to the external non-ASK disk?
    Yes you should be able to do it. You can try as:
    RMAN>backup backupset <BS number> format '<external disk path>';
    Refer this http://docs.oracle.com/cd/B10501_01/server.920/a96566/rcmconc1.htm#462600
    Topic "Backup of Backup Sets"
  • 5. Re: External Backup
    scottjhn Newbie
    Currently Being Moderated
    RMAN>backup backupset <BS number> format '<external disk path>';

    --Where can I find out the BS Number.  For instance, I am using the DBCONSOLE.  So I go to the Manage Current Backups screen, there I can see a list of the Backup Sets such as:

    <u>Key TAG </u>
    1 ORA_OEM_LEVEL_0
    2...
    3...
    7 BACKUP_SID_NAME_00002_10101012123901

    Is the BACKUP_SID_NAME_00002_10101012123901 the BS Number? If this is not the one, where can I find it?


    Thanks
  • 6. Re: External Backup
    Levi-Pereira Guru
    Currently Being Moderated
    Read the my 2 last post on this thread:
    {thread:id=2437962}
  • 7. Re: External Backup
    vlethakula Expert
    Currently Being Moderated
    Here i am backing it up to +DATA asm and /oracle/rman directory; It copied to two locations

    RMAN> BACKUP DEVICE TYPE DISK COPIES 2 DATABASE FORMAT '+DATA/%U','/oracle/rman/%U';

    Starting backup at 2012-10-11:13:58:32
    allocated channel: ORA_DISK_1
    channel ORA_DISK_1: SID=253 device type=DISK
    channel ORA_DISK_1: starting full datafile backup set
    channel ORA_DISK_1: specifying datafile(s) in backup set
    input datafile file number=00005 name=+DATA/test/datafile/testd.268.796392009
    input datafile file number=00004 name=+DATA/test/datafile/users.259.796323619
    input datafile file number=00001 name=+DATA/test/datafile/system.256.796323619
    input datafile file number=00002 name=+DATA/test/datafile/sysaux.257.796323619
    input datafile file number=00003 name=+DATA/test/datafile/undotbs1.258.796323619
    channel ORA_DISK_1: starting piece 1 at 2012-10-11:13:58:33
    channel ORA_DISK_1: finished piece 1 at 2012-10-11:14:01:09 with 2 copies and tag TAG20121011T135833
    piece handle=+DATA/01nng5g9_1_1 comment=NONE
    piece handle=/oracle/rman/01nng5g9_1_2 comment=NONE
    channel ORA_DISK_1: backup set complete, elapsed time: 00:02:36
    channel ORA_DISK_1: starting full datafile backup set
    channel ORA_DISK_1: specifying datafile(s) in backup set
    including current control file in backup set
    including current SPFILE in backup set
    channel ORA_DISK_1: starting piece 1 at 2012-10-11:14:01:10
    channel ORA_DISK_1: finished piece 1 at 2012-10-11:14:01:11 with 2 copies and tag TAG20121011T135833
    piece handle=+DATA/02nng5l5_1_1 comment=NONE
    piece handle=/oracle/rman/02nng5l5_1_2 comment=NONE
    channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
    Finished backup at 2012-10-11:14:01:11



    bash-3.2$ cd /oracle/rman
    bash-3.2$ ls -ltr
    total 3639828
    -rw-r----- 1 oracle dba 3713409024 Oct 11 14:01 01nng5g9_1_2
    -rw-r----- 1 oracle dba 10125312 Oct 11 14:01 02nng5l5_1_2

    bash-3.2$ asmcmd
    ASMCMD> cd DATA
    ASMCMD> ls
    01nng5g9_1_1
    02nng5l5_1_1

    Edited by: vreddy on Oct 11, 2012 12:04 PM

Legend

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