Home » RDBMS Server » Server Administration » Preventing database shutdown by a trigger
Preventing database shutdown by a trigger [message #574747] Tue, 15 January 2013 10:34 Go to next message
one973
Messages: 10
Registered: January 2013
Junior Member
i mean can i write a trigger to prevent shutdown in certain time
create or replace trigger trig1
before shutdown on database
begin
if to_char(sysdate,'hh24') <16 then
'WHAT IS THE RIGHT THING TO DO HERE??'
.....

[Updated on: Tue, 15 January 2013 10:35]

Report message to a moderator

Re: Preventing database shutdown by a trigger [message #574749 is a reply to message #574747] Tue, 15 January 2013 10:38 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

>WHAT IS THE RIGHT THING TO DO HERE??'
Fire anyone who shuts down the DB during normal working hours.
Re: Preventing database shutdown by a trigger [message #574754 is a reply to message #574747] Tue, 15 January 2013 10:52 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You cannot prevent from a shutdown command (hopefully).
As BlackSwan said, the solution is in your organization not in Oracle.

Regards
Michel
Re: Preventing database shutdown by a trigger [message #574756 is a reply to message #574754] Tue, 15 January 2013 10:55 Go to previous message
one973
Messages: 10
Registered: January 2013
Junior Member
thank you Michel,
Previous Topic: "_corrupted_rollback_segments" and "_offline_rollback_segments"
Next Topic: Regarding ASM
Goto Forum:
  


Current Time: Fri Mar 29 01:01:16 CDT 2024