10g/11g/12g/18c
Ablauf:
Die DB Umgebung wie SID und Oracle Home in der Shell setzen
emctl stop dbconsole
emca -deconfig dbcontrol db -repos drop
#DB stoppen und im Restict Modus starten ---Set DB HOME #Single DB sqlplus / as sysdba #prüfen ob es auch die richtige DB is sql>select inst_id ,status ,instance_name as name ,to_char(STARTUP_TIME, 'dd.mm.YY hh24:mi') as startzeit ,host_name from gv$instance order by 1 / sql>shutdown abort sql>startup mount RESTRICT sql>exit #Cluster DB srvctl stop database -d GPI sqlplus / as sysdba #Cluster mode ausschalten: sql>startup nomount sql>alter system set cluster_database=false scope=spfile; sql>shutdown abort sql>startup mount RESTRICT sql>exit
#Start rman Rman Rman>connect target / RMAN> delete archivelog all; RMAN> delete backup;
RMAN> drop database; database name is "GPIDB" and DBID is 2527786665 Do you really want to drop the database (enter YES or NO)? YES database dropped RMAN>exit
oradim -delete -SID GPIDB