Data guard 问题请教
主库上切换日志时,alert.log报错:
[PHP]
Thu Apr 20 15:58:59 2006
Errors in file /oracle/admin/mktdb/bdump/mktdb_arc0_23022.trc:
ORA-16401: archivelog rejected by RFS
....................
[/PHP]
vi /oracle/admin/mktdb/bdump/mktdb_arc0_23022.trc却并没有这个trace文件。
查询standby上没有RFS进程:
[PHP]
SQL> select process, status from v$managed_standby;
PROCESS STATUS
------- ------------
ARCH CONNECTED
ARCH CONNECTED
MRP0 WAIT_FOR_LOG
3 rows selected.
[/PHP]
主库一共有两个Standby, 另外一个正常,请问有人遇见过这种问题吗?有什么建议?谢谢。
OS: SunOS 5.9
DB: Oracle 10.2.0.1
Data, 日志, file, archivelog, trace
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(9)
wo ye bu dong a
请把你的primary and standby 参数文件贴出来看看,帮你分析一下。RFS是建好standby后必须起的后台进程之一。
没有trace文件可能是因为之前就写入过这个文件,而这个文件又被删除了,现在再往这个文件里写,那就是null了
SQL> select process,status from v$managed_standby;
PROCESS STATUS
--------- ------------
ARCH CONNECTED
ARCH CONNECTED
ARCH CONNECTED
ARCH CONNECTED
ARCH CONNECTED
ARCH CONNECTED
ARCH CONNECTED
ARCH CONNECTED
ARCH CONNECTED
ARCH CONNECTED
ARCH CONNECTED
PROCESS STATUS
--------- ------------
ARCH CONNECTED
ARCH CONNECTED
ARCH CONNECTED
ARCH CONNECTED
ARCH CONNECTED
ARCH CONNECTED
ARCH CONNECTED
ARCH CONNECTED
ARCH CONNECTED
ARCH CONNECTED
ARCH CONNECTED
PROCESS STATUS
--------- ------------
ARCH CONNECTED
ARCH CONNECTED
ARCH CONNECTED
ARCH CONNECTED
ARCH CONNECTED
ARCH CONNECTED
ARCH CONNECTED
ARCH CONNECTED
MRP0 WAIT_FOR_LOG
RFS IDLE
RFS IDLE
PROCESS STATUS
--------- ------------
RFS IDLE
RFS IDLE
RFS IDLE
RFS IDLE
RFS IDLE
RFS IDLE
RFS IDLE
RFS IDLE
RFS IDLE
RFS IDLE
RFS IDLE
PROCESS STATUS
--------- ------------
RFS IDLE
RFS IDLE
RFS IDLE
RFS IDLE
RFS IDLE
RFS IDLE
RFS IDLE
RFS IDLE
RFS IDLE
RFS IDLE
RFS IDLE
PROCESS STATUS
--------- ------------
RFS IDLE
RFS IDLE
RFS IDLE
RFS IDLE
Thu Sep 20 03:44:30 2007
Errors in file /u01/oracle/admin/shark/bdump/shark_arcg_6569.trc:
ORA-16401: archivelog rejected by RFS
重新启动了,alert.log没有报错,但还是没有RFS进程
从库的RFS不存在?那日志流也就过不去那边了
可以把从库启动一遍么?
可是现在归档过不去啊,一switch logfile 就报这个错
16401, 00000, "archivelog rejected by RFS"
// *Cause: An attempt was made to re-archive an existing archivelog.
// This usually happens because either a multiple primary database or
// standby database(s) or both are trying to archive to
// this standby database.
// *Action: See alert log and trace file for more details.
// No action is necessary; this is an informational statement provided
// to record the event for diagnostic purposes.
应该不用做动作吧。