Restore Pluggable database with RMAN Advisory Recover the Pluggable database with RMAN advisory from CDB completed backup in Oracle. Error:SQL> alter pluggable database pdb3 open;alter pluggable database pdb3 open*ERROR…
Issue When i tried to connect with the database then i got the following error.ORA-27101: shared memory realm does not exist ErrorSQL*Plus: Release 12.1.2 – Production on Mon May 07…
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…
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…
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…
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…
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.…
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…
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…