How to restore and recover noarchivelog database

In this post we cover how Restore and Recover the noarchivelog database.

How to restore and recover noarchivelog database.| In this post we cover how Restore and Recover the noarchivelog database
How to restore and recover noarchivelog database
Suppose any datafile lost and we trying to recover the oracle database in noarchivelog mode, it will give the below error.


Here we are facing error while recovering database.
RMAN> recover database;

Starting recover at 24-MAR-18
using channel ORA_DISK_1
starting media recovery
media recovery failed
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-03002: failure of recover command at 03/24/2018 12:10:58
ORA-00283: recovery session canceled due to errors
RMAN-11003: failure during parse/execution of SQL statement: alter database recover if needed
start until cancel
ORA-00283: recovery session canceled due to errors
ORA-01124: cannot recover data file 1 – file is in use or recovery
ORA-01110: data file 1: ‘/data01/UAT3/data01/system01.dbf’
In this scenario, Using RMAN we can’t recover the database if no valid rman backup (either in archivelog or noarchivelog mod).
If media failure damage datafiles in noarchivelog mode, then the only option is to restore the database from valid old backup (logical , manual backup).

Steps to restore the most recent whole database on default or new location.

1.Shutdown the Database, if still in open state.
2.Fix the media problem, so that copy the backup datafiles to their location.
3.Restored the Binary file,datafiles,controlfile and parameter file from      backup location to datafile location.
$cp /backup01/PROd/*.dbf’/data01/PROD/datafiles/
4.Do the incomplete recovery from available archivelog using recover database until cancel as below.
  SQL> recover database until cancel;
5.Open the database with open resetlogs.
SQL> alter database open resetlogs;
Note:- To perform the complete recovery , do the database in archivelog mode and schedule the full backup using rman on daily basis.

How to restore and recover noarchivelog database using incremental backup:-

Alternatively, we can do the incomplete recover using incremental strategies. Here we will apply incremental backup. We need to ensure incremental backup is consistent. Before going to start we have to do some important steps to do so. Make sure you are restoring and recovering the on another location.

==> RMAN>startup nomount;

==>RMAN> restore controlfile from autobackup;

==>RMAN> alter database mount;

==>RMAN> restore database;

==>RMAN> recover database noredo;

==>SQL> alter database open resetlogs;

After completion of restore & recovery noarchivelog database, need to be do the consistent backup and oracle always recommend putting database in archive log mode.


==>How to clone EBS and Database using rman backup

==>How to duplicate from active database using rman in oracle database.


==>Monitoring oracle rman backup status and timing.

8 thoughts on “How to restore and recover noarchivelog database”

  1. thanks for sharing the information.Indian Cyber Army is announcing “ Summer Internship 2018” on “ Ethical hacking and Cyber Crime Investigation” for the enthusiasts of Cyber security. Here internship will give you on-the-job experience, help you learn whether you and Cyber security industry are a good match and can provide you with valuable connections and references. Here interns are usually exposed to a wide variety of tasks and responsibilities which allows the intern to showcase their strengths by working on projects for various managers that work on different parts of Indian Cyber Army. Becoming a high performing intern is a fantastic way to improve your employment prospects. This internship can be a great way to get your foot in the door of success with a prestigious or desirable Organization.

  2. thanks for sharing the more valuable information.
    Indian Cyber Army credibility in Ethical hacking training & Cybercrime investigation training is acknowledged across nation as we offer hands on practical knowledge and full assistance with basic as well as advanced level ethical hacking & cybercrime investigation courses. The training is conducted by subject specialist corporate professionals with wide experience in managing real-time ethical hacking/ cyber security projects. Indian Cyber Army implements a blend of academic learning and practical sessions to give the candidate optimum exposure.Ethical hacking training ,
    Ethical hacking course


Leave a Comment