Re: How to change control file parameter - MAXLOGMEMBERS

Hi,

first log on to the databse as a dba.
Type in

alter database backup controlfile to trace;

exit the sqlplus and have a look in your user dump directory. This = mostly resides under
ORACLE_BASE/admin/<SID>/udump. The latest .trc file should be your = create controlfile script.
Make your changes (in this case MAXLOGMEMBERS 2). Shutdown your database = and run this script with
the server manager. If this fails do it by hand with copy and paste.

good luck

Detlev

    zenithh schrieb in Nachricht <3715E3C9.89C478FB_at_netscape.com>...     Hello everybody,
    I need to change MAXLOGMEMBERS value from 2 to 4 in control file. I = would appreciate very much if you could provide me with a step by step = instruction of how to accomplish this task.

    Thanks a lot.
    zenith Received on Mon Apr 19 1999 - 08:20:54 CDT