2 Replies Latest reply: Dec 10, 2012 5:52 AM by Helios-GunesEROL RSS

    logs are not archived at Standby site on same server

    978865
      Hello all,


      I am using 11gR2 on Redhat Linux 5


      i have a testing to do in which i have created my standby database through rman duplicate command


      i have my standby db on the same machine.

      my primary database is : prod

      standby database is : std

      on primary site:

      /*
      SQL> select database_role,open_mode,name from v$database;

      DATABASE_ROLE OPEN_MODE NAME
      ---------------- -------------------- ---------
      PRIMARY READ WRITE PROD

      SQL> archive log list;
      Database log mode Archive Mode
      Automatic archival Enabled
      Archive destination USE_DB_RECOVERY_FILE_DEST
      Oldest online log sequence 53
      Next log sequence to archive 55
      Current log sequence 55

      */

      but the archiving is not being done on standby site it shows the following:

      /*SQL> select database_role,open_mode,name,db_unique_name from v$database;

      DATABASE_ROLE OPEN_MODE NAME DB_UNIQUE_NAME
      ---------------- -------------------- --------- ------------------------------
      PHYSICAL STANDBY MOUNTED PROD std

      SQL> archive log list;
      Database log mode Archive Mode
      Automatic archival Enabled
      Archive destination USE_DB_RECOVERY_FILE_DEST
      Oldest online log sequence 0
      Next log sequence to archive 0
      Current log sequence 0

      */


      and in alert logfile os standby database its shoing follwoing error

      /*
      Fatal NI connect error 12543, connecting to:
      (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.25.217.137)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=prod)(CID=(PROGRAM=oracle)(HOST=sm-alpha)(USER=oracle))))

      VERSION INFORMATION:
      TNS for Linux: Version 11.2.0.3.0 - Production
      TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.3.0 - Production
      Time: 10-DEC-2012 10:51:10
      Tracing not turned on.
      Tns error struct:
      ns main err code: 12543

      TNS-12543: TNS:destination host unreachable
      ns secondary err code: 12560
      nt main err code: 513

      TNS-00513: Destination host unreachable
      nt secondary err code: 113
      nt OS err code: 0


      ***********************************************************************

      Fatal NI connect error 12543, connecting to:
      (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.25.217.137)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=prod)(CID=(PROGRAM=oracle)(HOST=sm-alpha)(USER=oracle))))

      VERSION INFORMATION:
      TNS for Linux: Version 11.2.0.3.0 - Production
      TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.3.0 - Production
      Time: 10-DEC-2012 10:51:14
      Tracing not turned on.
      Tns error struct:
      ns main err code: 12543

      TNS-12543: TNS:destination host unreachable
      ns secondary err code: 12560
      nt main err code: 513

      TNS-00513: Destination host unreachable
      nt secondary err code: 113
      nt OS err code: 0
      Error 12543 received logging on to the standby
      FAL[client, MRP0]: Error 12543 connecting to toprod for fetching gap sequence


      */

      here is my /etc/hosts

      /*
      [root@sm-alpha ~]# cat /etc/hosts
      # Do not remove the following line, or various programs
      # that require network functionality will fail.
      127.0.0.1 localhost.localdomain localhost
      10.25.217.137 sm-alpha
      */


      and when i ping to sm-alpha

      it gives

      /*

      PING sm-alpha (10.25.217.137) 56(84) bytes of data.
      From 10.25.205.117 icmp_seq=1 Destination Host Unreachable
      From 10.25.205.117 icmp_seq=2 Destination Host Unreachable
      From 10.25.205.117 icmp_seq=3 Destination Host Unreachable
      From 10.25.205.117 icmp_seq=4 Destination Host Unreachable
      From 10.25.205.117 icmp_seq=5 Destination Host Unreachable
      */

      would any one have a kind look at my problem.


      thanks