Why there's only one RFS Process in v$managed_standby?
798430Sep 17 2010 — edited Sep 21 2010We build a standby server using Oracle Dataguard 10g.
Steps for starting this server are :
SQL> STARTUP NOMOUNT;
SQL> ALTER DATABASE MOUNT STANDBY DATABASE;
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;
when we list the process on v$managed_standby using
SQL> SELECT PROCESS, STATUS, THREAD#, SEQUENCE#, BLOCK#, BLOCKS FROM V$MANAGED_STANDBY;
the result is
PROCESS STATUS THREAD# SEQUENCE# BLOCK# BLOCKS
--------- ------------ ---------- ---------- ---------- ----------
ARCH CONNECTED 0 0 0 0
ARCH CONNECTED 0 0 0 0
MRP0 WAIT_FOR_LOG 1 81 0 0
RFS IDLE 0 0 0 0
There's only one RFS process. Whereas, when I read articles about ODG, they mention that there are two processes of RFS.
How to create the another RFS process? What parameters should be define?
Thanks alot
Regards,
May
Notes: init.ora
SID.__db_cache_size=2231369728
*._B_TREE_BITMAP_PLANS=FALSE
*._bloom_filter_enabled=FALSE
*._fix_control='4728348:OFF','5705630:ON'
*._IN_MEMORY_UNDO=FALSE
*._INDEX_JOIN_ENABLED=FALSE
*._OPTIM_PEEK_USER_BINDS=FALSE
*._OPTIMIZER_MJC_ENABLED=FALSE
*._SORT_ELIMINATION_COST_RATIO=10
*._table_lookup_prefetch_size=0
*.background_dump_dest='/oracle/SID/saptrace/background'
*.compatible='10.2.0'
*.control_file_record_keep_time=30
*.control_files='/oracle/SID/origlogA/cntrl/cntrlSID.dbf','/oracle/SID/origlogB/cntrl/cntrlSID.dbf','/oracle/SID/sapdata1/cntrl/cntrlSID.dbf'
*.core_dump_dest='/oracle/SID/saptrace/background'
*.db_block_size=8192
*.db_cache_size=3383296000
*.db_files=354
*.db_name='SID'
*.dml_locks=4000
*.event='10027 trace name context forever, level 1','10028 trace name context forever, level 1','10162 trace name context forever, level 1','10183 trace name
context forever, level 1','10191 trace name context forever, level 1','10629 trace name context forever, level 32','10891 trace name context forever, level
1','14532 trace name context forever, level 1','38068 trace name context forever, level 100','38087 trace name context forever, level 1','44951 trace name co
ntext forever, level 1024'
*.FILESYSTEMIO_OPTIONS='setall'
*.job_queue_processes=1
#*.log_archive_dest='/oracle/SID/oraarch/SIDarch'
*.log_buffer=1048576
*.log_checkpoint_interval=0
*.log_checkpoints_to_alert=true
*.max_dump_file_size='20000'
*.open_cursors=800
*.optimizer_index_cost_adj=20
*.parallel_execution_message_size=16384
*.parallel_threads_per_cpu=1
*.pga_aggregate_target=3435973837
*.processes=160
*.query_rewrite_enabled='false'
*.recyclebin='off'
*.remote_login_passwordfile='exclusive'
*.remote_os_authent=true
*.replication_dependency_tracking=false
*.sessions=320
*.sga_max_size=5670000000
*.shared_pool_size=2228685373
*.sort_area_retained_size=0
*.sort_area_size=2097152
*.star_transformation_enabled='true'
*.undo_management='AUTO'
*.undo_retention=43200
*.undo_tablespace='PSAPUNDO'
*.user_dump_dest='/oracle/SID/saptrace/usertrace'
#DATA GUARD CONFIGURATION FOR STANDBY DATABASE
*.log_archive_dest_1='LOCATION=/oracle/SID/oraarch/SIDarch'
*.log_archive_dest_state_1=enable
*.log_archive_format=SIDarch%t_%s_%r.dbf
*.standby_archive_dest=/oracle/SID/oraarch/SIDarch
*.fal_server=prim-server
*.fal_client=stan-server