HighLight in your life~

-- 실전 오라클 백업과 복구(생능출판사, 서진수 지음), p.138~p.140
-- temporary tablespace 관리 방법
-- 1. 현재 상태 파악하기
SQL> set line 200
SQL> col tablespace_name for a10
SQL> col file_name for a50
SQL> select file_id, tablespace_name, bytes/1024/1024 MB, file_name from dba_temp_files;
SQL>

-- 2. 신규 temporary tablespace temp2 생성하기
SQL> create temporary tablespace temp2
tempfile '/u01/app/oracle/oradata/orcl/temp02.dbf' size 10M;
SQL> set line 200
SQL> col property_name for a30
SQL> col property_value for a10
SQL> col description for a50
SQL> select * from database_properties
where property_name like 'DEFAULT%';
SQL>

-- 3. temporary tablespace 변경하기
SQL> alter database default temporary tablespace temp2;
SQL> drop tablespace temp;
SQL>

-- 실전 오라클 백업과 복구(생능출판사, 서진수 지음), p.138~p.140
-- undo tablespace 관리 방법
-- 1. 현재 상태 파악하기
SQL> set line 200
SQL> col name for a10
SQL> show parameter undo;
SQL>

-- 2. 신규 undo tablespace 생성하기
SQL> create undo tablespace undo01
     datafile '/u01/app/oracle/oradata/orcl/undo01.dbf' size 10M
     autoextend on;
SQL> col tablespace_name for a10
SQL> col file_name for a50
SQL> select tablespace_name, bytes/1024/1024 MB, file_name from dba_data_files;
SQL>

-- 3. Undo tablespace 변경하기(UNDOTBS1 -> UNDO01)
SQL> show parameter undo;
SQL> alter system set undo_tablespace=undo01;
SQL> show parameter undo;
SQL>

-- 실전 오라클 백업과 복구(생능출판사, 서진수 지음), p.140
-- 각 세션별로 사용 중인 undo segment 확인하기

SQL> select s.sid, s.serial#, s.username, r.name "ROLLBACK SEG"
from v$session s, v$transaction t, v$rollname r
where s.taddr = t.addr
and t.xidusn = r.usn;

-- 실전 오라클 백업과 복구(생능출판사, 서진수 지음), p.142
-- ORA-0155, Snapshot too old
undo_retention: commit 수행 후에도 해당 undo segment 내의 데이터를 다른 서버프로세스가 덮어쓰지 못하도록 막아주는 시간이다.
이 부분이 문제가 발생하면 오라클은 ORA-0155.Snapshot too old라는 에러를 발생시킨다.

-- Redo log file 관리 II - 추가 Redo log 멤버를 '/u01/app/oracle/disk2/'에 추가
-- 실전 오라클 백업과 복구(생능출판사, 서진수 지음), p.122
-- /u01/app/oracle/disk1/redo01_a.log, redo02_a.log, redo03_a.log
-- /u01/app/oracle/disk2/redo01_b.log, redo02_b.log, redo03_b.log

SQL> select a.group#, a.member, b.bytes/1024/1024 MB, b.archived, b.status
     from v$logfile a, v$log b
     where a.group#=b.group#
     order by 1, 2;  2    3    4

    GROUP# MEMBER                                                     MB ARCHIV STATUS
---------- -------------------------------------------------- ---------- ------ ----------------------------
         1 /u01/app/oracle/disk1/redo01_a.log                         50 NO     INACTIVE
         2 /u01/app/oracle/disk1/redo02_a.log                         50 NO     INACTIVE
         3 /u01/app/oracle/disk1/redo03_a.log                         50 NO     CURRENT

SQL> alter database add logfile member
     '/u01/app/oracle/disk2/redo01_b.log' to group 1;

SQL> alter database add logfile member
     '/u01/app/oracle/disk2/redo02_b.log' to group 2;

SQL> alter database add logfile member
     '/u01/app/oracle/disk2/redo03_b.log' to group 3;

