From oracle-l-bounce@freelists.org Wed Dec 7 14:17:14 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id jB7KHE6p024183 for ; Wed, 7 Dec 2005 14:17:14 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id jB7KHAAX024168 for ; Wed, 7 Dec 2005 14:17:10 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 84F5B24CF3F; Wed, 7 Dec 2005 15:17:04 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 14424-04; Wed, 7 Dec 2005 15:17:04 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id F11EA24D4E8; Wed, 7 Dec 2005 15:17:03 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 07 Dec 2005 15:17:03 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id AEBCF24D81D for ; Wed, 7 Dec 2005 15:17:03 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 14424-03 for ; Wed, 7 Dec 2005 15:17:03 -0500 (EST) Received: from mail02.prod.il.pqe (mail00.il.proquest.com [165.215.88.19]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id D7A8E24D4E8 for ; Wed, 7 Dec 2005 15:17:01 -0500 (EST) Received: from AABO-EXCHANGE04.bos.il.pqe (aabo-exchange04.bos.il.pqe [172.24.3.208]) by mail02.prod.il.pqe (8.12.11/8.12.11) with ESMTP id jB7KGw3h012322; Wed, 7 Dec 2005 15:16:58 -0500 Received: from AABO-EXCHANGE02.bos.il.pqe ([172.24.3.200]) by AABO-EXCHANGE04.bos.il.pqe with Microsoft SMTPSVC(6.0.3790.211); Wed, 7 Dec 2005 15:16:58 -0500 X-MIMEOLE: Produced By Microsoft Exchange V6.5.7226.0 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C5FB6B.2D089ED6" Subject: RE: RMAN error on level0 backup after controlfile recovery to new server Date: Wed, 7 Dec 2005 15:18:57 -0500 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: RMAN error on level0 backup after controlfile recovery to new server Thread-Index: AcX7aw2OKBTwD8kFRQWShxntVKpcDQAAFqrQ From: "Bobak, Mark" To: "laura pena" , "Oracle-L Freelists" X-OriginalArrivalTime: 07 Dec 2005 20:16:58.0812 (UTC) FILETIME=[2D2FFFC0:01C5FB6B] X-archive-position: 29000 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Mark.Bobak@il.proquest.com Precedence: normal Reply-To: Mark.Bobak@il.proquest.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Not scanned: please contact your Internet E-Mail Service Provider for details X-MailScanner-From: oracle-l-bounce@freelists.org ------_=_NextPart_001_01C5FB6B.2D089ED6 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable Sorry, somehow I skipped right over that second to last line.....my bad. ________________________________ From: laura pena [mailto:lizzpenaorclgrp@yahoo.com]=20 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" wrote:=20 Um, at the risk of asking the obvious, what does this: =20 cd /oracle/oradata/VLTEST1/backup df -k . =09 tell you? =20 In other words, is there space in the directory you're backing up to? =20 -Mark ________________________________ From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@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 =09 =09 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: =20 =09 channel ORA_DISK_1: starting piece 31 at 12-02-2005 20:34:36 RMAN-00571: =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D RMAN-00569: =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D ERROR MESSAGE = STACK FOLLOWS =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D RMAN-00571: =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D 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=3D8192) ORA-27063: skgfospo: number of bytes read/written is incorrect Additional information: 8192 Additional information: 1048576 =20 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. =20 My RMAN level0 backup is still failing. Any ideas? =20 Thanks. ________________________________ Yahoo! Personals Skip the bars and set-ups and start using Yahoo! Personals for free =20 ________________________________ Yahoo! DSL Something to write home about. Just $16.99/mo. or less ------_=_NextPart_001_01C5FB6B.2D089ED6 Content-Type: text/html; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable
Sorry, somehow I skipped right over that second = to last=20 line.....my bad.


From: laura pena=20 [mailto:lizzpenaorclgrp@yahoo.com]
Sent: Wednesday, December = 07, 2005=20 3:15 PM
To: Bobak, Mark; Oracle-L Freelists
Subject: = RE:=20 RMAN error on level0 backup after controlfile recovery to new=20 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=20 recovery.


"Bobak, Mark"=20 <Mark.Bobak@il.proquest.com> wrote:=20
Um, at the risk of asking the obvious, what = does=20 this:
 
cd = /oracle/oradata/VLTEST1/backup
df -k .

tell you?
 
In other words, is there space in the = directory you're=20 backing up to?
 
-Mark

From: = oracle-l-bounce@freelists.org=20 [mailto:oracle-l-bounce@freelists.org] On Behalf Of laura=20 pena
Sent: Wednesday, December 07, 2005 3:00 = PM
To:=20 Oracle-L Freelists
Subject: RMAN error on level0 backup = after=20 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=20 error:
 
channel ORA_DISK_1: starting piece 31 at 12-02-2005 = 20:34:36
RMAN-00571:=20 = =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D
RMAN-00569: =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D ERROR = MESSAGE STACK FOLLOWS=20 =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
RMAN-00571:=20 = =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D
RMAN-03009: failure of backup command on ORA_DISK_1 channel at = 12/02/2005=20 20:35:42
ORA-19502: write error on file=20 = "/oracle/oradata/VLTEST1/backup/VLTEST1_L0_20051202_S8_P31_C1_08h5afdv.RM= AN",=20 blockno 133377 (blocksize=3D8192)
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=20 using Yahoo! Personals for free


Yahoo!=20 DSL Something to write home about. Just $16.99/mo. or = less ------_=_NextPart_001_01C5FB6B.2D089ED6-- -- http://www.freelists.org/webpage/oracle-l