manually drop and delete an Oracle database

最新推荐文章于 2025-11-26 14:12:29 发布

最新推荐文章于 2025-11-26 14:12:29 发布 · 134 阅读

文章标签：

#数据库

Oracle 专栏收录该内容

8 篇文章

订阅专栏

本文提供了手动删除Oracle数据库的详细步骤。首先设置数据库SID并使用sysdba身份登录SQL*Plus，确认要删除的数据库名称正确无误。接着关闭数据库、进行备份（可选），再以未开启状态启动数据库，最后执行删除数据库命令。

Using DBCA command line to delete a database is quite simple:
dbca -silent -deleteDatabase -sourceDB dbSID2delete

The following describes MANUALLY delete a database:

Refrence:

Search "Oracle DBA Justin - How to drop/delete an Oracle database" on YouTube.
http://www.youtube.com/watch?v=NkI2Sbpjaf4

1. set the database SID
export ORACLE_SID=mydb

2. sqlplus / as sysdba

3. make sure it's the correct database to delete
SQL>select name from v$database;
name
---------
mydb

4. shutdown the database
SQL>shutdown immediate;

5. YOU MAY WANT TO BACKUP THE DATABASE NOW

6. start the database not opened
SQL>startup mount restrict;

only control files loaded and restrict other users to sqlplus(logon) the database

7. drop the database now
SQL>drop database;

8. database control files, log files, data files and SPFILES etc would be deleted.

Warning: this is only the steps to drop/delete an Oracle database from the video, it's not yet tested.