Home
 | 
Articles
 | 
Backup & Recovery
 | 
RMAN Restore/Recovery (RAC -> Single Instance)
 | 
RMAN Restore/Recovery
 (RAC -> Single Instance)
Last modified: September 2016
Recent Article
All Archives
Topics
Comments 
by ShanNura
»»
This article demonstrates the step by step procedure of restoring and recovering a RAC database to a different server (single instance).
Assumptions
  • A linux box is already configured with Oracle Restart (12cR1) and Database Server software (12cR1) is already installed
  • ASM diskgroups have sufficient space for the restoration task
  • Valid RMAN backup is available and accessible
RMAN Backup
$
[oracle@olinux7201 /]$ ls -l /u02/rmanbkp/phoenix/
total 1128572
-rw-r--r--. 1 oracle oinstall 175440896 Sep 23 10:07 archivelog_1498_1.bak
-rw-r--r--. 1 oracle oinstall     73632 Sep 23 10:06 backup.log
-rw-r--r--. 1 oracle oinstall  19398656 Sep 23 10:07 c-1356565195-20160921-00
-rw-r--r--. 1 oracle oinstall  19398656 Sep 23 10:07 c-1356565195-20160921-01
-rw-r--r--. 1 oracle oinstall  19398656 Sep 23 10:07 c-1356565195-20160921-02
-rw-r--r--. 1 oracle oinstall   1343488 Sep 23 10:07 controlfile_1501.bak
-rw-r--r--. 1 oracle oinstall   1343488 Sep 23 10:07 PHOENIX_controlfile_1500.bak
-rw-r--r--. 1 oracle oinstall 917913600 Sep 23 10:08 phoenix_1495_1.bak
-rw-r--r--. 1 oracle oinstall   1343488 Sep 23 10:07 phoenix_1496_1.bak
Restore the SPFILE
$
[oracle@olinux7201 /]$ ORACLE_SID=PHOENIX
$
[oracle@olinux7201 /]$ rman target /

Recovery Manager: Release 12.1.0.2.0 - Production on Fri Sep 23 10:16:59 2016

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

connected to target database (not started)
RMAN>
RMAN> set DBID=1356565195

executing command: SET DBID

RMAN> startup nomount ;

startup failed: ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/u01/app/oracle/product/12.1.0/db_1/dbs/initPHOENIX.ora'

starting Oracle instance without parameter file for retrieval of spfile
Oracle instance started

Total System Global Area    1073741824 bytes

Fixed Size                     2932632 bytes
Variable Size                281018472 bytes
Database Buffers             784334848 bytes
Redo Buffers                   5455872 bytes
RMAN>
RMAN> run {
2> set CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/u02/rmanbkp/phoenix/%F';
3> restore SPFILE from autobackup ;
4> }

executing command: SET CONTROLFILE AUTOBACKUP FORMAT

Starting restore at 23-SEP-2016 10:20:26
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=12 device type=DISK

channel ORA_DISK_1: looking for AUTOBACKUP on day: 20160923
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20160922
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20160921
channel ORA_DISK_1: AUTOBACKUP found: /u02/rmanbkp/phoenix/c-1356565195-20160921-02
channel ORA_DISK_1: restoring spfile from AUTOBACKUP /u02/rmanbkp/phoenix/c-1356565195-20160921-02
channel ORA_DISK_1: SPFILE restore from AUTOBACKUP complete
Finished restore at 23-SEP-2016 10:20:28


RMAN> shutdown immediate
$<>  
[oracle@olinux7201 ~]$ ls -l $ORACLE_HOME/dbs/spfile*
-rw-r-----. 1 oracle oinstall 7680 Sep 23 10:20 /u01/app/oracle/product/12.1.0/db_1/dbs/spfilePHOENIX.ora
$
[oracle@olinux7201 train1]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Thu Sep 22 11:57:54 2016

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

Connected to an idle instance.

SQL> create pfile from spfile ;

File created.
Modified the pfile as below and removing the cluster related parameters:
$<>  
[oracle@olinux7201 dbs]$ cat initPHOENIX.ora
*.audit_file_dest='/u01/app/oracle/admin/PHOENIX/adump'
*.audit_trail='db'
*.cluster_database=false #modified 
*.compatible='12.1.0.2.0'
*.control_files='+FRADG/PHOENIX/control01.ctl','+DATADG/PHOENIX/control02.ctl' #modified 
*.cursor_sharing='FORCE'
*.db_block_size=8192
*.db_create_file_dest='+DATADG' #modified
*.db_domain=''
*.db_file_name_convert='+ORCLDG/PHOENIX','+DATADG/PHOENIX' #modified
*.db_name='PHOENIX'
*.db_unique_name='PHOENIX'
*.db_writer_processes=2
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=PHOENIXXDB)'
*.job_queue_processes=100
*.log_archive_dest_1='location=/u01/app/oracle/product/12.1.0/db_1/arch arch reopen=60 max_failure=0 mandatory valid_for=(ALL_LOGFILES,ALL_ROLES) db_unique_name=PHOENIX'
*.log_archive_format='%t_%s_%r.arch'
*.log_archive_max_processes=12
*.log_archive_trace=16384
*.log_file_name_convert='+ORCLDG/PHOENIX','+DATADG/PHOENIX','+ORCLDG/PHOENIX/ONLINELOG','+DATADG/PHOENIX/ONLINELOG','+ARCHDG/PHOENIX/ONLINELOG','+DATADG/PHOENIX/ONLINELOG' #modified
*.memory_max_target=2G #modified
*.memory_target=2G #modified
*.nls_currency='R'
*.nls_iso_currency='SOUTH AFRICA'
*.nls_territory='SOUTH AFRICA'
*.open_cursors=300
*.os_authent_prefix=''
*.parallel_degree_policy='AUTO'
*.parallel_execution_message_size=65535
*.parallel_max_servers=24
*.processes=1500
*.remote_login_passwordfile='exclusive'
*.service_names='PHOENIX'
*.session_cached_cursors=300
*.sessions=1500
*.sort_area_retained_size=65536
*.transactions=250
*.transactions_per_rollback_segment=15
*.undo_retention=3600
*.undo_tablespace='UNDOTBS1' #modified
$
[oracle@olinux7201 dbs]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Fri Sep 23 10:30:36 2016

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

Connected to an idle instance.

SQL> create spfile from pfile ;

File created.

SQL>
Restore the CONTROLFILE
$
[oracle@olinux7201 phoenix]$ rman target /

Recovery Manager: Release 12.1.0.2.0 - Production on Fri Sep 23 10:31:25 2016

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

connected to target database (not started)
$<>  
RMAN> startup nomount;
RMAN> set DBID=1356565195
RMAN> run {
2> set CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/u02/rmanbkp/phoenix/%F';
3> restore controlfile from autobackup ;
4> }

executing command: SET CONTROLFILE AUTOBACKUP FORMAT

Starting restore at 23-SEP-2016 10:33:14
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1151 device type=DISK

channel ORA_DISK_1: looking for AUTOBACKUP on day: 20160923
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20160922
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20160921
channel ORA_DISK_1: AUTOBACKUP found: /u02/rmanbkp/phoenix/c-1356565195-20160921-02
channel ORA_DISK_1: restoring control file from AUTOBACKUP /u02/rmanbkp/phoenix/c-1356565195-20160921-02
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00601: fatal error in recovery manager
RMAN-03004: fatal error during execution of command
ORA-01092: ORACLE instance terminated. Disconnection forced
Alert log indicated a couple of error which I googled and found some solution. In fact, the messages say that Oracle cannot access the ASMLib drivers is strange although I could access all the disk groups from within ASM. Mounting and unmounting of the disk groups worked perfectly. The output from 'crsctl status resource' also indicated everything was in order.

Fri Sep 23 10:31:43 2016
Errors in file /u01/app/oracle/diag/rdbms/phoenix/PHOENIX/trace/PHOENIX_rbal_5155.trc:
ORA-15183: ASMLIB initialization error [driver/agent not installed]
Fri Sep 23 10:31:43 2016

WARNING: FAILED to load library: /opt/oracle/extapi/64/asm/orcl/1/libasm.so
Login as grid user and execute the script as below:
$
[oracle@olinux7201 trace]$ su - grid
[grid@olinux7201 ~]$ cd $ORACLE_HOME/bin
$
[grid@olinux7201 grid]$ ls -l /u01/app/oracle/product/12.1.0/db_1/bin/oracle
-rwsr-s--x. 1 oracle oinstall 323649826 Sep 19 13:15 /u01/app/oracle/product/12.1.0/db_1/bin/oracle
$
[grid@olinux7201 bin]$ ./setasmgidwrap o=/u01/app/oracle/product/12.1.0/db_1/bin/oracle
$
[grid@olinux7201 bin]$ ls -l /u01/app/oracle/product/12.1.0/db_1/bin/oracle
-rwsr-s--x. 1 oracle asmadmin 323649826 Sep 19 13:15 /u01/app/oracle/product/12.1.0/db_1/bin/oracle
Then tried the restore once again:
$<>  
RMAN> run {
2> set CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/u02/rmanbkp/phoenix/%F';
3> restore controlfile from autobackup ;
4> }

executing command: SET CONTROLFILE AUTOBACKUP FORMAT

Starting restore at 23-SEP-2016 10:46:38
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1140 device type=DISK

channel ORA_DISK_1: looking for AUTOBACKUP on day: 20160923
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20160922
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20160921
channel ORA_DISK_1: AUTOBACKUP found: /u02/rmanbkp/phoenix/c-1356565195-20160921-02
channel ORA_DISK_1: restoring control file from AUTOBACKUP /u02/rmanbkp/phoenix/c-1356565195-20160921-02
channel ORA_DISK_1: control file restore from AUTOBACKUP complete
output file name=+FRADG/PHOENIX/control01.ctl
output file name=+DATADG/PHOENIX/control02.ctl
Finished restore at 23-SEP-2016 10:46:45

RMAN> alter database mount ;
Review the physical structure
Take a peek at the physical structure of the database from the control file:
SQL><>  
SQL> select file#, name from v$datafile;

     FILE# NAME
