HI all ,
i have oracle 11g ASM RAC under OEL 5.6 and for backup purposes i use HP DATA Protector and i want to restore this backup
to different server and the restore is done but please check the below :
run {
allocate channel 'dev_0' type 'sbt_tape'
parms
'SBT_LIBRARY=/opt/omni/lib/libob2oracle8_64bit.so,ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=MEDI,OB2BARLIST=Mediation DB Whole Online - Archive Delete)'
;
set newname for datafile 1 to '/u01/app/oracle/oradata/MEDI/system.dbf';
set newname for datafile 3 to '/u01/app/oracle/oradata/MEDI/undotbs01.dbf';
set newname for datafile 4 to '/u01/app/oracle/oradata/MEDI/undotbs02.dbf';
set newname for datafile 2 to '/u01/app/oracle/oradata/MEDI/sysaux01.dbf';
set newname for datafile 5 to '/u01/app/oracle/oradata/MEDI/users.dbf';
set newname for datafile 6 to '/u01/app/oracle/oradata/MEDI/abs_mid1.dbf';
set newname for datafile 7 to '/u01/app/oracle/oradata/MEDI/abs_mid_ind1.dbf';
set newname for datafile 8 to '/u01/app/oracle/oradata/MEDI/abs_mid2.dbf';
set newname for datafile 9 to '/u01/app/oracle/oradata/MEDI/abs_mid_ind2';
set newname for datafile 10 to '/u01/app/oracle/oradata/MEDI/abs_mid3.dbf';
set newname for datafile 11 to '/u01/app/oracle/oradata/MEDI/abs_mid_ind3.dbf';
set newname for datafile 12 to '/u01/app/oracle/oradata/MEDI/abs_mid4.dbf';
set newname for datafile 13 to '/u01/app/oracle/oradata/MEDI/abs_mid5.dbf';
set newname for datafile 14 to '/u01/app/oracle/oradata/MEDI/abs_mid6.dbf';
set newname for datafile 15 to '/u01/app/oracle/oradata/MEDI/abs_mid7.dbf';
set newname for datafile 16 to '/u01/app/oracle/oradata/MEDI/abs_mid8.dbf';
set newname for datafile 17 to '/u01/app/oracle/oradata/MEDI/abs_mid9.dbf';
set newname for datafile 18 to '/u01/app/oracle/oradata/MEDI/abs_mid10.dbf';
set newname for datafile 19 to '/u01/app/oracle/oradata/MEDI/abs_mid11.dbf';
set newname for datafile 20 to '/u01/app/oracle/oradata/MEDI/abs_mid12.dbf';
set newname for datafile 21 to '/u01/app/oracle/oradata/MEDI/abs_mid13.dbf';
set newname for datafile 22 to '/u01/app/oracle/oradata/MEDI/abs_mid14.dbf';
set newname for datafile 23 to '/u01/app/oracle/oradata/MEDI/abs_mid15.dbf';
set newname for datafile 24 to '/u01/app/oracle/oradata/MEDI/abs_mid16.dbf';
set newname for datafile 25 to '/u01/app/oracle/oradata/MEDI/abs_mid17.dbf';
set newname for datafile 26 to '/u01/app/oracle/oradata/MEDI/abs_mid18.dbf';
set newname for datafile 27 to '/u01/app/oracle/oradata/MEDI/abs_mid19.dbf';
set newname for datafile 28 to '/u01/app/oracle/oradata/MEDI/abs_mid20.dbf';
set newname for datafile 29 to '/u01/app/oracle/oradata/MEDI/abs_mid21.dbf';
set newname for datafile 30 to '/u01/app/oracle/oradata/MEDI/abs_mid22.dbf';
set newname for datafile 31 to '/u01/app/oracle/oradata/MEDI/abs_mid23.dbf';
set newname for datafile 32 to '/u01/app/oracle/oradata/MEDI/abs_mid24.dbf';
set newname for datafile 33 to '/u01/app/oracle/oradata/MEDI/abs_mid25.dbf';
set newname for datafile 34 to '/u01/app/oracle/oradata/MEDI/abs_mid26.dbf';
set newname for datafile 35 to '/u01/app/oracle/oradata/MEDI/abs_mid27.dbf';
set newname for datafile 36 to '/u01/app/oracle/oradata/MEDI/abs_mid28.dbf';
set newname for datafile 37 to '/u01/app/oracle/oradata/MEDI/abs_mid29.dbf';
set newname for datafile 38 to '/u01/app/oracle/oradata/MEDI/abs_mid30.dbf';
set newname for datafile 39 to '/u01/app/oracle/oradata/MEDI/undotbs2011.dbf';
set newname for datafile 40 to '/u01/app/oracle/oradata/MEDI/undotbs2012.dbf';
set newname for datafile 41 to '/u01/app/oracle/oradata/MEDI/undotbs111.dbf';
set newname for datafile 42 to '/u01/app/oracle/oradata/MEDI/undotbs112.dbf';
set newname for datafile 43 to '/u01/app/oracle/oradata/MEDI/undotbs113.dbf';
set newname for datafile 44 to '/u01/app/oracle/oradata/MEDI/abs_mid31.dbf';
set newname for datafile 45 to '/u01/app/oracle/oradata/MEDI/abs_mid32.dbf';
set newname for datafile 46 to '/u01/app/oracle/oradata/MEDI/abs_mid33.dbf';
set newname for datafile 47 to '/u01/app/oracle/oradata/MEDI/undotbs20121.dbf';
set newname for datafile 48 to '/u01/app/oracle/oradata/MEDI/abs_mid34.dbf';
set newname for datafile 49 to '/u01/app/oracle/oradata/MEDI/abs_mid35.dbf';
set newname for datafile 50 to '/u01/app/oracle/oradata/MEDI/abs_mid36.dbf';
set newname for datafile 51 to '/u01/app/oracle/oradata/MEDI/abs_mid37.dbf';
set newname for datafile 52 to '/u01/app/oracle/oradata/MEDI/abs_mid38.dbf';
set newname for datafile 53 to '/u01/app/oracle/oradata/MEDI/abs_mid38.dbf';
set newname for datafile 54 to '/u01/app/oracle/oradata/MEDI/abs_mid39.dbf';
RESTORE DATABASE;
SWITCH DATAFILE ALL;
RECOVER DATABASE;
}
using target database control file instead of recovery catalog
allocated channel: dev_0
channel dev_0: SID=68 device type=SBT_TAPE
channel dev_0: Data Protector A.06.11/243
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 14-MAY-13
channel dev_0: starting datafile backup set restore
channel dev_0: specifying datafile(s) to restore from backup set
channel dev_0: restoring datafile 00001 to /u01/app/oracle/oradata/MEDI/system.dbf
channel dev_0: restoring datafile 00002 to /u01/app/oracle/oradata/MEDI/sysaux01.dbf
channel dev_0: restoring datafile 00003 to /u01/app/oracle/oradata/MEDI/undotbs01.dbf
channel dev_0: restoring datafile 00004 to /u01/app/oracle/oradata/MEDI/undotbs02.dbf
channel dev_0: restoring datafile 00005 to /u01/app/oracle/oradata/MEDI/users.dbf
channel dev_0: restoring datafile 00006 to /u01/app/oracle/oradata/MEDI/abs_mid1.dbf
channel dev_0: restoring datafile 00007 to /u01/app/oracle/oradata/MEDI/abs_mid_ind1.dbf
channel dev_0: restoring datafile 00008 to /u01/app/oracle/oradata/MEDI/abs_mid2.dbf
channel dev_0: restoring datafile 00009 to /u01/app/oracle/oradata/MEDI/abs_mid_ind2
channel dev_0: restoring datafile 00010 to /u01/app/oracle/oradata/MEDI/abs_mid3.dbf
channel dev_0: restoring datafile 00011 to /u01/app/oracle/oradata/MEDI/abs_mid_ind3.dbf
channel dev_0: restoring datafile 00012 to /u01/app/oracle/oradata/MEDI/abs_mid4.dbf
channel dev_0: restoring datafile 00013 to /u01/app/oracle/oradata/MEDI/abs_mid5.dbf
channel dev_0: restoring datafile 00014 to /u01/app/oracle/oradata/MEDI/abs_mid6.dbf
channel dev_0: restoring datafile 00015 to /u01/app/oracle/oradata/MEDI/abs_mid7.dbf
channel dev_0: restoring datafile 00016 to /u01/app/oracle/oradata/MEDI/abs_mid8.dbf
channel dev_0: restoring datafile 00017 to /u01/app/oracle/oradata/MEDI/abs_mid9.dbf
channel dev_0: restoring datafile 00018 to /u01/app/oracle/oradata/MEDI/abs_mid10.dbf
channel dev_0: restoring datafile 00019 to /u01/app/oracle/oradata/MEDI/abs_mid11.dbf
channel dev_0: restoring datafile 00020 to /u01/app/oracle/oradata/MEDI/abs_mid12.dbf
channel dev_0: restoring datafile 00021 to /u01/app/oracle/oradata/MEDI/abs_mid13.dbf
channel dev_0: restoring datafile 00022 to /u01/app/oracle/oradata/MEDI/abs_mid14.dbf
channel dev_0: restoring datafile 00023 to /u01/app/oracle/oradata/MEDI/abs_mid15.dbf
channel dev_0: restoring datafile 00024 to /u01/app/oracle/oradata/MEDI/abs_mid16.dbf
channel dev_0: restoring datafile 00025 to /u01/app/oracle/oradata/MEDI/abs_mid17.dbf
channel dev_0: restoring datafile 00026 to /u01/app/oracle/oradata/MEDI/abs_mid18.dbf
channel dev_0: restoring datafile 00027 to /u01/app/oracle/oradata/MEDI/abs_mid19.dbf
channel dev_0: restoring datafile 00028 to /u01/app/oracle/oradata/MEDI/abs_mid20.dbf
channel dev_0: restoring datafile 00029 to /u01/app/oracle/oradata/MEDI/abs_mid21.dbf
channel dev_0: restoring datafile 00030 to /u01/app/oracle/oradata/MEDI/abs_mid22.dbf
channel dev_0: restoring datafile 00031 to /u01/app/oracle/oradata/MEDI/abs_mid23.dbf
channel dev_0: restoring datafile 00032 to /u01/app/oracle/oradata/MEDI/abs_mid24.dbf
channel dev_0: restoring datafile 00033 to /u01/app/oracle/oradata/MEDI/abs_mid25.dbf
channel dev_0: restoring datafile 00034 to /u01/app/oracle/oradata/MEDI/abs_mid26.dbf
channel dev_0: restoring datafile 00035 to /u01/app/oracle/oradata/MEDI/abs_mid27.dbf
channel dev_0: restoring datafile 00036 to /u01/app/oracle/oradata/MEDI/abs_mid28.dbf
channel dev_0: restoring datafile 00037 to /u01/app/oracle/oradata/MEDI/abs_mid29.dbf
channel dev_0: restoring datafile 00038 to /u01/app/oracle/oradata/MEDI/abs_mid30.dbf
channel dev_0: restoring datafile 00039 to /u01/app/oracle/oradata/MEDI/undotbs2011.dbf
channel dev_0: restoring datafile 00040 to /u01/app/oracle/oradata/MEDI/undotbs2012.dbf
channel dev_0: restoring datafile 00041 to /u01/app/oracle/oradata/MEDI/undotbs111.dbf
channel dev_0: restoring datafile 00042 to /u01/app/oracle/oradata/MEDI/undotbs112.dbf
channel dev_0: restoring datafile 00043 to /u01/app/oracle/oradata/MEDI/undotbs113.dbf
channel dev_0: restoring datafile 00044 to /u01/app/oracle/oradata/MEDI/abs_mid31.dbf
channel dev_0: restoring datafile 00045 to /u01/app/oracle/oradata/MEDI/abs_mid32.dbf
channel dev_0: restoring datafile 00046 to /u01/app/oracle/oradata/MEDI/abs_mid33.dbf
channel dev_0: restoring datafile 00047 to /u01/app/oracle/oradata/MEDI/undotbs20121.dbf
channel dev_0: restoring datafile 00048 to /u01/app/oracle/oradata/MEDI/abs_mid34.dbf
channel dev_0: restoring datafile 00049 to /u01/app/oracle/oradata/MEDI/abs_mid35.dbf
channel dev_0: restoring datafile 00050 to /u01/app/oracle/oradata/MEDI/abs_mid36.dbf
channel dev_0: restoring datafile 00051 to /u01/app/oracle/oradata/MEDI/abs_mid37.dbf
channel dev_0: restoring datafile 00052 to /u01/app/oracle/oradata/MEDI/abs_mid38.dbf
channel dev_0: restoring datafile 00053 to /u01/app/oracle/oradata/MEDI/abs_mid38.dbf
channel dev_0: restoring datafile 00054 to /u01/app/oracle/oradata/MEDI/abs_mid39.dbf
channel dev_0: reading from backup piece Mediation Node01 - Archive_Control<MEDI_5209:815281228:1>.dbf
channel dev_0: piece handle=Mediation Node01 - Archive_Control<MEDI_5209:815281228:1>.dbf tag=TAG20130513T030027
channel dev_0: restored backup piece 1
channel dev_0: restore complete, elapsed time: 02:39:06
Finished restore at 14-MAY-13
released channel: dev_0
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of switch command at 05/14/2013 11:26:51
ORA-19563: header validation failed for file
RMAN> run {
allocate channel 'dev_0' type 'sbt_tape'
parms
'SBT_LIBRARY=/opt/omni/lib/libob2oracle8_64bit.so,ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=MEDI,OB2BARLIST=Mediation DB Whole Online - Archive Delete)'
;2> 3> 4> 5>
6> recover database;
7> }
allocated channel: dev_0
channel dev_0: SID=68 device type=SBT_TAPE
channel dev_0: Data Protector A.06.11/243
Starting recover at 14-MAY-13
released channel: dev_0
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 05/14/2013 11:40:14
RMAN-06094: datafile 1 must be restored
RMAN> alter database open;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 05/14/2013 11:40:23
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
RMAN> alter database open resetlogs;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 05/14/2013 11:40:31
ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
ORA-01110: data file 1: '+DATA/medi/datafile/system.294.815123359'
RMAN>
i see the datafile still in +DATA not switch in controlfile but in /u01/app/oracle/oradata/MEDI all the file is here but the set newname is not works ?
please any suggestion ?