Logfile Problem

[sudip]

Hi! All
Is it possible to rename a logfile group.
Thanx

[marist89]

Rename the individual members or rename the entire group?

[padmam]

Hi, 21st May 2001 18:25 hrs chennai

Padmam

[Edited by padmam on 05-21-2001 at 09:00 AM]

[padmam]

Hi, 21st May 2001 18:25 hrs chennai

Here is link which explains you in very precise how to rename a log file .

http://oradb1.jinr.ru/oracle/srvr/se...m#renameonline

Note:A log group consist of log file members.

A group is a logical entity.

If you read the link you will understand why you canot move a group.A group is not a Physical file to move at o/s level and then rename (rename i.e update the controlfile of the new path of the log file) the same.

Cheers

Padmam

[sudip]

Actually What I have done is as follows

I had 8 logfiles with 1 member each of 512k size each. Now it was causing some contentions. So I added 8 more groups with one member each of size 5m. After that I dropped the old 512k groups. Now I have groups named as group08 to group16. And now I want to rename them from group1 to group8.

[oddster]

Sudip,

Is this a production DB?

If so, I recommend that you add an extra set of members to your redo groups to increase resilience?

[sudip]

No, Absolutely Not.
It is a test instance. Thanx anyway.

[padmam]

Hi , 21st May 2001 18:59 hrs chennai

In the link it has also given how to rename the log files..Instead of renaming to different disk rename it in the same path or disk as per your requirement.

Rename the existing files as new and then drop the old ones physically.

Eg:

ALTER DATABASE
RENAME FILE 'log1a'
TO 'log1c' ;

Did you try like this ?

Cheers

Padmam

[sudip]

Well, May be I am confusing myself,
Well I deleted group1 to group8 now is it possible to recreate a group with name group1 OR rename a existing group not log member to group1?

thanx for yr patience

[padmam]

Hi, 21st May 2001 20:00 hrs chennai

Why dont you create a new log groups as the name you require and drop the old ones.

I have not come across renaming a log group.I think that is not possible or available in oracle.If some ones tells well and good to know.

Cheers

Padmam