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 (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |
相关内容
- 正则表达式中的特殊符号 及实例
- ruby-on-rails-3 – Rails – 401当我在生产中访问操作时未
- c# – 如何调试缓慢的Office应用程序interop构造函数?
- c# – 实体框架中的异步查询和延迟加载
- 在高隆锁定外部依赖关系“版本”的最有效方式是什么?
- 设计模式六大原则(2):里氏替换原则(Liskov Substitutio
- c# – Unity – InjectionProperty导致null属性?
- ruby-on-rails – EOFError:文件结束 – 所有js规格都在使
- objective-c – 将self属性传递给block时的ARC实现
- 另一个“读取XML数据时已超出最大字符串内容长度配额(8192)