Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Migrating Oracle Financial Data between instances
Forget SQL*Loader, import would work but is very slow...
You could try this...
First create the services for the new instance.
Here it is..
1.) From your source database issue the command 'alter database backup
controlfile to trace' , this will create a .trc file which you will
modify and rename to a .sql file. You will use this file for two
things: first, to create a copy script to copy all the files listed in
it to a new location where you would like them to be for your second
instance. Secondly, you will then use it to create your control file
for your second instance.. remove any comments, modify the locations
of all the files and change the following
<create control file reuse database "dbname" noresetlogs> to
<create control file set database "newdbname" resetlogs>.
and make sure the last line reads alter database open resetlogs
3.) shutdown the source database
2.) set ORACLE_SID to the new value for your second instance.
3.) create new initsid.ora for your second instance(I copy them from the other instance), modify them to reflect the new sid and file locations of the second instance.
4.) run the script that will copy all your data files
5.) svrmgr23
6.) run your create control file .sql file and BE SURE all references to files are actually pointing the NEW locations and not those belonging to the other instance.
Don't forget to have complete backups before doing all this and you will have to add this instance to any sqlnet related .ora files, etc...
Good Luck
Robert Prendin
Reid Lai <reidlai_at_hk.super.net> wrote:
>Could you use database link or SQL*Loader to do so?
>
>Howard Shidlowsky wrote:
>
>> I've been asked to determine how to migrate data from one instance of
>> Oracle
>> Financial Applications on NT 4.0 to a second instance on the same
>> machine.
>> Most of us will think of Export and Import; however, Oracle embeds
>> information
>> concerning the instance in the Oracle Applications tables. Importing
>> this
>> information into a second instance reeks havoc with the instance (which
>> is the reason Oracle says not to try it).
>>
>> If anyone has experience with this, please reply by email.
>> I'll post a summary.
>>
>> Thanks folks.
>>
>> Howard
>> hows_at_shaw.wave.ca
>
>
>
>
#**************************************************** # RP Data Solutions Inc. # Specializing in ORACLE DBA Support Services # We offer 24HR remote DBA support!!! #****************************************************Received on Wed Sep 16 1998 - 21:15:19 CDT