Database Startup

What do they do?

NOMOUNT	background processes are started. No files are open
MOUNT	control files are opened
MOUNT	data files are opened

Startup

STARTUP [FORCE][RESTRICT][NOMOUNT][MIGRATE][QUIET]
[PFILE=]
[MOUNT [EXCLUSIVE] x |
OPEN
]

SQL> STARTUP

Startup Force

SQL> STARTUP FORCE

Startup Nomount

SQL> STARTUP NOMOUNT

Startup Mount

SQL> STARTUP MOUNT

Startup Mount Exclusive

Deprecated .. now use STARTUP MOUNT

Startup Open

SQL> STARTUP OPEN

Startup Migrate

SQL> STARTUP MIGRATE

Startup Restricted

SQL> STARTUP RESTRICT

Startup

STARTUP [PFILE=]{UPGRADE | DOWNGRADE} [QUIET]

SQL> STARTUP UPGRADE

Alter Database

Alter Database Mount

SQL> ALTER DATABASE MOUNT

Alter Database Open

SQL> ALTER DATABASE OPEN

Database Shutdown

Shutdown

SHUTDOWN

SQL> SHUTDOWN

Shutdown Normal

SQL> SHUTDOWN NORMAL

Shutdown Transactional

SQL> SHUTDOWN TRANSACTIONAL

Shutdown Immediate

SQL> SHUTDOWN IMMEDIATE

Shutdown Abort

SQL> SHUTDOWN ABORT

Oracle Supplied Startup & Shutdown Scripts

Startup

dbstart

Shutdown

dbshut

System Hangs On Shutdown

Solution #1

SQL> alter system checkpoint;
SQL> shutdown abort
SQL> startup restrict
SQL> shutdown immediate

Oracle Services On Windows

Startup

net start OracleService

c:winntsystem32 net start oracleserviceorabase

Shutdown

net stop OracleService

c:winntsystem32 net stop oracleserviceorabase

Help

net

c:winntsystem32 net help helpmsg

c:winntsystem32net1063

Oracle Services On Windows With Oradim

Start Oracle Service

oradim -STARTUP
[-SID | -ASMSID [-SYSPWD ]
[STARTTYPE [-PFILE | -SPFILE]

$ORACLE_HOMEbinoradim -STARTUP -SID orabase -STARTTYPE tstc -SPFILE

Stop Oracle Service

oradim -SHUTDOWN
[-SID | -ASMSID [-SYSPWD ]
[-SHUTTYPE [-SHUTMODE

$ORACLE_HOMEbinoradim -SHUTDOWN -SID orabase -SHUTMODE abort

Stopping Processes

When stop doesn't stop

alter database close may fail for many reasons. Among them job queue processes, dbms_job, and advanced queueing.

SQL> ALTER DATABASE CLOSE;
alter database close
*
ERROR at line 1:
ORA-01093: ALTER DATABASE CLOSE only permitted with no sessions connected

col username format a20
col schemaname format a20
col osuser format a20
SELECT username, schemaname, osuser, status
FROM gv$session;

ALTER SYSTEM SET job_queue_processes = 0 SCOPE=MEMORY;

ALTER SYSTEM SET aq_tm_processes=0 SCOPE=MEMORY;

ALTER DATABASE CLOSE;

Force log files to be archived in preparation for media recovery

startup mount exclusive;
alter database orabase archivelog;
alter system archive log start;
alter database open;

When testing startup scripts be sure you are mimicking the environment under which the script will actually run

For example:

sh -x /etc/init.d/oracle start

[@more@]

ITPub博客

Oracle Startup & Shutdown参数大全

最新文章