question regarding archive logs
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: question regarding archive logs

  1. #1
    Join Date
    Dec 2000
    Posts
    18
    this is my problem this I got this message:

    ARCH: Archival stopped, error occurred. Will continue retrying
    ARCH:
    ORA-00255: error archiving log 3 of thread 1, sequence # 423
    ORA-00312: online log 3 thread 1: 'E:\ORADATA\LOGDAMS3A.RDO'
    ORA-00334: archived log: 'E:\ORADATA\ARCHIVE\MST0001S0000000423.ARC'
    ORA-00270: error creating archive log E:\ORADATA\ARCHIVE\MST0001S0000000423.ARC
    ORA-19504: failed to create file "E:\ORADATA\ARCHIVE\MST0001S0000000423.ARC"
    ORA-27040: skgfrcre: create error, unable to create file
    OSD-04002: unable to open file
    O/S-Error: (OS 5) Access is denied.


    then the db went into a hung state what must I do to resolve this


  2. #2
    Join Date
    Oct 2000
    Location
    Dallas:TX:USA
    Posts
    407
    Is the E: drive a mapped drive ? Is it available ?
    Can you connect to the drive and see the contents under 'E:\ORADATA' directory ?

    Is there enough space available on this drive for Archives ?

    - Rajeev

  3. #3
    Join Date
    Jun 2000
    Location
    Chennai/India
    Posts
    90
    Hi, the reason being is that Oracle cannot recognize the online redo log files.
    Rgds
    Ganesh .R
    A Winner never Quits, A Quitter never Wins
    Ganesh .R

  4. #4
    Join Date
    Apr 2000
    Location
    Edison, NJ
    Posts
    759
    Bounce the db and switch a logfile or two.

  5. #5
    Join Date
    Mar 2000
    Location
    CA
    Posts
    317
    Is E network drive. If so some probably some one has remove the access to it.
    Thanks
    Kishore Kumar

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