In the Oracle documentation, it is said that :
"Rolling forward proceeds through as many redo log files as necessary to bring the database forward in time. Rolling forward usually includes online redo log
files and may include archived redo log files."
also, it is said that :
"NOARCHIVELOG mode protects a database only from instance failure, not from disk (media) failure. Only the most recent changes made to the database,
stored in the groups of the online redo log, are available for instance recovery. "
So, when Oracle does a switch log, db files are updated and only the current redo log file
is needed in case of an instance recovery ? I am right ? If I am wrong, in which case Oracle
needs current log file & unactive log files to perform an instance recovery (DB in no archive mode) ?
Thanks a lot
Click Here to Expand Forum to Full Width