RMAN>backup database archivelogs all;
After that I truncated a table.
I then tried to restore with,
RMAN>restore database; RMAN>recover database; RMAN>alter database open;
I connected with sqldeveloper, and the table is still empty. I have tried many times. I made sure there wer archive files with crosscheck backup. It simply never restores the data to that table in the schema. I know you cannot restore a single table, so I restored the whole database thinking it would put my data back.
There is one database, one backup, truncate, one restore (did this a lot). I have tried
set until for an incomplete backup, many things. I don't need a point in time, however. I was trying to get anything to work.
I received no errors. Everything looked good.
- All disk backup.
- Oracle Enterprise Linux 6.5.
- Oracle 11gR2, 22.214.171.124
- I have not used logminer.
What am I doing wrong?