Database Reference
In-Depth Information
NOMOUNT
Starts the instance but does not mount the database. This option is used during
database creation and to re-create the control files.
OPEN
Starts the instance, mounts the database, and opens it for general access. This is the
default.
OPEN RECOVER
Starts the instance and begins complete media recovery.
RESTRICT
Starts the instance but prevents general access and allows access only for users
with RESTRICTED SESSION privileges.
Starting Up a CDB Instance: Examples
As mentioned previously, to start up a CDB you'll need to connect to the idle instance and
issue the
STARTUP
command. In this example, you'll use
STARTUP RESTRICT
and then open
the database for general access:
C:\>set ORACLE_SID=CONT
C:\>sqlplus / as sysdba
SQL*Plus: Release 12.1.0.1.0 Production on Fri Nov 29 14:28:34 2013
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to an idle instance.
SQL> STARTUP RESTRICT
ORACLE instance started.
Total System Global Area 2471931904 bytes
Fixed Size 2405664 bytes
Variable Size 671091424 bytes
Database Buffers 1778384896 bytes
Redo Buffers 20049920 bytes
Database mounted.
Database opened.
SQL>
SQL> select name, open_mode from v$pdbs;
NAME OPEN_MODE
------------------------------ ----------
PDB$SEED READ ONLY
PDB1 MOUNTED
PDB2 MOUNTED
Search WWH ::
Custom Search