5 Replies Latest reply: Jan 15, 2013 12:58 AM by 817202 RSS

    Physical Standby Configuration Issue

    817202
      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