RE: recreating a create database file

From: Stephen Lee <Stephen.Lee_at_DTAG.Com>
Date: Tue, 17 Jun 2003 08:35:41 -0700
Message-ID: <F001.005B2FD6.20030617080957@fatcity.com>

Well ... here is some generic stuff for you to edit. This is from 8.1.x, but I think it will still (with an edit or two) get you a running database in 9.2.x

connect / as sysdba
startup nomount

create database "CRCT2"

    maxinstances 8
    maxlogfiles 32
    character set "US7ASCII"
    datafile
   '/u09/oradata/CRCT2/system_01.dbf' size 200M     logfile

       GROUP 1
   ('/z01/oradata/CRCT2/redo_01a.log'
   ,'/z02/oradata/CRCT2/redo_01b.log') size 50M     , GROUP 2
   ('/z01/oradata/CRCT2/redo_02a.log'
   ,'/z02/oradata/CRCT2/redo_02b.log') size 50M     , GROUP 3
   ('/z01/oradata/CRCT2/redo_03a.log'
   ,'/z02/oradata/CRCT2/redo_03b.log') size 50M     , GROUP 4
   ('/z01/oradata/CRCT2/redo_04a.log'
   ,'/z02/oradata/CRCT2/redo_04b.log') size 50M ;

connect / as sysdba
REM * add or subtract to the following as desired

@?/rdbms/admin/catalog.sql
@?/rdbms/admin/catproc.sql
@?/rdbms/admin/catexp.sql
@?/rdbms/admin/catblock.sql
@?/rdbms/admin/catparr.sql
@?/rdbms/admin/catrep.sql
@?/rdbms/admin/utlrp.sql

REM * Create additional rollback segment in SYSTEM before creating tablespace.
REM *
connect / as sysdba

REM * Need a non-system rollback segment for a while. create rollback segment r0 tablespace system storage (initial 16k next 16k minextents 2 maxextents 20); alter rollback segment r0 online;

REM * Create a tablespace for rollback segments. create tablespace RBS datafile

'/u09/oradata/CRCT2/rbs_01.dbf' size 1000M default storage (

   initial      1M
   next      1M
   pctincrease    0
   minextents     20
   maxextents       unlimited

);

REM * Create a tablespace for temporary segments. create tablespace TEMP datafile

'/u09/oradata/CRCT2/temp_01.dbf' size 1000M default storage (

   initial     1M
   next        1M
        pctincrease  0

minextents 1
maxextents unlimited
)
TEMPORARY; REM * Create a tablespace for database tools. create tablespace TOOLS datafile

'/u09/oradata/CRCT2/tools_01.dbf' size 200M default storage (

   initial      16k
   next         16k
        pctincrease  0

minextents 1
maxextents unlimited
);

REM * Create a tablespace for miscellaneous database user activity. create tablespace USERS datafile

'/u09/oradata/CRCT2/user_01.dbf' size 100M default storage (

   initial      16k
   next         16k
        pctincrease  0

minextents 1
maxextents unlimited
);

REM * Create rollback segments.
create rollback segment r01 tablespace rbs storage (

         initial 1M
   next 1M
   minextents 20
   maxextents unlimited
   optimal 20m
);

create rollback segment r02 tablespace rbs storage (

         initial 1M
   next 1M
   minextents 20
   maxextents unlimited
   optimal 20m
);

create rollback segment r03 tablespace rbs storage (

         initial 1M
   next 1M
   minextents 20
   maxextents unlimited
   optimal 20m
);

create rollback segment r04 tablespace rbs storage (

         initial 1M
   next 1M
   minextents 20
   maxextents unlimited
   optimal 20m
);

alter rollback segment r01 online;
alter rollback segment r02 online;
alter rollback segment r03 online;
alter rollback segment r04 online;

REM * Since we've created and brought online more rollback segments, REM * we no longer need the rollback segment in the SYSTEM tablespace. alter rollback segment r0 offline;
drop rollback segment r0;

alter user sys identified by yeehaa;
alter user system identified by yeehaa;

REM

REM Run the following from SQLPLUS
REM connect system/yeehaa
REM @/oracle/app/oracle/product/8.1.7/sqlplus/admin/pupbld.sql REM alter user sys temporary tablespace temp; REM alter user system default tablespace tools temporary tablespace temp; REM alter user dbsnmp default tablespace tools temporary tablespace temp; REM alter user outln default tablespace tools temporary tablespace temp; REM grant sysoper,sysdba to system;
REM grant sysoper,sysdba to sys;
REM alter user dbsnmp identified by yeehaa; REM alter user outln identified by yeehaa; REM

> -----Original Message-----
> From: Ruth Gramolini [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, June 17, 2003 9:09 AM
> To: Multiple recipients of list ORACLE-L
> Subject: recreating a create database file
> 
> 
> Good morning all,
> 
> Somehow all of my scripts to create the databases on my 9i 
> sandbox have
> disappeared.  Does anyone have a script or trick or something 
> to recreate
> these files?  I could recreate them manually but I am 
> somewhat of a time
> crunch.
> 
> Thanks in advance,
> Ruth
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Ruth Gramolini
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
> San Diego, California        -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Tue Jun 17 2003 - 10:35:41 CDT