RAC归档问题！

buptdream · 发表于 2012-5-4 10:31

测试了一下，应该是出现了ORA-16009: invalid redo transport destination的错误提示

myfriend2010 · 发表于 2012-5-4 10:33

这几个参数中，看不到什么，需要再查下相关的动态性能表！

我本地试一下！！

myfriend2010 · 发表于 2012-5-4 11:45

LZ如何看到另外一个节点没有同步归档日志呢？

buptdream · 发表于 2012-5-4 13:06

myfriend2010 发表于 2012-5-4 11:45
LZ如何看到另外一个节点没有同步归档日志呢？

他说在另外一个目录下看不到传递过来的日志啊，我测试好像也出现这个问题呢了

myfriend2010 · 发表于 2012-5-4 13:09

我这边刚试了，没问题，不过我没配置service=...
而是
log_archive_dest_1 location=/arch_wk/ltaiswk1
log_archive_dest_2 location=/arch_wk/ltaiswk2
等会儿试下 service=什么的

buptdream · 发表于 2012-5-4 13:37

myfriend2010 发表于 2012-5-4 13:09
我这边刚试了，没问题，不过我没配置service=...
而是
log_archive_dest_1 location=/arch_wk/ltaiswk1

这个是没问题的，关键就在于service上，你试一下

buptdream · 发表于 2012-5-4 14:49

stevenzjds 发表于 2012-4-6 12:31
已经解决了。。原来网上的书上的东西，很多不能全信啊！忽悠人

如何解决的，文档错在什么地方，指点一下

myfriend2010 · 发表于 2012-5-4 16:44

我这边测试了一下，没问题！等下贴上测试过程

myfriend2010 · 发表于 2012-5-4 16:44

1、停止节点2(略)
2、登陆节点1，如下操作，配置归档日志
SQL> archive log list;
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination /oracle/product/10.2.0/db/dbs/arch
Oldest online log sequence 61
Current log sequence 62
SQL> show parameter log_archive
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_config string
log_archive_dest string
log_archive_dest_1 string
log_archive_dest_10 string
log_archive_dest_2 string
log_archive_dest_3 string
log_archive_dest_4 string
log_archive_dest_5 string
log_archive_dest_6 string
log_archive_dest_7 string
log_archive_dest_8 string
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_9 string
log_archive_dest_state_1 string enable
log_archive_dest_state_10 string enable
log_archive_dest_state_2 string enable
log_archive_dest_state_3 string enable
log_archive_dest_state_4 string enable
log_archive_dest_state_5 string enable
log_archive_dest_state_6 string enable
log_archive_dest_state_7 string enable
log_archive_dest_state_8 string enable
log_archive_dest_state_9 string enable
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_duplex_dest string
log_archive_format string %t_%s_%r.dbf
log_archive_local_first boolean TRUE
log_archive_max_processes integer 2
log_archive_min_succeed_dest integer 1
log_archive_start boolean FALSE
log_archive_trace integer 0
SQL> alter system set log_archive_dest_1='LOCATION=+TEST_DISK/arch1' sid='ltais1';
System altered.
SQL> alter system set log_archive_dest_1='LOCATION=+TEST_DISK/arch2' sid='ltais2';
System altered.
SQL> show parameter log_archive
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_config string
log_archive_dest string
log_archive_dest_1 string LOCATION=+TEST_DISK/arch1
log_archive_dest_10 string
log_archive_dest_2 string
log_archive_dest_3 string
log_archive_dest_4 string
log_archive_dest_5 string
log_archive_dest_6 string
log_archive_dest_7 string
log_archive_dest_8 string
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_9 string
log_archive_dest_state_1 string enable
log_archive_dest_state_10 string enable
log_archive_dest_state_2 string enable
log_archive_dest_state_3 string enable
log_archive_dest_state_4 string enable
log_archive_dest_state_5 string enable
log_archive_dest_state_6 string enable
log_archive_dest_state_7 string enable
log_archive_dest_state_8 string enable
log_archive_dest_state_9 string enable
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_duplex_dest string
log_archive_format string %t_%s_%r.dbf
log_archive_local_first boolean TRUE
log_archive_max_processes integer 2
log_archive_min_succeed_dest integer 1
log_archive_start boolean FALSE
log_archive_trace integer 0
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.
Total System Global Area 167772160 bytes
Fixed Size 1218316 bytes
Variable Size 79694068 bytes
Database Buffers 83886080 bytes
Redo Buffers 2973696 bytes
Database mounted.
SQL> alter database archivelog;
Database altered.
SQL> alter database open;
Database altered.
3、启动节点2(略)
4、切换日志，检查归档(alter system archive log current; )略

复制代码

myfriend2010 · 发表于 2012-5-4 16:45

