All online redo logs in ACTIVE state
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: All online redo logs in ACTIVE state

  1. #1
    Join Date
    Jul 2000
    Posts
    521
    We had this situation (all online redo logs in ACTIVE status) a few days ago. Regular scheduled hot backup was in progress and the 'begin backup' statements for some tablespaces hung. The database also appeared to be in hung status. We did a shutdown/restart. But trying to figure out what might have happened....Any inputs ??!!
    svk

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Oracle was waiting for a checkpoint to complete. You were probably getting "checkpoint not complete" errors in your alert.log. If you frequently get this condition, you need to add more redo. Either bigger redo logs, more redo logs, or both.
    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 2001
    Posts
    36
    The Database may be in Hot backup mode. check the tablespace status. Otherwise during hotbackup too much archivelog log been generated and that's why your archive log directroy may full. So now Oracle unable to archive online redolog. so your database is hang.

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