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:33] – 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>
      
-=== Check Current Logs ===+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 ===
  
 <code>SELECT GROUP#, STATUS FROM V$LOG;</code> <code>SELECT GROUP#, STATUS FROM V$LOG;</code>
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 ===
 +
 +<code>set linesize 120
 +col MEMBER format a60
 +SELECT A.GROUP#, A.MEMBER, B.BYTES
 +FROM V$LOGFILE A, V$LOG B WHERE A.GROUP# = B.GROUP#;</code>
  
redo_logs.1450434823.txt.gz · Last modified: 2025/03/08 22:23 (external edit)