| Redolog [message #387171] |
Wed, 18 February 2009 02:29  |
grpatwari
Messages: 288
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 #387343 is a reply to message #387171] |
Wed, 18 February 2009 22:29  |
grpatwari
Messages: 288
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 #387368 is a reply to message #387171] |
Thu, 19 February 2009 00:45 |
grpatwari
Messages: 288
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 #387408 is a reply to message #387171] |
Thu, 19 February 2009 02:29 |
grpatwari
Messages: 288
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?
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
