Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: RMAN - problems restoring to clone server
Can you please clarify what you mean by "linking the MML to Oracle"? I am
unable to create the RMAN schema,table,and views on the 'to-be-clone'
database yet since it is just a non-mounted instance at this point in time.
I assumed I would connect to rman as a rcvcat on the server with the dbcat database and the legato tape device. Then connect as the target to the to-be-clone non-mounted instance. Is this correct?
Then in the restore rman script I use:
NSR_SERVER as the tape device/dbcat server
NSR_CLIENT as the to-be-clone target server
Is this correct?
Thanks in advance!
-Gary
>From: Paula_Stankus_at_doh.state.fl.us
>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 08:24:44 -0800
>
>Are you sure that you have linked your MML to Oracle RDBMS on all hosts? I
>thought NSR_SERVER needed to be set to the host on which the target was -
>due to the fact that the client indexes on each database target host stores
>information on the backupsets.
>
>-----Original Message-----
>Sent: Friday, January 31, 2003 10:05 AM
>To: Multiple recipients of list ORACLE-L
>
>
>
>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: Jared Still
> INET: jkstill_at_cybcon.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: 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 - 11:20:17 CST
![]() |
![]() |