Results 1 to 5 of 5

Thread: Flashback - Recover deleted data - oracle datbase

  1. #1
    Member
    Join Date
    Sep 2012
    Posts
    1,147

    Flashback - Recover deleted data - oracle datbase

    The flashback feature in oracle database allows you to recover the deleted data. The following example shows how to recover the data at a point of time using the flashback feature:

    Code:
    Insert into temp_table
    select * from tablename
    AS OF TIMESTAMP ('01-OCT-12 00:00:00','DD-MON-YY HH24: MI: SS'));
    This insert statement is to recover the data at the specified point of time. Now we have to get the system change number (SCN).

    Code:
    SELECT DBMS_FLASHBACK. GET_SYSTEM_CHANGE_NUMBER FROM dual;
    This query gives the SCN number. Let say the SCN number is 20560806678. The final step is to recover the data and insert into the temp table.

    Code:
    INSERT INTO temp_table
    (SELECT * FROM tablename AS OF SCN 20560806678);

  2. #2
    Junior Member
    Join Date
    Nov 2013
    Posts
    2
    Oracle database corruption is very embarrassing for the user of this database because they are totally dependent on the database. There are many reasons of database corruption and by knowing that causes you can protect your database from corruption.

    • Due to any virus attack. It can totally damage your database and make it inaccessible.
    • Due to damage operating system database will get corrupted.
    • If any hardware problem or malfunctioning are occurs in to the computer system then it will also corrupt your database.
    • Improper shut down of the database when it is running.
    • Database will also get corrupted due to the corruption of Media.

    In manual process corrupted database can be repaired by applying lengthy commands and codes on the command prompt which is very difficult to remember for the normal user of computer. In Automatic process any one can repair and restore corrupted database easily because in this process database can be repaired by using any third party oracle database repair tool.

  3. #3
    Junior Member
    Join Date
    Dec 2013
    Posts
    2
    Hi thank you I like it

  4. #4
    Senior Member
    Join Date
    Aug 2012
    Posts
    29,394
    Thanks for the answers and it made my life simpler

Similar Threads

  1. read from a file which is deleted
    By amrutha in forum Unix
    Replies: 0
    Last Post: 01-03-2013, 10:33 PM
  2. Replies: 0
    Last Post: 10-26-2012, 09:39 AM
  3. How to recover deleted file?
    By Tarah in forum Unix
    Replies: 1
    Last Post: 07-18-2012, 01:37 PM

Bookmarks

Posting Permissions

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