| Dopping Online Redo Log Files [message #62193] |
Sun, 04 July 2004 23:06  |
Minh Tam
Messages: 5
Registered: July 2004
|
Junior Member |
|
|
Hi all,
I am beginner with Oracle, i have some problems when i try to dop online redo log file member.I Made database with 4 log groups, then i drop log member of group 1 with command
Alter database drop logfile member
'd:oracleoradatadb1redo01b.log';
I received some Error
ERROR at line 1:
ORA-00362: member is required to form a valid logfile in group 1
ORA-01517: log member: 'd:oracleoradatadb1redo01b.log'
I checked some restrictions when drop log members in document but i can't find way to solve the prolem.
Please help me.
Best Regards
|
|
|
|
| Re: Dopping Online Redo Log Files [message #62204 is a reply to message #62193] |
Mon, 05 July 2004 07:41  |
croK
Messages: 170
Registered: April 2002
|
Senior Member |
|
|
because groups can have ONE or more members, you can't drop a file member if it is the only member belonging to that group.
But you can drop the group, if you have at least two other groups.
Best regards.
www.otools.com.ar
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
