[20200302]startup dba.txt

--//不记得那个时候看到人家这样执行启动数据库的操作，不知道后面的dba什么意思。
--//今天才知道实际上使用在rman，直接启动到restricted模式，测试看看。

1.测试1：
--//在sqlplus下：
SYS@book> startup dba
SP2-0714: invalid combination of STARTUP options

2.测试2：
RMAN> startup dba
Oracle instance started
database mounted
database opened
Total System Global Area     643084288 bytes
Fixed Size                     2255872 bytes
Variable Size                205521920 bytes
Database Buffers             427819008 bytes
Redo Buffers                   7487488 bytes

SYS@book> select status,instance_name,logins from v$instance;
STATUS       INSTANCE_NAME    LOGINS
------------ ---------------- ----------
OPEN         book             RESTRICTED
--//重启:

SYS@book> startup
ORACLE instance started.
Total System Global Area  643084288 bytes
Fixed Size                  2255872 bytes
Variable Size             205521920 bytes
Database Buffers          427819008 bytes
Redo Buffers                7487488 bytes
Database mounted.
Database opened.

SYS@book> select status,instance_name,logins from v$instance;
STATUS       INSTANCE_NAME    LOGINS
------------ ---------------- ----------
OPEN         book             ALLOWED

SYS@book> alter system enable restricted session;
System altered.

SYS@book> select status,instance_name,logins from v$instance;
STATUS       INSTANCE_NAME    LOGINS
------------ ---------------- ----------
OPEN         book             RESTRICTED

3.测试3：
--//在sqlplus下：
SYS@book> startup restrict
ORACLE instance started.
Total System Global Area  643084288 bytes
Fixed Size                  2255872 bytes
Variable Size             205521920 bytes
Database Buffers          427819008 bytes
Redo Buffers                7487488 bytes
Database mounted.
Database opened.
--//oracle的语法有时候很奇怪，这里不要写成startup restricted。否者报
SYS@book> startup restricted
SP2-0714: invalid combination of STARTUP options

SYS@book> select status,instance_name,logins from v$instance;
STATUS       INSTANCE_NAME    LOGINS
------------ ---------------- ----------
OPEN         book             RESTRICTED

SYS@book> alter system disable restricted session;
System altered.

SYS@book> select status,instance_name,logins from v$instance;
STATUS       INSTANCE_NAME    LOGINS
------------ ---------------- ----------
OPEN         book             ALLOWED

--//如果在rman下执行：

RMAN> startup restrict
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "identifier": expecting one of: "dba, force, mount, newline, nomount, pfile, ;"
RMAN-01008: the bad identifier was: restrict
RMAN-01007: at line 1 column 9 file: standard input
--//newline什么意思!!

RMAN> startup newline
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "identifier": expecting one of: "dba, force, mount, newline, nomount, pfile, ;"
RMAN-01008: the bad identifier was: newline
RMAN-01007: at line 1 column 9 file: standard input