Re: Missing UNDO & TEMP datafiles in cold backup
From: Connor McDonald <mcdonald.connor_at_gmail.com>
Date: Thu, 28 May 2015 09:49:21 +0800
Message-ID: <CAB=aETC2LHwEkxpT-=1cvysX8VPMBK0Qak7yWVy8j=K5piG-eQ_at_mail.gmail.com>
Missing TEMP is of no consequence.
Date: Thu, 28 May 2015 09:49:21 +0800
Message-ID: <CAB=aETC2LHwEkxpT-=1cvysX8VPMBK0Qak7yWVy8j=K5piG-eQ_at_mail.gmail.com>
Missing TEMP is of no consequence.
Missing UNDO is a big drama. There are sometimes ways of getting a database running without undo, with all sorts of underscore parameters etc...but you end up with a running database where you dont really have much confidence in the data...which could almost be worse than not having one at all
Cheers,
Connor
On Thu, May 28, 2015 at 3:52 AM, Manjula Krishnan <oradba.la_at_gmail.com> wrote:
> I have all datafiles, control files & redo log files.What do I need to do
> to restore this database with a different SID?
>
> Thanks,
>
> Manjula
>
-- Connor McDonald =========================== blog: connormcdonald.wordpress.com web: http://www.oracledba.co.uk "If you are not living on the edge, you are taking up too much room." - Jayne Howard -- http://www.freelists.org/webpage/oracle-lReceived on Thu May 28 2015 - 03:49:21 CEST