-
I have configure standby database on remote machine.
I have set archive dest to remote machine so managed recovery can be possible on standby DB.
TNSPING and database connectivity working perfetly from any other machine but when log switch occured at production database immidiarly second archive destination will give error :
ORA-16032 parameter string destination string cannot be translated
TNSNAMES.ORA (At production DB)
STANDBY =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = M1)(PORT = 1561))
)
(CONNECT_DATA =
(SERVICE = KLCL)
)
)
LISTENER.ORA (At standby site)
STANDBY =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(PORT = 1561)(HOST = M1 ))
)
SID_LIST_STANDBY =
(SID_LIST =
(SID_DESC =
(SID_NAME = KLCL)
(ORACLE_HOME = D:\oracle\ora81)
)
)
-
What is the Oracle Version ?
Can you post values for following init.ora prameters..
1. LOG_ARCHIVE_DEST
2. LOG_FILE_NAME_CONVERT
3. STANDBY_ARCHIVE_DEST
Sanjay
-
Value of init.ora
ORACLE VERSION 8.1.7. Ooperating System - Windows 2000 server on both the machine (Production DB and Standby DB).
LOG_ARCHIVE_DEST_1 = "location=D:\ORACLE\ORADATA\ORCL\ARCHIVE"
LOG_FILE_NAME_CONVERT - NOT MENTION AS I AM CONFIGURING STANDBY DB AT REMOTE LOCATION.
STANDBY_ARCHIVE_DEST "location=D:\ORACLE\ORADATA\ORCL\ARCHIVE"
Nirav
-
You are poiniting to same directory for LOG_ARCHIVE_DEST and STANDBY_ARCHIVE_DEST.
You should use 'SERVICE= ' for standby_archive_dest
Sanjay
-
Yes on production database i have already
set the following init.ora
parameter
log_archive_dest_2='SERVICE=STANDBY'
log_archive_dest_state_2 = Enable
Then also got the same error
Nirav
-
did you configure
STANDBY_ARCHIVE_DEST "location=D:\ORACLE\ORADATA\ORCL\ARCHIVE"
in standby database or primary?
-
i have configure
STANDBY_ARCHIVE_DEST "location=D:\ORACLE\ORADATA\ORCL\ARCHIVE"
on standby database
-
Here is the resolution:
The parameter STANDBY_ARCHIVE_DEST that you need to have on the init.ora file of the standby database (required in a managed mode) needs to be a valid path. (duh!)
(Wait, heres the real resolution...)
don't be confused by the convention of the value in that parameter (STANDBY_ARCHIVE_DEST) with those used in LOC_ARCHIVE_DEST_n. I'm refering to the prefix of "location=". The STANDBY_ARCHIVE_DEST parameter doesn't require the prefix and will not work if the prefix ("location=") is used.
See MetaLink doc# 106699.1
This thread from 2 years ago seemd to have gone unresolved. If thw owner eventually found the answer on their own....IT WOULD BE REALLY NICE IF THEY COULD COME BACK TO THEIR ORIGINAL THREAD AND CLOSE IT OFF WITH A RESOLUTION.
I found all these threads related to issue...ALL OF THEM WITHOUT ANY RESOLUTION TO IT. I'm almost positive more 75% of those thread were eventually resolved the owner.
Well, I had the same problem this week and none of these threads helped me at all.
AND PLEASE, IF YOU FIND THE SOLUTION TO OWN THREAD, DO SHARE IT BY REPLYING TO YOUR OWN THREAD.