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@(protected)]=20
Sent: Thursday, October 21, 2004 1:56 PM
To: Stankus, Paula G; zhuchao@(protected)
Cc: charlottejanehammond@(protected); oracle-l@(protected);
christian.antognini@(protected)
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@(protected)
[mailto:oracle-l-bounce@(protected)]
On Behalf Of Paula_Stankus@(protected)
Sent: Thursday, October 21, 2004 9:30 AM
To: zhuchao@(protected)
Cc: charlottejanehammond@(protected); oracle-l@(protected);
christian.antognini@(protected)
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@(protected)]=3D20
Sent: Thursday, October 21, 2004 10:20 AM
To: Stankus, Paula G
Cc: charlottejanehammond@(protected); oracle-l@(protected);
christian.antognini@(protected)
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@(protected)
<paula_stankus@(protected) > 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 (See ORA-19502.ora-code.com): write error on file=3D20
> "/dbdumps/backups/df_t540005405_s232_p1 ",
> blockno
> 380417 (blocksize=3D3D3D8192)
> ORA-27063 (See ORA-27063.ora-code.com): skgfospo: number of bytes read/written is incorrect=3D20 =20
>Additional information: 761856 Additional information: 1048576
> --
> http://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
--
http://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
