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 …
Category:
Oracle
-
-
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 …
-
-
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 …