Hello. I'm on Solaris 10, running Oracle EE 11.2.0.2.
I'm fairly new to this job site and I've found they have a database that was once set up with DG physical standby (no FSFO).
Apparently it has not been updating their standby database for over a year.
At this point, they said they can live without the standby (at least for now).
First problem I see is that in the alert log, there are millions of errors trying to connect to the old standby database.
I have tried a couple times to disable (defer) the dest_2, but I'm still getting the errors in the alert log even though dest_2 is deferred.
See below:
***********************************************************************
Fatal NI connect error 12541, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=taurus)(PORT=1522))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=ASSIA_DG2_DGB)(CID=(PROGRAM=oracle)(HOST=copernicus)(USER=ora
cle))))
VERSION INFORMATION:
TNS for Solaris: Version 11.2.0.2.0 - Production
TCP/IP NT Protocol Adapter for Solaris: Version 11.2.0.2.0 - Production
Time: 18-DEC-2012 09:11:08
Tracing not turned on.
Tns error struct:
ns main err code: 12541
TNS-12541: TNS:no listener
ns secondary err code: 12560
nt main err code: 511
TNS-00511: No listener
nt secondary err code: 146
nt OS err code: 0
***********************************************************************
When I first checked the alert log, it was over 3Gb, which makes it pretty difficult to use.
Anyway, now that I have a new fresh alert log, I see the errors keep being generated.
See init params below.
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest string
log_archive_dest_1 string LOCATION=/opt/oracle/orabackup/ASSIA/archivelogs/
log_archive_dest_10 string
log_archive_dest_11 string
log_archive_dest_12 string
log_archive_dest_13 string
log_archive_dest_14 string
log_archive_dest_15 string
log_archive_dest_16 string
log_archive_dest_17 string
log_archive_dest_18 string
log_archive_dest_19 string
log_archive_dest_2 string service="ASSIA_DG2", LGWR ASYNC NOAFFIRM delay=0 optional compression=disable
max_failure=0 max_connections=1 reopen=300 db_unique_name="ASSIA_DG2"
net_timeout=30, valid_for=(all_logfiles,primary_role)
log_archive_dest_20 string
log_archive_dest_21 string
log_archive_dest_22 string
log_archive_dest_23 string
log_archive_dest_24 string
log_archive_dest_25 string
log_archive_dest_26 string
log_archive_dest_27 string
log_archive_dest_28 string
log_archive_dest_29 string
log_archive_dest_3 string
log_archive_dest_30 string
log_archive_dest_31 string
log_archive_dest_4 string
log_archive_dest_5 string
log_archive_dest_6 string
log_archive_dest_7 string
log_archive_dest_8 string
log_archive_dest_9 string
log_archive_dest_state_1 string ENABLE
log_archive_dest_state_10 string enable
log_archive_dest_state_11 string enable
log_archive_dest_state_12 string enable
log_archive_dest_state_13 string enable
log_archive_dest_state_14 string enable
log_archive_dest_state_15 string enable
log_archive_dest_state_16 string enable
log_archive_dest_state_17 string enable
log_archive_dest_state_18 string enable
log_archive_dest_state_19 string enable
log_archive_dest_state_2 string DEFER <=======
log_archive_dest_state_20 string enable
log_archive_dest_state_21 string enable
log_archive_dest_state_22 string enable
log_archive_dest_state_23 string enable
log_archive_dest_state_24 string enable
log_archive_dest_state_25 string enable
log_archive_dest_state_26 string enable
log_archive_dest_state_27 string enable
log_archive_dest_state_28 string enable
log_archive_dest_state_29 string enable
log_archive_dest_state_3 string enable
log_archive_dest_state_30 string enable
log_archive_dest_state_31 string enable
log_archive_dest_state_4 string enable
log_archive_dest_state_5 string enable
log_archive_dest_state_6 string enable
log_archive_dest_state_7 string enable
log_archive_dest_state_8 string enable
log_archive_dest_state_9 string enable
I'm thinking I could just clear out the log_archive_dest_2 parameter entirely since they don't need it for now, but I'd also like to understand why it is still attemting to connect to the standby server even though dest_2 is set to DEFER.