|
||||
|
In order to duplicate a database one must use rman duplicate command or manual procedure to copy and restore the files From 19c, DBCA facilitates duplication of db with new “CreateDuplicateDB” Requires easy connection string so that it duplicates the target db to wherever running § From 19c, ability to […] 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 […] In Oracle 19c Grid, Run the Oracle Grid Infrastructure installer in dry-run upgrade mode to determine if the system is ready for upgrade. To perform Oracle Grid Infrastructure dry-run upgrade, create a new Grid home with the necessary user group permissions, extract the Oracle Grid Infrastructure 19c gold image to the new Grid home, and […] 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 […] 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 database or PDB is moved […] Cloud Feature – Not working in On Prem installation. Oracle Database 12c introduced online statistics gathering for CREATE TABLE AS SELECT statements and direct-path inserts. Oracle Database 19c introduces real-time statistics, which extend online support to conventional DML statements. Because statistics can go stale between DBMS_STATS jobs, real-time statistics helps the optimizer generate more optimal […] Edited this post on 30-Apr, to correct my command in the test. Update the post on 22-May, not working in on-prem as expected. Whilst the documentation say’s the auto indexing feature is not available on-prem ones, I tried to test it out. Command to enable auto index mode is below, we have options “Implement”, “Report-Only”, […] Starting Oracle 19c, SQL Quarantine features helps to prevent reuse of same execution plan which was terminated by resource managers due to resource limits. This will help not to run the rouge queries again on the database if the resource manager is active. SQL Quarantine will need to setup configuration and define thresholds for specific […] |
||||
Oracle 23c New Features for DBA's
Follow Me!!!