Este arquivo de controle do backup não é um controlfile de standby?
Parece ser, se for tens que usar a opcao backup current controlfile FOR
STANDBY!!!
- Mensagem de [EMAIL PROTECTED] -
Data: Wed, 4 Jun 2008 12:01:11 -0400
De: Diogo Lopez - Datapar <[EMAIL PROTECTED]>
Endereço para Resposta (Reply-To): oracle_br@yahoogrupos.com.br
Assunto: [oracle_br] RMAN não está reconhecendo TAG.
Para: oracle_br@yahoogrupos.com.br
> Pessoal
>
> De uns dias pra cá meu script de backup passsou a não incremetntar o
> backup dos datafiles e sim a criar um novo toda vez.
> O backup dos archives também parou.
>
> Investigando eu notei algum problema ao aplicar TAG nos backup;
>
> BACKUP ARCHIVES, passou a exibir esse erro:
> Starting backup at 04/06/2008 10:00:51
> current log archived
> using channel ORA_DISK_1
> RMAN-00571: ===
> RMAN-00569: === ERROR MESSAGE STACK FOLLOWS ===
> RMAN-00571: ===
> RMAN-03002: failure of backup command at 06/04/2008 10:01:02
> RMAN-06043: TAG option not supported for archive log copies
> O BACKUP FULL,está criando novas cópias de datafile pois não encontra
> as antigas.RMAN> recover copy of database with tag
> IMAGEM_COMPLETA;Starting backup at 04/06/2008 09:04:03
> using channel ORA_DISK_1
> no parent backup or copy of datafile 9 found
> no parent backup or copy of datafile 8 found
> no parent backup or copy of datafile 6 found
> no parent backup or copy of datafile 10 foundFiz um Teste de
> Bravação em Disco do próprio EM e me retonra isso:
>
> RMAN> run {
> 2> allocate channel oem_disk_backup type disk format
> '/u01/oradata/standby/%U'
> 3> ;backup as COPY current controlfile tag '06042008113452';
> 4> restore controlfile validate from tag '06042008113452';
> 5> release channel oem_disk_backup;
> 6> }
>
> allocated channel: oem_disk_backup
> channel oem_disk_backup: sid=63 devtype=DISK
> Starting backup at 04/06/2008 11:34:58
> channel oem_disk_backup: starting datafile copy
> copying current control file
> output
> filename=/u01/oradata/standby/cf_D-ORACLE_id-1476813642_ctji31v3
> tag=06042008113452 recid=7106 stamp=656508920
> channel oem_disk_backup: datafile copy complete, elapsed time: 00:00:25
> Finished backup at 04/06/2008 11:35:24
> Starting restore at 04/06/2008 11:35:26
>
> released channel: oem_disk_backup
> RMAN-00571: ===
> RMAN-00569: === ERROR MESSAGE STACK FOLLOWS ===
> RMAN-00571: ===
> RMAN-03002: failure of restore command at 06/04/2008 11:35:27
> RMAN-06026: some targets not found - aborting restore
> RMAN-06024: no backup or copy of the control file found to restore
>
> RMAN> allocate channel for maintenance type disk;
> allocated channel: ORA_MAINT_DISK_1
> channel ORA_MAINT_DISK_1: sid=63 devtype=DISK
>
> RMAN> delete noprompt controlfilecopy tag '06042008113452';
> List of Control File Copies
> Key S Completion Time Ckp SCNCkp TimeName
> --- - --- -- ---
> 7106A 04/06/2008 11:35:20 206618818 04/06/2008 11:34:59
> /u01/oradata/standby/cf_D-ORACLE_id-1476813642_ctji31v3
> deleted control file copy
> control file copy
> filename=/u01/oradata/standby/cf_D-ORACLE_id-1476813642_ctji31v3
> recid=7106 stamp=656508920
> Deleted 1 objects
>
> RMAN> exit;
>
>
>
> Os backups funcionavam bem há 2 anos.
> A única coisa que tentei fazer ha um tempo atras é duplexar o backup
> para 2 pastas, configurando o RMAN.
> Mas já voltei a configuração original.
>
> Alguem sabe o que pode ter acontecido?
>
>
> Esse é a configuração do meu RMAN:
>
> 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;
> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO
> '/u01/oradata/standby/%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 '/u01/oradata/standby/%U';
> CONFIGURE MAXSETSIZE TO UNLIMITED; # default
> CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
> CONFIGURE ENCRYPTION ALGORITHM 'AES12
