Again, thanks to all for their tips/help!!!
-Gary
From: Janardhana Babu Donga <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Subject: RE: RMAN - problems restoring to clone server
Date: Fri, 31 Jan 2003 10:57:04 -0800
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.
-- Babu
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.
-- Babu
-----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 <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED], "Gary Jackson" <[EMAIL PROTECTED]>
>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
_________________________________________________________________
The new MSN 8: smart spam protection and 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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
_________________________________________________________________
Tired of spam? Get advanced junk mail protection with MSN 8. http://join.msn.com/?page=features/junkmail
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Gary Jackson
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
