status from v$log
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: status from v$log

Hybrid View

  1. #1
    Join Date
    Jan 2000
    Location
    san jose
    Posts
    149
    is that possible that for all status from logfile in V$log,
    its status is active, so current log can't being switch?

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    I think I faced once when all logs were active but that was because I had 2 group redo log only and there were quite a lot of activities, it basically means that the checkpoint for those log is not done yet. I cant remember but it did not stop me from switching logs and it went to inactive after a while or after an ALTER SYSTEM SWITCH LOGFILE I cant remember...

  3. #3
    Join Date
    Apr 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    1,203
    When there is a status of ACTIVE it means that the checkpoint for that log hasn't completed yet and it is still required for recovery. I'd check the sizing of the redo logs and increase them if need be.

  4. #4
    Join Date
    Mar 2001
    Posts
    131
    No Generally It is not recommended to do so. If the checkpoint is not occur. otherwise you will not get the transaction data for that perticular logfile in archived log.

  5. #5
    Join Date
    Apr 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    1,203
    Your talking about the ALTER DATABASE SWITCH LOGFILE command right. And I agree, switching the logfile will not help, I still think the issue is sizing of redo logs and the volume of redo activity.

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