oracle设置控制文件多路径,『ORACLE』RAC—控制文件多路径复制

查看当前控制文件数量及位置、名称

[email protected] rac1>show parameter control_files;

NAME                                             TYPE           VALUE

--------------------------------------------  ------------  ----------------------------------------------------

control_files                                    string         +DATA/racdb/controlfile/current.260.942339579,

关闭数据库并将一个节点启动到nomount

[[email protected] ~]$ srvctl stop database -d racdb

[[email protected] ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Thu Apr 27 23:37:51 2017

Copyright (c) 1982, 2013, Oracle. All rights reserved.

Connected to an idle instance.

[email protected] rac1>startup nomount;

ORACLE instance started.

Total System Global Area 835104768 bytes

Fixed Size 2257840 bytes

Variable Size 603982928 bytes

Database Buffers 226492416 bytes

Redo Buffers 2371584 bytes

利用RMAN创建控制文件

[[email protected] ~]$ rman target /

Recovery Manager: Release 11.2.0.4.0 - Production on Thu Apr 27 23:45:55 2017

Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.

connected to target database: RACDB (not mounted)

RMAN> restore controlfile to ‘+DATA‘ from ‘+DATA/RACDB/CONTROLFILE/Current.260.942339579‘;

Starting restore at 27-APR-17

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=34 instance=RACDB1 device type=DISK

channel ORA_DISK_1: copied control file copy

Finished restore at 27-APR-17

RMAN> restore controlfile to ‘+DATA‘ from ‘+DATA/RACDB/CONTROLFILE/Current.260.942339579‘;

Starting restore at 27-APR-17

using channel ORA_DISK_1

channel ORA_DISK_1: copied control file copy

Finished restore at 27-APR-17

查看已生成的控制文件

ASMCMD> cd DATA/RACDB/CONTROLFILE

ASMCMD> pwd

+DATA/RACDB/CONTROLFILE

ASMCMD> ls

Current.260.942339579

current.269.942446013

current.270.942447435

此时1节点应该在nmount

[email protected] rac1>select inst_id,host_name,status from gv$instance;

INST_ID    HOST_NAME                                                                        STATUS

---------- ---------------------------------------------------------------- ------------

1              rac1                                                                                    OPEN

[email protected] rac1>alter system set control_files=

2 ‘+DATA/RACDB/controlfile/Current.260.942339579‘,

3 ‘+DATA/RACDB/controlfile/current.269.942450435‘,

4 ‘+DATA/RACDB/controlfile/current.270.942450415‘ scope=spfile;

System altered.

[email protected] rac1>shutdown immediate

ORA-01507: database not mounted

ORACLE instance shut down.

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, Real Application Clusters, OLAP, Data Mining

and Real Application Testing options

[[email protected] ~]$ srvctl start database -d racdb

[[email protected] ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Thu Apr 27 23:50:46 2017

Copyright (c) 1982, 2013, Oracle. All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,

Data Mining and Real Application Testing options

[email protected] rac1>select inst_id,name from gv$controlfile;

INST_ID             NAME

--------------------------------------------------------------------------------------------------------

1                     +DATA/racdb/controlfile/current.260.942339579

1                     +DATA/racdb/controlfile/current.269.942450435

1                     +DATA/racdb/controlfile/current.270.942450415

2                     +DATA/racdb/controlfile/current.260.942339579

2                     +DATA/racdb/controlfile/current.269.942450435

2                     +DATA/racdb/controlfile/current.270.942450415

6 rows selected.

原文：http://www.cnblogs.com/KT-melvin/p/6780846.html