I have an oracle 8.1.6 database with archive log mode enabled and configured. I went into DBA studio and removed archive log mode and hit the apply button. DBA studio then attempts to bounce my database but has been on the same screen for about two hours, stuck at the "shutting down database" step. I don't want to end task because I will leave the database in an unknown state. And I don't have a dump file to restore from. How do I know if this operation is going to go through or not? What do I do if it just sits here?
The database doesn't appear to be doing anything... The RAID array isn't doing anything either... the image with the gears is still going though and I can move the box around... Task manager reports that the application is running but all the cpu cycles are dedicated to idle processes.
I know I didn't have auto archiving turned on and since DBA studio is still doing something I can't make any changes at all. What would happen if I end tasked on DBA studio and restarted the server. Could I get my data back?
Same thing happened to me while I am using DBA studio for shutdown immediate , but not alter database noarchlog ;
That time I loggged as internal into svrmgrl .. I issued shutdown abort .. I know I don't have any transactions pending .. In your case if any transactions pending , they won't rollback .. It should allow you to logon as internal saying connected idle instance or some message ...