Oracle 23c New Features for DBA'sFrom 18c, we can have Shared Scan Listeners between clusters instead of having different scan listener for each cluster. This will save a lot of IP’s and configuration aspect. For example, instead of 10 clusters deploying 3 SCAN VIPs per cluster using a total of 30 IP addresses, with shared SCAN deployments, you only deploy […]
|
||||
|
In this post, we will see few important ASM Disk group Level Enhancements in 18c. DISK_REPAIR_TIME : Increased from 3.5 hrs to 12 Hrs When a disk is taken offline from a disk group , the diskgroup will not immediately dropped as it waits for 3.5 Hrs as DISK_REPAIR_TIME , but now that […] In this post we cover two aspects of new features in 18c. Readonly Oracle Home: A read-only Oracle home separates the software from the database configuration information and log files. This separation enables you to easily share the software across different deployments. A read-only Oracle home also simplifies version control and standardization. To enable the […] Hi From 12cR2 and 18c, you can cancel the session instead of killing it which is long running and consuming time and resources. The following is the syntax for cancelling a SQL statement: ALTER SYSTEM CANCEL SQL ‘SID, SERIAL, @INST_ID, SQL_ID’; If @INST_ID is not specified, the instance ID of the current session is used. […] Hi, We all aware of, when a table has attribute set with nologging option , those redo will be missed (although redo information there, the data will be missed) and standby will not apply those changes, and this will problematic when you do a switchover or failover unless you use force logging mode. To address […] Starting 18c, we can create a clone of PDB using ASM level mirror copy the diskgroup with a point in time recovery of the PDB database. This will be really helpful when you want to clone the PDB in the same instance and a point-in-time database clone is a full copy of a specific database, […] As we all aware , that we can have only one instance of Standby running with MRP (redo apply) running in RAC environments. Starting 12.2.0.1, we can have multiple instances on standby side too with following command. Generally, to start the MRP process we use, ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION; Now […] In previous post, you have seen the PSM utility installation and using PSM utility, In this post you will learn how to use CLI to effectively manage the databases using commands. #Create Database using Json file C:\Users\gandhi\Desktop>psm dbcs create-service -c 18cdatabase.json Job ID : 1986734 # Check the Service aka database config C:\Users\gandhi\Desktop>psm dbcs service […] Hello All In this post, we see how to install the PSM (Paas Service Manager) CLI utility to manage the cloud operations for Oracle. It has vide range of commands to manage different resources and can be useful to automate the Oracle Cloud Infrastructure operations. The following will be covered in this post. Install Python […] In 12c, we can have refreshable PDB from one PDB to another PDB via database link. –Manual Refresh CREATE PLUGGABLE DATABASE pdb_ref FROM pdb1@pdb_link REFRESH MODE MANUAL; — Automatically refresh ever 60 minutes. CREATE PLUGGABLE DATABASE pdb_ref FROM pdb1@pdb_link REFRESH MODE EVERY 60 MINUTES; In 18c, this is extended and we can switchover the primary […] |
||||
Follow Me!!!