Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: how to recover/restore a database using archive logs & control files 8i

Re: how to recover/restore a database using archive logs & control files 8i

From: gazzag <gareth_at_jamms.org>
Date: 4 Oct 2005 09:00:42 -0700
Message-ID: <1128441642.539676.151140@z14g2000cwz.googlegroups.com>


Yes. Just hit return to use the suggested log filename.

If you're lucky, eventually you'll see "Media recovery complete." At this point, shut down the database and make a consistent filesystem copy of all the datafiles - keep it safe!

If you're unlucky, Oracle might start telling you that a different datafile needs recovery. If the file exists, proceed as before. If not, you're going to have to try and restore it using the operating system.

Good luck. Received on Tue Oct 04 2005 - 11:00:42 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US