ASM下如何复制控制文件环境:OS:Red Hat linux As 5DB:11.2.0.1(ASM) 1.查看当前控制文件sql> select name from v$con
ASM下如何复制控制文件
环境:
OS:Red Hat linux As 5
DB:11.2.0.1(ASM)
1.查看当前控制文件
sql> select name from v$controlfile;
NAME
--------------------------------------------------------------------------------
+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
3.关闭数据库
shutdowm immediate
4.使用RMAN复制控制文件
[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
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
channel ORA_DISK_1: copied control file copy
Finished restore at 2012-09-21 06:54:01
5.使用ASMCMD查看控制文件的名字
ASMCMD> pwd
+recdata/oracl/CONTROLFILE
ASMCMD> ls
current.265.794560115
新建的控制文件如下:
+RECDATA/oracl/controlfile/current.265.794560115
6.修改spfile
[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 setcontrol_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
ORACLE instance shut down.
SQL> startup
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.
7.查看修改后的参数
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
-- The End --
--结束END--
本文标题: oracle10g asm复制控制文件
本文链接: https://www.lsjlt.com/news/37828.html(转载时请注明来源链接)
有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
下载Word文档到电脑,方便收藏和打印~
2024-05-15
2024-05-15
2024-05-15
2024-05-15
2024-05-15
2024-05-15
2024-05-15
2024-05-15
2024-05-14
2024-05-14
回答
回答
回答
回答
回答
回答
回答
回答
回答
回答
0