Oracle 删库

最近，“从删库到跑路”的话题热度攀升，今天就教你如何进行Oracle 删库！

DBCA启动图形界面


选择要删除的DB，点击finish按钮即可。


半杯茶的工夫，删库完成！比安装EZ很多~~


附1. 手工创建的数据库注册到 DBCA（添加到最后一行）：

1. [oracle@db01 ~]$ vi /etc/oratab
   
2. #
   
3. 
   
4. 
   
5. 
   
6. # This file is used by ORACLE utilities. It is created by root.sh
   
7. # and updated by either Database Configuration Assistant while creating
   
8. # a database or ASM Configuration Assistant while creating ASM instance.
   
9. 
   
10. # A colon, ':', is used as the field terminator. A new line terminates
    
11. # the entry. Lines beginning with a pound sign, '#', are comments.
    
12. #
    
13. # Entries are of the form:
    
14. # $ORACLE_SID:$ORACLE_HOME:<N|Y>:
    
15. #
    
16. # The first and second fields are the system identifier and home
    
17. # directory of the database respectively. The third filed indicates
    
18. # to the dbstart utility that the database should , "Y", or should not,
    
19. # "N", be brought up at system boot time.
    
20. #
    
21. # Multiple entries with the same $ORACLE_SID are not allowed.
    
22. #
    
23. #
    
24. ORCL:/u01/app/oracle/product/11.2.0/db_1:N
    
25. PROD:/u01/app/oracle/product/11.2.0/db_1:N

附2. DBCA静默安装的样例：

点击(此处)折叠或打开

1. 
   
2. [oracle@db01 ~]$ dbca -silent -createDatabase -templateName $ORACLE_HOME/assistants/dbca/templates/General_Purpose.dbc -gdbname PROD -sid PROD -characterSet ZHS16GBK
   
3. Enter SYS user password:
   
4.  
   
5. Enter SYSTEM user password:
   
6.  
   
7. Copying database files
   
8. 1% complete
   
9. 3% complete
   
10. 37% complete
    
11. Creating and starting Oracle instance
    
12. 40% complete
    
13. 45% complete
    
14. 50% complete
    
15. 55% complete
    
16. 56% complete
    
17. 60% complete
    
18. 62% complete
    
19. Completing Database Creation
    
20. 66% complete
    
21. 70% complete
    
22. 73% complete
    
23. 85% complete
    
24. 96% complete
    
25. 100% complete
    
26. Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/PROD/PROD.log" for further details.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/12707874/viewspace-2144581/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/12707874/viewspace-2144581/