Hi Eileen,
This is how I'd do it:
- Create all necessary directories on the NT server (bdump, udump,
pfile, tablespace directories etc.).
- Create your instance on NT using oradim (type "oradim" at a DOS
prompt if you don't know what command line options to give it).
- Set up Net8 on your server for the new instance (i.e. edit the
LISTENER.ORA, reload and test), and update your client service
resolution method too (e.g. Oracle Names or TNSNAMES.ORA).
- "set ORACLE_SID=<newsid>" at your DOS prompt.
- Go into svrmgrl, connect internal and then issue a "create
database..." statement to create an empty database. See the SQL
Reference guide if you're not familiar with the syntax. Then run the
necessary scripts to create your data dictionary objects (catalog.sql,
catproc.sql and any others needed for the products you've installed).
- Precreate all tablespaces on the new database using the "create
tablespace..." statement (with the same tablespace names as on your
existing development database - the file paths will of course be
different, which is okay).
- Create and bring online rollback segments on the new database.
- Perform a full export of your development database, ensuring that
you use the "consistent=y" option. Remember to specify a log file, and
check that log when the export is complete.
- FTP the export dump file to your NT server.
- Perform a full import on your NT server using the export FTPed in
step 8. You will need to use a DBA-privileged user to do this. Again,
specify a log file and check this log carefully when the import is
complete.
- If I haven't forgotten anything, you should then be finished. I
would recommend that you do some checks before handing the database to
your users. Basic checks would compare object counts, privilege
counts, constraint counts and user counts between your old and new
databases.
I'd be happy to help if you hit any problems. Just drop me an email.
Dave.
mailto:dave_at_oracle-consultant.co.uk
http://www.oracle-consultant.co.uk
P.S. I guess you're probably aware that 7.3.4 is no longer fully
supported by Oracle.
"Eileen Ong" <eileen_ong_at_abacus.com.sg> wrote in message news:<9kd32h$osd$1_at_newton.pacific.net.sg>...
> Hi,
>
> I need to duplicate the development database from the Unix platform (running
> Oracle 7.3.4.5.0) to the Win NT server (running Oracle 8.1.7). What are the
> steps that I have take, assuming that I cannot shutdown the development
> database?
>
> Thank you in advance.
>
> Cheers
> Eileen
Received on Fri Aug 03 2001 - 07:39:56 CDT
