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@(protected)> 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@(protected) [mailto:oracle-l-bounce@(protected)] 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 (See ORA-19502.ora-code.com): write error on file "/oracle/oradata/VLTEST1/backup/VLTEST1_L0 _20051202_S8_P31_C1_08h5afdv.RMAN", blockno 133377 (blocksize=8192) ORA-27063 (See ORA-27063.ora-code.com): 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
-- ---- ---- ---- ---- ---- ----- Yahoo! DSL Something to write home about. Just $16.99/mo. or less <DIV id=RTEContent> <DIV>I found notes on the Oracle Support Site to the following:</DIV> <DIV>I have set the default channel size to 2G.</DIV> <DIV>I have set the maxpiecesize to 2G.</DIV> <DIV>I have tried recreating the spfile .</DIV> <DIV>I am not running out of disk space.</DIV> <DIV>I verified that there are no files in need of recovery.</DIV><BR><BR><B><I>"Bobak, Mark" < ;Mark.Bobak@(protected)></I></B> wrote: <BLOCKQUOTE class=replbq style= "PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid"> <META content="MSHTML 6.00.2900.2769" name=GENERATOR> <DIV dir=ltr align=left><SPAN class=159550420-07122005><FONT face=Arial color=#0000ff size=2>Um, at the risk of asking the obvious, what does this:</FONT></SPAN></DIV> <DIV dir=ltr align =left><SPAN class=159550420-07122005><FONT face=Arial color=#0000ff size=2>< /FONT></SPAN> </DIV> <DIV dir=ltr align=left><SPAN class=159550420 -07122005><FONT face=Arial color=#0000ff size=2>cd /oracle/oradata/VLTEST1/backup</FONT></SPAN></DIV> <DIV dir=ltr align=left> <SPAN class=159550420-07122005><FONT face=Arial color=#0000ff size=2>df -k .< /FONT></SPAN></DIV><SPAN class=159550420-07122005></SPAN> <DIV dir=ltr align =left><BR><SPAN class=159550420-07122005><FONT face=Arial color=#0000ff size=2 >tell you?</FONT></SPAN></DIV> <DIV dir=ltr align=left><SPAN class=159550420 -07122005><FONT face=Arial color=#0000ff size=2></FONT></SPAN> </DIV> <DIV dir=ltr align=left><SPAN class=159550420-07122005><FONT face=Arial color= #0000ff size=2>In other words, is there space in the directory you're backing up to?</FONT></SPAN></DIV> <DIV dir=ltr align=left><SPAN class=159550420-07122005 ><FONT face=Arial color=#0000ff size=2></FONT></SPAN> </DIV> <DIV dir=ltr align=left><SPAN class=159550420-07122005><FONT face=Arial color=#0000ff size=2 >-Mark</FONT></SPAN></DIV> <DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left> <HR tabIndex=-1> <FONT face=Tahoma size=2><B>From:</B> oracle-l-bounce@(protected) [mailto:oracle-l-bounce @(protected)] <B>On Behalf Of </B>laura pena<BR><B>Sent:</B> Wednesday, December 07, 2005 3:00 PM<BR><B>To:</B> Oracle-L Freelists<BR><B>Subject:</B> RMAN error on level0 backup after controlfile recovery to new server<BR></FONT> <BR></DIV> <DIV></DIV> <DIV id=RTEContent>I need some help with an RMAN issue. </DIV> <DIV>I restored a database to a new server using an RMAN level0 backup.< /DIV> <DIV>I then renamed the database and all the files to the new instance name.</DIV> <DIV>I am not using an RMAN catalog.</DIV> <DIV>When I try and backup the database doing a level0 RMAN backup I get this error:</DIV> <DIV> </DIV> <DIV><FONT size=2> <DIV>channel ORA_DISK_1: starting piece 31 at 12-02-2005 20:34:36</DIV> <DIV>RMAN-00571: =================================== ========================</DIV> <DIV>RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============</DIV> <DIV>RMAN-00571: ===========================================================</DIV> <DIV>RMAN -03009: failure of backup command on ORA_DISK_1 channel at 12/02/2005 20:35:42< /DIV> <DIV>ORA-19502 (See ORA-19502.ora-code.com): write error on file "/oracle/oradata/VLTEST1/backup /VLTEST1_L0_20051202_S8_P31_C1_08h5afdv.RMAN", blockno 133377 (blocksize=8192)< /DIV> <DIV>ORA-27063 (See ORA-27063.ora-code.com): skgfospo: number of bytes read/written is incorrect</DIV> <DIV>Additional information: 8192</DIV> <DIV>Additional information: 1048576< /DIV> <DIV> </DIV> <DIV>I found notes on the Oracle Support Site to the following:</DIV> <DIV>I have set the default channel size to 2G.</DIV> <DIV>I have set the maxpiecesize to 2G.</DIV> <DIV>I have tried recreating the spfile .</DIV> <DIV>I am not running out of disk space.</DIV> <DIV>I verified that there are no files in need of recovery.</DIV> <DIV> </DIV> <DIV>My RMAN level0 backup is still failing.</DIV> <DIV>Any ideas?</DIV> <DIV> </DIV> <DIV>Thanks.</DIV></FONT></DIV> <div> <HR S IZE=1> <B>Yahoo! Personals</B><BR>Skip the bars and set-ups and <A href="http://us.rd .yahoo.com/evt=36107/*http://personals.yahoo.com/us/reg/free7days">start using Yahoo! Personals for free</A> </BLOCKQUOTE><BR></DIV><p> <hr size=1> <a href="http://pa.yahoo.com/*http://us.rd.yahoo.com/evt=37474/ *http://promo.yahoo.com/broadband/ ">Yahoo! DSL</a> Something to write home about. Just $16.99/mo. or less
