Database Administration (MOSC)

MOSC Banner

Is it possible to "take back" a shutdown statement? Would a before database trigger do any good?

edited Mar 20, 2017 12:59PM in Database Administration (MOSC) 8 commentsAnswered

You have both development and production SSH sessions open, Oracle 11gR2 single instance on Linux. You execute a SHUTDOWN immediate that was intended for development, but you've just introduced an unscheduled production outage. What would you do to sanity-check a shutdown on certain hosts during certain hours?

One possible workaround I've thought of is to change the practice of command-line, interactive shutdowns. Running an OS shell script, or even SQLPlus, will readily set a trap for the SHUTDOWN, and require some form of pre-confirmation during normal business hours.

Once the command leaves the client, however, do you have any technique to ask, are you sure?  Thanks in advance, all.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center