Recover Data Base Lost offline archive Help Me
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Recover Data Base Lost offline archive Help Me

  1. #1
    Join Date
    Jan 2001
    Posts
    1
    I have a database archive mode, but is crash, i connot recover because dont have the archive files.
    I put this parameters in init.ora

    _allow_resetlogs_corruption=true
    _corrupted_rollback_segments=(r01,r02,r03,r04)

    and i intente startup the database with

    alter database mount
    recover database until cancel using backup controlfile
    alter database open resetlogs

    but i get this message error

    alter database open x
    ORA-00704: bootstrap process failure x
    ORA-00604: error occurred at recursive SQL level 1 x
    ORA-00955: name is already used by an existing object
    ORA-01555 shaphot too old (rollback segment too small)

    what do i to do ...

    I need recover the database consistent o inconsistent


  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    I don't understand why you think you need:
    _allow_resetlogs_corruption=true
    _corrupted_rollback_segments=(r01,r02,r03,r04)

    After you issue:
    recover database until cancel using backup controlfile

    you have to stop the recovery at some point with:
    alter database recover cancel

    and then, you can open your database with:
    alter database open resetlogs


    There is a note on metalink outlining this procedure. The note number is 69468.1

    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."

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