Results 1 to 14 of 14
  1. #1
    Join Date
    Sep 2004
    Location
    Bahrain
    Posts
    21

    Unanswered: Can I use old copy of datafile

    Hello

    I have a backup of datafile on a tape for the month of July
    now our datafile is overwritten by another data.

    Can I just remove current datafile and copy old datafile to the same location and use it via SELECT statement only.

    And is there any precoutions for that?

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >Can I just remove current datafile and copy old datafile to the same location and use it via SELECT statement only.
    NO! Not a chance.
    Where are your backups, because you are going to need them?
    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
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    What OS & OS version?
    Which version of Oracle DB (to 4 places)?
    Is/was DB running in archived redo log file mode?
    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.

  4. #4
    Join Date
    Sep 2004
    Location
    Bahrain
    Posts
    21
    OS : UNIX 4.0E
    Oracle8 (8.0.5.0) with partitioning option
    DB is running in archive mode

  5. #5
    Join Date
    Nov 2002
    Posts
    833
    follow the step to a pit point-in-time recovery
    if applied hot backups you can apply all your archived redologs

  6. #6
    Join Date
    Jul 2003
    Posts
    2,296
    I think we need clarification:

    does this guy just want the OLD data that exists in the old datafile?
    (ie: I want the datafile data AS-IS from July with no updates)
    OR
    does he want to implement the OLD datafile and recover all transactions
    to the current day/time?
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  7. #7
    Join Date
    Sep 2004
    Location
    Bahrain
    Posts
    21
    Hello

    Exactly :I want the datafile data AS-IS from July with no updates

  8. #8
    Join Date
    Jul 2003
    Posts
    2,296
    Quote Originally Posted by eashiri
    Hello

    Exactly :I want the datafile data AS-IS from July with no updates
    Yup, you can do that.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  9. #9
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    OP>Can I just remove current datafile and copy old datafile to the same location and use it via SELECT statement only.
    DUCK> Yup, you can do that.
    I bet he can't. The "old" file will have the wrong SCN in it & Oracle will refuse to open.
    If the OP is knows what he is doing, the data can be recovered but it will involve more than a simple file copy or using any point & click GUI.
    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 2004
    Location
    Bahrain
    Posts
    21
    I made a try and it did not work!

    an error says object does not exist!!!

  11. #11
    Join Date
    Jul 2003
    Posts
    2,296
    please post what you did (cut & paste)
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  12. #12
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >I made a try and it did not work!
    Did you shutdown the DB prior to doing the copy?
    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.

  13. #13
    Join Date
    Sep 2004
    Location
    Bahrain
    Posts
    21
    - I renamed the correny datafile from "soe_01.dbf" to "soe_01.dbf_aug" , then
    - I copied the old one to same location
    - I stopped and restart the DB
    - I opend SqlPlus and I issue a select statement
    - An ora-?????: Object no more exits (I could not remember the number )
    - I removed old file and renamed back the current one, and i used select statement, it works.

  14. #14
    Join Date
    Jul 2003
    Posts
    2,296
    that is not how you do it.
    I suggest you read the RMAN documentation on Media Recovery.

    Code:
    http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96565/toc.htm
    - The_Duck
    you can lead someone to something but they will never learn anything ...

Posting Permissions

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