| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: RMAN - problems restoring to clone server
Contd....
It looks to me that you are trying to restore to Ariel from Delenn (where
catalog database resides). You must log in to the Ariel Box, switch to the
DB using "oraenv", then connect to DB on Ariel( which is in nomount state)
and the catalog DB (Delenn) as:
rman target / catalog rman/rman@<connect string for catalog DB>.
then follow the instructions below. Make sure you have permission to restore
to ARIEL from the backup taken by BRAIN.
I do this many times with Veritas NetBackup. The steps may be similar for legato with slight variation.
[1] By Default Netbackup or Legato restores files only to the client from which the files were backed up(Brain). Your Netbackup administrator should configure to let you restore to an alternate client(Ariel). There may be similar steps for Legato.
[2] Startup nomount
[3] run {
allocate channel t1 type 'SBT_TAPE'
parms="ENV=(NB_ORA_CLIENT=brain.xxxx.com; export
NB_ORA_CLIENT)";
restore controlfile;
alter database mount;
Look for similar parameter for Legato, may be NSR_CLIENT in place of NB_ORA_CLIENT. [4] run {
allocate channel t1 type 'SBT_TAPE'
parms="ENV=(NB_ORA_CLIENT=brain.xxxx.com; export
NB_ORA_CLIENT)";
restore database;
Hope this helps.
-----Original Message-----
Sent: Friday, January 31, 2003 8:39 AM
To: Multiple recipients of list ORACLE-L
Legato Networker version 6.1.1.Build.238
OS: SunOS 5.6
Database: Oracle8 Enterprise Edition Release 8.0.4.4.0
TIA!
>From: Jared Still <jkstill_at_cybcon.com>
>To: ORACLE-L_at_fatcity.com, "Gary Jackson" <fred_fred_1_at_hotmail.com>
>Subject: Re: RMAN - problems restoring to clone server
>Date: Fri, 31 Jan 2003 07:02:06 -0800
>
>
>What is your MML?
>
>Jared
>
>On Thursday 30 January 2003 11:56, Gary Jackson wrote:
> > The support analyst handling my TAR gave up, perhaps someone on here can
> > help me out...
> >
> > I have an 8.0.4.4.0 database. I used RMAN to perform a full backup of
>my
> > database on server A (Brain). The RMAN recovery catalog database is on
> > server B (Delenn). I am attempting to restore it to a 3rd instance which
>is
> > on server C (Ariel). On server C I created a new instance and it is in
> > startup nomount currently. From server B I am attempting to restore to
> > server C.
> >
> > run {
> > allocate channel t1 type 'SBT_TAPE' parms
> > 'ENV=(NSR_SERVER=delenn,NSR_CLIENT=ariel)';
> > set newname for datafile 1 to '/usr/oracle/DB1/datfiles/system01.dbf';
> > set newname for datafile 2 to '/usr/oracle/DB1/datfiles/rbs01.dbf';
> > set newname for datafile 3 to '/usr/oracle/DB1/datfiles/temp01.dbf';
> > set newname for datafile 4 to '/usr/oracle/DB1/datfiles/user01.dbf';
> > restore database;
> > release channel t1;
> > }
> >
> >
> > --------------------------------
> >
> > RMAN-10032: unhandled exception during execution of job step 1:
>ORA-06512:
> > at line 137
> > RMAN-10035: exception raised in RPC: ORA-19624: operation failed, retry
> > possible
> > ORA-19507: failed to retrieve sequential file,
> > handle="Incr_level0_db_DB1_151_1.hot", parms=""
> > ORA-27007: failed to open file
> > Additional information: 7009
> > Additional information: 2
> > ORA-06512: at "SYS.X$DBMS_BACKUP_RESTORE", line 925
> > RMAN-10031: ORA-19624 occurred during call to
> > DBMS_BACKUP_RESTORE.RESTOREBACKUPPIECE
> >
> >
> >
> > _________________________________________________________________
> > Help STOP SPAM with the new MSN 8 and get 2 months FREE*
> > http://join.msn.com/?page=features/junkmail
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gary Jackson INET: fred_fred_1_at_hotmail.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Janardhana Babu Donga INET: jbdonga_at_ucdavis.edu Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Fri Jan 31 2003 - 12:57:04 CST
 |
 |