Home » RDBMS Server » Server Administration » Redolog (Oracle10g)
Redolog [message #387171] Wed, 18 February 2009 02:29 Go to next message
grpatwari
Messages: 257
Registered: June 2008
Location: Hyderabad
Senior Member
Hi,

In my database, I have two redo log groups with two members.Database is noarchive log mode.It is giving following error.

Thread 1 cannot allocate new log, sequence 1909
Checkpoint not complete
Current log# 2 seq# 1908 mem# 0: +BAMDATA1/bam_db1/onlinelog/group_2.260.621943829
Current log# 2 seq# 1908 mem# 1: +BAMDATA1/bam_db1/onlinelog/group_2.261.621943831
Thread 1 advanced to log sequence 1909
Current log# 1 seq# 1909 mem# 0: +BAMDATA1/bam_db1/onlinelog/group_1.258.621943829
Current log# 1 seq# 1909 mem# 1: +BAMDATA1/bam_db1/onlinelog/group_1.259.621943829
Tue Feb 17 02:17:09 2009
Clearing standby activation ID 1273633486 (0x4bea1ace)
The primary database controlfile was created using the
'MAXLOGFILES 192' clause.
There is space for up to 188 standby redo logfiles


My question is:

1) How many groups can be created in the database(with how many members)?
2) When the redologs are full if the database is running in noarchivelog?
Re: Redolog [message #387172 is a reply to message #387171] Wed, 18 February 2009 02:36 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1) Defined at database creation
2) Question not clear. They are "full" when checkpoint is not complete before log needs to be reused.

Regards
Michel
Re: Redolog [message #387215 is a reply to message #387171] Wed, 18 February 2009 05:17 Go to previous messageGo to next message
grpatwari
Messages: 257
Registered: June 2008
Location: Hyderabad
Senior Member
Hi,

I am sending log file for your reference.

Re: Redolog [message #387343 is a reply to message #387171] Wed, 18 February 2009 22:29 Go to previous messageGo to next message
grpatwari
Messages: 257
Registered: June 2008
Location: Hyderabad
Senior Member
Hi,

If the database is archive log mode when the archive logs are full.

When to add redo log groups/members?
Re: Redolog [message #387352 is a reply to message #387343] Wed, 18 February 2009 23:27 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
If the database is archive log mode when the archive logs are full.

Still not clear. Never but maybe the file system containing them can be full.

Regards
Michel
Re: Redolog [message #387368 is a reply to message #387171] Thu, 19 February 2009 00:45 Go to previous messageGo to next message
grpatwari
Messages: 257
Registered: June 2008
Location: Hyderabad
Senior Member
I am facing a problem.we have configured our database in archieve log mode.And data comes in bulk. so size of archieved redo log increased in a huge ammount. So please suggest me how to manage big archive redo log files.
Re: Redolog [message #387372 is a reply to message #387368] Thu, 19 February 2009 00:52 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
how to manage big archive redo log files.

What do you mean?

Regards
Michel
Re: Redolog [message #387374 is a reply to message #387171] Thu, 19 February 2009 00:58 Go to previous messageGo to next message
grpatwari
Messages: 257
Registered: June 2008
Location: Hyderabad
Senior Member
When the redo log files are full?
Re: Redolog [message #387380 is a reply to message #387374] Thu, 19 February 2009 01:07 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Already answered.
I recommend you to read Database Concepts.

Regards
Michel
Re: Redolog [message #387403 is a reply to message #387380] Thu, 19 February 2009 02:10 Go to previous messageGo to next message
ajaysharma2907
Messages: 14
Registered: June 2008
Location: Delhi
Junior Member

can u give a detailed explaination of your problem.
why do u bother for the size of archived logs with the database issue..
Re: Redolog [message #387408 is a reply to message #387171] Thu, 19 February 2009 02:29 Go to previous messageGo to next message
grpatwari
Messages: 257
Registered: June 2008
Location: Hyderabad
Senior Member
Hi Ajay,

In our Prod db, my client got the problem saying

Oracle wanted to perform an archive log switch, but was unable to because the next online redo log has not yet been archived. The database will continue to function (i.e. no data will be lost), but all transactions will be blocked (i.e. the database may appear to hang) until the current archive log is written out and a redo log can be allocated.

If we see the above explanation, I thought redolog files are full(space).

When the redologs full and when we add the redolog group/member?
How many redologs consist in one database?
Re: Redolog [message #387411 is a reply to message #387408] Thu, 19 February 2009 02:33 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You should REALLY read the book, at least the first section of the first chapter, to understand how Oracle works.

Regards
Michel
Re: Redolog [message #387471 is a reply to message #387171] Thu, 19 February 2009 06:15 Go to previous message
grpatwari
Messages: 257
Registered: June 2008
Location: Hyderabad
Senior Member
thanq very much.
Previous Topic: REMOVE / REINSTALL ORACLE 9IAS
Next Topic: Oracle 9i statspack not scheduling (merged 3)
Goto Forum:
  


Current Time: Fri Dec 09 00:01:08 CST 2016

Total time taken to generate the page: 0.13288 seconds