This discussion is archived
2 Replies Latest reply: Dec 10, 2012 3:52 AM by Helios-GunesEROL RSS

logs are not archived at Standby site on same server

978865 Newbie
Currently Being Moderated
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

Legend

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