Hello Everyone,
Database Version : 12.1.0.2.0 ( DEVDB)
Database Version : 12.1.0.1.0 (PROD)
Server Version : RHELinux 6.8 Santiago - (both servers)
I am getting the below error while trying to do a cross restore(PROD to DEVDB) from a previous backup of PROD database through RMAN.
RMAN-03002: failure of recover command at 04/08/2017 07:11:40
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-01110: data file 1: '+DATA/PROD/DATAFILE/system.258.855417843'
ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
ORA-01110: data file 1: '+DATA/PROD/DATAFILE/system.258.855417843'
1) I have verified the integrity of the prod backup using the ( restore validate database & restore datafile 1 validate ) and it looks all good.
2) tried restore of datafile 1 alone from same backup but the same issue.
when I checked the location for datafiles on ASM its creating a PROD folder and keeping datafiles inside it rather restoring it in DEVDB folder. Not sure why it does that.
ASMCMD> pwd
+DATA1/devdb
ASMCMD>ls -lrt
Type Redund Striped Time Sys Name
DATAFILE UNPROT COARSE APR 08 07:00:00 N epm11_odimaster_001.dbf => +DATA1/PROD/DATAFILE/EPM11_ODIMASTER.265.940748915
DATAFILE UNPROT COARSE APR 08 07:00:00 N epm11_odiwork_001.dbf => +DATA1/PROD/DATAFILE/EPM11_ODIWORK.280.940748913
DATAFILE UNPROT COARSE APR 08 07:00:00 N epm11_plnbulleye_idxll01.dbf => +DATA1/PROD/DATAFILE/EPM11_PLNBULLEYE_IDXLL.268.940748913
DATAFILE UNPROT COARSE APR 08 07:00:00 N epm11_plnemeapln_001.dbf => +DATA1/PROD/DATAFILE/EPM11_PLNEMEAPLN.260.940748915
DATAFILE UNPROT COARSE APR 08 07:00:00 N epm11_plnglbhrwfp_001.dbf => +DATA1/PROD/DATAFILE/EPM11_PLNGLBHRWFP.272.940748915
DATAFILE UNPROT COARSE APR 08 07:00:00 N epm11_plnnaplan_001.dbf => +DATA1/PROD/DATAFILE/EPM11_PLNNAPLAN.267.940748913
DATAFILE UNPROT COARSE APR 08 07:00:00 N epm11_plnnapln_001.dbf => +DATA1/PROD/DATAFILE/EPM11_PLNNAPLN.278.940748915
DATAFILE UNPROT COARSE APR 08 07:00:00 N epm11_plnnglbpln_001.dbf => +DATA1/PROD/DATAFILE/EPM11_PLNNGLBPLN.279.940748915
DATAFILE UNPROT COARSE APR 08 07:00:00 N epm11_plnprime_01.dbf => +DATA1/PROD/DATAFILE/EPM11_PLNPRIME.281.940748913
DATAFILE UNPROT COARSE APR 08 07:00:00 N epm11_plnprodcost_001.dbf => +DATA1/PROD/DATAFILE/EPM11_PLNPRODCOST.264.940748915
DATAFILE UNPROT COARSE APR 08 07:00:00 N epm11_plnprodprof_001.dbf => +DATA1/PROD/DATAFILE/EPM11_PLNPRODPROF.258.940748913
DATAFILE UNPROT COARSE APR 08 07:00:00 N epm11_plnrefapp_001.dbf => +DATA1/PROD/DATAFILE/EPM11_PLNREFAPP.256.940748915
DATAFILE UNPROT COARSE APR 08 07:00:00 N epm11_plnstg_001.dbf => +DATA1/PROD/DATAFILE/EPM11_PLNSTG.257.940748915
DATAFILE UNPROT COARSE APR 08 07:00:00 N epm11_plnsys_001.dbf => +DATA1/PROD/DATAFILE/EPM11_PLNSYS.263.940748915
DATAFILE UNPROT COARSE APR 08 07:00:00 N epm11hypplan_def_wrk_datall_001.dbf => +DATA1/PROD/DATAFILE/EPM11HYPPLAN_DEF_WRK_DATALL.262.940748913
DATAFILE UNPROT COARSE APR 08 07:00:00 N epm11hypplan_idxll_001.dbf => +DATA1/PROD/DATAFILE/EPM11HYPPLAN_IDXLL.271.940748915
DATAFILE UNPROT COARSE APR 08 07:00:00 N epm11hypplan_map_seg_datall_001.dbf => +DATA1/PROD/DATAFILE/EPM11HYPPLAN_MAP_SEG_DATALL.277.940748915
DATAFILE UNPROT COARSE APR 08 07:00:00 N plnemeapln_def_wrk_datall_001.dbf => +DATA1/PROD/DATAFILE/PLNEMEAPLN_DEF_WRK_DATALL.269.940748915
DATAFILE UNPROT COARSE APR 08 07:00:00 N plnemeapln_idxll_001.dbf => +DATA1/PROD/DATAFILE/PLNEMEAPLN_IDXLL.259.940748913
DATAFILE UNPROT COARSE APR 08 07:00:00 N plnemeapln_map_seg_datall_001.dbf => +DATA1/PROD/DATAFILE/PLNEMEAPLN_MAP_SEG_DATALL.266.940748915
DATAFILE UNPROT COARSE APR 08 07:00:00 N sysaux01.dbf => +DATA1/PROD/DATAFILE/SYSAUX.276.940748915
DATAFILE UNPROT COARSE APR 08 07:00:00 N system01.dbf => +DATA1/PROD/DATAFILE/SYSTEM.274.940748915
DATAFILE UNPROT COARSE APR 08 07:00:00 N toolsll01.dbf => +DATA1/PROD/DATAFILE/TOOLSLL.275.940748913
DATAFILE UNPROT COARSE APR 08 07:00:00 N undotbs1.dbf => +DATA1/PROD/DATAFILE/UNDOTBS1.270.940748913
DATAFILE UNPROT COARSE APR 08 07:00:00 N users.dbf => +DATA1/PROD/DATAFILE/USERS.261.940748913
DATAFILE UNPROT COARSE APR 08 07:00:00 N usersll01.dbf => +DATA1/PROD/DATAFILE/USERSLL.273.940748913
ASMCMD>
I did google to see but dont see any posts related to above errors encountered during cross-restore. Can anyone please suggest
if I am missing anything in specific.
Thanks
Mohammeddba
Oracle DBA