Oracle Data Guard ensures high availability, data protection, and disaster recovery for enterprise data. Data Guard provides a comprehensive set of services that create, maintain, manage, and monitor one or more standby databases to enable production Oracle databases to survive disasters and data corruptions. Dataguard maintains these standby as exact copy of primary database. So if […]
Articles Tagged: DATAGUARD
Oracle Cloud (DBaaS): Using dbaascli Utility for Reinstating Operations on Oracle Data Guard
This article was written by Skant Gupta and Joel Perez in Oracle OTN. At the last part of this article we performed Switchover & Failover Operations on Oracle Data Guard using the dbaascli utility. You can read it here: Oracle Cloud (DBaaS): Using dbaascli Utility for Switchover & Failover Operations on Oracle Data Guard Now in this this article we […]
Oracle Cloud (DBaaS): Using dbaascli Utility for Switchover & Failover Operations on Oracle Data Guard
This article was written by Skant Gupta and Joel Perez in Oracle OTN. At the last part of this article we performed Switchover, Failover & Reinstate Operations on Oracle Data Guard using the DBCS Console. You can read it here: Oracle Cloud (DBaaS): Switchover, Failover & Reinstate Operations on Oracle Data Guard using DBCS Console […]
Oracle Cloud (DBaaS): Switchover, Failover & Reinstate Operations on Oracle Data Guard using DBCS Console
This article was written by Skant Gupta and Joel Perez in Oracle OTN. At the last part of this article we configure the oracle data guard in database cloud service. Oracle Cloud (DBaaS): Oracle Data Guard in Database Cloud Service ( DBCS ) Now in this this article we will show the necessary steps to […]
FAR SYNC in Oracle 12C Database
Oracle introduced a new feature for DataGuard called Far Sync. This configuration is design to support synchronous redo transport between primary and standby database which are far apart. In usual configuration synchronous redo transport between data centre in Europe and US is possible but inefficient from the primary database performance perspective. Every commit has to be written […]
Oracle Cloud (DBaaS): Oracle Data Guard in Database Cloud Service ( DBCS )
This article was written by Skant Gupta and Joel Perez in Oracle OTN When creating an Oracle Database Cloud Service database deployment at the Oracle Database Cloud Service level, you can create an Oracle Data Guard configuration. Since we will talk about Oracle Data Guard, let’s remember the concept: Oracle Data Guard enables production Oracle databases to survive disasters and […]
Creation of Physical Standby in Oracle One Node
Introduction:- Data plays an important role in business operations on a day to day life. Without data, we can not perform our business operations. Data helps to generate business reports, With the help of data, all kind of business’s departments( Hr, Top management, Technical Departments, Accounts Departments etc.) can achieve their goals on time. Loss of data […]
FIND THE ARCHIVE LAG BETWEEN PRIMARY AND STANDBY
select LOG_ARCHIVED-LOG_APPLIED “LOG_GAP” from (SELECT MAX(SEQUENCE#) LOG_ARCHIVED FROM V$ARCHIVED_LOG WHERE DEST_ID=1 AND ARCHIVED=’YES’), (SELECT MAX(SEQUENCE#) LOG_APPLIED FROM V$ARCHIVED_LOG WHERE DEST_ID=2 AND APPLIED=’YES’);
LAST SEQUENCE RECEIVED AND LAST SEQUENCE APPLIED
SQL> SELECT al.thrd “Thread”, almax “Last Seq Received”, lhmax “Last Seq Applied” FROM (select thread# thrd, MAX(sequence#) almax FROM v$archived_log WHERE resetlogs_change#=(SELECT resetlogs_change# FROM v$database) GROUP BY thread#) al, (SELECT thread# thrd, MAX(sequence#) lhmax FROM v$log_history WHERE resetlogs_change#=(SELECT resetlogs_change# FROM v$database) GROUP BY thread#) lh WHERE al.thrd = lh.thrd; Thread Last Seq Received Last Seq […]
CHECK THE MESSAGES/ERRORS IN STANDBY DATABASE
set pagesize 2000 set lines 2000 col MESSAGE for a90 select message,timestamp from V$DATAGUARD_STATUS where timestamp > sysdate – 1/6; MESSAGE TIMESTAMP —————————————————————————————— ——— RFS[48]: No standby redo logfiles created 05-AUG-15 Media Recovery Log /uv1010/arch/MRSX/arch_MRSX_779539386_1_49481.log 05-AUG-15 Media Recovery Waiting for thread 1 sequence 49482 (in transit) 05-AUG-15 RFS[48]: No standby redo logfiles created 05-AUG-15 Media […]