RE: best (reliability required, best speed at lowest resource consumption still important) way to get ASM contents to a file system for non-plugin tape jobs?

Thanks. I'll include that in the tests and (as seems likely) if it is the winner or merely competitive on speed I'll be looking for help getting it turned into a documented and supported RMAN option.  

From time to time and giving due diligence and consideration to down side risks I may advocate doing things with Oracle technology that are not strictly supported. (For example, doing standby databases before there was a product called "dataguard", circa 1995. After all even if they claimed it wasn't supported, it was merely up to you to follow the rules of recovery and they had to support recovery.)  

But of course I'm hesitant to employ an undocumented and unsupported device type in the backup scheme. So if it works out best .  

In the meantime, I'm still all ears for additional ideas and/or reports of test results on this issue.  

mwf  

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Niall Litchfield
Sent: Friday, October 31, 2008 3:13 PM
To: mwf_at_rsiz.com
Cc: ORACLE-L
Subject: Re: best (reliability required, best speed at lowest resource consumption still important) way to get ASM contents to a file system for non-plugin tape jobs?  

You can use the unsupported device type of SBT_DISK to backup your recovery area to disk (I can' actually recall the syntax right now).

On Fri, Oct 31, 2008 at 6:05 PM, Mark W. Farnham <mwf_at_rsiz.com> wrote:

If anyone has measured performance and tested reliability of copying ASM contained files onto a file system, I'm all ears.

--

Niall Litchfield
Oracle DBA
http://www.orawin.info

--

http://www.freelists.org/webpage/oracle-l Received on Sat Nov 01 2008 - 07:14:00 CDT