Hi All ,
I want to re-size redo log group on my production database .
i have 10 redo log groups of 50mb each having 2 members.
i want 4 redo groups to be of 250 mb each having 2 members and then i will drop that old 10 redo log group(50 mb ) , so that i will have only 4 redo log group of 250MB each having 2 members.
But i have physical standby and logical standby configured on production database .
Please find attached file for redo log configuration of production database(CBSPROD),Logical standby database(CBSMIS), Physical standby database(CBSDR)