如何在RAC中看某个LOG是否是私有的

显示全部楼层 · 2006-2-12 01:02:47

我在我的集群中给INSTANCE 1建立了LOGFILE 5
ALTER DATABASE ADD LOGFILE THREAD 1 GROUP 5 '/u01/oracle/oradata/tired/redo05.log'SIZE 1024k

但是，我在实际中发现使用
SELECT * FROM Gv$LOGFILE查询，并不可以得到是LOGFILE 5是INSTANCE 1的私有REDO LOG
2,1,,ONLINE,/u01/oracle/oradata/tired/redo01.LOG
2,2,,ONLINE,/u01/oracle/oradata/tired/redo02.LOG
2,3,,ONLINE,/u01/oracle/oradata/tired/redo03.LOG
2,4,,ONLINE,/u01/oracle/oradata/tired/tired_redo2_2.LOG
2,5,,ONLINE,/u01/oracle/oradata/tired/redo05.LOG
1,1,,ONLINE,/u01/oracle/oradata/tired/redo01.LOG
1,2,,ONLINE,/u01/oracle/oradata/tired/redo02.LOG
1,3,,ONLINE,/u01/oracle/oradata/tired/redo03.LOG
1,4,,ONLINE,/u01/oracle/oradata/tired/tired_redo2_2.LOG
1,5,,ONLINE,/u01/oracle/oradata/tired/redo05.LOG

千问 · 2006-2-12 01:02:47

在RAC中很多东西可以共享,但是就是ONLINE REDO LOG文件不共享!

千问 · 2006-2-12 01:02:47

最初由儿子属羊发布
[B]在RAC中很多东西可以共享,但是就是ONLINE REDO LOG文件不共享! [/B]

我没有共享LOGFILE 5，但是为什么会是这样的呢

2,1,,ONLINE,/u01/oracle/oradata/tired/redo01.LOG
2,2,,ONLINE,/u01/oracle/oradata/tired/redo02.LOG
2,3,,ONLINE,/u01/oracle/oradata/tired/redo03.LOG
2,4,,ONLINE,/u01/oracle/oradata/tired/tired_redo2_2.LOG
2,5,,ONLINE,/u01/oracle/oradata/tired/redo05.LOG
1,1,,ONLINE,/u01/oracle/oradata/tired/redo01.LOG
1,2,,ONLINE,/u01/oracle/oradata/tired/redo02.LOG
1,3,,ONLINE,/u01/oracle/oradata/tired/redo03.LOG
1,4,,ONLINE,/u01/oracle/oradata/tired/tired_redo2_2.LOG
1,5,,ONLINE,/u01/oracle/oradata/tired/redo05.LOG

千问 · 2006-2-12 01:02:47

2,1,,ONLINE,/u01/oracle/oradata/tired/redo01.LOG
2,2,,ONLINE,/u01/oracle/oradata/tired/redo02.LOG
2,3,,ONLINE,/u01/oracle/oradata/tired/redo03.LOG
2,4,,ONLINE,/u01/oracle/oradata/tired/tired_redo2_2.LOG
2,5,,ONLINE,/u01/oracle/oradata/tired/redo05.LOG
1,1,,ONLINE,/u01/oracle/oradata/tired/redo01.LOG
1,2,,ONLINE,/u01/oracle/oradata/tired/redo02.LOG
1,3,,ONLINE,/u01/oracle/oradata/tired/redo03.LOG
1,4,,ONLINE,/u01/oracle/oradata/tired/tired_redo2_2.LOG
1,5,,ONLINE,/u01/oracle/oradata/tired/redo05.LOG
前面的1，2不就代表是属于哪一个INSTANCE的了吗？

千问 · 2006-2-12 01:02:47

最初由 panda_blue 发布
[B]2,1,,ONLINE,/u01/oracle/oradata/tired/redo01.LOG
2,2,,ONLINE,/u01/oracle/oradata/tired/redo02.LOG
2,3,,ONLINE,/u01/oracle/oradata/tired/redo03.LOG
2,4,,ONLINE,/u01/oracle/oradata/tired/tired_redo2_2.LOG
2,5,,ONLINE,/u01/oracle/oradata/tired/redo05.LOG
1,1,,ONLINE,/u01/oracle/oradata/tired/redo01.LOG
1,2,,ONLINE,/u01/oracle/oradata/tired/redo02.LOG
1,3,,ONLINE,/u01/oracle/oradata/tired/redo03.LOG
1,4,,ONLINE,/u01/oracle/oradata/tired/tired_redo2_2.LOG
1,5,,ONLINE,/u01/oracle/oradata/tired/redo05.LOG
前面的1，2不就代表是属于哪一个INSTANCE的了吗？ [/B]

但是，我这个明明是私人的REDO LOG，是建立给INSTANCE 1，但是为什么会出现
2,5,,ONLINE,/u01/oracle/oradata/tired/redo05.LOG
1,5,,ONLINE,/u01/oracle/oradata/tired/redo05.LOG
的情况呢

千问 · 2006-2-12 01:02:47

嗯,我也想过这个问题

千问 · 2006-2-12 01:02:47

Online redo log is not sharable but need put in the shared disk area for recover purpose. So better have a instance name included in the path like ..../oradata/instance_name/redo5.log to identify which log is belong to which instance. It looks like your redo logs in a local disk that is not a shared disk. Try gv$log to find the current one of each instance.

千问 · 2006-2-12 01:02:47

觉得楼主要看视图
select * from v$log
就会明白的

千问 · 2006-2-12 01:02:47

最初由 akuan 发布
[B]Online redo log is not sharable but need put in the shared disk area for recover purpose. So better have a instance name included in the path like ..../oradata/instance_name/redo5.log to identify which log is belong to which instance. It looks like your redo logs in a local disk that is not a shared disk. Try gv$log to find the current one of each instance. [/B]
redo log 放在本地盘和共享盘有区别吗？instance能够访问到不就可以了吗？