RE: Duplicate online Database

From: Jack van Zanen <JACK_at_QUANTSYSTEMS.NL>
Date: Tue, 04 Mar 2003 03:43:58 -0800
Message-ID: <F001.0055F4B1.20030304034358@fatcity.com>

Use the Rman duplicate command  

Example test script for Oracle 8i:    

sqlplus /nolog <<EOF
connect sys/oracledba as sysdba
shutdown abort
startup nomount
exit
EOF
rm /data/oracle8/TEST3/*
rman <<EOF
connect target rman/rman_oracledba_at_test2 connect catalog rman/rman_oracledba_at_test1 connect auxiliary sys/oracledba_at_test3
run {
resync catalog;
allocate auxiliary channel d1 type disk; allocate auxiliary channel d2 type disk;

# set until time "to_date('2002-01-29:15:16:53','yyyy-mm-dd:hh24:mi:ss')"
# set until time "to_date('30-JAN-2002 10:50:00','dd-mon-YYYY HH24:MI:SS')"
# set until time '31-JAN-2002 10:51:00'
# set until time 'sysdate-1/96';
# set until scn = 155534

set newname for datafile '/data/oracle8/TEST2/systemTEST2.dbf' TO
'/data/oracle8/TEST3/systemTEST3.dbf';

set newname for datafile '/data/oracle8/TEST2/rbsTEST2.dbf' TO
'/data/oracle8/TEST3/rbsTEST3.dbf';

set newname for datafile '/data/oracle8/TEST2/tempTEST2.dbf' TO
'/data/oracle8/TEST3/tempTEST3.dbf';

set newname for datafile '/data/oracle8/TEST2/dataTEST2.dbf' TO
'/data/oracle8/TEST3/dataTEST3.dbf';

sql 'alter system switch logfile';
duplicate target database to test3
LOGFILE
'/data/oracle8/TEST3/redoTEST301.log' size 1M,
'/data/oracle8/TEST3/redoTEST302.log' size 1M,
'/data/oracle8/TEST3/redoTEST303.log' size 1M;
}
EOF -----Original Message-----
Sent: dinsdag 4 maart 2003 11:39
To: Multiple recipients of list ORACLE-L

I need to duplicate online database Oracle 8.1.7. It is not possible to shutdown the primary database. Can I do online backup this primary database by RMAN, and + using archivelogs create duplicate database? Inconsistent backups of RMAN + archivelogs = duplicate database??  

Thanks
Edouard Dormidontov

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jack van Zanen
  INET: JACK_at_QUANTSYSTEMS.NL

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: ListGuru_at_fatcity.com (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).

Received on Tue Mar 04 2003 - 05:43:58 CST