TranslateProject/published/201412/20141204 How To Drop Database In Oracle 11 Without Using DBCA.md

75 lines
2.0 KiB
Markdown
Raw Permalink Normal View History

2014-12-05 23:39:50 +08:00
如何不使用DBCA在Oracle 11中删除数据库
2014-12-04 18:46:36 +08:00
================================================================================
本文简短的教程将会向你展示如何不使用DBCA数据库配置助手在Oracle 11中删除数据库。
2014-12-04 18:46:36 +08:00
2014-12-05 23:39:50 +08:00
#### 1- 导入数据库的SID如果没有定义的话 ####
2014-12-04 18:46:36 +08:00
export ORACLE_SID=database
2014-12-05 23:39:50 +08:00
#### 2- 以操作系统认证连接数据库 ####
2014-12-04 18:46:36 +08:00
[oracle@Oracle11 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Mon Dec 1 17:38:02 2014
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to an idle instance.
2014-12-05 23:39:50 +08:00
#### 3- 启动数据库实例 ####
2014-12-04 18:46:36 +08:00
SQL> startup
2014-12-04 18:46:36 +08:00
ORACLE instance started.
Total System Global Area 3340451840 bytes
Fixed Size 2217952 bytes
Variable Size 1828718624 bytes
Database Buffers 1493172224 bytes
Redo Buffers 16343040 bytes
Database mounted.
Database opened.
2014-12-05 23:39:50 +08:00
#### 4- 关闭数据库 ####
2014-12-04 18:46:36 +08:00
SQL> shutdown immediate;
2014-12-04 18:46:36 +08:00
Database closed.
Database dismounted.
ORACLE instance shut down.
2014-12-05 23:39:50 +08:00
#### 5- 启动独占模式 ####
2014-12-04 18:46:36 +08:00
SQL> startup mount exclusive restrict
2014-12-04 18:46:36 +08:00
ORACLE instance started.
Total System Global Area 3340451840 bytes
Fixed Size 2217952 bytes
Variable Size 1828718624 bytes
Database Buffers 1493172224 bytes
Redo Buffers 16343040 bytes
Database mounted.
2014-12-05 23:39:50 +08:00
#### 6- 删除数据库 ####
2014-12-04 18:46:36 +08:00
SQL> drop database;
Database dropped.
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
2014-12-05 23:39:50 +08:00
完成!
2014-12-04 18:46:36 +08:00
--------------------------------------------------------------------------------
via: http://www.unixmen.com/drop-database-oracle-11-without-using-dcba/
作者:[M.el Khamlichi][a]
2014-12-05 23:39:50 +08:00
译者:[VicYu/Vic020](http://vicyu.net/)
校对:[wxy](https://github.com/wxy)
2014-12-04 18:46:36 +08:00
本文由 [LCTT](https://github.com/LCTT/TranslateProject) 原创翻译,[Linux中国](http://linux.cn/) 荣誉推出
2014-12-04 20:33:22 +08:00
[a]:http://www.unixmen.com/author/pirat9/