Database Recovery
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Database Recovery

  1. #1
    Join Date
    Dec 2000
    Posts
    19
    Hi, We are experiencing a database crash in the production database running in winnt Oracle version 8.1.6. The database is in archivelog mode. I have full database RMAN backup as on 1-12-2000 and subsequent incermental backup and archive log files.
    I tried to do a recovery, but I got ORA-00283 and ORA-01579.

    Pl advise how to restore the database.


  2. #2
    Join Date
    May 2000
    Location
    Portsmouth, NH, USA
    Posts
    378

    Cool trace file?


    What does your trace file say? Look that up and post results.
    WEhen looking up your error I get:
    shamrock% oerr ORA 01579
    01579, 00000, "write error occurred during recovery"
    // *Cause: A write error occurred during recovery
    // *Action: Consult trace files for the nature of the write error, and
    // correct error.


    - Magnus

    ps: are you using RMAN to recover or command line?

  3. #3
    Join Date
    Mar 2000
    Location
    CA
    Posts
    317
    May be your datafile is corrupt, or your hard disk is having some bad sectors.

    Try to restore it on some other machine
    Thanks
    Kishore Kumar

  4. #4
    Join Date
    Dec 2000
    Posts
    19

    Database recovery

    Hi, thanks for the response. The trace file says OSD error.
    DBWR generates the following error.
    KCF: write/open error block=0x305f1 online=1
    file=2 I:\ORACLE\GABS\RBS01.DBF
    error=27069 txt: 'OSD-04026: Invalid parameter passed. (OS 198129)'
    I don't know what is OSD error. Consultated Oracle Support, and the HW vendor.
    The M/c is running Microsoft Cluster Service. Disks are Okay.
    Pl reply at the earliest.

  5. #5
    Join Date
    Jul 2000
    Posts
    53
    Are you using any third party backup / archive software by any chance?
    Steve

  6. #6
    Join Date
    Dec 2000
    Posts
    19
    No we are not using any 3rd party backup s/w. we are using RMAN in command mode for backup and recovery.

    Anybody can u tell me what is meaning of OSD. Have any one of u experienced the same.


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