Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> UNDOTBS + ARCHIVE LOGS
I am a 'Newbie' to Oracle (we have 9i) and have been doing a lot of
reading about these two features but still can't get a clear idea
about them.
My understanding is that UNDOTBS is automatic undo segment generation
that ORACLE now recommends and REDOLOGGING is the manual rollback
segment option. If ARCHIVELOGGING is set on, archvive log files are
created when the REDO LOGFILES are filled up. Does this still happen
if you are using the automatic UNDOTBS way? or does it mean that
ARCHIVELOGGING is only possible when you have selected the manual
option. Therefore if this is correct this would mean using the
automatic UNDOTBS option would only cater for instance recovery and
not allow a full media restore.
In essence my question is, can you have the automatic UNDOTBS and also
have ARCHIVELOGGING?
Received on Sat Jan 17 2004 - 18:16:17 CST