Re: Restore question

  • From: "Alex Fatkulin" <afatkulin@xxxxxxxxx>
  • To: cemail_219@xxxxxxxxxxx
  • Date: Wed, 31 Dec 2008 15:02:45 -0500

unless I am missing something...

if I understood correctly, your situation is this:

1. you took a full hot DB backup
2. you shut DB down
3. some datafiles were lost/erased
4. You can't start your DB due to datafiles you've lost on step 3 and
now wandering what to do next

if the above is true then

all you have to do is normally restore + recover stuff you've lost on
step 3 (no old controlfile required, shutdown is irrelevant either)

if you've lost not system/undo type of stuff then you can even offline
drop missing datafiles, open your DB and restore missing files
thereafter, I blogged about it recently

On Wed, Dec 31, 2008 at 2:51 PM, J. Dex <cemail_219@xxxxxxxxxxx> wrote:
> Is it possible to restore from a hot backup that was taken prior to a
> database being shutdown.  We had an RMAN hot backup running in archivelog
> mode.  The database was shutdown and them some files are lost before it was
> restarted  Isn't it possible to just point to the oldest controlfile that
> was taken during the last hot backup and restore from that?
> ________________________________
> Send e-mail anywhere. No map, no compass. Get your Hotmail(R) account now.

Alex Fatkulin,

Other related posts: