cancel
Showing results for 
Search instead for 
Did you mean: 

checkpoint not completed

Former Member
0 Kudos

Dear all,

I am getting checkpoint not completed in db16.Can any please help me.I have trouble shoted.

the correction is : inscrease the on line redolog file. how i can increase the redo file .please give the steps.

Regards:

Ramu

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi,

You can not resize the existing redo log files.

For this, you have to create another redo log files group, make it current and than drop the current redo log files group.

Full DB backup is always recommanded before using these steps.

1. alter database

add logfile group x

('c:\log\log0101.log','d:\log\log0102.log') size <Your new size in MB>M;

2. Switch to make it current

alter database switch logfile;

3. Drop the exisiting redo log files

alter database drop logfile group y;

Follow this link for more clarity on commands.

http://www.stanford.edu/dept/itss/docs/oracle/10g/server.101/b10739/onlineredo.htm#i1006398

With Regards,

Saurabh

Edited by: Saurabh.Arora on Jun 8, 2009 8:35 AM

Former Member
0 Kudos

Both answers are not correct

are you trying to do this scripts before posting ?

, try to read the notes dear's :

Note 79341 - Checkpoint not complete

Note 309526 - Enlarging redo log files

Regards.

Former Member
0 Kudos

Dear all,

thanks for given the solution.

Regards,

Ramu

Former Member
Former Member
0 Kudos

Hi,

Assuming Oracle already have group 1 and group 2, this command will create a third group (Unix directory):

ALTER DATABASE ADD LOGFILE GROUP 3

(u2018$HOME/ORADATA/directory/log3a.rdou2019,

u2018$HOME/ORADATA/directory/log3b.rdou2019)

SIZE 1 M;

Thanks

Rishi Abrol