Restore and Recover the noarchivelog database.
Suppose any
datafile lost and we trying to recover the oracle database in noarchivelog mode ,it
will give the below error.
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 any 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.
SQL> SHUTDOWN IMMEDIATE;
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 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.
