DB
Cloning Steps using RMAN
On DEVL10gserver 172.16.0.70 (OCCN : 203.90.124.199 )
1. Bring the Listner and Apps tier services
down.
2. Bring the 'DEVL10g' Database down
Starting the Restoration using Rman On DEVLserver [172.16.0.70][as 'oracle' user]:
The RMAN backup was Copied to Location '/backup/rmanbackup/prod/level0' by the Customer
[Kindly Replace The Backup Location mentioned above with the New backup
Location].
$ export ORACLE_SID=DEVL
$ sqlplus '/as sysdba'
SQL> startup nomount
SQL>exit
On DEVL10gServer Setting the DBID
The DBID can be found as a part of the
Control file Rman backup
Eg '
CONTROL_644556222_2008_JAN_21 ', here in this Case the DBID is 29622524 [Replace the same with the actual
values. Replace the Text in Blue with the New Rman
Controlfile backup. ]
$ rman target /
RMAN> set DBID= 644556222
Restoring the Control File on DEVLserver:
The Following Restoration will restore 3 control files
Eg “/test01/oradevl/home/devldata/cntrl01.dbf,
/test10/oradevl/home/devldata/cntrl02.dbf,
/test12/oradevl/home/devldata/cntrl03.dbf”
RMAN> restore controlfile from '/rman_bkp/backup/
CONTROL_644556222_2008_JAN_21';
Starting with the RMAN restore database on
DEVLserver [as 'oracle' user]:
We need to rename the location where the
datafile should be restored as the directory structure is all together
different from the Production for DEVLserver [For this we will use
"SET NEWNAME FOR DATAFILE '<Path in
Prod>/<datafile Name>.dbf' to '<Path in DEVLserver>/<datafile
Name>.dbf'"
We also need to compare and manually edit
all the set newname for datafile, as there might have been an addition of a
datafile, so pls cross check with the Production instance of all the datafiles.
After setting the new location we need to Restore the
database and in the end also issue switch datafile all, in order to register
the new location of the datafiles in the controlfile.
RMAN>mount database;
RMAN> RUN {
allocate channel ch1 type disk;
SET NEWNAME FOR DATAFILE
'/controldb6/oractl9i/home/controldata/system01.dbf' to
'/test06/oradevl/home/devldata/system01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb6/oractl9i/home/controldata/system02.dbf' to
'/test06/oradevl/home/devldata/system02.dbf';
SET NEWNAME FOR DATAFILE
'/controldb6/oractl9i/home/controldata/system03.dbf' to
'/test06/oradevl/home/devldata/system03.dbf';
SET NEWNAME FOR DATAFILE
'/controldb6/oractl9i/home/controldata/system04.dbf' to
'/test06/oradevl/home/devldata/system04.dbf';
SET NEWNAME FOR DATAFILE '/controldb6/oractl9i/home/controldata/system05.dbf'
to '/test06/oradevl/home/devldata/system05.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/ctxd01.dbf' to
'/test01/oradevl/home/devldata/ctxd01.dbf';
SET NEWNAME FOR DATAFILE '/controldb6/oractl9i/home/controldata/owad01.dbf'
to '/test06/oradevl/home/devldata/owad01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb13/oractl9i/home/controldata/applsysd01.dbf' to
'/test13/oradevl/home/devldata/applsysd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb11/oractl9i/home/controldata/applsysx01.dbf' to
'/test11/oradevl/home/devldata/applsysx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb10/oractl9i/home/controldata/gld01.dbf' to
'/test10/oradevl/home/devldata/gld01.dbf';
SET
NEWNAME FOR DATAFILE '/controldb7/oractl9i/home/controldata/glx01.dbf' to
'/test07/oradevl/home/devldata/glx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/fad01.dbf' to
'/test01/oradevl/home/devldata/fad01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/fax01.dbf' to
'/test07/oradevl/home/devldata/fax01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/alrd01.dbf' to
'/test01/oradevl/home/devldata/alrd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/alrx01.dbf' to
'/test07/oradevl/home/devldata/alrx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb6/oractl9i/home/controldata/rgd01.dbf' to
'/test06/oradevl/home/devldata/rgd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/rgx01.dbf' to
'/test03/oradevl/home/devldata/rgx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/csd01.dbf' to
'/test01/oradevl/home/devldata/csd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/csx01.dbf' to
'/test07/oradevl/home/devldata/csx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/cctd01.dbf' to
'/test01/oradevl/home/devldata/cctd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/undo03.dbf' to
'/test03/oradevl/home/devldata/undo03.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/cctx01.dbf' to
'/test07/oradevl/home/devldata/cctx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/ecxd01.dbf' to
'/test01/oradevl/home/devldata/ecxd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/ecxx01.dbf' to '/test07/oradevl/home/devldata/ecxx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/ecd01.dbf' to
'/test03/oradevl/home/devldata/ecd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/ecx01.dbf' to '/test07/oradevl/home/devldata/ecx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/icxd01.dbf' to
'/test01/oradevl/home/devldata/icxd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/icxx01.dbf' to '/test07/oradevl/home/devldata/icxx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/xtrd01.dbf' to
'/test07/oradevl/home/devldata/xtrd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/xtrx01.dbf' to '/test03/oradevl/home/devldata/xtrx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/azd01.dbf' to
'/test01/oradevl/home/devldata/azd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/azx01.dbf' to '/test07/oradevl/home/devldata/azx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb17/oractl9i/home/controldata/bisd01.dbf' to
'/test17/oradevl/home/devldata/bisd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/bisx01.dbf' to
'/test07/oradevl/home/devldata/bisx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb4/oractl9i/home/controldata/apd01.dbf' to
'/test04/oradevl/home/devldata/apd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb4/oractl9i/home/controldata/apx01.dbf' to
'/test04/oradevl/home/devldata/apx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb8/oractl9i/home/controldata/pod01.dbf' to
'/test08/oradevl/home/devldata/pod01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb8/oractl9i/home/controldata/pox01.dbf' to
'/test08/oradevl/home/devldata/pox01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/ard01.dbf' to
'/test01/oradevl/home/devldata/ard01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb11/oractl9i/home/controldata/arx01.dbf' to
'/test11/oradevl/home/devldata/arx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb6/oractl9i/home/controldata/pnd01.dbf' to
'/test06/oradevl/home/devldata/pnd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/pnx01.dbf' to
'/test03/oradevl/home/devldata/pnx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb6/oractl9i/home/controldata/qad01.dbf' to
'/test06/oradevl/home/devldata/qad01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/qax01.dbf' to
'/test03/oradevl/home/devldata/qax01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/ced01.dbf' to
'/test01/oradevl/home/devldata/ced01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/cex01.dbf' to
'/test07/oradevl/home/devldata/cex01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/frmd01.dbf' to
'/test01/oradevl/home/devldata/frmd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/frmx01.dbf' to
'/test07/oradevl/home/devldata/frmx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/eaad01.dbf' to
'/test01/oradevl/home/devldata/eaad01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/eaax01.dbf' to
'/test07/oradevl/home/devldata/eaax01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/bscd01.dbf' to
'/test01/oradevl/home/devldata/bscd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/bscx01.dbf' to
'/test07/oradevl/home/devldata/bscx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/abmd01.dbf' to
'/test01/oradevl/home/devldata/abmd01.dbf';
SET NEWNAME FOR DATAFILE '/controldb7/oractl9i/home/controldata/abmx01.dbf'
to '/test07/oradevl/home/devldata/abmx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/evmd01.dbf' to
'/test01/oradevl/home/devldata/evmd01.dbf';
SET NEWNAME FOR DATAFILE '/controldb7/oractl9i/home/controldata/evmx01.dbf'
to '/test07/oradevl/home/devldata/evmx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/femd01.dbf' to
'/test01/oradevl/home/devldata/femd01.dbf';
SET NEWNAME FOR DATAFILE '/controldb7/oractl9i/home/controldata/femx01.dbf'
to '/test07/oradevl/home/devldata/femx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb10/oractl9i/home/controldata/pad01.dbf' to
'/test10/oradevl/home/devldata/pad01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/pax01.dbf' to
'/test03/oradevl/home/devldata/pax01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/osmd01.dbf' to
'/test03/oradevl/home/devldata/osmd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/osmx01.dbf' to
'/test03/oradevl/home/devldata/osmx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/cnd01.dbf' to
'/test01/oradevl/home/devldata/cnd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/cnx01.dbf' to
'/test07/oradevl/home/devldata/cnx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb6/oractl9i/home/controldata/pomd01.dbf' to
'/test06/oradevl/home/devldata/pomd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/pomx01.dbf' to
'/test03/oradevl/home/devldata/pomx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb6/oractl9i/home/controldata/oed01.dbf' to
'/test06/oradevl/home/devldata/oed01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/oex01.dbf' to
'/test03/oradevl/home/devldata/oex01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/wmsd01.dbf' to
'/test07/oradevl/home/devldata/wmsd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/wmsx01.dbf' to
'/test03/oradevl/home/devldata/wmsx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/wpsd01.dbf' to
'/test07/oradevl/home/devldata/wpsd01.dbf';
SET
NEWNAME FOR DATAFILE '/controldb3/oractl9i/home/controldata/wpsx01.dbf' to
'/test03/oradevl/home/devldata/wpsx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb4/oractl9i/home/controldata/invd01.dbf' to
'/test04/oradevl/home/devldata/invd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb4/oractl9i/home/controldata/invx01.dbf' to
'/test04/oradevl/home/devldata/invx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb6/oractl9i/home/controldata/mwad01.dbf' to
'/test06/oradevl/home/devldata/mwad01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/mwax01.dbf' to
'/test03/oradevl/home/devldata/mwax01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/wsmd01.dbf' to
'/test07/oradevl/home/devldata/wsmd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/wsmx01.dbf' to
'/test03/oradevl/home/devldata/wsmx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/fiid01.dbf' to '/test01/oradevl/home/devldata/fiid01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/fiix01.dbf' to
'/test07/oradevl/home/devldata/fiix01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb6/oractl9i/home/controldata/opid01.dbf' to '/test06/oradevl/home/devldata/opid01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/opix01.dbf' to
'/test03/oradevl/home/devldata/opix01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb6/oractl9i/home/controldata/poad01.dbf' to '/test06/oradevl/home/devldata/poad01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/poax01.dbf' to
'/test03/oradevl/home/devldata/poax01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/hrid01.dbf' to '/test01/oradevl/home/devldata/hrid01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/hrix01.dbf' to
'/test07/oradevl/home/devldata/hrix01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/iscd01.dbf' to '/test01/oradevl/home/devldata/iscd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/iscx01.dbf' to
'/test03/oradevl/home/devldata/iscx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb6/oractl9i/home/controldata/okcd01.dbf' to
'/test06/oradevl/home/devldata/okcd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/okcx01.dbf' to
'/test03/oradevl/home/devldata/okcx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/cscd01.dbf' to
'/test01/oradevl/home/devldata/cscd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/cscx01.dbf' to
'/test07/oradevl/home/devldata/cscx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/csdd01.dbf' to
'/test01/oradevl/home/devldata/csdd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/csdx01.dbf' to
'/test07/oradevl/home/devldata/csdx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/csfd01.dbf' to
'/test01/oradevl/home/devldata/csfd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/csfx01.dbf' to
'/test07/oradevl/home/devldata/csfx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/cssd01.dbf' to
'/test01/oradevl/home/devldata/cssd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/cssx01.dbf' to
'/test07/oradevl/home/devldata/cssx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb6/oractl9i/home/controldata/oksd01.dbf' to
'/test06/oradevl/home/devldata/oksd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/oksx01.dbf' to
'/test03/oradevl/home/devldata/oksx01.dbf';
SET NEWNAME FOR DATAFILE '/controldb6/oractl9i/home/controldata/med01.dbf'
to '/test06/oradevl/home/devldata/med01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/mex01.dbf' to
'/test03/oradevl/home/devldata/mex01.dbf';
SET NEWNAME FOR DATAFILE '/controldb1/oractl9i/home/controldata/bimd01.dbf'
to '/test01/oradevl/home/devldata/bimd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/bimx01.dbf' to
'/test07/oradevl/home/devldata/bimx01.dbf';
SET NEWNAME FOR DATAFILE '/controldb1/oractl9i/home/controldata/bicd01.dbf'
to '/test01/oradevl/home/devldata/bicd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/bicx01.dbf' to
'/test07/oradevl/home/devldata/bicx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/iesd01.dbf' to
'/test01/oradevl/home/devldata/iesd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/iesx01.dbf' to
'/test07/oradevl/home/devldata/iesx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/amvd01.dbf' to
'/test01/oradevl/home/devldata/amvd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/amvx01.dbf' to
'/test07/oradevl/home/devldata/amvx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/astd01.dbf' to
'/test01/oradevl/home/devldata/astd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/astx01.dbf' to
'/test07/oradevl/home/devldata/astx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/asfd01.dbf' to
'/test01/oradevl/home/devldata/asfd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/asfx01.dbf' to
'/test07/oradevl/home/devldata/asfx01.dbf';
SET
NEWNAME FOR DATAFILE '/controldb1/oractl9i/home/controldata/cspd01.dbf' to
'/test01/oradevl/home/devldata/cspd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/cspx01.dbf' to
'/test07/oradevl/home/devldata/cspx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb6/oractl9i/home/controldata/okxd01.dbf' to
'/test06/oradevl/home/devldata/okxd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/okxx01.dbf' to
'/test03/oradevl/home/devldata/okxx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/amsd01.dbf' to
'/test01/oradevl/home/devldata/amsd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/amsx01.dbf' to
'/test07/oradevl/home/devldata/amsx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/xnmd01.dbf' to
'/test07/oradevl/home/devldata/xnmd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/xnmx01.dbf' to
'/test03/oradevl/home/devldata/xnmx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/xncd01.dbf' to
'/test07/oradevl/home/devldata/xncd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/xncx01.dbf' to '/test03/oradevl/home/devldata/xncx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/xnsd01.dbf' to
'/test07/oradevl/home/devldata/xnsd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/xnsx01.dbf' to '/test03/oradevl/home/devldata/xnsx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/xnpd01.dbf' to
'/test07/oradevl/home/devldata/xnpd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/xnpx01.dbf' to '/test03/oradevl/home/devldata/xnpx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/xdpd01.dbf' to
'/test07/oradevl/home/devldata/xdpd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/xdpx01.dbf' to '/test03/oradevl/home/devldata/xdpx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/fptd01.dbf' to
'/test01/oradevl/home/devldata/fptd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/fptx01.dbf' to
'/test07/oradevl/home/devldata/fptx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/ieod01.dbf' to
'/test01/oradevl/home/devldata/ieod01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/ieox01.dbf' to
'/test07/oradevl/home/devldata/ieox01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/gmad01.dbf' to
'/test01/oradevl/home/devldata/gmad01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/gmax01.dbf' to
'/test07/oradevl/home/devldata/gmax01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/gmid01.dbf' to
'/test01/oradevl/home/devldata/gmid01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/gmix01.dbf' to
'/test07/oradevl/home/devldata/gmix01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/gmdd01.dbf' to
'/test01/oradevl/home/devldata/gmdd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/gmdx01.dbf' to
'/test07/oradevl/home/devldata/gmdx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/gmed01.dbf' to
'/test01/oradevl/home/devldata/gmed01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/gmex01.dbf' to
'/test07/oradevl/home/devldata/gmex01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/gmpd01.dbf' to
'/test01/oradevl/home/devldata/gmpd01.dbf';
SET NEWNAME FOR DATAFILE '/controldb7/oractl9i/home/controldata/gmpx01.dbf'
to '/test07/oradevl/home/devldata/gmpx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/gmfd01.dbf' to
'/test01/oradevl/home/devldata/gmfd01.dbf';
SET NEWNAME FOR DATAFILE '/controldb7/oractl9i/home/controldata/gmfx01.dbf'
to '/test07/oradevl/home/devldata/gmfx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/gmld01.dbf' to
'/test01/oradevl/home/devldata/gmld01.dbf';
SET NEWNAME FOR DATAFILE '/controldb7/oractl9i/home/controldata/gmlx01.dbf'
to '/test07/oradevl/home/devldata/gmlx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/grd01.dbf' to
'/test01/oradevl/home/devldata/grd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/grx01.dbf' to
'/test07/oradevl/home/devldata/grx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb6/oractl9i/home/controldata/pmid01.dbf' to
'/test06/oradevl/home/devldata/pmid01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/pmix01.dbf' to
'/test03/oradevl/home/devldata/pmix01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/axd01.dbf' to
'/test01/oradevl/home/devldata/axd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/axx01.dbf' to
'/test07/oradevl/home/devldata/axx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb10/oractl9i/home/controldata/akd01.dbf' to
'/test10/oradevl/home/devldata/akd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/akx01.dbf' to
'/test07/oradevl/home/devldata/akx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/xlad01.dbf' to
'/test07/oradevl/home/devldata/xlad01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/xlax01.dbf' to
'/test03/oradevl/home/devldata/xlax01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb10/oractl9i/home/controldata/ontd01.dbf' to
'/test10/oradevl/home/devldata/ontd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/ontx01.dbf' to
'/test03/oradevl/home/devldata/ontx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb6/oractl9i/home/controldata/qpd01.dbf' to
'/test06/oradevl/home/devldata/qpd01.dbf';
SET
NEWNAME FOR DATAFILE '/controldb3/oractl9i/home/controldata/qpx01.dbf' to
'/test03/oradevl/home/devldata/qpx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb6/oractl9i/home/controldata/rlmd01.dbf' to
'/test06/oradevl/home/devldata/rlmd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/rlmx01.dbf' to
'/test03/oradevl/home/devldata/rlmx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb6/oractl9i/home/controldata/vead01.dbf' to
'/test06/oradevl/home/devldata/vead01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/veax01.dbf' to
'/test03/oradevl/home/devldata/veax01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/wshd01.dbf' to
'/test07/oradevl/home/devldata/wshd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/wshx01.dbf' to
'/test03/oradevl/home/devldata/wshx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/ibad01.dbf' to
'/test01/oradevl/home/devldata/ibad01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/ibax01.dbf' to
'/test07/oradevl/home/devldata/ibax01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/ibed01.dbf' to '/test01/oradevl/home/devldata/ibed01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/ibex01.dbf' to
'/test07/oradevl/home/devldata/ibex01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/ibud01.dbf' to '/test01/oradevl/home/devldata/ibud01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/ibux01.dbf' to
'/test07/oradevl/home/devldata/ibux01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/ibyd01.dbf' to '/test01/oradevl/home/devldata/ibyd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/ibyx01.dbf' to
'/test07/oradevl/home/devldata/ibyx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/ibpd01.dbf' to '/test01/oradevl/home/devldata/ibpd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/ibpx01.dbf' to
'/test07/oradevl/home/devldata/ibpx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/bild01.dbf' to
'/test01/oradevl/home/devldata/bild01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/bilx01.dbf' to
'/test07/oradevl/home/devldata/bilx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/bixd01.dbf' to
'/test01/oradevl/home/devldata/bixd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/bixx01.dbf' to
'/test07/oradevl/home/devldata/bixx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/iemd01.dbf' to
'/test01/oradevl/home/devldata/iemd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/iemx01.dbf' to
'/test07/oradevl/home/devldata/iemx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb6/oractl9i/home/controldata/ozpd01.dbf' to
'/test06/oradevl/home/devldata/ozpd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/ozpx01.dbf' to
'/test03/oradevl/home/devldata/ozpx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb6/oractl9i/home/controldata/ozfd01.dbf' to
'/test06/oradevl/home/devldata/ozfd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/ozfx01.dbf' to
'/test03/oradevl/home/devldata/ozfx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb6/oractl9i/home/controldata/ozsd01.dbf' to
'/test06/oradevl/home/devldata/ozsd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/ozsx01.dbf' to
'/test03/oradevl/home/devldata/ozsx01.dbf';
SET NEWNAME FOR DATAFILE '/controldb1/oractl9i/home/controldata/asgd01.dbf'
to '/test01/oradevl/home/devldata/asgd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/asgx01.dbf' to
'/test07/oradevl/home/devldata/asgx01.dbf';
SET NEWNAME FOR DATAFILE '/controldb6/oractl9i/home/controldata/jtfd01.dbf'
to '/test06/oradevl/home/devldata/jtfd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/jtfx01.dbf' to
'/test03/oradevl/home/devldata/jtfx01.dbf';
SET NEWNAME FOR DATAFILE '/controldb1/oractl9i/home/controldata/iexd01.dbf'
to '/test01/oradevl/home/devldata/iexd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/iexx01.dbf' to
'/test07/oradevl/home/devldata/iexx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/ieud01.dbf' to
'/test01/oradevl/home/devldata/ieud01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/ieux01.dbf' to
'/test07/oradevl/home/devldata/ieux01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb8/oractl9i/home/controldata/asod01.dbf' to
'/test08/oradevl/home/devldata/asod01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/asox01.dbf' to
'/test07/oradevl/home/devldata/asox01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/csrd01.dbf' to
'/test01/oradevl/home/devldata/csrd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/csrx01.dbf' to
'/test07/oradevl/home/devldata/csrx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/iebd01.dbf' to
'/test01/oradevl/home/devldata/iebd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/iebx01.dbf' to
'/test07/oradevl/home/devldata/iebx01.dbf';
SET
NEWNAME FOR DATAFILE '/controldb6/oractl9i/home/controldata/mfgd01.dbf' to
'/test06/oradevl/home/devldata/mfgd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/mfgx01.dbf' to
'/test03/oradevl/home/devldata/mfgx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb11/oractl9i/home/controldata/bomd01.dbf' to
'/test11/oradevl/home/devldata/bomd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb6/oractl9i/home/controldata/bomx01.dbf' to
'/test06/oradevl/home/devldata/bomx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/engd01.dbf' to
'/test01/oradevl/home/devldata/engd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/engx01.dbf' to
'/test07/oradevl/home/devldata/engx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb5/oractl9i/home/controldata/mrpd01.dbf' to
'/test05/oradevl/home/devldata/mrpd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/mrpx01.dbf' to
'/test03/oradevl/home/devldata/mrpx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/crpd01.dbf' to
'/test01/oradevl/home/devldata/crpd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/crpx01.dbf' to '/test07/oradevl/home/devldata/crpx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb6/oractl9i/home/controldata/wipd01.dbf' to
'/test06/oradevl/home/devldata/wipd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb5/oractl9i/home/controldata/wipx01.dbf' to '/test05/oradevl/home/devldata/wipx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/czd01.dbf' to
'/test01/oradevl/home/devldata/czd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/czx01.dbf' to '/test07/oradevl/home/devldata/czx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb6/oractl9i/home/controldata/rlad01.dbf' to
'/test06/oradevl/home/devldata/rlad01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/rlax01.dbf' to '/test03/oradevl/home/devldata/rlax01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb6/oractl9i/home/controldata/vehd01.dbf' to
'/test06/oradevl/home/devldata/vehd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/vehx01.dbf' to '/test03/oradevl/home/devldata/vehx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb6/oractl9i/home/controldata/pjmd01.dbf' to
'/test06/oradevl/home/devldata/pjmd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/pjmx01.dbf' to
'/test03/oradevl/home/devldata/pjmx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/flmd01.dbf' to
'/test01/oradevl/home/devldata/flmd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/flmx01.dbf' to
'/test07/oradevl/home/devldata/flmx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb6/oractl9i/home/controldata/msdd01.dbf' to
'/test06/oradevl/home/devldata/msdd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/msdx01.dbf' to
'/test03/oradevl/home/devldata/msdx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb6/oractl9i/home/controldata/msod01.dbf' to
'/test06/oradevl/home/devldata/msod01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/msox01.dbf' to
'/test03/oradevl/home/devldata/msox01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb6/oractl9i/home/controldata/mscd01.dbf' to
'/test06/oradevl/home/devldata/mscd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/mscx01.dbf' to
'/test03/oradevl/home/devldata/mscx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb6/oractl9i/home/controldata/rhxd01.dbf' to
'/test06/oradevl/home/devldata/rhxd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/rhxx01.dbf' to
'/test03/oradevl/home/devldata/rhxx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb6/oractl9i/home/controldata/oked01.dbf' to
'/test06/oradevl/home/devldata/oked01.dbf';
SET NEWNAME FOR DATAFILE '/controldb3/oractl9i/home/controldata/okex01.dbf'
to '/test03/oradevl/home/devldata/okex01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/hrd01.dbf' to
'/test01/oradevl/home/devldata/hrd01.dbf';
SET NEWNAME FOR DATAFILE '/controldb7/oractl9i/home/controldata/hrx01.dbf'
to '/test07/oradevl/home/devldata/hrx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb6/oractl9i/home/controldata/sspd01.dbf' to
'/test06/oradevl/home/devldata/sspd01.dbf';
SET NEWNAME FOR DATAFILE '/controldb3/oractl9i/home/controldata/sspx01.dbf'
to '/test03/oradevl/home/devldata/sspx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/bend01.dbf' to
'/test01/oradevl/home/devldata/bend01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/benx01.dbf' to
'/test07/oradevl/home/devldata/benx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/hxtd01.dbf' to
'/test01/oradevl/home/devldata/hxtd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/hxtx01.dbf' to
'/test07/oradevl/home/devldata/hxtx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/hxcd01.dbf' to
'/test01/oradevl/home/devldata/hxcd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/hxcx01.dbf' to
'/test07/oradevl/home/devldata/hxcx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb6/oractl9i/home/controldata/otad01.dbf' to
'/test06/oradevl/home/devldata/otad01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/otax01.dbf' to
'/test03/oradevl/home/devldata/otax01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb9/oractl9i/home/controldata/jad01.dbf' to
'/test09/oradevl/home/devldata/jad01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/jax01.dbf' to
'/test03/oradevl/home/devldata/jax01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/jed01.dbf' to
'/test01/oradevl/home/devldata/jed01.dbf';
SET
NEWNAME FOR DATAFILE '/controldb3/oractl9i/home/controldata/jex01.dbf' to
'/test03/oradevl/home/devldata/jex01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/jgd01.dbf' to
'/test01/oradevl/home/devldata/jgd01.dbf';
SET
NEWNAME FOR DATAFILE '/controldb3/oractl9i/home/controldata/jgx01.dbf' to
'/test03/oradevl/home/devldata/jgx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/jld01.dbf' to
'/test01/oradevl/home/devldata/jld01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/jlx01.dbf' to
'/test03/oradevl/home/devldata/jlx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb6/oractl9i/home/controldata/psbd01.dbf' to
'/test06/oradevl/home/devldata/psbd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/psbx01.dbf' to
'/test03/oradevl/home/devldata/psbx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/gmsd01.dbf' to
'/test01/oradevl/home/devldata/gmsd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/gmsx01.dbf' to
'/test07/oradevl/home/devldata/gmsx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb6/oractl9i/home/controldata/pspd01.dbf' to
'/test06/oradevl/home/devldata/pspd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/pspx01.dbf' to
'/test03/oradevl/home/devldata/pspx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/igwd01.dbf' to '/test01/oradevl/home/devldata/igwd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/igwx01.dbf' to
'/test07/oradevl/home/devldata/igwx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/igsd01.dbf' to '/test01/oradevl/home/devldata/igsd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/igsx01.dbf' to
'/test07/oradevl/home/devldata/igsx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/igfd01.dbf' to '/test01/oradevl/home/devldata/igfd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/igfx01.dbf' to
'/test07/oradevl/home/devldata/igfx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/igcd01.dbf' to '/test01/oradevl/home/devldata/igcd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/igcx01.dbf' to
'/test07/oradevl/home/devldata/igcx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb6/oractl9i/home/controldata/psad01.dbf' to '/test06/oradevl/home/devldata/psad01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/psax01.dbf' to
'/test03/oradevl/home/devldata/psax01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/ipad01.dbf' to
'/test01/oradevl/home/devldata/ipad01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/ipax01.dbf' to
'/test03/oradevl/home/devldata/ipax01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/cuid01.dbf' to
'/test01/oradevl/home/devldata/cuid01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/cuix01.dbf' to
'/test07/oradevl/home/devldata/cuix01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/cupd01.dbf' to
'/test01/oradevl/home/devldata/cupd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/cupx01.dbf' to
'/test07/oradevl/home/devldata/cupx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/cufd01.dbf' to
'/test01/oradevl/home/devldata/cufd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/cufx01.dbf' to
'/test07/oradevl/home/devldata/cufx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/cusd01.dbf' to
'/test01/oradevl/home/devldata/cusd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/cusx01.dbf' to
'/test07/oradevl/home/devldata/cusx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/cund01.dbf' to
'/test01/oradevl/home/devldata/cund01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/cunx01.dbf' to
'/test07/oradevl/home/devldata/cunx01.dbf';
SET NEWNAME FOR DATAFILE '/controldb1/oractl9i/home/controldata/cuad01.dbf'
to '/test01/oradevl/home/devldata/cuad01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/cuax01.dbf' to
'/test07/oradevl/home/devldata/cuax01.dbf';
SET NEWNAME FOR DATAFILE '/controldb1/oractl9i/home/controldata/fvd01.dbf'
to '/test01/oradevl/home/devldata/fvd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/fvx01.dbf' to
'/test07/oradevl/home/devldata/fvx01.dbf';
SET NEWNAME FOR DATAFILE '/controldb11/oractl9i/home/controldata/applsysx02.dbf'
to '/test11/oradevl/home/devldata/applsysx02.dbf';
SET NEWNAME FOR DATAFILE
'/controldb6/oractl9i/home/controldata/applsysd02.dbf' to
'/test06/oradevl/home/devldata/applsysd02.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/asld01.dbf' to
'/test01/oradevl/home/devldata/asld01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/aslx01.dbf' to
'/test07/oradevl/home/devldata/aslx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb6/oractl9i/home/controldata/pvd01.dbf' to
'/test06/oradevl/home/devldata/pvd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/pvx01.dbf' to
'/test03/oradevl/home/devldata/pvx01.dbf';
SET
NEWNAME FOR DATAFILE '/controldb1/oractl9i/home/controldata/itgd01.dbf' to
'/test01/oradevl/home/devldata/itgd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/itgx01.dbf' to
'/test03/oradevl/home/devldata/itgx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/ipdd01.dbf' to
'/test01/oradevl/home/devldata/ipdd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/ipdx01.dbf' to
'/test03/oradevl/home/devldata/ipdx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/eamd01.dbf' to
'/test01/oradevl/home/devldata/eamd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/eamx01.dbf' to
'/test07/oradevl/home/devldata/eamx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/enid01.dbf' to
'/test01/oradevl/home/devldata/enid01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/enix01.dbf' to
'/test07/oradevl/home/devldata/enix01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb6/oractl9i/home/controldata/okrd01.dbf' to
'/test06/oradevl/home/devldata/okrd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/okrx01.dbf' to '/test03/oradevl/home/devldata/okrx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/cued01.dbf' to
'/test01/oradevl/home/devldata/cued01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/cuex01.dbf' to '/test07/oradevl/home/devldata/cuex01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/fted01.dbf' to
'/test01/oradevl/home/devldata/fted01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/ftex01.dbf' to '/test07/oradevl/home/devldata/ftex01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb6/oractl9i/home/controldata/msrd01.dbf' to
'/test06/oradevl/home/devldata/msrd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/msrx01.dbf' to '/test03/oradevl/home/devldata/msrx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/igid01.dbf' to
'/test01/oradevl/home/devldata/igid01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/igix01.dbf' to
'/test07/oradevl/home/devldata/igix01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb6/oractl9i/home/controldata/system06.dbf' to
'/test06/oradevl/home/devldata/system06.dbf';
SET NEWNAME FOR DATAFILE
'/controldb4/oractl9i/home/controldata/portal01.dbf' to
'/test04/oradevl/home/devldata/portal01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb6/oractl9i/home/controldata/system07.dbf' to
'/test06/oradevl/home/devldata/system07.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/ahld01.dbf' to
'/test01/oradevl/home/devldata/ahld01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/ahlx01.dbf' to
'/test07/oradevl/home/devldata/ahlx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/ahmd01.dbf' to
'/test01/oradevl/home/devldata/ahmd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/ahmx01.dbf' to
'/test07/oradevl/home/devldata/ahmx01.dbf';
SET NEWNAME FOR DATAFILE '/controldb1/oractl9i/home/controldata/aspd01.dbf'
to '/test01/oradevl/home/devldata/aspd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/aspx01.dbf' to
'/test07/oradevl/home/devldata/aspx01.dbf';
SET NEWNAME FOR DATAFILE '/controldb1/oractl9i/home/controldata/bivd01.dbf'
to '/test01/oradevl/home/devldata/bivd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/bivx01.dbf' to
'/test07/oradevl/home/devldata/bivx01.dbf';
SET NEWNAME FOR DATAFILE '/controldb1/oractl9i/home/controldata/csed01.dbf'
to '/test01/oradevl/home/devldata/csed01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/csex01.dbf' to
'/test07/oradevl/home/devldata/csex01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/csid01.dbf' to
'/test01/oradevl/home/devldata/csid01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/csix01.dbf' to
'/test07/oradevl/home/devldata/csix01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/csld01.dbf' to
'/test01/oradevl/home/devldata/csld01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/cslx01.dbf' to
'/test07/oradevl/home/devldata/cslx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/cugd01.dbf' to
'/test01/oradevl/home/devldata/cugd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/cugx01.dbf' to
'/test07/oradevl/home/devldata/cugx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/iecd01.dbf' to
'/test01/oradevl/home/devldata/iecd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/iecx01.dbf' to
'/test07/oradevl/home/devldata/iecx01.dbf';
SET
NEWNAME FOR DATAFILE '/controldb1/oractl9i/home/controldata/imcd01.dbf' to
'/test01/oradevl/home/devldata/imcd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/imcx01.dbf' to
'/test07/oradevl/home/devldata/imcx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/imtd01.dbf' to
'/test01/oradevl/home/devldata/imtd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/imtx01.dbf' to
'/test07/oradevl/home/devldata/imtx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb6/oractl9i/home/controldata/jtmd01.dbf' to
'/test06/oradevl/home/devldata/jtmd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/jtmx01.dbf' to
'/test03/oradevl/home/devldata/jtmx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb6/oractl9i/home/controldata/jtsd01.dbf' to
'/test06/oradevl/home/devldata/jtsd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/jtsx01.dbf' to
'/test03/oradevl/home/devldata/jtsx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb6/oractl9i/home/controldata/okbd01.dbf' to
'/test06/oradevl/home/devldata/okbd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/okbx01.dbf' to '/test03/oradevl/home/devldata/okbx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb6/oractl9i/home/controldata/okid01.dbf' to
'/test06/oradevl/home/devldata/okid01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/okix01.dbf' to '/test03/oradevl/home/devldata/okix01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb6/oractl9i/home/controldata/okod01.dbf' to
'/test06/oradevl/home/devldata/okod01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/okox01.dbf' to '/test03/oradevl/home/devldata/okox01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb6/oractl9i/home/controldata/posd01.dbf' to
'/test06/oradevl/home/devldata/posd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/posx01.dbf' to '/test03/oradevl/home/devldata/posx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/xnid01.dbf' to
'/test07/oradevl/home/devldata/xnid01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/xnix01.dbf' to
'/test03/oradevl/home/devldata/xnix01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb9/oractl9i/home/controldata/undo01.dbf' to
'/test09/oradevl/home/devldata/undo01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb6/oractl9i/home/controldata/system08.dbf' to
'/test06/oradevl/home/devldata/system08.dbf';
SET NEWNAME FOR DATAFILE
'/controldb6/oractl9i/home/controldata/system09.dbf' to
'/test06/oradevl/home/devldata/system09.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/amfd01.dbf' to
'/test01/oradevl/home/devldata/amfd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/amfx01.dbf' to
'/test07/oradevl/home/devldata/amfx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/bned01.dbf' to
'/test01/oradevl/home/devldata/bned01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/bnex01.dbf' to
'/test07/oradevl/home/devldata/bnex01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/csmd01.dbf' to
'/test01/oradevl/home/devldata/csmd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/csmx01.dbf' to
'/test07/oradevl/home/devldata/csmx01.dbf';
SET NEWNAME FOR DATAFILE '/controldb1/oractl9i/home/controldata/dddd01.dbf'
to '/test01/oradevl/home/devldata/dddd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/dddx01.dbf' to
'/test07/oradevl/home/devldata/dddx01.dbf';
SET NEWNAME FOR DATAFILE '/controldb1/oractl9i/home/controldata/domd01.dbf'
to '/test01/oradevl/home/devldata/domd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/domx01.dbf' to
'/test07/oradevl/home/devldata/domx01.dbf';
SET NEWNAME FOR DATAFILE '/controldb1/oractl9i/home/controldata/egod01.dbf'
to '/test01/oradevl/home/devldata/egod01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/egox01.dbf' to
'/test07/oradevl/home/devldata/egox01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/ibcd01.dbf' to
'/test01/oradevl/home/devldata/ibcd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/ibcx01.dbf' to
'/test07/oradevl/home/devldata/ibcx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb6/oractl9i/home/controldata/okld01.dbf' to
'/test06/oradevl/home/devldata/okld01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/oklx01.dbf' to
'/test03/oradevl/home/devldata/oklx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb6/oractl9i/home/controldata/pjid01.dbf' to
'/test06/oradevl/home/devldata/pjid01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/pjix01.dbf' to
'/test03/oradevl/home/devldata/pjix01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb6/oractl9i/home/controldata/pond01.dbf' to
'/test06/oradevl/home/devldata/pond01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/ponx01.dbf' to
'/test03/oradevl/home/devldata/ponx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb6/oractl9i/home/controldata/qotd01.dbf' to
'/test06/oradevl/home/devldata/qotd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/qotx01.dbf' to
'/test03/oradevl/home/devldata/qotx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb6/oractl9i/home/controldata/qrmd01.dbf' to
'/test06/oradevl/home/devldata/qrmd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/qrmx01.dbf' to
'/test03/oradevl/home/devldata/qrmx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb9/oractl9i/home/controldata/jad02.dbf' to
'/test09/oradevl/home/devldata/jad02.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/jax02.dbf' to
'/test03/oradevl/home/devldata/jax02.dbf';
SET NEWNAME FOR DATAFILE
'/controldb6/oractl9i/home/controldata/sun_cluster01.dbf to
'/test06/oradevl/home/devldata/sun_cluster01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb5/oractl9i/home/controldata/undo02.dbf' to '/test05/oradevl/home/devldata/undo02.dbf';
SET NEWNAME FOR DATAFILE
'/controldb11/oractl9i/home/controldata/applsysx03.dbf' to
'/test11/oradevl/home/devldata/applsysx03.dbf';
SET NEWNAME FOR DATAFILE
'/controldb13/oractl9i/home/controldata/applsysd03.dbf' to
'/test13/oradevl/home/devldata/applsysd03.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/bomd02.dbf' to
'/test07/oradevl/home/devldata/bomd02.dbf';
SET NEWNAME FOR DATAFILE
'/controldb12/oractl9i/home/controldata/bomx02.dbf' to
'/test12/oradevl/home/devldata/bomx02.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/icxd02.dbf' to
'/test03/oradevl/home/devldata/icxd02.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/icxx02.dbf' to
'/test07/oradevl/home/devldata/icxx02.dbf';
SET NEWNAME FOR DATAFILE
'/controldb4/oractl9i/home/controldata/invd02.dbf' to
'/test04/oradevl/home/devldata/invd02.dbf';
SET NEWNAME FOR DATAFILE
'/controldb4/oractl9i/home/controldata/invx02.dbf' to
'/test04/oradevl/home/devldata/invx02.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/ard02.dbf' to
'/test01/oradevl/home/devldata/ard02.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/axx02.dbf' to
'/test07/oradevl/home/devldata/axx02.dbf';
SET NEWNAME FOR DATAFILE
'/controldb4/oractl9i/home/controldata/amsd02.dbf' to
'/test04/oradevl/home/devldata/amsd02.dbf';
SET NEWNAME FOR DATAFILE '/controldb4/oractl9i/home/controldata/qpd02.dbf'
to '/test04/oradevl/home/devldata/qpd02.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/qpx02.dbf' to
'/test03/oradevl/home/devldata/qpx02.dbf';
SET NEWNAME FOR DATAFILE '/controldb3/oractl9i/home/controldata/wshx02.dbf'
to '/test03/oradevl/home/devldata/wshx02.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/oklx02.dbf' to
'/test03/oradevl/home/devldata/oklx02.dbf';
SET NEWNAME FOR DATAFILE '/controldb7/oractl9i/home/controldata/igfx02.dbf'
to '/test07/oradevl/home/devldata/igfx02.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/jtfx02.dbf' to
'/test03/oradevl/home/devldata/jtfx02.dbf';
SET NEWNAME FOR DATAFILE '/controldb3/oractl9i/home/controldata/ontd02.dbf'
to '/test03/oradevl/home/devldata/ontd02.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/ontx02.dbf' to
'/test03/oradevl/home/devldata/ontx02.dbf';
SET NEWNAME FOR DATAFILE
'/controldb4/oractl9i/home/controldata/qad02.dbf' to
'/test04/oradevl/home/devldata/qad02.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/igsx02.dbf' to
'/test07/oradevl/home/devldata/igsx02.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/igsd02.dbf' to
'/test03/oradevl/home/devldata/igsd02.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/hrd02.dbf' to
'/test01/oradevl/home/devldata/hrd02.dbf';
SET NEWNAME FOR DATAFILE
'/controldb11/oractl9i/home/controldata/arx02.dbf' to
'/test11/oradevl/home/devldata/arx02.dbf';
SET NEWNAME FOR DATAFILE
'/controldb4/oractl9i/home/controldata/qad03.dbf' to
'/test04/oradevl/home/devldata/qad03.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/qax02.dbf' to
'/test03/oradevl/home/devldata/qax02.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/qax03.dbf' to
'/test03/oradevl/home/devldata/qax03.dbf';
SET NEWNAME FOR DATAFILE
'/controldb5/oractl9i/home/controldata/bomd03.dbf' to
'/test05/oradevl/home/devldata/bomd03.dbf';
SET NEWNAME FOR DATAFILE
'/controldb11/oractl9i/home/controldata/arx03.dbf' to
'/test11/oradevl/home/devldata/arx03.dbf';
SET NEWNAME FOR DATAFILE
'/controldb4/oractl9i/home/controldata/invx03.dbf' to
'/test04/oradevl/home/devldata/invx03.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/czd02.dbf' to
'/test03/oradevl/home/devldata/czd02.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/czx02.dbf' to
'/test07/oradevl/home/devldata/czx02.dbf';
SET NEWNAME FOR DATAFILE
'/controldb9/oractl9i/home/controldata/applsysd05.dbf' to
'/test09/oradevl/home/devldata/applsysd05.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/pod02.dbf' to
'/test07/oradevl/home/devldata/pod02.dbf';
SET NEWNAME FOR DATAFILE
'/controldb9/oractl9i/home/controldata/customx01.dbf' to
'/test09/oradevl/home/devldata/customx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/ctxd02.dbf' to
'/test03/oradevl/home/devldata/ctxd02.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/perfstat01.dbf' to '/test03/oradevl/home/devldata/perfstat01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/ibed02.dbf' to
'/test03/oradevl/home/devldata/ibed02.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/ibex02.dbf' to '/test07/oradevl/home/devldata/ibex02.dbf';
SET NEWNAME FOR DATAFILE
'/controldb9/oractl9i/home/controldata/applsysx06.dbf' to
'/test09/oradevl/home/devldata/applsysx06.dbf';
SET NEWNAME FOR DATAFILE
'/controldb12/oractl9i/home/controldata/invd06.dbf' to
'/test12/oradevl/home/devldata/invd06.dbf';
SET NEWNAME FOR DATAFILE
'/controldb4/oractl9i/home/controldata/invx06.dbf' to
'/test04/oradevl/home/devldata/invx06.dbf';
SET NEWNAME FOR DATAFILE
'/controldb9/oractl9i/home/controldata/custom02.dbf' to
'/test09/oradevl/home/devldata/custom02.dbf';
SET NEWNAME FOR DATAFILE
'/controldb5/oractl9i/home/controldata/mrpd02.dbf' to
'/test05/oradevl/home/devldata/mrpd02.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/mrpx02.dbf' to
'/test03/oradevl/home/devldata/mrpx02.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/czd03.dbf' to
'/test03/oradevl/home/devldata/czd03.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/hrx02.dbf' to
'/test07/oradevl/home/devldata/hrx02.dbf';
SET NEWNAME FOR DATAFILE
'/controldb8/oractl9i/home/controldata/pox02.dbf' to
'/test08/oradevl/home/devldata/pox02.dbf';
SET NEWNAME FOR DATAFILE
'/controldb12/oractl9i/home/controldata/invd05.dbf' to
'/test12/oradevl/home/devldata/invd05.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/csid02.dbf' to
'/test03/oradevl/home/devldata/csid02.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/csix02.dbf' to
'/test07/oradevl/home/devldata/csix02.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/csid03.dbf' to
'/test03/oradevl/home/devldata/csid03.dbf';
SET NEWNAME FOR DATAFILE '/controldb7/oractl9i/home/controldata/csix03.dbf'
to '/test07/oradevl/home/devldata/csix03.dbf';
SET NEWNAME FOR DATAFILE
'/controldb9/oractl9i/home/controldata/custom01.dbf' to
'/test09/oradevl/home/devldata/custom01.dbf';
SET NEWNAME FOR DATAFILE '/controldb7/oractl9i/home/controldata/czx03.dbf'
to '/test07/oradevl/home/devldata/czx03.dbf';
SET NEWNAME FOR DATAFILE
'/controldb5/oractl9i/home/controldata/bomx03.dbf' to
'/test05/oradevl/home/devldata/bomx03.dbf';
SET NEWNAME FOR DATAFILE '/controldb4/oractl9i/home/controldata/apd02.dbf'
to '/test04/oradevl/home/devldata/apd02.dbf';
SET NEWNAME FOR DATAFILE
'/controldb4/oractl9i/home/controldata/apd03.dbf' to
'/test04/oradevl/home/devldata/apd03.dbf';
SET NEWNAME FOR DATAFILE
'/controldb4/oractl9i/home/controldata/apx02.dbf' to
'/test04/oradevl/home/devldata/apx02.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/fax02.dbf' to
'/test07/oradevl/home/devldata/fax02.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/fax03.dbf' to
'/test07/oradevl/home/devldata/fax03.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/ctxd03.dbf' to
'/test03/oradevl/home/devldata/ctxd03.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/wipd02.dbf' to
'/test07/oradevl/home/devldata/wipd02.dbf';
SET NEWNAME FOR DATAFILE
'/controldb4/oractl9i/home/controldata/wipx02.dbf' to
'/test04/oradevl/home/devldata/wipx02.dbf';
SET NEWNAME FOR DATAFILE
'/controldb9/oractl9i/home/controldata/xnpd02.dbf' to
'/test09/oradevl/home/devldata/xnpd02.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/xnpx02.dbf' to
'/test03/oradevl/home/devldata/xnpx02.dbf';
SET NEWNAME FOR DATAFILE
'/controldb11/oractl9i/home/controldata/asod02.dbf' to
'/test11/oradevl/home/devldata/asod02.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/czd04.dbf' to
'/test01/oradevl/home/devldata/czd04.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/osmx02.dbf' to
'/test03/oradevl/home/devldata/osmx02.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/czx04.dbf' to
'/test07/oradevl/home/devldata/czx04.dbf';
SET
NEWNAME FOR DATAFILE '/controldb4/oractl9i/home/controldata/wshd02.dbf' to
'/test04/oradevl/home/devldata/wshd02.dbf';
SET NEWNAME FOR DATAFILE
'/controldb8/oractl9i/home/controldata/applsysd04.dbf' to
'/test08/oradevl/home/devldata/applsysd04.dbf';
SET NEWNAME FOR DATAFILE
'/controldb11/oractl9i/home/controldata/applsysx04.dbf' to
'/test11/oradevl/home/devldata/applsysx04.dbf';
SET NEWNAME FOR DATAFILE
'/controldb12/oractl9i/home/controldata/bomd04.dbf' to '/test12/oradevl/home/devldata/bomd04.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/csid04.dbf' to
'/test01/oradevl/home/devldata/csid04.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/osmx03.dbf' to '/test03/oradevl/home/devldata/osmx03.dbf';
SET NEWNAME FOR DATAFILE
'/controldb4/oractl9i/home/controldata/qpx03.dbf' to
'/test04/oradevl/home/devldata/qpx03.dbf';
SET NEWNAME FOR DATAFILE
'/controldb8/oractl9i/home/controldata/mrpd03.dbf' to '/test08/oradevl/home/devldata/mrpd03.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/mrpx03.dbf' to
'/test03/oradevl/home/devldata/mrpx03.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/alrd02.dbf' to '/test01/oradevl/home/devldata/alrd02.dbf';
SET NEWNAME FOR DATAFILE
'/controldb5/oractl9i/home/controldata/jtfd02.dbf' to
'/test05/oradevl/home/devldata/jtfd02.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/ieud02.dbf' to
'/test01/oradevl/home/devldata/ieud02.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/crpd02.dbf' to
'/test01/oradevl/home/devldata/crpd02.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/icxd03.dbf' to
'/test01/oradevl/home/devldata/icxd03.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/crpx03.dbf' to
'/test03/oradevl/home/devldata/crpx03.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/ibed03.dbf' to
'/test01/oradevl/home/devldata/ibed03.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/ibex03.dbf' to
'/test03/oradevl/home/devldata/ibex03.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/csd02.dbf' to
'/test01/oradevl/home/devldata/csd02.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/csx02.dbf' to
'/test03/oradevl/home/devldata/csx02.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/csdd02.dbf' to
'/test01/oradevl/home/devldata/csdd02.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/csdx02.dbf' to
'/test03/oradevl/home/devldata/csdx02.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/csd03.dbf' to
'/test03/oradevl/home/devldata/csd03.dbf';
SET NEWNAME FOR DATAFILE
'/controldb5/oractl9i/home/controldata/mrpd04.dbf' to
'/test05/oradevl/home/devldata/mrpd04.dbf';
SET NEWNAME FOR DATAFILE
'/controldb4/oractl9i/home/controldata/invd03.dbf' to
'/test04/oradevl/home/devldata/invd03.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/cssd02.dbf' to
'/test01/oradevl/home/devldata/cssd02.dbf';
SET NEWNAME FOR DATAFILE '/controldb3/oractl9i/home/controldata/cssx02.dbf'
to '/test03/oradevl/home/devldata/cssx02.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/mrpx04.dbf' to
'/test03/oradevl/home/devldata/mrpx04.dbf';
SET NEWNAME FOR DATAFILE '/controldb1/oractl9i/home/controldata/hxtd02.dbf'
to '/test01/oradevl/home/devldata/hxtd02.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/hxtx02.dbf' to
'/test03/oradevl/home/devldata/hxtx02.dbf';
SET NEWNAME FOR DATAFILE '/controldb4/oractl9i/home/controldata/wshd03.dbf'
to '/test04/oradevl/home/devldata/wshd03.dbf';
SET NEWNAME FOR DATAFILE
'/controldb4/oractl9i/home/controldata/wshx03.dbf' to
'/test04/oradevl/home/devldata/wshx03.dbf';
SET NEWNAME FOR DATAFILE
'/controldb4/oractl9i/home/controldata/invd04.dbf' to
'/test04/oradevl/home/devldata/invd04.dbf';
SET NEWNAME FOR DATAFILE
'/controldb4/oractl9i/home/controldata/invx04.dbf' to
'/test04/oradevl/home/devldata/invx04.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/mrpd05.dbf' to
'/test07/oradevl/home/devldata/mrpd05.dbf';
SET NEWNAME FOR DATAFILE
'/controldb10/oractl9i/home/controldata/gld02.dbf' to
'/test10/oradevl/home/devldata/gld02.dbf';
SET NEWNAME FOR DATAFILE
'/controldb6/oractl9i/home/controldata/jtfd03.dbf' to
'/test06/oradevl/home/devldata/jtfd03.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/jtfx03.dbf' to
'/test03/oradevl/home/devldata/jtfx03.dbf';
SET NEWNAME FOR DATAFILE
'/controldb9/oractl9i/home/controldata/asod03.dbf' to
'/test09/oradevl/home/devldata/asod03.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/asox02.dbf' to
'/test03/oradevl/home/devldata/asox02.dbf';
SET
NEWNAME FOR DATAFILE '/controldb3/oractl9i/home/controldata/asox03.dbf' to
'/test03/oradevl/home/devldata/asox03.dbf';
SET NEWNAME FOR DATAFILE
'/controldb12/oractl9i/home/controldata/invx05.dbf' to
'/test12/oradevl/home/devldata/invx05.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/mscd02.dbf' to
'/test03/oradevl/home/devldata/mscd02.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/mscx02.dbf' to
'/test03/oradevl/home/devldata/mscx02.dbf';
SET NEWNAME FOR DATAFILE
'/controldb8/oractl9i/home/controldata/pod03.dbf' to
'/test08/oradevl/home/devldata/pod03.dbf';
SET NEWNAME FOR DATAFILE
'/controldb8/oractl9i/home/controldata/pox03.dbf' to
'/test08/oradevl/home/devldata/pox03.dbf';
SET NEWNAME FOR DATAFILE
'/controldb5/oractl9i/home/controldata/bomx04.dbf' to
'/test05/oradevl/home/devldata/bomx04.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/jax03.dbf' to
'/test03/oradevl/home/devldata/jax03.dbf';
SET NEWNAME FOR DATAFILE
'/controldb13/oractl9i/home/controldata/applsysx05.dbf' to
'/test13/oradevl/home/devldata/applsysx05.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/eamd02.dbf' to '/test01/oradevl/home/devldata/eamd02.dbf';
SET NEWNAME FOR DATAFILE
'/controldb6/oractl9i/home/controldata/wipd03.dbf' to
'/test06/oradevl/home/devldata/wipd03.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/ontd03.dbf' to '/test03/oradevl/home/devldata/ontd03.dbf';
SET NEWNAME FOR DATAFILE
'/controldb5/oractl9i/home/controldata/crpd03.dbf' to
'/test05/oradevl/home/devldata/crpd03.dbf';
SET NEWNAME FOR DATAFILE
'/controldb4/oractl9i/home/controldata/crpx02.dbf' to '/test04/oradevl/home/devldata/crpx02.dbf';
SET NEWNAME FOR DATAFILE
'/controldb6/oractl9i/home/controldata/gv01.dbf' to
'/test06/oradevl/home/devldata/gv01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/ms01.dbf' to '/test07/oradevl/home/devldata/ms01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb9/oractl9i/home/controldata/xnpd03.dbf' to
'/test09/oradevl/home/devldata/xnpd03.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/gld03.dbf' to '/test01/oradevl/home/devldata/gld03.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/mrpx05.dbf' to
'/test03/oradevl/home/devldata/mrpx05.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/eul_us01.dbf' to
'/test07/oradevl/home/devldata/eul_us01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb9/oractl9i/home/controldata/asod04.dbf' to
'/test09/oradevl/home/devldata/asod04.dbf';
SET NEWNAME FOR DATAFILE
'/controldb4/oractl9i/home/controldata/ajinnid01.dbf' to
'/test04/oradevl/home/devldata/ajinnid01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb5/oractl9i/home/controldata/archived01.dbf' to
'/test05/oradevl/home/devldata/archived01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb8/oractl9i/home/controldata/merged01.dbf' to
'/test08/oradevl/home/devldata/merged01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/undo04.dbf' to
'/test03/oradevl/home/devldata/undo04.dbf';
SET NEWNAME FOR DATAFILE '/controldb5/oractl9i/home/controldata/undo05.dbf'
to '/test05/oradevl/home/devldata/undo05.dbf';
SET NEWNAME FOR DATAFILE
'/controldb11/oractl9i/home/controldata/bomx05.dbf' to
'/test11/oradevl/home/devldata/bomx05.dbf';
SET NEWNAME FOR DATAFILE '/controldb1/oractl9i/home/controldata/csid05.dbf'
to '/test01/oradevl/home/devldata/csid05.dbf';
SET NEWNAME FOR DATAFILE
'/controldb10/oractl9i/home/controldata/asod05.dbf' to
'/test10/oradevl/home/devldata/asod05.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/invd07.dbf' to
'/test07/oradevl/home/devldata/invd07.dbf';
SET NEWNAME FOR DATAFILE
'/controldb8/oractl9i/home/controldata/pr01.dbf' to
'/test08/oradevl/home/devldata/pr01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb6/oractl9i/home/controldata/ks01.dbf' to
'/test06/oradevl/home/devldata/ks01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb13/oractl9i/home/controldata/applsysd06.dbf' to
'/test13/oradevl/home/devldata/applsysd06.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/amwd01.dbf' to
'/test07/oradevl/home/devldata/amwd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/amwx01.dbf' to
'/test07/oradevl/home/devldata/amwx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/asnd01.dbf' to
'/test07/oradevl/home/devldata/asnd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/asnx01.dbf' to
'/test07/oradevl/home/devldata/asnx01.dbf';
SET
NEWNAME FOR DATAFILE '/controldb7/oractl9i/home/controldata/clnd01.dbf' to
'/test07/oradevl/home/devldata/clnd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/clnx01.dbf' to
'/test07/oradevl/home/devldata/clnx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/edrd01.dbf' to
'/test07/oradevl/home/devldata/edrd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/edrx01.dbf' to
'/test07/oradevl/home/devldata/edrx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/fpad01.dbf' to
'/test07/oradevl/home/devldata/fpad01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/controldatax01.db to
'/test07/oradevl/home/devldata/controldatax01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/fund01.dbf' to
'/test07/oradevl/home/devldata/fund01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/funx01.dbf' to '/test07/oradevl/home/devldata/funx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/gcsd01.dbf' to
'/test07/oradevl/home/devldata/gcsd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/gcsx01.dbf' to '/test07/oradevl/home/devldata/gcsx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/iad01.dbf' to
'/test07/oradevl/home/devldata/iad01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/iax01.dbf' to '/test07/oradevl/home/devldata/iax01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/lnsd01.dbf' to
'/test07/oradevl/home/devldata/lnsd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/lnsx01.dbf' to
'/test07/oradevl/home/devldata/lnsx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/mstd01.dbf' to
'/test07/oradevl/home/devldata/mstd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/mstx01.dbf' to
'/test07/oradevl/home/devldata/mstx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/prpd01.dbf' to
'/test07/oradevl/home/devldata/prpd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/prpx01.dbf' to
'/test07/oradevl/home/devldata/prpx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/xdod01.dbf' to
'/test07/oradevl/home/devldata/xdod01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/xdox01.dbf' to
'/test07/oradevl/home/devldata/xdox01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/xled01.dbf' to
'/test07/oradevl/home/devldata/xled01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/xlex01.dbf' to
'/test07/oradevl/home/devldata/xlex01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/xnbd01.dbf' to
'/test07/oradevl/home/devldata/xnbd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/xnbx01.dbf' to
'/test07/oradevl/home/devldata/xnbx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/zfad01.dbf' to
'/test07/oradevl/home/devldata/zfad01.dbf';
SET NEWNAME FOR DATAFILE '/controldb7/oractl9i/home/controldata/zfax01.dbf'
to '/test07/oradevl/home/devldata/zfax01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/zpbd01.dbf' to
'/test07/oradevl/home/devldata/zpbd01.dbf';
SET NEWNAME FOR DATAFILE '/controldb7/oractl9i/home/controldata/zpbx01.dbf'
to '/test07/oradevl/home/devldata/zpbx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/zsad01.dbf' to
'/test07/oradevl/home/devldata/zsad01.dbf';
SET NEWNAME FOR DATAFILE '/controldb7/oractl9i/home/controldata/zsax01.dbf'
to '/test07/oradevl/home/devldata/zsax01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/zxd01.dbf' to
'/test07/oradevl/home/devldata/zxd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/zxx01.dbf' to
'/test07/oradevl/home/devldata/zxx01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/interim.dbf' to
'/test07/oradevl/home/devldata/interim.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/csix04.dbf' to
'/test03/oradevl/home/devldata/csix04.dbf';
SET NEWNAME FOR DATAFILE
'/controldb8/oractl9i/home/controldata/hrx03.dbf' to
'/test08/oradevl/home/devldata/hrx03.dbf';
SET NEWNAME FOR DATAFILE
'/controldb8/oractl9i/home/controldata/wipd04.dbf' to
'/test08/oradevl/home/devldata/wipd04.dbf';
SET NEWNAME FOR DATAFILE
'/controldb10/oractl9i/home/controldata/invx07.dbf' to
'/test10/oradevl/home/devldata/invx07.dbf';
SET NEWNAME FOR DATAFILE
'/controldb8/oractl9i/home/controldata/apd04.dbf' to
'/test08/oradevl/home/devldata/apd04.dbf';
SET NEWNAME FOR DATAFILE
'/controldb9/oractl9i/home/controldata/jad03.dbf' to
'/test09/oradevl/home/devldata/jad03.dbf';
SET NEWNAME FOR DATAFILE
'/controldb8/oractl9i/home/controldata/bomd05.dbf' to
'/test08/oradevl/home/devldata/bomd05.dbf';
SET NEWNAME FOR DATAFILE
'/controldb10/oractl9i/home/controldata/bomd06.dbf' to
'/test10/oradevl/home/devldata/bomd06.dbf';
SET
NEWNAME FOR DATAFILE '/controldb8/oractl9i/home/controldata/bomd07.dbf' to
'/test08/oradevl/home/devldata/bomd07.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/czd05.dbf' to
'/test01/oradevl/home/devldata/czd05.dbf';
SET NEWNAME FOR DATAFILE
'/controldb4/oractl9i/home/controldata/invx08.dbf' to
'/test04/oradevl/home/devldata/invx08.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/hxtd03.dbf' to
'/test01/oradevl/home/devldata/hxtd03.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/csid06.dbf' to
'/test01/oradevl/home/devldata/csid06.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/csid07.dbf' to
'/test01/oradevl/home/devldata/csid07.dbf';
SET NEWNAME FOR DATAFILE
'/controldb10/oractl9i/home/controldata/bomd08.dbf' to
'/test10/oradevl/home/devldata/bomd08.dbf';
SET NEWNAME FOR DATAFILE
'/controldb11/oractl9i/home/controldata/bomx06.dbf' to
'/test11/oradevl/home/devldata/bomx06.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/csid08.dbf' to
'/test01/oradevl/home/devldata/csid08.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/fiid02.dbf' to '/test01/oradevl/home/devldata/fiid02.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/csid09.dbf' to
'/test01/oradevl/home/devldata/csid09.dbf';
SET NEWNAME FOR DATAFILE
'/controldb12/oractl9i/home/controldata/tcsd01.dbf' to '/test12/oradevl/home/devldata/tcsd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/bisd02.dbf' to
'/test01/oradevl/home/devldata/bisd02.dbf';
SET NEWNAME FOR DATAFILE
'/controldb10/oractl9i/home/controldata/bisd03.dbf' to '/test10/oradevl/home/devldata/bisd03.dbf';
SET NEWNAME FOR DATAFILE
'/controldb10/oractl9i/home/controldata/bisd04.dbf' to
'/test10/oradevl/home/devldata/bisd04.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/wipd05.dbf' to
'/test07/oradevl/home/devldata/wipd05.dbf';
SET NEWNAME FOR DATAFILE
'/controldb8/oractl9i/home/controldata/pr02.dbf' to
'/test08/oradevl/home/devldata/pr02.dbf';
SET NEWNAME FOR DATAFILE
'/controldb10/oractl9i/home/controldata/invx08.dbf' to
'/test10/oradevl/home/devldata/invx08.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/glx02.dbf' to
'/test07/oradevl/home/devldata/glx02.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/gld04.dbf' to
'/test01/oradevl/home/devldata/gld04.dbf';
SET NEWNAME FOR DATAFILE
'/controldb13/oractl9i/home/controldata/applsysd07.dbf' to
'/test13/oradevl/home/devldata/applsysd07.dbf';
SET NEWNAME FOR DATAFILE
'/controldb4/oractl9i/home/controldata/invd08.dbf' to
'/test04/oradevl/home/devldata/invd08.dbf';
SET NEWNAME FOR DATAFILE
'/controldb6/oractl9i/home/controldata/czd07.dbf' to
'/test06/oradevl/home/devldata/czd07.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/czd06.dbf' to
'/test03/oradevl/home/devldata/czd06.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/csid10.dbf' to
'/test03/oradevl/home/devldata/csid10.dbf';
SET NEWNAME FOR DATAFILE
'/controldb5/oractl9i/home/controldata/enid02.dbf' to
'/test05/oradevl/home/devldata/enid02.dbf';
SET NEWNAME FOR DATAFILE
'/controldb10/oractl9i/home/controldata/invx09.dbf' to
'/test10/oradevl/home/devldata/invx09.dbf';
SET NEWNAME FOR DATAFILE '/controldb10/oractl9i/home/controldata/pox04.dbf'
to '/test10/oradevl/home/devldata/pox04.dbf';
SET NEWNAME FOR DATAFILE
'/controldb10/oractl9i/home/controldata/ontd04.dbf' to
'/test10/oradevl/home/devldata/ontd04.dbf';
SET NEWNAME FOR DATAFILE '/controldb10/oractl9i/home/controldata/csix05.dbf'
to '/test10/oradevl/home/devldata/csix05.dbf';
SET NEWNAME FOR DATAFILE
'/controldb10/oractl9i/home/controldata/wipx03.dbf' to
'/test10/oradevl/home/devldata/wipx03.dbf';
SET NEWNAME FOR DATAFILE '/controldb4/oractl9i/home/controldata/wshx04.dbf'
to '/test04/oradevl/home/devldata/wshx04.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/czx05.dbf' to
'/test07/oradevl/home/devldata/czx05.dbf';
SET NEWNAME FOR DATAFILE
'/controldb10/oractl9i/home/controldata/apd05.dbf' to
'/test10/oradevl/home/devldata/apd05.dbf';
SET NEWNAME FOR DATAFILE
'/controldb10/oractl9i/home/controldata/invx10.dbf' to
'/test10/oradevl/home/devldata/invx10.dbf';
SET NEWNAME FOR DATAFILE
'/controldb10/oractl9i/home/controldata/poad02.dbf' to
'/test10/oradevl/home/devldata/poad02.dbf';
SET NEWNAME FOR DATAFILE
'/controldb11/oractl9i/home/controldata/wipd06.dbf' to
'/test11/oradevl/home/devldata/wipd06.dbf';
SET NEWNAME FOR DATAFILE
'/controldb11/oractl9i/home/controldata/custom03.dbf' to
'/test11/oradevl/home/devldata/custom03.dbf';
SET NEWNAME FOR DATAFILE
'/controldb10/oractl9i/home/controldata/apx03.dbf' to
'/test10/oradevl/home/devldata/apx03.dbf';
SET NEWNAME FOR DATAFILE
'/controldb12/oractl9i/home/controldata/invx11.dbf' to
'/test12/oradevl/home/devldata/invx11.dbf';
SET NEWNAME FOR DATAFILE
'/controldb11/oractl9i/home/controldata/ibed04.dbf' to
'/test11/oradevl/home/devldata/ibed04.dbf';
SET NEWNAME FOR DATAFILE
'/controldb5/oractl9i/home/controldata/csid11.dbf' to
'/test05/oradevl/home/devldata/csid11.dbf';
SET NEWNAME FOR DATAFILE
'/controldb10/oractl9i/home/controldata/gld05.dbf' to
'/test10/oradevl/home/devldata/gld05.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/asox4.dbf' to
'/test07/oradevl/home/devldata/asox4.dbf';
SET NEWNAME FOR DATAFILE
'/controldb11/oractl9i/home/controldata/csix06.dbf' to
'/test11/oradevl/home/devldata/csix06.dbf';
SET NEWNAME FOR DATAFILE
'/controldb13/oractl9i/home/controldata/jax04.dbf' to
'/test13/oradevl/home/devldata/jax04.dbf';
SET NEWNAME FOR DATAFILE
'/controldb13/oractl9i/home/controldata/applsysd08.dbf' to
'/test13/oradevl/home/devldata/applsysd08.dbf';
SET NEWNAME FOR DATAFILE
'/controldb12/oractl9i/home/controldata/alrd03.dbf' to
'/test12/oradevl/home/devldata/alrd03.dbf';
SET NEWNAME FOR DATAFILE
'/controldb11/oractl9i/home/controldata/wipd07.dbf' to '/test11/oradevl/home/devldata/wipd07.dbf';
SET NEWNAME FOR DATAFILE
'/controldb12/oractl9i/home/controldata/invx12.dbf' to
'/test12/oradevl/home/devldata/invx12.dbf';
SET NEWNAME FOR DATAFILE
'/controldb5/oractl9i/home/controldata/csid12.dbf' to '/test05/oradevl/home/devldata/csid12.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/csd04.dbf' to
'/test03/oradevl/home/devldata/csd04.dbf';
SET NEWNAME FOR DATAFILE
'/controldb12/oractl9i/home/controldata/invd09.dbf' to '/test12/oradevl/home/devldata/invd09.dbf';
SET NEWNAME FOR DATAFILE
'/controldb9/oractl9i/home/controldata/xnpd04.dbf' to
'/test09/oradevl/home/devldata/xnpd04.dbf';
SET NEWNAME FOR DATAFILE
'/controldb13/oractl9i/home/controldata/asod06.dbf' to
'/test13/oradevl/home/devldata/asod06.dbf';
SET NEWNAME FOR DATAFILE
'/controldb13/oractl9i/home/controldata/ard03.dbf' to
'/test13/oradevl/home/devldata/ard03.dbf';
SET NEWNAME FOR DATAFILE
'/controldb14/oractl9i/home/controldata/ontx03.dbf' to
'/test14/oradevl/home/devldata/ontx03.dbf';
SET NEWNAME FOR DATAFILE
'/controldb12/oractl9i/home/controldata/invd10.dbf' to
'/test12/oradevl/home/devldata/invd10.dbf';
SET NEWNAME FOR DATAFILE
'/controldb9/oractl9i/home/controldata/applsysx07.dbf' to
'/test09/oradevl/home/devldata/applsysx07.dbf';
SET NEWNAME FOR DATAFILE
'/controldb14/oractl9i/home/controldata/invx13.dbf' to
'/test14/oradevl/home/devldata/invx13.dbf';
SET NEWNAME FOR DATAFILE
'/controldb14/oractl9i/home/controldata/mrpd06.dbf' to
'/test14/oradevl/home/devldata/mrpd06.dbf';
SET NEWNAME FOR DATAFILE
'/controldb14/oractl9i/home/controldata/wipd08.dbf' to
'/test14/oradevl/home/devldata/wipd08.dbf';
SET NEWNAME FOR DATAFILE '/controldb10/oractl9i/home/controldata/opid02.dbf'
to '/test10/oradevl/home/devldata/opid02.dbf';
SET NEWNAME FOR DATAFILE
'/controldb13/oractl9i/home/controldata/applsysx08.dbf' to
'/test13/oradevl/home/devldata/applsysx08.dbf';
SET NEWNAME FOR DATAFILE
'/controldb14/oractl9i/home/controldata/invx14.dbf' to
'/test14/oradevl/home/devldata/invx14.dbf';
SET NEWNAME FOR DATAFILE
'/controldb8/oractl9i/home/controldata/czx06.dbf' to
'/test08/oradevl/home/devldata/czx06.dbf';
SET NEWNAME FOR DATAFILE
'/controldb11/oractl9i/home/controldata/custom04.dbf' to
'/test11/oradevl/home/devldata/custom04.dbf';
SET NEWNAME FOR DATAFILE
'/controldb14/oractl9i/home/controldata/izu01.dbf' to
'/test14/oradevl/home/devldata/izu01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb14/oractl9i/home/controldata/izu_ind01.dbf' to
'/test14/oradevl/home/devldata/izu_ind01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb14/oractl9i/home/controldata/invx15.dbf' to
'/test14/oradevl/home/devldata/invx15.dbf';
SET NEWNAME FOR DATAFILE
'/controldb10/oractl9i/home/controldata/poad03.dbf' to
'/test10/oradevl/home/devldata/poad03.dbf';
SET NEWNAME FOR DATAFILE
'/controldb14/oractl9i/home/controldata/wipd09.dbf' to
'/test14/oradevl/home/devldata/wipd09.dbf';
SET NEWNAME FOR DATAFILE
'/controldb14/oractl9i/home/controldata/mrpd07.dbf' to
'/test14/oradevl/home/devldata/mrpd07.dbf';
SET NEWNAME FOR DATAFILE
'/controldb14/oractl9i/home/controldata/invd11.dbf' to
'/test14/oradevl/home/devldata/invd11.dbf';
SET NEWNAME FOR DATAFILE
'/controldb14/oractl9i/home/controldata/invx16.dbf' to
'/test14/oradevl/home/devldata/invx16.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/hxtx03.dbf' to '/test03/oradevl/home/devldata/hxtx03.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/gld06.dbf' to
'/test03/oradevl/home/devldata/gld06.dbf';
SET NEWNAME FOR DATAFILE
'/controldb14/oractl9i/home/controldata/wipx04.dbf' to '/test14/oradevl/home/devldata/wipx04.dbf';
SET NEWNAME FOR DATAFILE
'/controldb14/oractl9i/home/controldata/jad04.dbf' to
'/test14/oradevl/home/devldata/jad04.dbf';
SET NEWNAME FOR DATAFILE
'/controldb13/oractl9i/home/controldata/applsysx09.dbf' to '/test13/oradevl/home/devldata/applsysx09.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/csid13.dbf' to
'/test03/oradevl/home/devldata/csid13.dbf';
SET NEWNAME FOR DATAFILE
'/controldb8/oractl9i/home/controldata/apd06.dbf' to
'/test08/oradevl/home/devldata/apd06.dbf';
SET NEWNAME FOR DATAFILE
'/controldb8/oractl9i/home/controldata/pr03.dbf' to
'/test08/oradevl/home/devldata/pr03.dbf';
SET NEWNAME FOR DATAFILE
'/controldb14/oractl9i/home/controldata/invx17.dbf' to
'/test14/oradevl/home/devldata/invx17.dbf';
SET NEWNAME FOR DATAFILE
'/controldb5/oractl9i/home/controldata/enid03.dbf' to
'/test05/oradevl/home/devldata/enid03.dbf';
SET NEWNAME FOR DATAFILE
'/controldb14/oractl9i/home/controldata/hxtd04.dbf' to
'/test14/oradevl/home/devldata/hxtd04.dbf';
SET NEWNAME FOR DATAFILE
'/controldb14/oractl9i/home/controldata/invx18.dbf' to
'/test14/oradevl/home/devldata/invx18.dbf';
SET NEWNAME FOR DATAFILE
'/controldb11/oractl9i/home/controldata/csix07.dbf' to
'/test11/oradevl/home/devldata/csix07.dbf';
SET NEWNAME FOR DATAFILE
'/controldb13/oractl9i/home/controldata/applsysx10.dbf' to
'/test13/oradevl/home/devldata/applsysx10.dbf';
SET NEWNAME FOR DATAFILE
'/controldb14/oractl9i/home/controldata/asod07.dbf' to
'/test14/oradevl/home/devldata/asod07.dbf';
SET NEWNAME FOR DATAFILE
'/controldb14/oractl9i/home/controldata/apx04.dbf' to
'/test14/oradevl/home/devldata/apx04.dbf';
SET NEWNAME FOR DATAFILE '/controldb14/oractl9i/home/controldata/ard04.dbf'
to '/test14/oradevl/home/devldata/ard04.dbf';
SET NEWNAME FOR DATAFILE
'/controldb15/oractl9i/home/controldata/lmwtemp01.dbf' to
'/test15/oradevl/home/devldata/lmwtemp01.dbf';
SET NEWNAME FOR DATAFILE '/controldb14/oractl9i/home/controldata/applsysx11.dbf'
to '/test14/oradevl/home/devldata/applsysx11.dbf';
SET NEWNAME FOR DATAFILE
'/controldb14/oractl9i/home/controldata/crpd04.dbf' to
'/test14/oradevl/home/devldata/crpd04.dbf';
SET NEWNAME FOR DATAFILE
'/controldb14/oractl9i/home/controldata/crpx04.dbf' to
'/test14/oradevl/home/devldata/crpx04.dbf';
SET NEWNAME FOR DATAFILE
'/controldb14/oractl9i/home/controldata/egod02.dbf' to
'/test14/oradevl/home/devldata/egod02.dbf';
SET NEWNAME FOR DATAFILE
'/controldb14/oractl9i/home/controldata/invd12.dbf' to
'/test14/oradevl/home/devldata/invd12.dbf';
SET NEWNAME FOR DATAFILE
'/controldb14/oractl9i/home/controldata/invd13.dbf' to
'/test14/oradevl/home/devldata/invd13.dbf';
SET NEWNAME FOR DATAFILE
'/controldb14/oractl9i/home/controldata/invd14.dbf' to
'/test14/oradevl/home/devldata/invd14.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/egox02.dbf' to
'/test01/oradevl/home/devldata/egox02.dbf';
SET NEWNAME FOR DATAFILE
'/controldb14/oractl9i/home/controldata/wshd04.dbf' to
'/test14/oradevl/home/devldata/wshd04.dbf';
SET NEWNAME FOR DATAFILE
'/controldb14/oractl9i/home/controldata/ontd05.dbf' to
'/test14/oradevl/home/devldata/ontd05.dbf';
SET NEWNAME FOR DATAFILE
'/controldb14/oractl9i/home/controldata/applsysd09.dbf' to
'/test14/oradevl/home/devldata/applsysd09.dbf';
SET NEWNAME FOR DATAFILE
'/controldb14/oractl9i/home/controldata/wipd10.dbf' to '/test14/oradevl/home/devldata/wipd10.dbf';
SET NEWNAME FOR DATAFILE
'/controldb14/oractl9i/home/controldata/custom05.dbf' to
'/test14/oradevl/home/devldata/custom05.dbf';
SET NEWNAME FOR DATAFILE
'/controldb14/oractl9i/home/controldata/fiid03.dbf' to '/test14/oradevl/home/devldata/fiid03.dbf';
SET NEWNAME FOR DATAFILE
'/controldb14/oractl9i/home/controldata/applsysd10.dbf' to
'/test14/oradevl/home/devldata/applsysd10.dbf';
SET NEWNAME FOR DATAFILE
'/controldb7/oractl9i/home/controldata/xnpd02.dbf' to
'/test07/oradevl/home/devldata/xnpd02.dbf';
SET NEWNAME FOR DATAFILE
'/controldb14/oractl9i/home/controldata/poad04.dbf' to
'/test14/oradevl/home/devldata/poad04.dbf';
SET NEWNAME FOR DATAFILE
'/controldb14/oractl9i/home/controldata/bisd05.dbf' to
'/test14/oradevl/home/devldata/bisd05.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/ibed05.dbf' to
'/test01/oradevl/home/devldata/ibed05.dbf';
SET NEWNAME FOR DATAFILE
'/controldb14/oractl9i/home/controldata/applsysd11.dbf' to
'/test14/oradevl/home/devldata/applsysd11.dbf';
SET NEWNAME FOR DATAFILE
'/controldb14/oractl9i/home/controldata/applsysd12.dbf' to
'/test14/oradevl/home/devldata/applsysd12.dbf';
SET NEWNAME FOR DATAFILE '/controldb14/oractl9i/home/controldata/applsysx12.dbf'
to '/test14/oradevl/home/devldata/applsysx12.dbf';
SET NEWNAME FOR DATAFILE
'/controldb14/oractl9i/home/controldata/xnpd05.dbf' to
'/test14/oradevl/home/devldata/xnpd05.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/czd08.dbf' to
'/test03/oradevl/home/devldata/czd08.dbf';
SET NEWNAME FOR DATAFILE
'/controldb14/oractl9i/home/controldata/applsysd13.dbf' to
'/test14/oradevl/home/devldata/applsysd13.dbf';
SET
NEWNAME FOR DATAFILE '/controldb14/oractl9i/home/controldata/asod08.dbf' to
'/test14/oradevl/home/devldata/asod08.dbf';
SET NEWNAME FOR DATAFILE
'/controldb14/oractl9i/home/controldata/applsysx13.dbf' to
'/test14/oradevl/home/devldata/applsysx13.dbf';
SET NEWNAME FOR DATAFILE
'/controldb15/oractl9i/home/controldata/glx03.dbf' to
'/test15/oradevl/home/devldata/glx03.dbf';
SET NEWNAME FOR DATAFILE
'/controldb15/oractl9i/home/controldata/glx04.dbf' to
'/test15/oradevl/home/devldata/glx04.dbf';
SET NEWNAME FOR DATAFILE
'/controldb15/oractl9i/home/controldata/applsysx14.dbf' to
'/test15/oradevl/home/devldata/applsysx14.dbf';
SET NEWNAME FOR DATAFILE
'/controldb15/oractl9i/home/controldata/gld07.dbf' to '/test15/oradevl/home/devldata/gld07.dbf';
SET NEWNAME FOR DATAFILE
'/controldb15/oractl9i/home/controldata/asox05.dbf' to
'/test15/oradevl/home/devldata/asox05.dbf';
SET NEWNAME FOR DATAFILE
'/controldb15/oractl9i/home/controldata/applsysx15.dbf' to '/test15/oradevl/home/devldata/applsysx15.dbf';
SET NEWNAME FOR DATAFILE
'/controldb15/oractl9i/home/controldata/applsysx16.dbf' to
'/test15/oradevl/home/devldata/applsysx16.dbf';
SET NEWNAME FOR DATAFILE
'/controldb15/oractl9i/home/controldata/apd07.dbf' to
'/test15/oradevl/home/devldata/apd07.dbf';
SET NEWNAME FOR DATAFILE
'/controldb15/oractl9i/home/controldata/ard05.dbf' to
'/test15/oradevl/home/devldata/ard05.dbf';
SET NEWNAME FOR DATAFILE
'/controldb15/oractl9i/home/controldata/arx04.dbf' to
'/test15/oradevl/home/devldata/arx04.dbf';
SET NEWNAME FOR DATAFILE
'/controldb15/oractl9i/home/controldata/csid14.dbf' to
'/test15/oradevl/home/devldata/csid14.dbf';
SET NEWNAME FOR DATAFILE
'/controldb15/oractl9i/home/controldata/pox05.dbf' to
'/test15/oradevl/home/devldata/pox05.dbf';
SET NEWNAME FOR DATAFILE
'/controldb15/oractl9i/home/controldata/ontx04.dbf' to
'/test15/oradevl/home/devldata/ontx04.dbf';
SET NEWNAME FOR DATAFILE
'/controldb15/oractl9i/home/controldata/csix08.dbf' to
'/test15/oradevl/home/devldata/csix08.dbf';
SET NEWNAME FOR DATAFILE
'/controldb15/oractl9i/home/controldata/applsysd14.dbf' to
'/test15/oradevl/home/devldata/applsysd14.dbf';
SET NEWNAME FOR DATAFILE '/controldb15/oractl9i/home/controldata/applsysd15.dbf'
to '/test15/oradevl/home/devldata/applsysd15.dbf';
SET NEWNAME FOR DATAFILE
'/controldb15/oractl9i/home/controldata/applsysd16.dbf' to
'/test15/oradevl/home/devldata/applsysd16.dbf';
SET NEWNAME FOR DATAFILE
'/controldb15/oractl9i/home/controldata/applsysd17.dbf' to
'/test15/oradevl/home/devldata/applsysd17.dbf';
SET NEWNAME FOR DATAFILE
'/controldb15/oractl9i/home/controldata/applsysd18.dbf' to
'/test15/oradevl/home/devldata/applsysd18.dbf';
SET NEWNAME FOR DATAFILE
'/controldb15/oractl9i/home/controldata/custom06.dbf' to
'/test15/oradevl/home/devldata/custom06.dbf';
SET NEWNAME FOR DATAFILE
'/controldb15/oractl9i/home/controldata/opid03.dbf' to
'/test15/oradevl/home/devldata/opid03.dbf';
SET NEWNAME FOR DATAFILE
'/controldb15/oractl9i/home/controldata/ontd06.dbf' to
'/test15/oradevl/home/devldata/ontd06.dbf';
SET NEWNAME FOR DATAFILE
'/controldb4/oractl9i/home/controldata/invd15.dbf' to '/test04/oradevl/home/devldata/invd15.dbf';
SET NEWNAME FOR DATAFILE
'/controldb15/oractl9i/home/controldata/apx05.dbf' to
'/test15/oradevl/home/devldata/apx05.dbf';
SET NEWNAME FOR DATAFILE
'/controldb15/oractl9i/home/controldata/applsysx17.dbf' to '/test15/oradevl/home/devldata/applsysx17.dbf';
SET NEWNAME FOR DATAFILE
'/controldb15/oractl9i/home/controldata/czx07.dbf' to
'/test15/oradevl/home/devldata/czx07.dbf';
SET NEWNAME FOR DATAFILE
'/controldb15/oractl9i/home/controldata/applsysx18.dbf' to
'/test15/oradevl/home/devldata/applsysx18.dbf';
SET NEWNAME FOR DATAFILE
'/controldb15/oractl9i/home/controldata/pod04.dbf' to
'/test15/oradevl/home/devldata/pod04.dbf';
SET NEWNAME FOR DATAFILE
'/controldb15/oractl9i/home/controldata/jad05.dbf' to
'/test15/oradevl/home/devldata/jad05.dbf';
SET NEWNAME FOR DATAFILE
'/controldb15/oractl9i/home/controldata/asod09.dbf' to
'/test15/oradevl/home/devldata/asod09.dbf';
SET NEWNAME FOR DATAFILE
'/controldb15/oractl9i/home/controldata/applsysx19.dbf' to
'/test15/oradevl/home/devldata/applsysx19.dbf';
SET NEWNAME FOR DATAFILE
'/controldb15/oractl9i/home/controldata/applsysx20.dbf' to
'/test15/oradevl/home/devldata/applsysx20.dbf';
SET NEWNAME FOR DATAFILE '/controldb16/oractl9i/home/controldata/wipx05.dbf'
to '/test16/oradevl/home/devldata/wipx05.dbf';
SET NEWNAME FOR DATAFILE
'/controldb16/oractl9i/home/controldata/applsysd19.dbf' to
'/test16/oradevl/home/devldata/applsysd19.dbf';
SET NEWNAME FOR DATAFILE
'/controldb16/oractl9i/home/controldata/applsysd20.dbf' to
'/test16/oradevl/home/devldata/applsysd20.dbf';
SET NEWNAME FOR DATAFILE
'/controldb16/oractl9i/home/controldata/applsysd21.dbf' to
'/test16/oradevl/home/devldata/applsysd21.dbf';
SET NEWNAME FOR DATAFILE
'/controldb16/oractl9i/home/controldata/qad04.dbf' to
'/test16/oradevl/home/devldata/qad04.dbf';
SET NEWNAME FOR DATAFILE
'/controldb16/oractl9i/home/controldata/custom07.dbf' to
'/test16/oradevl/home/devldata/custom07.dbf';
SET NEWNAME FOR DATAFILE
'/controldb16/oractl9i/home/controldata/xnpd07.dbf' to
'/test16/oradevl/home/devldata/xnpd07.dbf';
SET NEWNAME FOR DATAFILE
'/controldb16/oractl9i/home/controldata/asod10.dbf' to
'/test16/oradevl/home/devldata/asod10.dbf';
SET NEWNAME FOR DATAFILE
'/controldb16/oractl9i/home/controldata/bomd09.dbf' to
'/test16/oradevl/home/devldata/bomd09.dbf';
SET NEWNAME FOR DATAFILE
'/controldb16/oractl9i/home/controldata/applsysx21.dbf' to '/test16/oradevl/home/devldata/applsysx21.dbf';
SET NEWNAME FOR DATAFILE
'/controldb16/oractl9i/home/controldata/apx06.dbf' to
'/test16/oradevl/home/devldata/apx06.dbf';
SET NEWNAME FOR DATAFILE
'/controldb16/oractl9i/home/controldata/qax04.dbf' to '/test16/oradevl/home/devldata/qax04.dbf';
SET NEWNAME FOR DATAFILE
'/controldb16/oractl9i/home/controldata/invx19.dbf' to
'/test16/oradevl/home/devldata/invx19.dbf';
SET NEWNAME FOR DATAFILE
'/controldb16/oractl9i/home/controldata/poad05.dbf' to '/test16/oradevl/home/devldata/poad05.dbf';
SET NEWNAME FOR DATAFILE
'/controldb16/oractl9i/home/controldata/ontd07.dbf' to
'/test16/oradevl/home/devldata/ontd07.dbf';
SET NEWNAME FOR DATAFILE
'/controldb16/oractl9i/home/controldata/bomd10.dbf' to
'/test16/oradevl/home/devldata/bomd10.dbf';
SET NEWNAME FOR DATAFILE
'/controldb16/oractl9i/home/controldata/bomd11.dbf' to
'/test16/oradevl/home/devldata/bomd11.dbf';
SET NEWNAME FOR DATAFILE
'/controldb16/oractl9i/home/controldata/applsysd22.dbf' to
'/test16/oradevl/home/devldata/applsysd22.dbf';
SET NEWNAME FOR DATAFILE
'/controldb16/oractl9i/home/controldata/asod11.dbf' to
'/test16/oradevl/home/devldata/asod11.dbf';
SET NEWNAME FOR DATAFILE
'/controldb16/oractl9i/home/controldata/alrx02.dbf' to
'/test16/oradevl/home/devldata/alrx02.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/csd05.dbf' to
'/test01/oradevl/home/devldata/csd05.dbf';
SET NEWNAME FOR DATAFILE
'/controldb16/oractl9i/home/controldata/applsysx22.dbf' to
'/test16/oradevl/home/devldata/applsysx22.dbf';
SET NEWNAME FOR DATAFILE
'/controldb16/oractl9i/home/controldata/wipx06.dbf' to
'/test16/oradevl/home/devldata/wipx06.dbf';
SET NEWNAME FOR DATAFILE '/controldb16/oractl9i/home/controldata/czd09.dbf'
to '/test16/oradevl/home/devldata/czd09.dbf';
SET NEWNAME FOR DATAFILE
'/controldb16/oractl9i/home/controldata/perfstat02.dbf' to
'/test16/oradevl/home/devldata/perfstat02.dbf';
SET NEWNAME FOR DATAFILE
'/controldb16/oractl9i/home/controldata/xdod02.dbf' to
'/test16/oradevl/home/devldata/xdod02.dbf';
SET NEWNAME FOR DATAFILE
'/controldb16/oractl9i/home/controldata/bomd12.dbf' to
'/test16/oradevl/home/devldata/bomd12.dbf';
SET NEWNAME FOR DATAFILE
'/controldb16/oractl9i/home/controldata/bomd13.dbf' to
'/test16/oradevl/home/devldata/bomd13.dbf';
SET NEWNAME FOR DATAFILE
'/controldb16/oractl9i/home/controldata/bomd14.dbf' to
'/test16/oradevl/home/devldata/bomd14.dbf';
SET
NEWNAME FOR DATAFILE '/controldb16/oractl9i/home/controldata/bomd15.dbf' to
'/test16/oradevl/home/devldata/bomd15.dbf';
SET NEWNAME FOR DATAFILE
'/controldb16/oractl9i/home/controldata/custom08.dbf' to
'/test16/oradevl/home/devldata/custom08.dbf';
SET NEWNAME FOR DATAFILE
'/controldb16/oractl9i/home/controldata/jad06.dbf' to
'/test16/oradevl/home/devldata/jad06.dbf';
SET NEWNAME FOR DATAFILE
'/controldb16/oractl9i/home/controldata/jad07.dbf' to
'/test16/oradevl/home/devldata/jad07.dbf';
SET NEWNAME FOR DATAFILE
'/controldb16/oractl9i/home/controldata/asod12.dbf' to
'/test16/oradevl/home/devldata/asod12.dbf';
SET NEWNAME FOR DATAFILE
'/controldb16/oractl9i/home/controldata/asod13.dbf' to
'/test16/oradevl/home/devldata/asod13.dbf';
SET NEWNAME FOR DATAFILE
'/controldb16/oractl9i/home/controldata/bomd16.dbf' to
'/test16/oradevl/home/devldata/bomd16.dbf';
SET NEWNAME FOR DATAFILE
'/controldb12/oractl9i/home/controldata/applsysd23.dbf' to '/test12/oradevl/home/devldata/applsysd23.dbf';
SET NEWNAME FOR DATAFILE
'/controldb17/oractl9i/home/controldata/undo06.dbf' to
'/test17/oradevl/home/devldata/undo06.dbf';
SET NEWNAME FOR DATAFILE
'/controldb17/oractl9i/home/controldata/perfstat03.dbf' to
'/test17/oradevl/home/devldata/perfstat03.dbf';
SET NEWNAME FOR DATAFILE
'/controldb17/oractl9i/home/controldata/applsysd24.dbf' to
'/test17/oradevl/home/devldata/applsysd24.dbf';
SET NEWNAME FOR DATAFILE
'/controldb17/oractl9i/home/controldata/invx20.dbf' to
'/test17/oradevl/home/devldata/invx20.dbf';
SET NEWNAME FOR DATAFILE
'/controldb17/oractl9i/home/controldata/xnpx03.dbf' to
'/test17/oradevl/home/devldata/xnpx03.dbf';
SET NEWNAME FOR DATAFILE
'/controldb17/oractl9i/home/controldata/csid15.dbf' to
'/test17/oradevl/home/devldata/csid15.dbf';
SET NEWNAME FOR DATAFILE
'/controldb17/oractl9i/home/controldata/gld08.dbf' to
'/test17/oradevl/home/devldata/gld08.dbf';
SET NEWNAME FOR DATAFILE
'/controldb17/oractl9i/home/controldata/apd08.dbf' to
'/test17/oradevl/home/devldata/apd08.dbf';
SET NEWNAME FOR DATAFILE
'/controldb17/oractl9i/home/controldata/pax02.dbf' to
'/test17/oradevl/home/devldata/pax02.dbf';
SET NEWNAME FOR DATAFILE '/controldb17/oractl9i/home/controldata/czd10.dbf'
to '/test17/oradevl/home/devldata/czd10.dbf';
SET NEWNAME FOR DATAFILE
'/controldb17/oractl9i/home/controldata/ajinnid02.dbf' to
'/test17/oradevl/home/devldata/ajinnid02.dbf';
SET NEWNAME FOR DATAFILE '/controldb17/oractl9i/home/controldata/abmd02.dbf'
to '/test17/oradevl/home/devldata/abmd02.dbf';
SET NEWNAME FOR DATAFILE
'/controldb17/oractl9i/home/controldata/abmx02.dbf' to
'/test17/oradevl/home/devldata/abmx02.dbf';
SET NEWNAME FOR DATAFILE
'/controldb17/oractl9i/home/controldata/pr04.dbf' to
'/test17/oradevl/home/devldata/pr04.dbf';
SET NEWNAME FOR DATAFILE
'/controldb17/oractl9i/home/controldata/bomx07.dbf' to
'/test17/oradevl/home/devldata/bomx07.dbf';
SET NEWNAME FOR DATAFILE
'/controldb17/oractl9i/home/controldata/wipx07.dbf' to
'/test17/oradevl/home/devldata/wipx07.dbf';
SET NEWNAME FOR DATAFILE
'/controldb17/oractl9i/home/controldata/invx21.dbf' to
'/test17/oradevl/home/devldata/invx21.dbf';
SET NEWNAME FOR DATAFILE
'/controldb1/oractl9i/home/controldata/custom09.dbf' to
'/test01/oradevl/home/devldata/custom09.dbf';
SET NEWNAME FOR DATAFILE
'/controldb17/oractl9i/home/controldata/ibed06.dbf' to
'/test17/oradevl/home/devldata/ibed06.dbf';
SET
NEWNAME FOR DATAFILE '/controldb17/oractl9i/home/controldata/ibex04.dbf' to
'/test17/oradevl/home/devldata/ibex04.dbf';
SET NEWNAME FOR DATAFILE
'/controldb17/oractl9i/home/controldata/applsysd25.dbf' to
'/test17/oradevl/home/devldata/applsysd25.dbf';
SET NEWNAME FOR DATAFILE
'/controldb17/oractl9i/home/controldata/custom10.dbf' to
'/test17/oradevl/home/devldata/custom10.dbf';
SET NEWNAME FOR DATAFILE
'/controldb17/oractl9i/home/controldata/custom11.dbf' to '/test17/oradevl/home/devldata/custom11.dbf';
SET NEWNAME FOR DATAFILE
'/controldb17/oractl9i/home/controldata/czx08.dbf' to
'/test17/oradevl/home/devldata/czx08.dbf';
SET NEWNAME FOR DATAFILE
'/controldb17/oractl9i/home/controldata/mrpd08.dbf' to '/test17/oradevl/home/devldata/mrpd08.dbf';
SET NEWNAME FOR DATAFILE
'/controldb18/oractl9i/home/controldata/wipx08.dbf' to
'/test18/oradevl/home/devldata/wipx08.dbf';
SET NEWNAME FOR DATAFILE
'/controldb18/oractl9i/home/controldata/wipx09.dbf' to '/test18/oradevl/home/devldata/wipx09.dbf';
SET NEWNAME FOR DATAFILE
'/controldb16/oractl9i/home/controldata/asod14.dbf' to
'/test16/oradevl/home/devldata/asod14.dbf';
SET NEWNAME FOR DATAFILE
'/controldb16/oractl9i/home/controldata/asod15.dbf' to
'/test16/oradevl/home/devldata/asod15.dbf';
SET NEWNAME FOR DATAFILE
'/controldb18/oractl9i/home/controldata/jax05.dbf' to
'/test18/oradevl/home/devldata/jax05.dbf';
SET NEWNAME FOR DATAFILE
'/controldb6/oractl9i/home/controldata/system10.dbf' to
'/test06/oradevl/home/devldata/system10.dbf';
SET NEWNAME FOR DATAFILE
'/controldb12/oractl9i/home/controldata/sysauxd01.dbf' to
'/test12/oradevl/home/devldata/sysauxd01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb17/oractl9i/home/controldata/czx09.dbf' to
'/test17/oradevl/home/devldata/czx09.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/tools01.dbf' to
'/test03/oradevl/home/devldata/tools01.dbf';
SET NEWNAME FOR DATAFILE
'/controldb17/oractl9i/home/controldata/bomx08.dbf' to
'/test17/oradevl/home/devldata/bomx08.dbf';
SET NEWNAME FOR DATAFILE
'/controldb3/oractl9i/home/controldata/mrpx06.dbf' to
'/test03/oradevl/home/devldata/mrpx06.dbf';
SET NEWNAME FOR DATAFILE '/controldb17/oractl9i/home/controldata/custom12.dbf'
to '/test17/oradevl/home/devldata/custom12.dbf';
SET NEWNAME FOR DATAFILE
'/controldb15/oractl9i/home/controldata/ontd08.dbf' to
'/test15/oradevl/home/devldata/ontd08.dbf';
SET NEWNAME FOR DATAFILE '/controldb17/oractl9i/home/controldata/bomx09.dbf'
to '/test17/oradevl/home/devldata/bomx09.dbf';
SET NEWNAME FOR DATAFILE
'/controldb17/oractl9i/home/controldata/applsysd26.dbf' to
'/test17/oradevl/home/devldata/applsysd26.dbf';
RESTORE Database;
Switch datafile all;
}
Take backup of controlfile on
Production [203.90.124.197]:
SQL> alter database backup controlfile
to trace;
Change the path of datafiles
to point to New Location:
Edit the backup controlfile and and change
the paths accordingly.
Make sure to make the changes of first two
lines to:
" CREATE CONTROLFILE SET DATABASE
"DEVL" RESETLOGS ARCHIVELOG
--
SET STANDBY TO MAXIMIZE PERFORMANCE "
And also make the changes in the
path for the datafile and Redo logs to '/test01/oradevl/home/devldata/',
/test10/oradevl/home/devldata/’
Transfered the backup control
file to DEVLserver from Production system:
$scp clone_db_22_Jan_2008.sql
oractl9i@phys-evistaa1:/test01/oradevl/home
Enabled the following entry
in the init parameter file on DEVLserver:
log_archive_start = true # if you want automatic archiving
Shutdown the DEVL instance
that is running on the DEVLserver [172.16.0.70]
[Nothing to do on the Production server]
$ sqlplus '/as sysdba'
SQL>shutdown immediate
SQL> exit
Renaming the Existing
controlfiles on DEVLserver:
We need to rename the existing Control
files as we had already restored the control files earlier.
$ cd /test01/oradevl/home/devldata/,
/test10/oradevl/home/devldata/, /test12/oradevl/home/devldata/
$ ls cnt*
cntrl01.dbf
cntrl02.dbf cntrl03.dbf
$ mv cntrl01.dbf cntrl01.dbf.old
$ mv cntrl02.dbf cntrl02.dbf.old
$ mv cntrl03.dbf cntrl03.dbf.old
Re-Creating the Control File
and Setting the SID to 'DEVL' on DEV10gserver:
$ export ORACLE_SID=DEVL
$ cd /home/oracle/
$ sqlplus '/as sysdba'
SQL>startup nomount;
SQL>
@ clone_db_22_Jan_2008.sql
Recovering the Database:
Check and ship the archives from the
Production server to DEVLserver
SQL> recover database UNTIL CANCEL using
backup controlfile;
Opening the Database with
Resetlogs:
SQL> alter database open resetlogs;
SQL> shutdown immediate
Disabled the following entry
in the init parameter file on DEVserver:
#log_archive_start = true # if you want automatic archiving
Disabling the Archiving on
DEVserver:
SQL> startup mount;
SQL> alter database noarchivelog;
SQL> alter database open;
Temp file Added on
DEVLserver:
SQL> alter tablespace TEMP add tempfile
'/test04/oradevl/home/devldata/ temp01.dbf' size 1000m;
SQL>exit
Starting Listener on
DEVLserver:
$ lsnrctl start DEV
