FREE POSTGRESQL DBA TRAINING in తెలుగు SOON !!!
br8dba.com — Learn from a Senior DBA for FREE PostgreSQL DBA Training for Beginners in తెలుగు PostgreSQL Architecture, Installation, Configuration Files, User & Role Management Backup & Recovery, Replication, Streaming Replication, High Availability FREE Online Hands-on Sessions br8dba.com — Learn from a Senior DBA for FREE PostgreSQL DBA Training for Beginners in తెలుగు PostgreSQL Architecture, Installation, Configuration Files, User & Role Management Backup & Recovery, Replication, Streaming Replication, High Availability FREE Online Hands-on Sessions

BRIGHT DBA

ORACLE DBA – Tips and Techniques

Skip to content
  • Home
  • 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
        • DBA Monitor
          • DBA Sheet v7.0 popular
          • OS-DB-Commands
          • Database-Scripts
          • Generate INSERT statements from the SELECT query
          • Generate INSERT statements to a flat file using a PL/SQL query
        • 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-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
        • Tuning
          • Oracle Tuning Stage 1
            • Statistics
            • Oracle Histograms
            • Export/Import schema statistics
            • CONTROL MANAGEMENT PACK ACCESS
            • Generate Explain Plan
            • SQL Query is really hanged or not
          • Oracle Tuning Stage 2
            • STATSPACK
            • ASH
            • AWR
            • Colored SQL_ID
            • SYSAUX Tablespace
          • Oracle Tuning Stage 3
            • Troubleshooting Long Running Queries popular
            • 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) - Internal Only
            • Fire-Fighting Analysis (Ongoing / Live Issues)
              • Explain Plan Analysis
              • Top SQL Analysis
              • 10046 Trace Analysis
              • 10053 Trace Analysis
            • Forensic Analysis (RCA – Completed Issues)
        • 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 & Recovery
          • 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
        • 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
            • Enable Real-Time Apply
            • Refresh Standby Database using RMAN Incremental SCN Backup
            • Resetlogs on Primary where Standby in place
            • Drop SRL
          • 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
  • ExaData
    • Oracle Exadata – Overview
    • Exadata DB Server (Compute Node)
    • Exadata Storage Server (Cell Node)
    • ExaData infi Network
    • Exadata Part Replacement Runbook
    • CellCLI Commands
  • RAC
        • RAC Install
          • Create users, groups and Paths for Oracle RAC
          • 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
        • ASM
          • Configure UDEV Rules for Oracle ASM
          • Configure ASMLib for Oracle ASM
          • Move ASM Spfile to diff. DiskGroup
          • ASM Commands
          • Instantiating disk: failed
          • CSSD won’t start automatically
          • Create ACFS File System on RAC
        • 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 Standby 12.2
        • RAC Tools
          • CLUVFY
          • OSWatcher
  • 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
  • PostgreSQLNew
        • PostgreSQL Installation & Basics
          • PostgreSQL Versions & Features
          • Install PostgreSQL 15 using yum Repository on Linux
          • Install PostgreSQL Using Source Code
          • Install PostgreSQL 17.4 from Source code
          • How to START/STOP PostgreSQL 13 on Linux
          • Create Database in PostgreSQL
        • PostgreSQL DBA Interview QuestionsNew
          • Beginner Level
          • Intermediate Level
          • Advanced Level
        • PostgreSQL DBA ScriptsNew
        • PostgreSQL Storage & Architecture
          • PostgreSQL Architecture
          • initdb – PostgreSQL Cluster Initialization
          • PostgreSQL DBA Terminology
          • PostgreSQL vs Oracle Terminology
          • PostgreSQL Tablespace Internals
          • Change Data Directory
          • WAL Files
          • Change pg_wal path
          • PostgreSQL Tablespace
        • PostgreSQL Security & User Management
          • PostgreSQL User Management
          • pg_hba conf
        • 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
        • Replication Manager (repmgr)
          • PostgreSQL HA Setup with REPMGR + Automatic Failover
        • Patroni HA
          • etcd Cluster Setup
          • Patroni and Postgres
          • Haproxy (Load Balancer)
          • Keepalived VIP
        • Oracle to PostgreSQL via ora2pg
        • EDB Postgres
  • SQL Server
        • 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
        • SQL Server 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
        • 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
        • SQL Server 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?
  • DB2
    • Install DB2 V10.5 using GUI
    • DB2 STOP and START
    • DB2 Troubleshooting Guide
  • DevOps
    • Install and Configure Git on Linux 9
    • How to Install Jenkins on Linux
    • Install Docker on Linux
    • Docker Cheat Sheet

Monitor

1. DAY TO DAY

Still Page under construction !!!

About me - Rajasekhar Amudala