---------- ------------------------------------------------------------
         1 +ORCLDG/PHOENIX/system01.dbf
         2 +ORCLDG/PHOENIX/DATAFILE/mhb.288.915336369
         3 +ORCLDG/PHOENIX/sysaux01.dbf
         4 +ORCLDG/PHOENIX/undotbs01.dbf
         5 +ORCLDG/PHOENIX/undotbs02.dbf
         6 +ORCLDG/PHOENIX/users01.dbf
         7 +ORCLDG/PHOENIX/DATAFILE/mhb_idx.296.915336373
         8 +ORCLDG/PHOENIX/DATAFILE/evt.278.915336345
         9 +ORCLDG/PHOENIX/DATAFILE/evt_idx.297.915336373
        10 +ORCLDG/PHOENIX/DATAFILE/sso.285.915336357
        11 +ORCLDG/PHOENIX/DATAFILE/sso_idx.298.915336375
        12 +ORCLDG/PHOENIX/DATAFILE/base.289.915336369
        13 +ORCLDG/PHOENIX/DATAFILE/base_idx.299.915336375
        14 +ORCLDG/PHOENIX/DATAFILE/pfk.290.915336371
        15 +ORCLDG/PHOENIX/DATAFILE/pfk_idx.300.915336375
        16 +ORCLDG/PHOENIX/DATAFILE/com.291.915336371
        17 +ORCLDG/PHOENIX/DATAFILE/com_idx.301.915336375
        18 +ORCLDG/PHOENIX/DATAFILE/ncms.292.915336371
        19 +ORCLDG/PHOENIX/DATAFILE/ncms_idx.302.915336375
        20 +ORCLDG/PHOENIX/DATAFILE/ana.286.915336359
        21 +ORCLDG/PHOENIX/DATAFILE/ana_idx.279.915336345
        22 +ORCLDG/PHOENIX/DATAFILE/mcms.274.915336345
        23 +ORCLDG/PHOENIX/DATAFILE/mcms_idx.280.915336345
        24 +ORCLDG/PHOENIX/DATAFILE/mtn.276.915336345
        25 +ORCLDG/PHOENIX/DATAFILE/mtn_idx.281.915336345
        26 +ORCLDG/PHOENIX/DATAFILE/dms.277.915336345
        27 +ORCLDG/PHOENIX/DATAFILE/dms_idx.303.915336375
        28 +ORCLDG/PHOENIX/DATAFILE/mcmsjms.293.915336371
        29 +ORCLDG/PHOENIX/DATAFILE/mcmsjms_idx.294.915336373
        30 +ORCLDG/PHOENIX/DATAFILE/mda.287.915336359
        31 +ORCLDG/PHOENIX/DATAFILE/mda_idx.295.915336373

31 rows selected.
SQL><>  
SQL> select group#, member from v$logfile;

GROUP# MEMBER
------ ------------------------------------------------------------
     2 +ORCLDG/PHOENIX/redo02.log
     1 +ORCLDG/PHOENIX/redo01.log
     3 +ORCLDG/PHOENIX/redo03.log
     4 +ORCLDG/PHOENIX/redo04.log
     7 +ORCLDG/PHOENIX/ONLINELOG/group_7.308.915337429
     7 +ARCHDG/PHOENIX/ONLINELOG/group_7.286.915337429
     8 +ORCLDG/PHOENIX/ONLINELOG/group_8.309.915337429
     8 +ARCHDG/PHOENIX/ONLINELOG/group_8.287.915337431
     9 +ORCLDG/PHOENIX/ONLINELOG/group_9.310.915337431
     9 +ARCHDG/PHOENIX/ONLINELOG/group_9.288.915337431
    10 +ORCLDG/PHOENIX/ONLINELOG/group_10.311.915337431
    10 +ARCHDG/PHOENIX/ONLINELOG/group_10.289.915337433
    11 +ORCLDG/PHOENIX/ONLINELOG/group_11.312.915337433
    11 +ARCHDG/PHOENIX/ONLINELOG/group_11.290.915337433
    12 +ORCLDG/PHOENIX/ONLINELOG/group_12.313.915337433
    12 +ARCHDG/PHOENIX/ONLINELOG/group_12.291.915337433
    13 +ORCLDG/PHOENIX/ONLINELOG/group_13.314.915337435
    13 +ARCHDG/PHOENIX/ONLINELOG/group_13.292.915337435
    14 +ORCLDG/PHOENIX/ONLINELOG/group_14.315.915337435
    14 +ARCHDG/PHOENIX/ONLINELOG/group_14.293.915337435
    15 +ORCLDG/PHOENIX/ONLINELOG/group_15.316.915337437
    15 +ARCHDG/PHOENIX/ONLINELOG/group_15.294.915337437
    16 +ORCLDG/PHOENIX/ONLINELOG/group_16.317.915337437
    16 +ARCHDG/PHOENIX/ONLINELOG/group_16.295.915337437
    17 +ORCLDG/PHOENIX/ONLINELOG/group_17.318.915337439
    17 +ARCHDG/PHOENIX/ONLINELOG/group_17.296.915337439
    18 +ORCLDG/PHOENIX/ONLINELOG/group_18.319.915337439
    18 +ARCHDG/PHOENIX/ONLINELOG/group_18.297.915337439

28 rows selected.
We will need to change the path of the redo just before opening the database later.
RMAN>
RMAN> crosscheck backup ;
RMAN> delete expired backup ;
Add the backup metadata to the controlfile
Check the backup available for restore:
RMAN><>  
RMAN> catalog start with '/u02/rmanbkp/phoenix/';

searching for all files that match the pattern /u02/rmanbkp/phoenix/

List of Files Unknown to the Database
=====================================
File Name: /u02/rmanbkp/phoenix/archivelog_1498_1.bak
File Name: /u02/rmanbkp/phoenix/backup.log
File Name: /u02/rmanbkp/phoenix/c-1356565195-20160921-00
File Name: /u02/rmanbkp/phoenix/c-1356565195-20160921-01
File Name: /u02/rmanbkp/phoenix/c-1356565195-20160921-02
File Name: /u02/rmanbkp/phoenix/controlfile_1501.bak
File Name: /u02/rmanbkp/phoenix/PHOENIX_controlfile_1500.bak
File Name: /u02/rmanbkp/phoenix/phoenix_1495_1.bak
File Name: /u02/rmanbkp/phoenix/phoenix_1496_1.bak

Do you really want to catalog the above files (enter YES or NO)? YES
cataloging files...
cataloging done

List of Cataloged Files
=======================
File Name: /u02/rmanbkp/phoenix/archivelog_1498_1.bak
File Name: /u02/rmanbkp/phoenix/c-1356565195-20160921-00
File Name: /u02/rmanbkp/phoenix/c-1356565195-20160921-01
File Name: /u02/rmanbkp/phoenix/c-1356565195-20160921-02
File Name: /u02/rmanbkp/phoenix/controlfile_1501.bak
File Name: /u02/rmanbkp/phoenix/PHOENIX_controlfile_1500.bak
File Name: /u02/rmanbkp/phoenix/phoenix_1495_1.bak
File Name: /u02/rmanbkp/phoenix/phoenix_1496_1.bak

List of Files Which Were Not Cataloged
=======================================
File Name: /u02/rmanbkp/phoenix/backup.log
  RMAN-07517: Reason: The file header is corrupted        /* this is fine as this is just a log output file from the RMAN job */

RMAN>
RMAN><>  
RMAN> crosscheck backup ;

using channel ORA_DISK_1
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/rmanbkp/phoenix/archivelog_1498_1.bak RECID=1233 STAMP=923310133
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/rmanbkp/phoenix/c-1356565195-20160921-00 RECID=1234 STAMP=923310134
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/rmanbkp/phoenix/c-1356565195-20160921-01 RECID=1235 STAMP=923310134
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/rmanbkp/phoenix/c-1356565195-20160921-02 RECID=1236 STAMP=923310134
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/rmanbkp/phoenix/controlfile_1501.bak RECID=1237 STAMP=923310135
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/rmanbkp/phoenix/PHOENIX_controlfile_1500.bak RECID=1238 STAMP=923310135
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/rmanbkp/phoenix/phoenix_1495_1.bak RECID=1239 STAMP=923310135
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/rmanbkp/phoenix/phoenix_1496_1.bak RECID=1240 STAMP=923310135
Crosschecked 8 objects
RMAN>
RMAN> list backup of archivelog all;

List of Backup Sets
===================


BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ --------------------
1230    167.31M    DISK        00:00:14     21-SEP-2016 18:02:01
        BP Key: 1233   Status: AVAILABLE  Compressed: YES  Tag: ARCHIVELOG_BKP_PHOENIX
        Piece Name: /u02/rmanbkp/phoenix/archivelog_1498_1.bak

  List of Archived Logs in backup set 1230
  Thrd Seq     Low SCN    Low Time             Next SCN   Next Time
  ---- ------- ---------- -------------------- ---------- ---------
  1    438     146540208  20-SEP-2016 18:01:42 146937497  21-SEP-2016 02:03:08
  1    439     146937497  21-SEP-2016 02:03:08 147458706  21-SEP-2016 13:09:32
  1    440     147458706  21-SEP-2016 13:09:32 147675465  21-SEP-2016 18:00:01
  1    441     147675465  21-SEP-2016 18:00:01 147675469  21-SEP-2016 18:00:01
  1    442     147675469  21-SEP-2016 18:00:01 147679360  21-SEP-2016 18:01:43
  2    344     146540223  20-SEP-2016 18:01:44 147452244  21-SEP-2016 13:00:14
  2    345     147452244  21-SEP-2016 13:00:14 147584613  21-SEP-2016 16:00:05
  2    346     147584613  21-SEP-2016 16:00:05 147675479  21-SEP-2016 18:00:02
  2    347     147675479  21-SEP-2016 18:00:02 147679372  21-SEP-2016 18:01:44
Restore and Recover
Last available sequence in the backup with lowest "Next SCN" (147679360) is 442. So, RMAN should be able to do the recovery until 442.

1    442     147675469  21-SEP-2016 18:00:01 147679360  21-SEP-2016 18:01:43
Note: If you want to restore the database until a specific SEQUENCE or SCN, please scroll down to see the syntax.
RMAN> <>  
RMAN> run {
allocate channel c1 device type disk;
set newname for datafile 1 to '+DATADG/PHOENIX/system01.dbf';
set newname for datafile 2 to '+DATADG/PHOENIX/DATAFILE/mhb.288.915336369';
set newname for datafile 3 to '+DATADG/PHOENIX/sysaux01.dbf';
set newname for datafile 4 to '+DATADG/PHOENIX/undotbs01.dbf';
set newname for datafile 5 to '+DATADG/PHOENIX/undotbs02.dbf';
set newname for datafile 6 to '+DATADG/PHOENIX/users01.dbf';
set newname for datafile 7 to '+DATADG/PHOENIX/DATAFILE/mhb_idx.296.915336373';
set newname for datafile 8 to '+DATADG/PHOENIX/DATAFILE/evt.278.915336345';
set newname for datafile 9 to '+DATADG/PHOENIX/DATAFILE/evt_idx.297.915336373';
set newname for datafile 10 to '+DATADG/PHOENIX/DATAFILE/sso.285.915336357';
set newname for datafile 11 to '+DATADG/PHOENIX/DATAFILE/sso_idx.298.915336375';
set newname for datafile 12 to '+DATADG/PHOENIX/DATAFILE/base.289.915336369';
set newname for datafile 13 to '+DATADG/PHOENIX/DATAFILE/base_idx.299.915336375';
set newname for datafile 14 to '+DATADG/PHOENIX/DATAFILE/pfk.290.915336371';
set newname for datafile 15 to '+DATADG/PHOENIX/DATAFILE/pfk_idx.300.915336375';
set newname for datafile 16 to '+DATADG/PHOENIX/DATAFILE/com.291.915336371';
set newname for datafile 17 to '+DATADG/PHOENIX/DATAFILE/com_idx.301.915336375';
set newname for datafile 18 to '+DATADG/PHOENIX/DATAFILE/ncms.292.915336371';
set newname for datafile 19 to '+DATADG/PHOENIX/DATAFILE/ncms_idx.302.915336375';
set newname for datafile 20 to '+DATADG/PHOENIX/DATAFILE/ana.286.915336359';
set newname for datafile 21 to '+DATADG/PHOENIX/DATAFILE/ana_idx.279.915336345';
set newname for datafile 22 to '+DATADG/PHOENIX/DATAFILE/mcms.274.915336345';
set newname for datafile 23 to '+DATADG/PHOENIX/DATAFILE/mcms_idx.280.915336345';
set newname for datafile 24 to '+DATADG/PHOENIX/DATAFILE/mtn.276.915336345';
set newname for datafile 25 to '+DATADG/PHOENIX/DATAFILE/mtn_idx.281.915336345';
set newname for datafile 26 to '+DATADG/PHOENIX/DATAFILE/dms.277.915336345';
set newname for datafile 27 to '+DATADG/PHOENIX/DATAFILE/dms_idx.303.915336375';
set newname for datafile 28 to '+DATADG/PHOENIX/DATAFILE/mcmsjms.293.915336371';
set newname for datafile 29 to '+DATADG/PHOENIX/DATAFILE/mcmsjms_idx.294.915336373';
set newname for datafile 30 to '+DATADG/PHOENIX/DATAFILE/mda.287.915336359';
set newname for datafile 31 to '+DATADG/PHOENIX/DATAFILE/mda_idx.295.915336373';
restore database;
switch datafile all;
recover database;
}
		 
