Translate

Oracle Dataguard trouble shooting


Oracle Dataguard not working then try the basics of stop and start if not refer to the link below which recommends to restart primary server.
http://scn.sap.com/thread/2016335 - Archived Log is not shifting from Primary to DR

execute this command in Primary server

ALTER SYSTEM SET log_archive_dest_state_3='DEFER' SCOPE=BOTH;

ALTER SYSTEM SET log_archive_dest_state_3='ENABLE' SCOPE=BOTH;


Related topics on Oracle Dataguard error and trouble shooting
recover automatic standby database until cancel;
alter database recover cancel


DG

select sequence#, first_time, next_time from v$archived_log order by sequence#;

select sequence#, applied from v$archived_log order by sequence#;

select process, status, sequence# from v$managed_standby;

select database_role, protection_level from v$database;

select database_role, protection_level from v$database;

alter system set log_archive_dest_state_3=defer;

alter system switch logfile;

SELECT MESSAGE FROM V$DATAGUARD_STATUS;


SQL> SELECT MESSAGE FROM V$DATAGUARD_STATUS;

MESSAGE
------------------------------------------------------------------------

ARC0: Archival started
ARC1: Archival started
ARC0: Becoming the 'no FAL' ARCH
ARC0: Becoming the 'no SRL' ARCH
ARC1: Becoming the heartbeat ARCH
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 R:\ORACLE\DPF\ORIGLOGA\LOG_G11M1.DBF
Clearing online redo logfile 1 complete
Media Recovery Waiting for thread 1 sequence 42190

MESSAGE
------------------------------------------------------------------------

Fetching gap sequence in thread 1, gap sequence 42190-42289
FAL[client]: Failed to request gap sequence
 GAP - thread 1 sequence 42190-42289
 DBID 3620481324 branch 595624108
FAL[client]: All defined FAL servers have been attempted.

16 rows selected.

select * from (select sequence#,applied,first_time from v$archived_log
order by first_time desc)
where rownum <10;

select process,status,thread#,sequence#,block#,blocks from v$managed_standby;

select sequence#, name, archived, applied from  v$archived_log
where sequence# like '%42286%';


@ECHO OFF
replace W:\test.txt U:\oracle\DPF\temp /A



Help full notes on WAIT_FOR_GAP DG

http://anoopbal.blogspot.nl/2012/03/falclient-failed-to-request-gap.html
https://kr.forums.oracle.com/forums/thread.jspa?threadID=2171232
https://cn.forums.oracle.com/forums/thread.jspa?threadID=2233823
http://www.dba-oracle.com/t_detect_redo_log_gaps.htm
http://docs.oracle.com/cd/B28359_01/server.111/b28294/trace.htm#CACBEFAD
https://scn.sap.com/thread/1876345

No comments:

Labels

sap hana hana database aws s4 hana hana db s4hana conversion steps sap hana azure bw4hana hana migration s4hana migration sap cloud migration steps sap hana migration steps sap hana migration to azure s4hana sap fiori fiori performance fiori erp s4 hana fiori sap fiori app sap fiori client sap fiori launchpad sap s4 hana fiori cisco ecc AI SAP AI abap dumps hana sap S/4HANA S/4HANA Conversion best sap ui5 & fiori training configuration database fiori tutorial on webide free sap ui5 & fiori training s/4 hana sap dumps sap fiori tutorial sap ui5 sap ui5 & fiori sap ui5 & fiori tutorial sara ui5cn 2367245 - Troubleshooting performance issues with SAP BPA Amazon free tier for SAP AWS setup Experience CALL_FUNCTION_NOT_FOUND CCMS Configuration and Use Create New Data Class in SAP (Oracle) Critical top SAP Abap dumps DHCP Clients Not Receiving IP Addresses Download Stack.xml HAN-DB HAN-DB-ENG High CPU Usage Due to Excessive Process Switching How To How to Start and Stop SAP Hana Tenant Database How to change SAP Hana Sql Output results are limited to 5000 Records How to perform SAP Dual Stack Split - Netweaver Inactive Objects in SAP Intercompany transactions in SAP AP / AR : Cross Company Code Transaction Interface Flapping Due to Duplex Mismatch KBA LOAD_PROGRAM_LOST MSSQL shrinking transaction log file Migrating to SAP hana database NAT Overload Causing Internet Access Failure Note 500235 - Network Diagnosis with NIPING OSPF Adjacency Not Forming PRINCE2 Foundation Sample Questions Preparing for S/4HANA Conversion and the MUST know items Push to Download Basket S/4HANA Migration Cockpit S/4JANA SAP BI Support Data Load Errors and Solutions SAP BI/BW Landscape SAP BPA SAP Basis SAP Basis Automation SAP Business Objects SAP CPS SAP Certification SAP FI Certification SAP FI Certification Sample Questions SAP HANA Admin - Cockpit SAP HANA DB Engines SAP HANA Database SAP HANA terminate session connection disconnect cancel kill hang stuck SAP Hana DB restore SAP Hana Numeric Error Codes SAP Landscape SAP Language installation SAP MM and Purchase Order Tables SAP Maintenance Planner SAP Note 500235 SAP R/3 Glossary SAP Readiness Check SAP S/4HANA 1709 Installation Files SAP S/4HANA 2023 SAP S/4HANA 2023 Installation SAP S/4HANA 2023 running SAP S/4HANA Installation SAP Scheduling SAP Solman 7.2 CHARM: SAP Support Package Stack Strategy SAP Support package SAP Upgrade SAP support stack upgrade SP stacks STORAGE_PARAMETERS_WRONG_SET SUSE/SLES/Kernel versions Setup of S/4hana 2023 TSV_TNEW_PAGE_ALLOC_FAILED TSV_TNEW_PAGE_ALLOC_FAILED error Transaction ID Unable to download an SAP Note Unix/Linux Command That Are Helpful For SAP Basis Upgrading SAP Kernel Without Downtime Upgrading windows server 2008 to windows server 2019 What is OSS Notes? SAP SNOTE Tutorial accounting agile ale idoc ale/edi archive FI documents audit auditing auditor aws aws cloud basic type bluefield approach ccms ccmsidb charm copilot datavard dbacockpit download sap note download snote edi idoc electronic data interchange enable sap archiving objects erpprep ffid firefighter fraud functional hana admin how to apply sap security note https://www.erpprep.com/ idoc install install sap fiori installation interfaces intermediate document internal control license key linux version materials management messsage niping test order type port prince2 agile prince2 agile practitioner purchasing quick info s4 hana sap abap dumps sap abbreviations sap activate certification sap activate project manager sap authorization sap aws sap brownfield sap ccms sap ccms configuration sap erp sap error sap grc sap greenfield sap internet demo system sap license sap maintenance certificate sap material management sap meaning sap mm sap mm consultant sap monthly security note sap netweaver sap network diagnostic sap niping sap note sap oss sap patch day sap performance sap performance issue sap purchase order sap s/4hana sap sales and distribution sap sap otc sap sd sap sd certification training sap sd course sap sd jobs sap sd module sap sd online training sap sd training sap sd tutorial sap sd tutorial for beginners sap security sap security note sap snote sap snote tutorial sap solution manager sap sql segregation of duties separation of duties sles slicense smc snote snote in sap system sod conflict solution manager solution maneger stop start hana database suse linux techie trex two step upgrade required waterfall