sql> show parameter control name -----------------------------------control_file_record_keep_time control_files
type ----------integer string
value -----------------------------7 d:\oracle\oradata\sue\suecontr ol01.ctl, d:\oracle\oradata\su e\suecontrol02.ctl, d:\oracle\ oradata\sue\suecontrol03.ctl sql> -------------we have three control file in spfile---------------------------sql> sql> ----------now add a one controlfile sql> alter system set control_files='d:\oracle\oradata\sue\suecontrol01.ctl','d:\oracle\oradata\sue\suec ontrol02.ctl','d:\oracle\oradata\sue\suecontrol03.ctl','d:\oracle\oradata\sue\suec ontrol04.ctl' scope=spfile; system altered. sql> -----now we create controlfile logically sql> shutdown immediate database closed. database dismounted. oracle instance shut down. sql> sql> startup oracle instance started. total system global area 135338868 bytes fixed size 453492 bytes variable size 109051904 bytes database buffers 25165824 bytes redo buffers 667648 bytes ora-00205: error in identifying controlfile, check alert log for more info sql> ----because physically controlfile4 not created sql> sql> shutdown immediate ora-01507: database not mounted oracle instance shut down. sql> ------------now physically created sql> startup oracle instance started. total system global area 135338868 fixed size 453492 variable size 109051904 database buffers 25165824 redo buffers 667648 database mounted. database opened. sql> shutdown immediate database closed. database dismounted. oracle instance shut down.
bytes bytes bytes bytes bytes
sql> sql> ---now spfile is work sql> ---now start with pfile sql> startup pfile='d:\oracle\admin\sue\pfile\init.ora'; oracle instance started. total system global area 135338868 fixed size 453492 variable size 109051904 database buffers 25165824 redo buffers 667648 database mounted. database opened. sql> --now db open sql> shutdown immediate database closed. database dismounted. oracle instance shut down. sql> --now start spfile sql> startup oracle instance started.
bytes bytes bytes bytes bytes
total system global area 135338868 bytes fixed size 453492 bytes variable size 109051904 bytes database buffers 25165824 bytes redo buffers 667648 bytes ora-00214: controlfile 'd:\oracle\oradata\sue\suecontrol01.ctl' version 1430 inconsistent with file 'd:\oracle\oradata\sue\suecontrol04.ctl' version 1427 sql> shutdown immediate ora-01507: database not mounted oracle instance shut down. sql> ---now start with pfile sql> startup pfile='d:\oracle\admin\sue\init.ora' lrm-00109: could not open parameter file 'd:\oracle\admin\sue\init.ora' ora-01078: failure in processing system parameters sql> startup pfile='d:\oracle\admin\sue\init.ora'; lrm-00109: could not open parameter file 'd:\oracle\admin\sue\init.ora' ora-01078: failure in processing system parameters sql> startup pfile='d:\oracle\admin\sue\pfile\init.ora'; oracle instance started. total system global area 135338868 bytes fixed size 453492 bytes variable size 109051904 bytes database buffers 25165824 bytes redo buffers 667648 bytes database mounted. database opened. sql> ---db start with pfile sql> create spfile from pfile'd:\oracle\admin\sue\init.ora'; create spfile from pfile'd:\oracle\admin\sue\init.ora' * error at line 1:
ora-00933: sql command not properly ended sql> ed wrote file afiedt.buf 1* create spfile from pfile='d:\oracle\admin\sue\init.ora' sql> / create spfile from pfile='d:\oracle\admin\sue\init.ora' * error at line 1: ora-01078: failure in processing system parameters lrm-00109: could not open parameter file 'd:\oracle\admin\sue\init.ora' sql> create spfile from pfile='d:\oracle\admin\sue\init.ora'; create spfile from pfile='d:\oracle\admin\sue\init.ora' * error at line 1: ora-01078: failure in processing system parameters lrm-00109: could not open parameter file 'd:\oracle\admin\sue\init.ora' sql> show parameter pfile name type value ------------------------------------ ----------- -----------------------------spfile string sql> show parameter spfile name type value ------------------------------------ ----------- -----------------------------spfile string sql> startup pfile='d:\oracle\admin\sue\pfile\init.ora'; ora-01081: cannot start already-running oracle - shut it down first sql> create spfile from pfile='d:\oracle\admin\sue\init.ora'; create spfile from pfile='d:\oracle\admin\sue\init.ora' * error at line 1: ora-01078: failure in processing system parameters lrm-00109: could not open parameter file 'd:\oracle\admin\sue\init.ora' sql> shutdown immediate database closed. database dismounted. oracle instance shut down. sql> startup pfile='d:\oracle\admin\sue\init.ora'; lrm-00109: could not open parameter file 'd:\oracle\admin\sue\init.ora' ora-01078: failure in processing system parameters sql> startup pfile='d:\oracle\admin\sue\pfile\init.ora'; oracle instance started. total system global area fixed size variable size database buffers redo buffers
135338868 453492 109051904 25165824 667648
bytes bytes bytes bytes bytes
database mounted. database opened. sql> create spfile from pfile='d:\oracle\admin\sue\pfile\init.ora'; file created. sql> shutdown immediate database closed. database dismounted. oracle instance shut down. sql> startup oracle instance started. total system global area 135338868 bytes fixed size 453492 bytes variable size 109051904 bytes database buffers 25165824 bytes redo buffers 667648 bytes database mounted. database opened. sql> sql> alter system set control_files='d:\oracle\oradata\sue\suecontrol01.ctl','d:\oracle\oradata\sue\ sp2-0734: unknown command beginning "sql> alter..." - rest of line ignored. sql> suecontrol02.ctl','d:\oracle\oradata\sue\suecontrol03.ctl','d:\oracle\oradata\sue\ suecontrol04.ctl' sp2-0734: unknown command beginning "suecontrol..." - rest of line ignored. sql> scope=spfile; sp2-0734: unknown command beginning "scope=spfi..." - rest of line ignored. sql> ed wrote file afiedt.buf 1* create spfile from pfile='d:\oracle\admin\sue\pfile\init.ora' sql> . sql> alter system set control_files='d:\oracle\oradata\sue\suecontrol01.ctl','d:\oracle\oradata\sue\suec ontrol02.ctl','d:\oracle\oradata\sue\suecontrol03.ctl','d:\oracle\oradata\sue\suec ontrol04.ctl' scope=spfile; system altered. sql> shutdown immmediate sp2-0717: illegal shutdown option sql> shutdown immediate database closed. database dismounted. oracle instance shut down. sql> startup oracle instance started. total system global area 135338868 bytes fixed size 453492 bytes variable size 109051904 bytes database buffers 25165824 bytes redo buffers 667648 bytes ora-00214: controlfile 'd:\oracle\oradata\sue\suecontrol01.ctl' version 1439 inconsistent with file 'd:\oracle\oradata\sue\suecontrol04.ctl' version 1427
sql> alter database mount; database altered. sql> show parameter control name -----------------------------------control_file_record_keep_time control_files
value -----------------------------7 d:\oracle\oradata\sue\suecontr ol01.ctl, d:\oracle\oradata\su e\suecontrol02.ctl, d:\oracle\ oradata\sue\suecontrol03.ctl, d:\oracle\oradata\sue\suecontr ol04.ctl sql> create pfile='d:\oracle\admin\sue\init.ora' from spfile; file created. sql> shutdown immediate ora-01109: database not open database dismounted. oracle instance shut down. sql> spool off
type ----------integer string