oracle sql and dba tutorial logo


Oracle DBA

Learn Oracle 11g / 12c Database Admin step by step

Oracle SQL

Tutorial for Oracle SQL

Oracle DBA Interview Questions

Most asked Oracle DBA Interview Questions.

60 Technical Questions
42 Backup & Recovery Questions

Unix For Oracle DBA 20 Questions

Download Oracle 11g / 12 c Software

Links to Download Oracle 12c / 11g for Linux, Windows etc.

MySQL Tutorial

Learn MySQL step by step










Recovering from loss of Datafile using RMAN

If some datafiles are lost or become damaged then when we try start the database then database will not start and it will throw error while opening the database. If we were taking backups using RMAN then we recover the database using RMAN.

Case Study

Recover from the loss of a datafile assuming the following


To recover from the damaged or lost datafile using RMAN do the following

Step 1

Try to start the database using SQL Plus

$ export ORACLE_SID=test
$ sqlplus
SQL> startup

When we try to open, Oracle will show an error that a datafile is missing as shown below

startup database

From the above the above output we can clearly see that '/u02/oracle/testdb/test/users01.dbf' datafile is not found or damaged.

Now we need to recover it.

To perform a Complete Recovery of this datafile follow the next step

Step 2

Exit from SQL Plus and start RMAN by typing the following command

$ rman target / nocatalog

start rman for recovery


Continue Next Page



HomeContact Us

Data Loader

Data Loader is a simple yet powerful tool to
export and import Data between many common database formats

Forms Data Loader

Tool to load data into Oracle E-Business Suite R12 / Oracle Apps using Macros and Forms Record and Playback

Interface Computers Academy © 2007-2017 All Rights Reserved