on 09-21-2016 3:33 PM
Hello,
I did an offline backup and when i try to restore in another machine the rman throw the error
unbru33:oratmp 9> brrestore -m all -b beublpss.afr -c
BR0401I BRRESTORE 7.40 (13)
BR0114W Software compression not supported for 'rman_util'
BR0405I Start of file restore: reucozix.rsb 2016-09-21 11:22:51
BR0484I BRRESTORE log file: /oracle/TMP/sapbackup/reucozix.rsb
BR0454W Values of oracle_sid are different: current 'TMP', backup beublpss.afr 'TST'
BR0455W Value 'TMP' of oracle_sid will be used for restore
BR0454W Values of oracle_home are different: current '/oracle/TMP/112_64', backup beublpss.afr '/oracle/TST/112_64'
BR0455W Value '/oracle/TMP/112_64' of oracle_home will be used for restore
BR0454W Values of sapdata_home are different: current '/oracle/TMP', backup beublpss.afr '/oracle/TST'
BR0455W Value '/oracle/TMP' of sapdata_home will be used for restore
BR0453W Error message found in /oracle/TMP/sapbackup/beublpss.afr:
'BR0278E Command output of 'SHELL=/bin/sh /oracle/TST/112_64/bin/rman nocatalog':'
BR0453W Error message found in /oracle/TMP/sapbackup/beublpss.afr:
'BR0279E Return code from 'SHELL=/bin/sh /oracle/TST/112_64/bin/rman nocatalog': 1'
BR0453W Error message found in /oracle/TMP/sapbackup/beublpss.afr:
'BR0503E Normal database backup using RMAN failed'
BR0459W Backup beublpss.afr terminated with errors
BR0280I BRRESTORE time stamp: 2016-09-21 11:22:51
BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRRESTORE:
c
BR0280I BRRESTORE time stamp: 2016-09-21 11:22:52
BR0257I Your reply: 'c'
BR0259I Program execution will be continued...
BR0427I Files from the old sapdata_home /oracle/TST will be restored into the new sapdata_home /oracle/TMP
BR0280I BRRESTORE time stamp: 2016-09-21 11:22:52
BR0407I Restore of database: TMP
BR0408I BRRESTORE action ID: reucozix
BR0409I BRRESTORE function ID: rsb
BR0449I Restore mode: ALL
BR0419I Files will be restored from backup: beublpss.afr 2016-09-15 11:59:22
BR0416I 123 files found to restore, total size 291602.961 MB
BR0424I Files will not be decompressed
BR0421I Restore device type: rman_util
BR0280I BRRESTORE time stamp: 2016-09-21 11:22:52
BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRRESTORE:
c
BR0280I BRRESTORE time stamp: 2016-09-21 11:22:53
BR0257I Your reply: 'c'
BR0259I Program execution will be continued...
BR0126I Unattended mode active - no operator confirmation required
BR0280I BRRESTORE time stamp: 2016-09-21 11:22:53
BR0551I Starting restore from normal database backup using RMAN...
BR0278E Command output of 'SHELL=/bin/sh /oracle/TMP/112_64/bin/rman nocatalog':
Recovery Manager: Release 11.2.0.3.0 - Production on Wed Sep 21 11:22:53 2016
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
RMAN>
RMAN> connect target *
connected to target database: TMP (not mounted)
using target database control file instead of recovery catalog
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>
allocated channel: sbt_1
channel sbt_1: SID=66 device type=SBT_TAPE
channel sbt_1: Data Protection for SAP(R)
allocated channel: sbt_2
channel sbt_2: SID=81 device type=SBT_TAPE
channel sbt_2: Data Protection for SAP(R)
allocated channel: sbt_3
channel sbt_3: SID=98 device type=SBT_TAPE
channel sbt_3: Data Protection for SAP(R)
allocated channel: sbt_4
channel sbt_4: SID=114 device type=SBT_TAPE
channel sbt_4: Data Protection for SAP(R)
allocated channel: sbt_5
channel sbt_5: SID=130 device type=SBT_TAPE
channel sbt_5: Data Protection for SAP(R)
allocated channel: sbt_6
channel sbt_6: SID=146 device type=SBT_TAPE
channel sbt_6: Data Protection for SAP(R)
allocated channel: sbt_7
channel sbt_7: SID=162 device type=SBT_TAPE
channel sbt_7: Data Protection for SAP(R)
allocated channel: sbt_8
channel sbt_8: SID=178 device type=SBT_TAPE
channel sbt_8: Data Protection for SAP(R)
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
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
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
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 2016-09-21 11:22:58
released channel: sbt_1
released channel: sbt_2
released channel: sbt_3
released channel: sbt_4
released channel: sbt_5
released channel: sbt_6
released channel: sbt_7
released channel: sbt_8
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 09/21/2016 11:22:58
ORA-01507: database not mounted
RMAN>
Recovery Manager complete.
BR0280I BRRESTORE time stamp: 2016-09-21 11:22:59
BR0279E Return code from 'SHELL=/bin/sh /oracle/TMP/112_64/bin/rman nocatalog': 1
BR0522E 0 of 123 files / save sets processed by RMAN
BR0536E RMAN call for database instance TMP failed
BR0200I BR_TRACE: location BrRmanCall-62, commands for RMAN in: /oracle/TMP/sapbackup/.reucozix.cmd
@/oracle/TMP/sapbackup/..reucozix..cmd
host '/usr/sap/TMP/SYS/exe/run/brtools -f delete /oracle/TMP/sapbackup/..reucozix..cmd';
run { allocate channel sbt_1 device type 'SBT_TAPE'
parms 'ENV=(XINT_PROFILE=/oracle/TMP/112_64/dbs/initTMP.utl,PROLE_PORT=57323,BR_CALLER=BRRESTORE,BR_BACKUP=ALL,BR_REQUEST=NEW,BR_RUN=reucozix.rsb)';
allocate channel sbt_2 device type 'SBT_TAPE'
parms 'ENV=(XINT_PROFILE=/oracle/TMP/112_64/dbs/initTMP.utl,PROLE_PORT=57323,BR_CALLER=BRRESTORE,BR_BACKUP=ALL,BR_REQUEST=NEW,BR_RUN=reucozix.rsb)';
allocate channel sbt_3 device type 'SBT_TAPE'
parms 'ENV=(XINT_PROFILE=/oracle/TMP/112_64/dbs/initTMP.utl,PROLE_PORT=57323,BR_CALLER=BRRESTORE,BR_BACKUP=ALL,BR_REQUEST=NEW,BR_RUN=reucozix.rsb)';
allocate channel sbt_4 device type 'SBT_TAPE'
parms 'ENV=(XINT_PROFILE=/oracle/TMP/112_64/dbs/initTMP.utl,PROLE_PORT=57323,BR_CALLER=BRRESTORE,BR_BACKUP=ALL,BR_REQUEST=NEW,BR_RUN=reucozix.rsb)';
allocate channel sbt_5 device type 'SBT_TAPE'
parms 'ENV=(XINT_PROFILE=/oracle/TMP/112_64/dbs/initTMP.utl,PROLE_PORT=57323,BR_CALLER=BRRESTORE,BR_BACKUP=ALL,BR_REQUEST=NEW,BR_RUN=reucozix.rsb)';
allocate channel sbt_6 device type 'SBT_TAPE'
parms 'ENV=(XINT_PROFILE=/oracle/TMP/112_64/dbs/initTMP.utl,PROLE_PORT=57323,BR_CALLER=BRRESTORE,BR_BACKUP=ALL,BR_REQUEST=NEW,BR_RUN=reucozix.rsb)';
allocate channel sbt_7 device type 'SBT_TAPE'
parms 'ENV=(XINT_PROFILE=/oracle/TMP/112_64/dbs/initTMP.utl,PROLE_PORT=57323,BR_CALLER=BRRESTORE,BR_BACKUP=ALL,BR_REQUEST=NEW,BR_RUN=reucozix.rsb)';
allocate channel sbt_8 device type 'SBT_TAPE'
parms 'ENV=(XINT_PROFILE=/oracle/TMP/112_64/dbs/initTMP.utl,PROLE_PORT=57323,BR_CALLER=BRRESTORE,BR_BACKUP=ALL,BR_REQUEST=NEW,BR_RUN=reucozix.rsb)';
set newname for datafile '/oracle/TST/sapdata1/btabd_2/btabd.data2' to '/oracle/TMP/sapdata1/btabd_2/btabd.data2';
set newname for datafile '/oracle/TST/sapdata4/btabd_3/btabd.data3' to '/oracle/TMP/sapdata4/btabd_3/btabd.data3';
set newname for datafile '/oracle/TST/sapdata4/btabd_4/btabd.data4' to '/oracle/TMP/sapdata4/btabd_4/btabd.data4';
set newname for datafile '/oracle/TST/sapdata5/btabi_1/btabi.data1' to '/oracle/TMP/sapdata5/btabi_1/btabi.data1';
set newname for datafile '/oracle/TST/sapdata5/btabi_2/btabi.data2' to '/oracle/TMP/sapdata5/btabi_2/btabi.data2';
set newname for datafile '/oracle/TST/sapdata1/clud_1/clud.data1' to '/oracle/TMP/sapdata1/clud_1/clud.data1';
set newname for datafile '/oracle/TST/sapdata1/clud_2/clud.data2' to '/oracle/TMP/sapdata1/clud_2/clud.data2';
set newname for datafile '/oracle/TST/sapdata6/clui_2/clui.data2' to '/oracle/TMP/sapdata6/clui_2/clui.data2';
set newname for datafile '/oracle/TST/sapdata1/ddicd_1/ddicd.data1' to '/oracle/TMP/sapdata1/ddicd_1/ddicd.data1';
set newname for datafile '/oracle/TST/sapdata4/ddicd_2/ddicd.data2' to '/oracle/TMP/sapdata4/ddicd_2/ddicd.data2';
set newname for datafile '/oracle/TST/sapdata4/ddicd_3/ddicd.data3' to '/oracle/TMP/sapdata4/ddicd_3/ddicd.data3';
set newname for datafile '/oracle/TST/sapdata4/ddici_1/ddici.data1' to '/oracle/TMP/sapdata4/ddici_1/ddici.data1';
set newname for datafile '/oracle/TST/sapdata4/ddici_2/ddici.data2' to '/oracle/TMP/sapdata4/ddici_2/ddici.data2';
set newname for datafile '/oracle/TST/sapdata4/ddici_3/ddici.data3' to '/oracle/TMP/sapdata4/ddici_3/ddici.data3';
set newname for datafile '/oracle/TST/sapdata1/dev_1/dev.data1' to '/oracle/TMP/sapdata1/dev_1/dev.data1';
set newname for datafile '/oracle/TST/sapdata1/dev_2/dev.data2' to '/oracle/TMP/sapdata1/dev_2/dev.data2';
set newname for datafile '/oracle/TST/sapdata3/dev_3/dev.data3' to '/oracle/TMP/sapdata3/dev_3/dev.data3';
set newname for datafile '/oracle/TST/sapdata4/dev_4/dev.data4' to '/oracle/TMP/sapdata4/dev_4/dev.data4';
set newname for datafile '/oracle/TST/sapdata5/dev_5/dev.data5' to '/oracle/TMP/sapdata5/dev_5/dev.data5';
set newname for datafile '/oracle/TST/sapdata5/dev_6/dev.data6' to '/oracle/TMP/sapdata5/dev_6/dev.data6';
set newname for datafile '/oracle/TST/sapdata5/dev_7/dev.data7' to '/oracle/TMP/sapdata5/dev_7/dev.data7';
set newname for datafile '/oracle/TST/sapdata6/dev_10/dev.data10' to '/oracle/TMP/sapdata6/dev_10/dev.data10';
set newname for datafile '/oracle/TST/sapdata6/dev_8/dev.data8' to '/oracle/TMP/sapdata6/dev_8/dev.data8';
set newname for datafile '/oracle/TST/sapdata6/dev_9/dev.data9' to '/oracle/TMP/sapdata6/dev_9/dev.data9';
set newname for datafile '/oracle/TST/sapdata2/dev46c_1/dev46c.data1' to '/oracle/TMP/sapdata2/dev46c_1/dev46c.data1';
set newname for datafile '/oracle/TST/sapdata2/dev46c_2/dev46c.data2' to '/oracle/TMP/sapdata2/dev46c_2/dev46c.data2';
set newname for datafile '/oracle/TST/sapdata2/dev46c_3/dev46c.data3' to '/oracle/TMP/sapdata2/dev46c_3/dev46c.data3';
set newname for datafile '/oracle/TST/sapdata3/dev46c_4/dev46c.data4' to '/oracle/TMP/sapdata3/dev46c_4/dev46c.data4';
set newname for datafile '/oracle/TST/sapdata3/dev46c_5/dev46c.data5' to '/oracle/TMP/sapdata3/dev46c_5/dev46c.data5';
set newname for datafile '/oracle/TST/sapdata3/dev46c_6/dev46c.data6' to '/oracle/TMP/sapdata3/dev46c_6/dev46c.data6';
set newname for datafile '/oracle/TST/sapdata4/dev46c_7/dev46c.data7' to '/oracle/TMP/sapdata4/dev46c_7/dev46c.data7';
set newname for datafile '/oracle/TST/sapdata4/dev46c_8/dev46c.data8' to '/oracle/TMP/sapdata4/dev46c_8/dev46c.data8';
set newname for datafile '/oracle/TST/sapdata4/dev46c_9/dev46c.data9' to '/oracle/TMP/sapdata4/dev46c_9/dev46c.data9';
set newname for datafile '/oracle/TST/sapdata1/devusr_1/devusr.data1' to '/oracle/TMP/sapdata1/devusr_1/devusr.data1';
set newname for datafile '/oracle/TST/sapdata4/dimd_1/dimd.data1' to '/oracle/TMP/sapdata4/dimd_1/dimd.data1';
set newname for datafile '/oracle/TST/sapdata4/dimi_1/dimi.data1' to '/oracle/TMP/sapdata4/dimi_1/dimi.data1';
set newname for datafile '/oracle/TST/sapdata1/docud_1/docud.data1' to '/oracle/TMP/sapdata1/docud_1/docud.data1';
set newname for datafile '/oracle/TST/sapdata6/docui_1/docui.data1' to '/oracle/TMP/sapdata6/docui_1/docui.data1';
set newname for datafile '/oracle/TST/sapdata1/el702d_1/el702d.data1' to '/oracle/TMP/sapdata1/el702d_1/el702d.data1';
set newname for datafile '/oracle/TST/sapdata1/el702d_2/el702d.data2' to '/oracle/TMP/sapdata1/el702d_2/el702d.data2';
set newname for datafile '/oracle/TST/sapdata1/el702d_3/el702d.data3' to '/oracle/TMP/sapdata1/el702d_3/el702d.data3';
set newname for datafile '/oracle/TST/sapdata1/el702dx_1/el702dx.data1' to '/oracle/TMP/sapdata1/el702dx_1/el702dx.data1';
set newname for datafile '/oracle/TST/sapdata2/el702i_1/el702i.data1' to '/oracle/TMP/sapdata2/el702i_1/el702i.data1';
set newname for datafile '/oracle/TST/sapdata1/el702ix_1/el702ix.data1' to '/oracle/TMP/sapdata1/el702ix_1/el702ix.data1';
set newname for datafile '/oracle/TST/sapdata2/el740d_1/el740d.data1' to '/oracle/TMP/sapdata2/el740d_1/el740d.data1';
set newname for datafile '/oracle/TST/sapdata2/el740d_2/el740d.data2' to '/oracle/TMP/sapdata2/el740d_2/el740d.data2';
set newname for datafile '/oracle/TST/sapdata2/el740d_3/el740d.data3' to '/oracle/TMP/sapdata2/el740d_3/el740d.data3';
set newname for datafile '/oracle/TST/sapdata2/el740i_1/el740i.data1' to '/oracle/TMP/sapdata2/el740i_1/el740i.data1';
set newname for datafile '/oracle/TST/sapdata2/el740i_2/el740i.data2' to '/oracle/TMP/sapdata2/el740i_2/el740i.data2';
set newname for datafile '/oracle/TST/sapdata4/es702d_1/es702d.data1' to '/oracle/TMP/sapdata4/es702d_1/es702d.data1';
set newname for datafile '/oracle/TST/sapdata6/es702d_2/es702d.data2' to '/oracle/TMP/sapdata6/es702d_2/es702d.data2';
set newname for datafile '/oracle/TST/sapdata1/es702dx_1/es702dx.data1' to '/oracle/TMP/sapdata1/es702dx_1/es702dx.data1';
set newname for datafile '/oracle/TST/sapdata1/es702dx_2/es702dx.data2' to '/oracle/TMP/sapdata1/es702dx_2/es702dx.data2';
set newname for datafile '/oracle/TST/sapdata5/es702i_1/es702i.data1' to '/oracle/TMP/sapdata5/es702i_1/es702i.data1';
set newname for datafile '/oracle/TST/sapdata5/es702i_2/es702i.data2' to '/oracle/TMP/sapdata5/es702i_2/es702i.data2';
set newname for datafile '/oracle/TST/sapdata1/es702ix_1/es702ix.data1' to '/oracle/TMP/sapdata1/es702ix_1/es702ix.data1';
set newname for datafile '/oracle/TST/sapdata4/es740d_1/es740d.data1' to '/oracle/TMP/sapdata4/es740d_1/es740d.data1';
set newname for datafile '/oracle/TST/sapdata4/es740d_2/es740d.data2' to '/oracle/TMP/sapdata4/es740d_2/es740d.data2';
set newname for datafile '/oracle/TST/sapdata3/es740i_3/es740i.data3' to '/oracle/TMP/sapdata3/es740i_3/es740i.data3';
set newname for datafile '/oracle/TST/sapdata4/es740i_1/es740i.data1' to '/oracle/TMP/sapdata4/es740i_1/es740i.data1';
set newname for datafile '/oracle/TST/sapdata4/es740i_2/es740i.data2' to '/oracle/TMP/sapdata4/es740i_2/es740i.data2';
set newname for datafile '/oracle/TST/sapdata4/factd_1/factd.data1' to '/oracle/TMP/sapdata4/factd_1/factd.data1';
set newname for datafile '/oracle/TST/sapdata4/facti_1/facti.data1' to '/oracle/TMP/sapdata4/facti_1/facti.data1';
set newname for datafile '/oracle/TST/sapdata1/loadd_1/loadd.data1' to '/oracle/TMP/sapdata1/loadd_1/loadd.data1';
set newname for datafile '/oracle/TST/sapdata1/loadd_2/loadd.data2' to '/oracle/TMP/sapdata1/loadd_2/loadd.data2';
set newname for datafile '/oracle/TST/sapdata1/loadd_3/loadd.data3' to '/oracle/TMP/sapdata1/loadd_3/loadd.data3';
set newname for datafile '/oracle/TST/sapdata1/loadi_1/loadi.data1' to '/oracle/TMP/sapdata1/loadi_1/loadi.data1';
set newname for datafile '/oracle/TST/sapdata1/loadi_2/loadi.data2' to '/oracle/TMP/sapdata1/loadi_2/loadi.data2';
set newname for datafile '/oracle/TST/sapdata4/odsd_1/odsd.data1' to '/oracle/TMP/sapdata4/odsd_1/odsd.data1';
set newname for datafile '/oracle/TST/sapdata4/odsi_1/odsi.data1' to '/oracle/TMP/sapdata4/odsi_1/odsi.data1';
set newname for datafile '/oracle/TST/sapdata4/poold_2/poold.data2' to '/oracle/TMP/sapdata4/poold_2/poold.data2';
set newname for datafile '/oracle/TST/sapdata4/poold_3/poold.data3' to '/oracle/TMP/sapdata4/poold_3/poold.data3';
set newname for datafile '/oracle/TST/sapdata4/poold_4/poold.data4' to '/oracle/TMP/sapdata4/poold_4/poold.data4';
set newname for datafile '/oracle/TST/sapdata4/poold_5/poold.data5' to '/oracle/TMP/sapdata4/poold_5/poold.data5';
set newname for datafile '/oracle/TST/sapdata4/poold_6/poold.data6' to '/oracle/TMP/sapdata4/poold_6/poold.data6';
set newname for datafile '/oracle/TST/sapdata6/poold_1/poold.data1' to '/oracle/TMP/sapdata6/poold_1/poold.data1';
set newname for datafile '/oracle/TST/sapdata1/pooli_2/pooli.data2' to '/oracle/TMP/sapdata1/pooli_2/pooli.data2';
set newname for datafile '/oracle/TST/sapdata4/pooli_3/pooli.data3' to '/oracle/TMP/sapdata4/pooli_3/pooli.data3';
set newname for datafile '/oracle/TST/sapdata4/pooli_4/pooli.data4' to '/oracle/TMP/sapdata4/pooli_4/pooli.data4';
set newname for datafile '/oracle/TST/sapdata4/pooli_5/pooli.data5' to '/oracle/TMP/sapdata4/pooli_5/pooli.data5';
set newname for datafile '/oracle/TST/sapdata1/protd_1/protd.data1' to '/oracle/TMP/sapdata1/protd_1/protd.data1';
set newname for datafile '/oracle/TST/sapdata4/protd_2/protd.data2' to '/oracle/TMP/sapdata4/protd_2/protd.data2';
set newname for datafile '/oracle/TST/sapdata4/protd_3/protd.data3' to '/oracle/TMP/sapdata4/protd_3/protd.data3';
set newname for datafile '/oracle/TST/sapdata4/protd_4/protd.data4' to '/oracle/TMP/sapdata4/protd_4/protd.data4';
set newname for datafile '/oracle/TST/sapdata6/proti_1/proti.data1' to '/oracle/TMP/sapdata6/proti_1/proti.data1';
set newname for datafile '/oracle/TST/sapdata6/proti_2/proti.data2' to '/oracle/TMP/sapdata6/proti_2/proti.data2';
set newname for datafile '/oracle/TST/sapdata6/proti_3/proti.data3' to '/oracle/TMP/sapdata6/proti_3/proti.data3';
set newname for datafile '/oracle/TST/sapdata1/sourced_1/sourced.data1' to '/oracle/TMP/sapdata1/sourced_1/sourced.data1';
set newname for datafile '/oracle/TST/sapdata4/sourced_2/sourced.data2' to '/oracle/TMP/sapdata4/sourced_2/sourced.data2';
set newname for datafile '/oracle/TST/sapdata4/sourced_3/sourced.data3' to '/oracle/TMP/sapdata4/sourced_3/sourced.data3';
set newname for datafile '/oracle/TST/sapdata4/sourced_4/sourced.data4' to '/oracle/TMP/sapdata4/sourced_4/sourced.data4';
set newname for datafile '/oracle/TST/sapdata4/sourced_5/sourced.data5' to '/oracle/TMP/sapdata4/sourced_5/sourced.data5';
set newname for datafile '/oracle/TST/sapdata4/sourced_6/sourced.data6' to '/oracle/TMP/sapdata4/sourced_6/sourced.data6';
set newname for datafile '/oracle/TST/sapdata4/sourcei_1/sourcei.data1' to '/oracle/TMP/sapdata4/sourcei_1/sourcei.data1';
set newname for datafile '/oracle/TST/sapdata4/sourcei_2/sourcei.data2' to '/oracle/TMP/sapdata4/sourcei_2/sourcei.data2';
set newname for datafile '/oracle/TST/sapdata4/sourcei_3/sourcei.data3' to '/oracle/TMP/sapdata4/sourcei_3/sourcei.data3';
set newname for datafile '/oracle/TST/sapdata4/sourcei_4/sourcei.data4' to '/oracle/TMP/sapdata4/sourcei_4/sourcei.data4';
set newname for datafile '/oracle/TST/sapdata5/sourcei_5/sourcei.data5' to '/oracle/TMP/sapdata5/sourcei_5/sourcei.data5';
set newname for datafile '/oracle/TST/sapdata5/sourcei_6/sourcei.data6' to '/oracle/TMP/sapdata5/sourcei_6/sourcei.data6';
set newname for datafile '/oracle/TST/sapdata1/sr3usr_1/sr3usr.data1' to '/oracle/TMP/sapdata1/sr3usr_1/sr3usr.data1';
set newname for datafile '/oracle/TST/sapdata1/stabd_4/stabd.data4' to '/oracle/TMP/sapdata1/stabd_4/stabd.data4';
set newname for datafile '/oracle/TST/sapdata1/stabd_5/stabd.data5' to '/oracle/TMP/sapdata1/stabd_5/stabd.data5';
set newname for datafile '/oracle/TST/sapdata1/stabd_6/stabd.data6' to '/oracle/TMP/sapdata1/stabd_6/stabd.data6';
set newname for datafile '/oracle/TST/sapdata1/stabd_7/stabd.data7' to '/oracle/TMP/sapdata1/stabd_7/stabd.data7';
set newname for datafile '/oracle/TST/sapdata4/stabd_1/stabd.data1' to '/oracle/TMP/sapdata4/stabd_1/stabd.data1';
set newname for datafile '/oracle/TST/sapdata4/stabd_2/stabd.data2' to '/oracle/TMP/sapdata4/stabd_2/stabd.data2';
set newname for datafile '/oracle/TST/sapdata4/stabd_3/stabd.data3' to '/oracle/TMP/sapdata4/stabd_3/stabd.data3';
set newname for datafile '/oracle/TST/sapdata1/stabi_4/stabi.data4' to '/oracle/TMP/sapdata1/stabi_4/stabi.data4';
set newname for datafile '/oracle/TST/sapdata1/stabi_5/stabi.data5' to '/oracle/TMP/sapdata1/stabi_5/stabi.data5';
set newname for datafile '/oracle/TST/sapdata1/stabi_6/stabi.data6' to '/oracle/TMP/sapdata1/stabi_6/stabi.data6';
set newname for datafile '/oracle/TST/sapdata4/stabi_3/stabi.data3' to '/oracle/TMP/sapdata4/stabi_3/stabi.data3';
set newname for datafile '/oracle/TST/sapdata6/stabi_2/stabi.data2' to '/oracle/TMP/sapdata6/stabi_2/stabi.data2';
set newname for datafile '/oracle/TST/sapdata5/stabi_1/stabi.data1' to '/oracle/TMP/sapdata5/stabi_1/stabi.data1';
set newname for datafile '/oracle/TST/sapdata1/roll_1/roll.data1' to '/oracle/TMP/sapdata1/roll_1/roll.data1';
set newname for datafile '/oracle/TST/sapdata2/undo_1/undo.data1' to '/oracle/TMP/sapdata2/undo_1/undo.data1';
set newname for datafile '/oracle/TST/sapdata1/user1d_1/user1d.data1' to '/oracle/TMP/sapdata1/user1d_1/user1d.data1';
set newname for datafile '/oracle/TST/sapdata6/user1i_1/user1i.data1' to '/oracle/TMP/sapdata6/user1i_1/user1i.data1';
set newname for datafile '/oracle/TST/sapdata1/sysaux_1/sysaux.data1' to '/oracle/TMP/sapdata1/sysaux_1/sysaux.data1';
set newname for datafile '/oracle/TST/sapdata2/system_4/sysaux04.dbf' to '/oracle/TMP/sapdata2/system_4/sysaux04.dbf';
set newname for datafile '/oracle/TST/sapdata2/system_5/sysaux05.dbf' to '/oracle/TMP/sapdata2/system_5/sysaux05.dbf';
set newname for datafile '/oracle/TST/sapdata1/system_1/system.data1' to '/oracle/TMP/sapdata1/system_1/system.data1';
set newname for datafile '/oracle/TST/sapdata1/system_3/system.data3' to '/oracle/TMP/sapdata1/system_3/system.data3';
set newname for datafile '/oracle/TST/sapdata1/system_4/system.data4' to '/oracle/TMP/sapdata1/system_4/system.data4';
restore datafile 86,84,63,85,73,107,27,109,61,108,2,70,46,52,123,110,43,87,90,42,
65,79,28,89,33,64,44,71,78,62,92,54,49,69,67,25,80,68,4,8,
9,11,12,15,14,17,18,20,21,120,119,5,94,122,75,39,76,93,77,41,
7,10,88,102,24,95,104,74,48,16,30,13,50,121,114,6,96,97,103,113,
37,116,115,1,72,81,82,98,34,45,99,91,101,100,35,40,66,29,51,53,
105,106,111,117,112,57,118,58,55,56,59,60,3,47,36,26,83,22,19,23,
31,32,38 from tag beublpss force;
release channel sbt_1;
release channel sbt_2;
release channel sbt_3;
release channel sbt_4;
release channel sbt_5;
release channel sbt_6;
release channel sbt_7;
release channel sbt_8; }
exit;
BR0280I BRRESTORE time stamp: 2016-09-21 11:22:59
BR0553E Restore from normal database backup using RMAN failed
BR0406I End of file restore: reucozix.rsb 2016-09-21 11:22:59
BR0280I BRRESTORE time stamp: 2016-09-21 11:22:59
BR0404I BRRESTORE terminated with errors
Please, Can you help me?
Thank you
Denis
Hello,
Now i have the error
released channel: sbt_1
released channel: sbt_2
released channel: sbt_3
released channel: sbt_4
released channel: sbt_5
released channel: sbt_6
released channel: sbt_7
released channel: sbt_8
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 09/21/2016 14:33:45
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 38 found to restore
RMAN-06023: no backup or copy of datafile 32 found to restore
RMAN-06023: no backup or copy of datafile 31 found to restore
RMAN-06023: no backup or copy of datafile 23 found to restore
RMAN-06023: no backup or copy of datafile 19 found to restore
Please, can you help me?
Thank you
Denis
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Gomes,
If you are doing backup and restore system copy one machine to another using rman, then database should mount in target. So, in our case copy you are trying to restore the system with same control file in target. To fix the issur copy the control file from source to target and created the soft-link under dir "/oracle/SID(SRG) --> SID(TRG) and start the database in mount mode. then try to execute the brestore with RMAN command.
Thanks,
BM
User | Count |
---|---|
87 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.