Bom, dia tenho uma instância oracle 10.2.0.4 em ambiente windows da qual é
feito um backup de archives de hora em hora e um backup full todos os dias
as 19hs.
Os scripts são:
backup de archives:
run {
CONFIGURE DEVICE TYPE DISK PARALLELISM 2;
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 2 DAYS;
ALLOCATE CHANNEL CANAL_DISCO_1 DEVICE TYPE DISK;
ALLOCATE CHANNEL CANAL_DISCO_2 DEVICE TYPE DISK;
CHANGE ARCHIVELOG ALL CROSSCHECK;
BACKUP AS COMPRESSED BACKUPSET ARCHIVELOG ALL FORMAT
'\\10.1.7.7\unk-fls-02\orabkp\HC1\archives\arch_%d_20112206_%u' DELETE
INPUT;
DELETE noprompt ARCHIVELOG ALL COMPLETED BEFORE 'TRUNC(SYSDATE-2)';
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO
'\\10.1.7.7\unk-fls-02\orabkp\HC1\controlfiles\ctl_%d_20112206_%u';
CROSSCHECK BACKUP OF DATABASE ;
CROSSCHECK COPY ;
CROSSCHECK BACKUPSET ;
CROSSCHECK ARCHIVELOG ALL ;
DELETE NOPROMPT EXPIRED BACKUP ;
RELEASE CHANNEL CANAL_DISCO_1;
RELEASE CHANNEL CANAL_DISCO_2;
}
exit
BACKUP FULL:
run {
CONFIGURE DEVICE TYPE DISK PARALLELISM 2;
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS;
ALLOCATE CHANNEL CANAL_DISCO_1 DEVICE TYPE DISK;
ALLOCATE CHANNEL CANAL_DISCO_2 DEVICE TYPE DISK;
SETLIMIT CHANNEL CANAL_DISCO_1 MAXOPENFILES 3;
SETLIMIT CHANNEL CANAL_DISCO_2 MAXOPENFILES 3;
BACKUP AS COMPRESSED BACKUPSET FULL MAXSETSIZE=40G DATABASE FORMAT
'\\10.1.7.7\unk-fls-02\orabkp\HC1\datafiles\bkp_full_%d_20112106_%u' SKIP
INACCESSIBLE;
CROSSCHECK ARCHIVELOG ALL;
BACKUP AS COMPRESSED BACKUPSET ARCHIVELOG ALL FORMAT
'\\10.1.7.7\unk-fls-02\orabkp\HC1\archives\arch_%d_20112106_%u' DELETE
INPUT;
DELETE noprompt ARCHIVELOG ALL COMPLETED BEFORE 'TRUNC(SYSDATE-1)';
CROSSCHECK BACKUP OF DATABASE ;
CROSSCHECK COPY ;
CROSSCHECK BACKUPSET ;
CROSSCHECK ARCHIVELOG ALL ;
DELETE NOPROMPT EXPIRED BACKUP ;
RELEASE CHANNEL CANAL_DISCO_1;
RELEASE CHANNEL CANAL_DISCO_2;
}
exit
ACONTECE QUE OS DOIS ESTÃO DANDO O MESMO NO FINAL DO BACKUP COMO SEGUE
ABAIXO. PARECE ALGUM PROBLEMA DE ACESSO OU PERMISSÃO MAS ISSO JA FOI
VERIFICADO PELA INFRA E SÓ ACONTECE COM O CONTROL FILE, OS BACKUP SETS E
BACKUPS DE ARCHIVES SÃO GRAVADOS EM DIRETÓRIOS NO MESMO NÍVEL DO DIRETÓRIO
"CONTROLFILES". VEJAM ERRO ABAIXO. SE ALGUEM TIVER ALGUMA SUGESTÃO EU
AGRADEÇO.
ERRO NO BACKUP DE ARCHIVES:
Starting backup at 22-JUN-11
current log archived
channel CANAL_DISCO_1: starting compressed archive log backupset
channel CANAL_DISCO_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=17053 recid=20575 stamp=754480823
channel CANAL_DISCO_1: starting piece 1 at 22-JUN-11
channel CANAL_DISCO_1: finished piece 1 at 22-JUN-11
piece
handle=\\10.1.7.7\UNK-FLS-02\ORABKP\HC1\ARCHIVES\ARCH_HC1_20112206_FDMFGTLP
tag=TAG20110622T100024 comment=NONE
channel CANAL_DISCO_1: backup set complete, elapsed time: 00:00:16
channel CANAL_DISCO_1: deleting archive log(s)
archive log filename=D:\ORADATA\HC1\ARCH\ARCH_725451246_1_17053.ARC
recid=20575 stamp=754480823
Finished backup at 22-JUN-11
Starting Control File and SPFILE Autobackup at 22-JUN-11
released channel: CANAL_DISCO_1
released channel: CANAL_DISCO_2
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of Control File and SPFILE Autobackup command on
CANAL_DISCO_1 channel at 06/22/2011 10:00:45
ORA-19504: failed to create file
"\\10.1.7.7\UNIK-ORA-BKP$\ORABKP\HC1\CONTROLFILES\C-728574766-20110622-0A"
ORA-27056: could not delete file
OSD-04029: unable to get file attributes
O/S-Error: (OS 53) The network path was not found.
Recovery Manager complete.
ERRO NO BACKUP FULL:
Finished backup at 21-JUN-11
Starting Control File and SPFILE Autobackup at 21-JUN-11
released channel: CANAL_DISCO_1
released channel: CANAL_DISCO_2
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of Control File and SPFILE Autobackup command on
CANAL_DISCO_1 channel at 06/21/2011 19:56:31
ORA-19504: failed to create file
"\\10.1.7.7\UNIK-ORA-BKP$\ORABKP\HC1\CONTROLFILES\C-728574766-20110621-15"
ORA-27056: could not delete file
OSD-04029: unable to get file attributes
O/S-Error: (OS 53) The network path was not found.
Recovery Manager complete.
Abraços,
--
Jose Luis Ramos Jr
Campinas - SP - Brazil
Database Administrator
Fone: +55-21-19-91916882
[As partes desta mensagem que não continham texto foram removidas]