released channel: ORA_DISK_1
allocated channel: c1
channel c1: SID=17 device type=DISK

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting restore at 23-SEP-2016 11:10:14

channel c1: starting datafile backup set restore
channel c1: specifying datafile(s) to restore from backup set
channel c1: restoring datafile 00001 to +DATADG/PHOENIX/system01.dbf
channel c1: restoring datafile 00002 to +DATADG/PHOENIX/DATAFILE/mhb.288.915336369
channel c1: restoring datafile 00003 to +DATADG/PHOENIX/sysaux01.dbf
channel c1: restoring datafile 00004 to +DATADG/PHOENIX/undotbs01.dbf
channel c1: restoring datafile 00005 to +DATADG/PHOENIX/undotbs02.dbf
channel c1: restoring datafile 00006 to +DATADG/PHOENIX/users01.dbf
channel c1: restoring datafile 00007 to +DATADG/PHOENIX/DATAFILE/mhb_idx.296.915336373
channel c1: restoring datafile 00008 to +DATADG/PHOENIX/DATAFILE/evt.278.915336345
channel c1: restoring datafile 00009 to +DATADG/PHOENIX/DATAFILE/evt_idx.297.915336373
channel c1: restoring datafile 00010 to +DATADG/PHOENIX/DATAFILE/sso.285.915336357
channel c1: restoring datafile 00011 to +DATADG/PHOENIX/DATAFILE/sso_idx.298.915336375
channel c1: restoring datafile 00012 to +DATADG/PHOENIX/DATAFILE/base.289.915336369
channel c1: restoring datafile 00013 to +DATADG/PHOENIX/DATAFILE/base_idx.299.915336375
channel c1: restoring datafile 00014 to +DATADG/PHOENIX/DATAFILE/pfk.290.915336371
channel c1: restoring datafile 00015 to +DATADG/PHOENIX/DATAFILE/pfk_idx.300.915336375
channel c1: restoring datafile 00016 to +DATADG/PHOENIX/DATAFILE/com.291.915336371
channel c1: restoring datafile 00017 to +DATADG/PHOENIX/DATAFILE/com_idx.301.915336375
channel c1: restoring datafile 00018 to +DATADG/PHOENIX/DATAFILE/ncms.292.915336371
channel c1: restoring datafile 00019 to +DATADG/PHOENIX/DATAFILE/ncms_idx.302.915336375
channel c1: restoring datafile 00020 to +DATADG/PHOENIX/DATAFILE/ana.286.915336359
channel c1: restoring datafile 00021 to +DATADG/PHOENIX/DATAFILE/ana_idx.279.915336345
channel c1: restoring datafile 00022 to +DATADG/PHOENIX/DATAFILE/mcms.274.915336345
channel c1: restoring datafile 00023 to +DATADG/PHOENIX/DATAFILE/mcms_idx.280.915336345
channel c1: restoring datafile 00024 to +DATADG/PHOENIX/DATAFILE/mtn.276.915336345
channel c1: restoring datafile 00025 to +DATADG/PHOENIX/DATAFILE/mtn_idx.281.915336345
channel c1: restoring datafile 00026 to +DATADG/PHOENIX/DATAFILE/dms.277.915336345
channel c1: restoring datafile 00027 to +DATADG/PHOENIX/DATAFILE/dms_idx.303.915336375
channel c1: restoring datafile 00028 to +DATADG/PHOENIX/DATAFILE/mcmsjms.293.915336371
channel c1: restoring datafile 00029 to +DATADG/PHOENIX/DATAFILE/mcmsjms_idx.294.915336373
channel c1: restoring datafile 00030 to +DATADG/PHOENIX/DATAFILE/mda.287.915336359
channel c1: restoring datafile 00031 to +DATADG/PHOENIX/DATAFILE/mda_idx.295.915336373
channel c1: reading from backup piece /u02/rmanbkp/phoenix/phoenix_1495_1.bak
channel c1: piece handle=/u02/rmanbkp/phoenix/phoenix_1495_1.bak tag=PHOENIX_FULL_BACKUP
channel c1: restored backup piece 1
channel c1: restore complete, elapsed time: 00:07:56
Finished restore at 23-SEP-2016 11:18:11

datafile 1 switched to datafile copy
input datafile copy RECID=32 STAMP=923311093 file name=+DATADG/PHOENIX/system01.dbf
datafile 2 switched to datafile copy
input datafile copy RECID=33 STAMP=923311093 file name=+DATADG/PHOENIX/DATAFILE/mhb.272.923310743
datafile 3 switched to datafile copy
input datafile copy RECID=34 STAMP=923311093 file name=+DATADG/PHOENIX/sysaux01.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=35 STAMP=923311093 file name=+DATADG/PHOENIX/undotbs01.dbf
datafile 5 switched to datafile copy
input datafile copy RECID=36 STAMP=923311093 file name=+DATADG/PHOENIX/undotbs02.dbf
datafile 6 switched to datafile copy
input datafile copy RECID=37 STAMP=923311096 file name=+DATADG/PHOENIX/users01.dbf
datafile 7 switched to datafile copy
input datafile copy RECID=38 STAMP=923311098 file name=+DATADG/PHOENIX/DATAFILE/mhb_idx.280.923310777
datafile 8 switched to datafile copy
input datafile copy RECID=39 STAMP=923311099 file name=+DATADG/PHOENIX/DATAFILE/evt.262.923310617
datafile 9 switched to datafile copy
input datafile copy RECID=40 STAMP=923311099 file name=+DATADG/PHOENIX/DATAFILE/evt_idx.281.923310781
datafile 10 switched to datafile copy
input datafile copy RECID=41 STAMP=923311099 file name=+DATADG/PHOENIX/DATAFILE/sso.269.923310695
datafile 11 switched to datafile copy
input datafile copy RECID=42 STAMP=923311100 file name=+DATADG/PHOENIX/DATAFILE/sso_idx.282.923310787
datafile 12 switched to datafile copy
input datafile copy RECID=43 STAMP=923311100 file name=+DATADG/PHOENIX/DATAFILE/base.273.923310747
datafile 13 switched to datafile copy
input datafile copy RECID=44 STAMP=923311100 file name=+DATADG/PHOENIX/DATAFILE/base_idx.283.923310787
datafile 14 switched to datafile copy
input datafile copy RECID=45 STAMP=923311100 file name=+DATADG/PHOENIX/DATAFILE/pfk.274.923310751
datafile 15 switched to datafile copy
input datafile copy RECID=46 STAMP=923311100 file name=+DATADG/PHOENIX/DATAFILE/pfk_idx.284.923310789
datafile 16 switched to datafile copy
input datafile copy RECID=47 STAMP=923311100 file name=+DATADG/PHOENIX/DATAFILE/com.275.923310757
datafile 17 switched to datafile copy
input datafile copy RECID=48 STAMP=923311101 file name=+DATADG/PHOENIX/DATAFILE/com_idx.285.923310793
datafile 18 switched to datafile copy
input datafile copy RECID=49 STAMP=923311101 file name=+DATADG/PHOENIX/DATAFILE/ncms.276.923310761
datafile 19 switched to datafile copy
input datafile copy RECID=50 STAMP=923311101 file name=+DATADG/PHOENIX/DATAFILE/ncms_idx.286.923310797
datafile 20 switched to datafile copy
input datafile copy RECID=51 STAMP=923311101 file name=+DATADG/PHOENIX/DATAFILE/ana.270.923310701
datafile 21 switched to datafile copy
input datafile copy RECID=52 STAMP=923311101 file name=+DATADG/PHOENIX/DATAFILE/ana_idx.263.923310617
datafile 22 switched to datafile copy
input datafile copy RECID=53 STAMP=923311101 file name=+DATADG/PHOENIX/DATAFILE/mcms.258.923310615
datafile 23 switched to datafile copy
input datafile copy RECID=54 STAMP=923311101 file name=+DATADG/PHOENIX/DATAFILE/mcms_idx.264.923310617
datafile 24 switched to datafile copy
input datafile copy RECID=55 STAMP=923311102 file name=+DATADG/PHOENIX/DATAFILE/mtn.260.923310617
datafile 25 switched to datafile copy
input datafile copy RECID=56 STAMP=923311102 file name=+DATADG/PHOENIX/DATAFILE/mtn_idx.265.923310629
datafile 26 switched to datafile copy
input datafile copy RECID=57 STAMP=923311102 file name=+DATADG/PHOENIX/DATAFILE/dms.261.923310617
datafile 27 switched to datafile copy
input datafile copy RECID=58 STAMP=923311102 file name=+DATADG/PHOENIX/DATAFILE/dms_idx.287.923310799
datafile 28 switched to datafile copy
input datafile copy RECID=59 STAMP=923311102 file name=+DATADG/PHOENIX/DATAFILE/mcmsjms.277.923310765
datafile 29 switched to datafile copy
input datafile copy RECID=60 STAMP=923311102 file name=+DATADG/PHOENIX/DATAFILE/mcmsjms_idx.278.923310769
datafile 30 switched to datafile copy
input datafile copy RECID=61 STAMP=923311103 file name=+DATADG/PHOENIX/DATAFILE/mda.271.923310711
datafile 31 switched to datafile copy
input datafile copy RECID=62 STAMP=923311103 file name=+DATADG/PHOENIX/DATAFILE/mda_idx.279.923310773

Starting recover at 23-SEP-2016 11:18:24

starting media recovery
media recovery failed
released channel: c1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 09/23/2016 11:18:27
ORA-00283: recovery session canceled due to errors
RMAN-11003: failure during parse/execution of SQL statement: alter database recover if needed
 start until cancel using backup controlfile
ORA-00283: recovery session canceled due to errors
ORA-38760: This database instance failed to turn on flashback database

RMAN>
Retried the recovery after turning the flashback off.
SQL>
SQL> select flashback_on from v$database ;

FLASHBACK_ON
------------------
YES
$
SQL> alter database flashback off;

Database altered.

SQL> shut immediate
$
[oracle@olinux7201 dbs]$ rman target /

Recovery Manager: Release 12.1.0.2.0 - Production on Fri Sep 23 11:34:52 2016

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

connected to target database (not started)

RMAN> startup mount;

Oracle instance started
database mounted

Total System Global Area    2147483648 bytes

Fixed Size                     2926472 bytes
Variable Size               1795164280 bytes
Database Buffers             335544320 bytes
Redo Buffers                  13848576 bytes