本帖最后由 myfriend2010 于 2012-5-4 16:46 编辑

现在是重点，配置log_archive_dest_2

5、停止节点2(略)，在节点1上配置log_archive_dest_2
SQL> show parameter archiveNAME TYPE VALUE
------------------------------------ ----------- ------------------------------
archive_lag_target integer 0
log_archive_config string
log_archive_dest string
log_archive_dest_1 string LOCATION=+TEST_DISK/arch1
log_archive_dest_10 string
log_archive_dest_2 string
log_archive_dest_3 string
log_archive_dest_4 string
log_archive_dest_5 string
log_archive_dest_6 string
log_archive_dest_7 stringNAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_8 string
log_archive_dest_9 string
log_archive_dest_state_1 string enable
log_archive_dest_state_10 string enable
log_archive_dest_state_2 string enable
log_archive_dest_state_3 string enable
log_archive_dest_state_4 string enable
log_archive_dest_state_5 string enable
log_archive_dest_state_6 string enable
log_archive_dest_state_7 string enable
log_archive_dest_state_8 string enableNAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_state_9 string enable
log_archive_duplex_dest string
log_archive_format string %t_%s_%r.dbf
log_archive_local_first boolean TRUE
log_archive_max_processes integer 2
log_archive_min_succeed_dest integer 1
log_archive_start boolean FALSE
log_archive_trace integer 0
remote_archive_enable string true
standby_archive_dest string ?/dbs/arch
SQL> show parameter inst NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
active_instance_count integer
cluster_database_instances integer 2
instance_groups string
instance_name string ltais1
instance_number integer 1
instance_type string RDBMS
open_links_per_instance integer 4
parallel_instance_group string
parallel_server_instances integer 2
SQL> alter system set log_archive_dest_2='SERVICE=ltais2' sid='ltais1'; System altered.SQL> alter system set log_archive_dest_2='SERVICE=ltais1' sid='ltais2';System altered.SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.Total System Global Area 167772160 bytes
Fixed Size 1218316 bytes
Variable Size 79694068 bytes
Database Buffers 83886080 bytes
Redo Buffers 2973696 bytes
Database mounted.
Database opened.6、启动节点2(略)7、切换日之前，检查归档日志
ASMCMD> cd ../arch2
ASMCMD> ls -ltr
Type Redund Striped Time Sys Name
N 1_63_766000402.dbf => +TEST_DISK/LTAIS/ARCHIVELOG/2009_05_05/thread_1_seq_63.259.686074179
N 1_64_766000402.dbf => +TEST_DISK/LTAIS/ARCHIVELOG/2009_05_05/thread_1_seq_64.263.686074241
N 2_95_766000402.dbf => +TEST_DISK/LTAIS/ARCHIVELOG/2009_05_05/thread_2_seq_95.260.686074179
N 2_96_766000402.dbf => +TEST_DISK/LTAIS/ARCHIVELOG/2009_05_05/thread_2_seq_96.264.686074243
ASMCMD> cd ../arch1
ASMCMD> ls -ltr这里可以看到在../arch2下有4个文件，arch1下没有文件8、在节点1下切换归档日志
SQL> alter system archive log current;System altered.9、检查归档日志ASMCMD> ls -ltr
Type Redund Striped Time Sys Name
N 1_65_766000402.dbf => +TEST_DISK/LTAIS/ARCHIVELOG/2009_05_05/thread_1_seq_65.258.686077777
N 2_97_766000402.dbf => +TEST_DISK/LTAIS/ARCHIVELOG/2009_05_05/thread_2_seq_97.261.686077779
N 1_63_766000402.dbf => +TEST_DISK/LTAIS/ARCHIVELOG/2009_05_05/thread_1_seq_63.259.686074179
N 1_64_766000402.dbf => +TEST_DISK/LTAIS/ARCHIVELOG/2009_05_05/thread_1_seq_64.263.686074241
N 2_95_766000402.dbf => +TEST_DISK/LTAIS/ARCHIVELOG/2009_05_05/thread_2_seq_95.260.686074179
N 2_96_766000402.dbf => +TEST_DISK/LTAIS/ARCHIVELOG/2009_05_05/thread_2_seq_96.264.686074243
ASMCMD> cd ../arch1
ASMCMD> ls -ltr
Type Redund Striped Time Sys Name
N 1_65_766000402.dbf => +TEST_DISK/LTAIS/ARCHIVELOG/2009_05_05/thread_1_seq_65.262.686078663
N 2_97_766000402.dbf => +TEST_DISK/LTAIS/ARCHIVELOG/2009_05_05/thread_2_seq_97.257.686078661
这里可以看到，每个目录下都多了2个文件，分别为1_65_766000402.dbf、2_97_766000402.dbf

复制代码

[参数设置] RAC归档问题！