ASM中增加控制文件成员
来源:互联网 发布:网络创业毕业论文 编辑:程序博客网 时间:2024/04/29 22:37
环境:
OS:Red Hat Linux As 5
DB:11.2.0.1(ASM)
1.查看当前控制文件
SQL> select name from v$controlfile;
SQL> select name from v$controlfile;
NAME
--------------------------------------------------------------------------------
+DATA/oracl/controlfile/current.260.794393131
--------------------------------------------------------------------------------
+DATA/oracl/controlfile/current.260.794393131
2.查看参数文件
SQL> show parameters control_files;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
control_files string +DATA/oracl/controlfile/curren
t.260.794393131
------------------------------------ ----------- ------------------------------
control_files string +DATA/oracl/controlfile/curren
t.260.794393131
3.关闭数据库
shutdowm immediate
4.使用RMAN复制控制文件
[hxl.com::/]$rman target /
[hxl.com::/]$rman target /
RMAN> startup nomount
Oracle instance started
Total System Global Area 338968576 bytes
Fixed Size 1336400 bytes
Variable Size 276827056 bytes
Database Buffers 54525952 bytes
Redo Buffers 6279168 bytes
Variable Size 276827056 bytes
Database Buffers 54525952 bytes
Redo Buffers 6279168 bytes
RMAN> restore controlfile to '+RECDATA' from '+DATA/oracl/controlfile/current.260.794393131';
Starting restore at 2012-09-21 06:53:56
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=23 device type=DISK
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=23 device type=DISK
channel ORA_DISK_1: copied control file copy
Finished restore at 2012-09-21 06:54:01
Finished restore at 2012-09-21 06:54:01
5.使用ASMCMD查看控制文件的名字
ASMCMD> pwd
+recdata/oracl/CONTROLFILE
ASMCMD> ls
current.265.794560115
ASMCMD> pwd
+recdata/oracl/CONTROLFILE
ASMCMD> ls
current.265.794560115
新建的控制文件如下:
+RECDATA/oracl/controlfile/current.265.794560115
+RECDATA/oracl/controlfile/current.265.794560115
6.修改spfile
[hxl.com::/]$echo $ORACLE_SID
[hxl.com::/]$sqlplus /nolog
[hxl.com::/]$echo $ORACLE_SID
[hxl.com::/]$sqlplus /nolog
SQL*Plus: Release 11.2.0.1.0 Production on Fri Sep 21 06:57:42 2012
Copyright (c) 1982, 2009, Oracle. All rights reserved.
SQL> connect / as sysdba
Connected.
SQL> alter system set control_files='+DATA/oracl/controlfile/current.260.794393131','+RECDATA/oracl/controlfile/current.265.794560115' scope=spfile;
Connected.
SQL> alter system set control_files='+DATA/oracl/controlfile/current.260.794393131','+RECDATA/oracl/controlfile/current.265.794560115' scope=spfile;
System altered.
SQL> shutdown immediate
ORA-01507: database not mounted
SQL> shutdown immediate
ORA-01507: database not mounted
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
ORACLE instance started.
Total System Global Area 338968576 bytes
Fixed Size 1336400 bytes
Variable Size 276827056 bytes
Database Buffers 54525952 bytes
Redo Buffers 6279168 bytes
Database mounted.
Database opened.
Fixed Size 1336400 bytes
Variable Size 276827056 bytes
Database Buffers 54525952 bytes
Redo Buffers 6279168 bytes
Database mounted.
Database opened.
7.查看修改后的参数
SQL> show parameters control_files;
SQL> show parameters control_files;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
control_files string +DATA/oracl/controlfile/curren
t.260.794393131, +RECDATA/orac
l/controlfile/current.265.7945
60115
------------------------------------ ----------- ------------------------------
control_files string +DATA/oracl/controlfile/curren
t.260.794393131, +RECDATA/orac
l/controlfile/current.265.7945
60115
0 0
- ASM中增加控制文件成员
- RAC+ASM下增加控制文件
- 如何为 asm RAC 数据库增加控制文件
- asm 增加控制文件,使用控制文件多路复用(附带如何从asm里面拷出文件)
- ASM实例中增加磁盘
- oracle 10g rac asm上面的控制文件损坏既增加方法
- ASM下加控制文件
- 增加控制文件controlfile
- 增加控制文件
- 增加控制文件副本
- oracle增加控制文件
- 10g ASM下加控制文件 .
- ASM下如何复制控制文件
- ORACLE RAC+ASM修改控制文件位置
- 如何将控制文件迁移到ASM
- 增加数据库控制文件命令
- oracle手动增加控制文件
- RAC增加控制文件多路复用
- ARM多核引导过程
- 嵌入式 linux yum命令详解
- PHP的学习--解析URL
- 静态成员的初始化顺序(C#,java)
- Java中单例模式的多种实现方式
- ASM中增加控制文件成员
- 第12周项目一 程序阅读题(3)
- 第十二周项目一 阅读程序
- 数据结构_单链表的建立与反转
- 【python】 读取Excel文件并绘制图表
- Java学习(七)高级for循环、可变参数的使用
- python的shorthand notation
- 第12周项目1-阅读程序(3)递归函数
- Oracle: listener.ora 、sqlnet.ora 、tnsnames.ora的配置及例子