oracle10g rac三个日志,ORACLE 10G RAC 归档日志问题 - Oracle数据库管理 - Oracle数据库数据恢复、性能优化来问问AskMaclean - Parnassus...

环境：linux5.5 x86_64

ORACLE 10.2.0.4   RAC

问题描述：新开局数据库，按照下面操作，想把归档日志放到ASM上：

调整归档日志路径

sql>startup mount

sql>alter system set log_archive_dest_1='LOCATION=+DATA' scope=spfile sid='prod1';

sql>alter system set log_archive_dest_1='LOCATION=+DATA' scope=spfile sid='prod2';

调整归档日志文件命名方式

sql>alter system set log_archive_format ='arch1_%s_%R_%T.arc' scope=spfile sid='prod1';

sql>alter system set log_archive_format ='arch2_%s_%R_%T.arc' scope=spfile sid='prod2';

开启归档日志

sql>alter database archivelog

sql>alter database open

过了几天发现：归档日志都分别在两个节点的本地磁盘上存放着。很奇怪。我也是新手，接触rac的机会很少，求大神，给我看一下。非常感谢！

SQL> archive log list

Database log mode              Archive Mode

Automatic archival             Enabled

Archive destination            /u01/oracle/product/10.2.0/db_1/dbs/arch

Oldest online log sequence     6

Next log sequence to archive   8

Current log sequence           8

SQL> select name,sequence#,first_change# from v$archived_log;

NAME

--------------------------------------------------------------------------------

SEQUENCE# FIRST_CHANGE#

---------- -------------

4       2090539

4       1621987

5       2396167

NAME

--------------------------------------------------------------------------------

SEQUENCE# FIRST_CHANGE#

---------- -------------

5       2396423

6       2406901

/u01/oracle/product/10.2.0/db_1/dbs/arch2_6_832868919.dbf

6       2406904

NAME

--------------------------------------------------------------------------------

SEQUENCE# FIRST_CHANGE#

---------- -------------

4       1621987

5       2396423

7       2407537

NAME

--------------------------------------------------------------------------------

SEQUENCE# FIRST_CHANGE#

---------- -------------

/u01/oracle/product/10.2.0/db_1/dbs/arch2_7_832868919.dbf

7       2407539