Results 1 to 10 of 10

Thread: DB Recovery

  1. #1
    Join Date
    Sep 2003
    Posts
    218

    Unanswered: DB Recovery

    Our env: Oracle 8.1.7.3 on Solaris 5.8

    Our database has been dropped and there is a cold backup of the same. Howver, it was not taken gracefully i.e by shutting down the database and coping the datafiles, log files, control files etc to a backup location.

    So when we try to restore from this backup, we are getting the following error.

    ORA-01194: file 1 needs more recovery to be consistent
    ORA-01110: data file 1: '/oradata/system01.dbf'

    We have tried doing "recover database using backup controlfile until cancel" etc but it has not fixed the issue.

    Any helps is greatly appreciated.

  2. #2
    Join Date
    Sep 2003
    Posts
    218
    Btw, our database is running in NOARCHIVELOG MODE.

  3. #3
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Thumbs down


    NO ARCHIVELOGS??? NO COLD BACKUPS???

    You are very screwed.

    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  4. #4
    Join Date
    Sep 2003
    Location
    NE Florida w/ view of co-workers
    Posts
    32
    Quote Originally Posted by dr_suresh20
    ... a cold backup ...
    Is there another cold backup?

  5. #5
    Join Date
    Oct 2002
    Location
    greenwich.ct.us
    Posts
    279
    It must be development, so just reload it from production.

  6. #6
    Join Date
    Sep 2003
    Posts
    218
    We managed to find a copy of cold backup and brought up the database. Now the issue is ORA-27101: shared memory realm does not exist; tns write packet error..

    Thanks in advance.

  7. #7
    Join Date
    Sep 2005
    Posts
    12
    ----------------------------------------------------
    27101, 00000, "shared memory realm does not exist"
    // *Cause: Unable to locate shared memory realm
    // *Action: Verify that the realm is accessible
    ----------------------------------------------------
    are you sure that the realm is accessible ???

  8. #8
    Join Date
    Sep 2003
    Posts
    218
    Turns out that the env was not proper hence the error. Now we are able to access the db .. however we do get the following error occasionally.

    ORA-00600: internal error code, arguments: [4193], [4851], [], [], [], [], []

    Any clues?

  9. #9
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >Any clues?
    GOOGLE has plenty, but only if you use it/them.
    ========================================
    This error may indicate a rollback segment corruption.
    This may require a recovery from a database backup depending on the situation.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  10. #10
    Join Date
    Sep 2003
    Posts
    218
    Alright .. db is back online and working fine. thanks for your response.

    Now the replication is not working.. we have a multi-master replication setup on this very database and it does not seem to work as expected. We are getting ORA-01403: no data found error.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •