Checkpoint not complete

[Former Member]

Hello,

ECC 6.0

HP-UX 11.23

ORACLE 10.2.0.2

IN DB16 I HAVE FOUND THE WARNING,

Time: 2008-08-06 23.01.37, line: Checkpoint not complete

As i know I have to increase redo log file size.

Kindly giude me how to increase the redo log file size.

And if there is anothere solution.

Kindly suggest.

Thanks,

Chandresh Pranami

[former_member227600 · Accepted solution]

hi,

You can increass the size of redo log files using this:-

It is recommended that you perform a full backup before changing

the size of the redo log files.

In order to recreate the online redo logs with bigger sizes

perform the following steps:

- Drop logfile group 11 (usually the number of the first log

file group):

sqlplus "/ as sysdba"

ALTER DATABASE DROP LOGFILE GROUP 11;

- Remove related operating system files, e.g.:

UNIX: rm /oracle//origlogA/log_g11_m1.dbf

rm /oracle//mirrlogA/log_g11_m1.dbf

WINDOWS: del :\oracle
origlogA/log_g11_m1.dbf

del :\oracle
mirrlogA/log_g11_m2.dbf

Do not remove the files before the related logfile group is

dropped!

- Recreate the logfile group 11 with a bigger size :

ALTER DATABASE ADD LOGFILE GROUP 11

('/oracle//origlogA/log_g11_m1.dbf',

'/oracle//mirrlogA/log_g11_m2.dbf')

SIZE M;

- Do the same for all other existing logfile groups

Please refer to note 79341 for more detail

Karan

[Former Member]

DEAR moderators ..... Please lock this thread ...........How many time possible to repeat the same answers ??

[Former Member]

Hi,

If you have database level access then you can go through that....

Its depend your database, if your database is on oracle then you can add a new Redo Logfile group to the database give the following command

SQL>alter database add logfile group <no>

u2018/u01/oracle/ica/log3.orau2019 size 10M;

[Former Member]

sqlplus "/ as sysdba"

Alter database Switch log -- n times

ALTER DATABASE DROP LOGFILE GROUP 11;

Remove related operating system files, e.g.:

UNIX: rm /oracle/<sid>/origlogA/log_g11_m1.dbf

rm /oracle/<sid>/mirrlogA/log_g11_m2.db

alter database add logfile group 11(u2018/oracle/TPS/origlogA/log_g11m1.dbfu2019 , '/oracle/TPS/mirrlogA/log_g11m2.dbfu2019) Size 200MB;

Hope it works.

Amit

[Former Member]

Hello. Note 79341 - Checkpoint not complete.

[Former Member]

Hi Chandresh,

If this issue is happening regularly then only you think obout changing the size unless you can ignore it.This warning might have come due to some temporary issue.

If you want to change the size of the log file then you can do so by creating a new control file with the new size of redo files.

Regards

Ashok

[Former Member]

Hi,

There are two possible solutions to resolve this issue.

Increase the size of redo log file.

or Increase the number of redo log files.

There SQL commands available to do this,I dont remembe those commands this time,Please search that.

Check in Brtools also I think there also we have options for this.

Shivam