1In what situation you need to use Startup command to start

1.In what situation you need to use \'Startup\' command to start up a Oracle Instance?

2. In what situation you need to use \'Startup NOMOUNT\' to start Oracle Instance?

3. In what situation you need to use \'Startup MOUNT\' to start Oracle Instance?

4. In what situation you need to use \'Open Database\'\' to change the database to be ready to serve?

5. What\'s the differences between SHUTDOWN IMMEDIATE, SHUTDOWN ABORT, SHOTDOWN?

Solution

2) when we are creating a database we use database nomount

1) startup command is used when we need to mount and open database and while starting we make oracle read initialization parameters from a server parameter file.

3) startup mount is used only when you only want to mount it but not open it during which we can only do some maintenance and recovery operation.

4) open database is used after startup mount command to enable the database open for sql transactions.

5) shutdown is used to to shut down recovery catalog DB.

Shutdown abort stops all running process and tasks and shuts down the oracle DB

Shutdown immediate ,running processes are completed and then shutsdown ,so,it rolls back all uncommitted transactions. which is not available in abort