Stopping the Oracle Database 12C

Stopping the Oracle Database 12C

Normally, you use the SHUTDOWN IMMEDIATE statement to stop a Oracle database 12C. The IMMEDIATE parameter instructs Oracle to halt database activity and roll back any open transactions, for example:

SQL> shutdown immediate;

Database closed.
Database dismounted.

ORACLE instance shut down.

Table 1 provides a detailed definition of the parameters available with the SHUTDOWN statement. In most cases, SHUTDOWN IMMEDIATE is an acceptable method of shutting down your Oracle database 12C. If you issue the SHUTDOWN command with no parameters, it’s equivalent to issuing SHUTDOWN NORMAL.

You should rarely need to use the SHUTDOWN ABORT statement. Usually, SHUTDOWN IMMEDIATE is sufficient. Having said that, there is nothing wrong with using SHUTDOWN ABORT. If SHUTDOWN IMMEDIATE isn’t working for any reason, then use SHUTDOWN ABORT.

Image Note  Stopping and restarting your database in quick succession is known colloquially as “bouncing the database.”

Starting and stopping your database is a fairly simple process. If the environment is set up correctly, you should be able to connect to your database as a privileged user, and issue the appropriate startup and shutdown statements.

STARTUP FORCE

Sometimes in development environments, I’ll quickly want to stop and start my Oracle database 12C. For example, I might want to do this because I’ve modified an initialization parameter that requires a database restart. You can stop/start your database with one command:

SQL> startup force;

If your instance is currently running, the STARTUP FORCE command will shut down the instance (abort mode) and restart it. This behavior may not be what you want in a production environment, but for test/development databases, this is usually fine.

Вас заинтересует / Intresting for you:

Oracle Database and Instance d...
Oracle Database and Instance d... 704 views Masha Thu, 21 Jun 2018, 18:23:39
Oracle Database 12C Backup: un...
Oracle Database 12C Backup: un... 323 views Андрей Волков Sat, 29 Feb 2020, 10:15:04
How to connect to Oracle Datab...
How to connect to Oracle Datab... 342 views Андрей Волков Sat, 29 Feb 2020, 10:19:58
Starting the Oracle Database 1...
Starting the Oracle Database 1... 262 views Андрей Волков Sat, 29 Feb 2020, 10:19:42