I've had to tackle this one a few months ago. If you haven't got the RMAN
Backup & Recovery book by Robert Freeman from Oracle Press its quite good
and has saved me a few times, particularly with RAC. But on page 435 you
get this great nugget of truth. "Media recovery in a RAC environment has one
rule that you must never forget: only one node can perform recovery". So
you set cluster_database=false. Do you duplicate, make sure you have
backups of both archive log threads because rman knows to apply both archive
log threads to the single instance. Then you have to basically re-cluster
you db by recreating the redo logs for thread 2, enable thread 2, set
cluster_database to true.
Here is the post duplicate sql script I have.
alter database add logfile thread 2 group 3
('/u06/oradata/dwprd/redo03.log') size 100M reuse, group 4
('/u06/oradata/dwprd/redo04.log') size 100M reuse;
alter database enable thread 2;
alter system set cluster_database=true scope=spfile;
alter database rename global_name to dwprd.tgic.com;
Then restart instance on node 2.
Hope that helps,
Bobby
-----Original Message-----
From: Jean-Hilaire Yapi [mailto:jhyapi@(protected)]
Sent: Monday, July 10, 2006 4:13 PM
To: suse-oracle@(protected)
Subject: [suse-oracle] Help for using RMAN to duplicate a two-nodes RAC
database
Hi everyone,
I have a RAC database with instances papp1 et papp2
I would like to create on a new set of server a duplicate of this database
(with instances pprod1 and pprod2) to serve as preproduction.
We are doing hot backup of production database with RMAN and a recovery
catalog. I would like to use the duplicate feature of RMAN to make the
duplication.
The duplication of a single instance is explained in Oracle Documentation
but I could not find anything about how to duplicate a RAC database using
RMAN backups.
Any help will be appreciated since I need the new database asap.
Regards
---------------------------------
Lèche-vitrine ou lèche-écran ? Yahoo! Magasinage.
-----------------------------------------
The information contained in this email and any attachments may be
privileged and/or confidential and protected from disclosure. It
is intended solely for the use of the recipient(s) to whom it is
addressed, or an employee or agent responsible for delivering this
message to the intended recipient(s). You are hereby notified that
any dissemination, distribution, copying or other use of this
communication is strictly prohibited. If you have received this
communication in error, please notify the sender by reply email and
delete this email and all attachments from your system. Thank you.
--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting
