Home » RDBMS Server » Server Utilities » redolog files lost
redolog files lost [message #69436] Sat, 05 January 2002 19:16 Go to next message
TEAR
Messages: 2
Registered: January 2002
Junior Member
hi,
i am stuck.
my database goes till mount stage & does not open.
gives the above error!!
actually , i added three members & one log group.something happened & i decided to delete them.i deleted them from win NT explorer manually,all of them .the mistake i did that i didn't do any log switch before deleting them.
now what i did...............................
i was able to delete the group from oracle that i had created.now came the turn of my redog members.it will delete all other members except the one which is current.it doesn't accept my switch logfile command for the current member as the database is not open.
i don't want to create a new database unless it becomes very necessary as i want to learn from this senario.

please help me !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
thanks#
Re: redolog files lost [message #69476 is a reply to message #69436] Tue, 15 January 2002 08:29 Go to previous message
unique kumar
Messages: 4
Registered: January 2002
Junior Member
give the commnad
alter database clear logfile
(path of logfile in single quotos)
Previous Topic: Importing database table schema without data
Next Topic: Export util
Goto Forum:
  


Current Time: Sat Mar 02 14:29:14 CST 2024