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
      • 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
    • Dataguard
      • 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
  • ExaDB
    • 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
  • MS-SQL
    • 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?
  • PostgreSQL
    • 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
  • DB2
    • Install DB2 V10.5 using GUI
    • DB2 STOP and START
    • DB2 Troubleshooting Guide
  • DevOps
    • How to Install Jenkins on Linux
  • AWS

4

Published on November 28, 2020 in Restore Database without Tail BackupFull resolution (370 × 216)
← Previous Next →
About me - Rajasekhar Amudala