redo scripts

select group#,status,member
from v$logfile;

select group#,members,status,archived
from v$log;

alter database drop logfile member 'C:\esas\oracle\oradata\XE\REDO2M.LOG';
alter database add logfile member '' to group 1;
alter database clear logfile group 1;

SQL> startup mount
SQL> recover database until cancel using backup controlfile
SQL> cancel
SQL> alter database open resetlogs;

alter database drop logfile member 'C:\esas\oracle\oradata\XE\REDO1M.LOG';
alter database drop logfile member 'C:\esas\oracle\oradata\XE\REDO2M.LOG';
alter database drop logfile member 'C:\esas\oracle\oradata\XE\REDO3M.LOG';

SQL> recover database until cancel;
Media recovery complete.
SQL> alter database open resetlogs;
Database altered.

ALTER DATABASE ADD LOGFILE MEMBER 'C:\ESAS\ORACLE\ORADATA\XE\REDO1M.LOG' TO GROUP 1
ALTER DATABASE ADD LOGFILE MEMBER 'C:\ESAS\ORACLE\ORADATA\XE\REDO2M.LOG' TO GROUP 2
ALTER DATABASE ADD LOGFILE MEMBER 'C:\ESAS\ORACLE\ORADATA\XE\REDO3M.LOG' TO GROUP 3

alter database drop logfile member 'C:\ESAS\ORACLE\ORADATA\XE\REDO3M.LOG'
alter database clear logfile group 2;
alter database clear logfile unarchived group 2;
ALTER DATABASE DROP LOGFILE GROUP 2;
ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3;

alter database add logfile group 4 ( 'D:\DATAFILES\ATM\REDO04A.LOG', 'D:\DATAFILES\ATM\REDO04B.LOG' ) size 100M


Redos should be predicted to switch every 20 minutes.