This discussion is archived
5 Replies Latest reply: Jan 14, 2013 10:58 PM by vk82 RSS

Physical Standby Configuration Issue

vk82 Explorer
Currently Being Moderated
Hi All,


DB Version:10.2.0
OS Version:Windows


I am trying to create Physical standby DB on the same machine where my pri db is running for testing purpose. I am following the Official Doc for configuring the physical standby

docs.oracle.com/cd/B19306_01/server.102/b14239/create_ps.htm

But this time what happens with me when i configure all the things as per the doc and issue

SQL>ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION; on standby

what i saw redo files redo01,redo02,redo03 are generated again in standby folder which already contains standby logfiles. And this gnerates an error of unable to read file redo03.log on the standby path when i check the aler log files of standby db.below are my pfile for sec db:


*.audit_file_dest='E:\oracle\product\10.2.0\admin\pak\adump'
*.background_dump_dest='E:\oracle\product\10.2.0\admin\pak\bdump'
*.compatible='10.2.0.1.0'
*.control_files='E:\oracle\product\10.2.0\oradata\pak\control01.ctl'
*.core_dump_dest='E:\oracle\product\10.2.0\admin\pak\cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_file_name_convert='india','pak'
*.db_name='india'
*.db_recovery_file_dest='E:\oracle\product\10.2.0/flash_recovery_area'
*.db_recovery_file_dest_size=2147483648
*.db_unique_name=pak
*.dispatchers='(PROTOCOL=TCP) (SERVICE=indiaXDB)'
*.fal_client=pak
*.fal_server=india
*.job_queue_processes=10
*.log_archive_config='DG_CONFIG=(india,pak)'
*.log_archive_dest_1='LOCATION=E:\oracle\product\10.2.0\flash_recovery_area\pak\ VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=pak'
*.log_archive_dest_2='SERVICE=india LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=india'
*.log_archive_dest_state_1='ENABLE'
*.log_archive_dest_state_2='ENABLE'
*.log_file_name_convert='E:\oracle\product\10.2.0\oradata\india\','E:\oracle\product\10.2.0\oradata\pak'
*.open_cursors=300
*.pga_aggregate_target=92274688
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=278921216
*.standby_file_management='AUTO'
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='E:\oracle\product\10.2.0\admin\pak\udump'


Kindly help me what i need to do
Thanks all in advance

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points