Following are the way to check current SCN in Oracle Database: 1. Fetch the current SCN number in v$database view.Select CURRENT_SCN from v$database; SQL> Select CURRENT_SCN from v$database;CURRENT_SCN———–3208426 2. Get…
ollowing are the steps used to disable or enable the Dataguard Broker service during upgrade process of Oracle Database: 1. Disable the fast start failover.DGMGRL> DISABLE FAST_START FAILOVER;2. Shutdown the…
Acknowledge Over PGA limit is a new wait event introduced with PGA_AGGREGATE_LIMIT in 12.1 version of Oracle Database. If process need more PGA then process has to wait if instance is…
Configure RMAN Archive log setting for Dataguard Environment Configure:Archive log is not deleted before applied or shipped to all standby Server Cause:In Oracle Dataguard environment, Archive is going to…
In this case you must have archive present in the Server or backup location. So that you applied on Standby Server. 1. Check the GAP between Primary and Standby enviornment.SELECT…
Scripts to start the Dataguard Standby Server after Windows system reboot occurred. Problem: When the window reboot occurred, the DR site of the data guard environment did not come up…
We have archive on Production Server but we need to apply manually on DR server. Archive is present in ASM disk. So We have two option to resolve these: 1.…
Error: ORA-27041: unable to open file Cause:Unable to start the database after adding new disk in diskgroup. Solution: 1. Check the permission of the disks.Note: Need permission at OS level…