RE: RMAN Duplicate database

From: <Jill.Drocea_at_VerizonWireless.com>
Date: Tue, 7 Jun 2005 10:44:54 -0400
Message-Id: <20050607144457.0EE191BC482@turing.freelists.org>

Hi Scott,

The command you specified will clone the database to your aux server. Make sure db TRGT database has remote_login_passwordfile = exclusive. Also on AUX create a password file using command orapwd. You do not need the "allocate channel" command. It is not required since 9i. You can enhance your duplicate command with "recovery until time": ie

duplicate target database to aux nofilenamecheck until time="TO_DATE('03/03/05,21:50','MM/DD/YY,HH24:MI')";

 -----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Scott Stefick

Sent:	Tuesday, June 07, 2005 10:22 AM
To:	ORACLE-L_at_freelists.org
Subject:	RMAN Duplicate database

I'm getting ready to test an RMAN Duplicate Database script. I've never done this before and I'm looking to see if I understand this correctly before I run the test.

I'm on Solaris 8 and Oracle 10g. I'm duplicating from one server to another. They are both the same version and have the same directory structure. I'll call the DB's TRGT and AUX to be generic.

I created the initAUX.ora pfile on the auxiliary server The directory structure is exactly the same The RMAN Hotbackup is copied to the auxiliary server The archive logs are all copied to the auxiliary server

Here is my syntax:

run {
allocate auxiliary channel aux1 device type disk; duplicate target database to aux
nofilenamecheck;
}

Is this correct? Or will it overwrite what is on my target database?

Thanks in advance,
S
--

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

---

The information contained in this message and any attachment may be proprietary, confidential, and privileged or subject to the work product doctrine and thus protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify me immediately by replying to this message and deleting it and all copies and backups thereof. Thank you.

--

http://www.freelists.org/webpage/oracle-l Received on Tue Jun 07 2005 - 10:50:00 CDT