Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 22568 invoked from network); 20 Apr 2007 14:02:00 -0500 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by 69.64.49.119 with SMTP; 20 Apr 2007 14:02:00 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id B92AA6C0765; Fri, 20 Apr 2007 15:00:21 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 11727-02; Fri, 20 Apr 2007 15:00:21 -0400 (EDT) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 322156C0772; Fri, 20 Apr 2007 15:00:21 -0400 (EDT) Received: with ECARTIS (v1.0.0; list oracle-l); Fri, 20 Apr 2007 14:21:39 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 7B3DC6C0A78 for ; Fri, 20 Apr 2007 14:21:39 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 06829-01 for ; Fri, 20 Apr 2007 14:21:39 -0400 (EDT) Received: from mail130.messagelabs.com (mail130.messagelabs.com [216.82.250.163]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with SMTP id 532B16C037A for ; Fri, 20 Apr 2007 14:21:25 -0400 (EDT) X-VirusChecked: Checked X-Env-Sender: ashoke.k.mandal@medtronic.com X-Msg-Ref: server-2.tower-130.messagelabs.com!1177093372!6445756!1 X-StarScan-Version: 5.5.10.7.1; banners=-,-,- X-Originating-IP: [144.15.156.71] Received: (qmail 14979 invoked from network); 20 Apr 2007 18:22:53 -0000 Received: from mspinfra3.medtronic.com (HELO mspinfra3.medtronic.com) (144.15.156.71) by server-2.tower-130.messagelabs.com with AES256-SHA encrypted SMTP; 20 Apr 2007 18:22:53 -0000 Received: from MSPM1BMSGH01.ent.core.medtronic.com (localhost [127.0.0.1]) by mspinfra3.medtronic.com (8.13.6/8.13.6) with ESMTP id l3KIMqXZ013257 for ; Fri, 20 Apr 2007 13:22:52 -0500 (CDT) Received: from MSPM1BMSGM04.ent.core.medtronic.com ([172.24.112.56]) by MSPM1BMSGH01.ent.core.medtronic.com with Microsoft SMTPSVC(6.0.3790.2499); Fri, 20 Apr 2007 13:22:52 -0500 X-MimeOLE: Produced By Microsoft Exchange V6.5 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C78378.E8574846" Subject: URGENT RMAN question Date: Fri, 20 Apr 2007 13:22:50 -0500 Message-ID: In-Reply-To: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: URGENT RMAN question References: From: "Mandal, Ashoke" To: "oracle-l" X-OriginalArrivalTime: 20 Apr 2007 18:22:52.0261 (UTC) FILETIME=[E8747950:01C78378] X-archive-position: 48162 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: ashoke.k.mandal@medtronic.com Precedence: normal Reply-to: ashoke.k.mandal@medtronic.com List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l X-Virus-Scanned: Debian amavisd-new at localhost.localdomain ------_=_NextPart_001_01C78378.E8574846 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable One of my friend is getting the following error while restoring 1.5TB data in windows environment. As I understand that some of the backup sets are missing and the database is restored up to 78%. . =0D He got the missing backup sets. How can he restore the data files from the missing backup sets? What commands should he use? =0D Thanks in advance, Ashoke =0D channel ORA_DISK_1: reading from backup piece Z:\BACKUPS\22IF5B2R_12_1 ORA-19501: read error on file "Z:\BACKUPS\22IF5B2R_12_1", blockno 64256 (blocksize=3D8192) ORA-27070: async read/write failed OSD-04016: Error queuing an asynchronous I/O request. O/S-Error: (OS 121) The semaphore timeout period has expired. ORA-19870: error reading backup piece Z:\BACKUPS\22IF5B2R_12_1 ORA-19501: read error on file "Z:\BACKUPS\22IF5B2R_12_1", blockno 64000 (blocksize=3D8192) ORA-27070: async read/write faile =0D 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-03002: failure of restore command at 04/17/2007 15:29:57 RMAN-06026: some targets not found - aborting restore RMAN-06023: no backup or copy of datafile 3 found to restore =0D ___________________________________________________________________________= ________________________ CONFIDENTIALITY AND PRIVACY NOTICE Information transmitted by this email is proprietary to Medtronic and is= intended for use only by the individual or entity to which it is= addressed, and may contain information that is private, privileged,= confidential or exempt from disclosure under applicable law. If you are= not the intended recipient or it appears that this mail has been forwarded= to you without proper authority, you are notified that any use or= dissemination of this information in any manner is strictly prohibited. In= such cases, please delete this mail from your records. http://emaildisclaimer.medtronic.com ------_=_NextPart_001_01C78378.E8574846 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable
One of my friend is getting the following error= while=0D restoring 1.5TB data in windows environment.
As I understand that some of the backup sets are= =0D missing and the database is restored up to 78%. .
 
He got the missing backup sets. How can he= restore the=0D data files from the missing backup sets? What commands should he=0D use?
 
Thanks in advance,
Ashoke
 

channel ORA_DISK_1: reading from backup piece=0D Z:\BACKUPS\22IF5B2R_12_1

ORA-19501: read error on file= "Z:\BACKUPS\22IF5B2R_12_1",=0D blockno 64256 (blocksize=3D8192)

ORA-27070: async read/write=0D failed

OSD-04016: Error queuing an asynchronous I/O=0D request.

O/S-Error: (OS 121) The semaphore timeout period has=0D expired.

ORA-19870: error reading backup piece=0D Z:\BACKUPS\22IF5B2R_12_1

ORA-19501: read error on file= "Z:\BACKUPS\22IF5B2R_12_1",=0D blockno 64000 (blocksize=3D8192)

ORA-27070: async read/write faile

 

RMAN-00571:=0D =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=0D =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D

RMAN-00571:=0D =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-03002: failure of restore command at 04/17/2007=0D 15:29:57

RMAN-06026: some targets not found - aborting=0D restore

RMAN-06023: no backup or copy of datafile 3 found to=0D restore

 

________________________________________________________________= ___________________________________
CONFIDENTIALITY AND PRIVACY NOTICE
Information transmitted by this email is proprietary to Medtronic and is= intended for use only by the individual or entity to which it is= addressed, and may contain information that is private, privileged,= confidential or exempt from disclosure under applicable law. If you are= not the intended recipient or it appears that this mail has been forwarded= to you without proper authority, you are notified that any use or= dissemination of this information in any manner is strictly prohibited. In= such cases, please delete this mail from your records.
http://emaildisclaimer.medtronic.com
------_=_NextPart_001_01C78378.E8574846-- -- http://www.freelists.org/webpage/oracle-l