[oracle@rac1~]$ rman target /
RecoveryManager: Release 11.2.0.2.0
Copyright(c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connectedto target database: RAC (DBID=2514956254) 要记住这个 DBID 下面需要用
[oracle@rac1 ~]$ sqlplus / as sysdba
SQL*Plus:Release 11.2.0.2.0 Production
Copyright(c) 1982, 2010, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management,OLAP,
Data Mining and Real Application Testing options
SQL>select name,status from v$controlfile;
NAME
--------------------------------------------------------------------------------
STATUS
-------
+DG1/rac/controlfile/current.260.926974239
[grid@rac1 ~]$ srvctlstop database -d rac
[root@rac1 ~]# su - oracle
[oracle@rac1 ~]$ sqlplus / as sysdba
SQL*Plus:Release 11.2.0.2.0 Production on Thu Apr 17 21:50:23 2014
Copyright(c) 1982, 2010, Oracle. All rights reserved.
Connectedto an idle instance.
SQL> startup nomount;
ORACLE instance started.
TotalSystem Global Area 8351150080 bytes
FixedSize 2243120 bytes
Variable Size 4328523216 bytes
Database Buffers 4009754624bytes
RedoBuffers 10629120 bytes
[oracle@rac1~]$ rman target /
RecoveryManager: Release 11.2.0.2.0 - Production on Thu Apr 17 21:51:05 2014
Copyright(c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connectedto target database: RAC (not mounted)
RMAN> set DBID=2514956254
executingcommand: SET DBID
RMAN> restore controlfile to '+DG1' from'+DG1/rac/controlfile/current.260.926974239';
Startingrestore at 17-APR-14
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=713 instance=rac1 device type=DISK
channelORA_DISK_1: copied control file copy
Finished restore at 17-APR-14
RMAN>
SQL> alter system setcontrol_files='+DG1/rac/controlfile/current.260.926974239','+DG1/rac/controlfile/current.362.845157093'scope=spfile;
Systemaltered.
SQL> shutdown immediate
[grid@rac1 ~]$ srvctl start database -d rac
[oracle@rac1 ~]$ sqlplus / as sysdba
SQL*Plus:Release 11.2.0.2.0 Production on Thu Apr 17 21:55:17 2014
Copyright(c) 1982, 2010, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management,OLAP,
Data Mining and Real Application Testing options
SQL> select name,status fromv$controlfile;
NAME
--------------------------------------------------------------------------------
STATUS
-------
+DG1/rac/controlfile/current.260.926974239
+DG1/rac/controlfile/current.362.845157093