URGENT ---- BIG MISTAKE --- HELP !!!!
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 14

Thread: URGENT ---- BIG MISTAKE --- HELP !!!!

  1. #1
    Join Date
    Mar 2001
    Posts
    82
    Hi,

    I was using a third party tool to drop tables from a tablespace.
    When I confirmed the action, I noticed, too late, that the WHOLE TABLESPACE
    was dropped.

    Since this is a relatively small database, with only 4 users, we didn't have backup procedures
    (WE WILL AS OF NOW!!!!!). We did manual backups once in a while, the latest one being
    a few months ago. How can I restore the database as best as I can??

    Can I use the REDO logs? How do I do this??

    Please, detailed steps as I am not really a DBA.

    Thanks.

  2. #2
    Join Date
    Aug 2001
    Posts
    390
    several questions need to be answered!!!!

    What Oracle version are you running on ???

    The latest backup you had, what kind of backup is that ??? You can't use your redo log to recover your table when you dropped.



  3. #3
    Join Date
    Mar 2001
    Posts
    82
    Oracle 8.1.7

    Last backup was a full export end of December.

  4. #4
    Join Date
    Nov 2001
    Posts
    335
    If you have cold or hot backup of your database and all archived redo logs since your last backup than you can restore your database from the backup on a different server and on the same server with the different name and roll forward up to the point where tablespace was dropped. Please state what kind of backup you have and whether you have all archived redo logs.

    One, who thinks that the other one who thinks that know and does not know, does not know either!

  5. #5
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,587
    what all files did u lose in that tablespace/r u in archivelog mode or noarchive logmode?
    then we can think up a strategy. The Q is to see how much of of data is going to be lost forver(meaning the period between end dec and now!)

    Tarry Singh
    I'm a JOLE(JavaOracleLinuxEnthusiast)
    TarryBlogging
    --- Everything was meant to be---

  6. #6
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,587
    what all files did u lose in that tablespace/r u in archivelog mode or noarchive logmode?
    then we can think up a strategy. The Q is to see how much of of data is going to be lost forever(meaning the period between end dec and now!)

    Tarry Singh
    I'm a JOLE(JavaOracleLinuxEnthusiast)
    TarryBlogging
    --- Everything was meant to be---

  7. #7
    Join Date
    Aug 2001
    Posts
    390
    If you have the full export in Dec , you can recover that table but all of the data from DEc to now will be lost.


    use import utility to import your table and the command as follow:

    IMP USERNAME/PASSWWORD FILE=FILENAME.DMP LOG=RECOVER.LOG TABLES=THE TABLE WAS LOST


    hope this will help

  8. #8
    Join Date
    Mar 2001
    Posts
    82
    I am not running in ARCHIVELOG mode.
    I have some REDO log files.

    ..........AH! I MIGHT BE A LUCKY MAN

    It seems there is a .dmp file that was created this morning (at the fatal time).
    Must have been done by the software, or Oracle, or GOD !!!!

    I will be recreating the database from this export file and hope it works.

  9. #9
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    Originally posted by DQuinn
    I am not running in ARCHIVELOG mode.
    I have some REDO log files.

    ..........AH! I MIGHT BE A LUCKY MAN

    It seems there is a .dmp file that was created this morning (at the fatal time).
    Must have been done by the software, or Oracle, or GOD !!!!

    I will be recreating the database from this export file and hope it works.
    Or a DBA

    Angel

  10. #10
    Join Date
    May 2002
    Posts
    108

    Oracle? or God!

    Hi

    Can you mention in which directory u see the newly generated dump file?

    This may not be a good news... as it was created at
    the FATAL time !

    Nandu
    :(
    Never give up !

    Nanda Kumar - Vellore

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