rac 下建立建立連機日誌

L> select * From v$log;

    GROUP#    THREAD#  SEQUENCE#      BYTES  BLOCKSIZE   MEMBERS ARC STATUS        FIRST_CHANGE# FIRST_TIM NEXT_CHANGE# NEXT_TIME
---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- --------- ------------ ---------
  1     1      443   52428800    512  2 NO  CURRENT    3.0990E+10 10-DEC-12  2.8147E+14 10-DEC-12
  2     1      442   52428800    512  2 YES INACTIVE    3.0990E+10 09-DEC-12  3.0990E+10 09-DEC-12
  3     2      289   52428800    512  2 YES ACTIVE    3.0990E+10 10-DEC-12  3.0990E+10 10-DEC-12
  4     2      288   52428800    512  2 YES INACTIVE    3.0990E+10 08-DEC-12  3.0990E+10 10-DEC-12
select * From v$logfile;
GROUP# STATUS  TYPE    MEMBER           IS_
---------- ------- ------- -------------------------------------------------- ---
  1    ONLINE  +DATA01/rac/onlinelog/group_1.257.795262481       NO
  1    ONLINE  +CANDIATE/rac/onlinelog/group_1.260.795262483      YES
  2    ONLINE  +DATA01/rac/onlinelog/group_2.258.795262485       NO
  2    ONLINE  +CANDIATE/rac/onlinelog/group_2.261.795262487      YES
  3    ONLINE  +DATA01/rac/onlinelog/group_3.265.795268739       NO
  3    ONLINE  +CANDIATE/rac/onlinelog/group_3.262.795268741      YES
  4    ONLINE  +DATA01/rac/onlinelog/group_4.266.795268751       NO
  4    ONLINE  +CANDIATE/rac/onlinelog/group_4.263.795268757      YES
參數檔案備份
create pfile='/home/oracle/pfilerac.ora' from spfile='+data01/rac/spfilerac.ora'
控制檔案備份
 alter database backup controlfile to trace as '/home/oracle/controlfile.sql'
增加聯機記錄檔
alter database add logfile thread 1 group 5 '+DATA01/rac/onlinelog/redo05.log' size 50M;
alter database add logfile thread 2 group 6'+DATA01/rac/onlinelog/redo06.log' size 50M;
alter database add logfile thread 1 group 7 '+DATA01/rac/onlinelog/redo07.log' size 50M;
alter database add logfile thread 2group 8 '+DATA01/rac/onlinelog/redo08.log' size 50M;
alter database add logfile thread 1 group 9 '+DATA01/rac/onlinelog/redo09.log' size 50M;
alter database add logfile thread 2 group 10 '+DATA01/rac/onlinelog/redo10.log' size 50M;

增加日誌成員：
alter database add logfile member '+DATA01/rac/onlinelog/redo05a.log'  to group  5;
alter database add logfile member '+DATA01/rac/onlinelog/redo06a.log'  to group  6;
alter database add logfile member '+DATA01/rac/onlinelog/redo07a.log'  to group  7;
alter database add logfile member '+DATA01/rac/onlinelog/redo08a.log'  to group  8;
alter database add logfile member '+DATA01/rac/onlinelog/redo09a.log'  to group  9;
alter database add logfile member '+DATA01/rac/onlinelog/redo10a.log'  to group  10;

 

刪除聯機日誌

ALTER DATABASE DROP LOGFILE GROUP 1;
alter database drop logfile group 2;
alter database drop logfile group 3;
alter database drop logfile group 4;