바람한잔의 일상생활

+ Startup & Shutdown
1. Login
- sqlplus "/as sysdba"
- sqlplus
  /as sysdba
- sqlplus /nolog
  conn /as sysdba

2. Startup
D:\>sqlplus "/as sysdba"
SQL*Plus: Release 10.2.0.1.0 - Production on Mon Dec 18 15:25:52 2006
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area  167772160 bytes
Fixed Size                  1247900 bytes
Variable Size              71304548 bytes
Database Buffers           92274688 bytes
Redo Buffers                2945024 bytes
Database mounted.
Database opened.
SQL> shutdown abort
ORACLE instance shut down.
SQL>
SQL> startup nomount
ORACLE instance started.
Total System Global Area  167772160 bytes
Fixed Size                  1247900 bytes
Variable Size              83887460 bytes
Database Buffers           79691776 bytes
Redo Buffers                2945024 bytes
SQL> select status from v$instance;
STATUS
------------------------
STARTED
SQL> alter database mount;
Database altered.
SQL> select status from v$instance;
STATUS
------------
MOUNTED
SQL> alter database open;
Database altered.
SQL> select status from v$instance;
STATUS
------------
OPEN