Ü PHYSICAL FILE STRUCTURE IN DATABASE
q DATABASE FILES
q CONTROL FILE
v $ORACLE_BASE/oradata/dbname
v DATABASE NAME
v TIMESTAMP OF DATABASE CREATION
v NAME AND LOCATION OF DATAFILES AND REDO LOG
FILES
q DATA FILES
v ACTUAL USER'S DATA IS STORED IN THE DATFILE
q REDOLOG FILE
v LOG OF THE CHANGES
q NON-DATABASE FILES
q PARAMETER FILE (initPROD.ora)
v $ORACLE_HOME/dbs
v FIRST FILE NEED TO START THE DATABASE
v DATABASE NAME
v ALLOCATE MEMORY
v NAME AND LOCATION OF CONTROL FILES
q NETWORK FILE
v HOW APPLICATION USER CONNECT TO THE DATABASE
v TCP IP - EVEN THOUGH TCP IP IS THERE ALTHOUGH
THEY CAN'T CONNECT
v DEDICATED NETWORK FOR ORACLE
v LISTENER [CONFIGURE ON THE SERVER SIDE]
v $ORACLE_HOME/network/admin
v listener.ora
v LISTEN TO THE CLIENT REQUEST
v IF THE USER TRYING TO CONNECT IT WILL GO FIRST
TO THE LISTENER, THEN THE LISTENER WILL REDIRECT TO THE DATABASE MEANS THE
INSTANCE
v WITHOUT A LISTENER APPLICATION USER CAN'T CONNECT TO THE DATABASE
v TNSNAME [CONFIGURE ON THE CLIENT SIDE]
q PASSWORD FILE
v $ORACLE_HOME/dbs/orapwprod
v USER IS AUTHENTICATED INFORMATION STORED HER
q ALERT LOGFILE
v $ORACLE_BASE/diag/rdbms/prod/alert/Alertprod.ora
v DIAGNOSTIC_DEST
v DIAGNOSTIC PURPOSE
v COMPLETE DATABASE EVENT STORE HERE
q TRACE FILES
v EACH BACKGROUND PROCESS WILL HAVE OWN TRACE FILE
q ARCHIVELOG FILES
v RECOVERY PURPOSE
Ü STARTUP THE DATABASE
q STARTUP NO MOUNT
v IT READS THE PARAMETER FILE
v MEMORY AREA ALLOCATED & BACKGROUND
PROCESSES ARE STARTED
v INSTANCE IS STARTED
WHY - TO RESTORE CONTROL FILE | TO CREATE CONTROL FILE | TO CREATE DATABASE
q STARTUP MOUNT
v IT READS THE PARAMETER FILE
v MEMORY AREA ALLOCATED & BACKGROUND
PROCESSES ARE STARTED
v INSTANCE IS STARTED
v IT READS THE CONTROL FILE
WHY - TO RESTORE AND RECOVER THE DATABASE | TO ENABLE OR DISABLE ARCHIVE LOG MODE
q STARTUP
v IT READS THE PARAMETER FILE
v MEMORY AREA ALLOCATED & BACKGROUND
PROCESSES ARE STARTED
v INSTANCE IS STARTED
v IT READS THE CONTROL FILE
v IT PHYSICALLY CHECKS DATAFILES AND REDO LOG
FILE
v IT CHECKS THE CHECKPOINT NUMBER IN THE
DATAFILE HEADER AND CONTROL FILE
v IF MATCHING THEN THE DATABASE WILL OPEN
WHY - IN NORMAL OPERATION
Ü SHUTDOWN THE DATABASE
q SHUTDOWN
q SHUTDOWN TRANSACTIONAL
q SHUTDOWN IMMEDIATE
q SHUTDOWN ABORT