1024programmer Oracle Manually delete the database dropdatabase

Manually delete the database dropdatabase

Manually delete the database drop database
the
The simple process is as follows, above version 10g, the database must be in the mount state, in RESTRICTED mode
sys@STANDBY3(dtydb5)> shutdown    
The database has been closed.
The database has been unmounted.
The ORACLE instance has been shut down.
sys@STANDBY3(dtydb5)> startup mount;
The ORACLE instance has been started.
www.2cto.com
Total System Global Area 3140026368 bytes
Fixed Size                                                      
Variable Size 771753656 bytes
Database Buffers 2348810240 bytes
Redo Buffers                                                          
The database is loaded.
sys@STANDBY3(dtydb5)> drop database;
drop database
*
Error on line 1:
ORA-12719: operation requires database to be in RESTRICTED mode
the
sys@STANDBY3(dtydb5)> alter system enable restricted session;
the
The system has changed.
sys@STANDBY3(dtydb5)> drop database;
the
The database has been deleted.
the
illustrate:
1. Only 10g or more can have the drop database command
2. The DROP DATABASE command deletes these files from operating system.
* Datafiles www.2cto.com
* Online Redo Log Files
* Controlfiles
* SPFILE (if it exists)
the
The DROP DATABASE command does not delete the following files:
* init.ora (text version of the Oracle initialization file)
* password file
* entries in listener files
* entries in oratab file
3. Files will not be deleted automatically under win NT environment
the
the
Author hijk139

This article is from the internet and does not represent1024programmerPosition, please indicate the source when reprinting:https://www.1024programmer.com/manually-delete-the-database-dropdatabase/

author: admin

Previous article
Next article

Leave a Reply

Your email address will not be published. Required fields are marked *

Contact Us

Contact us

181-3619-1160

Online consultation: QQ交谈

E-mail: [email protected]

Working hours: Monday to Friday, 9:00-17:30, holidays off

Follow wechat
Scan wechat and follow us

Scan wechat and follow us

Follow Weibo
Back to top
首页
微信
电话
搜索