手工重新创建8i数据库

手工重新创建8i数据库 
作者:llmmysun

1.查看原来的数据库文件,保存其位置和大小

SYSTEM
/home/ora817/oradata/clubcore/system01.dbf   800M

TOOLS
/home/ora817/oradata/clubcore/tools01.dbf  250M

RBS
/home/ora817/oradata/clubcore/rbs01.dbf   1024M

TEMP
/home/ora817/oradata/clubcore/temp01.dbf  2048

USERS
/home2/ora817/oradata/clubcore/users01.dbf  2048

INDX
/home3/ora817/oradata/clubcore/indx01.dbf 2048

CLUB_CORE
/home2/ora817/oradata/clubcore/club_core01.dbf  2048

 --查询原用户名,并导出原用户下数据 
 
--2.查询数据库sid
 ORACLE_SID=clubcore
 
 --3.确定原表空间名称和大小
 TABLESPACE                                                      USED MB
------------------------------------------------------------ ----------
   FREE MB      TOTAL
---------- ----------
CLUB_CORE                                                             0
      2048       2048

INDX                                                                  0
      2048       2048

RBS                                                                 116
       908       1024

TABLESPACE                                                      USED MB
------------------------------------------------------------ ----------
   FREE MB      TOTAL
---------- ----------
SYSTEM                                                               90
       710        800

TEMP                                                                  0
      2048       2048

TOOLS                                                                 0
       250        250

TABLESPACE                                                      USED MB
------------------------------------------------------------ ----------
   FREE MB      TOTAL
---------- ----------
USERS                                                                 2
      2046       2048

7 rows selected.

--4.确定重做日志文件的位置
GROUP# STATUS
---------- --------------
MEMBER
--------------------------------------------------------------------------------
         1
/home3/ora817/oradata/redo0101.log

         1
/home4/ora817/oradata/redo0102.log

         2
/home3/ora817/oradata/redo0201.log

    GROUP# STATUS
---------- --------------
MEMBER
--------------------------------------------------------------------------------
         2
/home4/ora817/oradata/redo0202.log

         3
/home3/ora817/oradata/redo0301.log

         3
/home4/ora817/oradata/redo0302.log

6 rows selected.

--创建密钥文件 orapwd file=orapwsid password=***  entries=5       

--执行创建数据库脚本

CREATE DATABASE clubcore
MAXINSTANCES 1
MAXLOGHISTORY 1
MAXLOGFILES 7
MAXLOGMEMBERS 3
MAXDATAFILES 100
DATAFILE '/home/ora817/oradata/clubcore/system01.dbf' SIZE 800M REUSE AUTOEXTEND ON NEXT  10240K MAXSIZE UNLIMITED
CHARACTER SET ZHS16GBK
NATIONAL CHARACTER SET ZHS16GBK
LOGFILE GROUP 1 ('/home3/ora817/oradata/redo0101.log','/home4/ora817/oradata/redo0102.log') SIZE 40960K,
GROUP 2 ('/home3/ora817/oradata/redo0201.log','/home4/ora817/oradata/redo0202.log') SIZE 40960K,
GROUP 3 ('/home3/ora817/oradata/redo0301.log','/home4/ora817/oradata/redo0302.log') SIZE 40960K;

--创建数据文件
CREATE TABLESPACE "INDX" LOGGING DATAFILE '/home3/ora817/oradata/clubcore/indx01.dbf' SIZE 2048M REUSE AUTOEXTEND ON NEXT  1280K MAXSIZE UNLIMITED;
CREATE TABLESPACE "USERS" LOGGING DATAFILE '/home2/ora817/oradata/clubcore/users01.dbf' SIZE 2048M REUSE AUTOEXTEND ON NEXT  1280K MAXSIZE UNLIMITED;
CREATE TABLESPACE "TOOLS" LOGGING DATAFILE '/home/ora817/oradata/clubcore/tools01.dbf ' SIZE 250M REUSE AUTOEXTEND ON NEXT  320K MAXSIZE UNLIMITED;
CREATE TABLESPACE "CLUB_CORE" LOGGING DATAFILE '/home2/ora817/oradata/clubcore/club_core01.dbf' SIZE 2048M REUSE AUTOEXTEND ON NEXT  1280K MAXSIZE UNLIMITED;
CREATE TABLESPACE "RBS" LOGGING DATAFILE '/home/ora817/oradata/clubcore/rbs01.dbf' SIZE 1024M REUSE AUTOEXTEND ON NEXT  1280K MAXSIZE UNLIMITED;
create temporary tablespace TEMP  tempfile '/home/ora817/oradata/clubcore/temp01.dbf' size 2048M;

--创建回滚段
create public rollback segment rb1 tablespace RBS  storage (initial 100K next 100K minextents 20 maxextents 100 optimal 50M);
create public rollback segment rb2 tablespace RBS  storage (initial 100K next 100K minextents 20 maxextents 100 optimal 50M);
create public rollback segment rb3 tablespace RBS  storage (initial 100K next 100K minextents 20 maxextents 100 optimal 50M);
create public rollback segment rb4 tablespace RBS  storage (initial 100K next 100K minextents 20 maxextents 100 optimal 50M);
create public rollback segment rb5 tablespace RBS  storage (initial 100K next 100K minextents 20 maxextents 100 optimal 50M);
create public rollback segment rb6 tablespace RBS  storage (initial 100K next 100K minextents 20 maxextents 100 optimal 50M);

--创建相应的数据库包
connect SYS/change_on_install as SYSDBA
@?/rdbms/admin/catalog.sql;
@?/rdbms/admin/catproc.sql;
connect SYSTEM/manager
@?/sqlplus/admin/pupbld.sql;

完