[Oracle-l] Link to RMAN alternate host restore

[Oracle-l] Link to RMAN alternate host restore

	Smith, Ron L.
	Aug 22, 2005 at 9:05 am

I need to restore our production database to a new server. I have RMAN
(9i) backups on disk, but the original server is not available. No
catalog was used.
Can anyone point be to any instructions on doing this?

Thanks!
Ron

--
http://www.freelists.org/webpage/oracle-l

Search Discussions

Discussion Posts

Follow ups

David Sharples: do you remember the dbid? - if you dont you are in trouble I believe -- http://www.freelists.org/webpage/oracle-l
Smith, Ron L.: I do. -----Original Message----- From: David Sharples Sent: Monday, August 22, 2005 9:12 AM To: Smith, Ron L. Cc: oracle-l_at_freelists.org Subject: Re: Link to RMAN alternate host restore do you remember the dbid? - if you dont you are in trouble I believe Important Notice!! If you are not the intended recipient of this e-mail message, any use, distribution or copying of the message is prohibited. Please let me know immediately by return e-mail if you have received this message by mistake,
Mladen Gogala: Actually, he's not. If he used %F format to backup the controlfile (that is default), he can find it out quite easily: %F = c-DBID-sysdate-xx When the DBID is known, he can do something like this: connect target / startup force nomount set dbid=2675037873; run { allocate channel c1 device type disk format '/u05/eora6/bkp_hot_%U'; SET CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/u05/eora6/bkp_hot_cont_%F'; restore controlfile from autobackup; alter database mount; restore database; }

Related Discussions

Discussion Navigation

view	thread \| post
posts	‹ prev \| 1 of 9 \| next ›

Discussion Overview

group	oracle-l @
categories	oracle
posted	Aug 22, '05 at 9:05a
active	Aug 22, '05 at 11:11a
posts	9
users	5
website	oracle.com

font	variable	Hotkey: f
user style	avatars	Hotkey: a

[Oracle-l] Link to RMAN alternate host restore

Search Discussions

Discussion Posts

Related Discussions

5 users in discussion