we are running 11g on LINUX and is our PROD.
we have rman implemented, the retention policy is 7 days.
Flashback is not ON.
We have some data missing on a perticular table which belongs to 27th DEC-2012 to 3rd of JAN 2013.
after the before said date data is currently available.
So basically we need to see data of this perticular days.
Kindly suggest a way.
You just want to see the data or want to permanently get it back? If the answer is yes for the 2nd option than you would need to do a TSPIT recovery for this table.
try to restore backup of 2nd..... may be you get the rows....other wise wait for guru's to reply.... AFAIK you are not able to restore the database to 27th untill you have old backup which is taken before 27th. and move your question to RMAN category.