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 Robert! That is the best idea yet. The key was your recognizing that even though the functional purpose of this copy is a backup, the way to execute it in RMAN is actually a RESTORE operation.  

This has many advantages, not the least of which is staying completely within RMAN using its engineered in affinity for ASM.  

Mark  

From: Robert Freeman [mailto:robertgfreeman_at_yahoo.com] Sent: Friday, October 31, 2008 3:52 PM
To: mwf_at_rsiz.com
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?  

RMAN can do this. You would just use the set newname command or the db_filename_convert (off the top of my head on this parameter) parameters during the restore operation to get RMAN to restore the datafiles to a different location (ie: NON-ASM).

Also, during upgrades Oracle will give you the opportunity to move datafiles in/out of ASM to file systems.

RF  

Robert G. Freeman
Author:
OCP: Oracle Database 11g Administrator Certified Professional Study Guide (Sybex)
Oracle Database 11g New Features (Oracle Press) Portable DBA: Oracle (Oracle Press)
Oracle Database 10g New Features (Oracle Press) Oracle9i RMAN Backup and Recovery (Oracle Press) Oracle9i New Features (Oracle Press)
Other various titles out of print now... Blog: http://robertgfreeman.blogspot.com The LDS Church is looking for DBA's. You do have to be a Church member in good standing. A lot of kind people write me, concerned I may be breaking the law by saying you have to be a Church member. It's legal I promise! :-)    

From: Mark W. Farnham <mwf_at_rsiz.com>
To: ORACLE-L <oracle-l_at_freelists.org>
Sent: Friday, October 31, 2008 12:05:04 PM Subject: 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?

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

So far I have considered the cp command of the asmcmd utility and the DBSM_FILE_TRANSFER.COPY_FILE package.  

For the purposes of this exercise, we can assume that the ASM contained files to be copied are quiescent.  

I'm also interested in any "lessons learned" attempting such copies, and suggestions for alternatives within the scope of starting from ASM and landing on regular file systems.  

This is to get generations of integral backups out of the an ASM based FRA onto disk, which as far as I can tell is not something RMAN actually does.  

If I've missed the memo on how to do that, please advise, but all I see is going to SBT_TAPE for that.  

Regards, and thanks in advance,  

mwf  

PS: Repeating the RMAN backups directly to a file system (repeating the rdbms load of backup and the i/o and cpu load) has been considered and we're looking for something better than that. (But the scope remains ASM to file system.)

--
http://www.freelists.org/webpage/oracle-l