Re: Need Help Moving 7.3.3 DBs to 7.3.4

Assuming you don't change the file locations: 1 issue alter database backup controlfile to trace for each of your databases
2 identify the trace files (end up in user_dump_dest) 3 save them to a different name keeping them apart 4 shut down the old database
5 make a backup of it
6 either configure your lmhosts file to reach the server 1000 miles away or take that backup to the other location
7 for each of the databases
  copy the files to the correct locations   create a service with oradim73,using oradim in a dos box , so oradim73 -new -sid etc
  start the service
  run the create controlfile script located in the save trace file   run %RDBMS73%\admin\cat7304.sql in svrmgr23.exe 8 This should be ALL

If you do want to change file locations, edit the trace file/create controlfile script accordingly

Hth,

--
Sybrand Bakker, Oracle DBA
<rock_cogar_at_my-deja.com> wrote in message news:83bltt$ht5$1_at_nnrp1.deja.com...
> Hi,
>
> I need to put a procedure together to move 5 Oracle 7.3.3 databases on
> one NT Box to another single NT box that has Oracle 7.3.4 installed
> (empty) on it.
>
> This is further complicated by the two NT boxes being 1000 miles apart.
> Also, I and the customer realize that having so many Oracle instances on
> an NT box with 160 MB of installed RAM is not recommended.
>
> QUESTION: Is there a white paper out there or any other procedure for
> doing this kind of task ?
>
> Thanks,
> Rock Cogar.
> URS Radian.
> Rock_cogar_at_my-deja.com
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Thu Dec 16 1999 - 16:39:43 CST