Skip to Content
avatar image
Former Member

Change in Oracle Parameters and Log file size

Hello All,

We have scheduled DB Check job and the log file showed few errors and warnings in the oracle parameter that needs to be corrected. We have also gone through the SAP Note #830576 – Oracle Parameter Configuration to change these parameters accordingly. However we need few clarifications on the same.

1.Can we change these parameters directly in init<SID>.ora file or only in SP file. If yes can we edit the same and change it or do we need to change it using BR tools.

2.We have tried to change few parameters using DB26 tcode. But it prompts for maintaining the connection variables in DBCO tcode. We try to make change only in default database but it prompts for connection variables.

Also we get check point error. As per note 309526 can we create the new log file with 100MB size and drop the existing one. Or are there any other considerations that we need to follow for the size of log file and creating new log file. Kindly advise on this. Our Environment is as follows.

OS: Windows 2003 Server

DB: Oracle 10g

regards,

Madhu

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Mar 12, 2008 at 10:30 AM

    Make sure you have enough space in the file system where your log files are located other wise you will end up in a bad situation

    follow this :

    sqlplus / as sysdba

    sql> select * from v$logfile

    sql> select * from v$log

    The above command will give you the log file name, size...etc

    sql> alter database add logfile group 3 ('c:\.........' size 100M, 'd:\........' size 100M

    Add new groups 3 to 6 or 7 or 10

    sql> drop logfile group 1

    repeat this command to drop the old groups

    Add comment
    10|10000 characters needed characters exceeded