Manually delete database drop database

Source: Internet
Author: User


The simple process of manually deleting a database to drop the database is as follows: if the database version is 10 Gb or later, it must be in the mount state. In RESTRICTED mode, sys @ STANDBY3 (dtydb5)> shutdown the database has been disabled. The database has been detached. The ORACLE routine has been disabled. Sys @ STANDBY3 (dtydb5)> startup mount; the ORACLE routine has been started. Www.2cto.com Total System Global Area 3140026368 bytesFixed Size 2230600 bytesVariable Size 771753656 bytesDatabase Buffers 2348810240 bytesRedo Buffers 17231872 bytes the database has been loaded. Sys @ STANDBY3 (dtydb5)> drop database; drop database * row 1st error: ORA-12719: operation requires database in RESTRICTED mode sys @ STANDBY3 (dtydb5)> alter system enable restricted session; the system has been changed. Sys @ STANDBY3 (dtydb5)> drop database; the database has been deleted. Note: The drop database command 2, The drop database command deletes these files from operating system can be available for 1, 10 Gb or above. * Datafiles www.2cto.com * Online Redo Log Files * Controlfiles * SPFILE (if it exists) 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 file3. files in Windows NT will not be automatically deleted by the author hijk139.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.