Bright DBA

ORACLE DBA – Tips and Techniques

Skip to content
  • Home
  • DBA Monitor
    • Scripts
      • DBA Sheet v6.1
      • DBA Sheet v7.0
      • DBA Daily Report
      • Generate INSERT statements from the SELECT query
      • Generate INSERT statements to a flat file using a PL/SQL query
    • OS
    • DATABASE
    • NETWORK
    • STORAGE
  • 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
      • Apply RU on DATABASE 12.2
      • ROLLBACK RU from DATABASE 12.2
      • Apply DB PSU on Standby
    • DB-Admin
      • Create database -DBCA silent mode
      • Drop Database
      • Delete database -DBCA silent mode
      • Create DB 19C – DBCA-GUI
      • Create DB 19C – DBCA-SILENT
      • CREATE NEW PDB BY CLONING AN EXISTING PDB
      • CREATE PDB USING DBCA
      • DROP PDB MANUALLY
      • SCHEMA REFRESH FROM 11G TO 12C PDB
      • CREATE PDB USING SEED
      • CREATE NON-CDB ON ORACLE 12C IN SILENT MODE
      • Configure OEM Express 12c
      • Convert Non-CDB to PDB with DBMS_PDB
      • Create Non-CDB on Oracle 12c using DBCA (GUI)
      • STARTUP/SHUTDOWN CDB AND PDB
      • How to Change MAX_STRING_SIZE on Physical Standby Environment
      • How to change SQL  prompt to show connected user and database name
      • Change Archive Dest
      • Enable Archivelog
      • 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
      • Store DB credentials in Oracle Wallet
      • Under Edit
    • 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
  • PT
    • 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
  • 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
  • Exadata
    • CellCLI Commands
  • 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
  • PostgreSQL New
    • 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
    • PostgreSQL User Management
    • PostgreSQL pg_hba.conf
    • Change Data Directory
    • WAL Files (Redo log files)
    • Change WAL Directory Location (pg_wal)
    • Enable Archive Mode (WAL Archiving)
    • Disable ARCHIVELOG Mode
    • PostgreSQL Tablespace
    • pg_dump & pg_restore
    • Backup and Restore Using pg_dumpall
    • pg_basebackup
    • Clone PostgreSQL Cluster (No Archive Mode)
    • Backup and Restore on Same Host Using pg_basebackup
    • PostgreSQL Backup & Restore+Recover to New Host with WAL Archive files
    • PostgreSQL Point-in-Time Recovery (PITR)
    • Incremental backups in PostgreSQL 17
    • Streaming Replication (Active Dataguard)
    • Failover Streaming Replication
    • Synchronous Replication in PostgreSQL
    • How to setup repmgr for PostgreSQL Automatic Failover
  • DB2
    • Install DB2 V10.5 using GUI
    • DB2 STOP and START
    • DB2 Troubleshooting Guide
  • DevOps
    • How to Install Jenkins on Linux
  • MSSQL
    • 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
    • Authentication Method
    • Create SQL Server Authenticated Login in SQL Server
    • Create Windows Group Authentication Login in SQL Server
    • Create Windows Authentication Login
    • Create SQL Server Authenticated Login in SQL Server
    • Create a new domain user account in Windows
    • SQL Server – Recovery Models
    • Database Backup-FULL-DIFFERENTIAL-TLOG
    • Restore Database without Tail Backup
    • Log Shipping (SQL Server 2022)
    • Windows Server 2022 Failover Cluster
    • Always On Availability Group
  • 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?
  • AWS

11_rolling

Published on February 10, 2020 in Rolling Upgrade With an Existing Physical Standby DatabaseFull resolution (812 × 608)
← Previous
About me - Rajasekhar Amudala