Re: Newbie question re: logging in 8i

From: Sanjeev K Singh <SJKSINGH_at_prodigy.net>
Date: Sun, 28 Nov 1999 17:52:18 -0800
Message-ID: <81sm6i$54j2$1@newssvr04-int.news.prodigy.com>

Couple of Steps.

shutdown immediate.
In you init<SID>.ora file set LOG_ARCHIVE_START = False
Startup Mount
alter database noarchivelog
alter database open

Just to verify.
SVRMGR> archive log list
Look for Database Log Mode and Automatic Archival.

Hope it help.

Keith Sharp <ksharp_at_bear.com> wrote in message news:01bf3819$4ec4a030$9e10a8a5_at_emc2369...
> How can I change the logging of an Oracle 8i database to nologging. This
is
> for our test environment which we do not want to back up regularly.
>
Received on Sun Nov 28 1999 - 19:52:18 CST