RMAN>
RMAN><>  
RMAN> run {
allocate channel c1 device type disk;
set newname for datafile 1 to '+DATADG/PHOENIX/system01.dbf';
set newname for datafile 2 to '+DATADG/PHOENIX/DATAFILE/mhb.288.915336369';
set newname for datafile 3 to '+DATADG/PHOENIX/sysaux01.dbf';
set newname for datafile 4 to '+DATADG/PHOENIX/undotbs01.dbf';
set newname for datafile 5 to '+DATADG/PHOENIX/undotbs02.dbf';
set newname for datafile 6 to '+DATADG/PHOENIX/users01.dbf';
set newname for datafile 7 to '+DATADG/PHOENIX/DATAFILE/mhb_idx.296.915336373';
set newname for datafile 8 to '+DATADG/PHOENIX/DATAFILE/evt.278.915336345';
set newname for datafile 9 to '+DATADG/PHOENIX/DATAFILE/evt_idx.297.915336373';
set newname for datafile 10 to '+DATADG/PHOENIX/DATAFILE/sso.285.915336357';
set newname for datafile 11 to '+DATADG/PHOENIX/DATAFILE/sso_idx.298.915336375';
set newname for datafile 12 to '+DATADG/PHOENIX/DATAFILE/base.289.915336369';
set newname for datafile 13 to '+DATADG/PHOENIX/DATAFILE/base_idx.299.915336375';
set newname for datafile 14 to '+DATADG/PHOENIX/DATAFILE/pfk.290.915336371';
set newname for datafile 15 to '+DATADG/PHOENIX/DATAFILE/pfk_idx.300.915336375';
set newname for datafile 16 to '+DATADG/PHOENIX/DATAFILE/com.291.915336371';
set newname for datafile 17 to '+DATADG/PHOENIX/DATAFILE/com_idx.301.915336375';
set newname for datafile 18 to '+DATADG/PHOENIX/DATAFILE/ncms.292.915336371';
set newname for datafile 19 to '+DATADG/PHOENIX/DATAFILE/ncms_idx.302.915336375';
set newname for datafile 20 to '+DATADG/PHOENIX/DATAFILE/ana.286.915336359';
set newname for datafile 21 to '+DATADG/PHOENIX/DATAFILE/ana_idx.279.915336345';
set newname for datafile 22 to '+DATADG/PHOENIX/DATAFILE/mcms.274.915336345';
set newname for datafile 23 to '+DATADG/PHOENIX/DATAFILE/mcms_idx.280.915336345';
set newname for datafile 24 to '+DATADG/PHOENIX/DATAFILE/mtn.276.915336345';
set newname for datafile 25 to '+DATADG/PHOENIX/DATAFILE/mtn_idx.281.915336345';
set newname for datafile 26 to '+DATADG/PHOENIX/DATAFILE/dms.277.915336345';
set newname for datafile 27 to '+DATADG/PHOENIX/DATAFILE/dms_idx.303.915336375';
set newname for datafile 28 to '+DATADG/PHOENIX/DATAFILE/mcmsjms.293.915336371';
set newname for datafile 29 to '+DATADG/PHOENIX/DATAFILE/mcmsjms_idx.294.915336373';
set newname for datafile 30 to '+DATADG/PHOENIX/DATAFILE/mda.287.915336359';
set newname for datafile 31 to '+DATADG/PHOENIX/DATAFILE/mda_idx.295.915336373';
restore database;
switch datafile all;
recover database;
}

using target database control file instead of recovery catalog
allocated channel: c1
channel c1: SID=18 device type=DISK

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting restore at 23-SEP-2016 11:35:58

skipping datafile 1; already restored to file +DATADG/PHOENIX/system01.dbf
skipping datafile 3; already restored to file +DATADG/PHOENIX/sysaux01.dbf
skipping datafile 4; already restored to file +DATADG/PHOENIX/undotbs01.dbf
skipping datafile 5; already restored to file +DATADG/PHOENIX/undotbs02.dbf
skipping datafile 6; already restored to file +DATADG/PHOENIX/users01.dbf
channel c1: starting datafile backup set restore
channel c1: specifying datafile(s) to restore from backup set
channel c1: restoring datafile 00002 to +DATADG/PHOENIX/DATAFILE/mhb.288.915336369
channel c1: restoring datafile 00007 to +DATADG/PHOENIX/DATAFILE/mhb_idx.296.915336373
channel c1: restoring datafile 00008 to +DATADG/PHOENIX/DATAFILE/evt.278.915336345
channel c1: restoring datafile 00009 to +DATADG/PHOENIX/DATAFILE/evt_idx.297.915336373
channel c1: restoring datafile 00010 to +DATADG/PHOENIX/DATAFILE/sso.285.915336357
channel c1: restoring datafile 00011 to +DATADG/PHOENIX/DATAFILE/sso_idx.298.915336375
channel c1: restoring datafile 00012 to +DATADG/PHOENIX/DATAFILE/base.289.915336369
channel c1: restoring datafile 00013 to +DATADG/PHOENIX/DATAFILE/base_idx.299.915336375
channel c1: restoring datafile 00014 to +DATADG/PHOENIX/DATAFILE/pfk.290.915336371
channel c1: restoring datafile 00015 to +DATADG/PHOENIX/DATAFILE/pfk_idx.300.915336375
channel c1: restoring datafile 00016 to +DATADG/PHOENIX/DATAFILE/com.291.915336371
channel c1: restoring datafile 00017 to +DATADG/PHOENIX/DATAFILE/com_idx.301.915336375
channel c1: restoring datafile 00018 to +DATADG/PHOENIX/DATAFILE/ncms.292.915336371
channel c1: restoring datafile 00019 to +DATADG/PHOENIX/DATAFILE/ncms_idx.302.915336375
channel c1: restoring datafile 00020 to +DATADG/PHOENIX/DATAFILE/ana.286.915336359
channel c1: restoring datafile 00021 to +DATADG/PHOENIX/DATAFILE/ana_idx.279.915336345
channel c1: restoring datafile 00022 to +DATADG/PHOENIX/DATAFILE/mcms.274.915336345
channel c1: restoring datafile 00023 to +DATADG/PHOENIX/DATAFILE/mcms_idx.280.915336345
channel c1: restoring datafile 00024 to +DATADG/PHOENIX/DATAFILE/mtn.276.915336345
channel c1: restoring datafile 00025 to +DATADG/PHOENIX/DATAFILE/mtn_idx.281.915336345
channel c1: restoring datafile 00026 to +DATADG/PHOENIX/DATAFILE/dms.277.915336345
channel c1: restoring datafile 00027 to +DATADG/PHOENIX/DATAFILE/dms_idx.303.915336375
channel c1: restoring datafile 00028 to +DATADG/PHOENIX/DATAFILE/mcmsjms.293.915336371
channel c1: restoring datafile 00029 to +DATADG/PHOENIX/DATAFILE/mcmsjms_idx.294.915336373
channel c1: restoring datafile 00030 to +DATADG/PHOENIX/DATAFILE/mda.287.915336359
channel c1: restoring datafile 00031 to +DATADG/PHOENIX/DATAFILE/mda_idx.295.915336373
channel c1: reading from backup piece /u02/rmanbkp/phoenix/phoenix_1495_1.bak
channel c1: piece handle=/u02/rmanbkp/phoenix/phoenix_1495_1.bak tag=PHOENIX_FULL_BACKUP
channel c1: restored backup piece 1
channel c1: restore complete, elapsed time: 00:04:45
Finished restore at 23-SEP-2016 11:40:45

datafile 2 switched to datafile copy
input datafile copy RECID=89 STAMP=923312447 file name=+DATADG/PHOENIX/DATAFILE/mhb.298.923312253
datafile 7 switched to datafile copy
input datafile copy RECID=90 STAMP=923312447 file name=+DATADG/PHOENIX/DATAFILE/mhb_idx.306.923312287
datafile 8 switched to datafile copy
input datafile copy RECID=91 STAMP=923312448 file name=+DATADG/PHOENIX/DATAFILE/evt.291.923312161
datafile 9 switched to datafile copy
input datafile copy RECID=92 STAMP=923312448 file name=+DATADG/PHOENIX/DATAFILE/evt_idx.307.923312297
datafile 10 switched to datafile copy
input datafile copy RECID=93 STAMP=923312448 file name=+DATADG/PHOENIX/DATAFILE/sso.295.923312211
datafile 11 switched to datafile copy
input datafile copy RECID=94 STAMP=923312448 file name=+DATADG/PHOENIX/DATAFILE/sso_idx.308.923312301
datafile 12 switched to datafile copy
input datafile copy RECID=95 STAMP=923312449 file name=+DATADG/PHOENIX/DATAFILE/base.299.923312259
datafile 13 switched to datafile copy
input datafile copy RECID=96 STAMP=923312449 file name=+DATADG/PHOENIX/DATAFILE/base_idx.309.923312303
datafile 14 switched to datafile copy
input datafile copy RECID=97 STAMP=923312449 file name=+DATADG/PHOENIX/DATAFILE/pfk.300.923312263
datafile 15 switched to datafile copy
input datafile copy RECID=98 STAMP=923312449 file name=+DATADG/PHOENIX/DATAFILE/pfk_idx.310.923312305
datafile 16 switched to datafile copy
input datafile copy RECID=99 STAMP=923312449 file name=+DATADG/PHOENIX/DATAFILE/com.301.923312269
datafile 17 switched to datafile copy
input datafile copy RECID=100 STAMP=923312449 file name=+DATADG/PHOENIX/DATAFILE/com_idx.311.923312309
datafile 18 switched to datafile copy
input datafile copy RECID=101 STAMP=923312449 file name=+DATADG/PHOENIX/DATAFILE/ncms.302.923312271
datafile 19 switched to datafile copy
input datafile copy RECID=102 STAMP=923312450 file name=+DATADG/PHOENIX/DATAFILE/ncms_idx.312.923312311
datafile 20 switched to datafile copy
input datafile copy RECID=103 STAMP=923312450 file name=+DATADG/PHOENIX/DATAFILE/ana.296.923312219
datafile 21 switched to datafile copy
input datafile copy RECID=104 STAMP=923312450 file name=+DATADG/PHOENIX/DATAFILE/ana_idx.292.923312161
datafile 22 switched to datafile copy
input datafile copy RECID=105 STAMP=923312450 file name=+DATADG/PHOENIX/DATAFILE/mcms.288.923312161
datafile 23 switched to datafile copy
input datafile copy RECID=106 STAMP=923312450 file name=+DATADG/PHOENIX/DATAFILE/mcms_idx.293.923312161
datafile 24 switched to datafile copy
input datafile copy RECID=107 STAMP=923312450 file name=+DATADG/PHOENIX/DATAFILE/mtn.289.923312161
datafile 25 switched to datafile copy
input datafile copy RECID=108 STAMP=923312450 file name=+DATADG/PHOENIX/DATAFILE/mtn_idx.294.923312169
datafile 26 switched to datafile copy
input datafile copy RECID=109 STAMP=923312451 file name=+DATADG/PHOENIX/DATAFILE/dms.290.923312161
datafile 27 switched to datafile copy
input datafile copy RECID=110 STAMP=923312451 file name=+DATADG/PHOENIX/DATAFILE/dms_idx.313.923312313
datafile 28 switched to datafile copy
input datafile copy RECID=111 STAMP=923312451 file name=+DATADG/PHOENIX/DATAFILE/mcmsjms.303.923312275
datafile 29 switched to datafile copy
input datafile copy RECID=112 STAMP=923312451 file name=+DATADG/PHOENIX/DATAFILE/mcmsjms_idx.304.923312279
datafile 30 switched to datafile copy
input datafile copy RECID=113 STAMP=923312452 file name=+DATADG/PHOENIX/DATAFILE/mda.297.923312223
datafile 31 switched to datafile copy
input datafile copy RECID=114 STAMP=923312453 file name=+DATADG/PHOENIX/DATAFILE/mda_idx.305.923312281

