Error: When i tried to set the log_archive dest value then i got the following error:SQL> ALTER SYSTEM SET log_archive_dest=’D:oraclexe’;ALTER SYSTEM SET log_archive_dest=’D:oraclexe’*ERROR at line 1:ORA-02097: parameter cannot be modified…
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…
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…
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.…