Problem In Normal Shutdown
hi,
One process was running in Oracle, that process has been killed.Since it will take 3 to 4 hrs to rollback the whole data.
I have shutdown the database with shutdown abort.
Then I brought it up.Then I again given the same process, but found that physical reads is not increasing.So shutdown abort given again.
And now when i am going for Normal or Immediate Shutdown, it is not taking place.Once Normal shutdown given , but it has not done after running for 8 hrs.
There is nothing abnormal in the log file.In this case what shall i do???
Re: Problem In Normal Shutdown
Quote:
Originally posted by dhiman_s
hi,
And now when i am going for Normal or Immediate Shutdown, it is not taking place.Once Normal shutdown given , but it has not done after running for 8 hrs.
Do u mean now no processes are running (except backgroung)...and SHUTDOWN Normal or Immediate is not working?
Or if that process(which u expect it wud take 3 to 4 hrs for rollback) is running and u give SHUTDOWN Normal..it took 8hrs time in vain doing nothing?