7 Replies Latest reply: Jul 14, 2010 6:53 AM by BelMan RSS

    how to get back deleted data logically

    742953
      Hi
      Friends


      Once again need your guidance to solve my this problem.
      If I have deleted data and commited.Now I want to bring that data back.
      How m I to do this.I want to do it logically.


      Pls help me.Is there any thirdparty software to do it logically if yes thwn what its name


      Hope to hear soon

      Regrds,
      Chandrima Roy
        • 1. Re: how to get back deleted data logically
          Srini Chavali-Oracle
          Pl post OS and database versions.

          Pl explain what you mean by "logically".

          The right way would be to restore the database from a previous backup and roll forward / recover to the necessary point.

          Pl also indicate what this has to do with a database upgrade (which is the title of this forum)

          HTH
          Srini
          • 2. Re: how to get back deleted data logically
            Lubiez Jean-Valentin
            Hello,


            As previously asked, please post your Oracle Version.

            Starting with Oracle 9.2 you have the Flashback Query which can help to get an image of the data in the past.

            Then starting with 10g, Oracle developped many Flashback features (Flashback Transaction, Flashback Table, Flashback Drop, Flashback Database, ...) which can help you to cancel logically a wrong transaction after commit.

            Please, find enclosed a link about Flashback Technology:

            http://www.oracle.com/technology/deploy/availability/htdocs/Flashback_Overview.htm


            Hope this help.
            Best regards,
            Jean-Valentin
            • 3. Re: how to get back deleted data logically
              ZahKar
              There are number of ways to recover from such user erros:

              1). RMAN incomplete recovery, if you have proper backups and redo logs to recover until the time just before the user error happened.
              http://www.kods.net/use-rman-based-incomplete-recovery-time/

              2). Flash back query, if UNDO is being managed properly.
              http://www.orafaq.com/node/50

              3). Flashback database if set to ON and flashback logs are being written.
              http://www.oracle-base.com/articles/10g/Flashback10g.php#flashback_database

              4). Last but not the least, Oracle LogMiner, required minimal setup i.e. db should be in Archive Log Mode.
              For Oracle 10g:
              http://www.oracleflash.com/25/Using-Oracle-LogMiner-to-undo-incorrectly-committed-changes.html
              For Oracle 11g:
              http://www.oracleflash.com/31/Oracle-11g-DBMS_FLASHBACK-TRANSACTION_BACKOUT.html
              http://www.oracleflash.com/30/Oracle-11g-Flashback-Transaction-in-OEM-LogMiner-Interface.html
              • 4. Re: how to get back deleted data logically
                user1122693
                Please let us know which version your using

                if it is 10g you can use flashback version and transcation query. new feature in 10g
                • 5. Re: how to get back deleted data logically
                  742953
                  Hi

                  Firstly I would thks all my friends who have given me suggestion.
                  I am using ORACLE10g and installed in linux server.

                  Moreover by logicaly i want to recover the data from the sql comand prompt or by any thirdparty tool.
                  Some friends hv suggested me of doing auditing.
                  Pls guide me about that.
                  and tell me if any other third party tool is also available or not.

                  Thanks & Regards
                  Chandrima Roy
                  • 6. Re: how to get back deleted data logically
                    Srini Chavali-Oracle
                    >
                    Moreover by logicaly i want to recover the data from the sql comand prompt or by any thirdparty tool.
                    Some friends hv suggested me of doing auditing.
                    Pls guide me about that.
                    and tell me if any other third party tool is also available or not.
                    >

                    Unless you explain what you mean by "logically" (as requested above), it will be impossible to help.

                    In all of the replies above, I see no reference to auditing. Regardless, AFAIK auditing does not play a role in recovery.

                    Srini
                    • 7. Re: how to get back deleted data logically
                      BelMan
                      what oracle version do you work with if you work with 10g or higher and your undo retention is sized to keep data for long interval, you can enable the flashback featuures if it's disabled

                      execute the command execute dbms_flashback.enable_at_time(to_time_stamp(sysdate-interval '4' hour));
                      for example ---- select empno from scot.emp;
                      and you the Pl/SQL cursor to load the data

                      Edited by: user8601310 on 14/07/2010 04:53 ص