While creating pfile from spfile getting below error.
SQL> create pfile from spfile
create pfile from spfile
*
ERROR at line 1:
ORA-27046: file size is not a multiple of logical block size
Additional information 1
Solution:
As per metalink serach it seems the SPFILE has previously been manually edited when the instance was opened and the spfile has gone corrupted.
If all the parameter are same then, yes copy the pfile from production to the DR and then as the database is opened using the spfile, you need to shut it down, and open it with the new pfile. After opening the database successfully, create the spfile from it.
