InstallationOracle11gR2RAC---修改在线日志
连接数据库服务器，查询现有在线日志组信息并添加在线日志组。
成都创新互联公司专注于建水企业网站建设,自适应网站建设,成都做商城网站。建水网站建设公司,为建水等地区提供建站服务。全流程定制网站开发，专业设计，全程项目跟踪，成都创新互联公司专业和态度为您提供的服务
Connected to Oracle Database 11g Enterprise Edition Release 11.2.0.4.0
Connected as system
SQL> select * from v$logfile;
GROUP# STATUS TYPE MEMBER IS_RECOVERY_DEST_FILE
---------- ------- ------- ------------------------------------------------- ---------------------
2 ONLINE +DATA/oracle/onlinelog/group_2.262.900549871 NO
2 ONLINE +FRA/oracle/onlinelog/group_2.258.900549873 YES
1 ONLINE +DATA/oracle/onlinelog/group_1.261.900549865 NO
1 ONLINE +FRA/oracle/onlinelog/group_1.257.900549867 YES
3 ONLINE +DATA/oracle/onlinelog/group_3.265.900550437 NO
3 ONLINE +FRA/oracle/onlinelog/group_3.259.900550441 YES
4 ONLINE +DATA/oracle/onlinelog/group_4.266.900550445 NO
4 ONLINE +FRA/oracle/onlinelog/group_4.260.900550449 YES
8 rows selected
添加新的日志组文件
SQL> alter database add logfile thread 1 group 5 ('+DATA/oracle/onlinelog/group5','+FRA/oracle/onlinelog/group5') size 200M;
Database altered
SQL> alter database add logfile thread 2 group 6 ('+DATA/oracle/onlinelog/group6','+FRA/oracle/onlinelog/group6') size 200M;
Database altered
SQL> alter database add logfile thread 1 group 7 ('+DATA/oracle/onlinelog/group7','+FRA/oracle/onlinelog/group7') size 200M;
Database altered
SQL> alter database add logfile thread 2 group 8 ('+DATA/oracle/onlinelog/group8','+FRA/oracle/onlinelog/group8') size 200M;
Database altered
SQL> select * from v$logfile;
GROUP# STATUS TYPE MEMBER IS_RECOVERY_DEST_FILE
---------- ------- ------- ----------------------------------------------- ---------------------
2 ONLINE +DATA/oracle/onlinelog/group_2.262.900549871 NO
2 ONLINE +FRA/oracle/onlinelog/group_2.258.900549873 YES
1 ONLINE +DATA/oracle/onlinelog/group_1.261.900549865 NO
1 ONLINE +FRA/oracle/onlinelog/group_1.257.900549867 YES
3 ONLINE +DATA/oracle/onlinelog/group_3.265.900550437 NO
3 ONLINE +FRA/oracle/onlinelog/group_3.259.900550441 YES
4 ONLINE +DATA/oracle/onlinelog/group_4.266.900550445 NO
4 ONLINE +FRA/oracle/onlinelog/group_4.260.900550449 YES
5 ONLINE +DATA/oracle/onlinelog/group5 NO
5 ONLINE +FRA/oracle/onlinelog/group5 NO
6 ONLINE +DATA/oracle/onlinelog/group6 NO
6 ONLINE +FRA/oracle/onlinelog/group6 NO
7 ONLINE +DATA/oracle/onlinelog/group7 NO
7 ONLINE +FRA/oracle/onlinelog/group7 NO
8 ONLINE +DATA/oracle/onlinelog/group8 NO
8 ONLINE +FRA/oracle/onlinelog/group8 NO
16 rows selected
SQL> select thread#,group#,archived,status from v$log;
THREAD# GROUP# ARCHIVED STATUS
---------- ---------- -------- ----------------
1 1 NO CURRENT
1 2 YES INACTIVE
2 3 YES INACTIVE
2 4 NO CURRENT
1 5 YES UNUSED
2 6 YES UNUSED
1 7 YES UNUSED
2 8 YES UNUSED
8 rows selected
切换日志
SQL> alter system switch logfile;
System altered
SQL> alter system switch logfile;
System altered
SQL> alter system switch logfile;
System altered
SQL> alter system switch logfile;
System altered
SQL> alter system switch logfile;
System altered
SQL> select thread#,group#,archived,status from v$log;
THREAD# GROUP# ARCHIVED STATUS
---------- ---------- -------- ----------------
1 1 YES ACTIVE
1 2 YES ACTIVE
2 3 YES INACTIVE
2 4 YES ACTIVE
1 5 NO CURRENT
2 6 YES ACTIVE
1 7 YES INACTIVE
2 8 NO CURRENT
8 rows selected
SQL> select * from v$logfile;
GROUP# STATUS TYPE MEMBER IS_RECOVERY_DEST_FILE
---------- ------- ------- ----------------------------------------------- ---------------------
2 ONLINE +DATA/oracle/onlinelog/group_2.262.900549871 NO
2 ONLINE +FRA/oracle/onlinelog/group_2.258.900549873 YES
1 ONLINE +DATA/oracle/onlinelog/group_1.261.900549865 NO
1 ONLINE +FRA/oracle/onlinelog/group_1.257.900549867 YES
3 ONLINE +DATA/oracle/onlinelog/group_3.265.900550437 NO
3 ONLINE +FRA/oracle/onlinelog/group_3.259.900550441 YES
4 ONLINE +DATA/oracle/onlinelog/group_4.266.900550445 NO
4 ONLINE +FRA/oracle/onlinelog/group_4.260.900550449 YES
5 ONLINE +DATA/oracle/onlinelog/group5 NO
5 ONLINE +FRA/oracle/onlinelog/group5 NO
6 ONLINE +DATA/oracle/onlinelog/group6 NO
6 ONLINE +FRA/oracle/onlinelog/group6 NO
7 ONLINE +DATA/oracle/onlinelog/group7 NO
7 ONLINE +FRA/oracle/onlinelog/group7 NO
8 ONLINE +DATA/oracle/onlinelog/group8 NO
8 ONLINE +FRA/oracle/onlinelog/group8 NO
16 rows selected
SQL> select thread#,group#,archived,status from v$log;
THREAD# GROUP# ARCHIVED STATUS
---------- ---------- -------- ----------------
1 1 YES INACTIVE
1 2 YES INACTIVE
2 3 YES INACTIVE
2 4 YES INACTIVE
1 5 NO CURRENT
2 6 YES INACTIVE
1 7 YES INACTIVE
2 8 NO CURRENT
8 rows selected
删除原有在线日志组，同时物理文件也会自动删除。
SQL> alter database drop logfile group 1;
Database altered
SQL> alter database drop logfile group 2;
Database altered
SQL> alter database drop logfile group 3;
Database altered
SQL> alter database drop logfile group 4;
Database altered
SQL> select thread#,group#,archived,status from v$log;
THREAD# GROUP# ARCHIVED STATUS
---------- ---------- -------- ----------------
1 5 NO CURRENT
2 6 YES INACTIVE
1 7 YES INACTIVE
2 8 NO CURRENT
SQL> select * from v$logfile;
GROUP# STATUS TYPE MEMBER IS_RECOVERY_DEST_FILE
---------- ------- ------- --------------------------------- ---------------------
5 ONLINE +DATA/oracle/onlinelog/group5 NO
5 ONLINE +FRA/oracle/onlinelog/group5 NO
6 ONLINE +DATA/oracle/onlinelog/group6 NO
6 ONLINE +FRA/oracle/onlinelog/group6 NO
7 ONLINE +DATA/oracle/onlinelog/group7 NO
7 ONLINE +FRA/oracle/onlinelog/group7 NO
8 ONLINE +DATA/oracle/onlinelog/group8 NO
8 ONLINE +FRA/oracle/onlinelog/group8 NO
8 rows selected
SQL> /
GROUP# STATUS TYPE MEMBER IS_RECOVERY_DEST_FILE
---------- ------- ------- -------------------------------- ---------------------
5 ONLINE +DATA/oracle/onlinelog/group5 NO
5 ONLINE +FRA/oracle/onlinelog/group5 NO
6 ONLINE +DATA/oracle/onlinelog/group6 NO
6 ONLINE +FRA/oracle/onlinelog/group6 NO
7 ONLINE +DATA/oracle/onlinelog/group7 NO
7 ONLINE +FRA/oracle/onlinelog/group7 NO
8 ONLINE +DATA/oracle/onlinelog/group8 NO
8 ONLINE +FRA/oracle/onlinelog/group8 NO
8 rows selected
SQL> select thread#,group#,archived,status from v$log;
THREAD# GROUP# ARCHIVED STATUS
---------- ---------- -------- ----------------
1 5 NO CURRENT
2 6 YES INACTIVE
1 7 YES INACTIVE
2 8 NO CURRENT
SQL> alter system switch logfile;
System altered
SQL> /
System altered
SQL> /
System altered
SQL> /
System altered
SQL> /
System altered
SQL> select * from v$logfile;
GROUP# STATUS TYPE MEMBER IS_RECOVERY_DEST_FILE
---------- ------- ------- --------------------------------- ---------------------
5 ONLINE +DATA/oracle/onlinelog/group5 NO
5 ONLINE +FRA/oracle/onlinelog/group5 NO
6 ONLINE +DATA/oracle/onlinelog/group6 NO
6 ONLINE +FRA/oracle/onlinelog/group6 NO
7 ONLINE +DATA/oracle/onlinelog/group7 NO
7 ONLINE +FRA/oracle/onlinelog/group7 NO
8 ONLINE +DATA/oracle/onlinelog/group8 NO
8 ONLINE +FRA/oracle/onlinelog/group8 NO
8 rows selected
SQL> select thread#,group#,archived,status from v$log;
THREAD# GROUP# ARCHIVED STATUS
---------- ---------- -------- ----------------
1 5 YES ACTIVE
2 6 NO CURRENT
1 7 NO CURRENT
2 8 YES ACTIVE
SQL>
网站标题：InstallationOracle11gR2RAC---修改在线日志
分享路径：https://www.cdcxhl.com/article0/gsjhio.html
成都网站建设公司_创新互联，为您提供外贸建站、微信公众号、、品牌网站建设、自适应网站、企业网站制作
声明：本网站发布的内容（图片、视频和文字）以用户投稿、用户转载内容为主，如果涉及侵权请尽快告知，我们将会在第一时间删除。文章观点不代表本网站立场，如需处理请联系客服。电话：028-86922220；邮箱：631063699@qq.com。内容未经允许不得转载，或转载时需注明来源： 创新互联
- 如何区别动态网站和静态网站以及他们的特点 2021-05-25
- 动态网站是什么？动态好还是静态好 2014-12-09
- 动态网页是什么？4种动态网站技术介绍 2022-09-01
- 生成静态之静态缓存和动态缓存 2016-10-30
- 大型网站动态运用体系架构浅析 2016-12-07
- 公司网站制作有关动态网站的制作方法 2016-08-21
- 网站制作动态网站与静态网页的优劣势对比 2023-01-22
- 动态内容的平衡有妙招！ 2014-02-21
- 网站建设基础知识之静态和动态网站（一） 2016-09-16
- 网站安全措施应该选择什么样的动态程序和相应的数据库 2016-12-28
- 网站制作动态、静态页面哪种合适 2016-09-27
- 网站托管所说的动态网站是什么？ 2016-07-28