4 Replies Latest reply: Nov 7, 2011 8:18 AM by Levi Pereira RSS

    Move Backups from ASM to Disks

    733763
      Hello all,

      RMAN Backups are running daily with backups stored in ASM Diskgroups (+FRA1 - Flash Recovery Area). We want to move then to normal disk (/u03/backups) from where they will be picked up by Tape Media Management software.

      How can I achieve this ? any issues doing this ?

      Please let me know

      KS
        • 1. Re: Move Backups from ASM to Disks
          19426
          Use the FORMAT option:

          http://download.oracle.com/docs/cd/E11882_01/backup.112/e10643/rcmsubcl010.htm#i82206
          • 2. Re: Move Backups from ASM to Disks
            733763
            That is to copy the database across from ASM to NON-ASM disk right ?

            I am looking to move Backups in ASM Diskgroup to Disks.
            • 3. Re: Move Backups from ASM to Disks
              19426
              You mean you want to continue to backup to ASM , but then to copy the backups in ASM to the filesystem?

              If yes you can use the ASMCMD command line utility:

              http://download.oracle.com/docs/cd/E11882_01/server.112/e18951/asm_util003.htm#CHDJEIEA

              Werner
              • 4. Re: Move Backups from ASM to Disks
                Levi Pereira
                user11982378 wrote:
                That is to copy the database across from ASM to NON-ASM disk right ?

                I am looking to move Backups in ASM Diskgroup to Disks.
                Also you can use RMAN to accomplish it.

                Allocate channel to disk using path desired and run "backup backupset" command in RMAN:

                See this example copying backupset 42.
                RMAN> list backupset 42;
                
                List of Backup Sets
                ===================
                
                BS Key  Size
                ------- ----------
                42      3.00K
                
                  List of Archived Logs in backup set 42
                  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
                  ---- ------- ---------- --------- ---------- ---------
                  1    14      1023411    06-NOV-11 1023433    06-NOV-11
                
                  Backup Set Copy #1 of backup set 42
                  Device Type Elapsed Time Completion Time Compressed Tag
                  ----------- ------------ --------------- ---------- ---
                  DISK        00:00:02     06-NOV-11       NO         TAG20111106T171604
                
                    List of Backup Pieces for backup set 42 Copy #1
                    BP Key  Pc# Status      Piece Name
                    ------- --- ----------- ----------
                    42      1   AVAILABLE   +FRA/dbhr/backupset/2011_11_06/annnf0_tag20111106t171604_0.272.766516565
                
                RMAN> run{
                allocate channel t1 device type disk format '/stage_area/%U';
                backup backupset 42;
                }
                allocated channel: t1
                channel t1: sid=137 devtype=DISK
                
                Starting backup at 07-NOV-11
                channel t1: input backup set: count=35, stamp=766516564, piece=1
                channel t1: starting piece 1 at 07-NOV-11
                channel t1: backup piece +FRA/dbhr/backupset/2011_11_06/annnf0_tag20111106t171604_0.272.766516565
                piece handle=/stage_area/13mr07ak_1_2 comment=NONE
                channel t1: finished piece 1 at 07-NOV-11
                channel t1: backup piece complete, elapsed time: 00:00:01
                Finished backup at 07-NOV-11
                
                Starting Control File and SPFILE Autobackup at 07-NOV-11
                piece handle=+FRA/dbhr/autobackup/2011_11_07/s_766583634.268.766583635 comment=NONE
                Finished Control File and SPFILE Autobackup at 07-NOV-11
                released channel: t1
                Now backuppiece 44 is copy of 42.
                RMAN> list backupset 42;
                
                
                List of Backup Sets
                ===================
                
                BS Key  Size
                ------- ----------
                42      3.00K
                
                  List of Archived Logs in backup set 42
                  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
                  ---- ------- ---------- --------- ---------- ---------
                  1    14      1023411    06-NOV-11 1023433    06-NOV-11
                
                  Backup Set Copy #1 of backup set 42
                  Device Type Elapsed Time Completion Time Compressed Tag
                  ----------- ------------ --------------- ---------- ---
                  DISK        00:00:02     06-NOV-11       NO         TAG20111106T171604
                
                    List of Backup Pieces for backup set 42 Copy #1
                    BP Key  Pc# Status      Piece Name
                    ------- --- ----------- ----------
                    42      1   AVAILABLE   +FRA/dbhr/backupset/2011_11_06/annnf0_tag20111106t171604_0.272.766516565
                
                  Backup Set Copy #2 of backup set 42
                  Device Type Elapsed Time Completion Time Compressed Tag
                  ----------- ------------ --------------- ---------- ---
                  DISK        00:00:02     07-NOV-11       NO         TAG20111106T171604
                
                    List of Backup Pieces for backup set 42 Copy #2
                    BP Key  Pc# Status      Piece Name
                    ------- --- ----------- ----------
                    44      1   AVAILABLE   /stage_area/13mr07ak_1_2
                Also you can use:
                backup backupset all delete input; # It will move all files in ASM to Filesystem
                backup backuset all; # It will keep backup data in both location.
                delete backuset 42; # It will delete all backuppiece of backupset 42 in both location
                delete backuppiece 44; It will delete only backuppiece 44 of the backupset 42 in location '/stage_area/13mr07ak_1_2'
                See this example:
                http://levipereira.wordpress.com/2011/09/16/how-migrate-asm-to-non-asm-unixlinux/

                Hope this help,
                Levi Pereira

                Edited by: Levi Pereira on Nov 7, 2011 11:55 AM