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?
- From: "Mark W. Farnham" <mwf@xxxxxxxx>
- To: "'Robert Freeman'" <robertgfreeman@xxxxxxxxx>
- Date: Sat, 1 Nov 2008 09:55:30 -0400
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@xxxxxxxxx]
Sent: Friday, October 31, 2008 3:52 PM
To: mwf@xxxxxxxx
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@xxxxxxxx>
To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
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.)
Other related posts:
