The optimal number of RMAN channels depends on the number of CPU cores physical I/O devices (disks tape drives) and the specific task but a good starting point is to match the number of channels to your physical output devices or to 1-2 less than your total CPU cores to leave resources for the operating system
Archive for the ‘ORACLE Database’ Category
Oracle Database Recovery Manager (RMAN) – how many channels you can allocate
Freitag, August 22nd, 2025Oracle Database AutoUpgrade 25.3 – is designed to automate the upgrade process both before starting upgrades during upgrade deployments and during postupgrade checks and configuration migration
Donnerstag, August 21st, 2025Oracle Database Recovery Manager (RMAN) – for encrypted backups you need a license for the Oracle Advanced Security option
Freitag, August 1st, 2025Split Brain Syndrome – in a Oracle RAC environment all the instances/servers communicate with each other using high speed interconnects on the private network
Montag, März 24th, 2025Split Brain Syndrome – this private network interface or interconnect are redundant and are only used for inter-instance oracle data block transfers. Now talking about split brain concept with respect to oracle RAC systems it occurs when the instance members in a RAC fail to ping/connect to each other via this private interconnect but the servers are all physically up and running and the database instance on each of these servers is also running
Simple Majority Rule according to Oracle “An absolute majority of voting disks configured (more than half) must be available and responsive at all times for Oracle Clusterware to operate” which means to survive from loss of ‘N’ voting disks you must configure at least ‘2N+1′ voting disks. Now we are in a state to understand the use of voting disk in case of heartbeat failure
Oracle GoldenGate Studio Free – deploys from a Docker container onto laptops on-premises or any cloud
Montag, März 17th, 2025Oracle Database 19c Enterprise Edition – Premier Support (PS) ends December 31, 2029 and the Extended Support (ES) will be Jan 01, 2030 through December 31, 2032
Donnerstag, Februar 20th, 2025Oracle Database 19c – offers powerful commands to manage the storage space of tables efficiently among these commands are the ‚ENABLE ROW MOVEMENT‘ ‚SHRINK SPACE‘ and ‚CASCADE‘ options
Freitag, Februar 14th, 2025Oracle – what is a Vector Database and how can it help meet business needs
Samstag, November 23rd, 2024Oracle Database 23ai – damit werden Spitzentechnologien wie maschinelles Lernen (ML) künstliche Intelligenz (KI) und generative KI bereitgestellt um datengesteuerte Entscheidungen zu verbessern
Mittwoch, September 4th, 2024Oracle Database 23ai – sets new industry standard for a modern AI database
Samstag, August 24th, 2024Oracle Database 23ai (for Free) – offers the ability to experience Oracle Database which businesses throughout the world rely on for their mission critical workloads the resource limits for Oracle Database (for Free) are up to 2 CPUs for foreground processes 2 GB of RAM and 12 GB of user data on disk and it is packaged for ease of use and simple download