Oracle Database 联机日志文件管理

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

（编辑：李大同）

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