Which option represents the actions performed, in the correct order, if you start up the instance?

Your database instance is down because there was a user-initiated shutdown. Which option
represents the actions performed, in the correct order, if you start up the instance?
a – The control file is read.
b – Memory is allocated.
c – Background processes pre started.
d -The initialization parameter file is read,
e- Redo log files and data files are opened.

Your database instance is down because there was a user-initiated shutdown. Which option
represents the actions performed, in the correct order, if you start up the instance?
a – The control file is read.
b – Memory is allocated.
c – Background processes pre started.
d -The initialization parameter file is read,
e- Redo log files and data files are opened.

A.
b, c, a

B.
d, a, e

C.
a, e, d, b

D.
d, b, c, a, e

E.
c, b, d, a, e



Leave a Reply 5

Your email address will not be published. Required fields are marked *


babug

babug

http://docs.oracle.com/cd/E11882_01/server.112/e40540/startup.htm#CNCPT955

How an Instance Is Started

When Oracle Database starts an instance, it performs the following basic steps:

Searches for a server parameter file in a platform-specific default location and, if not found, for a text initialization parameter file (specifying STARTUP with the SPFILE or PFILE parameters overrides the default behavior)

Reads the parameter file to determine the values of initialization parameters

Allocates the SGA based on the initialization parameter settings

Starts the Oracle background processes

Opens the alert log and trace files and writes all explicit parameter settings to the alert log in valid parameter syntax

Answer: D

Asraful Azim Al Khalil

Asraful Azim Al Khalil

D

Giovani Hernandez

Giovani Hernandez

answer D

http://docs.oracle.com/cd/E11882_01/server.112/e40540/startup.htm#CNCPT602
1. Searches for a server parameter file in a platform-specific default location and, if not found, for a text initialization parameter file (specifying STARTUP with the SPFILE or PFILE parameters overrides the default behavior)
2. Reads the parameter file to determine the values of initialization parameters
3. Allocates the SGA based on the initialization parameter settings
4. Starts the Oracle background processes
5. Opens the alert log and trace files and writes all explicit parameter settings to the alert log in valid parameter syntax