Get Confused after recovering a non-archivelog database
I just did a recover to a production database . But I still have some confusion :
The database is Oracle8.0.X and working in non-archivelog mode .
Today , The database is not opened and It stays in Mount mode , and Ora-01113 indicate there is a datafile need to have media recover .
As I have only last night export backup file and I don't want to jump
to that long recover process (recreate the db , import the file etc)
So I just try recover database in svrmgr ,(without doing anything before )
Lucky , the system report media recover is successful and I can alter database open .
My exprience told me that recover database is only working in archivelog mode and system will prompt me the archive log file . How it works for nonarchivelog mode database ?
One think I can think is maybe the media recover source is redo log file which 'repair' the damage datafile . I guess if the log switch occured before , there would be no hope for this databse being recovered by using this way .
Gurus , Please clarify my understanding .
Re: Get Confused after recovering a non-archivelog database
Quote:
Originally posted by ligang
One think I can think is maybe the media recover source is redo log file which 'repair' the damage datafile . I guess if the log switch occured before , there would be no hope for this databse being recovered by using this way .
You are right.
Sanjay