Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003
    Location
    usa
    Posts
    8

    Unanswered: Deleting OMF Managed LOGFILE Members

    Hi,
    Is there a way to add LOGFILE members to a OMF managed LOGFILE group ?

    I can add an OMF managed LOGFILE group. But any LOGFILE members I add thereafter are not OMF managed.

    Here is what I did :

    1. Set destination for ONLINE log group
    DB_CREATE_ONLINE_LOG_DEST = 'c:\oradata\db92'

    2. Add a LOGFILE group
    ALTER DATABASE add logfile group 1
    This creates an OMF : O1_MF_1_ZHWG01.DBF

    3. Add a member to LOGFILE group
    ALTER DATABASE
    ADD LOGFILE MEMBER 'redo011.log' to GROUP 1

    4. Verify the files
    select * from v$logfile where group# = 1

    5. Now drop the entire logfile group
    alter database drop logfile group 1

    Problem : The OMF file created in Step 2 is removed, but the file created in Step 3 remains.

    Question : Is there a way to add OMF managed files to MEMBERS of LOGFILE groups ?

    thanks
    abhay

  2. #2
    Join Date
    Apr 2003
    Location
    Minneapolis, MN
    Posts
    273
    Hi Abhay,
    Try setting this parameters.

    DB_CREATE_FILE_DEST = 'c:\oradata\db92'
    DB_CREATE_ONLINE_LOG_DEST_1 = 'c:\oradata\db92'
    DB_CREATE_ONLINE_LOG_DEST_2 = 'c:\oradata\db92' ( for the second group).

    As You say that ...

    "2. Add a LOGFILE group
    ALTER DATABASE add logfile group 1
    This creates an OMF : O1_MF_1_ZHWG01.DBF " in your post..

    How come it created .DBF logfile. It shoud be .log ( ora_%g_%u.log format)

    But anyway, I guess the abouv mentioned parameters will help you out.

    Thanks,

    Hings...

    ====

  3. #3
    Join Date
    Oct 2003
    Location
    usa
    Posts
    8
    Thanks Hings, it worked.

    You are correct in that the suffix is *.LOG and not *.DBF

Posting Permissions

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