Oracle-L: RE: RMAN - problems restoring to clone server

From: <Paula_Stankus_at_doh.state.fl.us>
Date: Fri, 31 Jan 2003 10:57:00 -0800
Message-ID: <F001.00540BDE.20030131105700@fatcity.com>

There really are a number of ways to do this. Another gotcha - make sure the OS versions are the same otherwise you will have to relink the oracle software.

Go to metalink and type in NSR_SERVER and you will find a really useful note: 120188.1 "How To Restore A Database To A Second Node Using RMAN and Legato Networker"

You will not have to create to the RMAN catalog locally. As long as the RMAN binaries are there you will be able to run rman and connect to a remote RMAN catalog. Of course, this implies that you have your Net8 listener and clients (tnsnames.ora) setup appropriately. If you run: rman and you get a prompt and can successfully do the following connect rcvcat user/pass_at_databaselinkforrmancatalog connected successfully

Then you are using the rman catalog in a remote database (i.e. another host)
- no problem.

There are specific commands to link networker libraries to oracle libraries and you can do this relinking without the rman catalog or a database - just the oracle software and networker libraries.

The following is create granted NSR_SERVER is where the backup was done. Since you don't have a database or rman locally you will have to run rman with a connect command as above.

NSR_SERVER as the tape device/dbcat server NSR_CLIENT as the to-be-clone target server

Also, you likely will have to set your dbid to restore the correct control file.

See below:

disaster recover mgm with rman

Hi,
I simulate a disaster recover by losing all datafile, online redo and controlfile.
The db was backed up on tape and after that only redos were. I remove all db files and try to restore/recover with following

connect target /;
connect catalog system/manager_at_obk;
run {
debug on;
set command id to "REC_DB";
allocate channel ch1 type "SBT_TAPE"
parms "ENV=(NSR_DATA_VOLUME_POOL=RC)";
shutdown abort;
startup pfile=/opt/oracle/admin/instances/omc/pfile/initomc.ora nomount; restore controlfile;
alter database mount;
restore database;
recover database;
# Complete this last step only if no more archived logs need to be applied. alter database open resetlogs;
}

I got the error:

EXEC SQL AT RCVCAT begin dbms_rcvman . setDatabase ( upper ( :dbname:dbname_i ) , :rlscn , :rltime , :fhdbi:fhdbi_i ) ; end ; sqlcode=-20005
setDatabase: db_id is null
krmicomp: error 6004 signalled during compilation krmicomp: error 3002 signalled during compilation

RMAN-00571: =========================================================== 
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== 
RMAN-00571: =========================================================== 
RMAN-03002: failure during compilation of command 
RMAN-03013: command type: restore 
RMAN-03002: failure during compilation of command

RMAN-03013: command type: IRESTORE
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20005: target database name is ambiguous
RMAN-06097: text of failing SQL statement: begin dbms_rcvman . setDatabase ( upper ( :dbname:dbname_i ) , :rlscn , :rltime , :fhdbi:fhdbi_i ) ; end ; RMAN-06099: error occurred in source file: krmk.pc, line: 9140

Recovery Manager complete.
krmxcd: xc=6807624

Thanks in advance for help.

Hi,

Try to start the database in nomount from svrmgr and then connect with rman.

Harvinder

Hi,

you have coonected to the target before starting your restore operation and same time you are trying shutdown database inside the program. i think RMAN is confused about null db name .

you can shutdown and statrtup with nomount your target database before starting your job .

Hope this helps.

Pramod Gudula
pgudula_at_hotmail.com
Pramod.Gudula_at_colesmyer.com.au
ColesMyer Pty Ltd.
Australia

Thanks for suggestions,
but I tried to do what you suggest before posting my mail and It didn't work.
I try again this morning with same result. Bye

You need to recover the controlfile from the recovery catalog using the set dbid.

Try the following:

svrmgrl> connect internal
connected
svrmgrl> starutp nomount
exit
rman
RMAN> set dbid = <integer>
RMAN> connect target / catalog
allocate channel(s)
restore controlfile to 'apsolute path'
allocate channel d1 type disk
replicate controlfile from 'absolute path' sql 'alter database mount';
allocate channel
restore database
recover database
etc.....

Reem Munakash
Electronic Support

OK,
catching right dbid it works!
Thanks.

-----Original Message-----

Sent: Friday, January 31, 2003 12:20 PM
To: Multiple recipients of list ORACLE-L

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:
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).


_________________________________________________________________

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: 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:
INET: Paula_Stankus_at_doh.state.fl.us

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