Re: Cold backup blues (UNIX)...

M.Rapier_at_shef.ac.uk (M.Rapier) wrote:

>We've got scripts that get put into the background to check whether the
>shutdown (normal) has worked - if not they kill off all current connections
>associated with user processes, wait a bit more & if it still hasn't worked,
>they do an abort.
>
>Cheers.
>Martin.
>

Why not try this. (I've read several other articles where people say they're doing it successfully.)

1. shutdown abort - kills all sessions immediately
2. startup - recovers database and rolls back uncommitted transactions
3. shutdown immediate - shuts down to permit cold backup.

--
Chuck Hamilton
chuckh_at_dvol.com

Never share a foxhole with anyone braver than yourself!