Hi took backup with controlfile autobackup is not on
So the controlfile and spfile will be included in backup pieces itself
I moved the backup pieces to diff server and trying to restore the controlfile and getting the below error
RMAN> RUN
{
ALLOCATE CHANNEL c1 DEVICE TYPE disk;
ALLOCATE CHANNEL c2 DEVICE TYPE disk;
backup database format '/ofa/u4907/%d_%T_%s_%p_FULL';
release channel c1;
release channel c2;
}2> 3> 4> 5> 6> 7> 8>
allocated channel: c1
channel c1: SID=16 device type=DISK
allocated channel: c2
channel c2: SID=146 device type=DISK
Starting backup at 12-APR-16
channel c1: starting full datafile backup set
channel c1: specifying datafile(s) in backup set
input datafile file number=00005 name=/ofa/u001/oradata/GRID10/datafiles/sysaux_01.dbf
input datafile file number=00011 name=/ofa/u001/oradata/GRID10/datafiles/GRID10_flflmt_tbl_01.dbf
input datafile file number=00009 name=/ofa/u001/oradata/GRID10/datafiles/GRID10_pv_data01.dbf
input datafile file number=00004 name=/ofa/u001/oradata/GRID10/rollsegs/GRID10_rbs01.dbf
input datafile file number=00006 name=/ofa/u001/oradata/GRID10/datafiles/GRID10_usr01.dbf
input datafile file number=00002 name=/ofa/u001/oradata/GRID10/datafiles/GRID10_tool01.dbf
input datafile file number=00008 name=/ofa/u001/oradata/GRID10/datafiles/GRID10_data02.dbf
channel c1: starting piece 1 at 12-APR-16
channel c2: starting full datafile backup set
channel c2: specifying datafile(s) in backup set
including current SPFILE in backup set
including current control file in backup set
input datafile file number=00013 name=/ofa/u001/oradata/GRID10/rollsegs/undotbs_01.dbf
input datafile file number=00001 name=/ofa/u001/oradata/GRID10/datafiles/GRID10_sys01.dbf
input datafile file number=00012 name=/ofa/u001/oradata/GRID10/indexes/GRID10_fl
input datafile file number=00010 name=/ofa/u001/oradata/GRID10/indexes/GRID10_pv
input datafile file number=00003 name=/ofa/u001/oradata/GRID10/datafiles/GRID10_
input datafile file number=00007 name=/ofa/u001/oradata/GRID10/indexes/GRID10_id
channel c2: starting piece 1 at 12-APR-16
channel c1: finished piece 1 at 12-APR-16
piece handle=/ofa/u4907/GRID10_20160412_76673_1_FULL tag=TAG20160412T134515 comm
channel c1: backup set complete, elapsed time: 00:00:36
channel c2: finished piece 1 at 12-APR-16
piece handle=/ofa/u4907/GRID10_20160412_76674_1_FULL tag=TAG20160412T134515 comm
channel c2: backup set complete, elapsed time: 00:00:35
Finished backup at 12-APR-16
released channel: c1
released channel: c2
RMAN> exit
Recovery Manager complete.
===================================================================================================
In Diff server trying to recover with dummy instance:
===================================
Recovery Manager: Release 11.2.0.4.0 - Production on Tue Apr 12 14:16:30 2016
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database (not started)
RMAN>
RMAN> startup nomount;
startup failed: ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/var/software/Oracle/product/11.2.0/db_1/dbs/initRECOVERY.ora'
starting Oracle instance without parameter file for retrieval of spfile
Oracle instance started
Total System Global Area 1068937216 bytes
Fixed Size 2260088 bytes
Variable Size 281019272 bytes
Database Buffers 780140544 bytes
Redo Buffers 5517312 bytes
RMAN>
RMAN> restore controlfile from '/tmp/GRID10_20160412_76674_1_FULL';
Starting restore at 12-APR-16
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 04/12/2016 14:19:44
RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or piece
RMAN> restore controlfile from '/tmp/GRID10_20160412_76673_1_FULL';
Starting restore at 12-APR-16
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 04/12/2016 14:19:52
RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or piece
RMAN>