7 Replies Latest reply: Oct 11, 2012 2:04 PM by vlethakula RSS

    External Backup

    scottjhn
      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
          See this thread:
          {thread:id=2437962}
          • 2. Re: External Backup
            vlethakula
            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
              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
                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
                  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
                    Read the my 2 last post on this thread:
                    {thread:id=2437962}
                    • 7. Re: External Backup
                      vlethakula
                      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