Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I used RMAN with,

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.

(edit)

  • All disk backup.
  • Oracle Enterprise Linux 6.5.
  • Oracle 11gR2, 11.2.0.3

(edit)

  • I have not used logminer.

What am I doing wrong?

share|improve this question

1 Answer 1

up vote 2 down vote accepted

You're issuing a "recover database" command, which will recover the database as far as possible. If that includes the archivelogs/redo logs which contain your "truncate" command, then this will also be re-played and the table truncated again.

Try doing the restore on it's own, or recovering to a specific time using RECOVER UNTIL... then opening the DB read-only to see if it's in the state you expect.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.