| 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
Thank you all for your help on this. The solution was a misconfiguration of
Legato. My tape SA and I discovered that Legato had not been configured to
allow permissions for files to be restored from my source database to my
clone database. We granted this through the 'nwrecover', and the database
has begun its restore process.
Again, thanks to all for their tips/help!!! -Gary
>From: Janardhana Babu Donga <jbdonga_at_ucdavis.edu>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>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 <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
>
>
>_________________________________________________________________
>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: 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).
-- 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).Received on Fri Jan 31 2003 - 14:23:55 CST
 |
 |