Re: DB not shutting while taking a cold backup through script

Re: DB not shutting while taking a cold backup through script

 

  

what i understand from your question is that you are using shutdown or
shutdown immediate command while you have users logged in and some work
is there in undo to be rolled back . check the sessions and running jobs
which are using undo segments or use shutdown abort (be careful you
won't be able to restore uncomitted work)

Try this

Shutdown abort
startup restrict
shutdown


take a cold backup
and then restart the database

use all three steps otherwise backup won't be consistent

RajeshKumar wrote:
> Hi DBA's
>
> DB is not shutting down while taking a cold backup & the same is working
> fine for others DB.
> Env: solaris
> O-ver:9i
>
>
> Thanks & Regards,
>
> Rajesh Kumar Mathur
>
> Techmahindra Ltd.
>
> Sharda Center, Erandwane.
>
> Pune (MH) - 04
>
> Ph: +91 20 - 56018100 Ext. 1475
>
>
> ============================================================================================================================
>
> Tech Mahindra, formerly Mahindra-British Telecom.
>
> Disclaimer:
>
> This message and the information contained herein is proprietary and confidential and subject to the Tech Mahindra policy statement, you may review at <a href="http://www.techmahindra.com/Disclaimer.html">http://www.techmahindra.com/Disclaimer.html</a> externally and <a href="http://tim.techmahindra.com/Disclaimer.html">http://tim.techmahindra.com/Disclaimer.html</a> internally within Tech Mahindra.
>
> ============================================================================================================================
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>


Oracle LazyDBA home page