Redologs administration(add,drop,switch)
                                                 Last update (2014-11-27 02:56:13)
                                                                                                                   Date added (2008-02-12 11:43:51)

Summary
Here is some useful information about administration of redologs groups. If you want to move redolog files to new filesystems the technique is adding new groups and dropping the old ones.

Add
For example if you already have 3 redolog groups (4,5,6) and you do not like something about where they reside or their name, or their size then to change the current situation add 3 new groups, lets say 1, 2, 3 using the statements:
ALTER DATABASE ADD LOGFILE GROUP 1 ('/filesystem01/log01a.LOG', '/filesystem02/log01b.LOG') SIZE 500M;
ALTER DATABASE ADD LOGFILE GROUP 2 ('/filesystem02/log02a.LOG', '/filesystem03/log02b.LOG') SIZE 500M;
ALTER DATABASE ADD LOGFILE GROUP 3 ('/filesystem03/log03a.LOG', '/filesystem02/log03b.LOG') SIZE 500M;
Drop
Dropping the redolog groups does not delete the members, you have to delete the files from unix manually. If you cannot delete the groups, do a:
ALTER SYSTEM SWITCH LOGFILE;
ALTER SYSTEM CHECKPOINT;
To drop group member 4 issue:
ALTER DATABASE DROP LOGFILE GROUP 4;
Reviews
Categories
Oracle DBA-> (147)
  Alertlog (3)
  Archivelog (5)
  Auditing (1)
  Backup - Recovery (19)
  Database files (6)
  Database options (2)
  DB links (2)
  Dependencies (1)
  Dictionary (2)
  Exp-Imp Datapump (6)
  Jobs (2)
  Mview (2)
  Networking (3)
  Objects (7)
  Parameters (2)
  Redologs (6)
  Roles - Grants (2)
  Rollback - Undo (8)
  Segments (3)
  Sequences (2)
  Sessions (14)
  SGA (14)
  Tables (10)
  Tablespaces (10)
  Temp (4)
  Toad (5)
  Transactions (1)
  Upgrade (2)
  Users (3)
Oracle APPS DBA-> (66)
Exadata (1)
Performance Tuning-> (59)
Oracle Real Cases (24)
Oracle Errors (23)
Oracle SQL tricks (32)
Oracle RAC (3)
Oracle Security (8)
Filters
Search