实验环境: redhat linux 5.5 x86_64
[root@node1 ~]# lsb_release -a
LSB Version: :core-3.1-amd64:core-3.1-ia32:core-3.1-noarch:graphics-3.1-amd64:graphics-3.1-ia32:graphics-3.1-noarch
Distributor ID: RedHatEnterpriseServer
Description: Red Hat Enterprise Linux Server release 5(Tikanga)
Release: 5
Codename: Tikanga
[root@node1 ~]# uname -a
Linux node1 2.6.18-194.el5 #1 SMP Tue Mar 16 21:52:39 EDT 2010 x86_64 x86_64 x86_64 GNU/Linux
[root@node1 ~]#
实验:
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIM
---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ---------
1 1 22 52428800 2 NO CURRENT 1258406 23-AUG-15
2 1 21 52428800 2 YES INACTIVE 1258295 23-AUG-15
3 2 23 52428800 2 YES INACTIVE 1258408 23-AUG-15
4 2 24 52428800 2 NO CURRENT 1281241 24-AUG-15
----
SQL> alter system archive log current;
System altered.
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIM
---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ---------
1 1 22 52428800 2 YES ACTIVE 1258406 23-AUG-15
2 1 23 52428800 2 NO CURRENT 1288330 25-AUG-15
3 2 25 52428800 2 NO CURRENT 1288332 25-AUG-15
4 2 24 52428800 2 YES ACTIVE 1281241 24-AUG-15
总结:rac环境中,在任何一个节点执行:aler system archive log current; 操作,将触发所有节点的arch进程归档当前的redo logfile,同时切换日志组。
[root@node1 ~]# lsb_release -a
LSB Version: :core-3.1-amd64:core-3.1-ia32:core-3.1-noarch:graphics-3.1-amd64:graphics-3.1-ia32:graphics-3.1-noarch
Distributor ID: RedHatEnterpriseServer
Description: Red Hat Enterprise Linux Server release 5(Tikanga)
Release: 5
Codename: Tikanga
[root@node1 ~]# uname -a
Linux node1 2.6.18-194.el5 #1 SMP Tue Mar 16 21:52:39 EDT 2010 x86_64 x86_64 x86_64 GNU/Linux
[root@node1 ~]#
实验:
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIM
---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ---------
1 1 22 52428800 2 NO CURRENT 1258406 23-AUG-15
2 1 21 52428800 2 YES INACTIVE 1258295 23-AUG-15
3 2 23 52428800 2 YES INACTIVE 1258408 23-AUG-15
4 2 24 52428800 2 NO CURRENT 1281241 24-AUG-15
----
SQL> alter system archive log current;
System altered.
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIM
---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ---------
1 1 22 52428800 2 YES ACTIVE 1258406 23-AUG-15
2 1 23 52428800 2 NO CURRENT 1288330 25-AUG-15
3 2 25 52428800 2 NO CURRENT 1288332 25-AUG-15
4 2 24 52428800 2 YES ACTIVE 1281241 24-AUG-15
总结:rac环境中,在任何一个节点执行:aler system archive log current; 操作,将触发所有节点的arch进程归档当前的redo logfile,同时切换日志组。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29249734/viewspace-1781624/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29249734/viewspace-1781624/