conn /as sysdba;
select * from v$controlfile;
create pfile from spfile;
shutdown immediade;
到OS
cp /oracle/database/xxx/control01 /oracle_xxx/control04
cp /oracle/product/10.2.0.1/dbs/initxxx.ora
/oracle/product/10.2.0.1/dbs/initxxx.ora.bak
vi /oracle/product/10.2.0.1/dbs/initxxx.ora
修改其中的control_file参数
sqlplus /nolog
conn /as sysdba;
startup pfile=/oracle/product/10.2.0.1/dbs/initxxx.ora;
select * from v$controlfile; --已经加上了
create spfile from pfile='/oracle/product/10.2.0.1/dbs/initxxx.ora';
shutdown immediate;
sqlplus /nolog
conn /as sysdba;
startup
select * from v$controlfile; --已经加上了