Add or drop the logfile member from existing redo group

Check the status of redo log file.

set line 200 pages 200
col member for a35
select g.group#,g.member,l.bytes/1024/1024 "Meg",l.status from v$log l,v$logfile g where l.group# = g.group# order by 1,2;

Add the redo member in existing group
you will add the member in each group then use the add command.

ALTER DATABASE ADD LOGFILE MEMBER 'C:\ORACLE\ORADATA\XE\REDO1.LOG' TO GROUP 1;

Drop the redo member from existing redo group
Drop the redo logfile from existing group with following command but you need to manually remove the physical file from the operating system.

ALTER DATABASE DROP LOGFILE MEMBER 'C:\ORACLE\ORADATA\XE\REDO1.LOG';

For changing Active, Current or Inactive Status of redo log files

-- For changing current status of redo 
Alter system switch logfile;

-- For clear active status of redo
Alter system checkpoint; 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.