Hi All,
DB: 11GR2
OS:RHEL
I am migrating my database from filesystem to ASM, however while doing so my spfile is still reflecting the path of filesystem. Here are the steps that I have performed:
>CREATE SPFILE='+DGDATA/spfileasmdb.ora' FROM PFILE='/oracle/app/product/11.2.0/dbhome_2/dbs/initasmdb.ora';
>STARTUP FORCE NOMOUNT;
And now when I check the spfile, the spfile is still showing the path of filesystem:
SQL> sho parameter spfile;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string /oracle/app/product/11.2.0/dbhome_2/dbs/spfileasmdb.ora
But when I check the ls -l command in asmcmd, i can see that the spfile is pointing to the above path:
ASMCMD> ls -l
Type Redund Striped Time Sys Name
Y ASM/
Y ASMDB/
N spfileasmdb.ora => +DGDATA/ASMDB/PARAMETERFILE/spfile.275.918
Is this normal, or there is some other way to do it,please advise.
Regards,
Sphinx
STARTUP FORCE NOMOUNT;
STARTUP FORCE NOMOUNT;
STARTUP FORCE NOMOUNT;