Database Software

Hi Folks,

Database version - 10.1.0.4.0
OS version - AIX 5.3
RAC node 2 and ASM

We had 4 redo log groups of lesser size on both nodes.yesterday I added 4 new groups of bigger size using pl/sql developer tool and deleted 2 old redolog groups. But I m not able to delete remaining 2 old groups.

ORA-01567 dropping log2 would have less than 2 log files for instance 1.

Our redolog files are on SAN and both node points to same storage. when I fired this query from command prompt

SELECT v$logfile.member, v$logfile.group#, v$log.status, v$log.bytes
FROM v$log, v$logfile
WHERE v$log.group# = v$logfile.group#;

I got same result for both nodes.

The problem I suspect is that All the 4 new log groups are added to instance 2 and its 2 old grouips are are also deleted.


Now my ques is that :

1. shouild I have added redo log groups separately on both nodes even storage is same for both nodes ?
2. redologs groups are defined separately for each node ?

How should I assign 2 new redo log groups to instance 1 ?

Regards,