第20章.txt

oracle操作基础基础基础基础基础基础基础基础基础基础基础基础

例20.1 
conn sys/sys@oradb as sysdba
SELECT * FROM V$LOGFILE;
ALTER DATABASE ADD LOGFILE GROUP 4 
 ('%ORACLE_BASE%\oradata\oradb\test4_1.rdo', 
  '%ORACLE_BASE%\oradata\oradb\test4_2.rdo') size 1M;
set pagesize 100
column MEMBER format a50
SELECT * FROM V$LOGFILE ORDER BY group#,member;

例20.2 
ALTER DATABASE ADD LOGFILE MEMBER 
  '%ORACLE_BASE%\oradata\oradb\test4_3.rdo' TO GROUP 4;
ALTER DATABASE ADD LOGFILE MEMBER '%ORACLE_BASE%\oradata\oradb\test4_4.rdo'
  TO ('%ORACLE_BASE%\oradata\oradb\test4_1.rdo',
      '%ORACLE_BASE%\oradata\oradb\test4_2.rdo',
      '%ORACLE_BASE%\oradata\oradb\test4_3.rdo');
set pagesize 100
column MEMBER format a50
SELECT * FROM V$LOGFILE ORDER BY group#,member;


20.5.3节
orapwd file=D:\oracle\ora92\database\PWDmy_oradb.ORA password=pwd1234 entries=5

compatible='9.2.0.0.0'
db_block_size = 8192
undo_management='AUTO'
db_name = my_oradb
instance_name=my_oradb
db_domain=''
service_names=my_oradb.my_domain
control_files = (D:\oracle\oradata\my_oradb\CONTROL01.CTL,
             D:\oracle\oradata\my_oradb\CONTROL02.CTL,
             D:\oracle\oradata\my_oradb\CONTROL03.CTL)

oradim -NEW -SID my_oradb -INTPWD pwd1234 -STARTMODE auto -PFILE D:\oracle\ora92\database\initMY_ORADB.ora	
oradim -DELETE -SID my_oradb 

STARTUP PFILE=D:\oracle\ora92\database\initMY_ORADB.ora NOMOUNT
CREATE DATABASE my_oradb
USER SYS IDENTIFIED BY pwd1234
USER SYSTEM IDENTIFIED BY manager
LOGFILE GROUP 1 ('D:\oracle\oradata\my_oradb\redo01.log') SIZE 5M,
        GROUP 2 ('D:\oracle\oradata\my_oradb\redo02.log') SIZE 5M,
        GROUP 3 ('D:\oracle\oradata\my_oradb\redo03.log') SIZE 5M
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXLOGHISTORY 1
MAXDATAFILES 100
MAXINSTANCES 1
CHARACTER SET ZHS16GBK
NATIONAL CHARACTER SET AL16UTF16
DATAFILE 'D:\oracle\oradata\my_oradb\system01.dbf' SIZE 200M REUSE
  EXTENT MANAGEMENT LOCAL
DEFAULT TEMPORARY TABLESPACE tempts1 
  TEMPFILE 'D:\oracle\oradata\my_oradb\temp01.dbf' SIZE 10M REUSE
UNDO TABLESPACE undotbs1
  DATAFILE 'D:\oracle\oradata\my_oradb\undotbs01.dbf' SIZE 10M REUSE 
  AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED;

CREATE TABLESPACE users 
  DATAFILE 'D:\oracle\oradata\my_oradb\users01.dbf' SIZE 5M REUSE
  AUTOEXTEND ON NEXT 1280K MAXSIZE UNLIMITED
  EXTENT MANAGEMENT LOCAL;

CREATE TABLESPACE indx
  DATAFILE 'D:\oracle\oradata\my_oradb\indx01.dbf' SIZE 5M REUSE
  AUTOEXTEND ON NEXT 1280K MAXSIZE UNLIMITED
  EXTENT MANAGEMENT LOCAL;
@D:\oracle\ora92\rdbms\admin\catalog.sql
@D:\oracle\ora92\rdbms\admin\catproc.sql

    (SID_DESC =
      (GLOBAL_DBNAME = my_oradb)
      (ORACLE_HOME = D:\oracle\ora92)
      (SID_NAME = my_oradb)
    )    

my_ORADB =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = tyx)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = my_oradb)
    )
  )