ORACLE手工删除数据库

SQL> select status ,name from v$controlfile;

SQL> select * from v$dbfile; 

SQL> select * from v$logfile;

SQL>archive log list;  

$lsnrctl stop  或 lsnrctl stop listener_name

[oracle@DB-Server ~]$ emctl stop dbconsole

TZ set to Hongkong

Oracle Enterprise Manager 10g Database Control Release 10.2.0.5.0  

Copyright (c) 1996, 2010 Oracle Corporation.  All rights reserved.

http://EGMLNX02.eel1.esquel.com:1158/em/console/aboutApplication

Stopping Oracle Enterprise Manager 10g Database Control ... 

 Cannot determine Oracle Enterprise Manager 10g Database Control process. /u01/app/oracle/product/10.2.0/db_1/xxxxx_xxx/emctl.pid does not exist. 

SQL> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup mount exclusive restrict;

或

SQL> startup mount;

SQL> alter system enable restricted session;

SQL>  SET SERVEROUTPUT ON

SQL>  DECLARE

      TYPE string_arr IS TABLE OF VARCHAR2(1024);

      file_list string_arr;

      BEGIN

           SELECT t.file_path BULK COLLECT

           INTO file_list

           FROM (SELECT NAME file_path

                  FROM V$DATAFILE

                 UNION

                   SELECT MEMBER file_path

                   FROM V$LOGFILE

                 UNION

                   SELECT NAME file_path

                   FROM v$controlfile

                 UNION

                   SELECT VALUE file_path

                    FROM v$parameter

                    WHERE NAME LIKE '%dest'

                 UNION

                   SELECT VALUE file_path

                   FROM v$parameter2

                   WHERE NAME = 'utl_file_dir'

                 UNION

                   SELECT '$ORACLE_BASE/admin/$ORACLE_SID' file_path 

                   FROM dual

                 ) t;

                 FOR i IN file_list.FIRST .. file_list.LAST LOOP

                            DBMS_OUTPUT.PUT_LINE('rm -f ' || file_list(i));

                 END LOOP;

         END;

         /

$echo $ORACLE_SID                                      --确认当前的ORACLE_SID

$ls $ORACLE_BASE/admin/$ORACLE_SID                     --删除Oracle Base目录下$ORACLE_SID时，先检查、确认一下

$ rm -rf $ORACLE_BASE/admin/$ORACLE_SID                --删除oracle base目录下的$ORACLE_SID的所有内容

注意，任何删除前最好先检查、确认，例如下面删除归档日志，我测试的环境，没有开启归档模式，所以下面命令根本没有必要

$ ls -lrt $ORACLE_BASE/arch/$ORACLE_SID          

$ rm -rf $ORACLE_BASE/arch/$ORACLE_SID                 --清除归档日志，注意归档路径的正确性

$ rm -rf $ORACLE_BASE/flash_recovery_area/$ORACLE_SID  --清除闪回区的内容

删除前，最好将所有的参数文件保存到另外一个目录，以免需要参考时需要

$ cp $ORACLE_HOME/dbs/*  /tmp/

$ rm -rf $ORACLE_HOME/dbs/*$ORACLE_SID*                --清除参数文件     

 $ rm $TNS_ADMIN/*.ora                          --如果设定了$TNS_ADMIN变量，否则删除默认路径下的监听文件

 $ rm $ORACLE_HOME/network/admin/*.ora          --注意，如果动态监听可能不存在这些文件。如果不删除，重新创建同样名字数据库

                                                --时，监听可能会有一些异常情况。