备用数据的问题集锦

1密码文件不一样导致备用数据库不可用
2log_archive_dest_state_2= enable 以前是reset,导致没有rfs不能应用日志[物理备库RFS进程消失]http://www.java123.net/v/956505.html
3备用重做日志大小和主库联机重做日志大小不一样导致可以进行日志切换应用，不能实时应用[Rfs[2]: no standby redo logfiles of size 153600 blocks available]
http://blog.itpub.net/23135684/viewspace-703620/
4.关闭防火墙




WARNING ORA-16714: the value of property LogArchiveMaxProcesses is inconsistent with the database setting
show database orcl11g inconsistentproperties
edit database orcl11g set property logarchivemaxprocesses=10;

---------------------------------------
1.NOT ALLOWED - ---Either this is a standby database and the primary database has not been switched first, or this is a primary database and there are no standby databases.这是一个备用数据库与主数据库还没有切换第一,或这是一个主数据库,没有备用数据库。
2.SESSIONS ACTIVE - ---Indicates that there are active SQL sessions attached to the primary or standby datab