RMAN restore from disk with files in a new location 2004-06-02 - By Keith Moore
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 (See ORA-19624.ora-code.com): operation failed, retry possible
ORA-19505 (See ORA-19505.ora-code.com): failed to identify file "/u17/backup/df_DMS_t527180414_s4967_p1 "
ORA-27037 (See ORA-27037.ora-code.com): unable to obtain file status
HP-UX Error: 2: No such file or directory
Additional information: 3
ORA-06512 (See ORA-06512.ora-code.com): at "SYS.X$DBMS_BACKUP_RESTORE ", line 925
RMAN-10031: ORA-19624 (See ORA-19624.ora-code.com) 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@(protected)
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN " >
<HTML > <HEAD >
<META http-equiv=Content-Type content= "text/html; charset=iso-8859-1 " >
<META content= "MSHTML 6.00.2800.1400 " name=GENERATOR >
<STYLE > </STYLE >
</HEAD >
<BODY bgColor=#ffffff >
<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 > </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.
|
|
