Usually I want to create pfile from spfile just run this command,
SQL> create pfile='/u01/app/oracle/backups/pools/pfiledb20120226.ora' from spfile; File created.
But in ASM environment, the above command raises an error,
SQL> create pfile='/u01/app/oracle/backups/pools/pfileasm20120226.ora' from spfile; create pfile='/u01/app/oracle/backups/pools/pfileasm20120226.ora' from spfile * ERROR at line 1: ORA-01565: error in identifying file '?/dbs/spfile@.ora' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 SQL> show parameter spfile; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ spfile string
Solution I found after googling,
SQL> create pfile='/u01/app/oracle/backups/pools/pfileasm20120226.ora' from memory; File created.
Filed under: Oracle |
Leave a comment