Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Why there's only one RFS Process in v$managed_standby?

798430Sep 17 2010 — edited Sep 21 2010
We 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
This post has been answered by baskar.l on Sep 19 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 19 2010
Added on Sep 17 2010
6 comments
2,549 views