Recovery Manager (RMAN) is a command-line tool provided by Oracle for managing the backup and recovery of Oracle databases. RMAN automates the process of creating backups, restoring datafiles, and recovering the database. Here are some key concepts and commands related to Oracle RMAN.
Category: Backup & Recovery
Oct 26 2023
Recover a Table From a Drop/Truncate/Delete By RMAN
User may drop or truncate a table or delete records accidently which need to recover. Even sometimes we may need to recover the data for a table for corrupted data. This is very difficult to restore the full DB if database size is huge like Terabytes. I will demonstrate with this Article how we can recover …
Nov 13 2021
Improve Backup Performance – Change Tracking
RMAN’s improvement in incremental backup performance is facilitated by its change tracking feature, which records altered blocks in a designated file. Enabling change tracking allows RMAN to efficiently identify changed blocks for incremental backups without the necessity of scanning every block in the datafile.
Feb 18 2021
Create a Trace file for Control file
Sometimes DBA needs to create database creation script from existing database. Oracle provides the “alter database backup controlfile to trace” command to copy the create database syntax into a trace file.
Nov 07 2020
Restoring Corrupted Datafile Using RMAN in Oracle
Datafile corrupt is a partial disaster in database. it will impact for all objects belonging the tablespace. In this case, DBA can either restore the problematic/corrupted datafile from backup.
Nov 07 2020
Performing Block Media Recovery in Oracle
In most cases, the database marks a block as media corrupt and then writes it to disk when the corruption is first encountered. No subsequent read of the block will be successful until the block is recovered. You can only perform block recovery on blocks that are marked corrupt or fail a corruption check.
Oct 27 2020
Configure and Manage RMAN Recovery Catalog
Recovery Catalog: A set of Oracle tables and views used by RMAN to store RMAN repository information about one or more Oracle databases. RMAN uses this metadata to manage the backup, restore, and recovery of Oracle databases. Target Database: In an RMAN environment, the database to which you are connected as TARGET. The target database is …
May 12 2020
Database Backup Script using RMAN
A backup is a copy of data. This copy can include important parts of the database, such as the control file and datafiles. A backup is a safeguard against unexpected data loss and application errors. If you lose the original data, then you can reconstruct it by using a backup. So taking database backup is …
Apr 03 2020
Oracle Data Pump (expdp, impdp) in Oracle Database
The Data Pump feature had been introduced from Oracle 10g. Until Oracle 9i, There were a tradition export and import (exp, imp) tools for logical backup. Nowadays Data Pump (expdp & impdp) utilities are mostly use by oracle DBA. Data Pump is very useful tools to migrate database in difference version of Oracle databases or …
Mar 01 2020
Move or Rename Oracle Files
DBA needs to rename or move oracle file from one filesystem or ASM DISKGroup to another. Move Datafiles Using ALTER DATABASE MOVE DATAFILE command – 12c and onward Moving Datafile Using RMAN with offline option – 10g or 11g Prerequisites: Database should be configured archive log mode.
About Me
- Bachelor of Science in Computer Science, Dhaka, Bangladesh
- Master of Science in Data Warehousing & Data Mining, London, UK
- Master of Science in Computer Science, MIU, IA, USA
- Oracle Cloud Infrastructure Architect Professional
- Oracle OCP 9i-12c
- Oracle OCE RAC and GRID 11g
- Oracle OCS Security 11g
- Oracle PL/SQL OCA 10g
- Red Hat Enterprise Linux 6 RHCE
