RE: ASM - hardware mirroring vs. Oracle mirroring
Date: Mon, 14 Apr 2008 15:58:46 +0200
Message-ID: <000001c89e37$a8639eb0$4901000a@iconos.be>
Paul,
You could try to use the utl_file.fcopy procedure to copy the db files. But I think you would actually need a third db to initiate the copy (as your first db should be down to copy the online redo logs).
Regards,
Freek D'Hooge
Uptime
Oracle Database Administrator
email: freek.dhooge_at_uptime.be
tel +32(0)3 451 23 82
http://www.uptime.be
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Baumgartel, Paul
Sent: maandag 14 april 2008 15:39
To: Jared Still
Cc: oracle-l_at_freelists.org
Subject: RE: ASM - hardware mirroring vs. Oracle mirroring
I didn't say that RMAN doesn't work with ASM. I said that "there are
certain operations in, e.g., RMAN, that aren't supported with ASM". This
was based on co-workers' comments regarding a database migration to a new
server.
I just checked with them to clarify, and what they said is that if you're
migrating a database to a new machine, and you're using ASM, RMAN is the
only way to go, and the RMAN clone process requires an "open resetlogs" of
the copy after recovery. This caused a problem for them, as the database in
question uses Streams, and the resetlogs meant that Streams had to be set up
anew in the migrated database. They wanted a way to copy the database
(including online redo logs) and open it normally, and felt that the use of
ASM forced them to use RMAN, which made this impossible.
In my addled Friday-afternoon brain I interpreted and oversimplified that
information, so the statement in my post was incorrect.
Paul Baumgartel
CREDIT SUISSE
Information Technology
Prime Services Databases Americas
One Madison Avenue
New York, NY 10010
USA
Phone 212.538.1143
paul.baumgartel_at_credit-suisse.com
www.credit-suisse.com
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Apr 14 2008 - 08:58:46 CDT