how can recover data delete
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 3 123 LastLast
Results 1 to 10 of 21

Thread: how can recover data delete

  1. #1
    Join Date
    Nov 2001
    Posts
    34
    How can recover row delete the table having archivelog mode , bad not having rman.

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Jan 2001
    Posts
    3,131
    ROLLBACK in a word

    MH
    I remember when this place was cool.

  4. #4
    Join Date
    Nov 2001
    Posts
    34
    example

    sql> select count(1) from tabla;
    500 rows select
    sql> delete from tabla;
    500 rows delete
    sql> commit;

    i want recover data having archivelog mode.

    thanks

  5. #5
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Point in time recovery. Check the manuals on how to do it. BTW, you don't need RMAN to perform PITR.

    Or, as Jeff allready suggested, use Log Miner.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  6. #6
    Join Date
    Nov 2001
    Posts
    34
    i run the command

    svrmgrl> recover database until time 'date:hour:';
    svrmgrl> alter database open noresetlogs;

    but i didn't function.

  7. #7
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Originally posted by cazpa
    i run the command

    svrmgrl> recover database until time 'date:hour:';
    You must specify the time in the following format: 'YYYY-MM-DD:HH24:MI:SS'. No exceptions to this rule, only this date format will be accepted.

    svrmgrl> alter database open noresetlogs;
    You cant use NORESETLOGS after incomplete recovery. You must open your database with:
    ALTER DATABASE OPEN RESETLOGS;

    As I said, you realy should spend some time with your manuals if you are serious about backup&recovery.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  8. #8
    Join Date
    Nov 2001
    Posts
    34
    is clear dad format is
    recover database until time '2001-02-05:12:43:00';
    alter database open resetlogs;

    but i didn'n function

  9. #9
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    What kind of error messages?

    Did you restore your database?
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  10. #10
    Join Date
    Nov 2001
    Posts
    34
    therd are no errors :

    SVRMGR> recover database until time '2001-02-05:12:43:00';
    Media recovery complete.
    SVRMGR> alter database open resetlogs;
    Statement processed.

    but my table doesn't have rows.


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