srvctl stop instance
With the article “srvctl stop instance,” we provide the command to stop an Oracle instance in an RAC through CRS, which is described in the following LINK.
It often happens that in the context of tuning activities, for example, adjusting the SGA (System Global Area), which is the portion of RAM used by the database, it’s necessary to shut down the instance to restart the database with the new parameter set in the pfile.
Therefore, to restart the database and have it start with the new parameter, it’s necessary to shut down the relevant instance with the srvctl command and then execute the start with the analogous command.
Even in the case of server restarts. Once the instance is closed and the Disk Groups are unmounted from the database, there is no risk of data corruption with the machine’s shutdown because the DGs are not mounted in the database.
So, in the event of server restarts, we can simply close the instances and give the OK for the machine to restart. Once it’s started, all that’s left is to check if all resources have returned to Up and Running status.
Below is a mini guide for stopping a resource:
Before executing the stop, check the status of resources with the command:
crsctl status res -tThe command to execute srvctl stop instance is:
srvctl stop instance -d <database> -i <istanza> -o <opzione>Example:
srvctl stop instance -d DBTESTp -i DBTESTp1 -o immediate
Once the prompt is returned, recheck the status of resources with the command:
crsctl status res -tTo view my guides on CRS Commands click here!
At this LINK, instead, you’ll find the SQL queries.
Stay updated on our activities by joining our community (make sure to like our pages, let’s connect, and stay updated on each of our new guides!):
Facebook
Youtube
Linkedin
For those who haven’t done so yet, we recommend saving this site among your bookmarks.
So you’ll always have our solutions to the most common database problems at your fingertips, especially Oracle databases.
- srvctl relocate service
- srvctl start service
- srvctl stop service
- srvctl stop listener
- srvctl stop instance
- srvctl start instance
- srvctl start database
- srvctl stop database
0 Comments