SQL> select a.group#, a.member, b.bytes/1024/1024 MB, b.archived, b.status
     from v$logfile a, v$log b
     where a.group#=b.group#
     order by 1, 2;  2    3    4

    GROUP# MEMBER                                                     MB ARCHIV STATUS
---------- -------------------------------------------------- ---------- ------ ----------------------------
         1 /u01/app/oracle/disk1/redo01_a.log                         50 NO     INACTIVE
         1 /u01/app/oracle/disk2/redo01_b.log                         50 NO     INACTIVE
         2 /u01/app/oracle/disk1/redo02_a.log                         50 NO     INACTIVE
         2 /u01/app/oracle/disk2/redo02_b.log                         50 NO     INACTIVE
         3 /u01/app/oracle/disk1/redo03_a.log                         50 NO     CURRENT
         3 /u01/app/oracle/disk2/redo03_b.log                         50 NO     CURRENT

-- Control file과 Redo log file 관리
-- 실전 오라클 백업과 복구(생능출판사, 서진수 지음), p.122

-- /u01/app/oracle/disk3/control01.ctl, redo01_a.log, redo02_a.log, redo03_a.log
-- /u01/app/oracle/disk4/control02.ctl, redo01_b.log, redo02_b.log, redo03_b.log
-- /u01/app/oracle/disk5/control03.ctl, redo01_c.log, redo02_c.log, redo03_c.log

SQL> shutdown immediate

SQL> startup open;

SQL> alter system set control_files='/u01/app/oracle/disk1/control01.ctl',
                                                  '/u01/app/oracle/disk2/control02.ctl', 
                                                  '/u01/app/oracle/disk3/control03.ctl',
                                                  '/u01/app/oracle/disk3/control01.ctl',
                                                  '/u01/app/oracle/disk4/control02.ctl',
                                                  '/u01/app/oracle/disk5/control03.ctl' scope=spfile;
SQL> shutdown immediate;
SQL> exit

os]cp /u01/app/oracle/oradata/orcl/control01.ctl /u01/app/oracle/disk1/control01.ctl
os]cp /u01/app/oracle/oradata/orcl/control01.ctl /u01/app/oracle/disk2/control02.ctl
os]cp /u01/app/oracle/oradata/orcl/control01.ctl /u01/app/oracle/disk3/control03.ctl

os]cp /u01/app/oracle/oradata/orcl/control01.ctl /u01/app/oracle/disk3/control01.ctl
os]cp /u01/app/oracle/oradata/orcl/control01.ctl /u01/app/oracle/disk4/control02.ctl
os]cp /u01/app/oracle/oradata/orcl/control01.ctl /u01/app/oracle/disk5/control03.ctl

os]sqlplus / as sysdba

SQL> startup open;
SQL> select name from v$controlfile;

NAME
--------------------------------------------------------------------------------
/u01/app/oracle/disk1/control01.ctl
/u01/app/oracle/disk2/control02.ctl
/u01/app/oracle/disk3/control03.ctl
/u01/app/oracle/disk3/control01.ctl
/u01/app/oracle/disk4/control02.ctl
/u01/app/oracle/disk5/control03.ctl

SQL> alter database add logfile member
     '/u01/app/oracle/disk3/redo01_a.log' to group 1;
SQL> alter database add logfile member
     '/u01/app/oracle/disk3/redo02_a.log' to group 2;
SQL> alter database add logfile member
     '/u01/app/oracle/disk3/redo03_a.log' to group 3;

SQL> alter database add logfile member
     '/u01/app/oracle/disk4/redo01_b.log' to group 1;
SQL> alter database add logfile member
     '/u01/app/oracle/disk4/redo02_b.log' to group 2;
SQL> alter database add logfile member
     '/u01/app/oracle/disk4/redo03_b.log' to group 3;

SQL> alter database add logfile member
     '/u01/app/oracle/disk5/redo01_c.log' to group 1;
SQL> alter database add logfile member
     '/u01/app/oracle/disk5/redo02_c.log' to group 2;
SQL> alter database add logfile member
     '/u01/app/oracle/disk5/redo03_c.log' to group 3;

