Drop Database but Keep SPFILE
AliDOct 31 2010 — edited Nov 1 2010Hi,
Starting 10g, Oracle introduced the command DROP DATABASE. It drops data files, redo logs, controlfile and SPFILE.
However, I want to keep SPFILE; because I'm going to restore the database immediately after drop. One solution is to copy spfile somewhere and copy it back to original location after each drop. Another is to use PFILE instead.
None of these really suits my situation. Do you guys know of any other workaround to run from RMAN or SQLPLUS?
Thanks,
Ali