RAC环境下修改归档模式(三)
-->归档当前日志,注意该命令在单实例下等同于alter system switch logfile
-->在rac环境下则不同，那就是所有实例上的current日志都将会被归档
SQL> alter system archive log current;
System altered.
-->下面的查询正好验证了上面的描述
-->日志62与44正是刚刚上面的命令同时产生的归档日志
SQL> select inst_id,name,thread#,sequence#,status from gv$archived_log;
INST_ID NAME THREAD# SEQUENCE# S
---------- ----------------------------------------------------------------- ---------- ---------- -
2 +REV/ora10g/archivelog/2012_12_24/thread_1_seq_61.459.802892953 1 61 A
2 +REV/ora10g/archivelog/2012_12_24/thread_2_seq_43.458.802893283 2 43 A
2 +REV/ora10g/archivelog/2012_12_24/thread_2_seq_44.456.802894343 2 44 A
2 +REV/ora10g/archivelog/2012_12_24/thread_1_seq_62.457.802894341 1 62 A
1 +REV/ora10g/archivelog/2012_12_24/thread_1_seq_61.459.802892953 1 61 A
1 +REV/ora10g/archivelog/2012_12_24/thread_2_seq_43.458.802893283 2 43 A
1 +REV/ora10g/archivelog/2012_12_24/thread_2_seq_44.456.802894343 2 44 A
1 +REV/ora10g/archivelog/2012_12_24/thread_1_seq_62.457.802894341 1 62 A
8 rows selected.
来源 http://blog.csdn.net/robinson_0612/article/details/8446304