Links
• Home
• Oracle DBA Forum
Frequent Oracle Errors
•TNS:could not resolve the connect identifier specified
•Backtrace message unwound by exceptions
•invalid identifier
•PL/SQL compilation error
•internal error
•missing expression
•table or view does not exist
•end-of-file on communication channel
•TNS:listener unknown in connect descriptor
•insufficient privileges
•PL/SQL: numeric or value error string
•TNS:protocol adapter error
•ORACLE not available
•target host or object does not exist
•invalid number
•unable to allocate string bytes of shared memory
•resource busy and acquire with NOWAIT specified
•error occurred at recursive SQL level string
•ORACLE initialization or shutdown in progress
•archiver error. Connect internal only, until freed
•snapshot too old
•unable to extend temp segment by string in tablespace
•Credential retrieval failed
•missing or invalid option
•invalid username/password; logon denied
•unable to create INITIAL extent for segment
•out of process memory when trying to allocate string bytes
•shared memory realm does not exist
•cannot insert NULL
•TNS:unable to connect to destination
•remote database not found'>ora-02019
•exception encountered: core dump
•inconsistent datatypes
•no data found
•TNS:operation timed out
•PL/SQL: could not find program
•existing state of packages has been discarded
•maximum number of processes exceeded
•error signaled in parallel query server
•ORACLE instance terminated. Disconnection forced
•TNS:packet writer failure
•see ORA-12699
•missing right parenthesis
•name is already used by an existing object
•cannot identify/lock data file
•invalid file operation
•quoted string not properly terminated
RMAN restore from disk with files in a new location

RMAN restore from disk with files in a new location

2004-06-02       - By Jared.Still@(protected)

Reply:     1     2     3     4     5  

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@(protected) 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 (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) 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.


<br > <font size=2 face= "sans-serif " >Here 's an example for 8i: </font >
<br >
<br > <font size=2 face= "sans-serif " >http://www.cybcon.com/~jkstill/Alternate_Client_Restore_With_Veritas_NetBackup_and_Oracle_RMAN.doc </font >
<br >
<br > <font size=2 face= "sans-serif " >9i is much easier, the 'duplicate ' command
I think. </font >
<br >
<br > <font size=2 face= "sans-serif " >Jared </font >
<br >
<br > <font size=2 > <tt >oracle-l-bounce@(protected) wrote on 06/02/2004
08:24:48 AM: <br >
<br >
> Is it possible to restore from a backup set where the set is in a
<br >
> different disk location from where it was originally created. </tt > </font >
<br > <font size=2 > <tt >>   </tt > </font >
<br > <font size=2 > <tt >> For example: </tt > </font >
<br > <font size=2 > <tt >> 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; </tt > </font >
<br > <font size=2 > <tt >>   ... <br >
> } </tt > </font >
<br > <font size=2 > <tt >> The backup sets were created in the /u17/backup
and /u18/backup <br >
> directories and the script give me the following error: </tt > </font >
<br > <font size=2 > <tt >>   </tt > </font >
<br > <font size=2 > <tt >> RMAN-10035: exception raised in RPC: ORA-19624 (See ORA-19624.ora-code.com):
operation failed, <br >
> 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. <br >
> RESTOREBACKUPPIECE </tt > </font >
<br > <font size=2 > <tt >> Is there any way to tell RMAN that the backup
set is now in a new <br >
> location? This is Oracle8, but if it can 't be done in Oracle8, can
<br >
> it be done in 9i? </tt > </font >
<br > <font size=2 > <tt >>   </tt > </font >
<br > <font size=2 > <tt >> BTW, this IS just a test and not a real recovery. </tt > </font >
<br > <font size=2 > <tt >>   </tt > </font >
<br > <font size=2 > <tt >> Thanks, </tt > </font >
<br > <font size=2 > <tt >>   </tt > </font >
<br > <font size=2 > <tt >> Keith Moore <br >
> Oracle Certified Professional <br >
> 972-431-5126 <br >
> kmoore7@(protected) information transmitted is intended only for <br >
> the person or entity to <br >
> which it is addressed and may contain confidential and/or privileged <br >
> material.  If the reader of this message is not the intended
recipient, <br >
> you are hereby notified that your access is unauthorized, and any
review, <br >
> dissemination, distribution or copying of this message including any <br >
> attachments is strictly prohibited.   If you are not the intended <br >
> recipient, please contact the sender and delete the material from
any <br >
> computer. <br >
</tt > </font >