Oracle重做日志-OMF管理

发布时间：2020-12-12 14:26:57 所属栏目：百科来源：网络整理

导读：OMF:oracle managed files oracle管理文件 1、设定日志成员存放目录 SQL alter system set DB_CREATE_ONLINE_LOG_DEST_1='C:orcl1122disk2'; System altered SQL alter system set DB_CREATE_ONLINE_LOG_DEST_2='C:orcl1122disk3'; System altered SQL a

OMF:oracle managed files oracle管理文件

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

SQL> alter system set DB_CREATE_ONLINE_LOG_DEST_1='C:orcl1122disk2';
System altered

SQL> alter system set DB_CREATE_ONLINE_LOG_DEST_2='C:orcl1122disk3';
System altered

SQL> alter system set DB_CREATE_ONLINE_LOG_DEST_3='C:orcl1122disk4';
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:ORACELBASEORADATAORCLREDO03.LOG NO
2 ONLINE C:ORACELBASEORADATAORCLREDO02.LOG NO
1 ONLINE C:ORACELBASEORADATAORCLREDO01.LOG NO
4 ONLINE C:ORCL1122DISK2ORCLONLINELOGO1_MF_4_DW6FOS5Q_.LOG NO
2 INVALID ONLINE C:ORACELBASEORADATAORCLREDO05.LOG NO
4 ONLINE C:ORCL1122DISK3ORCLONLINELOGO1_MF_4_DW6FOTJY_.LOG NO
4 ONLINE C:ORCL1122DISK4ORCLONLINELOGO1_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:ORACELBASEORADATAORCLREDO03.LOG NO 2 ONLINE C:ORACELBASEORADATAORCLREDO02.LOG NO 1 ONLINE C:ORACELBASEORADATAORCLREDO01.LOG NO 2 INVALID ONLINE C:ORACELBASEORADATAORCLREDO05.LOG NO SQL>

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!