Oracle11gR2--删除数据库

1. 停止ORACLE数据库

[oracle@localhost oracle]$ ps -ef|grep smon
oracle    72550      1  0 14:23 ?        00:00:00 ora_smon_orcl
oracle    76122  76045  0 16:18 pts/0    00:00:00 grep --color=auto smon


[oracle@localhost dbhome_1]$ sqlplus  / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Mon Jan 29 19:13:07 2018

Copyright (c) 1982, 2013, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>     
SQL> 
SQL> 
SQL> shutdown abort
ORACLE instance shut down.
SQL> exit

2.删除相关文件

[oracle@localhost database]$ cd $ORACLE_BASE
[oracle@localhost app]$ ll
total 4008180
drwxr-x---.  3 oracle dba            4096 Jul 14  2015 admin
drwxr-x---.  6 oracle dba            4096 Dec 19 16:31 cfgtoollogs
drwxr-xr-x.  2 oracle dba            4096 Jul 14  2015 checkpoints
drwxr-xr-x.  7 oracle dba            4096 Jul 14  2015 database
drwxrwxr-x. 11 oracle dba            4096 Jul 14  2015 diag
drwxr-x---.  3 oracle dba            4096 Jul 14  2015 fast_recovery_area
drwxr-xr-x.  7 oracle dba            4096 Aug 27  2013 grid
drwxr-xr-x.  3 oracle dba            4096 Jul 14  2015 oggsource
drwxr-xr-x.  3 oracle oinstall       4096 Jul 14  2015 oracle
-rw-r--r--.  1 root   root      352172376 Jul 14  2015 Oracle GoldenGate V12.1.2.1.0 for Oracle 11g on Linux x86-64.zip
drwxr-xr-x.  3 oracle oinstall       4096 Jul 14  2015 oradata
-rw-r--r--.  1 root   root     1395582860 Jul 14  2015 p13390677_112040_Linux-x86-64_1of7.zip
-rw-r--r--.  1 root   root     1151304589 Jul 14  2015 p13390677_112040_Linux-x86-64_2of7.zip
-rw-r--r--.  1 root   root     1205251894 Jul 14  2015 p13390677_112040_Linux-x86-64_3of7.zip
[oracle@localhost app]$ cd oradata
[oracle@localhost oradata]$ ll
total 4
drwxr-x---. 2 oracle dba 4096 Dec 19 16:45 orcl
[oracle@localhost oradata]$ cd orcl
[oracle@localhost orcl]$ ll
total 3034564
-rw-r-----. 1 oracle dba    9748480 Jan 29 19:16 control01.ctl
-rw-r-----. 1 oracle dba  104865792 Jan 29 09:05 ggsdirector.dbf
-rw-r-----. 1 oracle dba  209723392 Jan 29 09:05 goldengate.dbf
-rw-r-----. 1 oracle dba  209723392 Jan 29 09:05 mycat.dbf
-rw-r-----. 1 oracle dba   52429312 Jan 29 09:00 redo01.log
-rw-r-----. 1 oracle dba   52429312 Jan 29 19:15 redo02.log
-rw-r-----. 1 oracle dba   52429312 Jan 28 23:00 redo03.log
-rw-r-----. 1 oracle dba 1121984512 Jan 29 19:11 sysaux01.dbf
-rw-r-----. 1 oracle dba  775954432 Jan 29 19:14 system01.dbf
-rw-r-----. 1 oracle dba   61874176 Jan 28 22:10 temp01.dbf
-rw-r-----. 1 oracle dba  450895872 Jan 29 19:14 undotbs01.dbf
-rw-r-----. 1 oracle dba    6561792 Jan 29 09:05 users01.dbf
[oracle@localhost orcl]$ cd ..
[oracle@localhost oradata]$ ll
total 4
drwxr-x---. 2 oracle dba 4096 Dec 19 16:45 orcl
[oracle@localhost oradata]$ rm -rf orcl
[oracle@localhost oradata]$ ll
total 0
[oracle@localhost oradata]$ cd $ORACLE_HOME
[oracle@localhost dbhome_1]$ cd dbs
[oracle@localhost dbs]$ ll
total 20
-rw-rw----. 1 oracle dba 1544 Jan 29 19:16 hc_orcl.dat
-rw-r--r--. 1 oracle dba 2851 May 15  2009 init.ora
-rw-r-----. 1 oracle dba   24 Jul 14  2015 lkORCL
-rw-r-----. 1 oracle dba 1536 Jul 14  2015 orapworcl
-rw-r-----. 1 oracle dba 2560 Jan 28 22:10 spfileorcl.ora
[oracle@localhost dbs]$ rm -rf *orcl*
[[oracle@localhost dbs]$ exit
logout
[root@localhost ~]# cat /etc/oratab
#



# This file is used by ORACLE utilities.  It is created by root.sh
# and updated by either Database Configuration Assistant while creating
# a database or ASM Configuration Assistant while creating ASM instance.

# A colon, ':', is used as the field terminator.  A new line terminates
# the entry.  Lines beginning with a pound sign, '#', are comments.
#
# Entries are of the form:
#   $ORACLE_SID:$ORACLE_HOME:<N|Y>:
#
# The first and second fields are the system identifier and home
# directory of the database respectively.  The third filed indicates
# to the dbstart utility that the database should , "Y", or should not,
# "N", be brought up at system boot time.
#
# Multiple entries with the same $ORACLE_SID are not allowed.
#
#
orcl:/home/oracle/app/oracle/product/11.2.0/dbhome_1:N


[root@localhost usr]# rm -rf /etc/oratab

[root@localhost ~]# cat /etc/oraInst.loc 
inventory_loc=/home/oracle/oraInventory
inst_group=dba
[root@localhost ~]# cd /home/oracle/oraInventory
[root@localhost oraInventory]# ll
total 20
drwxrwx---. 2 oracle dba 4096 Jul 14  2015 ContentsXML
drwxrwx---. 2 oracle dba 4096 Jul 14  2015 logs
-rw-rw----. 1 oracle dba   55 Jul 14  2015 oraInst.loc
-rwxrwx---. 1 oracle dba 1636 Jul 14  2015 orainstRoot.sh
drwxrwx---. 2 oracle dba 4096 Jul 14  2015 oui
[root@localhost oraInventory]# cd ContentsXML
[root@localhost ContentsXML]# ll
total 12
-rw-rw----. 1 oracle dba 329 Jul 14  2015 comps.xml
-rw-rw----. 1 oracle dba 488 Jul 14  2015 inventory.xml
-rw-rw----. 1 oracle dba 292 Jul 14  2015 libs.xml
[root@localhost ContentsXML]# cat 
comps.xml      inventory.xml  libs.xml       
[root@localhost ContentsXML]# cat inventory.xml 
<?xml version="1.0" standalone="yes" ?>
<!-- Copyright (c) 1999, 2013, Oracle and/or its affiliates.
All rights reserved. -->
<!-- Do not modify the contents of this file by hand. -->
<INVENTORY>
<VERSION_INFO>
   <SAVED_WITH>11.2.0.4.0</SAVED_WITH>
   <MINIMUM_VER>2.1.0.6.0</MINIMUM_VER>
</VERSION_INFO>
<HOME_LIST>
<HOME NAME="OraDb11g_home1" LOC="/home/oracle/app/oracle/product/11.2.0/dbhome_1" TYPE="O" IDX="1"/>
</HOME_LIST>
<COMPOSITEHOME_LIST>
</COMPOSITEHOME_LIST>
</INVENTORY>
[root@localhost ContentsXML]# rm -rf inventory.xml



[root@localhost ~]# rm -rf /home/oracle/app/oracle/product/11.2.0/dbhome_1/*
posted @ 2018-01-31 14:52  chinesern  阅读(1995)  评论(0编辑  收藏  举报