Re: Link to RMAN alternate host restore
- From: Mladen Gogala <mgogala@xxxxxxxxxxxxxxxxxxxx>
- To: davidsharples@xxxxxxxxx
- Date: Mon, 22 Aug 2005 10:22:05 -0400
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
--
//www.freelists.org/webpage/oracle-l
Other related posts: