Oracle Exadata,Oracle Cloud,Oracle-Exacloud,Oracle Rac 19c and Oracle dba

ExaCS -Customer v/s Oracle managed . Customers control and manage software that dire ctly affects their databases . u All Patches pre-staged (OS, GI, DB) u Patch what you want when you want on your schedule u Patching automated through cloud tooling u REST services make scheduling easy . Oracle manages underlying infras tructure u Proactive Hardware Fault Notification u Oracle Patches the following rolling u Servers(dom0) u Storage hardware and software u Networking u Firmware u Hypervisor 

Exadata Cloud Service(ExaCS) u Exadata Cloud Service is offered on Oracle Cloud Infrastructure,within OCI regions. u Exadata Cloud Service available in  quarter Rack, Half Rack or full Rack configurations. u Exadata rack in OCI includes DB nodes, storage nodes and InfiniBand switches. u The storage and compute nodes are connected via high bandwidth Infiniband network that provides RDMA based storage access to the compute nodes. u Exadata storage software runs on storage servers and offloads database SQL processing overheads. u Currently, a single VM per compute node is supported. It allows root access for customers while protecting hardware and network, DB nodes are virtualized using Xen based OVM. u Oracle Manages storage cells, switches, management or IB network while customer manages database compute nodes. u Exadata Cloud Service provides a control Plane, a Web-based self-service management interface for Exadata provisioning and  interactive access to servic...

Add ASM disks to exiting ASM disk group and monitoring Re balancing operation :- Extending and Existing DISK GROUP  :- ASM automatically re balances the disk group when disk are added By default the Alter disk group statement returns immediately after the disk have been added while the re balance operation continues to run asynchronously.you can query the V$ASM_OPERATION view to monitor the status of the re balance operation    You can optionally use the RE BALANCE clause to manually control the re balance process. In the POWER clause,you can specify a value from 0 to 11.A value of 0 disable re balancing for this statement.A value of 1 causes the re balance to take place with minimal resources allocated to it.whereas a value of 11 permits ASM to execute the re balance to the value of the ASM_POWER_LIMIT initialization parameter .    Dropping Disks from an existing DISK group : When a disk is dropped. The disk group is re balanced by moving all the file extents f...

Re balance Power 0  When adding disks to or removing disks from a disk group ,You can effectively disable rebalancing by specifying REBALANCE POWER 0 in the alter diskgroup statement .    When adding disks to disk group in conjuction with REBALNCES POWER 0,the disk become immediately available to the disk group ;however existing data is not moved to the new disks .New data may be written to the new disks .This disk is useful in situations where you need to add disks quickly to a running system and you want to defer the rebalance operation until a later time such a scheduled maintenance periods.  Note - If There is less space in disk group in that case we need to add disk with  Re balance Power 0  option So New added disk it will be available in disk group to write new extend(data)  . Once off Business hour it will start then you can start the re-balance operation so exiting extend it will move new added disk . That is advantages of adding the...

Dropping Disks from an existing DISK group : When a disk is dropped. The disk group is re balanced by moving all the file extents from the dropped disk to other disks in the disk group .A drop disk operation will fail if not enough space is available on the other disk.Data will not be lost by dropping a disk . By default the alter disk group …. Drop disk statement returns before the drop and re balances operations are complete.Do not reuse,remove or disconnect the dropped disk until the  HEADER_STATUS column for this disk in the v$ASM_DISK view changes to FORMER.You can query the v$ASM_OPERATION view to determine the amount of the time remaining for the drop/rebalance operation to complete .    DISK_GROUP_NAME      DISK_FILE_PATH            DISK_FILE_NAME                 DISK_FILE_FAIL_GROUP           HEADER_STATU -------------------- -------------------...

Converting standard cluster to flex cluster  :- The steps for converting a standard cluster to a flex cluster. There are two phases to converting a standard cluster to flex cluster. First phase involves   converting Oracle ASM to Flex ASM   and second phase is to   change the cluster mode to flex . 1)      Current setup is a two node standard cluster . [ root@india1 bin]# ./crsctl get cluster mode status Cluster is running in "standard" mode           $ asmcmd           ASMCMD> showclustermode           ASM cluster : Flex mode disabled 2) There are few per-requisites to converting ASM to flex ASM, these include that OCR, SPFile and password file all stored in a disk group and this group have ASM compatibility (COMPATIBLE.ASM) set to 12.1 or higher. If this is not the case then make the necessary ch...