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 found....Fiz 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 SCN Ckp Time Name
------- - ------------------- ---------- ------------------- ----
7106 A 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 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO
'/u01/app/oracle/product/10.2.0/db_1/dbs/snapcf_oracle.f'; # default
[As partes desta mensagem que não continham texto foram removidas]
