Whats is the Recommended Method to Bounce EBS Database
Hi,
We have inhouse shell script to shutdown and startup the database during maintenance windwo every week
The shell script is calling addbctl.sh to shutdown the database in abort and startup and then shutdown immediate as follows:
addbctl.sh stop abort
addbctl.sh start
addbctl.sh stop immediate
My question is, Is shutdown abort recommended approach. I believe, we should never do shutdown abort in any case , especially PROD environment although SMON takes care of instance recovery.
Please suggest the recommended method and approach on this and also share if any scripts available
Thanks in advance