Oracle重做日志-OMF管理

OMF:oracle managed files   oracle管理文件

1、设定日志成员存放目录

SQL> alter system set DB_CREATE_ONLINE_LOG_DEST_1='C:\orcl1122\disk2';
System altered

SQL>  alter system set DB_CREATE_ONLINE_LOG_DEST_2='C:\orcl1122\disk3';
System altered

SQL>  alter system set DB_CREATE_ONLINE_LOG_DEST_3='C:\orcl1122\disk4';
System altered

2、以OMF命令运行加入一组新的重做日志
SQL> alter database add logfile;
Database altered

3、查看
SQL> select * from v$log;
    GROUP#    THREAD#  SEQUENCE#      BYTES  BLOCKSIZE    MEMBERS ARCHIVED STATUS           FIRST_CHANGE# FIRST_TIME  NEXT_CHANGE# NEXT_TIME
---------- ---------- ---------- ---------- ---------- ---------- -------- ---------------- ------------- ----------- ------------ -----------
         1          1         13   52428800        512          1 NO       INACTIVE           21995736819 2017-9-21 9  21995740613 2017-9-21 1
         2          1         14   52428800        512          2 NO       INACTIVE           21995740613 2017-9-21 1  21995744015 2017-9-21 1
         3          1         15   52428800        512          1 NO       CURRENT            21995744015 2017-9-21 1 281474976710
         4          1          0  104857600        512          3 YES      UNUSED                       0                        0

SQL>
SQL> select * from v$logfile;
    GROUP# STATUS  TYPE    MEMBER                                                                           IS_RECOVERY_DEST_FILE
---------- ------- ------- -------------------------------------------------------------------------------- ---------------------
         3         ONLINE  C:\ORACEL\BASE\ORADATA\ORCL\REDO03.LOG                                           NO
         2         ONLINE  C:\ORACEL\BASE\ORADATA\ORCL\REDO02.LOG                                           NO
         1         ONLINE  C:\ORACEL\BASE\ORADATA\ORCL\REDO01.LOG                                           NO
         4         ONLINE  C:\ORCL1122\DISK2\ORCL\ONLINELOG\O1_MF_4_DW6FOS5Q_.LOG                           NO
         2 INVALID ONLINE  C:\ORACEL\BASE\ORADATA\ORCL\REDO05.LOG                                           NO
         4         ONLINE  C:\ORCL1122\DISK3\ORCL\ONLINELOG\O1_MF_4_DW6FOTJY_.LOG                           NO
         4         ONLINE  C:\ORCL1122\DISK4\ORCL\ONLINELOG\O1_MF_4_DW6FOZ2S_.LOG                           NO
7 rows selected

SQL>

新增加的日志文件group 4   

4、删除   物理文件自动删除
SQL> alter database drop logfile group 4;
Database altered

SQL>

5、查看

SQL> select * from v$logfile;
    GROUP# STATUS  TYPE    MEMBER                                                                           IS_RECOVERY_DEST_FILE
---------- ------- ------- -------------------------------------------------------------------------------- ---------------------
         3         ONLINE  C:\ORACEL\BASE\ORADATA\ORCL\REDO03.LOG                                           NO
         2         ONLINE  C:\ORACEL\BASE\ORADATA\ORCL\REDO02.LOG                                           NO
         1         ONLINE  C:\ORACEL\BASE\ORADATA\ORCL\REDO01.LOG                                           NO
         2 INVALID ONLINE  C:\ORACEL\BASE\ORADATA\ORCL\REDO05.LOG                                           NO

SQL>