OraFAQ Forum: Server Administration » ORA-01185 when trying to add log file group

Home » RDBMS Server » Server Administration » ORA-01185 when trying to add log file group

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-01185 when trying to add log file group [message #63537]

Wed, 13 October 2004 22:33

Yan Seiler
Messages: 13
Registered: December 2001

Junior Member

Hi,

I have an Oracle 9.2.0.5 instance with 5 log file groups and I would like to add a new log file group and get the following error:

SQL> ALTER DATABASE
� 2�� ADD LOGFILE GROUP 6 ('F:ORADATALISLOGREDO06A.LOG',
� 3�� 'G:ORADATALISLOGREDO06B.LOG') SIZE 50M;
ALTER DATABASE
*
ERROR at line 1:
ORA-01185: logfile group number 6 is invalid

Any idea ?

Thanks in advance
best regards
Yan

Report message to a moderator

Re: ORA-01185 when trying to add log file group [message #63545 is a reply to message #63537]

Thu, 14 October 2004 22:19

puneet
Messages: 76
Registered: August 2002

Member

ALTER DATABASE
2 ADD LOGFILE GROUP 6 ('F:ORADATALISLOGREDO06A.RDO',
3 'G:ORADATALISLOGREDO06B.RDO') SIZE 50M;

Extension is RDO.. if i'm not wrong

Also check parameter
1) MAXLOGFILES
2) MAXLOGMEMBERS

do let me know if ur problem is solved

Cheers
Puneet

Report message to a moderator

Re: ORA-01185 when trying to add log file group [message #63578 is a reply to message #63545]

Mon, 18 October 2004 05:52

Yan Seiler
Messages: 13
Registered: December 2001

Junior Member

Dear Puneet,

Thanks for your answer.
I cannot find those parameters in Oracle 9i, do you know if they would have been replaced by others ?

Thanks in advance

Yan

Report message to a moderator

Re: ORA-01185 when trying to add log file group [message #63585 is a reply to message #63578]

Mon, 18 October 2004 19:44

Puneet sachar
Messages: 62
Registered: October 2003

Member

Hi...Yan

The 2 parameter
1) MAXLOGFILES
2) MAXLOGMEMBERS are required in creation od Redolog file while creating the database.

Check INIT<<SID>>.ora file.

Is your problem solved. The Extension must be .RDO not .Log.

Report message to a moderator

Re: ORA-01185 when trying to add log file group [message #63587 is a reply to message #63545]

Mon, 18 October 2004 22:41

Yan Seiler
Messages: 13
Registered: December 2001

Junior Member

Dear Puneet,

Thanks for your answer.
I cannot find those parameters in Oracle 9i, do you know if they would have been replaced by others ?

Thanks in advance

Yan

Report message to a moderator

Re: ORA-01185 when trying to add log file group [message #63588 is a reply to message #63587]

Tue, 19 October 2004 00:21

marco
Messages: 46
Registered: March 2001

Member

Hi,
check "REDO LOG" in v$controlfile_record_section, this value is the MAXLOGFILES specified at the DB creation time.
To change this value you have to recreate control file.

Marco

Report message to a moderator

Re: ORA-01185 when trying to add log file group [message #63595 is a reply to message #63585]

Tue, 19 October 2004 15:04

jack
Messages: 123
Registered: September 2000

Senior Member

The extention of the log file should be 'ora', or 'rdo'?

Report message to a moderator

Re: ORA-01185 when trying to add log file group [message #63618 is a reply to message #63595]

Thu, 21 October 2004 02:46

Mark
Messages: 284
Registered: July 1998

Senior Member

Hi,
check "REDO LOG" in v$controlfile_record_section, this value is the MAXLOGFILES specified at the DB creation time.
To change this value you have to recreate control file.

File extension is not necessary and it could be whatever you want.

Marco

Report message to a moderator