RE: Help intermittent failure of backup to disk

  • From: <Paula_Stankus@xxxxxxxxxxxxxxx>
  • To: <DWILLIAMS@xxxxxxxxxxxxx>, <zhuchao@xxxxxxxxx>
  • Date: Fri, 22 Oct 2004 10:12:13 -0400

Guys,

It was simply a space issue.  The reason why it failed on certain days
versus others was because of the fact that I used mtime to remove the
second set.  I thought I had enough space for 2 sets/days.  I don't.  So
every other day it would work because based on that script no backup
sets would be on the file system. =20

Therefore,  I changed the process to remove the current backup set
immediately before a new one and it works.  I am also backing these
database files up to tape.  This is just to ensure that when we have
Networker issues (every few weeks) we can still get a good backup. =20

-----Original Message-----
From: DENNIS WILLIAMS [mailto:DWILLIAMS@xxxxxxxxxxxxx]=20
Sent: Thursday, October 21, 2004 1:56 PM
To: Stankus, Paula G; zhuchao@xxxxxxxxx
Cc: charlottejanehammond@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx;
christian.antognini@xxxxxxxxxxxx
Subject: RE: Help intermittent failure of backup to disk

Paula - What type of device are you writing to? Is NFS involved?

Dennis Williams
DBA
Lifetouch, Inc.

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Paula_Stankus@xxxxxxxxxxxxxxx
Sent: Thursday, October 21, 2004 9:30 AM
To: zhuchao@xxxxxxxxx
Cc: charlottejanehammond@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx;
christian.antognini@xxxxxxxxxxxx
Subject: RE: Help intermittent failure of backup to disk

In Solaris 2.9 there is no longer a 2Gb file size limit.  Is there a
file size limit or issue with having larger backup set files in =
RMAN?=3D20

-----Original Message-----
From: zhu chao [mailto:zhuchao@xxxxxxxxx]=3D20
Sent: Thursday, October 21, 2004 10:20 AM
To: Stankus, Paula G
Cc: charlottejanehammond@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx;
christian.antognini@xxxxxxxxxxxx
Subject: Re: Help intermittent failure of backup to disk

Could you try add the file size limit to 2Gb in the rman script?



On Thu, 21 Oct 2004 10:16:53 -0400, paula_stankus@xxxxxxxxxxxxxxx
<paula_stankus@xxxxxxxxxxxxxxx> wrote:
> I have the same target database, the same OS, the same RMAN =
catalog=3D20

>the same RMAN script that backups to disk.  Every so often (not=3D20
> regularly) I get the following error.  I checked catalog table =
for=3D20

>backup_corruption in the target and nothing was listed. =3D3D20 =3D20  =
Why=20
>would I get this error some days but not others?  Also, it isn't=3D20  =
on

>the database datafiles but on the backup file?
>=3D20
> Help?
>=3D20
> RMAN-03009: failure of backup command on d1 channel at 10/20/2004=3D20 =
=20
>01:31:40
> ORA-19502: write error on file=3D20
> "/dbdumps/backups/df_t540005405_s232_p1",
> blockno
> 380417 (blocksize=3D3D3D8192)
> ORA-27063: skgfospo: number of bytes read/written is incorrect=3D20 =20
>Additional information: 761856 Additional information: 1048576
> --
> //www.freelists.org/webpage/oracle-l
>=3D20


--
Regards
Zhu Chao
www.cnoug.org


BEGIN-ANTISPAM-VOTING-LINKS
------------------------------------------------------
NOTE: This message was auto-learned as non-spam.  If this is wrong,
please correct the training as soon as possible.
Teach CanIt if this mail (ID 13500558) is spam:
Spam:
https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3D3Ds&i=3D3D13500558&m=3D=
3De06
b=3D
7b15c
80b
Not spam:
https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3D3Dn&i=3D3D13500558&m=3D=
3De06
b=3D
7b15c
80b
Forget vote:
https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3D3Df&i=3D3D13500558&m=3D=
3De06
b=3D
7b15c
80b
------------------------------------------------------
END-ANTISPAM-VOTING-LINKS

--
//www.freelists.org/webpage/oracle-l


BEGIN-ANTISPAM-VOTING-LINKS
------------------------------------------------------
Teach CanIt if this mail (ID 13521407) is spam:
Spam:
https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Ds&i=3D13521407&m=3Dd4e9=
1c631
d95
Not spam:
https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Dn&i=3D13521407&m=3Dd4e9=
1c631
d95
Forget vote:
https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Df&i=3D13521407&m=3Dd4e9=
1c631
d95
------------------------------------------------------
END-ANTISPAM-VOTING-LINKS

--
//www.freelists.org/webpage/oracle-l

Other related posts: