Bank locking in shutdown !!!

[leandro_ferreira]

Personally, when I tried to descend the bank by a shutdown immediate.

He got stuck.

But I killed the processes at UNIX that was as a place = in

or the following command ps -ef|grep LOCAL
99] And I killed the connection processes with the Bank.

My doubt is, when I kill this manually as it reacts this internally is the rollback of transactions? Is it good to do this or not?

And Shutdown Abort does it come to do the roll back etc?


Thanks.

[gilbertoca]

This situation is considered instance failure : http://download.oracle.com/docs/cd/B193 ... m#i1015225

that is, when one of the following causes occur:

• lack of energy;
  Hardware failure;
  Failure of one of the background processes;
  Emergency shutdown procedures.
  [/ list]
  No command is required for instance recovery, the entire process is fired automatically by Oracle. What you need to do is find out what causes that led to failure.

[KeenOnOracle]

Expensive,

when you say that the bank "locked," depending on the size of it this is absolutely normal because it is with the processes background all assets, the dbwn is recording the changes in the datafiles, if Existing Archive he will be archivando the shirts and depending on their size it takes, and it is clear, as you mentioned it is doing rollback from operations .... this in the immediate shutdown.

In Shutdown Abort, he does not do this, he will simply disable instance, and will make instance recapend as soon as it is put in the air ....

99] I hope I have helped

Cheers

[LoadingXp]

What kind of shutdown are you giving in the database ??

In Oracle There are 4 ways to make the shutdown, being them:


Mode Shutdown Abort Immediate Normal Transactional
Allows new connections no no no no
awaits the end of the sessions no no no yes
waits the end of the trans no yes yes
Impoe a ckpt and closes osfiles yes yes yes \r\n

Abort mode is the worst mode, and as if you were there and pull the computer's power cord, and bin Laden mode: Twisted:
rs ... It is not recommended ...
All transactions will be undone only when you boot the database. But this can screw your bank. Caution ein ... rs ..
: Idea: Uses immediate is the best type of shutdown.

Embrace my friend ....