Oracle database 11g has a set of online redo log files that are used to record the changes made to the oracle database.Changes recorded here will be eventually written to datafiles using oracle background process RECO. At times changes including changing the location of online redo log files, adding more member to the group can be done online
1) Get details on the status of many different files in the oracle database
select group#,member,status from v$log;
2) Drop the existing online redo log file that is archived and in INACTIVE status
alter database drop logfile group groupnumber;
Please note that above command entries of online redo logfile at the database level and not physically removed from the OS location
3) Add new online redologfiles to the database as follows
alter database add logfile(‘member1′,’member2′,’member3′) size value;
4) Perform log switch to activat the newly added member
alter system switch logfile;
5) Find the status and make sure that it works fine
select group#,member,status from v$log;
6) Remove all the physical logfiles from the OS location
Note that this is a good method to change the location of online redo log files.
FOOD
ASTROLOGY
