Sunday, July 1, 2012

Moving SPfile From ASM to File System

its Easy Steps

1-

SQL>Show parameter Spfile ;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string      +DATA/orcl/spfileorcl.ora
2-

Create pfile='/u01/new.pfile' from spfile ;

3-

Create spfile='/u01/app/oracle/product/10.2.0/db_1/dbs/newspfile.ora' from
pfile='/u01/new.pfile';


4-

Shutdown immediate ;
startup ;

5-
Check new Location For Spfile ;


Thank you
Osama Mustafa

No comments:

Post a Comment