Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

can't open database ,because lost a redofile group

351097Oct 10 2002
I can't open database ,because lost a redofile group.
Because disk error ,i lost redofile group 2 ,it's a current redofile group;so i can't drop it ,
"alter database switch logfile" must need database open.


Who can help me.

"alter database open resetlogs" Error message : ora-01139
I can't open database ,how to recovery database?


"alter database clear logfile '<filespec>';" Error message : ora-01624 ora-00312


I think that redofile group info are saved in my controlfile ,so when i open database ,it must search redofile.this is reason for can't open database.

I can't drop redofile group ,because it was current thread's redofile group.

How to switch that redofile group to incurrent,help me .

thank you!

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Nov 7 2002
Added on Oct 10 2002
#general-database-discussions
0 comments
188 views