Alberto, Tente fazer o seguinte:
RMAN> restore controlfile from autobackup; Atenciosamente, Rodrigo Mufalani OCP 10g & 11g +RAC Oracle ACE Member http://mufalani.blogspot.com [email protected] ----- Original Message ----- From: "Alberto Souza" <[email protected]> To: <[email protected]> Sent: Tuesday, September 22, 2009 3:09 PM Subject: [oracle_br] Backup e restore com o RMAN - Erro Pessoal, estou com um problema sério no RMAN, estou fazendo um backup em um servidor e restaurando em outro, com as mesmas configurações, mas na hora de restaurar dá um erro e não consigo passar. Vejam os dados: No Servidor de Origem ===================== RMAN> show all; RMAN configuration parameters are: CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default CONFIGURE BACKUP OPTIMIZATION OFF; # default CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default CONFIGURE CONTROLFILE AUTOBACKUP ON; CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/backup/Bkp_ControlFile_%F'; CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COPY PARALLELISM 1; CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/backup/bkp_%d_%t_%s.rman'; CONFIGURE MAXSETSIZE TO UNLIMITED; # default CONFIGURE ENCRYPTION FOR DATABASE OFF; # default CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/oracle/dbs/snapcf_WINT.f'; # default RMAN> backup database; Starting backup at 22-SEP-09 allocated channel: ORA_DISK_1 channel ORA_DISK_1: sid=128 devtype=DISK channel ORA_DISK_1: starting datafile copy input datafile fno=00005 name=/oracle/oradata/WINT/TS_DADOS output filename=/backup/bkp_WINT_698244378_248.rman tag=TAG20090922T124618 recid=125 stamp=698244504 channel ORA_DISK_1: datafile copy complete, elapsed time: 00:02:15 channel ORA_DISK_1: starting datafile copy input datafile fno=00006 name=/oracle/oradata/WINT/TS_INDICE output filename=/backup/bkp_WINT_698244513_249.rman tag=TAG20090922T124618 recid=126 stamp=698244642 channel ORA_DISK_1: datafile copy complete, elapsed time: 00:02:16 channel ORA_DISK_1: starting datafile copy input datafile fno=00001 name=/oracle/oradata/WINT/system01.dbf output filename=/backup/bkp_WINT_698244649_250.rman tag=TAG20090922T124618 recid=127 stamp=698244672 channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:25 channel ORA_DISK_1: starting datafile copy input datafile fno=00003 name=/oracle/oradata/WINT/sysaux01.dbf output filename=/backup/bkp_WINT_698244674_251.rman tag=TAG20090922T124618 recid=128 stamp=698244698 channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:25 channel ORA_DISK_1: starting datafile copy input datafile fno=00007 name=/oracle/oradata/WINT/TS_RBS output filename=/backup/bkp_WINT_698244699_252.rman tag=TAG20090922T124618 recid=129 stamp=698244720 channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:25 channel ORA_DISK_1: starting datafile copy input datafile fno=00008 name=/oracle/oradata/WINT/TS_GRANDE output filename=/backup/bkp_WINT_698244725_253.rman tag=TAG20090922T124618 recid=130 stamp=698244730 channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:07 channel ORA_DISK_1: starting datafile copy input datafile fno=00002 name=/oracle/oradata/WINT/undotbs01.dbf output filename=/backup/bkp_WINT_698244732_254.rman tag=TAG20090922T124618 recid=131 stamp=698244733 channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03 channel ORA_DISK_1: starting datafile copy input datafile fno=00004 name=/oracle/oradata/WINT/users01.dbf output filename=/backup/bkp_WINT_698244735_255.rman tag=TAG20090922T124618 recid=132 stamp=698244735 channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01 Finished backup at 22-SEP-09 Starting Control File and SPFILE Autobackup at 22-SEP-09 piece handle=/backup/Bkp_ControlFile_c-1240283497-20090922-01 comment=NONE Finished Control File and SPFILE Autobackup at 22-SEP-09 No Servidor de Destino ====================== RMAN> show all; RMAN configuration parameters are: CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default CONFIGURE BACKUP OPTIMIZATION OFF; # default CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default CONFIGURE MAXSETSIZE TO UNLIMITED; # default CONFIGURE ENCRYPTION FOR DATABASE OFF; # default CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default [ora...@wtserver02 ~]$ rman target / Recovery Manager: Release 10.2.0.1.0 - Production on Tue Sep 22 13:58:47 2009 Copyright (c) 1982, 2005, Oracle. All rights reserved. connected to target database: WINT (not mounted) RMAN> set dbid=1240283497 executing command: SET DBID RMAN> restore controlfile from '/backup/Bkp_ControlFile_c-1240283497-20090922-01'; Starting restore at 22-SEP-09 using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: sid=156 devtype=DISK RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of restore command at 09/22/2009 13:59:29 RMAN-06172: no autobackup found or specified handle is not a valid copy or piece RMAN> restore spfile from '/backup/Bkp_ControlFile_c-1240283497-20090922-00'; Starting restore at 22-SEP-09 using channel ORA_DISK_1 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of restore command at 09/22/2009 13:59:57 RMAN-06564: must use the TO clause when the instance is started with SPFILE O que será que estou fazendo de errado? Alberto Souza ============= ------------------------------------ -------------------------------------------------------------------------------------------------------------------------- >Atenção! As mensagens do grupo ORACLE_BR são de acesso público e de inteira >responsabilidade de seus remetentes. Acesse: http://www.mail-archive.com/[email protected]/ -------------------------------------------------------------------------------------------------------------------------- >Apostilas » Dicas e Exemplos » Função » Mundo Oracle » Package » >Procedure » Scripts » Tutoriais - O GRUPO ORACLE_BR TEM SEU PROPRIO ESPAÇO! >VISITE: http://www.oraclebr.com.br/ ------------------------------------------------------------------------------------------------------------------------ Links do Yahoo! Grupos
