oracle10gasm复制控制文件

ASM下如何复制控制文件

成都创新互联长期为1000多家客户提供的网站建设服务，团队从业经验10年，关注不同地域、不同群体，并针对不同对象提供差异化的产品和服务；打造开放共赢平台，与合作伙伴共同营造健康的互联网生态环境。为广宗企业提供专业的成都网站设计、网站建设、外贸网站建设，广宗网站改版等技术服务。拥有10余年丰富建站经验和众多成功案例,为您定制开发。

环境:

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

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 --

标题名称：oracle10gasm复制控制文件
文章分享：http://myzitong.com/article/jhjhei.html

oracle10gasm复制控制文件

其他资讯