How Oracle Restore SPFILE
Timings to Restore SPFILE At several occasions listed below, you may need to restore it from a previously backed up SPFILE. SPFILE was accidentally deleted.… Read More »How Oracle Restore SPFILE
DB_UNKNOWN
How to Resolve ORA-32002: cannot create SPFILE already being used by the instance
ORA-32002 Tried to restore the server parameter (SPFILE) to the default location from a parameter file (PFILE), but it failed with ORA-32002 like this. SQL>… Read More »How to Resolve ORA-32002: cannot create SPFILE already being used by the instance
Srvctl Add Database Example
Add RAC DB Let me ask you a question, why would you like to add a RAC database to a cluster? In my experience, there're… Read More »Srvctl Add Database Example
How to Resolve SPFILE in DB_UNKNOWN
SPFILE in DB_UNKNOWN When I tried to restore SPFILE to the default location at nomount state, I found that SPFILE was restored to a DB_UNKNOWN… Read More »How to Resolve SPFILE in DB_UNKNOWN