SQL> alter system switch logfile;
SQL> alter system switch logfile;
SQL> alter system switch logfile;
SQL> alter system switch logfile;
SQL> alter system switch logfile;
SQL> alter system chechkpoint;

SQL> select a.group#, a.member, b.bytes/1024/1024 MB, b.archived, b.status
     from v$logfile a, v$log b
     where a.group#=b.group#
     order by 1, 2;

    GROUP# MEMBER                                                     MB ARCHIV STATUS
---------- -------------------------------------------------- ---------- ------ ----------------------------
         1 /u01/app/oracle/disk1/redo01_a.log                         50 NO     INACTIVE
         1 /u01/app/oracle/disk2/redo01_b.log                         50 NO     INACTIVE
         1 /u01/app/oracle/disk3/redo01_a.log                         50 NO     INACTIVE
         1 /u01/app/oracle/disk4/redo01_b.log                         50 NO     INACTIVE
         1 /u01/app/oracle/disk5/redo01_c.log                         50 NO     INACTIVE
         2 /u01/app/oracle/disk1/redo02_a.log                         50 NO     CURRENT
         2 /u01/app/oracle/disk2/redo02_b.log                         50 NO     CURRENT
         2 /u01/app/oracle/disk3/redo02_a.log                         50 NO     CURRENT
         2 /u01/app/oracle/disk4/redo02_b.log                         50 NO     CURRENT
         2 /u01/app/oracle/disk5/redo02_c.log                         50 NO     CURRENT
         3 /u01/app/oracle/disk1/redo03_a.log                         50 NO     INACTIVE

    GROUP# MEMBER                                                     MB ARCHIV STATUS
---------- -------------------------------------------------- ---------- ------ ----------------------------
         3 /u01/app/oracle/disk2/redo03_b.log                         50 NO     INACTIVE
         3 /u01/app/oracle/disk3/redo03_a.log                         50 NO     INACTIVE
         3 /u01/app/oracle/disk4/redo03_b.log                         50 NO     INACTIVE
         3 /u01/app/oracle/disk5/redo03_c.log                         50 NO     INACTIVE

SQL> alter database drop logfile member '/u01/app/oracle/disk1/redo01_a.log';
SQL> alter database drop logfile member '/u01/app/oracle/disk2/redo01_b.log';

SQL> alter database drop logfile member '/u01/app/oracle/disk1/redo03_a.log';
SQL> alter database drop logfile member '/u01/app/oracle/disk2/redo03_b.log';

SQL> select a.group#, a.member, b.bytes/1024/1024 MB, b.archived, b.status
     from v$logfile a, v$log b
     where a.group#=b.group#
     order by 1, 2;   2    3    4

    GROUP# MEMBER                                                     MB ARCHIV STATUS
---------- -------------------------------------------------- ---------- ------ ----------------------------
         1 /u01/app/oracle/disk3/redo01_a.log                         50 NO     INACTIVE
         1 /u01/app/oracle/disk4/redo01_b.log                         50 NO     INACTIVE
         1 /u01/app/oracle/disk5/redo01_c.log                         50 NO     INACTIVE
         2 /u01/app/oracle/disk1/redo02_a.log                         50 NO     CURRENT
         2 /u01/app/oracle/disk2/redo02_b.log                         50 NO     CURRENT
         2 /u01/app/oracle/disk3/redo02_a.log                         50 NO     CURRENT
         2 /u01/app/oracle/disk4/redo02_b.log                         50 NO     CURRENT
         2 /u01/app/oracle/disk5/redo02_c.log                         50 NO     CURRENT
         3 /u01/app/oracle/disk3/redo03_a.log                         50 NO     INACTIVE
         3 /u01/app/oracle/disk4/redo03_b.log                         50 NO     INACTIVE
         3 /u01/app/oracle/disk5/redo03_c.log                         50 NO     INACTIVE

SQL> alter system switch logfile;
SQL> alter system checkpoint;

