Oracle pfile/spfile 간 변환

■ pfile을 spfile로 변환

create spfile='/opt/oracle/app/oracle/11g/dbs/spfileHA.ora' from pfile='/opt/oracle/app/oracle/11g/dbs/initHA.ora';

create spfile='/opt/oracle/app/oracle/11g/dbs/spfileGATEONE.ora' from pfile='/opt/oracle/app/oracle/11g/dbs/initGATEONE.ora';


spfile을 pfile로 변환은 역순으로 하면 된다.

위로 스크롤