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

Hi Bola,

Comprehensible? No, not without some study, but thanks -- I will study it!

Many thanks again !!!!!

  Cheers,
    Winton

In article <906124955.9974.0.nnrp-06.c2dec0b7_at_news.demon.co.uk>, "Bola Ogunlana" <bolao_at_incads.demon.co.uk> wrote:

> 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 Wed Sep 23 1998 - 20:16:48 CDT