SQL> select a.group#, a.member, b.bytes/1024/1024 MB, b.archived, b.status
     from v$logfile a, v$log b
     where a.group#=b.group#
     order by 1, 2;  2    3    4

    GROUP# MEMBER                                                     MB ARCHIV STATUS
---------- -------------------------------------------------- ---------- ------ ----------------------------
         1 /u01/app/oracle/disk3/redo01_a.log                         50 NO     INACTIVE
         1 /u01/app/oracle/disk4/redo01_b.log                         50 NO     INACTIVE
         1 /u01/app/oracle/disk5/redo01_c.log                         50 NO     INACTIVE
         2 /u01/app/oracle/disk1/redo02_a.log                         50 NO     INACTIVE
         2 /u01/app/oracle/disk2/redo02_b.log                         50 NO     INACTIVE
         2 /u01/app/oracle/disk3/redo02_a.log                         50 NO     INACTIVE
         2 /u01/app/oracle/disk4/redo02_b.log                         50 NO     INACTIVE
         2 /u01/app/oracle/disk5/redo02_c.log                         50 NO     INACTIVE
         3 /u01/app/oracle/disk3/redo03_a.log                         50 NO     CURRENT
         3 /u01/app/oracle/disk4/redo03_b.log                         50 NO     CURRENT
         3 /u01/app/oracle/disk5/redo03_c.log                         50 NO     CURRENT

SQL> alter database drop logfile member '/u01/app/oracle/disk1/redo02_a.log';
SQL> alter database drop logfile member '/u01/app/oracle/disk2/redo02_b.log';

SQL> !rm -rf /u01/app/oracle/disk1/redo01_a.log
SQL> !rm -rf /u01/app/oracle/disk2/redo01_b.log

SQL> !rm -rf /u01/app/oracle/disk1/redo02_a.log
SQL> !rm -rf /u01/app/oracle/disk2/redo02_b.log

SQL> !rm -rf /u01/app/oracle/disk1/redo03_a.log
SQL> !rm -rf /u01/app/oracle/disk2/redo03_b.log

SQL> !ls /u01/app/oracle/disk1/
SQL> !ls /u01/app/oracle/disk2/

SQL>

-- 실전 오라클 백업과 복구(생능출판사, 서진수 지음), p.115
-- Redo log file 관리방법 익히기
SQL> select member from v$logfile;

os]du -h /u01/app/oracle/oradata/orcl/redo01.log
51M     /u01/app/oracle/oradata/orcl/redo01.log

--1. 신규 그룹 생성
SQL> alter database add logfile group 4
     '/u01/app/oracle/oradata/orcl/redo04_a.log' size 51M;

--2. 멤버 추가
SQL> alter database add logfile member
     '/u01/app/oracle/oradata/orcl/redo04_b.log' to group 4;

--3. 멤버 삭제
SQL> alter database drop logfile member
     '/u01/app/oracle/oradata/orcl/redo04_b.log';

--4. 그룹 삭제
SQL> alter database drop logfile group 4;

--5. 강제로 log switch 발생
SQL> alter database switch logfile;

--6. 강제로 checkpoint 발생
SQL> alter system checkpoint;

 위의 3, 4번 과정을 진행해도 실제로 해당 파일은 지워지지 않는다. 3, 4번 명령어는 단지 control file 안에 있는
해당 그룹과 멤버의 정보만 지울뿐 실제 파일은 지우지 못 한다. 따라서 위 명령어들은 수행하고 난 뒤 반드시 DBA가 직접 OS 명령어로 해당 파일을 지워야 한다. 다른 그룹이나 멤버를 지우지 않도록 각별히 조심해야 한다. 그리고 Redo log file의 상태를 나타내는 것이 CURRENT / ACTIVE / INACTIVE 이렇게 3가지가 있다. 만약 DBA가 어떤 필요에 의해서 Redo log file을 삭제하고 싶다면 반드시 INACTIVE 상태로 만들고 위 3, 4번의 명령어로 삭제를 수행해야 한다.

