【ORACLE】ORACLE RAC设置控制文件多路

                              

[oracle@rac01 ~]$ srvctl stop database -d proc -o immediate
[oracle@rac01 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Sun Apr 8 20:58:16 2018

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

Connected to an idle instance.

SQL> startup nomount
ORACLE instance started.

Total System Global Area  776646656 bytes
Fixed Size                    2257272 bytes
Variable Size                  570429064 bytes
Database Buffers          201326592 bytes
Redo Buffers                    2633728 bytes
SQL> create pfile='/home/oracle/initproc.ora' from spfile;

File created.

SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Product
ionWith the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options


[oracle@rac01 ~]$ rman target/
RMAN> restore controlfile to '+ARCH' from '+DATA/proc/controlfile/current.274.971309975';

Starting restore at 08-APR-18
using channel ORA_DISK_1

channel ORA_DISK_1: copied control file copy
Finished restore at 08-APR-18


SQL> alter system set control_files='+DATA/proc/controlfile/current.274.971309975','+ARCH/p
roc/CONTROLFILE/current.256.972939847' scope=spfile sid='*';
System altered.

SQL> shutdown immediate;
ORA-01507: database not mounted


ORACLE instance shut down.


[oracle@rac01 ~]$ srvctl start database -d proc


SQL> select inst_id,name from gv$controlfile;
 
原文地址:https://www.cnblogs.com/xphdbky/p/8746087.html