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

Thread: 1 set of redo logs empty

Threaded View

  1. #4
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    Quote Originally Posted by sio View Post
    Hi

    One set of the redo-log files are physically there but empty. Both sets of redo-logs have the same permissions and one set are getting written to and one are not. Not sure why. Can anyone help me get both sets of redo-logs used.
    how do you know one set of redo logs are empty? I am sure you haven't open them in editor to see what is there in side.

    There might be less or no activity going on in your DB.

    Follow the below steps.

    1. select group#,members,status from v$log; - post the output of this command
    2. alter system switch logfile;
    3. select group#,members,status from v$log; - post the output of this command

    Thanks,
    Last edited by vnktummala; 02-15-2011 at 04:26 AM.
    Vijay Tummala

    Try hard to get what you like OR you will be forced to like what you get.

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