卸载一个数据库包含了移除数据文件, redo log文件,控制文件,和初始化参数文件。可以手动执行DROP DATABASE这个SQL语句来手动卸载数据库。 这个语句删除所有的控制文件,以及所有列于控制文件之中的所有的数据库文件。 要使这个语句成功执行,以下所有的条件必须满足:
1. The database must mounted and closed
2. The database must be mounted exclusively(not in share mode).
3. The database must have been started in RESTRICT mode
例:
STARTUP RESTRICT FORCE MOUNT
DROP DATABASE
DROP DATABASE statement has no effect on archived log files, nor does it have any effect on copies or backups of the database. It is best to use Recovery Manager(RMAN) to delete such files.
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/8520577/viewspace-761742/
,如需转载,请注明出处,否则将追究法律责任。