Re: Oracle Database Replication

Tony Pich <apich_at_viviance.com> schreef in berichtnieuws 8e3qos$nl2$1_at_diana.bcn.ttd.net...
> Hi:
>
> I have an Oracle 8.0.5 running and with several tables created. Now, I
> have installed Oracle 8.0.5 on a different machine and I'd like to know
 how
> can migrate the old database to the new one so they are exactly the same.
>
> Thanks a milion,
>
> --
>
> Tony Pich
>
>
>

1 in svrmgr
alter database backup controlfile to trace. This will produce a trace file in the user_dump_dest directory. 2 shut the source database
3 backup the source database
4 copy all files to the new database (including init.ora and controlfiles) 5 copy the trace file when necessary edit it to change file names. 6 startup svrmgr and run the trace file as a sql script. 7 shut the target database and make a backup

This should be all...

Hth,

Sybrand Bakker, Oracle DBA Received on Tue Apr 25 2000 - 00:00:00 CDT