Re: Oracle 7.2.3 emergency

From: Eric <eric_at_deptj.demon.co.uk>
Date: 12 Nov 2001 02:13:17 -0800
Message-ID: <70568f73.0111120213.43e980ef@posting.google.com>

jplebel_at_yahoo.com (Jean-Pierre Lebel) wrote in message news:<71ddcfd.0111100338.640c6082_at_posting.google.com>... <snip>

>  - I've restored the entire FS from backup tape because

> I wanted to turn off the archive feature in init.ora
> so I set log_archive_start = FALSE

Did you also do alter database noarchivelog; in mount state? If you missed this I think you should restore the backup again and move forward from there.

If you get the database running, do a full export immediately as this will show up any serious corruption.

>  - After rebooting the OS, Oracle appeared to start fine

> I could connect with SQL and look at tables and records,
> but as soon I ran my originally mentioned program again
> the database went into space so to speak.

Is this program new, or recently changed? If so, get someone to check it really carefully before running it again. In any case, run the queries it uses separately to see if any errors are produced.

What does the alert log say, were any trace files generated?

Regards,

Eric Junkermann Received on Mon Nov 12 2001 - 04:13:17 CST