Menu de navegação

[mpunganParticipante]

Pessoal, estou recebendo as vezes esse erro do backup com RMAN, alguém sabe me dizer o que pode estar ocorrendo. Não é sempre, mas as vezes vem esse erro.

Spooling started in log file: /oracle/backup/n0/backup_db_n0.log

Recovery Manager11.2.0.3.0

RMAN>

Starting backup at 24-MAY-12
current log archived
using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=1908 device type=DISK channel ORA_DISK_1: starting compressed archived log backup set channel ORA_DISK_1: specifying archived log(s) in backup set input archived log thread=1 sequence=1885 RECID=1607 STAMP=784162709 channel ORA_DISK_1: starting piece 1 at 24-MAY-12 channel ORA_DISK_1: finished piece 1 at 24-MAY-12 piece handle=/oracle/backup/rman_archives/arc_HSLPUCRS_1357.bkp tag=ARCHIVES comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:07 channel ORA_DISK_1: deleting archived log(s) archived log file name=/oracle/oradata/arch/arch_1_1885_779305931.dbf RECID=1607 STAMP=784162709 Finished backup at 24-MAY-12

Starting backup at 24-MAY-12
using channel ORA_DISK_1
channel ORA_DISK_1: starting compressed incremental level 0 datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set input datafile file number=00005 name=/oracle/oradata/HSLPUCRS/hslgestao.dbf
input datafile file number=00003 name=/oracle/oradata/HSLPUCRS/undotbs01.dbf
input datafile file number=00001 name=/oracle/oradata/HSLPUCRS/system01.dbf
input datafile file number=00010 name=/oracle/oradata/HSLPUCRS/inscerimg.dbf
input datafile file number=00002 name=/oracle/oradata/HSLPUCRS/sysaux01.dbf
input datafile file number=00009 name=/oracle/oradata/HSLPUCRS/hsllabwide.dbf
input datafile file number=00007 name=/oracle/oradata/HSLPUCRS/hslbranduser.dbf
input datafile file number=00006 name=/oracle/oradata/HSLPUCRS/hslbrand.dbf
input datafile file number=00008 name=/oracle/oradata/HSLPUCRS/hslforum.dbf
input datafile file number=00004 name=/oracle/oradata/HSLPUCRS/users01.dbf
channel ORA_DISK_1: starting piece 1 at 24-MAY-12 channel ORA_DISK_1: finished piece 1 at 25-MAY-12 piece handle=/oracle/backup/n0/n0_HSLPUCRS_1358.bkp tag=NIVEL_0 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 02:00:46 channel ORA_DISK_1: starting compressed incremental level 0 datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set including current control file in backup set including current SPFILE in backup set channel ORA_DISK_1: starting piece 1 at 25-MAY-12 channel ORA_DISK_1: finished piece 1 at 25-MAY-12 piece handle=/oracle/backup/n0/n0_HSLPUCRS_1359.bkp tag=NIVEL_0 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01 Finished backup at 25-MAY-12

Starting backup at 25-MAY-12
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting compressed archived log backup set channel ORA_DISK_1: specifying archived log(s) in backup set input archived log thread=1 sequence=1886 RECID=1608 STAMP=784162822 input archived log thread=1 sequence=1887 RECID=1609 STAMP=784162869 input archived log thread=1 sequence=1888 RECID=1610 STAMP=784162906 input archived log thread=1 sequence=1889 RECID=1611 STAMP=784162960 input archived log thread=1 sequence=1890 RECID=1612 STAMP=784163014 input archived log thread=1 sequence=1891 RECID=1613 STAMP=784163044 input archived log thread=1 sequence=1892 RECID=1614 STAMP=784163084 input archived log thread=1 sequence=1893 RECID=1615 STAMP=784169970 channel ORA_DISK_1: starting piece 1 at 25-MAY-12
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup plus archivelog command at 05/25/2012 01:03:26
ORA-19510: failed to set size of 2222550 blocks for file “/oracle/backup/rman_archives/arc_HSLPUCRS_1360.bkp” (block size=512)
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory Additional information: 9

RMAN>

Recovery Manager complete.

Se alguem puder ajudar, desde já agradeço.

[Douglas Paiva de SousaParticipante]

Isso me parece falta de espaço no disco, verifique…

Att,

[mpunganParticipante]

Falta de espaço em disco não é, tem muito espaço em disco.

[Victor ArmbrustMestre]

[b]Rman Backup Fails with ORA-19510 and Ora-27037 : No such file or directory [ID 335609.1]
[/b]

Cause

The backup piece is being removed from disk before the backup finishes creating it. There was a scheduled cron purge job
that conflicted with the RMAN backup and was removing the piece before RMAN finished creating it.

Solution

Schedule the purge job to run at a different time to allow the RMAN backup job to complete or remove the purge job entirely.

---

Tenha certeza que o diretório onde o backup está sendo gerado permaneça sem alterações até o final do Backup.
Sugiro a revisão do destino do Backup

Abs
Victor

[mpunganParticipante]

Caro varmbrust, veja abaixo, não realizamos nenhuma modificação e o backup não deu problemas. Isso ta muito estranhos, tem alguma idéia do que possa ser?

Spooling started in log file: /oracle/backup/n0/backup_db_n0.log

Recovery Manager11.2.0.3.0

RMAN>

