http://www.aamirharoon.com/11gr2/ora-01180-can-not-create-datafile-1-during-restore/
It's been a while since I posted any blog. My three boys keep me very busy :)
I came across this error at work and thought it was worth mentioning. Maybe someone else can benefit from it and not spend hours looking for solution.
During a Disaster Recovery exercise, my task was to drop already existing database (it was left there from previous restore) and restore database from current backup.
It is important to note that a database already existed in ARCHIVELOG mode (later on it'll become clear why I am mentioning this).
So, after deleting the database using dbca, I executed restore database command. Immediately after I got the ugly, confusing not enough information error :(
RMAN-03002: failure of restore command
at 09/10/2015 17:04:24
ORA-01180: can not create datafile 1
ORA-01110: data file 1:
'+DG_DATA_01/db1/datafile/system.211.849181900'
:)
:(
:))
:((
=))
=D>
:D
:P
:-O
:-?
:-SS
:-f
d(
:-*
b-(
h-(
g-)
5-p
y-)
c-)
s-)
d-)
w-)
:-h
:X
No comments:
Post a Comment