-- 실전 오라클 백업과 복구(생능출판사, 서진수 지음), p.117
 만약 어떤 Redo log 그룹을 삭제하고 싶다면 우선 해당 그룹의 상태가 Inactive인지 확인 후 만약 Current 상태였다면 먼저 Active 상태로 변경하고(alter system switch logfile;) 그 후에 Active 상태를 Inactive 상태로 변경하여(alter system ckeckpoint;) 삭제하여야 한다.

-- 실전 오라클 백업과 복구(생능출판사, 서진수 지음), p.117~p.121

os] sqlplus / as sysdba;

SQL> set line 200
SQL> col a.group# for 999
SQL> col member for a50
SQL> select a.group#, a.member, b.bytes/1024/1024 MB, b.archived, b.status
     from v$logfile a, v$log b
     where a.group#=b.group#
     order by 1, 2;
SQL> alter database add logfile group 4
     '/u01/app/oracle/oradata/orcl/redo04_a.log' size 51M;

SQL> alter database add logfile member
     '/u01/app/oracle/oradata/orcl/redo04_b.log' to group 4;

SQL> alter system switch logfile;
SQL> alter database drop logfile member '/u01/app/oracle/oradata/orcl/redo04_b.log';
SQL> !ls /u01/app/oracle/oradata/orcl
SQL> !rm -rf /u01/app/oracle/oradata/orcl/redo04_b.log
SQL> !ls /u01/app/oracle/oradata/orcl
--SQL> alter database drop logfile member '/u01/app/oracle/oradata/orcl/redo04_a.log';
--그룹에 멤버가 1개일 경우 멤보는 삭제가 안되며 그룹을 지워야 한다.
SQL> alter database drop logfile group 4;
SQL> !ls /u01/app/oracle/oradata/orcl
SQL> !rm -rf /u01/app/oracle/oradata/orcl/redo04_a.log
SQL> !ls ls /u01/app/oracle/oradata/orcl
SQL>

cf. 절대 주의 사항 - Redo log file을 삭제할 때 절대 OS 명령어로 먼저 삭제하면 안 된다.

P.S.

alter database clear unarchived logfile group 1;
-- 위 명령어를 치면 control file의 정보를 보고 해당 그룹의 멤버를 자동으로 생성한다.

alter database drop logfile group 1;

alter database add logfile group 1
('/u01/app/oracle/oradata/orcl/redo01_a.log',
'/u01/app/oracle/oradata/orcl/redo01_b.log') size 5m;

-- 실전 오라클 백업과 복구(생능출판사, 서진수 지음), p.114

만약 병렬쓰기 도중에 로그 파일이 삭제되었거나 블록에 문제가 발생했다든지 문제가 발생하는 경우에는 LGWR은 각 오픈 로그 멤버의 상태를 조사해서 어떤 파일에 에러가 발생되었는지 알아낸다. 그리고 그 장애가 발생한 멤버는 control file 안에서 STALE라는 상태로 기록이 된다. 그리고 LGWR은 백그라운드 trace file에 ORA-00346 에러를 기록한다. STALE이라는 상태는 해당 로그 파일에 문제가 있다는 것을 의미한다. 만약 LGWR이 하나의 로그 파일에서 4개 이상의 에러를 만나게 되면 로그 파일을 닫고 더 이상 그 파일에 내용을 기록하지 않는다. 만약 LGWR이 어떤 로그 파일에도 내용을 기록할 수 없다면 ORA-00340 에러를 발생시키고 shutdown abort로 강제 종료되고 startup 되지 않는다.

-- 실전 오라클 백업과 복구(생능출판사, 서진수 지음), p.110 문제 풀이

1. spfile 구동 시

SQL> shutdown immediate
SQL> exit

os]mkdir /u01/app/oracle/disk1
os]mkdir /u01/app/oracle/disk2
os]mkdir /u01/app/oracle/disk3
os]mkdir /u01/app/oracle/disk4
os]mkdir /u01/app/oracle/disk5

os]sqlplus / as sysdba

SQL> startup open;

