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.R MAN", 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 <http://us.rd.yahoo.com/evt=36107/*http://personals.yahoo.com/us/reg/fre e7days>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=Content-Type content="text/html; charset=us-ascii"> <META content="MSHTML 6.00.2900.2769" name=GENERATOR></HEAD> <BODY> <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> <P> <HR SIZE=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></BODY></HTML>
