copying DB1 (production) to DB2 (testing) Data Pump vs Import/Export
Date: Wed, 17 Sep 2008 23:18:58 -0700 (PDT)
Message-ID: <5cfd849f-c941-489b-b6db-9b88c6aeee61@l42g2000hsc.googlegroups.com>
set ORACLE_SID=DB2
shutdown immediate;
exit
delete all files from folder oradata\DB2\
set ORACLE_SID=DB1
alter database backup controlfile to trace;
shutdown immediate;
exit
copy all files from folder oradata\DB1 to oradata\DB2 in oradata\DB2 directory delete all control files control01.ctl control02.ctl control03.ctl
set ORACLE_SID=DB1
startup
exit
in admin\DB1\udump dir look for the newest file with .trc extension
remove everything before 'startup nomount'
in this line 'CREATE CONTROLFILE REUSE DATABASE "DB1" NORESETLOGS
NOARCHIVELOG'
change 'REUSE' to 'SET' and 'NORESETLOGS' to 'RESETLOGS'
in line 'ALTER DATABASE OPEN' add 'RESETLOGS'
change 'DB1' to 'DB2'
save file to .sql
set ORACLE_SID=DB2
@DB2.sql
That is the way i did it for long time (might be helpful). Now i want
something more advanced.
How to do exactly same thing with Data Pump? Any hints? Of course path
to tablespaces are different.
--- Norbert UrzędowskiReceived on Thu Sep 18 2008 - 01:18:58 CDT