How to recover tables in 11g oracle using rman
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: How to recover tables in 11g oracle using rman

  1. #1
    Join Date
    Jun 2009
    Posts
    1

    Unhappy How to recover tables in 11g oracle using rman

    I created table mytable in oracle 11g in database Mydb1;
    then,
    performed following steps for cold backup on remote Share using rman commands.
    I) Connect target /
    II) shutdown immediate
    III) startup nomount;
    IV) sql 'alter database mount';
    V) backup full tag full_offline_backup format '\\Machine_IP\Share_Name\%d_%U_%T'(database);
    VI) sql 'alter database open';

    After completing the backup ,i truncated the mytable. now i want to restorethis table from the backup i have taken so i performed following steps for restore,recovery using remote backup
    I) startup mount
    II) restore database;
    III) recover database;
    IV) alter database open;

    but i m not getting my records in the table back.
    What should i do to get mytable data.

    can anyone help me please...
    waiting for the reply...thanx in advance.

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    it works as it should, you restored it and recovered it - so you recovered past your truncate.

    You would need to restore to BEFORE you truncated the table (using set until time) and open resetlog from there

    also note, you cannot recover just tables, just tablespaces

  3. #3
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,483

    Cool -- Or --

    Or, recover databas with required tablespaces only to another host/location and export/import tables.
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

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