Results 1 to 6 of 6
  1. #1
    Join Date
    Dec 2013
    Location
    Florida
    Posts
    3

    Unanswered: Is Data Missing?

    How can I answer the question whether or not data is missing short of restoring the database and comparing the two?

    Flashback is not enabled.

    Thanks!

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Quote Originally Posted by yngiwulf View Post
    How can I answer the question whether or not data is missing short of restoring the database and comparing the two?

    data does not automagically go missing.
    You can depend upon Oracle not to lose data; however users may cause data to go missing.

    How do you differentiate between data correctly deleted vs data incorrectly deleted?
    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.

  3. #3
    Join Date
    Dec 2013
    Location
    Florida
    Posts
    3
    Sorry, not enough information.

    We had a server malfunction and I was asked if we could validate that no data was lost. So, my main thought was I would have to restore the database to another location and compare the data in the two for a really solid answer. Any other alternatives?

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Quote Originally Posted by yngiwulf View Post
    Sorry, not enough information.

    We had a server malfunction and I was asked if we could validate that no data was lost. So, my main thought was I would have to restore the database to another location and compare the data in the two for a really solid answer. Any other alternatives?
    If the Oracle database opens without error, then everyone should rest assured that NO data was lost.

    post complete results of the following SQL


    SELECT * FROM V$VERSION;
    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.

  5. #5
    Join Date
    Dec 2013
    Location
    Florida
    Posts
    3
    Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
    PL/SQL Release 11.2.0.3.0 - Production
    CORE 11.2.0.3.0 Production
    TNS for Linux: Version 11.2.0.3.0 - Production
    NLSRTL Version 11.2.0.3.0 - Production

  6. #6
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    If the Oracle database opens without error, then everyone should rest assured that NO data was lost.
    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.

Posting Permissions

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