RE: RMAN Duplicate database

  • From: "Ruth Gramolini" <rgramolini@xxxxxxxxxxxxxxx>
  • To: <sstefick@xxxxxxxxx>, <ORACLE-L@xxxxxxxxxxxxx>
  • Date: Tue, 7 Jun 2005 10:58:35 -0400

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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Scott Stefick
Sent: Tuesday, June 07, 2005 10:22 AM
To: ORACLE-L@xxxxxxxxxxxxx
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
--
//www.freelists.org/webpage/oracle-l

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

Other related posts: