|
||||
|
When flashback or point-in-time recovery is performed on the primary database, a standby that is in mounted mode can automatically follow the same recovery procedure performed on the primary When flashback or point-in-time recovery is performed either on a primary database or a PDB in the primary database, the primary […] DBA’s often kill the blocking sessions and from 19c (not sure which patch set) we have new parameter called MAX_IDLE_BLOCKER_TIME parameter which helps to specifies the maximum number of minutes that a blocking session can be idle. After that point, the session is automatically terminated. A session is considered to be a blocking […] Starting 19c , dataguard broker can be put in observe only mode instead performing FSFO. This will help to test the broker conditions that have met. There will be entries in the broker log or observer log indicating Fast start failover would have been initiated. DGMGRL> ENABLE FAST_START FAILOVER OBSERVE ONLY; […] EZConnect is something very useful to make fast connection calls without requiring a TNS. Problem is that, until now, if you want to use some value pairs likes SDU, RETRY_COUNT, CONNECT_TIMEOUT, this wasn’t possible and you would end-up using TNS. Now in 19c you will be able to write something like: sqlplus user/pwd@//DB:1521/host?connect_timeout=100&transport_connect_timeout=10&retry_count=3 […] In Oracle 19c, one can submit the DML to readonly standby database. the internals of the database detect a dml on standby and redirect that dml to primary apply it on primary and apply to standby back. However this require careful consideration of redo generation and identify the potential dml’s or occasional dml;s that […] Autoupgrade is compatible with 12.2 and 18.5 and you need to download the kit from 2485457.1 Autoupgrade.jar is available default in 19c How this works Prevent Issues : Analyze and Fixup Modes java -jar autoupgrade.jar -config config.txt -mode analyze java -jar autoupgrade.jar -config config.txt -mode fixups Simplifying […] Previous versions of Oracle database needs to manually manage the flashback area i.e flashback_retention_target to adjust according to growth of flashback logs Or manually backup the logs/backupsets to tape or to delete them But from Oracle 19c onwards, the management of space in the fast recovery area is simplified. Oracle Database monitors flashback logs […] Starting 19c, We can run DML operations on Active Data Guard standby databases. This enables you to run read-mostly applications, which occasionally execute DMLs, on the standby database. Automatic redirection of DML operations to the primary can be configured at the system level or the session level. The session level setting overrides the system level […] In Previous versions Oracle, When a service moves to an available instance, Oracle Database does not automatically move the service back to the preferred instance when the preferred instance restarts because: The service is running on the desired number of instances. Maintaining the service on the current instance provides a higher level of service availability. […] Desupport of Oracle Real Application Clusters for Standard Edition 2 (SE2) Database Edition. Starting with Oracle Database 19c, Oracle Real Application Clusters (Oracle RAC) is not supported in Oracle Database Standard Edition 2 (SE2). Upgrading Oracle Database Standard Edition databases that use Oracle Real Application Clusters (Oracle RAC) functionality from earlier releases to Oracle Database […] |
||||
Oracle 23c New Features for DBA's
Follow Me!!!