| Please help me to drop online redo log file! and Thank Crok and Frank [message #62263] |
Thu, 08 July 2004 05:22 |
Minh Tam
Messages: 5
Registered: July 2004
|
Junior Member |
|
|
Hi all,
Thank Crok and Frank , but I until can't drop the logfile !!! Please sent me some commands to drop the log file.
DROP LOGFILE in document is ALTER DATABASE DROP LOGFILE MENBER ... or not!
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 (group 1 have 2 member and INACTIVE. Database NOARCHIVE mode)
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'
In document explane :
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
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
