Introduction High availability and predictable disaster recovery are critical in any Oracle production environment. While managing Data Guard manually via SQL*Plus is possible, the number of manual steps during incidents…
Read MoreIn Oracle Database 19c, the MAX_STRING_SIZE parameter controls the maximum length for VARCHAR2, NVARCHAR2, and RAW columns. By default, it’s set to STANDARD, which limits columns to 4,000 bytes. Setting…
Read MoreDescription to standby: A standby database is a transactionally consistent replica of the primary database, designed to ensure continuity and data integrity in the event of disasters or data corruption. It allows the primary Oracle database to remain operational even during planned or unplanned outages. If the primary database becomes unavailable, Data Guard can seamlessly promote the standby database to the primary role, minimizing downtime. Additionally, the performance of the primary database can be optimized by redirecting resource-intensive tasks such as backups and reporting to the standby system. Therefore, keeping the standby database synchronized with the primary database is always advantageous. A standby database might lag behind the primary for various reasons like: Unavailability of or insufficient network bandwidth between primary and standby database Unavailability of Standby database Corruption / Accidental deletion of Archive Redo Data on primary CHECK THE SEQUENCE IN BOTH NODES: PRIMARY: SQL> select thread#, max(sequence#) “Last Primary Seq Generated” from v$archived_log val, v$database vdb where val.resetlogs_change# = vdb.resetlogs_change# group by thread# order by 1; THREAD# Last Primary Seq Generated ———- ————————– 1 556 STANDBY:…
Read MoreOracle Dataguard physical Standby configuration in 19c:(Active method-without using rman backup) Overview steps: Step:1 we have to enable the archive log mode ,flashback on primary databases. Step:2 Then enable the force…
Read MoreREFRESH STANDBY USING INCREMENTAL(SCN BASED) BACKUP This method is used to resolve problems if a physical standby database has lost or corrupted archived redo data or has an unresolvable archive…
Read MorePosted by : Karthick This Post demonstrates the Dataguard status connection lost contact from Primary database The Data Guard status of xxxx is Error ORA-03135: connection lost contact from Primary…
Read MorePosted by Sundaravel Ramasubbu Introduction : In this session we will see How to set up Data Guard Broker. NOTE: Environment in my case Prerequisite Check DG_BROKER_START parameter on Primary and…
Read MoreRenaming UNNAMED datafile(s) to standby database If parameter STANDBY_FILE_MANAGEMENT is set to MANUAL in Oracle standby database you may getthis error when rolling forward: Media Recovery Log logfile.arcFile #416 added…
Read MoreWe faced the error ORA-16057 while building a standby database.archives were not shipping to the DR site Now in the production database, Select dest_id,error from v$archive_dest; DEST_ID ERROR ———-…
Read MoreIn a active standby database we had a problem due to temp tablespace. So we increased the temp tablespace by adding a 10G tempfile in the primary database. SQL> select…
Read More