RAC DB 삭제
[oracle@racdb1 ~]$ crsctl status res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.CRS.dg
ONLINE ONLINE pradg1
ONLINE ONLINE pradg2
ora.DATA.dg
ONLINE ONLINE pradg1
ONLINE ONLINE pradg2
ora.LISTENER.lsnr
ONLINE ONLINE pradg1
ONLINE ONLINE pradg2
ora.RECO.dg
ONLINE ONLINE pradg1
ONLINE ONLINE pradg2
ora.asm
ONLINE ONLINE pradg1 Started
ONLINE ONLINE pradg2 Started
ora.gsd
OFFLINE OFFLINE pradg1
OFFLINE OFFLINE pradg2
ora.net1.network
ONLINE ONLINE pradg1
ONLINE ONLINE pradg2
ora.ons
ONLINE ONLINE pradg1
ONLINE ONLINE pradg2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE pradg2
ora.cvu
1 ONLINE ONLINE pradg2
ora.oc4j
1 ONLINE ONLINE pradg2
ora.pradg1.vip
1 ONLINE ONLINE pradg1
ora.pradg2.vip
1 ONLINE ONLINE pradg2
ora.racdb.db
1 ONLINE ONLINE pradg1 Open
2 ONLINE ONLINE pradg2 Open
ora.scan1.vip
1 ONLINE ONLINE pradg2
[oracle@racdb1 ~]$ srvctl stop database -d racdb
[oracle@racdb1 ~]$ srvctl remove instance -d racdb -i racdb1
racdb 데이터베이스에서 인스턴스를 제거하겠습니까? (y/[n]) y
[oracle@racdb1 ~]$ srvctl remove instance -d racdb -i racdb2
racdb 데이터베이스에서 인스턴스를 제거하겠습니까? (y/[n]) y
[oracle@racdb1 ~]$ srvctl remove database -d racdb
racdb 데이터베이스를 제거하겠습니까? (y/[n]) y
[oracle@racdb1 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Sat May 21 23:18:54 2022
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup mount restsrict exclusive;
ORACLE instance started.
Total System Global Area 3140026368 bytes
Fixed Size 2257352 bytes
Variable Size 788532792 bytes
Database Buffers 2332033024 bytes
Redo Buffers 17203200 bytes
ORA-01504: database name 'RESTSRICT' does not match parameter db_name 'racdb'
SQL> startup mount restrict exclusive;
ORA-01081: cannot start already-running ORACLE - shut it down first
SQL> alter systsem set cluster_database=false scope=spfile;
alter systsem set cluster_database=false scope=spfile
*
ERROR at line 1:
ORA-00940: invalid ALTER command
SQL> alter system set cluster_database=false scope=spfile;
System altered.
SQL> shut immediate;
ORA-01507: database not mounted
ORACLE instance shut down.
SQL> startup mount restrict exclusive;
ORACLE instance started.
Total System Global Area 3140026368 bytes
Fixed Size 2257352 bytes
Variable Size 721423928 bytes
Database Buffers 2399141888 bytes
Redo Buffers 17203200 bytes
Database mounted.
SQL> drop database;
Database dropped.
'ORACLE > ADMIN' 카테고리의 다른 글
| ORACLE SEHA 인스턴스 이동 (0) | 2022.09.15 |
|---|---|
| ORACLE SEHA LISTENER설정 및 상태 체크 (0) | 2022.09.15 |
| 오라클 메모리 튜닝 권고 (0) | 2022.05.22 |
| oracle ERROR: ORA-12547: TNS:lost contact (0) | 2018.08.08 |
| 오라클 role 에 관하여 (0) | 2018.07.21 |
