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.
4 comments:
Your website is very good and nice information was provided in your site, thanks for sharing.
Oracle Training in Hyderabad
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.
Thank you so very much for sharing these issues that we have to face normally. I would love people to suggest this dba course so that you can get full knowledge.
Good blog Thank you so much
SQL DBA Training in Hyderabad
Post a Comment
Thanks for reading till end. I hope this will help you more to improve your knowledge.
Now it's your turn!
What do you think? Share your experience in the comments box and subscribe for more interesting post.