Hi,
Below is the latest restore log which is showing failed.
brrestore -m full -b bfavttcd.ffr -p initHebdoAMQrestoreAMP. sap -c
BR0401I BRRESTORE 7.20 (18)
BR0405I Start of file restore: rfawiscv.rsb 2019-04-09 06.46.41
BR0484I BRRESTORE log file: /oracle/AMQ/sapbackup/rfawiscv.rsb
BR0454W Values of oracle_sid are different: current 'AMQ', backup bfavttcd.ffr 'AMP'
BR0455W Value 'AMQ' of oracle_sid will be used for restore
BR0454W Values of oracle_home are different: current '/oracle/AMQ/102_64', backup bfavttcd.ffr '/oracle/AMP/102_64'
BR0455W Value '/oracle/AMQ/102_64' of oracle_home will be used for restore
BR0454W Values of sapdata_home are different: current '/oracle/AMQ', backup bfavttcd.ffr '/oracle/AMP'
BR0455W Value '/oracle/AMQ' of sapdata_home will be used for restore
BR0280I BRRESTORE time stamp: 2019-04-09 06.46.41
BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRRESTORE:
c
BR0280I BRRESTORE time stamp: 2019-04-09 06.46.51
BR0257I Your reply: 'c'
BR0259I Program execution will be continued...
BR0427I Files from the old sapdata_home /oracle/AMP will be restored into the new sapdata_home /oracle/AMQ
BR0565W Due to running database instance control file cannot be restored during a BRRESTORE run with RMAN
BR0566I Stop the database instance and restore the control file separately
BR0280I BRRESTORE time stamp: 2019-04-09 06.46.51
BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRRESTORE:
c
BR0280I BRRESTORE time stamp: 2019-04-09 06.47.10
BR0257I Your reply: 'c'
BR0259I Program execution will be continued...
BR0280I BRRESTORE time stamp: 2019-04-09 06.47.10
BR0407I Restore of database: AMQ - This is I am pointing which is yellow Database name should be AMP not AMQ, AMQ is a quality system where I am restoring.BR0408I BRRESTORE action ID: rfawiscv
BR0409I BRRESTORE function ID: rsb
BR0449I Restore mode: FULL
BR0411I Database files for restore:
/oracle/AMP/origlogA/log_g11m1.dbf
/oracle/AMP/mirrlogA/log_g11m2.dbf
/oracle/AMP/origlogB/log_g12m1.dbf
/oracle/AMP/mirrlogB/log_g12m2.dbf
/oracle/AMP/origlogA/log_g13m1.dbf
/oracle/AMP/mirrlogA/log_g13m2.dbf
/oracle/AMP/origlogB/log_g14m1.dbf
/oracle/AMP/mirrlogB/log_g14m2.dbf
BR0419I Files will be restored from backup: bfavttcd.ffr 2019-04-06 05.43.39
BR0416I 142 files found to restore, total size 275384.598 MB
BR0424I Files will not be decompressed
BR0421I Restore device type: rman_util
BR0280I BRRESTORE time stamp: 2019-04-09 06.47.10
BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRRESTORE:
c
BR0280I BRRESTORE time stamp: 2019-04-09 06.47.23
BR0257I Your reply: 'c'
BR0259I Program execution will be continued...
BR0126I Unattended mode active - no operator confirmation required
BR0280I BRRESTORE time stamp: 2019-04-09 06.47.23
BR0554I Starting restore from full database backup using RMAN...
BR0278E Command output of 'SHELL=/bin/sh /oracle/AMQ/102_64/bin/rman nocatalog':
Recovery Manager: Release 10.2.0.4.0 - Production on Tue Apr 9 06:47:23 2019
Copyright (c) 1982, 2007, Oracle. All rights reserved.
RMAN>
RMAN> connect target *
connected to target database (not started)
RMAN> **end-of-file**
RMAN>
host command complete
RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> 22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40> 41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59> 60> 61> 62> 63> 64> 65> 66> 67> 68> 69> 70> 71> 72> 73> 74> 75> 76> 77> 78> 79> 80> 81> 82> 83> 84> 85> 86> 87> 88> 89> 90> 91> 92> 93> 94> 95> 96> 97> 98> 99> 100> 101> 102> 103> 104> 105> 106> 107> 108> 109> 110> 111> 112> 113> 114> 115> 116> 117> 118> 119> 120> 121> 122> 123> 124> 125> 126> 127> 128> 129> 130> 131> 132> 133> 134> 135> 136> 137> 138> 139> 140> 141> 142> 143> 144> 145> 146> 147> 148> 149> 150> 151> 152> 153> 154>
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of allocate command at 04/09/2019 06:47:24
RMAN-06403: could not obtain a fully authorized session
ORA-01034: ORACLE not available
RMAN>
Recovery Manager complete.
BR0200I BR_TRACE: location BrRmanCall-39, commands for RMAN in: /oracle/AMQ/sapbackup/.rfawiscv.cmd
'@/oracle/AMQ/sapbackup/..rfawiscv..cmd^'
'host '/usr/sap/AMQ/SYS/exe/run/brtools -f delete /oracle/AMQ/sapbackup/..rfawiscv..cmd';^'
'run { allocate channel sbt_1 device type 'SBT_TAPE'^'
'parms 'SBT_LIBRARY=/oracle/AMQ/102_64/lib/libobk.sl,ENV=(XINT_PROFILE=/oracle/AMQ/102_64/dbs/initHebdoAMQrestoreAMP.utl ,PROLE_PORT=57323,BR_CALLER=BRRESTORE,BR_BACKUP=FULL,BR_REQUEST=NEW,BR_RUN=rfawiscv.rsb)';^'
'allocate channel sbt_2 device type 'SBT_TAPE'^'
'parms 'SBT_LIBRARY=/oracle/AMQ/102_64/lib/libobk.sl,ENV=(XINT_PROFILE=/oracle/AMQ/102_64/dbs/initHebdoAMQrestoreAMP.utl ,PROLE_PORT=57323,BR_CALLER=BRRESTORE,BR_BACKUP=FULL,BR_REQUEST=NEW,BR_RUN=rfawiscv.rsb)';^'
'allocate channel sbt_3 device type 'SBT_TAPE'^'
'parms 'SBT_LIBRARY=/oracle/AMQ/102_64/lib/libobk.sl,ENV=(XINT_PROFILE=/oracle/AMQ/102_64/dbs/initHebdoAMQrestoreAMP.utl ,PROLE_PORT=57323,BR_CALLER=BRRESTORE,BR_BACKUP=FULL,BR_REQUEST=NEW,BR_RUN=rfawiscv.rsb)';^'
'set newname for datafile '/oracle/AMP/sapdata1/bctst03d_1/bctst03d.data1' to '/oracle/AMQ/sapdata1/bctst03d_1/bctst03d.data1';^'
'set newname for datafile '/oracle/AMP/sapdata1/bctst03i_1/bctst03i.data1' to '/oracle/AMQ/sapdata1/bctst03i_1/bctst03i.data1';^'
'set newname for datafile '/oracle/AMP/sapdata1/btabd_1/btabd.data1' to '/oracle/AMQ/sapdata1/btabd_1/btabd.data1';^'
'set newname for datafile '/oracle/AMP/sapdata1/btabd_10/btabd.data10' to '/oracle/AMQ/sapdata1/btabd_10/btabd.data10';^'
'set newname for datafile '/oracle/AMP/sapdata1/btabd_11/btabd.data11' to '/oracle/AMQ/sapdata1/btabd_11/btabd.data11';^'
'set newname for datafile '/oracle/AMP/sapdata1/btabd_12/btabd.data12' to '/oracle/AMQ/sapdata1/btabd_12/btabd.data12';^'
'set newname for datafile '/oracle/AMP/sapdata1/btabd_13/btabd.data13' to '/oracle/AMQ/sapdata1/btabd_13/btabd.data13';^'
'set newname for datafile '/oracle/AMP/sapdata1/btabd_14/btabd.data14' to '/oracle/AMQ/sapdata1/btabd_14/btabd.data14';^'
'set newname for datafile '/oracle/AMP/sapdata1/btabd_15/btabd.data15' to '/oracle/AMQ/sapdata1/btabd_15/btabd.data15';^'
'set newname for datafile '/oracle/AMP/sapdata1/btabd_16/btabd.data16' to '/oracle/AMQ/sapdata1/btabd_16/btabd.data16';^'
'set newname for datafile '/oracle/AMP/sapdata1/btabd_17/btabd.data17' to '/oracle/AMQ/sapdata1/btabd_17/btabd.data17';^'
'set newname for datafile '/oracle/AMP/sapdata1/btabd_18/btabd.data18' to '/oracle/AMQ/sapdata1/btabd_18/btabd.data18';^'
'set newname for datafile '/oracle/AMP/sapdata1/btabd_19/btabd.data19' to '/oracle/AMQ/sapdata1/btabd_19/btabd.data19';^'
'set newname for datafile '/oracle/AMP/sapdata1/btabd_2/btabd.data2' to '/oracle/AMQ/sapdata1/btabd_2/btabd.data2';^'
'set newname for datafile '/oracle/AMP/sapdata1/btabd_20/btabd.data20' to '/oracle/AMQ/sapdata1/btabd_20/btabd.data20';^'
'set newname for datafile '/oracle/AMP/sapdata1/btabd_21/btabd.data21' to '/oracle/AMQ/sapdata1/btabd_21/btabd.data21';^'
'set newname for datafile '/oracle/AMP/sapdata1/btabd_22/btabd.data22' to '/oracle/AMQ/sapdata1/btabd_22/btabd.data22';^'
'set newname for datafile '/oracle/AMP/sapdata1/btabd_23/btabd.data23' to '/oracle/AMQ/sapdata1/btabd_23/btabd.data23';^'
'set newname for datafile '/oracle/AMP/sapdata1/btabd_24/btabd.data24' to '/oracle/AMQ/sapdata1/btabd_24/btabd.data24';^'
'set newname for datafile '/oracle/AMP/sapdata1/btabd_25/btabd.data25' to '/oracle/AMQ/sapdata1/btabd_25/btabd.data25';^'
'set newname for datafile '/oracle/AMP/sapdata1/btabd_26/btabd.data26' to '/oracle/AMQ/sapdata1/btabd_26/btabd.data26';^'
'set newname for datafile '/oracle/AMP/sapdata1/btabd_27/btabd.data27' to '/oracle/AMQ/sapdata1/btabd_27/btabd.data27';^'
'set newname for datafile '/oracle/AMP/sapdata1/btabd_28/btabd.data28' to '/oracle/AMQ/sapdata1/btabd_28/btabd.data28';^'
'set newname for datafile '/oracle/AMP/sapdata1/btabd_29/btabd.data29' to '/oracle/AMQ/sapdata1/btabd_29/btabd.data29';^'
'set newname for datafile '/oracle/AMP/sapdata1/btabd_3/btabd.data3' to '/oracle/AMQ/sapdata1/btabd_3/btabd.data3';^'
'set newname for datafile '/oracle/AMP/sapdata1/btabd_30/btabd.data30' to '/oracle/AMQ/sapdata1/btabd_30/btabd.data30';^'
'set newname for datafile '/oracle/AMP/sapdata1/btabd_31/btabd.data31' to '/oracle/AMQ/sapdata1/btabd_31/btabd.data31';^'
'set newname for datafile '/oracle/AMP/sapdata1/btabd_32/btabd.data32' to '/oracle/AMQ/sapdata1/btabd_32/btabd.data32';^'
'set newname for datafile '/oracle/AMP/sapdata1/btabd_4/btabd.data4' to '/oracle/AMQ/sapdata1/btabd_4/btabd.data4';^'
'set newname for datafile '/oracle/AMP/sapdata1/btabd_5/btabd.data5' to '/oracle/AMQ/sapdata1/btabd_5/btabd.data5';^'
'set newname for datafile '/oracle/AMP/sapdata1/btabd_6/btabd.data6' to '/oracle/AMQ/sapdata1/btabd_6/btabd.data6';^'
'set newname for datafile '/oracle/AMP/sapdata1/btabd_7/btabd.data7' to '/oracle/AMQ/sapdata1/btabd_7/btabd.data7';^'
'set newname for datafile '/oracle/AMP/sapdata1/btabd_8/btabd.data8' to '/oracle/AMQ/sapdata1/btabd_8/btabd.data8';^'
'set newname for datafile '/oracle/AMP/sapdata1/btabd_9/btabd.data9' to '/oracle/AMQ/sapdata1/btabd_9/btabd.data9';^'
'set newname for datafile '/oracle/AMP/sapdata1/btabi_1/btabi.data1' to '/oracle/AMQ/sapdata1/btabi_1/btabi.data1';^'
'set newname for datafile '/oracle/AMP/sapdata1/btabi_10/btabi.data10' to '/oracle/AMQ/sapdata1/btabi_10/btabi.data10';^'
'set newname for datafile '/oracle/AMP/sapdata1/btabi_11/btabi.data11' to '/oracle/AMQ/sapdata1/btabi_11/btabi.data11';^'
'set newname for datafile '/oracle/AMP/sapdata1/btabi_12/btabi.data12' to '/oracle/AMQ/sapdata1/btabi_12/btabi.data12';^'
'set newname for datafile '/oracle/AMP/sapdata1/btabi_13/btabi.data13' to '/oracle/AMQ/sapdata1/btabi_13/btabi.data13';^'
'set newname for datafile '/oracle/AMP/sapdata1/btabi_14/btabi.data14' to '/oracle/AMQ/sapdata1/btabi_14/btabi.data14';^'
'set newname for datafile '/oracle/AMP/sapdata1/btabi_15/btabi.data15' to '/oracle/AMQ/sapdata1/btabi_15/btabi.data15';^'
'set newname for datafile '/oracle/AMP/sapdata1/btabi_16/btabi.data16' to '/oracle/AMQ/sapdata1/btabi_16/btabi.data16';^'
'set newname for datafile '/oracle/AMP/sapdata1/btabi_17/btabi.data17' to '/oracle/AMQ/sapdata1/btabi_17/btabi.data17';^'
'set newname for datafile '/oracle/AMP/sapdata1/btabi_18/btabi.data18' to '/oracle/AMQ/sapdata1/btabi_18/btabi.data18';^'
'set newname for datafile '/oracle/AMP/sapdata1/btabi_19/btabi.data19' to '/oracle/AMQ/sapdata1/btabi_19/btabi.data19';^'
'set newname for datafile '/oracle/AMP/sapdata1/btabi_2/btabi.data2' to '/oracle/AMQ/sapdata1/btabi_2/btabi.data2';^'
'set newname for datafile '/oracle/AMP/sapdata1/btabi_20/btabi.data20' to '/oracle/AMQ/sapdata1/btabi_20/btabi.data20';^'
'set newname for datafile '/oracle/AMP/sapdata1/btabi_21/btabi.data21' to '/oracle/AMQ/sapdata1/btabi_21/btabi.data21';^'
'set newname for datafile '/oracle/AMP/sapdata1/btabi_3/btabi.data3' to '/oracle/AMQ/sapdata1/btabi_3/btabi.data3';^'
'set newname for datafile '/oracle/AMP/sapdata1/btabi_4/btabi.data4' to '/oracle/AMQ/sapdata1/btabi_4/btabi.data4';^'
'set newname for datafile '/oracle/AMP/sapdata1/btabi_5/btabi.data5' to '/oracle/AMQ/sapdata1/btabi_5/btabi.data5';^'
'set newname for datafile '/oracle/AMP/sapdata1/btabi_6/btabi.data6' to '/oracle/AMQ/sapdata1/btabi_6/btabi.data6';^'
'set newname for datafile '/oracle/AMP/sapdata1/btabi_7/btabi.data7' to '/oracle/AMQ/sapdata1/btabi_7/btabi.data7';^'
'set newname for datafile '/oracle/AMP/sapdata1/btabi_8/btabi.data8' to '/oracle/AMQ/sapdata1/btabi_8/btabi.data8';^'
'set newname for datafile '/oracle/AMP/sapdata1/btabi_9/btabi.data9' to '/oracle/AMQ/sapdata1/btabi_9/btabi.data9';^'
'set newname for datafile '/oracle/AMP/sapdata1/clud_1/clud.data1' to '/oracle/AMQ/sapdata1/clud_1/clud.data1';^'
'set newname for datafile '/oracle/AMP/sapdata1/clud_2/clud.data2' to '/oracle/AMQ/sapdata1/clud_2/clud.data2';^'
'set newname for datafile '/oracle/AMP/sapdata1/clud_3/clud.data3' to '/oracle/AMQ/sapdata1/clud_3/clud.data3';^'
'set newname for datafile '/oracle/AMP/sapdata1/clui_1/clui.data1' to '/oracle/AMQ/sapdata1/clui_1/clui.data1';^'
'set newname for datafile '/oracle/AMP/sapdata1/cocoepd_1/cocoepd.data1' to '/oracle/AMQ/sapdata1/cocoepd_1/cocoepd.data1';^'
'set newname for datafile '/oracle/AMP/sapdata1/cocoepd_2/cocoepd.data2' to '/oracle/AMQ/sapdata1/cocoepd_2/cocoepd.data2';^'
'set newname for datafile '/oracle/AMP/sapdata1/cocoepd_3/cocoepd.data3' to '/oracle/AMQ/sapdata1/cocoepd_3/cocoepd.data3';^'
'set newname for datafile '/oracle/AMP/sapdata1/cocoepi_1/cocoepi.data1' to '/oracle/AMQ/sapdata1/cocoepi_1/cocoepi.data1';^'
'set newname for datafile '/oracle/AMP/sapdata1/cocoepi_2/cocoepi.data2' to '/oracle/AMQ/sapdata1/cocoepi_2/cocoepi.data2';^'
'set newname for datafile '/oracle/AMP/sapdata1/cocospd_1/cocospd.data1' to '/oracle/AMQ/sapdata1/cocospd_1/cocospd.data1';^'
'set newname for datafile '/oracle/AMP/sapdata1/cocospd_2/cocospd.data2' to '/oracle/AMQ/sapdata1/cocospd_2/cocospd.data2';^'
'set newname for datafile '/oracle/AMP/sapdata1/cocospi_1/cocospi.data1' to '/oracle/AMQ/sapdata1/cocospi_1/cocospi.data1';^'
'set newname for datafile '/oracle/AMP/sapdata1/cocospi_2/cocospi.data2' to '/oracle/AMQ/sapdata1/cocospi_2/cocospi.data2';^'
'set newname for datafile '/oracle/AMP/sapdata1/ddicd_1/ddicd.data1' to '/oracle/AMQ/sapdata1/ddicd_1/ddicd.data1';^'
'set newname for datafile '/oracle/AMP/sapdata1/ddici_1/ddici.data1' to '/oracle/AMQ/sapdata1/ddici_1/ddici.data1';^'
'set newname for datafile '/oracle/AMP/sapdata1/docud_1/docud.data1' to '/oracle/AMQ/sapdata1/docud_1/docud.data1';^'
'set newname for datafile '/oracle/AMP/sapdata1/docui_1/docui.data1' to '/oracle/AMQ/sapdata1/docui_1/docui.data1';^'
'set newname for datafile '/oracle/AMP/sapdata1/el46cd_1/el46cd.data1' to '/oracle/AMQ/sapdata1/el46cd_1/el46cd.data1';^'
'set newname for datafile '/oracle/AMP/sapdata1/el46cd_2/el46cd.data2' to '/oracle/AMQ/sapdata1/el46cd_2/el46cd.data2';^'
'set newname for datafile '/oracle/AMP/sapdata1/el46cd_3/el46cd.data3' to '/oracle/AMQ/sapdata1/el46cd_3/el46cd.data3';^'
'set newname for datafile '/oracle/AMP/sapdata1/el46cd_4/el46cd.data4' to '/oracle/AMQ/sapdata1/el46cd_4/el46cd.data4';^'
'set newname for datafile '/oracle/AMP/sapdata1/el46cd_5/el46cd.data5' to '/oracle/AMQ/sapdata1/el46cd_5/el46cd.data5';^'
'set newname for datafile '/oracle/AMP/sapdata1/el46ci_1/el46ci.data1' to '/oracle/AMQ/sapdata1/el46ci_1/el46ci.data1';^'
'set newname for datafile '/oracle/AMP/sapdata1/es46cd_1/es46cd.data1' to '/oracle/AMQ/sapdata1/es46cd_1/es46cd.data1';^'
'set newname for datafile '/oracle/AMP/sapdata1/es46cd_2/es46cd.data2' to '/oracle/AMQ/sapdata1/es46cd_2/es46cd.data2';^'
'set newname for datafile '/oracle/AMP/sapdata1/es46cd_3/es46cd.data3' to '/oracle/AMQ/sapdata1/es46cd_3/es46cd.data3';^'
'set newname for datafile '/oracle/AMP/sapdata1/es46cd_4/es46cd.data4' to '/oracle/AMQ/sapdata1/es46cd_4/es46cd.data4';^'
'set newname for datafile '/oracle/AMP/sapdata1/es46ci_1/es46ci.data1' to '/oracle/AMQ/sapdata1/es46ci_1/es46ci.data1';^'
'set newname for datafile '/oracle/AMP/sapdata1/es46ci_2/es46ci.data2' to '/oracle/AMQ/sapdata1/es46ci_2/es46ci.data2';^'
'set newname for datafile '/oracle/AMP/sapdata1/fiacctcrd_1/fiacctcrd.data1' to '/oracle/AMQ/sapdata1/fiacctcrd_1/fiacctcrd.data1';^'
'set newname for datafile '/oracle/AMP/sapdata1/fiacctcrd_2/fiacctcrd.data2' to '/oracle/AMQ/sapdata1/fiacctcrd_2/fiacctcrd.data2';^'
'set newname for datafile '/oracle/AMP/sapdata1/fiacctcrd_3/fiacctcrd.data3' to '/oracle/AMQ/sapdata1/fiacctcrd_3/fiacctcrd.data3';^'
'set newname for datafile '/oracle/AMP/sapdata1/fiacctcri_1/fiacctcri.data1' to '/oracle/AMQ/sapdata1/fiacctcri_1/fiacctcri.data1';^'
'set newname for datafile '/oracle/AMP/sapdata1/fiacctcri_2/fiacctcri.data2' to '/oracle/AMQ/sapdata1/fiacctcri_2/fiacctcri.data2';^'
'set newname for datafile '/oracle/AMP/sapdata1/figlpcad_1/figlpcad.data1' to '/oracle/AMQ/sapdata1/figlpcad_1/figlpcad.data1';^'
'set newname for datafile '/oracle/AMP/sapdata1/figlpcad_2/figlpcad.data2' to '/oracle/AMQ/sapdata1/figlpcad_2/figlpcad.data2';^'
'set newname for datafile '/oracle/AMP/sapdata1/figlpcad_3/figlpcad.data3' to '/oracle/AMQ/sapdata1/figlpcad_3/figlpcad.data3';^'
'set newname for datafile '/oracle/AMP/sapdata1/figlpcai_1/figlpcai.data1' to '/oracle/AMQ/sapdata1/figlpcai_1/figlpcai.data1';^'
'set newname for datafile '/oracle/AMP/sapdata1/figlpcai_2/figlpcai.data2' to '/oracle/AMQ/sapdata1/figlpcai_2/figlpcai.data2';^'
'set newname for datafile '/oracle/AMP/sapdata1/loadd_1/loadd.data1' to '/oracle/AMQ/sapdata1/loadd_1/loadd.data1';^'
'set newname for datafile '/oracle/AMP/sapdata1/loadi_1/loadi.data1' to '/oracle/AMQ/sapdata1/loadi_1/loadi.data1';^'
'set newname for datafile '/oracle/AMP/sapdata1/poold_1/poold.data1' to '/oracle/AMQ/sapdata1/poold_1/poold.data1';^'
'set newname for datafile '/oracle/AMP/sapdata1/pooli_1/pooli.data1' to '/oracle/AMQ/sapdata1/pooli_1/pooli.data1';^'
'set newname for datafile '/oracle/AMP/sapdata1/pooli_2/pooli.data2' to '/oracle/AMQ/sapdata1/pooli_2/pooli.data2';^'
'set newname for datafile '/oracle/AMP/sapdata1/ppjestd_1/ppjestd.data1' to '/oracle/AMQ/sapdata1/ppjestd_1/ppjestd.data1';^'
'set newname for datafile '/oracle/AMP/sapdata1/ppjesti_1/ppjesti.data1' to '/oracle/AMQ/sapdata1/ppjesti_1/ppjesti.data1';^'
'set newname for datafile '/oracle/AMP/sapdata1/ppjesti_2/ppjesti.data2' to '/oracle/AMQ/sapdata1/ppjesti_2/ppjesti.data2';^'
'set newname for datafile '/oracle/AMP/sapdata1/ppkbedd_1/ppkbedd.data1' to '/oracle/AMQ/sapdata1/ppkbedd_1/ppkbedd.data1';^'
'set newname for datafile '/oracle/AMP/sapdata1/ppkbedi_1/ppkbedi.data1' to '/oracle/AMQ/sapdata1/ppkbedi_1/ppkbedi.data1';^'
'set newname for datafile '/oracle/AMP/sapdata1/ppmdsmd_1/ppmdsmd.data1' to '/oracle/AMQ/sapdata1/ppmdsmd_1/ppmdsmd.data1';^'
'set newname for datafile '/oracle/AMP/sapdata1/ppmdsmi_1/ppmdsmi.data1' to '/oracle/AMQ/sapdata1/ppmdsmi_1/ppmdsmi.data1';^'
'set newname for datafile '/oracle/AMP/sapdata1/ppmdtbd_1/ppmdtbd.data1' to '/oracle/AMQ/sapdata1/ppmdtbd_1/ppmdtbd.data1';^'
'set newname for datafile '/oracle/AMP/sapdata1/ppmdtbi_1/ppmdtbi.data1' to '/oracle/AMQ/sapdata1/ppmdtbi_1/ppmdtbi.data1';^'
'set newname for datafile '/oracle/AMP/sapdata1/ppmsegd_1/ppmsegd.data1' to '/oracle/AMQ/sapdata1/ppmsegd_1/ppmsegd.data1';^'
'set newname for datafile '/oracle/AMP/sapdata1/ppmsegd_2/ppmsegd.data2' to '/oracle/AMQ/sapdata1/ppmsegd_2/ppmsegd.data2';^'
'set newname for datafile '/oracle/AMP/sapdata1/ppmsegd_3/ppmsegd.data3' to '/oracle/AMQ/sapdata1/ppmsegd_3/ppmsegd.data3';^'
'set newname for datafile '/oracle/AMP/sapdata1/ppmsegi_1/ppmsegi.data1' to '/oracle/AMQ/sapdata1/ppmsegi_1/ppmsegi.data1';^'
'set newname for datafile '/oracle/AMP/sapdata1/ppmsegi_2/ppmsegi.data2' to '/oracle/AMQ/sapdata1/ppmsegi_2/ppmsegi.data2';^'
'set newname for datafile '/oracle/AMP/sapdata1/pppacctitd_1/pppacctitd.data1' to '/oracle/AMQ/sapdata1/pppacctitd_1/pppacctitd.data1';^'
'set newname for datafile '/oracle/AMP/sapdata1/pppacctiti_1/pppacctiti.data1' to '/oracle/AMQ/sapdata1/pppacctiti_1/pppacctiti.data1';^'
'set newname for datafile '/oracle/AMP/sapdata1/ppresbd_1/ppresbd.data1' to '/oracle/AMQ/sapdata1/ppresbd_1/ppresbd.data1';^'
'set newname for datafile '/oracle/AMP/sapdata1/ppresbd_2/ppresbd.data2' to '/oracle/AMQ/sapdata1/ppresbd_2/ppresbd.data2';^'
'set newname for datafile '/oracle/AMP/sapdata1/ppresbi_1/ppresbi.data1' to '/oracle/AMQ/sapdata1/ppresbi_1/ppresbi.data1';^'
'set newname for datafile '/oracle/AMP/sapdata1/pps094d_1/pps094d.data1' to '/oracle/AMQ/sapdata1/pps094d_1/pps094d.data1';^'
'set newname for datafile '/oracle/AMP/sapdata1/pps094i_1/pps094i.data1' to '/oracle/AMQ/sapdata1/pps094i_1/pps094i.data1';^'
'set newname for datafile '/oracle/AMP/sapdata1/protd_1/protd.data1' to '/oracle/AMQ/sapdata1/protd_1/protd.data1';^'
'set newname for datafile '/oracle/AMP/sapdata1/proti_1/proti.data1' to '/oracle/AMQ/sapdata1/proti_1/proti.data1';^'
'set newname for datafile '/oracle/AMP/sapdata1/proti_2/proti.data2' to '/oracle/AMQ/sapdata1/proti_2/proti.data2';^'
'set newname for datafile '/oracle/AMP/sapdata1/sourced_1/sourced.data1' to '/oracle/AMQ/sapdata1/sourced_1/sourced.data1';^'
'set newname for datafile '/oracle/AMP/sapdata1/sourcei_1/sourcei.data1' to '/oracle/AMQ/sapdata1/sourcei_1/sourcei.data1';^'
'set newname for datafile '/oracle/AMP/sapdata1/stabd_1/stabd.data1' to '/oracle/AMQ/sapdata1/stabd_1/stabd.data1';^'
'set newname for datafile '/oracle/AMP/sapdata1/stabd_2/stabd.data2' to '/oracle/AMQ/sapdata1/stabd_2/stabd.data2';^'
'set newname for datafile '/oracle/AMP/sapdata1/stabd_3/stabd.data3' to '/oracle/AMQ/sapdata1/stabd_3/stabd.data3';^'
'set newname for datafile '/oracle/AMP/sapdata1/stabi_1/stabi.data1' to '/oracle/AMQ/sapdata1/stabi_1/stabi.data1';^'
'set newname for datafile '/oracle/AMP/sapdata1/stabi_2/stabi.data2' to '/oracle/AMQ/sapdata1/stabi_2/stabi.data2';^'
'set newname for datafile '/oracle/AMP/sapdata1/stabi_3/stabi.data3' to '/oracle/AMQ/sapdata1/stabi_3/stabi.data3';^'
'set newname for datafile '/oracle/AMP/sapdata1/stabi_4/stabi.data4' to '/oracle/AMQ/sapdata1/stabi_4/stabi.data4';^'
'set newname for datafile '/oracle/AMP/sapdata1/undo_1/undo.data1' to '/oracle/AMQ/sapdata1/undo_1/undo.data1';^'
'set newname for datafile '/oracle/AMP/sapdata1/user1d_1/user1d.data1' to '/oracle/AMQ/sapdata1/user1d_1/user1d.data1';^'
'set newname for datafile '/oracle/AMP/sapdata1/user1i_1/user1i.data1' to '/oracle/AMQ/sapdata1/user1i_1/user1i.data1';^'
'set newname for datafile '/oracle/AMP/sapdata1/sysaux_1/sysaux.data1' to '/oracle/AMQ/sapdata1/sysaux_1/sysaux.data1';^'
'set newname for datafile '/oracle/AMP/sapdata1/system_1/system.data1' to '/oracle/AMQ/sapdata1/system_1/system.data1';^'
'set newname for datafile '/oracle/AMP/sapdata1/system_2/system.data2' to '/oracle/AMQ/sapdata1/system_2/system.data2';^'
'restore datafile 134,121,107,97,125,119,100,103,66,83,104,112,115,40,49,73,102,131,132,136,^'
'133,137,111,110,25,71,23,17,24,26,22,99,106,117,79,118,4,5,6,7,^'
'8,9,10,11,12,13,14,15,16,18,19,20,32,34,36,35,46,37,45,69,^'
'70,56,72,74,91,92,21,41,60,42,77,78,81,80,85,93,86,95,94,96,^'
'98,101,109,113,114,122,120,2,89,84,88,116,90,135,39,64,27,48,30,61,^'
'57,124,129,47,38,58,59,138,87,50,52,105,82,28,1,29,123,108,53,68,^'
'33,51,65,128,75,126,67,127,3,31,43,54,62,76,130,44,55,63 from tag bfavttcd force;^'
'release channel sbt_1;^'
'release channel sbt_2;^'
'release channel sbt_3; }^'
'exit;^'
BR0280I BRRESTORE time stamp: 2019-04-09 06.47.24
BR0279E Return code from 'SHELL=/bin/sh /oracle/AMQ/102_64/bin/rman nocatalog': 1
BR0522E 0 of 138 files / save sets processed by RMAN
BR0536E RMAN call for database instance AMQ failed
BR0280I BRRESTORE time stamp: 2019-04-09 06.47.24
BR0556E Restore from full database backup using RMAN failed
BR0406I End of file restore: rfawiscv.rsb 2019-04-09 06.47.24
BR0280I BRRESTORE time stamp: 2019-04-09 06.47.24
BR0404I BRRESTORE terminated with errors
------------------------------
Prem Singh
------------------------------
Original Message:
Sent: Tue April 09, 2019 12:43 AM
From: Prem Singh
Subject: SAP Restore is failing with unknown reason
Hi ALL,
I am doing a SAP refresh activity, I have taken offline db backup of PRD system and now I am restoring on quality system but facing issue not able to understand where I am going wrong. I have restore the control file from below command.
brrestore -b bfavttcd.ffr -m 0 -r initHebdoAMQrestoreAMP.utl -p initHebdoAMQrestoreAMP.sap- It is restored successfully. now below is the command I am trying to restore the database but getting below error not able to understand if any issue in the switch how control file restore command worked
brrestore -b bfavttcd.ffr -m full -c force initHebdoAMQrestoreAMP.utl -p initHebdoAMQrestoreAMP.sap
BR0401I BRRESTORE 7.20 (18)
BR0154E Unexpected option value 'initHebdoAMQrestoreAMP.utl' found at position 7
BR0406I End of file restore: rfawiqqu.log 2019-04-09 06.30.12
BR0280I BRRESTORE time stamp: 2019-04-09 06.30.12
BR0404I BRRESTORE terminated with errors
After that I have tried any option or command which executed but failing with below error.
I have 2 main confusion here .
1. restore of database SID is coming for quality system itself, it should display PRD SID.
2. What is wrong on 7th line on UTL file why it is reporting error.
UTL FILE-
#--------------------------------------------------------------------------
# Prefix of the 'Backup ID' which will be used for communication with SAPDBA
# and stored in the description field of the Tivoli Storage Manager archive
# function.
# Maximum 6 characters.
# Default: none.
#--------------------------------------------------------------------------
BACKUPIDPREFIX AMP___
#--------------------------------------------------------------------------
# Number of total parallel sessions which will be established by Tivoli Data
# Protection for R/3. Note: this number should correspond with the number
# of simultaneously available tape drives specified for the Tivoli Storage
# Manager server.
# Default: none.
#--------------------------------------------------------------------------
#MAX_SESSIONS 4 # 1 Tivoli Storage Manager client session is default
MAX_SESSIONS 2 # 1 Tivoli Storage Manager client session is default
#--------------------------------------------------------------------------
# Number of parallel sessions which will be established by Tivoli Data
# Protection for R/3 for the database backup.
# Note: this number should correspond with the number of simultaneously
# available tape drives specified for the Tivoli Storage Manager server.
# Default: none.
#--------------------------------------------------------------------------
#MAX_BACK_SESSIONS 2 # 1 Tivoli Storage Manager client session for backup
#--------------------------------------------------------------------------
# Number of parallel sessions which will be established by Tivoli Data
# Protection for R/3 for the archive log backup.
# Note: this number should correspond with the number of simultaneously
# available tape drives specified for the Tivoli Storage Manager server.
# Default: none.
#--------------------------------------------------------------------------
#MAX_ARCH_SESSIONS 1 # 1 Tivoli Storage Manager client session for archive
#--------------------------------------------------------------------------
# Number of parallel sessions which will be established by Tivoli Data
# Protection for R/3 for the restore of files.
# Note: this number should correspond with the number of simultaneously
# available tape drives specified for the Tivoli Storage Manager server.
# Default: none.
#--------------------------------------------------------------------------
#MAX_RESTORE_SESSIONS 1 # 1 Tivoli Storage Manager client session for restore
#--------------------------------------------------------------------------
# Number of backup copies of the archived redo logs.
# Default: 1.
#--------------------------------------------------------------------------
#REDOLOG_COPIES 2 # 1 is default
#--------------------------------------------------------------------------
# Specifies whether Tivoli Data Protection for R/3 should perform a
# null block compression of the data before they are transmitted over the
# network to Tivoli Storage Manager. The null block compression consumes
# only little cpu resources. This compression in Tivoli Data Protection for
# R/3 is independent from the Tivoli Storage Manager compression.
# Do not compress twice !
# Default: NO
#--------------------------------------------------------------------------
#RL_COMPRESSION YES # NO is default
#--------------------------------------------------------------------------
# Specifies how many files are multiplexed into one data stream
# to a Tivoli Storage Manager server. Multiplexing is usefull when the data
# rate to a Tivoli Storage Manager server is higher (fast tapes, fast network)
# than the I/O rate from a single disk.
# The valid range of MULTIPLEXING is from 1 to 8.
# Default: 1 (meaning no multiplexing)
#--------------------------------------------------------------------------
#MULTIPLEXING 2 # 1 is default
#--------------------------------------------------------------------------
# Specifies the block size for disk I/O (in bytes). The valid range is
# from 4 KB to 256 KB.
# The default values have been chosen from our performance experiments in
# standard hardware environments.
# Default: 131072 (128 KB) on UNIX, 32768 (32 KB) on Windows NT.
#--------------------------------------------------------------------------
BUFFSIZE 131072 # block size in bytes
#--------------------------------------------------------------------------
# Name of a program that is called by Tivoli Data Protection for R/3
# before the backup task is started.
# Default: none.
#--------------------------------------------------------------------------
#FRONTEND pgmname parameterlist
#--------------------------------------------------------------------------
# Name of a program that is called by Tivoli Data Protection for R/3
# after the backup task is completed.
# Default: none.
#--------------------------------------------------------------------------
#BACKEND pgmname parameterlist
#--------------------------------------------------------------------------
# Maximum number of data base backup versions to be kept.
# Note: Version control by Tivoli Data Protection for R/3 is only
# activated if the SAP R/3 release is 3.0C and higher and the parameter
# MAX_VERSION is not 0.
# Default: 0.
#--------------------------------------------------------------------------
#MAX_VERSIONS 4
#--------------------------------------------------------------------------
# Batch processing
# Default:
# The default for the BATCH parameter is YES for the backup run and NO for
# the restore run if the BATCH parameter is COMMENTED OUT in this profile.
#--------------------------------------------------------------------------
#BATCH YES # unattended automated operation
#BATCH NO # manual operation
#--------------------------------------------------------------------------
# Control of error situations
# Default: NO.
#--------------------------------------------------------------------------
#EXITONERROR 3 # don't exit if an error occurs
#--------------------------------------------------------------------------
# Control of information for reporting purposes, e.g. messages, statistics.
# Default: NO (no additional data will be reported).
#--------------------------------------------------------------------------
#REPORT NO # no additional messages
#REPORT YES # all additional messages
#REPORT 2 # all additional messages + summary
#--------------------------------------------------------------------------
# Controls generation of a trace file.
# Note: we recommend using the trace function only in cooperation with
# the hotline.
# Default: NO.
#--------------------------------------------------------------------------
#TRACE 100
#--------------------------------------------------------------------------
# Specify the trace file for Tivoli Data Protection for R/3 to store all
# trace information (if TRACE ON), full path and name of file.
# Note: for an actual trace the string '%BID' will be replaced by
# the current backupid.
# (.../backint_%BID.trace changes to .../backint_SAP___9809182300.trace).
# Default: stdout.
#--------------------------------------------------------------------------
#TRACEFILE /oracle/C21/dbs/backint.trace
#TRACEFILE /oracle/C21/dbs/backint_%BID.trace
#--------------------------------------------------------------------------
# Specify the configuration file for Tivoli Data Protection for R/3 to
# store all variable parameters, full path and name of the file.
# Default: none.
#--------------------------------------------------------------------------
CONFIG_FILE /oracle/AMP/102_64/dbs/initHebdoAMQrestoreAMP.bki
#--------------------------------------------------------------------------
# Number of retries to be performed in case of errors when connecting to
# the Tivoli Storage Manager server.
# Default: 3.
#--------------------------------------------------------------------------
#RETRY 5
#--------------------------------------------------------------------------
# Specify time after which a retry has to be performed (seconds).
# Default: 1.
#--------------------------------------------------------------------------
#TCPWAIT 1
#--------------------------------------------------------------------------
# Number of times Tivoli Data Protection for R/3 retries to save/restore
# a file in case an error occurs.
# Default: 3.
#--------------------------------------------------------------------------
#FILE_RETRIES 3
#--------------------------------------------------------------------------
# Shall Tivoli Data Protection for R/3 send error/status information
# to a Tivoli Storage Manager server. The statement for servername must
# match one of the servers listed in a SERVER statement. Statements for
# verbosity can be ERROR, WARNING, or DETAIL.
# Default: none.
#--------------------------------------------------------------------------
#LOG_SERVER servername [verbosity]
#LOG_SERVER server_a ERROR
#--------------------------------------------------------------------------
# Shall Tivoli Data Protection for R/3 send error/status information
# to a network management program via SNMP traps?
# Default: none.
#--------------------------------------------------------------------------
#SNMPTRAP Hostname community level
#SNMPTRAP server_a public detail
#--------------------------------------------------------------------------
# Shall Tivoli Data Protection for R/3 use a manual sorting file for disk
# sorting ?
# Default: none.
#--------------------------------------------------------------------------
#SORT_FILE /oracle/C21/dbs/manual_sort_file
#**************************************************************************
# Statement for multiple Servers and multiple Paths.
# may be used multiple times (one for each server).
#**************************************************************************
SERVER TSM100 # Servername
# SESSIONS 4 # Max sessions
SESSIONS 2 # Max sessions
PASSWORDREQUIRED YES # Use a password
ADSMNODE bcv51s7b_sap # Tivoli Storage Manager Nodename
BRARCHIVEMGTCLASS brarchive_quotidien DUAL_ARCH_DISK # Mgmt-Classes
BRBACKUPMGTCLASS brbackup_hebdo # Mgmt-Classes
#BRARCHIVEMGTCLASS brarchive_hebdo # Mgmt-Classes
#BRBACKUPMGTCLASS brbackup_mensuel # Mgmt-Classes
#BRBACKUPMGTCLASS brbackup_quotidien
# REDOLOG_COPIES 2
# USE_AT 0 1 2 3 4 5 6 # Days for backup
#SERVER server_b # Servername
# SESSIONS 2 # Max sessions
# PASSWORDREQUIRED YES # Use a password
# ADSMNODE NODE # Tivoli Storage Manager Nodename
# BRBACKUPMGTCLASS MDB # Mgmt-Classes
# BRARCHIVEMGTCLASS MLOG1 MLOG2 # Mgmt-Classes
# USE_AT 0 1 2 3 4 5 6 # Days for backup
#**************************************************************************
# USE_AT : 0=Su 1=Mo 2=Tu 3=We 4=Th 5=Fr 6=Sa
# Default: all days
#**************************************************************************
#--------------------------------------------------------------------------
# End of profile
END
initHebdoAMQrestoreAMP.utl: END
------------------------------
Prem Singh
------------------------------