【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