DB Wiki

User Tools

Site Tools

Trace:
redo_logs

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
redo_logs [2015/12/18 10:34] – z0hpvkredo_logs [2025/03/08 22:24] (current) – external edit 127.0.0.1
Line 21: Line 21:
   3  '/u03/app/oradata/redo06b.log') SIZE 500M;</code>   3  '/u03/app/oradata/redo06b.log') SIZE 500M;</code>
      
 +To add a log file to an existing redo log group ...
 +<code>ALTER DATABASE ADD LOGFILE MEMBER TO GROUP 1;</code>
 +Note that the status of the logfile will be invalid before it is used.
 +
 === Check Status of Current Logs === === Check Status of Current Logs ===
  
Line 38: Line 42:
 ALTER DATABASE DROP LOGFILE GROUP 2; ALTER DATABASE DROP LOGFILE GROUP 2;
 ALTER DATABASE DROP LOGFILE GROUP 3;</code> ALTER DATABASE DROP LOGFILE GROUP 3;</code>
 +
 +To drop individual log files from within a group ...
 +<code>ALTER DATABASE DROP LOGFILE MEMBER '<Full Filename>';</code>
  
 === View Current Log Files === === View Current Log Files ===
redo_logs.1450434885.txt.gz · Last modified: 2025/03/08 22:23 (external edit)