Starting recover at 23-SEP-2016 11:41:01

starting media recovery

channel c1: starting archived log restore to default destination
channel c1: restoring archived log
archived log thread=1 sequence=442
channel c1: restoring archived log
archived log thread=2 sequence=347
channel c1: reading from backup piece /u02/rmanbkp/phoenix/archivelog_1498_1.bak
channel c1: piece handle=/u02/rmanbkp/phoenix/archivelog_1498_1.bak tag=ARCHIVELOG_BKP_PHOENIX
channel c1: restored backup piece 1
channel c1: restore complete, elapsed time: 00:00:07
archived log file name=/u01/app/oracle/product/12.1.0/db_1/arch/1_442_915359514.arch thread=1 sequence=442
archived log file name=/u01/app/oracle/product/12.1.0/db_1/arch/2_347_915359514.arch thread=2 sequence=347
unable to find archived log
archived log thread=1 sequence=443
released channel: c1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 09/23/2016 11:41:24
RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 443 and starting SCN of 147679360

RMAN>
The last error is fine as RMAN is looking for sequence 443 which we do not have as part of the backup.
RMAN>
RMAN> alter database open resetlogs ;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of sql statement command at 09/23/2016 11:48:57
ORA-00349: failure obtaining block size for '+ORCLDG/PHOENIX/redo01.log'
ORA-15001: diskgroup "ORCLDG" does not exist or is not mounted
ORA-15001: diskgroup "ORCLDG" does not exist or is not mounted
ORA-15001: diskgroup "ORCLDG" does not exist or is not mounted

RMAN>
As mentioned earlier, we now need to change the path of the redo log file.
$<>  
[oracle@olinux7201 dbs]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Fri Sep 23 11:56:39 2016

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


Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Advanced Analytics
and Real Application Testing options

SQL> alter database rename file '+ORCLDG/PHOENIX/redo01.log' to '+DATADG/PHOENIX/redo01.log';
Database altered.

SQL> alter database rename file '+ORCLDG/PHOENIX/redo02.log' to '+DATADG/PHOENIX/redo02.log';
Database altered.

SQL> alter database rename file '+ORCLDG/PHOENIX/redo03.log' to '+DATADG/PHOENIX/redo03.log';
Database altered.

SQL> alter database rename file '+ORCLDG/PHOENIX/redo04.log' to '+DATADG/PHOENIX/redo04.log';
Database altered.
RMAN>
RMAN> alter database open resetlogs ;

using target database control file instead of recovery catalog
Statement processed

RMAN>
SQL>
SQL> select name, status from v$database, v$instance ;

NAME      STATUS
--------- ------------
PHOENIX     OPEN

SQL>
Moving the SPFILE from to ASM
$
[oracle@olinux7201 dbs]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Thu Sep 22 12:56:17 2016

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


Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Advanced Analytics
and Real Application Testing options

SQL> shut immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>
$
[oracle@olinux7201 dbs]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Fri Sep 23 12:05:23 2016

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

Connected to an idle instance.

SQL> startup pfile=/u01/app/oracle/product/12.1.0/db_1/dbs/initPHOENIX.ora
ORACLE instance started.

Total System Global Area 2147483648 bytes
Fixed Size                  2926472 bytes
Variable Size            1795164280 bytes
Database Buffers          335544320 bytes
Redo Buffers               13848576 bytes
Database mounted.
Database opened.
SQL> create spfile='+FRADG' from pfile ;

File created.

