Oracle database on the start and stop

Apr 8 posted in Oracle Database (RSS), 85 views.

Oracle database on the start and stop

Shutdown
normal: waiting for all users disconnected, the closure of the database, uninstall the instance of the database and shut down.
immediate: all users rollback services, the closure of the database, uninstall the instance of the database and shut down.
(Note that the rollback).
transactional: When all the end user services, the closure of the database, uninstall the instance of the database and shut down
abort: an immediate end to examples. The end user pay services, the next time you start the restoration of data.

In fact I am not saying that there are problems starting or write error, but that more detailed and more for all of us to help more.
-------------------------------------------------- --------------------------
statup
Start startup nomount example, if in this state needs to open the database to operate:
Alter database mount
Alter database open
install non-nomount start, so the operation is read init.ora file to start the instance, that the SGA and background processes to start, into memory, process. This only needs to start reading init.ora file. This start mode executable: the reconstruction of the control file and rebuild the database, as also did not read the control file.
-------------------------------------------------- -----
start instance startup mount>; loaded database, if the state needs to operate to open the database:
Alter database open
mount is installed to start, so the operation is: Open the control files, data files and on-line to confirm the log file location, but this time not data files and log files for consistency, correctness checking and so on. This start of the executable:
Database log archiving,
Database media recovery,
So that online or offline data files,
Re-positioning data files, redo log files.
-------------------------------------------------- ----
statup open / startup start instance>; loading database>; open the database in this way also includes the implementation of the open files Redo log of all database files and check for consistency and so on, for crash recovery, in this way can access the database in data.
-------------------------------------------------- ---
forced to restart the database statup force
-------------------------------------------------- ----------------------------
Use non-default parameter files starting
STARTUP PFILE = parameter files Note: remote start data, the system parameters to find the local computer files.
-------------------------------------------------- --
To limit the open data
STARTUP RESTRICT
ALTER SYSTEM [ENABLE | DISABLE] RESTRICTED SESSION
RESTRICTED SESSION Only users can log on.
-------------------------------------------------- ---
Open read-only data
ALTER DATABASE OPEN READ ONLY