Wednesday, May 2, 2012

Restore read only tablespace with rman

A colleague of mine was restoring a database. After some time he shouted  i'm missing some
tablespace why won't rman restore them.
After a quick look from me and i saw what the poblem was. There where read only tablespaces in
that database. If you want rman to restore them you have to do the following

RESTORE DATABASE CHECK READONLY;
RECOVER DATABASE CHECK READONLY;

rman will check if the are of the right version and restore/recover them.

No comments:

Post a Comment