[Oracle 9i] Fundamentals 2 - Practice 7

Practice 7 : Instance and Media Recovery Structure

1. Database의 이름과 모든 Datafile, Redo Log file, Control file의 이름을 v$View를 통해 조회하세요.
   # sqlplus "/as sysdba"
   SQL> select name from v$database;
   SQL> select naem from v$datafile;
   SQL> select group#, status from v#log;
   SQL> select member from v$logfile;
   SQL> select name from v$controlfile;

2. Control file을 다중화 하세요. (/opt/oracle/PROD/u05 경로) -> 이미 다중화 되어 있으면 하지 말 것!
   SQL> shutdown immediate;
   SQL> exit
   # cp -p /opt/oracle/PROD/u05/ctrlPROD01.ctl   /opt/oracle/PROD/u05/ctrlPROD03.ctl
   # chmod 775 /opt/oracle/PROD/u05/ctrlPROD02.ctl
   # vi $ORACLE_HOME/dbs/initPROD.ora
  
   control_files=/opt/oracle/PROD/u05/ctrlPROD01.ctl, /opt/oracle/PROD/u05/ctrlPROD02.ctl

   # sqlplus "as/sysdba"
   SQL> startup
   SQL> show parameter control

3. Redo log file을 다중화 하세요.
   SQL> ALTER DATABASE ADD LOGFILE MEMBER
               /opt/oracle/PROD/u04/log01b.rdo'to GROUP 1,
               /opt/oracle/PROD/u04/log01b.rdo'to GROUP 2,
   SQL> select member from v$logfile;
   SQL> exit