Re: Link to RMAN alternate host restore

David Sharples wrote:

>do you remember the dbid? - if you dont you are in trouble I believe
>
>
>

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;
}
bash-2.03$

Few hours later, the database was working. May the farce be with you, young padawan!

-- 
Mladen Gogala
Oracle DBA
Ext. 121


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