DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 10

Thread: Urgent - Data Retrival

  1. 06-30-2003, 09:41 AM #1
    kanna
    kanna is offline Junior Member
    Join Date
    Jun 2003
    Location
    India
    Posts
    24

    Urgent - Data Retrival

    Hi,
    How to retreive the TRUNCATED data.

    One of table in our production has been truncated. How to retreive the data? The DB version is Oracle 8i.

    Rgds,
    Luv
    Kanna
    Reply With Quote Reply With Quote
  2. 06-30-2003, 09:44 AM #2
    jovery's Avatar
    jovery
    jovery is offline Ha Ha
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    Point In Time (PIT) recovery, providing you run your database in archivelog mode.
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!
    Reply With Quote Reply With Quote
  3. 06-30-2003, 09:52 AM #3
    kanna
    kanna is offline Junior Member
    Join Date
    Jun 2003
    Location
    India
    Posts
    24
    Hi
    Thnx for the help.
    can you guide me from here.
    I have no idea how to do this.

    "Point In Time (PIT) recovery, providing you run your database in archivelog mode". I doen't have any experience in DBA.

    Thnx in advance,
    Rgds
    Luv
    Kanna
    Reply With Quote Reply With Quote
  4. 06-30-2003, 09:58 AM #4
    jovery's Avatar
    jovery
    jovery is offline Ha Ha
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    Take a look at

    http://download-west.oracle.com/docs...itr.htm#421341
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!
    Reply With Quote Reply With Quote
  5. 06-30-2003, 10:03 AM #5
    kanna
    kanna is offline Junior Member
    Join Date
    Jun 2003
    Location
    India
    Posts
    24
    Hi,
    Thnx again jovery.
    Can we use the feature LOG MINOR to retreive data?
    Just one of my mate's view.
    Rgds,
    Luv
    Kanna
    Reply With Quote Reply With Quote
  6. 06-30-2003, 10:03 AM #6
    jovery's Avatar
    jovery
    jovery is offline Ha Ha
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    Also if you have access to Metalink you might want to have a look at this for step-by-step instructions

    http://support.oracle.co.uk/metalink...&p_id=141194.1

    HTH
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!
    Reply With Quote Reply With Quote
  7. 06-30-2003, 10:04 AM #7
    kanna
    kanna is offline Junior Member
    Join Date
    Jun 2003
    Location
    India
    Posts
    24
    Hi jovery
    I don't have meta link ID.
    Rgds,
    Luv
    Kanna
    Reply With Quote Reply With Quote
  8. 06-30-2003, 10:08 AM #8
    jovery's Avatar
    jovery
    jovery is offline Ha Ha
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    Originally posted by kanna
    Hi,
    Thnx again jovery.
    Can we use the feature LOG MINOR to retreive data?
    Just one of my mate's view.
    Rgds,
    No, TRUNCATE TABLE command is a DDL command, not a DML command. LogMiner doesn't support DDL commands.

    Basic step by step if the database is in archivelog mode

    1. Restore a backup of the database to another location.
    2. Recover this database to a moment in time BEFORE the truncate command occurred using RECOVER DATABASE UNTIL TIME .....
    3. Export the table data from this recovered database.
    4. Import the data back into the original database
    5. Remove the restored database.


    Regards
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!
    Reply With Quote Reply With Quote
  9. 06-30-2003, 11:27 AM #9
    Tarry's Avatar
    Tarry
    Tarry is offline Senior Advisor
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,587
    Originally posted by kanna
    Hi,
    Thnx again jovery.
    Can we use the feature LOG MINOR to retreive data?
    Just one of my mate's view.
    Rgds,
    Given your database is in archive log mode and all the arch logs are saved then you can (guessing/figuring out on when exactly the truncation occured)find the scn number and then carryout the PIT.

    I did post an example on the DBAsupport.com forum last year, but also have it here on my website. Maybe interesting for you to take a look...http://www.oraflame.com/tech/logmnr_ddl.php
    Tarry Singh
    I'm a JOLE(JavaOracleLinuxEnthusiast)
    TarryBlogging
    --- Everything was meant to be---
    Reply With Quote Reply With Quote
  10. 07-02-2003, 08:39 AM #10
    kanna
    kanna is offline Junior Member
    Join Date
    Jun 2003
    Location
    India
    Posts
    24
    Thanx u all
    guys chld not do anything since the DB was in NO ARCHIVAL MODE.
    Just took the previous day's dump and ran the process again.
    Thnx again
    Luv
    Kanna
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width