Adding redolog groups/members

[st2000]

I created a database and I don't know where I missed (DBassist) that it created 3 groups with 1 member in each..
How can I make that to atleast 2 members in each grp?

Do I have to create redolog 4a,4b to 6a,6b and then drop the redolog 1,2,3 or how?? Please be detailed..

Thanks, ST

[pando]

I am not gonmna be detailed because it is explain in detail in the DOCs on technet. All I can say is you dont need to drop, you can simply add a member to each group

Check administration guide: managing redo logs in the DOCs

[sambavan]

Try

ALTER DATABASE ADD LOGFILE MEMBER [ 'filename' [REUSE], 'filename' [REUSE]] ...
TO { GROUP integer,}
]

ALTER DATABASE ADD LOGFILE MEMBER
'/DISK4/log1b.redo' TO GROUP 1,
'/DISK4/log2b.redo' TO GROUP 2;


Sam

[pando]

IF I could remember all the commands by hard

[sambavan]

Then why the books are for

Sam