We are using SPFILE in our Oracle102 systems. My coworker mistakingly delected all files
in the .../dbs directory and we dont have a backup of the lost files.
Now the DB is down.
We have 2 options:
1) copy other DB's PFILE and edit it (e.g. change the SID, etc.), after the DB is up, create the spfile
from the PFILE.
2) copy other DB's initSID.ora and edit it (e.g. change the SID, etc.), start the DB.
Please advise which way is better.