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 .
1. www.dbasupport.com
2. www.dbforums.com
3. www.itpub.net
4. www.csdn.net
5. www.umlchina.com
6. www.tek-tips.com
7. www.cnforyou.com
8. fm365.federal.com.cn
9. www.programmersheaven.com
10.http://msdn.microsoft.com/library/default.asp
ligang1000@hotmail.com