Topic : Startup and Shutdown

What are the steps involved in Database Startup ?


Answer :

Start an instance; Mount the Database and Open the Database.

Show Answer Discuss

What are the steps involved in Database Shutdown?


Answer :

Close the Database; Dismount the Database and Shutdown the Instance.

Show Answer Discuss

What is Restricted Mode of Instance Startup ?


Answer :

An instance can be started in (or later altered to be in) restricted mode so that when the database is open connections are limited only to those whose user accounts have been granted the RESTRICTED SESSION system privilege.

Show Answer Discuss

You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?


Answer :

I would create a text based backup control file; stipulating where on disk all the data files where and then issue the recover command with the using backup control file clause.

Show Answer Discuss

Where would you look for errors from the database engine?


Answer :

In the alert log.

Show Answer Discuss