Pessoal, preciso de ajuda, mas acho que estou quase lá. Fiz o seguinte procedimento para o teste de restore do meu backup de produção em outro servidor:
Disponibilizei os backups do banco de dados target Configurei o ORACLE_SID no oradell03. % export ORACLE_SID=PD01 Iniciar o RMAN e conectar á target instance sem se conectar ao catálogo. % rman TARGET / NOCATALOG Iniciei a instância sem montá-la. Executei SET DBID para setar o DBID, então STARTUP NOMOUNT: SET DBID 4238933412; (obtido pela v$database no source) STARTUP FORCE NOMOUNT PFILE=initPD01.ora Criei o SPFILE a partir do PFILE: RMAN> SQL 'CREATE SPFILE FROM PFILE'; Recriei o controlfile para o FS no banco de origem: alter database backup controlfile to '/mnt/oradell03/u02/control_01.ctl'; Movi o controlfile para o novo banco (/u02/oradata/teste) Restaurei o controlfile RMAN> restore controlfile from '/u02/oradata/teste/control_01.ctl'; Montei o banco de dados: RMAN> alter database mount; Consultei os filenames do banco origem e montei script com SET NEWFILE (abaixo). Restore e recover do banco de dados com o script abaixo (recover.rcv): RUN { # allocate channels to the disk device ALLOCATE CHANNEL c1 DEVICE TYPE disk format '/u02/bkp/db_pd01_%d_%s_%p%U. bkp'; ALLOCATE CHANNEL c2 DEVICE TYPE disk format '/u02/bkp/db_pd01_%d_%s_%p%U.bkp'; ALLOCATE CHANNEL c3 DEVICE TYPE disk format '/u02/bkp/db_pd01_%d_%s_%p%U.bkp'; # rename the datafiles and online redo logs SET NEWNAME FOR DATAFILE 1 TO '/u02/oradata/teste/system01.dbf'; SET NEWNAME FOR DATAFILE 2 TO '/u02/oradata/teste/undotbs01.dbf'; SET NEWNAME FOR DATAFILE 3 TO '/u02/oradata/teste/sysaux01.dbf'; SET NEWNAME FOR DATAFILE 4 TO '/u02/oradata/teste/users01.dbf'; SET NEWNAME FOR DATAFILE 5 TO '/u02/oradata/teste/drsys01.dbf'; SET NEWNAME FOR DATAFILE 6 TO '/u02/oradata/teste/ifsdados01.dbf'; SET NEWNAME FOR DATAFILE 7 TO '/u02/oradata/teste/ifsindex01.dbf'; SET NEWNAME FOR DATAFILE 8 TO '/u02/oradata/teste/pergaindex01.dbf'; SET NEWNAME FOR DATAFILE 9 TO '/u02/oradata/teste/pergamarc01.dbf'; SET NEWNAME FOR DATAFILE 10 TO '/u02/oradata/teste/tsdatasual01.dbf'; SET NEWNAME FOR DATAFILE 11 TO '/u02/oradata/teste/tsd_faep01.dbf'; SET NEWNAME FOR DATAFILE 12 TO '/u02/oradata/teste/tsdhd01.dbf'; SET NEWNAME FOR DATAFILE 13 TO '/u02/oradata/teste/tsdintegra01.dbf'; SET NEWNAME FOR DATAFILE 14 TO '/u02/oradata/teste/tsdintranet01.dbf'; SET NEWNAME FOR DATAFILE 15 TO '/u02/oradata/teste/tsdlbv01.dbf'; SET NEWNAME FOR DATAFILE 16 TO '/u02/oradata/teste/tsdmacchips01.dbf'; SET NEWNAME FOR DATAFILE 17 TO '/u02/oradata/teste/tsdmra01.dbf'; SET NEWNAME FOR DATAFILE 18 TO '/u02/oradata/teste/tsdpleres01.dbf'; SET NEWNAME FOR DATAFILE 19 TO '/u02/oradata/teste/tsdsca01.dbf'; SET NEWNAME FOR DATAFILE 20 TO '/u02/oradata/teste/tsdscv01.dbf'; SET NEWNAME FOR DATAFILE 21 TO '/u02/oradata/teste/tsdsisp01.dbf'; SET NEWNAME FOR DATAFILE 22 TO '/u02/oradata/teste/tsdsiss01.dbf'; SET NEWNAME FOR DATAFILE 23 TO '/u02/oradata/teste/tsdsomec01.dbf'; SET NEWNAME FOR DATAFILE 24 TO '/u02/oradata/teste/tsifaep01.dbf'; SET NEWNAME FOR DATAFILE 25 TO '/u02/oradata/teste/tsihd01.dbf'; SET NEWNAME FOR DATAFILE 26 TO '/u02/oradata/teste/tsiintegra01.dbf'; SET NEWNAME FOR DATAFILE 27 TO '/u02/oradata/teste/tsiintranet01.dbf'; SET NEWNAME FOR DATAFILE 28 TO '/u02/oradata/teste/tsilbv01.dbf'; SET NEWNAME FOR DATAFILE 29 TO '/u02/oradata/teste/tsimacchips01.dbf'; SET NEWNAME FOR DATAFILE 30 TO '/u02/oradata/teste/tsimra01.dbf'; SET NEWNAME FOR DATAFILE 31 TO '/u02/oradata/teste/tsindexsual01.dbf'; SET NEWNAME FOR DATAFILE 32 TO '/u02/oradata/teste/tsipleres01.dbf'; SET NEWNAME FOR DATAFILE 33 TO '/u02/oradata/teste/tsisca01.dbf'; SET NEWNAME FOR DATAFILE 34 TO '/u02/oradata/teste/tsiscv01.dbf'; SET NEWNAME FOR DATAFILE 35 TO '/u02/oradata/teste/tsisisp01.dbf'; SET NEWNAME FOR DATAFILE 36 TO '/u02/oradata/teste/tsisomec01.dbf'; SET NEWNAME FOR DATAFILE 37 TO '/u02/oradata/teste/tsrman_bi01.dbf'; SET NEWNAME FOR DATAFILE 38 TO '/u02/oradata/teste/tsrman_sf01.dbf'; SET NEWNAME FOR DATAFILE 39 TO '/u02/oradata/teste/tsstatspack01.dbf'; SET NEWNAME FOR DATAFILE 40 TO '/u02/oradata/teste/tsuser01.dbf'; SET NEWNAME FOR DATAFILE 41 TO '/u02/oradata/teste/tsdeul01.dbf'; SET NEWNAME FOR DATAFILE 42 TO '/u02/oradata/teste/tsieul01.dbf'; SET NEWNAME FOR DATAFILE 43 TO '/u02/oradata/teste/tsdsirp01.dbf'; SET NEWNAME FOR DATAFILE 44 TO '/u02/oradata/teste/tsisirp01.dbf'; SET NEWNAME FOR DATAFILE 45 TO '/u02/oradata/teste/tsdsiscon01.dbf'; SET NEWNAME FOR DATAFILE 46 TO '/u02/oradata/teste/tsisiscon01.dbf'; SET NEWNAME FOR DATAFILE 47 TO '/u02/oradata/teste/tsdlbv01.dbf'; SET NEWNAME FOR DATAFILE 48 TO '/u02/oradata/teste/dfd_herbario01.dbf'; SET NEWNAME FOR DATAFILE 49 TO '/u02/oradata/teste/dfi_herbario01.dbf'; SET NEWNAME FOR DATAFILE 50 TO '/u02/oradata/teste/tsdintegra01.dbf'; SET NEWNAME FOR DATAFILE 51 TO '/u02/oradata/teste/pergamarc01.dbf'; SET NEWNAME FOR DATAFILE 52 TO '/u02/oradata/teste/tsdgae01.dbf'; SQL "ALTER DATABASE RENAME FILE ''+DG1/pd01/onlinelog/group_1.435.699983083'' TO ''/u02/oradata/teste/redo1_01.log'' "; SQL "ALTER DATABASE RENAME FILE ''+DG1/pd01/onlinelog/group_1.436.699983089'' TO ''/u02/oradata/teste/redo1_02.log'' "; SQL "ALTER DATABASE RENAME FILE ''+DG1/pd01/onlinelog/group_2.437.699983093'' TO ''/u02/oradata/teste/redo2_01.log'' "; SQL "ALTER DATABASE RENAME FILE ''+DG1/pd01/onlinelog/group_2.438.699983099'' TO ''/u02/oradata/teste/redo2_02.log'' "; SQL "ALTER DATABASE RENAME FILE ''+DG1/pd01/onlinelog/group_3.439.699983105'' TO ''/u02/oradata/teste/redo3_01.log'' "; SQL "ALTER DATABASE RENAME FILE ''+DG1/pd01/onlinelog/group_3.440.699983107'' TO ''/u02/oradata/teste/redo3_02.log'' "; # restore the database and switch the datafile names RESTORE DATABASE; SWITCH DATAFILE ALL; # recover the database RECOVER DATABASE; } EXIT RMAN> @recover.rcv Quando executo meu script recover.rcv os renames de arquivos rodam ok mas depois recebo o seguintes erros: channel c1: reading from backup piece /u01/exp/dump/db_pd01_PD01_1345_1a1mgsrju_1_1.bkp ORA-19870: error reading backup piece /u01/exp/dump/db_pd01_PD01_1346_1a2mgss59_1_1.bkp ORA-19505: failed to identify file "/u01/exp/dump/db_pd01_PD01_1346_1a2mgss59_1_1.bkp" ORA-27037: unable to obtain file status Linux Error: 2: No such file or directory Additional information: 3 ORA-19870: error reading backup piece /u01/exp/dump/db_pd01_PD01_1347_1a3mgsspf_1_1.bkp ORA-19505: failed to identify file "/u01/exp/dump/db_pd01_PD01_1347_1a3mgsspf_1_1.bkp" ORA-27037: unable to obtain file status Linux Error: 2: No such file or directory Additional information: 3 ORA-19870: error reading backup piece /u01/exp/dump/db_pd01_PD01_1345_1a1mgsrju_1_1.bkp ORA-19505: failed to identify file "/u01/exp/dump/db_pd01_PD01_1345_1a1mgsrju_1_1.bkp" ORA-27037: unable to obtain file status Linux Error: 2: No such file or directory Additional information: 3 channel c2: starting datafile backupset restore channel c2: specifying datafile(s) to restore from backup set restoring datafile 00002 to /u02/oradata/teste/undotbs01.dbf restoring datafile 00004 to /u02/oradata/teste/users01.dbf restoring datafile 00012 to /u02/oradata/teste/tsdhd01.dbf restoring datafile 00022 to /u02/oradata/teste/tsdsiss01.dbf restoring datafile 00025 to /u02/oradata/teste/tsihd01.dbf restoring datafile 00031 to /u02/oradata/teste/tsindexsual01.dbf restoring datafile 00038 to /u02/oradata/teste/tsrman_sf01.dbf restoring datafile 00044 to /u02/oradata/teste/tsisirp01.dbf restoring datafile 00051 to /u02/oradata/teste/pergamarc01.dbf restoring datafile 00052 to /u02/oradata/teste/tsdgae01.dbf channel c2: reading from backup piece /u01/exp/dump/db_pd01_PD01_1348_1a4mgsta7_1_1.bkp ORA-19870: error reading backup piece /u01/exp/dump/db_pd01_PD01_1348_1a4mgsta7_1_1.bkp ORA-19505: failed to identify file "/u01/exp/dump/db_pd01_PD01_1348_1a4mgsta7_1_1.bkp" ORA-27037: unable to obtain file status Linux Error: 2: No such file or directory Additional information: 3 failover to previous backup channel c1: starting datafile backupset restore channel c1: specifying datafile(s) to restore from backup set restoring datafile 00001 to /u02/oradata/teste/system01.dbf restoring datafile 00003 to /u02/oradata/teste/sysaux01.dbf restoring datafile 00014 to /u02/oradata/teste/tsdintranet01.dbf restoring datafile 00015 to /u02/oradata/teste/tsdlbv01.dbf restoring datafile 00018 to /u02/oradata/teste/tsdpleres01.dbf restoring datafile 00021 to /u02/oradata/teste/tsdsisp01.dbf restoring datafile 00028 to /u02/oradata/teste/tsilbv01.dbf restoring datafile 00035 to /u02/oradata/teste/tsisisp01.dbf restoring datafile 00039 to /u02/oradata/teste/tsstatspack01.dbf restoring datafile 00043 to /u02/oradata/teste/tsdsirp01.dbf restoring datafile 00046 to /u02/oradata/teste/tsisiscon01.dbf restoring datafile 00050 to /u02/oradata/teste/tsdintegra01.dbf channel c1: reading from backup piece /u01/exp/dump/db_pd01_PD01_1339_19rmgq77u_1_1.bkp ORA-19870: error reading backup piece /u01/exp/dump/db_pd01_PD01_1339_19rmgq77u_1_1.bkp ORA-19505: failed to identify file "/u01/exp/dump/db_pd01_PD01_1339_19rmgq77u_1_1.bkp" ORA-27037: unable to obtain file status Linux Error: 2: No such file or directory Additional information: 3 channel c2: starting datafile backupset restore channel c2: specifying datafile(s) to restore from backup set restoring datafile 00008 to /u02/oradata/teste/pergaindex01.dbf restoring datafile 00009 to /u02/oradata/teste/pergamarc01.dbf restoring datafile 00010 to /u02/oradata/teste/tsdatasual01.dbf restoring datafile 00013 to /u02/oradata/teste/tsdintegra01.dbf restoring datafile 00019 to /u02/oradata/teste/tsdsca01.dbf restoring datafile 00024 to /u02/oradata/teste/tsifaep01.dbf restoring datafile 00027 to /u02/oradata/teste/tsiintranet01.dbf restoring datafile 00032 to /u02/oradata/teste/tsipleres01.dbf restoring datafile 00033 to /u02/oradata/teste/tsisca01.dbf restoring datafile 00037 to /u02/oradata/teste/tsrman_bi01.dbf restoring datafile 00041 to /u02/oradata/teste/tsdeul01.dbf restoring datafile 00045 to /u02/oradata/teste/tsdsiscon01.dbf restoring datafile 00047 to /u02/oradata/teste/tsdlbv01.dbf channel c2: reading from backup piece /u01/exp/dump/db_pd01_PD01_1340_19smgq7pa_1_1.bkp channel c1: starting datafile backupset restore channel c1: specifying datafile(s) to restore from backup set restoring datafile 00002 to /u02/oradata/teste/undotbs01.dbf restoring datafile 00004 to /u02/oradata/teste/users01.dbf restoring datafile 00012 to /u02/oradata/teste/tsdhd01.dbf restoring datafile 00022 to /u02/oradata/teste/tsdsiss01.dbf restoring datafile 00025 to /u02/oradata/teste/tsihd01.dbf restoring datafile 00031 to /u02/oradata/teste/tsindexsual01.dbf restoring datafile 00038 to /u02/oradata/teste/tsrman_sf01.dbf restoring datafile 00044 to /u02/oradata/teste/tsisirp01.dbf restoring datafile 00051 to /u02/oradata/teste/pergamarc01.dbf restoring datafile 00052 to /u02/oradata/teste/tsdgae01.dbf channel c1: reading from backup piece /u01/exp/dump/db_pd01_PD01_1342_19umgq8u8_1_1.bkp ORA-19870: error reading backup piece /u01/exp/dump/db_pd01_PD01_1340_19smgq7pa_1_1.bkp ORA-19505: failed to identify file "/u01/exp/dump/db_pd01_PD01_1340_19smgq7pa_1_1.bkp" ORA-27037: unable to obtain file status Linux Error: 2: No such file or directory Additional information: 3 channel c3: starting datafile backupset restore channel c3: specifying datafile(s) to restore from backup set restoring datafile 00005 to /u02/oradata/teste/drsys01.dbf restoring datafile 00006 to /u02/oradata/teste/ifsdados01.dbf restoring datafile 00007 to /u02/oradata/teste/ifsindex01.dbf restoring datafile 00011 to /u02/oradata/teste/tsd_faep01.dbf restoring datafile 00016 to /u02/oradata/teste/tsdmacchips01.dbf restoring datafile 00017 to /u02/oradata/teste/tsdmra01.dbf restoring datafile 00020 to /u02/oradata/teste/tsdscv01.dbf restoring datafile 00023 to /u02/oradata/teste/tsdsomec01.dbf restoring datafile 00026 to /u02/oradata/teste/tsiintegra01.dbf restoring datafile 00029 to /u02/oradata/teste/tsimacchips01.dbf restoring datafile 00030 to /u02/oradata/teste/tsimra01.dbf restoring datafile 00034 to /u02/oradata/teste/tsiscv01.dbf restoring datafile 00036 to /u02/oradata/teste/tsisomec01.dbf restoring datafile 00040 to /u02/oradata/teste/tsuser01.dbf restoring datafile 00042 to /u02/oradata/teste/tsieul01.dbf restoring datafile 00048 to /u02/oradata/teste/dfd_herbario01.dbf restoring datafile 00049 to /u02/oradata/teste/dfi_herbario01.dbf channel c3: reading from backup piece /u01/exp/dump/db_pd01_PD01_1341_19tmgq8dg_1_1.bkp ORA-19870: error reading backup piece /u01/exp/dump/db_pd01_PD01_1342_19umgq8u8_1_1.bkp ORA-19505: failed to identify file "/u01/exp/dump/db_pd01_PD01_1342_19umgq8u8_1_1.bkp" ORA-27037: unable to obtain file status Linux Error: 2: No such file or directory Additional information: 3 ORA-19870: error reading backup piece /u01/exp/dump/db_pd01_PD01_1341_19tmgq8dg_1_1.bkp ORA-19505: failed to identify file "/u01/exp/dump/db_pd01_PD01_1341_19tmgq8dg_1_1.bkp" ORA-27037: unable to obtain file status Linux Error: 2: No such file or directory Additional information: 3 failover to previous backup channel c3: starting datafile backupset restore channel c3: specifying datafile(s) to restore from backup set restoring datafile 00005 to /u02/oradata/teste/drsys01.dbf restoring datafile 00006 to /u02/oradata/teste/ifsdados01.dbf restoring datafile 00007 to /u02/oradata/teste/ifsindex01.dbf restoring datafile 00011 to /u02/oradata/teste/tsd_faep01.dbf restoring datafile 00016 to /u02/oradata/teste/tsdmacchips01.dbf restoring datafile 00017 to /u02/oradata/teste/tsdmra01.dbf restoring datafile 00020 to /u02/oradata/teste/tsdscv01.dbf restoring datafile 00023 to /u02/oradata/teste/tsdsomec01.dbf restoring datafile 00026 to /u02/oradata/teste/tsiintegra01.dbf restoring datafile 00029 to /u02/oradata/teste/tsimacchips01.dbf restoring datafile 00030 to /u02/oradata/teste/tsimra01.dbf restoring datafile 00034 to /u02/oradata/teste/tsiscv01.dbf restoring datafile 00036 to /u02/oradata/teste/tsisomec01.dbf restoring datafile 00040 to /u02/oradata/teste/tsuser01.dbf restoring datafile 00042 to /u02/oradata/teste/tsieul01.dbf restoring datafile 00048 to /u02/oradata/teste/dfd_herbario01.dbf restoring datafile 00049 to /u02/oradata/teste/dfi_herbario01.dbf channel c3: reading from backup piece /u01/exp/dump/db_pd01_PD01_1335_19nmgnk1h_1_1.bkp channel c1: starting datafile backupset restore channel c1: specifying datafile(s) to restore from backup set restoring datafile 00001 to /u02/oradata/teste/system01.dbf restoring datafile 00003 to /u02/oradata/teste/sysaux01.dbf restoring datafile 00014 to /u02/oradata/teste/tsdintranet01.dbf restoring datafile 00015 to /u02/oradata/teste/tsdlbv01.dbf restoring datafile 00018 to /u02/oradata/teste/tsdpleres01.dbf restoring datafile 00021 to /u02/oradata/teste/tsdsisp01.dbf restoring datafile 00028 to /u02/oradata/teste/tsilbv01.dbf restoring datafile 00035 to /u02/oradata/teste/tsisisp01.dbf restoring datafile 00039 to /u02/oradata/teste/tsstatspack01.dbf restoring datafile 00043 to /u02/oradata/teste/tsdsirp01.dbf restoring datafile 00046 to /u02/oradata/teste/tsisiscon01.dbf restoring datafile 00050 to /u02/oradata/teste/tsdintegra01.dbf channel c1: reading from backup piece /u01/exp/dump/db_pd01_PD01_1333_19lmgnis0_1_1.bkp channel c2: starting datafile backupset restore channel c2: specifying datafile(s) to restore from backup set restoring datafile 00008 to /u02/oradata/teste/pergaindex01.dbf restoring datafile 00009 to /u02/oradata/teste/pergamarc01.dbf restoring datafile 00010 to /u02/oradata/teste/tsdatasual01.dbf restoring datafile 00013 to /u02/oradata/teste/tsdintegra01.dbf restoring datafile 00019 to /u02/oradata/teste/tsdsca01.dbf restoring datafile 00024 to /u02/oradata/teste/tsifaep01.dbf restoring datafile 00027 to /u02/oradata/teste/tsiintranet01.dbf restoring datafile 00032 to /u02/oradata/teste/tsipleres01.dbf restoring datafile 00033 to /u02/oradata/teste/tsisca01.dbf restoring datafile 00037 to /u02/oradata/teste/tsrman_bi01.dbf restoring datafile 00041 to /u02/oradata/teste/tsdeul01.dbf restoring datafile 00045 to /u02/oradata/teste/tsdsiscon01.dbf restoring datafile 00047 to /u02/oradata/teste/tsdlbv01.dbf channel c2: reading from backup piece /u01/exp/dump/db_pd01_PD01_1334_19mmgnjdc_1_1.bkp ORA-19870: error reading backup piece /u01/exp/dump/db_pd01_PD01_1335_19nmgnk1h_1_1.bkp ORA-19505: failed to identify file "/u01/exp/dump/db_pd01_PD01_1335_19nmgnk1h_1_1.bkp" ORA-27037: unable to obtain file status Linux Error: 2: No such file or directory Additional information: 3 ORA-19870: error reading backup piece /u01/exp/dump/db_pd01_PD01_1333_19lmgnis0_1_1.bkp ORA-19505: failed to identify file "/u01/exp/dump/db_pd01_PD01_1333_19lmgnis0_1_1.bkp" ORA-27037: unable to obtain file status Linux Error: 2: No such file or directory Additional information: 3 ORA-19870: error reading backup piece /u01/exp/dump/db_pd01_PD01_1334_19mmgnjdc_1_1.bkp ORA-19505: failed to identify file "/u01/exp/dump/db_pd01_PD01_1334_19mmgnjdc_1_1.bkp" ORA-27037: unable to obtain file status Linux Error: 2: No such file or directory Additional information: 3 channel c3: starting datafile backupset restore channel c3: specifying datafile(s) to restore from backup set restoring datafile 00002 to /u02/oradata/teste/undotbs01.dbf restoring datafile 00004 to /u02/oradata/teste/users01.dbf restoring datafile 00012 to /u02/oradata/teste/tsdhd01.dbf restoring datafile 00022 to /u02/oradata/teste/tsdsiss01.dbf restoring datafile 00025 to /u02/oradata/teste/tsihd01.dbf restoring datafile 00031 to /u02/oradata/teste/tsindexsual01.dbf restoring datafile 00038 to /u02/oradata/teste/tsrman_sf01.dbf restoring datafile 00044 to /u02/oradata/teste/tsisirp01.dbf restoring datafile 00051 to /u02/oradata/teste/pergamarc01.dbf restoring datafile 00052 to /u02/oradata/teste/tsdgae01.dbf channel c3: reading from backup piece /u01/exp/dump/db_pd01_PD01_1336_19omgnki9_1_1.bkp ORA-19870: error reading backup piece /u01/exp/dump/db_pd01_PD01_1336_19omgnki9_1_1.bkp ORA-19505: failed to identify file "/u01/exp/dump/db_pd01_PD01_1336_19omgnki9_1_1.bkp" ORA-27037: unable to obtain file status Linux Error: 2: No such file or directory Additional information: 3 failover to previous backup creating datafile fno=1 name=/u02/oradata/teste/system01.dbf released channel: c1 released channel: c2 released channel: c3 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of restore command at 07/12/2011 19:02:29 ORA-01180: can not create datafile 1 ORA-01110: data file 1: '+DG1/pd01/datafile/system.441.699983113' RMAN> EXIT -- Jose Luis Ramos Jr Campinas - SP - Brazil Database Administrator Fone: +55-21-19-91916882