Re: Manually moving an O7 system between Solaris mc/s.

I may need to recreate your control file on your target database. I don't think they are portable across servers. To do this you can, on your source database:

run an "alter database backup controlfile to trace;" command

Find the trace file that is dumped into your user_dump_destination

Edit the "create controlfile" statement in the dump file to say resetlogs, and

run it on your copy database in startup nomount mode.

comprehensible?

Winton Davies wrote in message ...
>Hi,
>
> Anyone out there have experience of simply moving an oracle system
>between two servers simply by tarring the appropriate directories ? I
>believe
>I have gotten everything across ok.
>
>My one problem is that when I do dbstart: I get an error message saying the
>database is still locked by the other machine.... The file is in oradata,
>called control01.dat.
>
>Is there any magic command that says "reset the control files ?" This
>isn't a production system, so I don't care about rollbacks or commits etc.
>We have some data in there, and we've moved our workgroup server to
>another machine.
>
> Cheers,
> Winton
>
>p.s. Please cc. me with any replies (much appreciatted).
Received on Thu Sep 17 1998 - 11:45:10 CDT