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 Database running in NOARCHIVELOG mode using RMAN   

If you have lost one or more datafiles or some datafiles becomes corrupt due to media failure then when you try to start the database it will give the following error

ORA-01157: cannot identify/lock data file 6 - see DBWR trace file
ORA-01110: data file 6: '/u02/oracle/testdb/test/<datafile_name>'

The above error message will give you the name of the datafile as well as it's location where it is supposed by present.

To overcome this error we need to do recovery of the database.

 If the database is running in NOARCHIVELOG mode then the only option we have is to recover the database from the most recent FULL database backup.

And also do remember there will be data loss i.e. the most recent transactions occurred after the last FULL backup will be lost. This is the disadvantage of running the database in NOARCHIVELOG mode. If the database was running in ARCHIVELOG mode then the recent transactions after the last FULL backup could be recovered from Archive log files.

Tto recover the database using RMAN when the database is running in NOARCHIVELOG mode do the following

Step 1

Start RMAN and start and mount the database

Start and Mount database using RMAN





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