Hi Guys
Just asking for your help in trouble shooting log shipping on Oracle dataguard 12c.
DG has not been in use for up to months. However It was working when it was configured
What I picked initially is an error on LOG_ARCHIVE_DEST_2
SQL> select dest_name,status,destination from V$ARCHIVE_DEST;
DEST_NAME
--------------------------------------------------------------------------------
STATUS
---------
DESTINATION
--------------------------------------------------------------------------------
LOG_ARCHIVE_DEST_1
VALID
USE_DB_RECOVERY_FILE_DEST
LOG_ARCHIVE_DEST_2
ERROR <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
nmbdr
Further investigations I notice the log shipping LISTENER on the primary DB has the following status
(Primary DB)
============
SQL> SELECT PROCESS, STATUS FROM V$MANAGED_STANDBY;
PROCESS STATUS
--------- ------------
ARCH CLOSING
ARCH CONNECTED
ARCH CLOSING
ARCH OPENING
LNS OPENING <<<<<<<<<<<<<<<<<<<<<<<
LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 07-FEB-2018 13:38:14
Copyright (c) 1991, 2014, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.254.196)(PORT=1530)))
Services Summary...
Service "nmbprod.nmbz.co.zw" has 1 instance(s).
Instance "nmbprod", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 <<<<<<<<<<<<<<<<<<<<<<<<<<<< (0 establised connections)
LOCAL SERVER
The command completed successfully
On the the standby we have the following status
(Standby DB)
=============
SQL> select process, client_process, thread#, sequence#, status from v$managed_standby;
PROCESS CLIENT_P THREAD# SEQUENCE# STATUS
--------- -------- ---------- ---------- ------------
ARCH ARCH 0 0 CONNECTED
ARCH ARCH 0 0 CONNECTED
ARCH ARCH 0 0 CONNECTED
ARCH ARCH 0 0 CONNECTED
LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 07-FEB-2018 12:53:25
Copyright (c) 1991, 2014, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.240.241)(PORT=1530)))
Services Summary...
Service "nmbdr" has 1 instance(s).
Instance "nmbdr", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:10676 refused:0 <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<< (some established connections)
LOCAL SERVER
The command completed successfully
Does this listener status have any link to the log shipping problem ?
What could be causing this error on LOG_ARCHIVE_DEST_2 ?
rgds
Vunga