Oracle刪庫跑路

標籤：刪除   spfile   ESS   rem   scope   sysdba   pfile   start   fixed   

--10g R2startup mount exclusive restrict;alter system enable restricted session;drop database;--11gstartup mount exclusive;alter system enable restricted session;drop database;--RAC 12.1.0.2.0刪庫 1.先停止所有節點執行個體2.在其中一節點操作,先關閉rac模式startup nomount;alter system set CLUSTER_DATABASE=FALSE scope=spfile;shutdown immediate;3.啟動mount restric模式startup mount restrict;4.刪除資料庫drop database;

刪庫刪全套兒！

su - oracle--刪除servicesrvctl remove service -d sgsopen -s sopen1srvctl remove service -d sgsopen -s sopen2--刪除db庫1.先停止所有節點執行個體2.在其中一節點操作,先關閉rac模式startup nomount;alter system set CLUSTER_DATABASE=FALSE scope=spfile;shutdown immediate;3.啟動mount restric模式startup mount restrict;4.刪除資料庫drop database;--刪除db資源srvctl remove database -d sgsopen

 

1 --10g R22 startup mount exclusive restrict;3 alter system enable restricted session;4 drop database;

10g R2

1 --11g2 startup mount exclusive;3 alter system enable restricted session;4 drop database;

11g

--RAC 12.1.0.2.0刪庫 1.先停止所有節點執行個體2.在其中一節點操作,先關閉rac模式startup nomount;alter system set CLUSTER_DATABASE=FALSE scope=spfile;shutdown immediate;3.啟動mount restric模式startup mount restrict;4.刪除資料庫drop database;

RAC 12.1.0.2.0刪庫

 1 --RAC 12.1.0.2.0刪庫跑路失敗1 2 startup mount exclusive; 3 alter system enable restricted session; 4 drop database; 5  6  7 oracle@DB01:/home/oracle#sqlplus / as sysdba 8  9 SQL*Plus: Release 12.1.0.2.0 Production on 星期四 8月 16 15:17:08 201810 11 Copyright (c) 1982, 2014, Oracle.  All rights reserved.12 13 Connected to an idle instance.14 15 SQL> startup mount exclusive;16 ORACLE instance started.17 18 Total System Global Area 1.5945E+11 bytes19 Fixed Size                  7726760 bytes20 Variable Size            5.7982E+10 bytes21 Database Buffers         1.0039E+11 bytes22 Redo Buffers             1066012672 bytes23 Database mounted.24 SQL>25 SQL> alter system enable restricted session;26 27 System altered.28 29 SQL> drop database;30 drop database31 *32 ERROR at line 1:33 ORA-01586: 對於此操作, 資料庫必須以 EXCLUSIVE 模式裝載且不開啟34 35 SQL> alter database close;36 alter database close37 *38 ERROR at line 1:39 ORA-01109: 資料庫未開啟40 41 SQL> drop database;42 drop database43 *44 ERROR at line 1:45 ORA-01586: 對於此操作, 資料庫必須以 EXCLUSIVE 模式裝載且不開啟46 47 SQL> select open_mode from v$database;48 49 OPEN_MODE50 --------------------51 MOUNTED

RAC 12.1.0.2.0刪庫跑路失敗1

 1 --RAC 12.1.0.2.0刪庫跑路失敗2 2 startup mount; 3 alter system enable restricted session; 4 drop database; 5  6 SQL> startup mount; 7 ORACLE instance started. 8  9 Total System Global Area 1.5945E+11 bytes10 Fixed Size                  7726760 bytes11 Variable Size            5.7982E+10 bytes12 Database Buffers         1.0039E+11 bytes13 Redo Buffers             1066012672 bytes14 Database mounted.15 SQL> alter system enable restricted session;16 17 System altered.18 19 SQL> drop database;20 drop database21 *22 ERROR at line 1:23 ORA-01586: 對於此操作, 資料庫必須以 EXCLUSIVE 模式裝載且不開啟

RAC 12.1.0.2.0刪庫跑路失敗2

 

Oracle刪庫跑路