Skip to Content
0
Former Member
Jun 25, 2008 at 02:39 PM

deleted everything in .../dbs

19 Views

Hi!

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.

Thanks!!