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. …