Oracle DBA (12c/19c) Articles and Scripts

  From USER satisfaction point of view, the major DBA responsibilties are Data Protection - (user accounts/passwords, quota, roles, privileges etc) Data Accountability - (audit, redologs/archives, backups) Data High Available - (DR solutions thru Cluster & Replication solutions) Data High Security - (table level, column level, row level, remote, network security) "Ensure to fast THROUPUT and/or RESPONSE TIME" --- which is important from PERFORMANCE TUNING point of view. Performance Tuning goal Performance Tuning goal is to see the best THROUPUT and  RESPONSE  TIME. Performance Tuning is a 'Iterative and Continuous process'. Yesterday fix/finding is not all the times standard for tomorrow issue. Because... Everyday is unique to the database. Its frequent data changes, increase and decrease in volume size, statistics changes, new deployments etc. It involves, I/O fluctuations relating to Disk, IP and network etc.  DBA usually experience and fix the performance and t

  It is always possible to loose archivelogs in our Prmiary-Standby Database configurations. When we loose even only one archivelog file, a gap would occur and the automatic recovery of our standby database stops. We'd have several methods to resolve the gaps: ·                        Restore the archivelogs from backup and apply them manually ·                        Create incremental backup from primary and recover standby. With the release of 12c, we have a new method to resolve the gaps;  --->Restore & Recover from Network Service  Steps: 1. Check the status: SQL> SELECT distinct PROCESS, STATUS, THREAD#, SEQUENCE# FROM V$MANAGED_STANDBY order by process;    PROCESS   STATUS          THREAD#  SEQUENCE# --------- ------------ ---------- ---------- ARCH      CLOSING               1         82 ARCH      CLOSING               1         89 ARCH      CONNECTED             0          0 MRP0      WAIT_FOR_GAP          1         86 RFS       IDLE                  0          0

Hello friends, this is something fun which I came across, while trying to troubleshoot an ASM issue. Usually we know that the diskgroups are an important entity of the ASM infrastructure and working of the database depends a lot upon them. This particular issue was seen on the standalone ASM database. The ASM diskgroup was nowhere to be found while querying the v$asm_diskgroup and v$asm_disks dynamic tables. Cause? There was a change in the hostname of the server, we had to reconfigure the Oracle restart. Post the changes, we ran the  crsctl stat res -t  command to check the status of the resources. --------------------------------------------------------------------------------NAME           TARGET  STATE        SERVER                   STATE_DETAILS   -----------------------------------------------------------------------------   Local Resources   -------------------------------------------------------------------------------ora.asm                  ONLINE  ONLINE       testdev03  

Oracle Database 19c, is the long term support release of the Oracle Database 12c and 18c family of products, offering customers Premier and Extended Support through to March 2023 and March 2026 respectively. It is available on Linux, Windows, Solaris, HP/UX and AIX platforms as well as the Oracle Cloud. Oracle Database 19c offers customers the best performance, scalability, reliability and security for all their operational and analytical workloads. Installation and Upgrades RPM Based Installation  install Oracle 19c Database using RPM method Simplified Image based installation of client as well Auto Upgrade Utility for Oracle Database Docker Container for Oracle 19c DryRun mode for GridSetup in clusterware Installation General Clear flashback logs from time to time Passwords removed from user accounts (default accounts) Flush Metadata Cache for Passwords Multi-model partitioning with Hybrid partitioning allowing some partitions in database and some as external partitions even in HDFS