DataGuard

Resync Standby Database Using RMAN Incremental Backups

by

Normally in DR setup, the archives from primary shipped to standby and applied there. Suppose some of the archives hasn’t been shipped to secondary .But due to intermittence error or human error, the archives has been deleted from primary. So without those archives, standby can’t be in sync with primary. So when this situation occurs, … Read more

Step by Step Data Guard Configuration in 19c

by

1) PREREQUISITES: Requirements before starting the DATA GUARD CONFIGURATION. NOTE: 1) In PRIMARY SERVER DG11 we need to install the BINARIES OF ORACLE 19c and then create only 1 PRIMARY DB NAMED ORCL by using ./dbca or manually as required. 2) In STANDBY SERVER DG11S we only need to install the BINARIES OF ORACLE 19c. … Read more

Switchover to Physical Standby Database in Oracle !!

by

Once the standby database is configured and verified to be working properly, we can switch over to the standby database for testing purposes. This helps to minimize downtime for the primary database, which may be required for various maintenance tasks such as OS upgrades, hardware upgrades, and other issues.During a switchover from the primary database … Read more

2 node RAC with Dataguard Configuration (DGMGRL)

by

This guide will take you through the steps configure Oracle Grid Infrastructure 12c and Database 12c including RAC to RAC Data Guard and Data Broker configuration in a Primary and Physical Standby environment for high availability. You need to download the following software if you do not have already. We can see here 6 redo … Read more

Steps to Startup & Shutdown Oracle Data Guard !

by

To start a physical standby database, follow these steps using SQL*Plus with administrator privileges: Start the database in NOMOUNT mode: Mount the standby database: Start managed recovery (optional): Start the DB with SRVCTL commands– SYNTAX FOR START DBsrvctl start database -d db_name [-o start_options] where start_option is nomount/mount/open(default)e.gsrvctl start database -d CERTDB -o nomountsrvctl start … Read more

Command to Check Archivelog Size

by

Oracle databases maintain a detailed history of all changes made to the database through archived redo logs, commonly known as archivelogs. These archivelogs are crucial for data recovery and are often managed by database administrators. Monitoring the size of archivelogs is essential to ensure optimal database performance and sufficient storage capacity. Here are some ways … Read more

Error: ORA-16698: member has a LOG_ARCHIVE_DEST_n parameter with SERVICE attribute set (DataGuard Broker Configuration)

by

The ORA-16698 error in Oracle indicates that a Data Guard member has a LOG_ARCHIVE_DEST_n parameter with the SERVICE attribute set, which is causing a conflict or an incorrect configuration in your Data Guard setup. Solution : Steps to Resolve ORA-16698 1. Check Current LOG_ARCHIVE_DEST_n Parameters2. Modify the Incorrect Parameter3. Validate the Data Guard Configuration4. Check … Read more