Thanks for the question, naved.
Asked: June 14, 2016 - 6:34 am UTC
Last updated: June 15, 2016 - 1:15 am UTC
Version: 11.2.0.4
Viewed 1000+ times
You Asked
Hi ,
I had to build new physical standby with enabling log shipping, as this is m y first time have faced few difficulties.
Errors in file /u01/app/diag/rdbms/daqibliv_stby/DAQIBLIV/trace/DAQIBLIV_mrp0_10554.trc:
ORA-00313: open failed for members of log group 3 of thread 1
ORA-00312: online log 3 thread 1: '/data/IBDATA/DAQIBLIVE/redo03.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Clearing online redo logfile 3 complete
Media Recovery Waiting for thread 1 sequence 1831
Fetching gap sequence in thread 1, gap sequence 1831-1831
Error 12154 received logging on to the standby
FAL[client, USER]: Error 12154 connecting to DAQIBLIV_STBY for fetching gap sequence
Completed: alter database recover managed standby database disconnect from session
Mon Jun 13 11:39:08 2016
Error 12154 received logging on to the standby
FAL[client]: Failed to request gap sequence
GAP - thread 1 sequence 1831-1831
DBID 3565392237 branch 883597935
FAL[client]: All defined FAL servers have been attempted.
I cannot see RFS being started also little confused between locations for convert_log_file_name and dest_1 paths:-
*.log_archive_dest_1='location=/data/IBDATA/DAQIBLIVE/'
*.log_archive_dest_2='SERVICE=DAQIBLIV_STBY NOAFFIRM ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=DAQIBLIV_STBY'
*.log_file_name_convert='/data/IBDATA/DAQIBLIVE/redo01.log','/data/ibdata/DAQIBLIVE/redo01.log','/data1/IBLIVE/DAQIBLIVE/redo02.log','/data1/redo02.log','/data/IBDATA/DAQIBLIV
E/redo03.log','/data/ibdata/DAQIBLIVE/redo03.log'
and Connor said...
12154 is the error you get when we've got a connectivity issue, most typically a problem with tnsnames.ora.
For example, I have no "blah" entry in my tnsnames.ora
C:\>sqlplus qwe/qwe@blah
SQL*Plus: Release 12.1.0.2.0 Production on Wed Jun 15 09:13:28 2016
Copyright (c) 1982, 2014, Oracle. All rights reserved.
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified
So check your tnsnames.ora file on BOTH nodes.
Hope this helps.
Is this answer out of date? If it is, please let us know via a Comment