Re: Oracle 7.0 database recovery

On Sat, 10 Aug 2002 10:57:48 +0800, "KS" <fongks_at_no.spam.hotmail.com> wrote:

>Hi,
>
>I got 2 questions on Oracle database recovery questions, need your expert
>advice on that:
>
>1.If the archive log for the Oracle database is missing, but all the rest of
>the related data files are intact, can database recovery be possible?
>2.If the archive log for the Oracle database is missing, can we rebuild the
>archive log based on the data files using special Oracle tools/command and
>then attempt data recovery.
>
>OS: Digital UNIX V4.0
>Oracle Version: V7
>
>Thanks in advance
>
>
>

1 Restore the datafiles, recreate the controlfile, open the databse using resetlogs, and forget about what you are missing. 2 You can't be serious about this. You are asking to reconstruct After Image data from current datafiles. So, no, it is definitely not possible

BTW: if you are really using Oracle 7.0, so 8 year old software, I don't think even Oracle will be capable of helping you out.

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Sat Aug 10 2002 - 09:13:03 CDT