BRIGHT DBA
Remote Database Services
Services
Training
Knowledge Base
Oracle
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
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
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
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
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)
ExaData
Overview
Compute Node
Cell Node
Network
Replacement Runbook
CellCLI Commands
RAC
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 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
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
GG
GG Install
GoldenGate Installation
GoldenGate 12C Installation
Install Oracle GoldenGate 19C for Database 12C
Install Oracle GoldenGate 19C for Database 19C
Replication & Migration
Unidirectional DML Replication
Zero Downtime Migration
DDL Replication
Integrated Capture
Oracle GoldenGate Heterogeneous Replication
Credential Store
ADD NEW TABLE TO AN EXISTING GOLDENGATE CONFIGURATION
OEM
Install OEM 13.2
Install OEM 13.3
Add Targets Manually
Upgrade OMSPatcher
Apply Patch on OMS 13.1
Apply Patch on Agent 13.1
PostgreSQL
New
Installation
PostgreSQL Versions & Features
Create PostgreSQL 17 using Docker CLI
Install PostgreSQL 13 Using Source Code (Offline Method)
Install PostgreSQL 15 using yum Repository on Linux
Install PostgreSQL 17.4 from Source code (Offline Method)
Install PostgreSQL 17.6 using RPM Packages (Offline Method)
Install PostgreSQL 17 client (dnf Method)
Uninstall PostgreSQL 17(RPM Method)
Uninstall PostgreSQL 17(Source Method)
Uninstall PostgreSQL 17 client (dnf Method)
How to Set cluster_name in PostgreSQL
Create a Second PostgreSQL Instance on the Same Linux Server
How to START/STOP PostgreSQL 13 on Linux
Types of Shutdown in PostgreSQL
DBA Scripts
New
Database, User & Security
Create Database in PostgreSQL v1.0
Databases in PostgreSQL v2.0
PostgreSQL User Management - version 1.0
PostgreSQL User & Role Management - version 2.0
PostgreSQL Configuration File(postgresql.conf & auto.conf)
Host-Based Authentication in PostgreSQL (pg_hba conf)
Identity Mapping in PostgreSQL (pg_ident.conf)
Enable SSL in PostgreSQL
Architecture
PostgreSQL Architecture
initdb – PostgreSQL Cluster Initialization
How SELECT, INSERT, UPDATE, and DELETE Work Internally in PostgreSQL
How COMMIT Process work Internally in PostgreSQL
How ABORT/ROLLBACK Works in PostgreSQL
How a Checkpoint Works in PostgreSQL
How PostgreSQL Replay Uncommitted Data During Crash Recovery
WAL Files
Are Uncommitted Transactions Also Written to WAL?
Physical Database Directory Layout on Disk
PostgreSQL Tablespace
PostgreSQL vs Oracle Terminology
PostgreSQL Tablespace Internals
Backup & Recovery
Enable Archive Mode
Disable ARCHIVELOG
Backup & Restore using PostgreSQL COPY
Database Backup and Recovery Using pg_dump in PostgreSQL
Schema Backup and Recovery Using pg_dump in PostgreSQL
Table Backup and Recovery Using pg_dump in PostgreSQL
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
Rejoining an Old Primary as a New Standby After Failover with pg_rewind and Replication Slots
Interview Questions
New
Beginner Level
Intermediate Level
Advanced Level
Replication Manager
PostgreSQL HA Setup with REPMGR + Automatic Failover
Patroni HA (Internal Only)
etcd Cluster Setup
Patroni and Postgres
Haproxy (Load Balancer)
Keepalived VIP
Migrations (Internal Only)
Oracle to PostgreSQL via ora2pg (Internal Only)
EDB Postgres
Install EDB Postgres Advanced Server 17 on Linux 8
PostgreSQL Maintenance
Change Data Directory Path ($PGDATA) in PostgreSQL
Change WAL Directory Path (pg_wal) in PostgreSQL
PostgreSQL Partitioning Basics
MVCC in PostgreSQL
VACUUM in PostgreSQL
ANALYZE in PostgreSQL
Free Space Map (FSM) in PostgreSQL
Visibility Map (VM) in PostgreSQL
SQL Server
Installation
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
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
Create a MySQL Database
User Management
Grant Privileges in MySQL
Create Roles in MySQL
Backup MySQL Using mysqldump
Restore a MySQL Database
Restore a Single Table in MySQL
Restore a Single Database from..
Master-Slave Replication
DB2
Install DB2 V10.5 using GUI
DB2 STOP and START
DB2 Troubleshooting Guide
DevOps
Install Git on Linux
How to Install Jenkins on Linux
Install Docker on Linux
Docker Cheat Sheet
MongoDB
MongoDB 7.0 Install - Tarball
About
Contact Us
Menu
Skip to content
Services
Training
Knowledge Base
Oracle
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
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
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
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
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)
ExaData
Overview
Compute Node
Cell Node
Network
Replacement Runbook
CellCLI Commands
RAC
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 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
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
GG
GG Install
GoldenGate Installation
GoldenGate 12C Installation
Install Oracle GoldenGate 19C for Database 12C
Install Oracle GoldenGate 19C for Database 19C
Replication & Migration
Unidirectional DML Replication
Zero Downtime Migration
DDL Replication
Integrated Capture
Oracle GoldenGate Heterogeneous Replication
Credential Store
ADD NEW TABLE TO AN EXISTING GOLDENGATE CONFIGURATION
OEM
Install OEM 13.2
Install OEM 13.3
Add Targets Manually
Upgrade OMSPatcher
Apply Patch on OMS 13.1
Apply Patch on Agent 13.1
PostgreSQL
New
Installation
PostgreSQL Versions & Features
Create PostgreSQL 17 using Docker CLI
Install PostgreSQL 13 Using Source Code (Offline Method)
Install PostgreSQL 15 using yum Repository on Linux
Install PostgreSQL 17.4 from Source code (Offline Method)
Install PostgreSQL 17.6 using RPM Packages (Offline Method)
Install PostgreSQL 17 client (dnf Method)
Uninstall PostgreSQL 17(RPM Method)
Uninstall PostgreSQL 17(Source Method)
Uninstall PostgreSQL 17 client (dnf Method)
How to Set cluster_name in PostgreSQL
Create a Second PostgreSQL Instance on the Same Linux Server
How to START/STOP PostgreSQL 13 on Linux
Types of Shutdown in PostgreSQL
DBA Scripts
New
Database, User & Security
Create Database in PostgreSQL v1.0
Databases in PostgreSQL v2.0
PostgreSQL User Management - version 1.0
PostgreSQL User & Role Management - version 2.0
PostgreSQL Configuration File(postgresql.conf & auto.conf)
Host-Based Authentication in PostgreSQL (pg_hba conf)
Identity Mapping in PostgreSQL (pg_ident.conf)
Enable SSL in PostgreSQL
Architecture
PostgreSQL Architecture
initdb – PostgreSQL Cluster Initialization
How SELECT, INSERT, UPDATE, and DELETE Work Internally in PostgreSQL
How COMMIT Process work Internally in PostgreSQL
How ABORT/ROLLBACK Works in PostgreSQL
How a Checkpoint Works in PostgreSQL
How PostgreSQL Replay Uncommitted Data During Crash Recovery
WAL Files
Are Uncommitted Transactions Also Written to WAL?
Physical Database Directory Layout on Disk
PostgreSQL Tablespace
PostgreSQL vs Oracle Terminology
PostgreSQL Tablespace Internals
Backup & Recovery
Enable Archive Mode
Disable ARCHIVELOG
Backup & Restore using PostgreSQL COPY
Database Backup and Recovery Using pg_dump in PostgreSQL
Schema Backup and Recovery Using pg_dump in PostgreSQL
Table Backup and Recovery Using pg_dump in PostgreSQL
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
Rejoining an Old Primary as a New Standby After Failover with pg_rewind and Replication Slots
Interview Questions
New
Beginner Level
Intermediate Level
Advanced Level
Replication Manager
PostgreSQL HA Setup with REPMGR + Automatic Failover
Patroni HA (Internal Only)
etcd Cluster Setup
Patroni and Postgres
Haproxy (Load Balancer)
Keepalived VIP
Migrations (Internal Only)
Oracle to PostgreSQL via ora2pg (Internal Only)
EDB Postgres
Install EDB Postgres Advanced Server 17 on Linux 8
PostgreSQL Maintenance
Change Data Directory Path ($PGDATA) in PostgreSQL
Change WAL Directory Path (pg_wal) in PostgreSQL
PostgreSQL Partitioning Basics
MVCC in PostgreSQL
VACUUM in PostgreSQL
ANALYZE in PostgreSQL
Free Space Map (FSM) in PostgreSQL
Visibility Map (VM) in PostgreSQL
SQL Server
Installation
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
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
Create a MySQL Database
User Management
Grant Privileges in MySQL
Create Roles in MySQL
Backup MySQL Using mysqldump
Restore a MySQL Database
Restore a Single Table in MySQL
Restore a Single Database from..
Master-Slave Replication
DB2
Install DB2 V10.5 using GUI
DB2 STOP and START
DB2 Troubleshooting Guide
DevOps
Install Git on Linux
How to Install Jenkins on Linux
Install Docker on Linux
Docker Cheat Sheet
MongoDB
MongoDB 7.0 Install - Tarball
About
Contact Us
Search for:
pp
Published on
December 31, 2018
in
Post #7
Full resolution (640 × 640)
Next
→