OraFAQ Forum: Data Guard

Home » Server Options » Data Guard » redo apply (Oracle 11.2.0.1.0 - RHEL5)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

redo apply [message #447674]

Wed, 17 March 2010 05:13

nojmathew
Messages: 4
Registered: August 2007
Location: Calicut

Junior Member

Hi all

My oracle data guard showing some problem

Log file is shipping to standby but not applying.

PRIMARY
========
SQL>select sequence#, archived, applied from v$archived_log;

SEQUENCE# ARC APPLIED
---------- --- ---------
1156 YES YES
1155 YES YES
1157 YES NO
1157 YES NO
1158 YES NO
1159 YES NO
1159 YES NO
1158 YES NO
1160 YES NO
1160 YES NO
1161 YES NO

SEQUENCE# ARC APPLIED
---------- --- ---------
1161 YES NO
1162 YES NO
1162 YES NO
1163 YES NO
1163 YES NO
1164 YES NO
1165 YES NO
1165 YES NO
1164 YES NO
1166 YES NO
1166 YES NO

SEQUENCE# ARC APPLIED
---------- --- ---------
1167 YES NO
1167 YES NO
1168 YES NO
1168 YES NO
1169 YES NO
1169 YES NO
1170 YES NO
1170 YES NO
1171 YES NO
1171 YES NO
1172 YES NO

SEQUENCE# ARC APPLIED
---------- --- ---------
1173 YES NO
1173 YES NO
1172 YES NO
1174 YES NO
1174 YES NO
1175 YES NO
1175 YES NO
1176 YES NO
1176 YES NO
1177 YES NO
1177 YES NO

SEQUENCE# ARC APPLIED
---------- --- ---------
1178 YES NO
1178 YES NO
1179 YES NO
1180 YES NO
1180 YES NO
1179 YES NO
1181 YES NO
1181 YES NO
1182 YES NO
1182 YES NO
1183 YES NO

SEQUENCE# ARC APPLIED
---------- --- ---------
1183 YES NO
1184 YES NO
1184 YES NO

1092 rows selected.

STANDBY
=======
SQL>select sequence#, archived, applied from v$archived_log;
SEQUENCE# ARC APPLIED
---------- --- ---------
1153 YES YES
1154 YES YES
1156 YES YES
1155 YES YES
1157 YES NO
1159 YES NO
1158 YES NO
1160 YES NO
1161 YES NO
1162 YES NO
1163 YES NO

SEQUENCE# ARC APPLIED
---------- --- ---------
1165 YES NO
1164 YES NO
1166 YES NO
1167 YES NO
1168 YES NO
1169 YES NO
1170 YES NO
1171 YES NO
1173 YES NO
1172 YES NO
1174 YES NO

SEQUENCE# ARC APPLIED
---------- --- ---------
1175 YES NO
1176 YES NO
1177 YES NO
1178 YES NO
1180 YES NO
1179 YES NO
1181 YES NO
1182 YES NO
1183 YES NO
1184 YES NO

560 rows selected.
===============================================================
The sequence# number up to 1156 was working fine... and after that it's not applying.

PRIMARY
=========
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /log
Oldest online log sequence 1183
Next log sequence to archive 1185
Current log sequence 1185

STANDBY
========
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /log
Oldest online log sequence 1183
Next log sequence to archive 0
Current log sequence 1185

PRIMARY
========
SQL> select message from v$dataguard_status;

MESSAGE
--------------------------------------------------------------------------------
ARC0: Archival started
ARC1: Archival started
ARC2: Archival started
ARC3: Archival started
ARC0: Becoming the 'no FAL' ARCH
ARC0: Becoming the 'no SRL' ARCH
ARC1: Becoming the heartbeat ARCH
ARC3: Beginning to archive thread 1 sequence 1172 (517756433-517796611)
ARC3: Completed archiving thread 1 sequence 1172 (517756433-517796611)
ARC3: Beginning to archive thread 1 sequence 1173 (517796611-517796721)
ARC3: Completed archiving thread 1 sequence 1173 (517796611-517796721)

MESSAGE
--------------------------------------------------------------------------------
Error 12543 received logging on to the standby
PING[ARC1]: Heartbeat failed to connect to standby 'standby'. Error is 12543.
Error 12541 received logging on to the standby
Check whether the listener is up and running.
Error 12541 received logging on to the standby
Check whether the listener is up and running.
Error 12541 for archive log file 3 to 'standby'
FAL[server, ARC2]: Error 12541 creating remote archivelog file 'standby'
ARC2: Beginning to archive thread 1 sequence 1174 (517796721-517805815)
LNS: Beginning to archive log 1 thread 1 sequence 1174
LNS: Completed archiving log 1 thread 1 sequence 1174

MESSAGE
--------------------------------------------------------------------------------
ARC2: Completed archiving thread 1 sequence 1174 (517796721-517805815)
LNS: Beginning to archive log 2 thread 1 sequence 1175
LNS: Completed archiving log 2 thread 1 sequence 1175
ARC3: Beginning to archive thread 1 sequence 1175 (517805815-517810261)
LNS: Beginning to archive log 3 thread 1 sequence 1176
ARC3: Completed archiving thread 1 sequence 1175 (517805815-517810261)
LNS: Completed archiving log 3 thread 1 sequence 1176
ARC0: Beginning to archive thread 1 sequence 1176 (517810261-517810397)
LNS: Beginning to archive log 1 thread 1 sequence 1177
ARC0: Completed archiving thread 1 sequence 1176 (517810261-517810397)
LNS: Attempting destination LOG_ARCHIVE_DEST_2 network reconnect (3135)

MESSAGE
--------------------------------------------------------------------------------
LNS: Destination LOG_ARCHIVE_DEST_2 network reconnect abandoned
Error 3135 for archive log file 1 to 'standby'
LNS: Failed to archive log 1 thread 1 sequence 1177 (3135)
ARC2: Beginning to archive thread 1 sequence 1177 (517810397-517813674)
LNS: Beginning to archive log 1 thread 1 sequence 1177
LNS: Completed archiving log 1 thread 1 sequence 1177
ARC2: Completed archiving thread 1 sequence 1177 (517810397-517813674)
LNS: Beginning to archive log 2 thread 1 sequence 1178
LNS: Attempting destination LOG_ARCHIVE_DEST_2 network reconnect (3135)
LNS: Destination LOG_ARCHIVE_DEST_2 network reconnect abandoned
Error 3135 for archive log file 2 to 'standby'

MESSAGE
--------------------------------------------------------------------------------
LNS: Failed to archive log 2 thread 1 sequence 1178 (3135)
ARC3: Beginning to archive thread 1 sequence 1178 (517813674-517817183)
LNS: Beginning to archive log 2 thread 1 sequence 1178
LNS: Completed archiving log 2 thread 1 sequence 1178
ARC3: Completed archiving thread 1 sequence 1178 (517813674-517817183)
LNS: Beginning to archive log 3 thread 1 sequence 1179
LNS: Attempting destination LOG_ARCHIVE_DEST_2 network reconnect (3135)
LNS: Destination LOG_ARCHIVE_DEST_2 network reconnect abandoned
Error 3135 for archive log file 3 to 'standby'
LNS: Failed to archive log 3 thread 1 sequence 1179 (3135)
ARCH: Beginning to archive thread 1 sequence 1179 (517817183-517845714)

MESSAGE
--------------------------------------------------------------------------------
ARCH: Completed archiving thread 1 sequence 1179 (517817183-517845714)
ARC2: Beginning to archive thread 1 sequence 1180 (517845714-517845951)
ARC2: Completed archiving thread 1 sequence 1180 (517845714-517845951)
ARC2: Beginning to archive thread 1 sequence 1181 (517845951-517846306)
ARC2: Completed archiving thread 1 sequence 1181 (517845951-517846306)
LNS: Beginning to archive log 2 thread 1 sequence 1181
LNS: Completed archiving log 2 thread 1 sequence 1181
LNS: Beginning to archive log 3 thread 1 sequence 1182
LNS: Attempting destination LOG_ARCHIVE_DEST_2 network reconnect (3135)
LNS: Destination LOG_ARCHIVE_DEST_2 network reconnect abandoned
Error 3135 for archive log file 3 to 'standby'

MESSAGE
--------------------------------------------------------------------------------
LNS: Failed to archive log 3 thread 1 sequence 1182 (3135)
ARC3: Beginning to archive thread 1 sequence 1182 (517846306-517850982)
ARC3: Completed archiving thread 1 sequence 1182 (517846306-517850982)
Error 12528 received logging on to the standby
PING[ARC1]: Heartbeat failed to connect to standby 'standby'. Error is 12528.
ARC2: Beginning to archive thread 1 sequence 1183 (517850982-517852807)
LNS: Beginning to archive log 1 thread 1 sequence 1183
ARC2: Completed archiving thread 1 sequence 1183 (517850982-517852807)
LNS: Completed archiving log 1 thread 1 sequence 1183
LNS: Beginning to archive log 2 thread 1 sequence 1184
LNS: Attempting destination LOG_ARCHIVE_DEST_2 network reconnect (3135)

MESSAGE
--------------------------------------------------------------------------------
LNS: Destination LOG_ARCHIVE_DEST_2 network reconnect abandoned
Error 3135 for archive log file 2 to 'standby'
LNS: Failed to archive log 2 thread 1 sequence 1184 (3135)
ARC3: Beginning to archive thread 1 sequence 1184 (517852807-517853443)
ARC3: Completed archiving thread 1 sequence 1184 (517852807-517853443)
LNS: Beginning to archive log 2 thread 1 sequence 1184
LNS: Completed archiving log 2 thread 1 sequence 1184
LNS: Beginning to archive log 3 thread 1 sequence 1185

85 rows selected.

STANDBY
========
SQL> select message from v$dataguard_status;

MESSAGE
--------------------------------------------------------------------------------
ARC0: Archival started
ARC1: Archival started
ARC2: Archival started
ARC2: Becoming the 'no FAL' ARCH
ARC1: Becoming the heartbeat ARCH
ARC3: Archival started
Attempt to start background Managed Standby Recovery process
MRP0: Background Managed Standby Recovery process started
Managed Standby Recovery not using Real Time Apply
Clearing online redo logfile 1 /opt/app/oracle/oradata/corecbs/redo01.log
Clearing online redo logfile 1 complete

MESSAGE
--------------------------------------------------------------------------------
Media Recovery Log /log/1_1157_707743675.dbf
MRP0: Background Media Recovery terminated with error 448
MRP0: Background Media Recovery process shutdown
RFS[1]: Assigned to RFS process 26911
RFS[1]: Identified database type as 'physical standby': Client is ARCH pid 2501
RFS[2]: Assigned to RFS process 26913
RFS[2]: Identified database type as 'physical standby': Client is LGWR ASYNC pid
2507

Primary database is in MAXIMUM PERFORMANCE mode

19 rows selected.

From The above informations, please help me to start the log apply service on standby

When cancel the log apply service on standby
STANDBY
========
SQL> alter database recover managed standby database cancel;
alter database recover managed standby database cancel
*
ERROR at line 1:
ORA-16136: Managed Standby Recovery not active

Thanks in Advance.....

Shinoj Mathew

Report message to a moderator

Re: redo apply [message #447698 is a reply to message #447674]

Wed, 17 March 2010 07:35

Yasir Hashmi
Messages: 304
Registered: April 2006

Senior Member

Hi,

oerr ora 3135
03135, 00000, "connection lost contact"
// *Cause:  1) Server unexpectedly terminated or was forced to terminate.
//          2) Server timed out the connection.
// *Action: 1) Check if the server session was terminated.
//          2) Check if the timeout parameters are set properly in sqlnet.ora.

Report message to a moderator

Re: redo apply [message #447795 is a reply to message #447698]

Wed, 17 March 2010 23:58

nojmathew
Messages: 4
Registered: August 2007
Location: Calicut

Junior Member

Hi,

sqlnet.ora on primary
=======================
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

ADR_BASE = /opt/app/oracle

sqlnet.ora on standby
=======================
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

ADR_BASE = /opt/app/oracle

Is it possible to copy all the archived log files to standby again and apply on it?

Report message to a moderator