unix上的手工建庫腳本
2024-07-21 02:40:26
供稿：網友
在hp-ux 11i上測試通過
Oracle版本為817
建好inittest.ora和PWDtest.ora
目錄：
/oracle/DATA/
執行下面的腳本
set termout on
set echo on
spool test.log
connect internal
startup pfile=/oracle/PRodUCt/8.1.7/dbs/inittest.ora nomount
create database test
logfile
group 1 (
'/oracle/DATA/redotest01a.log',
'/oracle/DATA/redotest01b.log' ) size 10M reuse,
group 2 (
'/oracle/DATA/redotest02a.log',
'/oracle/DATA/redotest02b.log' ) size 10M reuse,
group 3 (
'/oracle/DATA/redotest03a.log',
'/oracle/DATA/redotest03b.log' ) size 10M reuse
maxdatafiles 250
maxinstances 2
maxlogfiles 16
character set ZHS16GBK
national character set ZHS16GBK
datafile
'/oracle/DATA/systest.dbf' size 300M reuse
/
spool off
disconnect
connect internal
spool test_catalog.log
@/oracle/product/8.1.7/rdbms/admin/catalog.sql
spool off
connect internal
spool test.log
create rollback segment r0 tablespace system
storage (
initial 32k
next 32k
minextents 2
maxextents 100 )
/
alter rollback segment r0 online
/
create tablespace rbs
datafile
'/oracle/DATA/rbstest01.dbf' size 150M reuse,
'/oracle/DATA/rbstest02.dbf'
size 150M reuse
default storage (
initial 1M
next 1M
pctincrease 0
minextents 9
maxextents 300 )
/
create tablespace temp
datafile
'/oracle/DATA/tmptest.dbf' size 500M reuse
default storage (
initial 128k
next 128k
pctincrease 0 )
temporary
/
create rollback segment r01 tablespace rbs
storage ( optimal 20M )
/
create rollback segment r02 tablespace rbs
storage ( optimal 20M )
/
create rollback segment r03 tablespace rbs
storage ( optimal 20M )
/
create rollback segment r04 tablespace rbs
storage ( optimal 20M )
/
create rollback segment r05 tablespace rbs
storage ( optimal 20M )
/
create rollback segment r06 tablespace rbs
storage ( optimal 20M )
/
create rollback segment r07 tablespace rbs
storage ( optimal 20M )
/
create rollback segment r08 tablespace rbs
storage ( optimal 20M )
/
alter rollback segment r01 online
/
alter rollback segment r02 online
/
alter rollback segment r03 online
/
alter rollback segment r04 online
/
alter rollback segment r05 online
/
alter rollback segment r06 online
/
alter rollback segment r07 online
/
alter rollback segment r08 online
/
alter rollback segment r0 offline
/
alter
user system temporary tablespace temp
/
spool off
connect internal
spool test_catproc.log
@/oracle/product/8.1.7/rdbms/admin/catproc.sql
spool off
spool test_cateXP.log
@/oracle/product/8.1.7/rdbms/admin/catexp.sql
spool off
測試通過：）