SQL> alter system set control_files='/u01/app/oracle/disk1/control01.ctl',
                                                  '/u01/app/oracle/disk2/control02.ctl',
                                                  '/u01/app/oracle/disk3/control03.ctl',
                                                  '/u01/app/oracle/disk3/control01.ctl',
                                                  '/u01/app/oracle/disk4/control02.ctl',
                                                  '/u01/app/oracle/disk5/control03.ctl' scope=spfile;
SQL> shutdown immediate;
SQL> exit

os]cp /u01/app/oracle/oradata/orcl/control01.ctl /u01/app/oracle/disk1/control01.ctl
os]cp /u01/app/oracle/oradata/orcl/control01.ctl /u01/app/oracle/disk2/control02.ctl
os]cp /u01/app/oracle/oradata/orcl/control01.ctl /u01/app/oracle/disk3/control03.ctl

os]cp /u01/app/oracle/oradata/orcl/control01.ctl /u01/app/oracle/disk3/control01.ctl
os]cp /u01/app/oracle/oradata/orcl/control01.ctl /u01/app/oracle/disk4/control02.ctl
os]cp /u01/app/oracle/oradata/orcl/control01.ctl /u01/app/oracle/disk5/control03.ctl

os]sqlplus / as sysdba

SQL> startup open;
SQL> select name from v$controlfile;

NAME
--------------------------------------------------------------------------------
/u01/app/oracle/disk1/control01.ctl
/u01/app/oracle/disk2/control02.ctl
/u01/app/oracle/disk3/control03.ctl
/u01/app/oracle/disk3/control01.ctl
/u01/app/oracle/disk4/control02.ctl
/u01/app/oracle/disk5/control03.ctl

2. pfile 구동 시

SQL> shutdown immediate
SQL> exit

os]mkdir /u01/app/oracle/disk1
os]mkdir /u01/app/oracle/disk2
os]mkdir /u01/app/oracle/disk3
os]mkdir /u01/app/oracle/disk4
os]mkdir /u01/app/oracle/disk5

os]cp /u01/app/oracle/oradata/orcl/control01.ctl /u01/app/oracle/disk1/control01.ctl
os]cp /u01/app/oracle/oradata/orcl/control01.ctl /u01/app/oracle/disk2/control02.ctl
os]cp /u01/app/oracle/oradata/orcl/control01.ctl /u01/app/oracle/disk3/control03.ctl

os]cp /u01/app/oracle/oradata/orcl/control01.ctl /u01/app/oracle/disk3/control01.ctl
os]cp /u01/app/oracle/oradata/orcl/control01.ctl /u01/app/oracle/disk4/control02.ctl
os]cp /u01/app/oracle/oradata/orcl/control01.ctl /u01/app/oracle/disk5/control03.ctl

-- pfile 수정

os]sqlplus / as sysdba

SQL> startup open;
SQL> select name from v$controlfile;

NAME
--------------------------------------------------------------------------------
/u01/app/oracle/disk1/control01.ctl
/u01/app/oracle/disk2/control02.ctl
/u01/app/oracle/disk3/control03.ctl
/u01/app/oracle/disk3/control01.ctl
/u01/app/oracle/disk4/control02.ctl
/u01/app/oracle/disk5/control03.ctl

참고> http://f1angel.tistory.com/70

cf. 컨트롤 파일 다중화
http://blog.daum.net/itcertification/8212408
http://devidebyzero.egloos.com/2080477
http://sksstar.tistory.com/101
http://dbrang.tistory.com/512

cf. 리두로그 파일
http://www.jigi.net/entry/%EC%98%A4%EB%9D%BC%ED%81%B4-Admin-2

cf. 리눅스에서 오라클 설치 시 한글 깨짐 문제
http://secretno.tistory.com/338
http://fafoyoum.blog.me/70021582158

cf. Patch
http://cafe.naver.com/ocmkorea/7312

1. Current Parameterfile 확인

SQL> shutdown immediate
SQL> !ls $ORACLE_HOME/dbs
alert_orcl.log  init.ora    lkORCL     spfileorcl.ora
hc_orcl.dat     initdw.ora  orapworcl

