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 .
Re: Get Confused after recovering a non-archivelog database
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 .
I think all redo entries you need to do a recovery are still kept in your redo logfiles. Even log switch had occured, the redo logfiles were in inactive status instead of overwritting by LGWR for you probably have several redo log groups.
The datafile need media recovery is the "last backup" used to do recovery.
Please correct me if I'm on a wrong way.
Oracle Certified Master - September, 2003, the Second OCM in China
*** LOOKING for PART TIME JOB***
Data Warehouse & Business Intelligence Expert
MCSE, CCNA, SCJP, SCSA from 1998