温馨提示×

温馨提示×

您好,登录后才能下订单哦!

密码登录×
登录注册×
其他方式登录
点击 登录注册 即表示同意《亿速云用户服务条款》

oracle10g asm复制控制文件

发布时间:2020-06-20 00:58:23 来源:网络 阅读:575 作者:199001040018 栏目:关系型数据库

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


向AI问一下细节

免责声明:本站发布的内容(图片、视频和文字)以原创、转载和分享为主,文章观点不代表本网站立场,如果涉及侵权请联系站长邮箱:is@yisu.com进行举报,并提供相关证据,一经查实,将立刻删除涉嫌侵权内容。

AI