SQL> shut immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> quit
$
[grid@olinux7201 ~]$ asmcmd -p
ASMCMD [+] > ls -l +FRADG/PHOENIX/PARAMETERFILE/*
Type           Redund  Striped  Time             Sys  Name
PARAMETERFILE  UNPROT  COARSE   SEP 23 12:00:00  Y    spfile.257.923313971
$<>  
[oracle@olinux7201 dbs]$ echo "spfile='+FRADG/TRAINDB/PARAMETERFILE/spfile.257.923313971'" > initPHOENIX.ora
$
SQL> show parameter spfile

NAME                       TYPE                      VALUE
-------------------------- ------------------------- ------------------------------
spfile                     string                    +FRADG/TRAINDB/PARAMETERFILE/s
                                                     pfile.256.923230851
Add database to HAS
$
[oracle@olinux7201 dbs]$ srvctl add database -d PHOENIX -o /u01/app/oracle/product/12.1.0/db_1
[oracle@olinux7201 dbs]$ srvctl start database -d PHOENIX
$
[oracle@olinux7201 dbs]$ ps -ef | grep pmon
grid      2496     1  0 09:37 ?        00:00:00 asm_pmon_+ASM
oracle    8932     1  0 12:13 ?        00:00:00 ora_pmon_PHOENIX
oracle    9128  3370  0 12:13 pts/0    00:00:00 grep --color=auto pmon
[oracle@olinux7201 dbs]$
$<>  
[grid@olinux7201 ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATADG.dg
               ONLINE  ONLINE       olinux7201               STABLE
ora.FRADG.dg
               ONLINE  ONLINE       olinux7201               STABLE
ora.LISTENER.lsnr
               ONLINE  ONLINE       olinux7201               STABLE
ora.OCRDG.dg
               ONLINE  ONLINE       olinux7201               STABLE
ora.asm
               ONLINE  ONLINE       olinux7201               Started,STABLE
ora.ons
               OFFLINE OFFLINE      olinux7201               STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd
      1        ONLINE  ONLINE       olinux7201               STABLE
ora.diskmon
      1        OFFLINE OFFLINE                               STABLE
ora.evmd
      1        ONLINE  ONLINE       olinux7201               STABLE
ora.phoenix.db
      1        ONLINE  ONLINE       olinux7201               Open,STABLE
--------------------------------------------------------------------------------
[grid@olinux7201 ~]$
Another scenario (UNTIL SCN)
$<>  
RMAN> run {
allocate channel c1 device type disk;
set newname for datafile 1 to '+DATADG/PHOENIX/system01.dbf';
set newname for datafile 2 to '+DATADG/PHOENIX/DATAFILE/mhb.288.915336369';
set newname for datafile 3 to '+DATADG/PHOENIX/sysaux01.dbf';
set newname for datafile 4 to '+DATADG/PHOENIX/undotbs01.dbf';
set newname for datafile 5 to '+DATADG/PHOENIX/undotbs02.dbf';
set newname for datafile 6 to '+DATADG/PHOENIX/users01.dbf';
set newname for datafile 7 to '+DATADG/PHOENIX/DATAFILE/mhb_idx.296.915336373';
set newname for datafile 8 to '+DATADG/PHOENIX/DATAFILE/evt.278.915336345';
set newname for datafile 9 to '+DATADG/PHOENIX/DATAFILE/evt_idx.297.915336373';
set newname for datafile 10 to '+DATADG/PHOENIX/DATAFILE/sso.285.915336357';
set newname for datafile 11 to '+DATADG/PHOENIX/DATAFILE/sso_idx.298.915336375';
set newname for datafile 12 to '+DATADG/PHOENIX/DATAFILE/base.289.915336369';
set newname for datafile 13 to '+DATADG/PHOENIX/DATAFILE/base_idx.299.915336375';
set newname for datafile 14 to '+DATADG/PHOENIX/DATAFILE/pfk.290.915336371';
set newname for datafile 15 to '+DATADG/PHOENIX/DATAFILE/pfk_idx.300.915336375';
set newname for datafile 16 to '+DATADG/PHOENIX/DATAFILE/com.291.915336371';
set newname for datafile 17 to '+DATADG/PHOENIX/DATAFILE/com_idx.301.915336375';
set newname for datafile 18 to '+DATADG/PHOENIX/DATAFILE/ncms.292.915336371';
set newname for datafile 19 to '+DATADG/PHOENIX/DATAFILE/ncms_idx.302.915336375';
set newname for datafile 20 to '+DATADG/PHOENIX/DATAFILE/ana.286.915336359';
set newname for datafile 21 to '+DATADG/PHOENIX/DATAFILE/ana_idx.279.915336345';
set newname for datafile 22 to '+DATADG/PHOENIX/DATAFILE/mcms.274.915336345';
set newname for datafile 23 to '+DATADG/PHOENIX/DATAFILE/mcms_idx.280.915336345';
set newname for datafile 24 to '+DATADG/PHOENIX/DATAFILE/mtn.276.915336345';
set newname for datafile 25 to '+DATADG/PHOENIX/DATAFILE/mtn_idx.281.915336345';
set newname for datafile 26 to '+DATADG/PHOENIX/DATAFILE/dms.277.915336345';
set newname for datafile 27 to '+DATADG/PHOENIX/DATAFILE/dms_idx.303.915336375';
set newname for datafile 28 to '+DATADG/PHOENIX/DATAFILE/mcmsjms.293.915336371';
set newname for datafile 29 to '+DATADG/PHOENIX/DATAFILE/mcmsjms_idx.294.915336373';
set newname for datafile 30 to '+DATADG/PHOENIX/DATAFILE/mda.287.915336359';
set newname for datafile 31 to '+DATADG/PHOENIX/DATAFILE/mda_idx.295.915336373';
restore database;
switch datafile all;
recover database until scn 147679360;
}

released channel: ORA_DISK_1
allocated channel: c1
channel c1: SID=18 device type=DISK

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting restore at 23-SEP-2016 14:09:39

channel c1: starting datafile backup set restore
channel c1: specifying datafile(s) to restore from backup set
channel c1: restoring datafile 00001 to +DATADG/PHOENIX/system01.dbf
channel c1: restoring datafile 00002 to +DATADG/PHOENIX/DATAFILE/mhb.288.915336369
channel c1: restoring datafile 00003 to +DATADG/PHOENIX/sysaux01.dbf
channel c1: restoring datafile 00004 to +DATADG/PHOENIX/undotbs01.dbf
channel c1: restoring datafile 00005 to +DATADG/PHOENIX/undotbs02.dbf
channel c1: restoring datafile 00006 to +DATADG/PHOENIX/users01.dbf
channel c1: restoring datafile 00007 to +DATADG/PHOENIX/DATAFILE/mhb_idx.296.915336373
channel c1: restoring datafile 00008 to +DATADG/PHOENIX/DATAFILE/evt.278.915336345
channel c1: restoring datafile 00009 to +DATADG/PHOENIX/DATAFILE/evt_idx.297.915336373
channel c1: restoring datafile 00010 to +DATADG/PHOENIX/DATAFILE/sso.285.915336357
channel c1: restoring datafile 00011 to +DATADG/PHOENIX/DATAFILE/sso_idx.298.915336375
channel c1: restoring datafile 00012 to +DATADG/PHOENIX/DATAFILE/base.289.915336369
channel c1: restoring datafile 00013 to +DATADG/PHOENIX/DATAFILE/base_idx.299.915336375
channel c1: restoring datafile 00014 to +DATADG/PHOENIX/DATAFILE/pfk.290.915336371
channel c1: restoring datafile 00015 to +DATADG/PHOENIX/DATAFILE/pfk_idx.300.915336375
channel c1: restoring datafile 00016 to +DATADG/PHOENIX/DATAFILE/com.291.915336371
channel c1: restoring datafile 00017 to +DATADG/PHOENIX/DATAFILE/com_idx.301.915336375
channel c1: restoring datafile 00018 to +DATADG/PHOENIX/DATAFILE/ncms.292.915336371
channel c1: restoring datafile 00019 to +DATADG/PHOENIX/DATAFILE/ncms_idx.302.915336375
channel c1: restoring datafile 00020 to +DATADG/PHOENIX/DATAFILE/ana.286.915336359
channel c1: restoring datafile 00021 to +DATADG/PHOENIX/DATAFILE/ana_idx.279.915336345
channel c1: restoring datafile 00022 to +DATADG/PHOENIX/DATAFILE/mcms.274.915336345
channel c1: restoring datafile 00023 to +DATADG/PHOENIX/DATAFILE/mcms_idx.280.915336345
channel c1: restoring datafile 00024 to +DATADG/PHOENIX/DATAFILE/mtn.276.915336345
channel c1: restoring datafile 00025 to +DATADG/PHOENIX/DATAFILE/mtn_idx.281.915336345
channel c1: restoring datafile 00026 to +DATADG/PHOENIX/DATAFILE/dms.277.915336345
channel c1: restoring datafile 00027 to +DATADG/PHOENIX/DATAFILE/dms_idx.303.915336375
channel c1: restoring datafile 00028 to +DATADG/PHOENIX/DATAFILE/mcmsjms.293.915336371
channel c1: restoring datafile 00029 to +DATADG/PHOENIX/DATAFILE/mcmsjms_idx.294.915336373
channel c1: restoring datafile 00030 to +DATADG/PHOENIX/DATAFILE/mda.287.915336359
channel c1: restoring datafile 00031 to +DATADG/PHOENIX/DATAFILE/mda_idx.295.915336373
channel c1: reading from backup piece /u02/rmanbkp/phoenix/phoenix_1495_1.bak
channel c1: piece handle=/u02/rmanbkp/phoenix/phoenix_1495_1.bak tag=PHOENIX_FULL_BACKUP
channel c1: restored backup piece 1
channel c1: restore complete, elapsed time: 00:06:46
Finished restore at 23-SEP-2016 14:16:26

datafile 1 switched to datafile copy
input datafile copy RECID=32 STAMP=923321788 file name=+DATADG/PHOENIX/system01.dbf
datafile 2 switched to datafile copy
input datafile copy RECID=33 STAMP=923321789 file name=+DATADG/PHOENIX/DATAFILE/mhb.341.923321491
datafile 3 switched to datafile copy
input datafile copy RECID=34 STAMP=923321789 file name=+DATADG/PHOENIX/sysaux01.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=35 STAMP=923321789 file name=+DATADG/PHOENIX/undotbs01.dbf
datafile 5 switched to datafile copy
input datafile copy RECID=36 STAMP=923321790 file name=+DATADG/PHOENIX/undotbs02.dbf
datafile 6 switched to datafile copy
input datafile copy RECID=37 STAMP=923321790 file name=+DATADG/PHOENIX/users01.dbf
datafile 7 switched to datafile copy
input datafile copy RECID=38 STAMP=923321790 file name=+DATADG/PHOENIX/DATAFILE/mhb_idx.349.923321525
datafile 8 switched to datafile copy
input datafile copy RECID=39 STAMP=923321790 file name=+DATADG/PHOENIX/DATAFILE/evt.334.923321381
datafile 9 switched to datafile copy
input datafile copy RECID=40 STAMP=923321791 file name=+DATADG/PHOENIX/DATAFILE/evt_idx.350.923321533
datafile 10 switched to datafile copy
input datafile copy RECID=41 STAMP=923321791 file name=+DATADG/PHOENIX/DATAFILE/sso.338.923321439
datafile 11 switched to datafile copy
input datafile copy RECID=42 STAMP=923321791 file name=+DATADG/PHOENIX/DATAFILE/sso_idx.351.923321537
datafile 12 switched to datafile copy
input datafile copy RECID=43 STAMP=923321792 file name=+DATADG/PHOENIX/DATAFILE/base.342.923321495
datafile 13 switched to datafile copy
input datafile copy RECID=44 STAMP=923321792 file name=+DATADG/PHOENIX/DATAFILE/base_idx.352.923321537
datafile 14 switched to datafile copy
input datafile copy RECID=45 STAMP=923321792 file name=+DATADG/PHOENIX/DATAFILE/pfk.343.923321501
datafile 15 switched to datafile copy
input datafile copy RECID=46 STAMP=923321792 file name=+DATADG/PHOENIX/DATAFILE/pfk_idx.353.923321543
datafile 16 switched to datafile copy
input datafile copy RECID=47 STAMP=923321792 file name=+DATADG/PHOENIX/DATAFILE/com.344.923321505
datafile 17 switched to datafile copy
input datafile copy RECID=48 STAMP=923321792 file name=+DATADG/PHOENIX/DATAFILE/com_idx.354.923321547
datafile 18 switched to datafile copy
input datafile copy RECID=49 STAMP=923321793 file name=+DATADG/PHOENIX/DATAFILE/ncms.345.923321509
datafile 19 switched to datafile copy
input datafile copy RECID=50 STAMP=923321793 file name=+DATADG/PHOENIX/DATAFILE/ncms_idx.355.923321551
datafile 20 switched to datafile copy
input datafile copy RECID=51 STAMP=923321793 file name=+DATADG/PHOENIX/DATAFILE/ana.339.923321445
datafile 21 switched to datafile copy
input datafile copy RECID=52 STAMP=923321793 file name=+DATADG/PHOENIX/DATAFILE/ana_idx.335.923321381
datafile 22 switched to datafile copy
input datafile copy RECID=53 STAMP=923321793 file name=+DATADG/PHOENIX/DATAFILE/mcms.331.923321381
datafile 23 switched to datafile copy
input datafile copy RECID=54 STAMP=923321793 file name=+DATADG/PHOENIX/DATAFILE/mcms_idx.336.923321381
datafile 24 switched to datafile copy
input datafile copy RECID=55 STAMP=923321794 file name=+DATADG/PHOENIX/DATAFILE/mtn.332.923321381
datafile 25 switched to datafile copy
input datafile copy RECID=56 STAMP=923321794 file name=+DATADG/PHOENIX/DATAFILE/mtn_idx.337.923321389
datafile 26 switched to datafile copy
input datafile copy RECID=57 STAMP=923321794 file name=+DATADG/PHOENIX/DATAFILE/dms.333.923321381
datafile 27 switched to datafile copy
input datafile copy RECID=58 STAMP=923321794 file name=+DATADG/PHOENIX/DATAFILE/dms_idx.356.923321555
datafile 28 switched to datafile copy
input datafile copy RECID=59 STAMP=923321794 file name=+DATADG/PHOENIX/DATAFILE/mcmsjms.346.923321513
datafile 29 switched to datafile copy
input datafile copy RECID=60 STAMP=923321794 file name=+DATADG/PHOENIX/DATAFILE/mcmsjms_idx.347.923321517
datafile 30 switched to datafile copy
input datafile copy RECID=61 STAMP=923321794 file name=+DATADG/PHOENIX/DATAFILE/mda.340.923321453
datafile 31 switched to datafile copy
input datafile copy RECID=62 STAMP=923321795 file name=+DATADG/PHOENIX/DATAFILE/mda_idx.348.923321521

Starting recover at 23-SEP-2016 14:16:36

starting media recovery

channel c1: starting archived log restore to default destination
channel c1: restoring archived log
archived log thread=1 sequence=442
channel c1: restoring archived log
archived log thread=2 sequence=347
channel c1: reading from backup piece /u02/rmanbkp/phoenix/archivelog_1498_1.bak
channel c1: piece handle=/u02/rmanbkp/phoenix/archivelog_1498_1.bak tag=ARCHIVELOG_BKP_PHOENIX
channel c1: restored backup piece 1
channel c1: restore complete, elapsed time: 00:00:03
archived log file name=/u01/app/oracle/product/12.1.0/db_1/arch/1_442_915359514.arch thread=1 sequence=442
archived log file name=/u01/app/oracle/product/12.1.0/db_1/arch/2_347_915359514.arch thread=2 sequence=347
media recovery complete, elapsed time: 00:00:06
Finished recover at 23-SEP-2016 14:16:53
released channel: c1

RMAN>
Another scenario:
I wanted to recover the database until SCN 155764004 (28th September 2016). I restored the oldest controlfile from the available backup (i.e. from 26th September 2016 - RMANBKP26092016/c-1356565195-20160926-02) So, here is the command to accomplish this....

drwxr-xr-x. 2 oracle oinstall 4096 Sep 30 11:40 RMANBKP26092016/
drwxr-xr-x. 2 oracle oinstall 4096 Sep 30 11:45 RMANBKP27092016/
drwxr-xr-x. 2 oracle oinstall 4096 Sep 30 11:47 RMANBKP28092016/
drwxr-xr-x. 2 oracle oinstall 4096 Sep 30 11:52 RMANBKP29092016/
RMAN><>  
RMAN> list backup of database;


List of Backup Sets
===================


BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
1272    Full    883.73M    DISK        00:01:24     26-SEP-2016 18:01:38
        BP Key: 1275   Status: AVAILABLE  Compressed: YES  Tag: PHOENIX_FULL_BACKUP
        Piece Name: /u01/rmanbkp/phoenix/RMANBKP26092016/phoenix_1535_1.bak
  List of Datafiles in backup set 1272
  File LV Type Ckp SCN    Ckp Time             Name
  ---- -- ---- ---------- -------------------- ----
  1       Full 153414407  26-SEP-2016 18:00:14 +ORCLDG/PHOENIX/system01.dbf
  2       Full 153414407  26-SEP-2016 18:00:14 +ORCLDG/PHOENIX/DATAFILE/mhb.288.915336369
  3       Full 153414407  26-SEP-2016 18:00:14 +ORCLDG/PHOENIX/sysaux01.dbf
  4       Full 153414407  26-SEP-2016 18:00:14 +ORCLDG/PHOENIX/undotbs01.dbf
  5       Full 153414407  26-SEP-2016 18:00:14 +ORCLDG/PHOENIX/undotbs02.dbf
  6       Full 153414407  26-SEP-2016 18:00:14 +ORCLDG/PHOENIX/users01.dbf
  7       Full 153414407  26-SEP-2016 18:00:14 +ORCLDG/PHOENIX/DATAFILE/mhb_idx.296.915336373
  8       Full 153414407  26-SEP-2016 18:00:14 +ORCLDG/PHOENIX/DATAFILE/evt.278.915336345
  9       Full 153414407  26-SEP-2016 18:00:14 +ORCLDG/PHOENIX/DATAFILE/evt_idx.297.915336373
  10      Full 153414407  26-SEP-2016 18:00:14 +ORCLDG/PHOENIX/DATAFILE/sso.285.915336357
  11      Full 153414407  26-SEP-2016 18:00:14 +ORCLDG/PHOENIX/DATAFILE/sso_idx.298.915336375
  12      Full 153414407  26-SEP-2016 18:00:14 +ORCLDG/PHOENIX/DATAFILE/base.289.915336369
  13      Full 153414407  26-SEP-2016 18:00:14 +ORCLDG/PHOENIX/DATAFILE/base_idx.299.915336375
  14      Full 153414407  26-SEP-2016 18:00:14 +ORCLDG/PHOENIX/DATAFILE/pfk.290.915336371
  15      Full 153414407  26-SEP-2016 18:00:14 +ORCLDG/PHOENIX/DATAFILE/pfk_idx.300.915336375
  16      Full 153414407  26-SEP-2016 18:00:14 +ORCLDG/PHOENIX/DATAFILE/com.291.915336371
  17      Full 153414407  26-SEP-2016 18:00:14 +ORCLDG/PHOENIX/DATAFILE/com_idx.301.915336375
  18      Full 153414407  26-SEP-2016 18:00:14 +ORCLDG/PHOENIX/DATAFILE/ncms.292.915336371
  19      Full 153414407  26-SEP-2016 18:00:14 +ORCLDG/PHOENIX/DATAFILE/ncms_idx.302.915336375
  20      Full 153414407  26-SEP-2016 18:00:14 +ORCLDG/PHOENIX/DATAFILE/ana.286.915336359
  21      Full 153414407  26-SEP-2016 18:00:14 +ORCLDG/PHOENIX/DATAFILE/ana_idx.279.915336345
  22      Full 153414407  26-SEP-2016 18:00:14 +ORCLDG/PHOENIX/DATAFILE/mcms.274.915336345
  23      Full 153414407  26-SEP-2016 18:00:14 +ORCLDG/PHOENIX/DATAFILE/mcms_idx.280.915336345
  24      Full 153414407  26-SEP-2016 18:00:14 +ORCLDG/PHOENIX/DATAFILE/mtn.276.915336345
  25      Full 153414407  26-SEP-2016 18:00:14 +ORCLDG/PHOENIX/DATAFILE/mtn_idx.281.915336345
  26      Full 153414407  26-SEP-2016 18:00:14 +ORCLDG/PHOENIX/DATAFILE/dms.277.915336345
  27      Full 153414407  26-SEP-2016 18:00:14 +ORCLDG/PHOENIX/DATAFILE/dms_idx.303.915336375
  28      Full 153414407  26-SEP-2016 18:00:14 +ORCLDG/PHOENIX/DATAFILE/mcmsjms.293.915336371
  29      Full 153414407  26-SEP-2016 18:00:14 +ORCLDG/PHOENIX/DATAFILE/mcmsjms_idx.294.915336373
  30      Full 153414407  26-SEP-2016 18:00:14 +ORCLDG/PHOENIX/DATAFILE/mda.287.915336359
  31      Full 153414407  26-SEP-2016 18:00:14 +ORCLDG/PHOENIX/DATAFILE/mda_idx.295.915336373

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
1279    Full    881.76M    DISK        00:01:27     27-SEP-2016 18:01:39
        BP Key: 1282   Status: AVAILABLE  Compressed: YES  Tag: PHOENIX_FULL_BACKUP
        Piece Name: /u01/rmanbkp/phoenix/RMANBKP27092016/phoenix_1543_1.bak
  List of Datafiles in backup set 1279
  File LV Type Ckp SCN    Ckp Time             Name
  ---- -- ---- ---------- -------------------- ----
  1       Full 154554407  27-SEP-2016 18:00:12 +ORCLDG/PHOENIX/system01.dbf
  2       Full 154554407  27-SEP-2016 18:00:12 +ORCLDG/PHOENIX/DATAFILE/mhb.288.915336369
  3       Full 154554407  27-SEP-2016 18:00:12 +ORCLDG/PHOENIX/sysaux01.dbf
  4       Full 154554407  27-SEP-2016 18:00:12 +ORCLDG/PHOENIX/undotbs01.dbf
  5       Full 154554407  27-SEP-2016 18:00:12 +ORCLDG/PHOENIX/undotbs02.dbf
  6       Full 154554407  27-SEP-2016 18:00:12 +ORCLDG/PHOENIX/users01.dbf
  7       Full 154554407  27-SEP-2016 18:00:12 +ORCLDG/PHOENIX/DATAFILE/mhb_idx.296.915336373
  8       Full 154554407  27-SEP-2016 18:00:12 +ORCLDG/PHOENIX/DATAFILE/evt.278.915336345
  9       Full 154554407  27-SEP-2016 18:00:12 +ORCLDG/PHOENIX/DATAFILE/evt_idx.297.915336373
  10      Full 154554407  27-SEP-2016 18:00:12 +ORCLDG/PHOENIX/DATAFILE/sso.285.915336357
  11      Full 154554407  27-SEP-2016 18:00:12 +ORCLDG/PHOENIX/DATAFILE/sso_idx.298.915336375
  12      Full 154554407  27-SEP-2016 18:00:12 +ORCLDG/PHOENIX/DATAFILE/base.289.915336369
  13      Full 154554407  27-SEP-2016 18:00:12 +ORCLDG/PHOENIX/DATAFILE/base_idx.299.915336375
  14      Full 154554407  27-SEP-2016 18:00:12 +ORCLDG/PHOENIX/DATAFILE/pfk.290.915336371
  15      Full 154554407  27-SEP-2016 18:00:12 +ORCLDG/PHOENIX/DATAFILE/pfk_idx.300.915336375
  16      Full 154554407  27-SEP-2016 18:00:12 +ORCLDG/PHOENIX/DATAFILE/com.291.915336371
  17      Full 154554407  27-SEP-2016 18:00:12 +ORCLDG/PHOENIX/DATAFILE/com_idx.301.915336375
  18      Full 154554407  27-SEP-2016 18:00:12 +ORCLDG/PHOENIX/DATAFILE/ncms.292.915336371
  19      Full 154554407  27-SEP-2016 18:00:12 +ORCLDG/PHOENIX/DATAFILE/ncms_idx.302.915336375
  20      Full 154554407  27-SEP-2016 18:00:12 +ORCLDG/PHOENIX/DATAFILE/ana.286.915336359
  21      Full 154554407  27-SEP-2016 18:00:12 +ORCLDG/PHOENIX/DATAFILE/ana_idx.279.915336345
  22      Full 154554407  27-SEP-2016 18:00:12 +ORCLDG/PHOENIX/DATAFILE/mcms.274.915336345
  23      Full 154554407  27-SEP-2016 18:00:12 +ORCLDG/PHOENIX/DATAFILE/mcms_idx.280.915336345
  24      Full 154554407  27-SEP-2016 18:00:12 +ORCLDG/PHOENIX/DATAFILE/mtn.276.915336345
  25      Full 154554407  27-SEP-2016 18:00:12 +ORCLDG/PHOENIX/DATAFILE/mtn_idx.281.915336345
  26      Full 154554407  27-SEP-2016 18:00:12 +ORCLDG/PHOENIX/DATAFILE/dms.277.915336345
  27      Full 154554407  27-SEP-2016 18:00:12 +ORCLDG/PHOENIX/DATAFILE/dms_idx.303.915336375
  28      Full 154554407  27-SEP-2016 18:00:12 +ORCLDG/PHOENIX/DATAFILE/mcmsjms.293.915336371
  29      Full 154554407  27-SEP-2016 18:00:12 +ORCLDG/PHOENIX/DATAFILE/mcmsjms_idx.294.915336373
  30      Full 154554407  27-SEP-2016 18:00:12 +ORCLDG/PHOENIX/DATAFILE/mda.287.915336359
  31      Full 154554407  27-SEP-2016 18:00:12 +ORCLDG/PHOENIX/DATAFILE/mda_idx.295.915336373

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
1287    Full    881.47M    DISK        00:01:26     28-SEP-2016 18:01:39
        BP Key: 1290   Status: AVAILABLE  Compressed: YES  Tag: PHOENIX_FULL_BACKUP
        Piece Name: /u01/rmanbkp/phoenix/RMANBKP28092016/phoenix_1551_1.bak
  List of Datafiles in backup set 1287
  File LV Type Ckp SCN    Ckp Time             Name
  ---- -- ---- ---------- -------------------- ----
  1       Full 155764004  28-SEP-2016 18:00:13 +ORCLDG/PHOENIX/system01.dbf
  2       Full 155764004  28-SEP-2016 18:00:13 +ORCLDG/PHOENIX/DATAFILE/mhb.288.915336369
  3       Full 155764004  28-SEP-2016 18:00:13 +ORCLDG/PHOENIX/sysaux01.dbf
  4       Full 155764004  28-SEP-2016 18:00:13 +ORCLDG/PHOENIX/undotbs01.dbf
  5       Full 155764004  28-SEP-2016 18:00:13 +ORCLDG/PHOENIX/undotbs02.dbf
  6       Full 155764004  28-SEP-2016 18:00:13 +ORCLDG/PHOENIX/users01.dbf
  7       Full 155764004  28-SEP-2016 18:00:13 +ORCLDG/PHOENIX/DATAFILE/mhb_idx.296.915336373
  8       Full 155764004  28-SEP-2016 18:00:13 +ORCLDG/PHOENIX/DATAFILE/evt.278.915336345
  9       Full 155764004  28-SEP-2016 18:00:13 +ORCLDG/PHOENIX/DATAFILE/evt_idx.297.915336373
  10      Full 155764004  28-SEP-2016 18:00:13 +ORCLDG/PHOENIX/DATAFILE/sso.285.915336357
  11      Full 155764004  28-SEP-2016 18:00:13 +ORCLDG/PHOENIX/DATAFILE/sso_idx.298.915336375
  12      Full 155764004  28-SEP-2016 18:00:13 +ORCLDG/PHOENIX/DATAFILE/base.289.915336369
  13      Full 155764004  28-SEP-2016 18:00:13 +ORCLDG/PHOENIX/DATAFILE/base_idx.299.915336375
  14      Full 155764004  28-SEP-2016 18:00:13 +ORCLDG/PHOENIX/DATAFILE/pfk.290.915336371
  15      Full 155764004  28-SEP-2016 18:00:13 +ORCLDG/PHOENIX/DATAFILE/pfk_idx.300.915336375
  16      Full 155764004  28-SEP-2016 18:00:13 +ORCLDG/PHOENIX/DATAFILE/com.291.915336371
  17      Full 155764004  28-SEP-2016 18:00:13 +ORCLDG/PHOENIX/DATAFILE/com_idx.301.915336375
  18      Full 155764004  28-SEP-2016 18:00:13 +ORCLDG/PHOENIX/DATAFILE/ncms.292.915336371
  19      Full 155764004  28-SEP-2016 18:00:13 +ORCLDG/PHOENIX/DATAFILE/ncms_idx.302.915336375
  20      Full 155764004  28-SEP-2016 18:00:13 +ORCLDG/PHOENIX/DATAFILE/ana.286.915336359
  21      Full 155764004  28-SEP-2016 18:00:13 +ORCLDG/PHOENIX/DATAFILE/ana_idx.279.915336345
  22      Full 155764004  28-SEP-2016 18:00:13 +ORCLDG/PHOENIX/DATAFILE/mcms.274.915336345
  23      Full 155764004  28-SEP-2016 18:00:13 +ORCLDG/PHOENIX/DATAFILE/mcms_idx.280.915336345
  24      Full 155764004  28-SEP-2016 18:00:13 +ORCLDG/PHOENIX/DATAFILE/mtn.276.915336345
  25      Full 155764004  28-SEP-2016 18:00:13 +ORCLDG/PHOENIX/DATAFILE/mtn_idx.281.915336345
  26      Full 155764004  28-SEP-2016 18:00:13 +ORCLDG/PHOENIX/DATAFILE/dms.277.915336345
  27      Full 155764004  28-SEP-2016 18:00:13 +ORCLDG/PHOENIX/DATAFILE/dms_idx.303.915336375
  28      Full 155764004  28-SEP-2016 18:00:13 +ORCLDG/PHOENIX/DATAFILE/mcmsjms.293.915336371
  29      Full 155764004  28-SEP-2016 18:00:13 +ORCLDG/PHOENIX/DATAFILE/mcmsjms_idx.294.915336373
  30      Full 155764004  28-SEP-2016 18:00:13 +ORCLDG/PHOENIX/DATAFILE/mda.287.915336359
  31      Full 155764004  28-SEP-2016 18:00:13 +ORCLDG/PHOENIX/DATAFILE/mda_idx.295.915336373

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
1295    Full    886.72M    DISK        00:01:27     29-SEP-2016 18:01:39
        BP Key: 1298   Status: AVAILABLE  Compressed: YES  Tag: PHOENIX_FULL_BACKUP
        Piece Name: /u01/rmanbkp/phoenix/RMANBKP29092016/phoenix_1559_1.bak
  List of Datafiles in backup set 1295
  File LV Type Ckp SCN    Ckp Time             Name
  ---- -- ---- ---------- -------------------- ----
  1       Full 156912037  29-SEP-2016 18:00:12 +ORCLDG/PHOENIX/system01.dbf
  2       Full 156912037  29-SEP-2016 18:00:12 +ORCLDG/PHOENIX/DATAFILE/mhb.288.915336369
  3       Full 156912037  29-SEP-2016 18:00:12 +ORCLDG/PHOENIX/sysaux01.dbf
  4       Full 156912037  29-SEP-2016 18:00:12 +ORCLDG/PHOENIX/undotbs01.dbf
  5       Full 156912037  29-SEP-2016 18:00:12 +ORCLDG/PHOENIX/undotbs02.dbf
  6       Full 156912037  29-SEP-2016 18:00:12 +ORCLDG/PHOENIX/users01.dbf
  7       Full 156912037  29-SEP-2016 18:00:12 +ORCLDG/PHOENIX/DATAFILE/mhb_idx.296.915336373
  8       Full 156912037  29-SEP-2016 18:00:12 +ORCLDG/PHOENIX/DATAFILE/evt.278.915336345
  9       Full 156912037  29-SEP-2016 18:00:12 +ORCLDG/PHOENIX/DATAFILE/evt_idx.297.915336373
  10      Full 156912037  29-SEP-2016 18:00:12 +ORCLDG/PHOENIX/DATAFILE/sso.285.915336357
  11      Full 156912037  29-SEP-2016 18:00:12 +ORCLDG/PHOENIX/DATAFILE/sso_idx.298.915336375
  12      Full 156912037  29-SEP-2016 18:00:12 +ORCLDG/PHOENIX/DATAFILE/base.289.915336369
  13      Full 156912037  29-SEP-2016 18:00:12 +ORCLDG/PHOENIX/DATAFILE/base_idx.299.915336375
  14      Full 156912037  29-SEP-2016 18:00:12 +ORCLDG/PHOENIX/DATAFILE/pfk.290.915336371
  15      Full 156912037  29-SEP-2016 18:00:12 +ORCLDG/PHOENIX/DATAFILE/pfk_idx.300.915336375
  16      Full 156912037  29-SEP-2016 18:00:12 +ORCLDG/PHOENIX/DATAFILE/com.291.915336371
  17      Full 156912037  29-SEP-2016 18:00:12 +ORCLDG/PHOENIX/DATAFILE/com_idx.301.915336375
  18      Full 156912037  29-SEP-2016 18:00:12 +ORCLDG/PHOENIX/DATAFILE/ncms.292.915336371
  19      Full 156912037  29-SEP-2016 18:00:12 +ORCLDG/PHOENIX/DATAFILE/ncms_idx.302.915336375
  20      Full 156912037  29-SEP-2016 18:00:12 +ORCLDG/PHOENIX/DATAFILE/ana.286.915336359
  21      Full 156912037  29-SEP-2016 18:00:12 +ORCLDG/PHOENIX/DATAFILE/ana_idx.279.915336345
  22      Full 156912037  29-SEP-2016 18:00:12 +ORCLDG/PHOENIX/DATAFILE/mcms.274.915336345
  23      Full 156912037  29-SEP-2016 18:00:12 +ORCLDG/PHOENIX/DATAFILE/mcms_idx.280.915336345
  24      Full 156912037  29-SEP-2016 18:00:12 +ORCLDG/PHOENIX/DATAFILE/mtn.276.915336345
  25      Full 156912037  29-SEP-2016 18:00:12 +ORCLDG/PHOENIX/DATAFILE/mtn_idx.281.915336345
  26      Full 156912037  29-SEP-2016 18:00:12 +ORCLDG/PHOENIX/DATAFILE/dms.277.915336345
  27      Full 156912037  29-SEP-2016 18:00:12 +ORCLDG/PHOENIX/DATAFILE/dms_idx.303.915336375
  28      Full 156912037  29-SEP-2016 18:00:12 +ORCLDG/PHOENIX/DATAFILE/mcmsjms.293.915336371
  29      Full 156912037  29-SEP-2016 18:00:12 +ORCLDG/PHOENIX/DATAFILE/mcmsjms_idx.294.915336373
  30      Full 156912037  29-SEP-2016 18:00:12 +ORCLDG/PHOENIX/DATAFILE/mda.287.915336359
  31      Full 156912037  29-SEP-2016 18:00:12 +ORCLDG/PHOENIX/DATAFILE/mda_idx.295.915336373

RMAN>
RMAN><>  
run {
allocate channel c1 device type disk;
set newname for datafile 1 to '+DATADG/PHOENIX/system01.dbf';
set newname for datafile 2 to '+DATADG/PHOENIX/DATAFILE/mhb.288.915336369';
set newname for datafile 3 to '+DATADG/PHOENIX/sysaux01.dbf';
set newname for datafile 4 to '+DATADG/PHOENIX/undotbs01.dbf';
set newname for datafile 5 to '+DATADG/PHOENIX/undotbs02.dbf';
set newname for datafile 6 to '+DATADG/PHOENIX/users01.dbf';
set newname for datafile 7 to '+DATADG/PHOENIX/DATAFILE/mhb_idx.296.915336373';
set newname for datafile 8 to '+DATADG/PHOENIX/DATAFILE/evt.278.915336345';
set newname for datafile 9 to '+DATADG/PHOENIX/DATAFILE/evt_idx.297.915336373';
set newname for datafile 10 to '+DATADG/PHOENIX/DATAFILE/sso.285.915336357';
set newname for datafile 11 to '+DATADG/PHOENIX/DATAFILE/sso_idx.298.915336375';
set newname for datafile 12 to '+DATADG/PHOENIX/DATAFILE/base.289.915336369';
set newname for datafile 13 to '+DATADG/PHOENIX/DATAFILE/base_idx.299.915336375';
set newname for datafile 14 to '+DATADG/PHOENIX/DATAFILE/pfk.290.915336371';
set newname for datafile 15 to '+DATADG/PHOENIX/DATAFILE/pfk_idx.300.915336375';
set newname for datafile 16 to '+DATADG/PHOENIX/DATAFILE/com.291.915336371';
set newname for datafile 17 to '+DATADG/PHOENIX/DATAFILE/com_idx.301.915336375';
set newname for datafile 18 to '+DATADG/PHOENIX/DATAFILE/ncms.292.915336371';
set newname for datafile 19 to '+DATADG/PHOENIX/DATAFILE/ncms_idx.302.915336375';
set newname for datafile 20 to '+DATADG/PHOENIX/DATAFILE/ana.286.915336359';
set newname for datafile 21 to '+DATADG/PHOENIX/DATAFILE/ana_idx.279.915336345';
set newname for datafile 22 to '+DATADG/PHOENIX/DATAFILE/mcms.274.915336345';
set newname for datafile 23 to '+DATADG/PHOENIX/DATAFILE/mcms_idx.280.915336345';
set newname for datafile 24 to '+DATADG/PHOENIX/DATAFILE/mtn.276.915336345';
set newname for datafile 25 to '+DATADG/PHOENIX/DATAFILE/mtn_idx.281.915336345';
set newname for datafile 26 to '+DATADG/PHOENIX/DATAFILE/dms.277.915336345';
set newname for datafile 27 to '+DATADG/PHOENIX/DATAFILE/dms_idx.303.915336375';
set newname for datafile 28 to '+DATADG/PHOENIX/DATAFILE/mcmsjms.293.915336371';
set newname for datafile 29 to '+DATADG/PHOENIX/DATAFILE/mcmsjms_idx.294.915336373';
set newname for datafile 30 to '+DATADG/PHOENIX/DATAFILE/mda.287.915336359';
set newname for datafile 31 to '+DATADG/PHOENIX/DATAFILE/mda_idx.295.915336373';
restore database until scn 155764004;
switch datafile all;
recover database until scn 155764004;
}

.......................
.......................
.......................
archived log file name=/u01/app/oracle/product/12.1.0/db_1/arch/1_474_915359514.arch thread=1 sequence=474
archived log file name=/u01/app/oracle/product/12.1.0/db_1/arch/1_475_915359514.arch thread=1 sequence=475
archived log file name=/u01/app/oracle/product/12.1.0/db_1/arch/2_372_915359514.arch thread=2 sequence=372
archived log file name=/u01/app/oracle/product/12.1.0/db_1/arch/1_476_915359514.arch thread=1 sequence=476
archived log file name=/u01/app/oracle/product/12.1.0/db_1/arch/1_477_915359514.arch thread=1 sequence=477
archived log file name=/u01/app/oracle/product/12.1.0/db_1/arch/1_478_915359514.arch thread=1 sequence=478
archived log file name=/u01/app/oracle/product/12.1.0/db_1/arch/2_373_915359514.arch thread=2 sequence=373
media recovery complete, elapsed time: 00:02:59
Finished recover at 30-SEP-2016 14:00:34
released channel: c1

RMAN> 
$
SQL> alter database rename file '+ORCLDG/PHOENIX/redo01.log' to '+DATADG/PHOENIX/redo01.log';
Database altered.

SQL> alter database rename file '+ORCLDG/PHOENIX/redo02.log' to '+DATADG/PHOENIX/redo02.log';
Database altered.

SQL> alter database rename file '+ORCLDG/PHOENIX/redo03.log' to '+DATADG/PHOENIX/redo03.log';
Database altered.

SQL> alter database rename file '+ORCLDG/PHOENIX/redo04.log' to '+DATADG/PHOENIX/redo04.log';
Database altered.

SQL> alter database clear logfile group 1;
Database altered.
SQL>
SQL> alter database open resetlogs ;
Please write your comment if this article was useful.

Shannura

/
You might want to read this:
Recovery Scenarios