SQL> shutdown immediate
ORA
已經卸載數據庫
ORACLE 例程已經關閉
SQL> startup
ORACLE 例程已經啟動
Total System Global Area
Fixed Size
Variable Size
Database Buffers
Redo Buffers
數據庫裝載完畢
ORA
ORA
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS
FIRST_CHANGE# FIRST_TIME
SQL> select status from v$instance;
STATUS
MOUNTED
SQL> alter database drop logfile group
alter database drop logfile group
*
第
ORA
ORA
SQL> shutdown immediate
ORA
已經卸載數據庫
ORACLE 例程已經關閉
SQL> startup
ORACLE 例程已經啟動
Total System Global Area
Fixed Size
Variable Size
Database Buffers
Redo Buffers
數據庫裝載完畢
ORA
ORA
SQL> alter database clear logfile group
數據庫已更改
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS
FIRST_CHANGE# FIRST_TIME
SQL> alter database clear logfile group
數據庫已更改
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS
FIRST_CHANGE# FIRST_TIME
SQL> alter database open;
alter database open
*
第
ORA
ORA
SQL> shutdown immediate
ORA
已經卸載數據庫
ORACLE 例程已經關閉
SQL> startup
ORACLE 例程已經啟動
Total System Global Area
Fixed Size
Variable Size
Database Buffers
Redo Buffers
數據庫裝載完畢
ORA
ORA
SQL> alter database clear logfile group
數據庫已更改
SQL> alter database open;
數據庫已更改
SQL> conn scott/tiger
已連接
SQL> select * from emp;
EMPNO ENAME JOB MGR HIREDATE SAL COMM
DEPTNO
EMPNO ENAME JOB MGR HIREDATE SAL COMM
DEPTNO
EMPNO ENAME JOB MGR HIREDATE SAL COMM
DEPTNO
EMPNO ENAME JOB MGR HIREDATE SAL COMM
DEPTNO
EMPNO ENAME JOB MGR HIREDATE SAL COMM
DEPTNO
已選擇
SQL>
From:http://tw.wingwit.com/Article/program/Oracle/201311/17730.html