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
add comment

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.