Bright DBA

ORACLE DBA – Tips and Techniques

Skip to content
  • Home
  • DBA Monitor
    • DBA Sheet v7.0
    • OS-DB-Commands
    • Database-Scripts
    • Generate INSERT statements from the SELECT query
    • Generate INSERT statements to a flat file using a PL/SQL query
  • Oracle
    • DB-Install
      • Install Oracle AI Database 26ai
      • Install 19c GUI
      • Install 19c in silent mode
      • Install 18c
      • Install 12.2 Database Binaries in silent mode
      • Install Oracle Software in silent mode 11gR2
      • Install 10g
      • Deinstall Oracle 11gR2 Database binaries
      • Deinstall Oracle 18c Database Binaries
      • Oracle 19c Deinstall
      • Uninstall Oracle Client on Windows
    • DB-Upgrade
      • Upgrade DB using DBUA from 11.2.0.4 to 12.2.0.1
      • Upgrade DB Manually 11.2.0.4 to 12.2.0.1
      • Upgrade Oracle Database from 12.2.0.1 to 19c using DBUA
      • Upgrade Oracle Database Manually from 12.2.0.1 to 19c
      • Rolling Upgrade With an Existing Physical Standby Database
      • Upgrade TIMEZONE Version
      • Upgrade Database to 12.2 with Physical Standby
    • Patching
      • Patch Terminology
      • Apply Patch RU on Database 19c
      • 18c DB Patching
      • 18c DB Patching – Youtube
      • Apply RU on DATABASE 12.2 (CDB/PDB)
      • ROLLBACK RU from DATABASE 12.2
      • Apply DB PSU on Standby
    • DB-Admin
      • Oracle Container Database (CDB)
        • CREATE NEW PDB BY CLONING AN EXISTING PDB
        • CREATE PDB USING DBCA
        • CREATE PDB USING SEED
        • DROP PDB MANUALLY
        • STARTUP/SHUTDOWN CDB AND PDB
        • Convert Non-CDB to PDB with DBMS_PDB
        • SCHEMA REFRESH FROM 11G TO 12C PDB
      • Non-CDB
        • Store DB credentials in Oracle Wallet
        • Create database -DBCA silent mode
        • Drop Database
        • Delete database -DBCA silent mode
        • DBT-06103 The port (1,522) is already used – DBCA
        • Create DB 19C – DBCA-GUI
        • Create DB 19C – DBCA-SILENT
        • CREATE NON-CDB ON ORACLE 12C IN SILENT MODE
        • Configure OEM Express 12c
        • Create Non-CDB on Oracle 12c using DBCA (GUI)
        • How to Change MAX_STRING_SIZE on Physical Standby Environment
        • How to change SQL  prompt to show connected user and database name
        • Enable Archivelog
        • Change Archive Dest
        • How to Recover Loss of DATA – (Without a Backup!)
        • Configure OEM DBConsole manually
        • Proxy User
        • Database Link
        • DBMS_SCHEDULER
        • Enable/Disable JOBS during Maintenance
        • ORA-00054
        • Blocking Sessions
        • Create Service using DBMS_SERVICE
        • Error TNS-12543
      • Under Edit
    • BACKUP
      • How to Recover Loss of DATA – (Without a Backup!)
      • BACKUP ORACLE HOME AND INVENTORY
      • SCHEMA REFRESH FROM 11G TO 12C PDB
      • RMAN-CATALOG
      • RMAN Database Restore RAC – RAC
      • RMAN Database Restore ASM – ASM
      • RMAN Database Restore from ASM to File System
      • RMAN ACTIVE DUPLICATION ASM TO ASM
      • Backup Based RMAN Duplicate Database
  • ExaDB
    • Oracle Exadata – Overview
    • Exadata DB Server (Compute Node)
    • Exadata Storage Server (Cell Node)
    • ExaData infi Network
    • Exadata Part Replacement Runbook
    • CellCLI Commands
  • P.Tuning
    • Tuning Stage 1
      • Statistics
      • Oracle Histograms
      • Export/Import schema statistics
      • CONTROL MANAGEMENT PACK ACCESS
      • Generate Explain Plan
      • SQL Query is really hanged or not
    • Tuning Stage 2
      • STATSPACK
      • ASH
      • AWR
      • Colored SQL_ID
      • SYSAUX Tablespace
    • Tuning Stage 3
      • Troubleshooting Long Running Queries
      • SQL Tuning Advisor
      • SQLT
        • How to Install SQLT
        • How to Run SQLT
        • How to Create Custom SQL Profile
        • Uninstall SQLT
      • Tracing
      • TRCA – Trace Analyzer
    • FF Analysis (Advanced Troubleshooting)
      • Fire-Fighting Analysis (Ongoing / Live Issues)
        • Explain Plan Analysis
        • Top SQL Analysis
        • 10046 Trace Analysis
        • 10053 Trace Analysis
      • Forensic Analysis (RCA – Completed Issues)
  • HA
    • CONFIGURATION
      • Active Dataguard on Non-ASM
      • Active Dataguard on ASM
      • Convert Physical Standby Database to Snapshot Standby Database
      • Convert Snapshot Standby database to Physical Standby database
      • Configure Cascading Standby Database
      • DG Broker Configuration
      • DG Broker Error – ORA-16714
      • Disable DG Broker
      • 12.2 Active Dataguard in CDB on Non-ASM
      • Create Physical Standby using RMAN Backup Without Duplicate Command
      • Create Physical Standby using RMAN Backup with Duplicate Command
      • 12c DG Broker Configuration
    • SWITCHOVER
      • Switchover Manual No-Broker
      • Switchover with Broker
    • FAILOVER
      • Failover with Broker(No Flashback)
      • Failover with No Broker (No Flashback)
      • Failover with Broker using Flashback
      • Failover with No Broker using Flashback
    • Enable Real-Time Apply
    • Refresh Standby Database using RMAN Incremental SCN Backup
    • Resetlogs on Primary where Standby in place
    • Drop SRL
  • RAC
    • Create users, groups and Paths for Oracle RAC
    • Configure ASMLib for Oracle ASM
    • Configure UDEV Rules for Oracle ASM
    • ASM
      • Move ASM Spfile to diff. DiskGroup
      • ASM Commands
      • Instantiating disk: failed
      • CSSD won’t start automatically
    • RAC Install
      • RAC Install 11.2.0.3
      • Upgrade GI to 11.2.0.4
      • Downgrade GI to 11.2.0.3
      • root.sh failed with ORA-29783 on RAC
      • Delete Node
      • Add Node
      • Delete Node without remove software
      • Add Node Back which was DELETED without remove software
    • RAC Admin
      • How to take OCR backup on 11.2.0.4
      • Cluster Name
      • Move/Relocate OCR
      • Restore loss of all VOTE disk
      • Cluster Startup issues
      • Add SCAN
    • RAC Tools
      • CLUVFY
      • OSWatcher
    • RAC Standby 12.2
    • Create ACFS File System on RAC
  • GG
    • GoldenGate Installation
    • Unidirectional DML Replication
    • Zero Downtime Migration
    • DDL Replication
    • GoldenGate 12C Installation
    • Integrated Capture
    • Oracle GoldenGate Heterogeneous Replication
    • Credential Store
    • ADD NEW TABLE TO AN EXISTING GOLDENGATE CONFIGURATION
    • Install Oracle GoldenGate 19C for Database 12C
    • Install Oracle GoldenGate 19C for Database 19C
  • OEM
    • Install OEM 13.2
    • Install OEM 13.3
    • Add Targets Manually on EM Cloud Control 13c
    • Upgrade OMSPatcher
    • Apply Patch on OMS 13.1
    • Apply Patch on Agent 13.1
  • SQL Server
    • Installation & Basics
      • SQL Server Basics
      • Install Microsoft SQL Server Express 2014
      • Install Only SQL Server Management Studio
      • Create Database using GUI
      • Enable TCP/IP Connection
      • Allow Remote Connection
    • Security & User Management
      • Authentication Method
      • Create a new domain user account in Windows
      • Create Windows Authentication Login
      • Create SQL Server Authenticated Login in SQL Server
      • Create Windows Group Authentication Login in SQL Server
    • Backup & Recovery
      • SQL Server – Recovery Models
      • Database Backup-FULL-DIFFERENTIAL-TLOG
      • Restore Database without Tail-log Backup
      • Restore Database with Tail-log Backup
    • High Availability
      • Log Shipping (SQL Server 2022)
      • Windows Server 2022 Failover Cluster
      • Setup 4 Node Always On Availability Group
      • Who is NT AUTHORITY\SYSTEM?
      • Add Database to Existing AG using Backup and Restore
      • Manual Failover (Planned)
      • Automatic Failover (Unplanned)
  • MySQL
    • Install MySQL 8 on Linux 7 Using RPM Packages
    • Create MySQL Database
    • Create New User Account in MySQL
    • Grant Privileges in MySQL
    • Create Roles in MySQL
    • How To Backup MySQL Database Using mysqldump
    • How to Restore Database from Single MySQL Database Backup
    • How to Restore A Single Database From A Backup File Which Contains Multiple Databases
    • How To Restore Single Table From Full Database Backup in MySQL
    • How To Configure MySQL Master-Slave Replication?
  • MariaDB
  • PostgreSQLNew
    • Installation & Basics
      • PostgreSQL Versions & Features
      • Install PostgreSQL 15 using yum Repository on Linux
      • Install PostgreSQL Using Source Code
      • How to START/STOP PostgreSQL 13 on Linux
      • Create Database in PostgreSQL
    • Security & User Management
      • PostgreSQL User Management
      • pg_hba conf
    • Storage & Architecture
      • Change Data Directory
      • WAL Files
      • Change pg_wal path
      • PostgreSQL Tablespace
    • Backup & Recovery
      • Enable Archive Mode
      • Disable ARCHIVELOG
      • Logical – pg_dump and pg_restore (Backup & Restore)
      • Logical – pg_dumpall (Backup & Restore)
      • Physical – pg_basebackup (Backup and Restore)
      • Backup & Restore to Another Host (No Archive Mode)
      • Backup & Restore on Same Host
      • Restore PostgreSQL to New Host using pg_basebackup + WAL Archives
      • PostgreSQL PITR – Point in Time Recovery
    • High Availability
      • Streaming Replication
      • Manual Failover – Streaming Replication
      • Synchronous Replication
    • PostgreSQL DBA Interview Questions
      • Beginner Level
      • Intermediate Level
      • Advanced Level
    • Replication Manager (repmgr)
      • PostgreSQL HA Setup with REPMGR + Automatic Failover
    • Patroni HA
      • etcd Cluster Setup
      • Patroni and Postgres
      • Haproxy (Load Balancer)
      • Keepalived VIP
    • Postgres DBA Scripts
    • EDB Postgres
  • DB2
    • Install DB2 V10.5 using GUI
    • DB2 STOP and START
    • DB2 Troubleshooting Guide
  • MongoDB
  • DevOps
    • How to Install Jenkins on Linux

PostgreSQL DBA Interview Questions

1. PostgreSQL DBA Beginner Level  Interview Questions 

2. PostgreSQL DBA Intermediate  Level Interview Questions 

3. PostgreSQL DBA Advanced Level  Interview Questions 

Database Architect

Database Architect

Rajasekhar Amudala

Database Architect | 16+ Years

Certifications:
• Oracle 11g & 10g OCP
• Oracle RAC Certified Expert (OCE)
• Oracle GoldenGate Certified
• Oracle Exadata Certified
• OCI Architect Professional
• MBA

📧 br8dba@gmail.com
🔗 linkedin.com/in/rajasekhar-amudala

About me - Rajasekhar Amudala