Starting backup at 27-MAY-12
current log archived
using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=765 device type=DISK channel ORA_DISK_1: starting compressed archived log backup set channel ORA_DISK_1: specifying archived log(s) in backup set input archived log thread=1 sequence=1976 RECID=1698 STAMP=784421908 channel ORA_DISK_1: starting piece 1 at 27-MAY-12 channel ORA_DISK_1: finished piece 1 at 27-MAY-12 piece handle=/oracle/backup/rman_archives/arc_HSLPUCRS_1433.bkp tag=ARCHIVES comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03 channel ORA_DISK_1: deleting archived log(s) archived log file name=/oracle/oradata/arch/arch_1_1976_779305931.dbf RECID=1698 STAMP=784421908 Finished backup at 27-MAY-12

Starting backup at 27-MAY-12
using channel ORA_DISK_1
channel ORA_DISK_1: starting compressed incremental level 0 datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set input datafile file number=00005 name=/oracle/oradata/HSLPUCRS/hslgestao.dbf
input datafile file number=00001 name=/oracle/oradata/HSLPUCRS/system01.dbf
input datafile file number=00003 name=/oracle/oradata/HSLPUCRS/undotbs01.dbf
input datafile file number=00010 name=/oracle/oradata/HSLPUCRS/inscerimg.dbf
input datafile file number=00002 name=/oracle/oradata/HSLPUCRS/sysaux01.dbf
input datafile file number=00009 name=/oracle/oradata/HSLPUCRS/hsllabwide.dbf
input datafile file number=00007 name=/oracle/oradata/HSLPUCRS/hslbranduser.dbf
input datafile file number=00006 name=/oracle/oradata/HSLPUCRS/hslbrand.dbf
input datafile file number=00008 name=/oracle/oradata/HSLPUCRS/hslforum.dbf
input datafile file number=00004 name=/oracle/oradata/HSLPUCRS/users01.dbf
channel ORA_DISK_1: starting piece 1 at 27-MAY-12 channel ORA_DISK_1: finished piece 1 at 28-MAY-12 piece handle=/oracle/backup/n0/n0_HSLPUCRS_1434.bkp tag=NIVEL_0 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 01:54:16 channel ORA_DISK_1: starting compressed incremental level 0 datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set including current control file in backup set including current SPFILE in backup set channel ORA_DISK_1: starting piece 1 at 28-MAY-12 channel ORA_DISK_1: finished piece 1 at 28-MAY-12 piece handle=/oracle/backup/n0/n0_HSLPUCRS_1435.bkp tag=NIVEL_0 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01 Finished backup at 28-MAY-12

Starting backup at 28-MAY-12
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting compressed archived log backup set channel ORA_DISK_1: specifying archived log(s) in backup set input archived log thread=1 sequence=1977 RECID=1699 STAMP=784422038 input archived log thread=1 sequence=1978 RECID=1700 STAMP=784422116 input archived log thread=1 sequence=1979 RECID=1701 STAMP=784422172 input archived log thread=1 sequence=1980 RECID=1702 STAMP=784422233 input archived log thread=1 sequence=1981 RECID=1703 STAMP=784422254 input archived log thread=1 sequence=1982 RECID=1704 STAMP=784422329 input archived log thread=1 sequence=1983 RECID=1705 STAMP=784422386 input archived log thread=1 sequence=1984 RECID=1706 STAMP=784428778 channel ORA_DISK_1: starting piece 1 at 28-MAY-12 channel ORA_DISK_1: finished piece 1 at 28-MAY-12 piece handle=/oracle/backup/rman_archives/arc_HSLPUCRS_1436.bkp tag=ARCHIVES comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:04:05 channel ORA_DISK_1: deleting archived log(s) archived log file name=/oracle/oradata/arch/arch_1_1977_779305931.dbf RECID=1699 STAMP=784422038 archived log file name=/oracle/oradata/arch/arch_1_1978_779305931.dbf RECID=1700 STAMP=784422116 archived log file name=/oracle/oradata/arch/arch_1_1979_779305931.dbf RECID=1701 STAMP=784422172 archived log file name=/oracle/oradata/arch/arch_1_1980_779305931.dbf RECID=1702 STAMP=784422233 archived log file name=/oracle/oradata/arch/arch_1_1981_779305931.dbf RECID=1703 STAMP=784422254 archived log file name=/oracle/oradata/arch/arch_1_1982_779305931.dbf RECID=1704 STAMP=784422329 archived log file name=/oracle/oradata/arch/arch_1_1983_779305931.dbf RECID=1705 STAMP=784422386 archived log file name=/oracle/oradata/arch/arch_1_1984_779305931.dbf RECID=1706 STAMP=784428778 Finished backup at 28-MAY-12

RMAN>

Recovery Manager complete.

[vieriParticipante]

isso está me cheirando problema com o tamanho do db_BLOCK_SIZE,
ele não esta sendo multiplo do FILE_SIZE do seu backup.

[Victor ArmbrustMestre]

Cara,

Fica esperto com o OPEN FILES do Linux tb… se não está estourando.

É NFS o destino do Backup? Ou compatilhamento SAMBA, WIN etc?

atente no parâmetro “fs.file-max” do /etc/sysctl.conf

Abs
Victor

[mpunganParticipante]

O tamanho do db_block_size do banco esta com 8192 tamanho padrão quando o banco foi criado, e o parametro “fs.file-max” do /etc/sysctl.conf esta com 6815744. O que mais eu posso ver além disso, pode existir alguma outra coisa.

[vieriParticipante]

só de onda altere esse parâmetro do RMAN na propria sessão do backup e ve se o erro muda.

RMAN> CONFIGURE MAXSETSIZE TO 800M;

old RMAN configuration parameters:
CONFIGURE MAXSETSIZE TO UNLIMITED;
new RMAN configuration parameters:
CONFIGURE MAXSETSIZE TO 800 M;
new RMAN configuration parameters are successfully stored

[Autor]

Posts