Re: Moving backups to / from ASM

This gets a little weird but...

You can use backup backupset to make a backup of your backup and store it outside of the ASM ( flash recovery area ). This is one of my biggest dissapointments with ASM as I need 2 times the space for backups if I want to resotre the database on another server as the other server needs access to the backup files.

Another option would be to use dbms_file_transfer and copy the files out of the ASM to some other location if need be. With 10GR2 you have the ability to access asm files via ftp assuming you have xmldb installed in your db.

Hope that helps.
Scott.

"hpuxrac" <johnbhurley_at_sbcglobal.net> wrote in message news:1163422980.456278.264450_at_b28g2000cwb.googlegroups.com...
>
> Albert Bihler wrote:
>> Hi,
>>
>> we are using Oracle 10g with ASM on Solaris 10. Currently we are
>> planning to do once a week a level 0 backup and every night a
>> level 1 backup. The backupsets are stored in the Flash Recovery
>> Area on ASM.
>>
>> Furthermore we would like to somehow get a copy of the backupfiles
>> out of ASM and store them on a disk share where a backup team
>> collects the files and stores them to their system.
>>
>> What I have gathered from Google and Technet so far is that this
>> could be done using RMAN. Unfortunately I can't find the right section
>> in the Oracle documentation. Can somebody please give me a hint?
>>
>
> I think it should be just "backup recovery area" and related options to
> get it backed up. Once you get to 10.2 I think oracle has some command
> level ways to manipulate ASM based files.
>
> The RMAN documentation should have an area and set of topics on the
> recovery area and maintenance thereof. Robert Freeman also has a new
> version of his RMAN book that should be out by now, it may be worth
> looking at.
>
> We are still plotting our move to 10.2 ... probably in the next 3
> months or shortly after.
>
Received on Mon Nov 13 2006 - 10:37:20 CST