Re: Is it possible to recover just one datafile/tablespace "until cancel"?

From: Noons <wizofoz2k_at_yahoo.com.au>
Date: Wed, 1 Oct 2003 15:43:55 +1000
Message-ID: <3f7a6b56$0$13416$afc38c87@news.optusnet.com.au>

"Howard J. Rogers" <howardjr2000_at_yahoo.com.au> wrote in message news:3f7a5a50$0$13656$afc38c87_at_news.optusnet.com.au...

> procedures are unlikely to work when they are (eventually) tried. The
> suggestion of a cold backup before starting any recovery is an excellent
> one -though often not practical in a production 24x7 environment :-(

Often a quick backup of one of the copies of control files (or the split of the softmirror in init.ora) and a backup of the online redo logs is all that's needed. Takes only a few minutes and allows for a re-start of proceedings if something goes terribly wrong.

-- 
Cheers
Nuno Souto
wizofoz2k_at_yahoo.com.au.nospam

Received on Wed Oct 01 2003 - 00:43:55 CDT