From oracle-l-bounce@freelists.org Wed Jun 2 16:04:40 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i52L4Pr00915 for ; Wed, 2 Jun 2004 16:04:35 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i52L4F600879 for ; Wed, 2 Jun 2004 16:04:25 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 52EA672C9EF; Wed, 2 Jun 2004 15:50:53 -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 02959-51; Wed, 2 Jun 2004 15:50:53 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 38CDB72CA42; Wed, 2 Jun 2004 15:50:52 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 02 Jun 2004 15:49:32 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id AB35872C9C0 for ; Wed, 2 Jun 2004 15:49:31 -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 02791-21 for ; Wed, 2 Jun 2004 15:49:31 -0500 (EST) Received: from mx10.radisys.com (mx10.radisys.com [206.102.10.36]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 4ABB872C9B1 for ; Wed, 2 Jun 2004 15:49:31 -0500 (EST) Received: by mx10.radisys.com (Postfix, from userid 5) id 60E65142E27; Wed, 2 Jun 2004 14:07:47 -0700 (PDT) Received: from UNKNOWN(206.103.52.194), claiming to be "dcblackberry.radisys.com" via SMTP by mx10, id smtpdAAA0wSQ9V; Wed Jun 2 14:07:38 2004 In-Reply-To: <03c801c448b5$be3a51b0$7003200a@kmoore7> To: oracle-l@freelists.org Subject: Re: RMAN restore from disk with files in a new location MIME-Version: 1.0 X-Mailer: Lotus Notes Release 6.5.1 January 21, 2004 Message-ID: From: Jared.Still@radisys.com Date: Wed, 2 Jun 2004 14:07:36 -0700 X-MIMETrack: Serialize by Router on DCBlackBerry/Radisys_Corporation/US(Release 6.0.3|September 26, 2003) at 06/02/2004 02:01:36 PM, Serialize complete at 06/02/2004 02:01:36 PM Content-Type: multipart/alternative; boundary="=_alternative 00740AF688256EA7_=" X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 1817 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Jared.Still@radisys.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org --=_alternative 00740AF688256EA7_= Content-Type: text/plain; charset="US-ASCII" Here's an example for 8i: http://www.cybcon.com/~jkstill/Alternate_Client_Restore_With_Veritas_NetBackup_and_Oracle_RMAN.doc 9i is much easier, the 'duplicate' command I think. Jared oracle-l-bounce@freelists.org wrote on 06/02/2004 08:24:48 AM: > Is it possible to restore from a backup set where the set is in a > different disk location from where it was originally created. > > For example: > replace script test_full_recovery { > allocate channel d1 type disk format '/backup/df_%d_t%t_s%s_p%p'; > allocate channel d2 type disk format '/backup2/df_%d_t%t_s%s_p%p'; > restore database; > ... > } > The backup sets were created in the /u17/backup and /u18/backup > directories and the script give me the following error: > > RMAN-10035: exception raised in RPC: ORA-19624: operation failed, > retry possible > ORA-19505: failed to identify file "/u17/backup/df_DMS_t527180414_s4967_p1" > ORA-27037: unable to obtain file status > HP-UX Error: 2: No such file or directory > Additional information: 3 > ORA-06512: at "SYS.X$DBMS_BACKUP_RESTORE", line 925 > RMAN-10031: ORA-19624 occurred during call to DBMS_BACKUP_RESTORE. > RESTOREBACKUPPIECE > Is there any way to tell RMAN that the backup set is now in a new > location? This is Oracle8, but if it can't be done in Oracle8, can > it be done in 9i? > > BTW, this IS just a test and not a real recovery. > > Thanks, > > Keith Moore > Oracle Certified Professional > 972-431-5126 > kmoore7@jcpenney.comThe information transmitted is intended only for > the person or entity to > which it is addressed and may contain confidential and/or privileged > material. If the reader of this message is not the intended recipient, > you are hereby notified that your access is unauthorized, and any review, > dissemination, distribution or copying of this message including any > attachments is strictly prohibited. If you are not the intended > recipient, please contact the sender and delete the material from any > computer. --=_alternative 00740AF688256EA7_= Content-Type: text/html; charset="US-ASCII"
Here's an example for 8i:

http://www.cybcon.com/~jkstill/Alternate_Client_Restore_With_Veritas_NetBackup_and_Oracle_RMAN.doc

9i is much easier, the 'duplicate' command I think.

Jared

oracle-l-bounce@freelists.org wrote on 06/02/2004 08:24:48 AM:

> Is it possible to restore from a backup set where the set is in a
> different disk location from where it was originally created.
>  
> For example:
> replace script test_full_recovery {
>   allocate channel d1 type disk format '/backup/df_%d_t%t_s%s_p%p';
>   allocate channel d2 type disk format '/backup2/df_%d_t%t_s%s_p%p';
>   restore database;
>   ...
> }
> The backup sets were created in the /u17/backup and /u18/backup
> directories and the script give me the following error:
>  
> RMAN-10035: exception raised in RPC: ORA-19624: operation failed,
> retry possible
> ORA-19505: failed to identify file "/u17/backup/df_DMS_t527180414_s4967_p1"
> ORA-27037: unable to obtain file status
> HP-UX Error: 2: No such file or directory
> Additional information: 3
> ORA-06512: at "SYS.X$DBMS_BACKUP_RESTORE", line 925
> RMAN-10031: ORA-19624 occurred during call to DBMS_BACKUP_RESTORE.
> RESTOREBACKUPPIECE
> Is there any way to tell RMAN that the backup set is now in a new
> location? This is Oracle8, but if it can't be done in Oracle8, can
> it be done in 9i?
>  
> BTW, this IS just a test and not a real recovery.
>  
> Thanks,
>  
> Keith Moore
> Oracle Certified Professional
> 972-431-5126
> kmoore7@jcpenney.comThe information transmitted is intended only for
> the person or entity to
> which it is addressed and may contain confidential and/or privileged
> material.  If the reader of this message is not the intended recipient,
> you are hereby notified that your access is unauthorized, and any review,
> dissemination, distribution or copying of this message including any
> attachments is strictly prohibited.   If you are not the intended
> recipient, please contact the sender and delete the material from any
> computer.
 --=_alternative 00740AF688256EA7_=-- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------