Oracle Drop tablespace: ORA-19258
Posted by jason on Aug 31st, 2007
I’ve done a database clone using rman hundreds of times and it works pretty much as advertised. However we have some read only tablespaces and by default rman restore database does not restore read only. You can use the check readonly option on the restore command to restore read only datafiles as well.
This time I forgot to do this and as I did not need these files I thought I would just get rid of them:
SQL> drop tablespace example; * ERROR at line 1: ORA-19528: redo logs being cleared may need access to files
The response from Oracle has so far been dismal: “the bug 6368134 on 10.2.0.3, which describe exactly this issue.” There is no fix and no workaround as yet.