2. 이미 만들어져 있는 원본 pfile 찾기
SQL> !ls /u01/app/oracle/admin/orcl/pfile
init.ora.112201223639

3. 원본 pfile을 복사해 오기
SQL> !cp /u01/app/oracle/admin/orcl/pfile/init.ora.112201223639 $ORACLE_HOME/dbs/initorcl.ora

SQL> !ls $ORACLE_HOME/dbs/
alert_orcl.log  init.ora    initorcl.ora  orapworcl
hc_orcl.dat     initdw.ora  lkORCL        spfileorcl.ora

SQL> !rm -rf $ORACLE_HOME/dbs/spfileorcl.ora

SQL> !ls $ORACLE_HOME/dbs/
alert_orcl.log  init.ora    initorcl.ora  orapworcl
hc_orcl.dat     initdw.ora  lkORCL

SQL> create spfile from pfile;

SQL> !ls $ORACLE_HOME/dbs/

SQL> !rm -rf $ORACLE_HOME/dbs/initorcl.ora

SQL> create pfile from spfile;

SQL> !ls $ORACLE_HOME/dbs/

1. 읽어 봐야 할 자료들
  - 실무 전문가가 짚어 주는 유닉스UNIX | 조경휘 저 | 프리렉(이한디지털리)
  - 솔라리스 10 | 이원양 저 | 프리렉(이한디지털리)
  - 뇌를 자극하는 Red Hat Fedora 레드햇 페도라 | 우재남 저 | 한빛미디어

    http://docs.oracle.com/cd/B10501_01/server.920/a96524/c01_02intro.htm#20385
    http://docs.oracle.com/cd/E11882_01/server.112/e25789/intro.htm#i68236
   
 * Database Limits : http://docs.oracle.com/cd/B19306_01/server.102/b14237/limits002.htm#i287915

# 1-5

  http://blog.naver.com/eduguide4u/130136477686

# 1-14 : Stages of SQL Processing

  http://docs.oracle.com/cd/E11882_01/server.112/e25789/sqllangu.htm#CHDDAGAA

# vi 편집기

  http://cafe.naver.com/gsinternet/58

# 2-3

  http://docs.oracle.com/cd/B19306_01/server.102/b14231/dba.htm#sthref66

# 2-19

  - OUI Silent  모드 : http://cafe.naver.com/gsinternet/123
  - DBCA Silent 모드 : http://docs.oracle.com/cd/B10501_01/server.920/a96521/create.htm#1026199

  [oracle@ora10gr2 ~]$ dbca   --> prod 서버를 생성하세요.

    --> 10gWS1 3장 교재를 참고해서 화면에 적절한 작업을 수행하시면 됩니다.
    --> DBCA를 silent 모드로 사용할 수 있습니다. : http://docs.oracle.com/cd/B10501_01/server.920/a96521/create.htm

# Create Database : http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/create.htm#stshef232

# 출처 : http://dba-services.berkeley.edu/docs/oracle/manual-10gR2/server.102/b14357/ch2.htm#stshef475

Using the JAZN Admintool : http://docs.oracle.com/cd/B10464_05/web.904/b10325/admintoo.htm

--------------------------------------------------------------------------------------------------------

2. 실습해야 할 것들

http://gseducation.blog.me/20093164977

1)VMware 네트워크 개요
 http://suriman.tistory.com/4
 
2)OpenSSH 사용하기
 http://gseducation.blog.me/20111649379

3)VNC 서버 설정
 http://gseducation.blog.me/20115582628

4)VMware의 Snapshot 기능 활용하기
 http://gseducation.blog.me/20111162264

5)하드 디스크 한 개 추가하기
 http://gseducation.blog.me/20111229488

6)Logical Volumn Manager(LVM) 실습
 http://gseducation.blog.me/20111424211

7)VMware 포트 포워딩(권장 필수)
 http://gseducation.blog.me/20134131874

10)Oracle Database 11g Release 2 Installation On Enterprise Linux 5.0