Logfile Problem
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 12

Thread: Logfile Problem

  1. #1
    Join Date
    Feb 2001
    Location
    Kolkata- India
    Posts
    356
    Hi! All
    Is it possible to rename a logfile group.
    Thanx
    There Nothing You cannot Do, The problem is HOW.

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Rename the individual members or rename the entire group?
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Mar 2000
    Location
    Chennai.Tamilnadu.India.
    Posts
    658

    solution

    Hi, 21st May 2001 18:25 hrs chennai

    Padmam

    [Edited by padmam on 05-21-2001 at 09:00 AM]
    Attitude:Attack every problem with enthusiasam ...as if your survival depends upon it

  4. #4
    Join Date
    Mar 2000
    Location
    Chennai.Tamilnadu.India.
    Posts
    658

    solution

    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
    Attitude:Attack every problem with enthusiasam ...as if your survival depends upon it

  5. #5
    Join Date
    Feb 2001
    Location
    Kolkata- India
    Posts
    356
    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.


    There Nothing You cannot Do, The problem is HOW.

  6. #6
    Join Date
    Feb 2001
    Location
    Adelaide, Australia
    Posts
    159
    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?

  7. #7
    Join Date
    Feb 2001
    Location
    Kolkata- India
    Posts
    356
    No, Absolutely Not.
    It is a test instance. Thanx anyway.
    There Nothing You cannot Do, The problem is HOW.

  8. #8
    Join Date
    Mar 2000
    Location
    Chennai.Tamilnadu.India.
    Posts
    658

    solution

    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


    Attitude:Attack every problem with enthusiasam ...as if your survival depends upon it

  9. #9
    Join Date
    Feb 2001
    Location
    Kolkata- India
    Posts
    356
    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
    There Nothing You cannot Do, The problem is HOW.

  10. #10
    Join Date
    Mar 2000
    Location
    Chennai.Tamilnadu.India.
    Posts
    658

    Yes

    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

    Attitude:Attack every problem with enthusiasam ...as if your survival depends upon it

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width