How to recover tables in 11g oracle using rman
I created table mytable in oracle 11g in database Mydb1;
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.
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
-- 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
Click Here to Expand Forum to Full Width