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.



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

Solution

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