ergent, please help....
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: ergent, please help....

  1. #1
    Join Date
    Apr 2001
    Posts
    151
    Hi all.

    I got an ora-error any quick action I can take.

    ARCH:
    ORA-00255: error archiving log 5 of thread 1, sequence # 12735
    ORA-00312: online log 5 thread 1: 'F:\ORCLBERP\REDO_LOGS\LOG51BERP.ORA'
    ORA-00312: online log 5 thread 1: 'J:\ORCLBERP\REDO_LOGS\LOG52BERP.ORA'
    ORA-00334: archived log: 'G:\ORCLBERP\ARCHIVE\ARCBERP0000012735.LOG'
    ORA-19502: write error on file "G:\ORCLBERP\ARCHIVE\ARCBERP0000012735.LOG", blockno 32257 (blocksize=512)
    ORA-27072: skgfdisp: I/O error
    OSD-04008: WriteFile() failure, unable to write to file
    O/S-Error: (OS 112) There is not enough space on the disk.
    ORA-00272: error writing archive log G:\ORCLBERP\ARCHIVE\ARCBERP0000012735.LOG
    ORA-19502: write error on file "G:\ORCLBERP\ARCHIVE\ARCBERP0000012735.LOG", blockno 32257 (blocksize=512)
    ORA-27072: skgfdisp: I/O error
    OSD-04008: WriteFile() failure, unable to write to file
    O/S-Error: (OS 112) There is not enough space on the disk.
    Thu May 03 13:38:37 2001
    Completed checkpoint up to RBA [0x31c0.2.10], SCN: 0x0000.01c83b43
    Thu May 03 13:40:19 2001
    Beginning log switch checkpoint up to RBA [0x31c1.2.10], SCN: 0x0000.01c84418
    Thread 1 advanced to log sequence 12737
    Current log# 7 seq# 12737 mem# 0: F:\ORCLBERP\REDO_LOGS\LOG71BERP.ORA
    Current log# 7 seq# 12737 mem# 1: J:\ORCLBERP\REDO_LOGS\LOG72BERP.ORA
    Thu May 03 13:40:46 2001
    Completed checkpoint up to RBA [0x31c1.2.10], SCN: 0x0000.01c84418
    Thu May 03 13:42:29 2001
    Beginning log switch checkpoint up to RBA [0x31c2.2.10], SCN: 0x0000.01c84c80
    Thread 1 advanced to log sequence 12738
    Current log# 3 seq# 12738 mem# 0: F:\ORCLBERP\REDO_LOGS\LOG31BERP.ORA
    Current log# 3 seq# 12738 mem# 1: J:\ORCLBERP\REDO_LOGS\LOG32BERP.ORA
    Thu May 03 13:42:49 2001
    Completed checkpoint up to RBA [0x31c2.2.10], SCN: 0x0000.01c84c80
    Elin@trend

  2. #2
    Join Date
    Oct 2000
    Location
    Dallas:TX:USA
    Posts
    407
    You are running out of free space in --

    G:\ORCLBERP\ARCHIVE

    create some space and Archival process will continue.

    - Rajeev
    Rajeev Suri

  3. #3
    Join Date
    Apr 2001
    Posts
    151
    do you mean I need to delete some archive log from G?
    Elin@trend

  4. #4
    Join Date
    Oct 2000
    Location
    Dallas:TX:USA
    Posts
    407
    if your archive logs are not copied onto tape then NO !!!
    But you must delete some other files to make space for Archiving to go on. Another way will be to stop Archiving process temporarily while you figure out what to do with the space problem. This is always the number one thing you should plan when putting a database in Archive log mode.

    - Rajeev


    Rajeev Suri

  5. #5
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Don't you have a backup strategy defined. If you If you take a level 0 backup today, then you wouldn't require any archivelog files prior to today (i.e) y-day for your recovery. So you could delete those old ones. So I cannot be specific in answering on what to do, without knowing your backup strategy.


    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  6. #6
    Join Date
    Apr 2001
    Posts
    151
    Thank you all,

    I am new to the company. I noticed that I have 142 archived log files y-day. and each one is 20K.
    I will look into company's backup plan to see what I can do.

    Thank you to all again
    Elin@trend

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