加入收藏 | 设为首页 | 会员中心 | 我要投稿 李大同 (https://www.lidatong.com.cn/)- 科技、建站、经验、云计算、5G、大数据,站长网!
当前位置: 首页 > 百科 > 正文

Oracle Database 联机日志文件管理

发布时间:2020-12-12 13:33:16 所属栏目:百科 来源:网络整理
导读:SQL?col?member?for?a50 SQL?select?group#,status,type,member?from?v$logfile;??? ????GROUP#?Status????TS?Type?????????MEMBER ----------?---------?---------------?-------------------------------------------------- ?????????3???????????ONLINE?
SQL>?col?member?for?a50 SQL>?select?group#,status,type,member?from?v$logfile;??? ????GROUP#?Status????TS?Type?????????MEMBER ----------?---------?---------------?-------------------------------------------------- ?????????3???????????ONLINE??????????/u01/app/oracle/oradata/king/redo03.log ?????????2???????????ONLINE??????????/u01/app/oracle/oradata/king/redo02.log ?????????1???????????ONLINE??????????/u01/app/oracle/oradata/king/redo01.log


SQL>?select?group#,sequence#,members,bytes,archived?from?v$log;
????GROUP#??SEQUENCE#????MEMBERS??????BYTES?Status????ARCHIVED
----------?----------?----------?----------?---------?---------
?????????1??????????4??????????1???52428800?INACTIVE??YES
?????????2??????????5??????????1???52428800?INACTIVE??YES
?????????3??????????6??????????1???52428800?CURRENT???NO


SQL>?alter?database?drop?logfile?group?1;

SQL>?host?rm?-rf?/u01/app/oracle/oradata/king/redo01.log

SQL>?alter?database?add?logfile?group?1
('/u01/app/oracle/oradata/king/redo01a.log','/u01/app/oracle/oradata/king/redo01b.log')
size?50M;


SQL>?alter?database?drop?logfile?group?2;

SQL>?host?rm?-rf?/u01/app/oracle/oradata/king/redo02.log

SQL>?alter?database?add?logfile?group?2
('/u01/app/oracle/oradata/king/redo02a.log','/u01/app/oracle/oradata/king/redo02b.log')
size?50M;


SQL>?alter?system?switch?logfile;

SQL>?alter?system?checkpoint;


SQL>?alter?database?drop?logfile?group?3;

SQL>?host?rm?-rf?/u01/app/oracle/oradata/king/redo03.log

SQL>?alter?database?add?logfile?group?3
('/u01/app/oracle/oradata/king/redo03a.log','/u01/app/oracle/oradata/king/redo03b.log')
size?50M;


SQL>?select?group#,member?from?v$logfile;
????GROUP#?Status????TS?Type?????????MEMBER
----------?---------?---------------?--------------------------------------------------
?????????3???????????ONLINE??????????/u01/app/oracle/oradata/king/redo03a.log
?????????2???????????ONLINE??????????/u01/app/oracle/oradata/king/redo02a.log
?????????1???????????ONLINE??????????/u01/app/oracle/oradata/king/redo01a.log
?????????1???????????ONLINE??????????/u01/app/oracle/oradata/king/redo01b.log
?????????2???????????ONLINE??????????/u01/app/oracle/oradata/king/redo02b.log
?????????3???????????ONLINE??????????/u01/app/oracle/oradata/king/redo03b.log


SQL>?select?group#,archived?from?v$log;
????GROUP#??SEQUENCE#????MEMBERS??????BYTES?Status????ARCHIVED
----------?----------?----------?----------?---------?---------
?????????1??????????7??????????2???52428800?CURRENT???NO
?????????2??????????0??????????2???52428800?UNUSED????YES
?????????3??????????0??????????2???52428800?UNUSED????YES

(编辑:李大同)

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

    推荐文章
      热点阅读