Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I am not able to transfer my archive logs from primary to standby. I executed the following query:

archive log list                                           
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            /u03/app/oracle/flash_recovery_area/TEST1/
Oldest online log sequence     0
Next log sequence to archive   0
Current log sequence           0
SQL> select message from v$dataguard_status;

MESSAGE
--------------------------------------------------------------------------------
ARC0: Archival started
ARC1: Becoming the 'no FAL' ARCH
ARC2: Becoming the 'no FAL' ARCH
ARC3: Becoming the 'no FAL' ARCH
ARC4: Becoming the 'no FAL' ARCH
ARC5: Becoming the 'no FAL' ARCH
ARC6: Becoming the 'no FAL' ARCH
ARC7: Becoming the 'no FAL' ARCH
ARC8: Becoming the 'no FAL' ARCH
ARC9: Becoming the 'no FAL' ARCH
ARCa: Becoming the 'no FAL' ARCH
ARCb: Becoming the 'no FAL' ARCH
ARCc: Becoming the 'no FAL' ARCH
ARCd: Becoming the 'no FAL' ARCH
ARCe: Becoming the 'no FAL' ARCH
ARCf: Becoming the 'no FAL' ARCH
ARCg: Becoming the 'no FAL' ARCH
ARCh: Becoming the 'no FAL' ARCH
ARCi: Becoming the 'no FAL' ARCH
ARCj: Becoming the 'no FAL' ARCH
ARCk: Becoming the 'no FAL' ARCH
ARCl: Becoming the 'no FAL' ARCH
ARCm: Becoming the 'no FAL' ARCH
ARCn: Becoming the 'no FAL' ARCH
ARCo: Becoming the 'no FAL' ARCH
ARC1: Archival started
ARC2: Archival started
ARC3: Archival started
ARC4: Archival started
ARC5: Archival started
ARC6: Archival started
ARC7: Archival started
ARC8: Archival started
ARC9: Archival started
ARCa: Archival started
ARCb: Archival started
ARCc: Archival started
ARCd: Archival started
ARCe: Archival started
ARCf: Archival started
ARCg: Archival started
ARCh: Archival started
ARCi: Archival started
ARCj: Archival started
ARCk: Archival started
ARCl: Archival started
ARCm: Archival started
ARCn: Archival started
ARCo: Archival started
ARCp: Archival started
ARCq: Archival started
ARCr: Archival started
ARCs: Archival started
ARCj: Becoming the 'no FAL' ARCH
ARCk: Becoming the heartbeat ARCH
Error 28547 received logging on to the standby
FAL[client, ARC2]: Error 28547 connecting to TEST1 for fetching gap sequence
ARCt: Archival started
Attempt to start background Managed Standby Recovery process
MRP0: Background Managed Standby Recovery process started
Managed Standby Recovery not using Real Time Apply
Clearing online redo logfile 1 /u03/app/oracle/oradata/TEST1_SDY/redo01.log
Clearing online redo logfile 1 complete
Clearing online redo logfile 2 /u03/app/oracle/oradata/TEST1_SDY/redo02.log
Clearing online redo logfile 2 complete
Clearing online redo logfile 3 /u03/app/oracle/oradata/TEST1_SDY/redo03.log
Clearing online redo logfile 3 complete
Media Recovery Waiting for thread 1 sequence 52
Error 12543 received logging on to the standby
FAL[client, USER]: Error 12543 connecting to TEST1 for fetching gap sequence
Error 12543 received logging on to the standby
FAL[client, USER]: Error 12543 connecting to TEST1 for fetching gap sequence
Error 12543 received logging on to the standby
FAL[client, USER]: Error 12543 connecting to TEST1 for fetching gap sequence
Error 12543 received logging on to the standby
FAL[client, USER]: Error 12543 connecting to TEST1 for fetching gap sequence
Error 12543 received logging on to the standby
FAL[client, USER]: Error 12543 connecting to TEST1 for fetching gap sequence
FAL[client]: Failed to request gap sequence
 GAP - SCN range: 0x0000.00150842 - 0x0000.00150842
 DBID 1176505217 branch 799462852
FAL[client]: All defined FAL servers have been attempted.
82 rows selected.

I tried to Google the error but I am not able to get a clear answer. Can any one help to fix the problem? At first I was getting the message:

MRP0: Background Managed Standby Recovery process started
Managed Standby Recovery not using Real Time Apply
MRP0: Detected orphaned datafiles!
Recovery will possibly be retried after flashback...

I again did manual recovery from primary to standby database. After that I am getting above error. ora-12543 is a network error so I used tnsping command on primary db

tnsping TEST1_SDY

/u03/app/oracle/product/11.2.0/dbhome_1/network/admin/sqlnet.ora

Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = db7.oracle.com)>(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SID=TEST1_SDY))) OK (450 msec)

on standby db tnsping TEST1

/u03/app/oracle/product/11.2.0/dbhome_1/network/admin/sqlnet.ora Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = db6.oracle.com)>>>>(PORT = 1522)) (CONNECT_DATA = (SERVER = DEDICATED) (SID=TEST1))) OK (870 mse)

I am able to ping but I dont know why I am getting this error.

share|improve this question

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.