Skip to Main Content

Breadcrumb

Question and Answer

Connor McDonald

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