Month: March 2025

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