To make administration and problem diagnosis easier in Oracle Clusterware, there is a single consolidated directory structure for the main clusterware log files. This is found under $GRID_HOME/log/[hostname]/ The CRSD logfile – crsd.log is stored in the /crsd/ directory and is archived every 10mb. The CSS logfiles – cssd.log is stored in …
[embedplusvideo height=”328″ width=”584″ standard=”http://www.youtube.com/v/wmc9uxNW99E?fs=1″ vars=”ytid=wmc9uxNW99E&width=584&height=328&start=&stop=&rs=w&hd=0&autoplay=0&react=1&chapters=¬es=” id=”ep5503″ /] Check out part 1 first. Notes: Online Redo Logs Contains Redo and Undo info DML Inserts/Deletes DDL – Create alter drop Commits Need at least 2 files/groups Should be multiplexed each on different devices and controlers When each file fils, next one is started and old one is archived (if …
When a redo log file fills up it switches to the next file. This is called a log switch. The log switch always causes a checkpoint to occur. This flushes all dirty buffers from the log cache. (writes modified data to disk) If archiving is on, the old log file id archived. The new log …