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 NEWNAME (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 (SET
NEWNAME) 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
Abraços,
--
Jose Luis Ramos Jr
Campinas - SP - Brazil
Database Administrator
Fone: +55-21-19-91916882
