RE: RMAN error on level0 backup after controlfile recovery to new server

From: Bobak, Mark <Mark.Bobak_at_il.proquest.com>
Date: Wed, 7 Dec 2005 15:40:33 -0500
Message-ID: <AA29A27627F842409E1D18FB19CDCF2705FC8A4E@AABO-EXCHANGE02.bos.il.pqe>

This is a bit odd, cause the size (133,377 blocks * 8,192 bytes/block = 1,092,624,384 bytes) is not very near a 1G or 2G boundary. Out of curiousity, do you have other files that were successfully backed up in that same file system, that are at least that large?

The only other thing I can think of is, ask your sysadmin to umount the filesystem and do an fsck to check for corruptions....

Hope that helps,

-Mark

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Bobak, Mark Sent: Wednesday, December 07, 2005 3:19 PM To: laura pena; Oracle-L Freelists
Subject: RE: RMAN error on level0 backup after controlfile recovery to new server

Sorry, somehow I skipped right over that second to last line.....my bad.

From: laura pena [mailto:lizzpenaorclgrp_at_yahoo.com] Sent: Wednesday, December 07, 2005 3:15 PM To: Bobak, Mark; Oracle-L Freelists
Subject: RE: RMAN error on level0 backup after controlfile recovery to new server

I found notes on the Oracle Support Site to the following: I have set the default channel size to 2G. I have set the maxpiecesize to 2G.
I have tried recreating the spfile.
I am not running out of disk space.
I verified that there are no files in need of recovery.

"Bobak, Mark" <Mark.Bobak_at_il.proquest.com> wrote:

Um, at the risk of asking the obvious, what does this:

	cd /oracle/oradata/VLTEST1/backup
	df -k .
	

	tell you?
	 
	In other words, is there space in the directory you're backing

up to?

-Mark

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of laura pena

	Sent: Wednesday, December 07, 2005 3:00 PM
	To: Oracle-L Freelists
	Subject: RMAN error on level0 backup after controlfile recovery

to new server

	I need some help with an RMAN issue.
	I restored a database to a new server using an RMAN level0
backup.
	I then renamed the database and all the files to the new
instance name.
	I am not using an RMAN catalog.
	When I try and backup the database doing a level0 RMAN backup I

get this error:

	channel ORA_DISK_1: starting piece 31 at 12-02-2005 20:34:36
	RMAN-00571:
===========================================================
	RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS
===============
	RMAN-00571:
===========================================================
	RMAN-03009: failure of backup command on ORA_DISK_1 channel at
12/02/2005 20:35:42
	ORA-19502: write error on file

"/oracle/oradata/VLTEST1/backup/VLTEST1_L0_20051202_S8_P31_C1_08h5afdv.R MAN", blockno 133377 (blocksize=8192)

	ORA-27063: skgfospo: number of bytes read/written is incorrect
	Additional information: 8192
	Additional information: 1048576
	 
	I found notes on the Oracle Support Site to the following:
	I have set the default channel size to 2G.
	I have set the maxpiecesize to 2G.
	I have tried recreating the spfile.
	I am not running out of disk space.
	I verified that there are no files in need of recovery.
	 
	My RMAN level0 backup is still failing.
	Any ideas?
	 
	Thanks.


________________________________


	Yahoo! Personals
	Skip the bars and set-ups and start using Yahoo! Personals for

free
<http://us.rd.yahoo.com/evt=36107/*http://personals.yahoo.com/us/reg/fre e7days>

Yahoo! DSL
<http://pa.yahoo.com/*http://us.rd.yahoo.com/evt=37474/*http://promo.yah oo.com/broadband/> Something to write home about. Just $16.99/mo. or less

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

Received on Wed Dec 07 2005 - 14:38:57 CST