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>
最新文章
- C#将WebBowser控件替换为Chrome内核
- 调用discuz编辑器发布帖子显示html代码的解决办法
- 用VLC Media Player搭建简单的流媒体服务器
- knockout源码分析之执行过程
- qt_计算器的简单实现
- JQuery 支持 hide 和 show 事件的方法与分析
- [问题2014S02] 解答
- postgresql 9.6 rc1发布
- JS基础知识（基本类型 引用类型）
- C3P0数据库连接池的相关bug解决
- java重写
- Objective-C中字典的使用方法总结
- Linux概念架构的理解(转)
- httpd日志和日志轮替工具
- 第4章 PCIe总线概述
- error: cannot lock ref 'refs/remotes/origin/master': unable to resolve reference 'refs/remotes/origin/master': reference broken...
- python之路-----多线程与多进程
- Django--cookie操作
- 关于flexjson将json转为javabean的使用
- shell编程awk基础介绍