Skip to Content
avatar image
Former Member

how to deactivate logging via brtools

Hello

I wander how to deactivate logging via brtools(640)

regards

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Oct 03, 2006 at 12:31 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 13, 2007 at 10:42 AM

    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

    Add comment
    10|10000 characters needed characters exceeded