Re: Oracle screws up Sun host

From: NetComrade <andreyNSPAM_at_bookexchange.net>
Date: Tue, 22 Apr 2003 14:27:04 GMT
Message-ID: <3ea550c8.621054729@nyc.news.speakeasy.net>

On Tue, 22 Apr 2003 02:16:35 +0200, Rick Denoire <100.17706_at_germanynet.de> wrote:

>
>The processes that I had to kill were archiver processes. Now I
>remember that four days ago the archiver was blocked ("no destination
>available") because too many redologs were produced as the DB was
>reorganized and tables were moved. What I did was to delete some of
>these archived logs, "archive log stop", "archive log all", "archive
>log start" and everything seemed to go well. It just seemed.

For large reorgs it's best to stop archiving, do a backup after reorg and start archiving again.. I know these things are tough to plan, but it would have saved you from killing ora processes.

Here's a link to ORA-0600 analyzer, btw:

http://metalink.oracle.com/metalink/plsql/showdoc?db=NOT&id=153788.1&blackframe=0 .......
We use Oracle 8.1.7.4 on Solaris 2.7 boxes remove NSPAM to email Received on Tue Apr 22 2003 - 09:27:04 CDT