-----------------关闭、启动数据库
root@his1 rman]# su - oracle ------切换至oracle模式
his1:/home/oracle>sqlplus / as sysdba -------以sysdba身份连接数据库
或者
his2:/home/oracle>sqlplus /nolog
SQL>connect /as sysdba -------以sysdba身份连接数据库
SQL> select status from v$instance; -------查看数据库状态
STATUS
------------
OPEN -----开启的
SQL> shutdown immediate; -----------关闭数据库
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup; -------------启动数据库
ORACLE instance started.
Total System Global Area 5027385344 bytes
Fixed Size 2261888 bytes
Variable Size 1795165312 bytes
Database Buffers 3221225472 bytes
Redo Buffers 8732672 bytes
Database mounted.
Database opened.
SQL> exit ----------------退出SQL