2 Replies Latest reply: Sep 10, 2013 7:24 AM by mseberg RSS

    Redo not transferred after changing host ip

    shipon_97

      Dear Friends ,

       

      We have to configure our dataguard on Oracle11g (11.2.0.3) with AIX6.1 platform . The dataguard configuration was working fine . But after 7 days of the server configuration  we have to move our dataguard server onto another location(At least 10 KM far away) and also change the physical IP of the Dataguard server .

       

      After changing ip and the physical location , when we connect the Dataguard server with PRIMARY server then we got the below errors onto our both PRIMARY and STANDBY nodes :

       

      PRIMARY alert log error :

      ====================

      Sat Sep 07 17:19:24 2013

      Deleted Oracle managed file /archivefs/AIBLDG/archivelog/2013_09_07/o1_mf_1_11929_92p2lk44_.arc

      WARN: ARCH: Terminating pid 10485860 hung on an I/O operation

      krsv_proc_kill: Killing 1 processes (Process by index)

      Deleted Oracle managed file /archivefs/AIBLDG/archivelog/2013_09_07/o1_mf_1_11930_92p2lk1t_.arc

      Sat Sep 07 17:20:15 2013

      WARN: ARCH: Terminating pid 10551406 hung on an I/O operation

      WARN: ARCH: Terminating pid 11731182 hung on an I/O operation

      krsv_proc_kill: Killing 1 processes (Process by index)

      Sat Sep 07 17:20:15 2013

      RFS[6]: Assigned to RFS process 10354794

      RFS[6]: Selected log 9 for thread 1 sequence 11866 dbid 1226709381 branch 789955333

      krsv_proc_kill: Killing 1 processes (Process by index)

      Sat Sep 07 17:20:17 2013

      RFS[7]: Assigned to RFS process 10420418

      RFS[7]: Selected log 10 for thread 1 sequence 11867 dbid 1226709381 branch 789955333

      Sat Sep 07 17:21:57 2013

      Primary database is in MAXIMUM PERFORMANCE mode

      RFS[8]: Assigned to RFS process 11337956

      RFS[8]: No standby redo logfiles available for thread 1

      RFS[8]: Opened log for thread 1 sequence 11933 dbid 1226709381 branch 789955333

      Sat Sep 07 17:25:00 2013

      Error 1031 received logging on to the standby

      FAL[client, USER]: Error 1031 connecting to ababil for fetching gap sequence

      Sat Sep 07 17:25:05 2013

       

      (Note : Here ABABIL is the PRODUCTION database NAME)

       

      STANDBY alert log :

      ===============

       

      WARN: ARCH: Terminating pid 10158208 hung on an I/O operation

      krsv_proc_kill: Killing 1 processes (Process by index)

      Sat Sep 07 17:25:25 2013

      RFS[9]: Assigned to RFS process 9699334

      RFS[9]: Selected log 11 for thread 1 sequence 11863 dbid 1226709381 branch 789955333

      Sat Sep 07 17:26:18 2013

      WARN: ARCH: Terminating pid 10354794 hung on an I/O operation

      krsv_proc_kill: Killing 1 processes (Process by index)

      Sat Sep 07 17:26:22 2013

      RFS[10]: Assigned to RFS process 11534470

      RFS[10]: Selected log 12 for thread 1 sequence 11868 dbid 1226709381 branch 789955333

      WARN: ARCH: Terminating pid 10420418 hung on an I/O operation

      krsv_proc_kill: Killing 1 processes (Process by index)

      Sat Sep 07 17:26:25 2013

      RFS[11]: Assigned to RFS process 10616942

      RFS[11]: Selected log 10 for thread 1 sequence 11867 dbid 1226709381 branch 789955333

      Sat Sep 07 17:28:04 2013

      WARN: ARCH: Terminating pid 11337956 hung on an I/O operation

      krsv_proc_kill: Killing 1 processes (Process by index)

      Sat Sep 07 17:28:04 2013

      Primary database is in MAXIMUM PERFORMANCE mode

      RFS[12]: Assigned to RFS process 10485888

      WARN: RFS[12]: Terminating pid 11337956 hung on an I/O operation

      RFS[12]: No standby redo logfiles available for thread 1

      RFS[12]: Opened log for thread 1 sequence 11934 dbid 1226709381 branch 789955333

      Sat Sep 07 17:28:05 2013

      Deleted Oracle managed file /archivefs/AIBLDG/archivelog/2013_09_07/o1_mf_1_11933_92p32ong_.arc

      Sat Sep 07 17:28:21 2013

      Shutting down instance (immediate)

      Shutting down instance: further logons disabled

      Stopping background process MMNL

      Stopping background process MMON

      =============================================

       

      For yours kind information :

      - During log switch  no log is transferred from primary to standby and shows the above error on alert log

      - we can successfully ping our IP from the both end ,

      - The DB_RECOVERY_FILE_DEST location has enough free spaces of both nodes

      - After changing physical ip of STANDBYnode, we also change the TNSFILES.ora  entry onto the PRIMARY End & listener of STANDBY end.

       

      Would anybody advice , in which case and why we face this sorts of problem ?