| Please help me to drop online redo log file! [message #62208] |
Mon, 05 July 2004 18:31  |
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 group, then i drop log member of group 1 with command (group 1 have 2 members and inactive). Database in NOARCHIVELOG mode
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: Please help me to drop online redo log file! [message #62232 is a reply to message #62208] |
Tue, 06 July 2004 06:37  |
Frank Naude
Messages: 4587
Registered: April 1998
|
Senior Member |
|
|
Hi,
00362, 00000, "member is required to form a valid logfile in group %s"
// *Cause: A request to drop a logfile member was denied because it would
// remove data required to form a complete logfile.
// *Action: If desired, delete the entire log (after archiving if required),
// by using DROP LOGFILE;
Best regards.
Frank
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
