DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: droping a logfile in mount status possible?

Hybrid View

  1. #1
    Join Date
    Jan 2002
    Posts
    94

    Unhappy

    I know, it is my own fault! I got 3 logfile groups with only one member! One of them is corrupted. If I try to start the database crash recovery is starting. After a while the error message ora-00376 is comming up while the database is try to read one redolog file.

    So I will start the database in mount status, drop the logfile and start the database.

    Is that possible?

    chris

  2. #2
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840
    yes,use alter database drop logfile 'file_name';

    cheese
    anandkl
    anandkl

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