Here is a script that I use to clone a database from an rman backup.
rman
connect target sys/[EMAIL PROTECTED]
connect catalog rmanadmin/[EMAIL PROTECTED]
connect auxiliary sys/password
configure channel device type disk clear;
configure default device type to disk;
configure device type disk parallelism 3;
run {
SET UNTIL TIME "TO_DATE('08 SEP 2003 09:00:00','DD MON YYYY HH24:MI:SS')";
SET NEWNAME FOR DATAFILE 1 TO '/complete/path/to/clone/SYSTEM01.DBF';
SET NEWNAME FOR DATAFILE 2 TO '/complete/path/to/clone/UNDOTBS01.DBF';
SET NEWNAME FOR DATAFILE 3 TO '/complete/path/to/clone/CWMLITE01.DBF';
SET NEWNAME FOR DATAFILE 4 TO '/complete/path/to/clone/DRSYS01.DBF';
SET NEWNAME FOR DATAFILE 5 TO '/complete/path/to/clone/INDX01.DBF';
SET NEWNAME FOR DATAFILE 6 TO '/complete/path/to/clone/TOOLS01.DBF';
SET NEWNAME FOR DATAFILE 7 TO '/complete/path/to/clone/USERS01.DBF';
SET NEWNAME FOR DATAFILE 8 TO '/complete/path/to/clone/XDB01.DBF';
duplicate target database to CLONE_DB_NAME
LOGFILE
'/complete/path/to/log01.log' size 10M,
'/complete/path/to/log02.log' size 10M,
'/complete/path/to/log03.log' size 10M;
}
Scott Stefick
MILPDS OCP Oracle DBA
[EMAIL PROTECTED]
210-565-2540
-----Original Message-----
From: Tanel Poder [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 08, 2003 12:29 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Document/Resource link for cloning DB using RMAN in Oracle8i
When I typed "clone oracle database using rman" into google, the first hit
was:
http://www.nyquest.com/tutorials/cloneRMAN.html
Tanel.
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, September 08, 2003 6:09 PM
> Hi List,
>
> Does anyone have step by step instruction for cloning
> DB using RMAN in Oracle8i?
> Any help would be really appreciated.
>
> TIA
> Sami
>
> __________________________________
> Do you Yahoo!?
> Yahoo! SiteBuilder - Free, easy-to-use web site design software
> http://sitebuilder.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Oracle DBA
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L (or the
> name of mailing list you want to be removed from). You may also send
> the HELP command for other information (like subscribing).
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Tanel Poder
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
