RE: RMAN Duplicate database

This looks good to me.

If you want the duplicate db to include only what is on the backup, just do a set until time to one second after the backup completed so you won't have to deal with archivelogs created since the backup.

After you are done, be sure to check the temp datafiles. They tend not to be duplicated. Just creat them if they are not there.

Good luck,
Ruth

P.S. Scott, if you need anymore help you can call me. 802-828-5708. Hugs, R

-----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

--

http://www.freelists.org/webpage/oracle-l Received on Tue Jun 07 2005 - 11:09:12 CDT