Oracle 7.3.4 - initscript and copying an existing db

[tt523600]

Hi guys!!

sorry to trouble you guys with this beginners question, haven't worked with oracle 7.3.4 for a while. Is there anyone who has a good script for creating a new database in oracle 7.3.4.

any tips for moving an existing database into a completely new server. What considerations is there to think about, and isn't there any tools one can use to do this?

appreciate any help.

 

[sem]

You may use export-import to move data.

 

[alexhu]

This may help (if you're using UNIX, for NT change the pathnames)

startup nomount pfile=/u01/admin/DATABASE/pfile/initDATABASE.ora
create database DATABASE
controlfile reuse
logfile group 1 ('/u07/oradata/DATABASE/log1DATABASE.ora',
'/u08/oradata/DATABASE/log1DATABASE.ora') size 10M reuse,
group 2 ('/u08/oradata/DATABASE/log2DATABASE.ora',
'/u09/oradata/DATABASE/log2DATABASE.ora') size 10M reuse,
group 3 ('/u09/oradata/DATABASE/log3DATABASE.ora',
'/u07/oradata/DATABASE/log3DATABASE.ora') size 10M reuse
datafile '/u02/oradata/DATABASE/sysDATABASE_01.ora' size 200M ;



create rollback segment rb_temp;

create tablespace DATABASE
datafile '/u04/oradata/DATABASE/DATABASE_01.dbf' size 300M;
alter tablespace DATABASE add datafile '/u05/oradata/DATABASE/DATABASE_02.dbf' size 300M;
alter tablespace DATABASE add datafile '/u06/oradata/DATABASE/DATABASE_03.dbf' size 300M;

alter tablespace DATABASE add datafile '/u04/oradata/DATABASE/DATABASE_04.dbf' size 500M;
alter tablespace DATABASE add datafile '/u05/oradata/DATABASE/DATABASE_05.dbf' size 500M;
alter tablespace DATABASE add datafile '/u06/oradata/DATABASE/DATABASE_06.dbf' size 500M;

alter tablespace DATABASE add datafile '/u04/oradata/DATABASE/DATABASE_07.dbf' size 500M;
alter tablespace DATABASE add datafile '/u05/oradata/DATABASE/DATABASE_08.dbf' size 500M;
alter tablespace DATABASE add datafile '/u06/oradata/DATABASE/DATABASE_09.dbf' size 500M;

create tablespace rbs datafile '/u03/oradata/DATABASE/rbs_01.dbf' size 1024M;

create tablespace temp datafile '/u03/oradata/DATABASE/temp_01.dbf' size 400M;

create tablespace tms datafile '/u08/oradata/DATABASE/tms_01.dbf' size 200M;

create tablespace tools datafile '/u03/oradata/DATABASE/tools_01.dbf' size 50M;

create tablespace users datafile '/u03/oradata/DATABASE/users_01.dbf' size 50M;


alter rollback segment rb_temp online;
alter user system temporary tablespace temp;
alter user system default tablespace users;



create public rollback segment rbs01 storage(initial 1M next 1M)
tablespace rbs;

create public rollback segment rbs02 storage(initial 1M next 1M)
tablespace rbs;

create public rollback segment rbs03 storage(initial 1M next 1M)
tablespace rbs;

create public rollback segment rbs04 storage(initial 1M next 1M)
tablespace rbs;

create public rollback segment rbs05 storage(initial 1M next 1M)
tablespace rbs;


To move the database to another server as long as its UNIX and has identical disk layout, the easiest way is to use tape and then recreate the controlfile

if its a differant OS then export / import is the only way

I've never done it on NT so can't help there

Alex