OraFAQ Forum: Backup & Recovery » point in time recovery of a table through rman

Home » RDBMS Server » Backup & Recovery » point in time recovery of a table through rman

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

point in time recovery of a table through rman [message #194612]

Sat, 23 September 2006 00:45

vijaykumarsudi
Messages: 9
Registered: September 2006
Location: hyderabad

Junior Member

I am trying to recover a table which was dropped at particular time through rman,the problem is i am able to recover the table with the data,but the transactions made on the other table are lost even i committed it.can u plz help me in this problem
thanks in advance.
vijay

Report message to a moderator

Re: point in time recovery of a table through rman [message #194640 is a reply to message #194612]

Sat, 23 September 2006 05:28

email.sandeepnaik
Messages: 121
Registered: August 2006

Senior Member

First of all make sure time for restore is correct.

If you want to get table back (which was dropped) you may give earlier time(which is ok). In this case.Once table is available, export data from table which is dropped...and then redo all exercise of recovery, restart recovery , this time move further, let table get dropped..apply logs till you see proper data in other tables...once you are at that stage..you can open database.
You also have export of table which was dropped. Import it back.

Sandeep

Report message to a moderator