Tagged articles
RMAN
22 articles · Page 1 of 1
This article explains Oracle database backup and recovery fundamentals, covering failure types, logical vs physical backup, RMAN configuration, level 0/1 incremental backup scripts with cron scheduling, flashback technology, and complete vs incomplete recovery methods.
FlashbackOracleRMAN
0 likes · 7 min read


ITPUBSep 26, 2026 · Databases
This comprehensive guide lists 100 essential Oracle DBA commands covering instance management, parameter configuration, session troubleshooting, lock analysis, SQL performance tuning, tablespace and user management, UNDO, temporary tablespace, RMAN backup and recovery, Data Guard, RAC, Data Pump, and OS-level diagnostics, with practical examples and usage notes.
Backup RecoveryDBAData Guard
0 likes · 30 min read

This article walks through three common Oracle OCP exam questions—distinguishing permanent, temporary, and UNDO tablespaces, choosing the correct object versus system privilege syntax, and selecting the safest RMAN command for a hot backup—providing detailed explanations and the correct answers.
OCPOraclePrivileges
0 likes · 6 min read

The article explains why mastering database backup and recovery—including failure types, logical vs. physical backups, flashback, full and partial restores, a weekly backup strategy, RMAN configuration, shell scripts, and monitoring queries—is essential for avoiding costly mistakes and passing a new‑job probation.
OracleRMANRecovery
0 likes · 7 min read


ITPUBApr 12, 2024 · Databases
This guide explains how to rescue both physically and logically deleted Oracle databases, covering RMAN file recovery, full database restoration, flashback table techniques, recycle‑bin usage, flashback database configuration, and essential backup strategies to prevent data loss.
FlashbackOracleRMAN
0 likes · 10 min read

This article explains Oracle database backup and recovery fundamentals, classifies failure types, compares logical and physical backup methods, introduces flashback technology, outlines complete and incomplete recovery, and provides practical RMAN scripts and scheduling tips for reliable data protection.
OracleRMANRecovery
0 likes · 7 min read


ITPUBJul 15, 2021 · Databases
This guide walks through restoring a mistakenly updated Oracle 11.2.0.1 table to a specific point in time using RMAN tablespace recovery on a new host, handling Windows-specific issues, and finally retrieving the data via a database link, with full scripts and step‑by‑step instructions.
DBLINKOracleRMAN
0 likes · 14 min read


ITPUBJun 8, 2020 · Databases
This guide walks through simulating corruption of Oracle password, parameter, control, data, and log files, demonstrates the resulting errors, and provides step‑by‑step RMAN and SQL commands to restore each file type while emphasizing backup best practices.
Control FileFile CorruptionLog File
0 likes · 16 min read

An in‑depth exploration of Oracle 12c’s multitenant architecture explains key concepts, analyzes a real‑world backup failure, and provides a comprehensive, step‑by‑step RMAN procedure—including control file handling, datafile restoration, and selective tablespace skipping—to reliably recover pluggable databases.
OraclePDBRMAN
0 likes · 13 min read


ITPUBFeb 27, 2018 · Databases
This guide answers common Oracle backup questions, covering planning for 50‑TB databases, speed calculations, backup window design, RMAN versus Data Pump, multi‑user and RAC scenarios, catalog usage, performance troubleshooting, and practical SQL queries for monitoring backup status.
Data PumpOracleRMAN
0 likes · 18 min read

This article presents two comprehensive Shell scripts—one to validate Oracle RMAN backup sets and another to perform a full backup‑restore experiment—detailing SSH trust configuration, source information collection, log transfer, directory preparation, and step‑by‑step RMAN restore commands, all illustrated with practical screenshots and a GitHub repository link.
OracleRMANRestore
0 likes · 15 min read


ITPUBFeb 3, 2017 · Databases
This article outlines common Oracle migration pitfalls—including architectural constraints, resource impacts, application coordination issues, and diverse database problems—drawn from real‑world projects, and offers practical guidance to help DBAs anticipate and mitigate these challenges during system cut‑overs, upgrades, and consolidations.
DBADataGuardDatabase Migration
0 likes · 6 min read


ITPUBJan 29, 2017 · Databases
This guide walks through simulating a catastrophic Oracle database failure, performing incremental RMAN backups, verifying backup completeness, and executing a full restore and recovery—including spfile, controlfile, datafiles, and archived logs—so you can confidently recover a database after total data loss.
OracleRMANRestore
0 likes · 15 min read

This guide walks through Oracle's Database Configuration Assistant (DBCA), explaining silent creation commands, template types, seed vs. no‑seed databases, step‑by‑step script generation, and how DBCA ties into multitenant architecture and Data Guard features.
DBCAData GuardDatabase Creation
0 likes · 13 min read


ITPUBOct 11, 2016 · Databases
This guide explains why backup security is critical for enterprise databases, introduces Oracle RMAN's three encryption strategies, and provides step‑by‑step commands to configure password‑based encryption, perform backups, handle decryption errors, and finally disable encryption safely.
OracleRMANbackup
0 likes · 9 min read


ITPUBSep 28, 2016 · Databases
This guide explains what Oracle bad blocks are, how they affect the database, common causes, methods to detect them, and step‑by‑step recovery techniques—including full datafile restore, RMAN block recovery, ROWID range scans, EVENT 10231, and DBMS_REPAIR—plus pre‑emptive detection tools.
Bad BlocksDBMS_REPAIROracle
0 likes · 10 min read


ITPUBAug 10, 2016 · Databases
This guide walks through preparing the primary and standby Oracle 11g databases on RH Linux, configuring listeners, tnsnames, force logging, adding standby redo logs, editing parameter files, transferring files with RMAN, verifying roles, activating Active Data Guard, using snapshot standby, switching logs, and setting an archive‑log deletion policy.
Active Data GuardData GuardDatabase Replication
0 likes · 20 min read


ITPUBJul 28, 2016 · Databases
This guide provides comprehensive Oracle database interview questions and answers covering SQL tuning techniques such as join types, execution‑plan inspection, CBO vs RBO, heavy‑SQL identification, session tracing, index structures, binding variables, plan stability, memory settings, tablespace management, backup and recovery methods including RMAN and standby, as well as system performance diagnostics.
CBOOraclePerformance Diagnosis
0 likes · 19 min read


ITPUBJul 21, 2016 · Information Security
This guide outlines comprehensive Oracle database security hardening measures, covering system‑level protections, disaster‑recovery configuration, account privilege tightening, data access controls, network restrictions, password policies, audit settings, and patch management, with concrete commands and configuration examples for each step.
DataGuardDatabase SecurityHardening
0 likes · 19 min read

This article walks through two unconventional Oracle recovery techniques—restoring a mistakenly deleted datafile by leveraging Linux file descriptors and bypassing a missing archive log with BBED—detailing the scenarios, analysis, step‑by‑step commands, and practical considerations.
BBEDDatafileLinux
0 likes · 9 min read

This article provides a comprehensive walkthrough of Oracle's XTTS technology, covering its evolution, traditional and incremental‑backup workflows, version constraints, detailed configuration steps, real‑world migration timing, common pitfalls, remediation tactics, and a concise Q&A for practitioners.
Best PracticesDatabase MigrationOracle
0 likes · 18 min read

DD Boost integrates tightly with Oracle RMAN to provide a flexible, policy‑driven backup solution that allows DBAs to manage local and disaster‑recovery sites independently, simplifies deployment via a simple plugin, and dramatically improves performance by sending only unique data blocks to Data Domain for deduplication.
DD BoostData DomainOracle
0 likes · 3 min read
