Re: shutdown abort

Anurag <anurag_at_synergy-infotech.com> wrote:

]Hi,
]I have scheduled a cold backup every day and i do a shutdown abort
]first and then bring up the database in restricted mode and then do a
]shutdown normal nad then the cold backup takes place.
]Will there be any problem if a shutdown abort takes place every day,
]will it corrupt the database.
]
]-sometimes shutdown immediated takes a lot of time it even hangs , why
]is it so

Shutdown immediate still waits for connections to close, cleans up any in-progress transactions etc. It may never shut down the database.

I use the exact process you describe on 2 databases now, and used to it on about 8 databases every night for 4 years.

I had a problem with one database once that did not come back up due to some file corruption, but I think that was not related to the shutdown abort, but some other problem. I forget what it was now, it was a long time ago.

I still use the process you describe on databases that do not have the enterprise manager stuff; where I still use scripts to do the backups. I also so the shutdown abort; startup restrict; shutdown in my machine shutdown scripts.
--
 ,-,_|\ George Dau - Unix (Solaris, DEC Unix, Linux), Oracle, Internet. __

/    * \ Home: gedau_at_pobox.com         !  Any views or opinions expressed (OO)
\_,--\_/ Work: gedau_at_isa.mim.com.au    !  above may be mine, but are NOT ( \/ )
      v   WWW: http://pobox.com/~gedau !  necessarily those of M.I.M.     W--W