-- --Original Message-- --
From: oracle-l-bounce@(protected)
[mailto:oracle-l-bounce@(protected)] On Behalf Of Keith Moore
Sent: Wednesday, June 02, 2004 10:25 AM
To: oracle-l@(protected)
Subject: RMAN restore from disk with files in a new location
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:
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@(protected)
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN " >
<HTML > <HEAD >
<META HTTP-EQUIV= "Content-Type " CONTENT= "text/html; charset=us-ascii " >
<TITLE >Message </TITLE >
<META content= "MSHTML 6.00.2800.1400 " name=GENERATOR >
<STYLE > </STYLE >
</HEAD >
<BODY bgColor=#ffffff >
<DIV > <SPAN class=397544816-02062004 > <FONT face=Arial
size=2 >Keith </FONT > </SPAN > </DIV >
<DIV > <SPAN class=397544816-02062004 > <FONT face=Arial
size=2 >you can use backup command in 9i..I thought, there was a document in
metalink for this, can 't find the document now. </FONT > </SPAN > </DIV >
<DIV > <SPAN class=397544816-02062004 > <FONT face=Arial
size=2 > </FONT > </SPAN > </DIV >
<DIV > <SPAN class=397544816-02062004 > <FONT face=Arial
size=2 >backup device type disk </FONT > </SPAN > </DIV >
<DIV > <SPAN class=397544816-02062004 > <FONT face=Arial
size=2 >format "/unew/backup/df_DMS_t%t_s%s_p%p ' </FONT > </SPAN > </DIV >
<DIV > <SPAN class=397544816-02062004 > <FONT face=Arial size=2 >
backupset <backup_set_key_from list backup command> </FONT > </SPAN > </DIV >
<DIV > <SPAN class=397544816-02062004 > <FONT face=Arial
size=2 >delete input; </FONT > </SPAN > </DIV >
<DIV > <SPAN class=397544816-02062004 > <FONT face=Arial
size=2 > </FONT > </SPAN > </DIV >
<DIV > <SPAN class=397544816-02062004 > <FONT face=Arial size=2 >I
think, delete input is to avoid duplicates.. </FONT > </SPAN > </DIV >
<DIV > <SPAN class=397544816-02062004 > <FONT face=Arial
size=2 > </FONT > </SPAN > </DIV >
<DIV > <SPAN class=397544816-02062004 > <FONT face=Arial
size=2 >Not sure whether you can do this in pre-9i, but take a look at the table
'bp ' if you use rman catalog ;-) </FONT > </SPAN > </DIV >
<DIV > <SPAN class=397544816-02062004 > <FONT face=Arial
size=2 > </FONT > </SPAN > </DIV >
<DIV align=left > <FONT face=Verdana size=2 >Thanks </FONT > </DIV >
<DIV align=left > <FONT face=Verdana size=2 >Riyaj "Re-yas " Shamsudeen </FONT > </DIV >
<DIV align=left > <FONT face=Verdana size=2 >Certified Oracle DBA </FONT > </DIV >
<BLOCKQUOTE dir=ltr style= "MARGIN-RIGHT: 0px " >
<DIV > </DIV >
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left > <FONT
face=Tahoma size=2 >-- --Original Message-- -- <BR > <B >From: </B >
oracle-l-bounce@(protected) [mailto:oracle-l-bounce@(protected)] <B >On
Behalf Of </B >Keith Moore <BR > <B >Sent: </B > Wednesday, June 02, 2004 10:25
AM <BR > <B >To: </B > oracle-l@(protected) <BR > <B >Subject: </B > RMAN restore from
disk with files in a new location <BR > <BR > </FONT > </DIV >
<DIV > <FONT face=Arial size=2 >Is it possible to restore from a backup set where
the set is in a different disk location from where it was originally
created. </FONT > </DIV >
<DIV > <FONT face=Arial size=2 > </FONT > </DIV >
<DIV > <FONT face=Arial size=2 >For example: </FONT > </DIV >
<DIV > <FONT face=Arial size=2 >replace script test_full_recovery { <BR >
allocate channel d1 type disk format '/backup/df_%d_t%t_s%s_p%p '; <BR >
allocate channel d2 type disk format '/backup2/df_%d_t%t_s%s_p%p '; <BR >
restore database; </FONT > </DIV >
<DIV > <FONT face=Arial size=2 > ... <BR >} <BR > </FONT > </DIV >
<DIV > <FONT face=Arial size=2 >The backup sets were created in the /u17/backup
and /u18/backup directories and the script give me the following
error: </FONT > </DIV >
<DIV > <FONT face=Arial size=2 > </FONT > </DIV >
<DIV > <FONT face=Arial size=2 >RMAN-10035: exception raised in RPC: ORA-19624 (See ORA-19624.ora-code.com):
operation failed, retry possible <BR >ORA-19505 (See ORA-19505.ora-code.com): failed to identify file
"/u17/backup/df_DMS_t527180414_s4967_p1 " <BR >ORA-27037 (See ORA-27037.ora-code.com): unable to obtain file
status <BR >HP-UX Error: 2: No such file or directory <BR >Additional information:
3 <BR >ORA-06512 (See ORA-06512.ora-code.com): at "SYS.X$DBMS_BACKUP_RESTORE ", line 925 <BR >RMAN-10031:
ORA-19624 (See ORA-19624.ora-code.com) occurred during call to
DBMS_BACKUP_RESTORE.RESTOREBACKUPPIECE <BR > </FONT > </DIV >
<DIV > <FONT face=Arial size=2 >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? </FONT > </DIV >
<DIV > <FONT face=Arial size=2 > </FONT > </DIV >
<DIV > <FONT face=Arial size=2 >BTW, this IS just a test and not a real
recovery. </FONT > </DIV >
<DIV > <FONT face=Arial size=2 > </FONT > </DIV >
<DIV > <FONT face=Arial size=2 >Thanks, </FONT > </DIV >
<DIV > <FONT face=Arial size=2 > </DIV > </FONT >
<DIV > <FONT face=Arial size=2 >Keith Moore <BR >Oracle Certified
Professional <BR >972-431-5126 <BR > <A
href= "mailto:kmoore7@(protected) " >kmoore7@(protected) </A > </FONT > </DIV > </BLOCKQUOTE > </BODY > </HTML >
The 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.
