RAC oracle删除数据库
24：
site2-DMS1:~ # su - oracle
oracle@site2-DMS1:~> sqlplus / as
sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Fri Mar 21 10:29:28 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release
11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application
Clusters, Automatic Storage Management,
Oracle Label Security,
OLAP, Data Mining, Oracle Database Vault and Real
Application Testing options
SQL> select status from v$instance;
STATUS
------------------------------------
MOUNTED
SQL> show parameter cluster_database;
NAME
TYPE
------------------------------------
---------------------------------
VALUE
------------------------------
cluster_database
boolean
TRUE
cluster_database_instances
integer
2
SQL> shutdown immediate;
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> sqlplus /
as sysdba
SP2-0734: unknown command beginning "sqlplus /..." - rest of line
ignored.
SQL> startup;
ORACLE instance started.
Total System Global Area 3290345472 bytes
Fixed Size
2232840 bytes
Variable Size 1962937848 bytes
Database Buffers
1308622848 bytes
Redo Buffers 16551936 bytes
Database
mounted.
Database opened.
SQL> alter system set cluster_database=false
scope=both
2 ;
alter system set cluster_database=false scope=both
*
ERROR at line 1:
ORA-02095: specified initialization
parameter cannot be modified
SQL> alter system set cluster_database=false scope=spfile;
System altered.
SQL> shutdown immediate;
Database closed.
Database
dismounted.
ORACLE instance shut down.
SQL> startup mount
restrict;
ORACLE instance started.
Total System Global Area 3290345472 bytes
Fixed Size
2232840 bytes
Variable Size 1962937848 bytes
Database Buffers
1308622848 bytes
Redo Buffers 16551936 bytes
Database
mounted.
SQL> select logins,parallel from v$instance;
LOGINS PARALLEL
------------------------------
---------
RESTRICTED NO
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition
Release 11.2.0.3.0 - 64
bit
Production
With the Partitioning, Real Application Clusters, Automatic
Storage Management,
Oracle Label
Security,
OLAP, Data Mining, Oracle Database Vault and Real Application
Testing options
oracle@site2-DMS1:~> rman target / nocatalog
Recovery Manager: Release 11.2.0.3.0 - Production on Fri Mar 21 10:32:55 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORA11G (DBID=4235703729, not open)
using
target database control file instead of recovery catalog
RMAN> drop database including backups;
database name is "ORA11G" and DBID is 4235703729
Do you really want to drop all backups and the database (enter YES or NO)? NO
RMAN> drop database;
database name is "ORA11G" and DBID is 4235703729
Do you really want to drop the database (enter YES or NO)? YES
database
dropped
25：
site2-DMS2:~ # su - oracle
oracle@site2-DMS2:~> sqlplus / as
sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Fri Mar 21 10:31:34 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release
11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application
Clusters, Automatic Storage Management,
Oracle Label Security,
OLAP, Data Mining, Oracle Database Vault and Real
Application Testing options
SQL> select status from v$instance;
STATUS
------------------------------------
MOUNTED
SQL> shutdown immediate;
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL>
郑重声明：本站内容如果来自互联网及其他传播媒体，其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享，并不代表本站赞同其观点和对其真实性负责，也不构成任何其他建议。
