Mar 24, 2009 Â· Hi all, I want to know the purpose of offline redo log files .It is taking up too much of space .I want to delete the files .Can i go ahead.If we don have a system backup can we restore the system with offline redo log files .
Feb 11, 2011 Â· Im looking for a way how to determine offline redo log frequency for past days eventualy longer period of time and also the list of redo logs archived with creation time stamp.
What Is the Redo Log? The most crucial structure for recovery operations is the redo log, which consists of two or more preallocated files that store all changes made to the database as they occur.Every instance of an Oracle Database has an associated redo log â¦
What Is the Archived Redo Log? Oracle Database lets you save filled groups of redo log files to one or more offline destinations, known collectively as the archived redo log.The process of turning redo log files into archived redo log files is called archiving.This process is only possible if the database is running in ARCHIVELOG mode.You can choose automatic or manual archiving.
Sep 25, 2001 Â· After re-creating an online redo log group, continue to re-create (or resize) all online redo log groups until all of them are rebuilt. After rebuilding (resizing) all online redo log groups, here is a snapshot of all physical files: SQL> SELECT a.group#, a.member, b.bytesAuthor: Legendz
Every Oracle database must have at least 2 redo logfile groups. Oracle writes all statements except, SELECT statement, to the logfiles. This is done because Oracle performs deferred batch writes i.e. it does write changes to disk per statement instead it performs write in batches.