Oracle database Startup and shutdown

Database Shutdown and Startup: SCN = = System change Number

Database Startup steps

Nomount----> Mount---->open

(1) The first stage

Sql> Startup Nomount

ORACLE instance started.

Total System Global area 7148580864 bytes

Fixed Size 2214216 bytes

Variable Size 3825206968 bytes

Database buffers 3288334336 bytes

Redo buffers 32825344 bytes

Sql>

Sql> select status from V$instance;

STATUS

------------

STARTED

Sql> Show parameter SPFile;

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

SPFile string +data/orcl/spfileorcl.ora

Nomount This step, what did the database do?

Read parameter file + Start DB instance

(2) Phase II

Sql> ALTER DATABASE Mount;

Database altered.

Sql>

Sql> Show Parameter control

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

Control_file_record_keep_time integer 7

Control_files string +data/orcl/controlfile/current

.260.943301383, +fra/orcl/cont

rolfile/current.256.943301385

Control_management_pack_access string diagnostic+tuning

Sql> select status from V$instance;

STATUS

------------

Mounted

Sql> select name from V$datafile;

NAME

--------------------------------------------------------------------------------

+data/orcl/datafile/system.256.943301251

+data/orcl/datafile/sysaux.257.943301251

+data/orcl/datafile/undotbs1.258.943301251

+data/orcl/datafile/users.259.943301251

+data/orcl/datafile/example.265.943301433

Sql> Select member from V$logfile;

MEMBER

--------------------------------------------------------------------------------

+data/orcl/onlinelog/group_3.263.943301403

+fra/orcl/onlinelog/group_3.259.943301407

+data/orcl/onlinelog/group_2.262.943301397

+fra/orcl/onlinelog/group_2.258.943301401

+data/orcl/onlinelog/group_1.261.943301389

+fra/orcl/onlinelog/group_1.257.943301395

Select name from V$tablespace;

Select name from V$database;

Sql> select name from V$database;

NAME

---------

ORCL

Sql> Show Parameter name

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

Db_file_name_convert String

Db_name string ORCL

Db_unique_name string ORCL

Global_names boolean FALSE

instance_name string ORCL

Lock_name_space String

Log_file_name_convert String

Service_names string ORCL

Sql>

Mount this step, what did the database do?

Read control file, verify control file consistency and db_name consistency

(3) Phase III

sql> ALTER DATABASE open;

Database altered.

Sql> select Open_mode from V$database;

Open_mode

--------------------

READ WRITE

Sql> select status from V$instance;

STATUS

------------

OPEN

Open this step, what did the database do?

Verify that data files and online redo logs exist and control the consistency of files and data files

Sql> Startup

ORACLE instance started.

Total System Global area 7148580864 bytes

Fixed Size 2214216 bytes

Variable Size 3825206968 bytes

Database buffers 3288334336 bytes

Redo buffers 32825344 bytes

Database mounted.

Database opened.

###############

Use the SRVCTL tool in the Oracle restart component to start the database

Srvctl Start database-d Orcl-o Mount

Srvctl start database-d Orcl-o start

Srvctl Start database-d Orcl-o Open

Do not add-o default is open

Srvctl start database-d ORCL is equivalent to

Srvctl Start database-d Orcl-o Open

[Email protected] ~]$ crs_stat-t

Name Type Target State Host

------------------------------------------------------------

Ora. DATA.DG ora....up.type Online Online Oel

Ora. FRA.DG ora....up.type Online Online Oel

Ora .... Er.lsnr ora....er.type Online Online Oel

Ora.asm ora.asm.type Online Online Oel

ORA.CSSD ora.cssd.type Online Online Oel

Ora.diskmon ora....on.type Online Online Oel

Ora.orcl.db ora....se.type Online Online Oel

#############

Database shutdown:

Other:

To view Oracle memory segments:

ipcs-m | grep ora

[Email protected] ~]# Ipcs-m | grep ora

0xfa55c7d8 163841 Oracle 660 4096 0

0x00000000 1736706 Oracle 660 4096 0

0x00000000 1769475 Oracle 660 4096 0

0XD3AC6C80 1802244 Oracle 660 4096 0

Ps-ef | grep ora

This article from "Liang Blog" blog, reproduced please contact the author!

Oracle database Startup and shutdown