how to deactivate logging via brtools

[Former Member]

Hello

I wander how to deactivate logging via brtools(640)

regards

[Former Member · Accepted solution]

Hello,

Do you mean how to set the database in NOLOGIN mode?

if so, keep in mind the consequences of doing so.

Here are the steps:

brtools

1 = Instance management

3 - Alter database instance

Continue on the next screen to start BRSPACE

Then you have the options:

3 - Set archivelog mode

4 - Set noarchivelog mode

[Former Member]

hello,

Can u pl specify by logging what do u exactly mean?

I want to know if u meant to prevent users from logging to the database

or u want to deactivate the archivelog mode.

In the first if u want no user interaction on the database then take the database to mount mode instead of open mode by executing the following SQL

ALTERDATABASE MOUNT;

In the second case, if u want to turn the archivelog mode then do what VAle has suggested. But taking the database to nolog mode has a lot of serious demerits in the context to recovery and restoration of database in case of a crash. U wont be able to get the archive logfiles as the redo logfiles are over written in case of the database is in nolog mode.

So think twice before u take the database into nologmode.

Regards