Control Files

sql> alter system set control_file='d:\oracle\oradata\sue\control01.ctl','d:\oracle\oradata\sue\control0 2.ctl' to scope='spfile'; alter system set control_file='d:\oracle\oradata\sue\control01.ctl','d:\oracle\oradata\sue\control0 2.ctl' to scope='spfile' * error at line 1: ora-02065: illegal option for alter system sql> alter system set control_files='d:\oracle\oradata\sue\control01.ctl','d:\oracle\oradata\sue\control 02.ctl' scope='spfile'; alter system set control_files='d:\oracle\oradata\sue\control01.ctl','d:\oracle\oradata\sue\control 02.ctl' scope='spfile' * error at line 1: ora-00922: missing or invalid option sql> alter system set control_files='d:\oracle\oradata\sue\control01.ctl','d:\oracle\oradata\sue\control 02.ctl' scope=spfile; system altered. sql> shutdown immediate database closed. database dismounted. oracle instance shut down. sql> startup oracle instance started. total system global area

135338868 bytes

fixed size variable size database buffers

453492 bytes 109051904 bytes 25165824 bytes

redo buffers

667648 bytes

database mounted. database opened. sql> show parameter control name

type

value

------------------------------------ ----------- -----------------------------control_file_record_keep_time

integer

7

control_files

string

d:\oracle\oradata\sue\control0

1.ctl, d:\oracle\oradata\sue\c ontrol02.ctl sql> shutdown immediate database closed. database dismounted. oracle instance shut down. sql> startup pfile='d:\oracle\admin\sue\pfile\init.ora'; oracle instance started. total system global area

135338868 bytes

fixed size variable size

453492 bytes 109051904 bytes

database buffers

25165824 bytes

redo buffers

667648 bytes

ora-00205: error in identifying controlfile, check alert log for more info sql> shutdown immediate ora-01507: database not mounted oracle instance shut down. sql> startup pfile='d:\oracle\admin\sue\pfile\init.ora'; oracle instance started. total system global area

135338868 bytes

fixed size variable size

453492 bytes 109051904 bytes

database buffers

25165824 bytes

redo buffers

667648 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 fixed size

135338868 bytes 453492 bytes

variable size

109051904 bytes

database buffers

25165824 bytes

redo buffers

667648 bytes

database mounted. database opened. sql> alter system set control_files='d:\oracle\oradata\sue\control01.ctl','d:\oracle\oradata\sue\control 02.ctl','d:\oracle\oradata\sue\control03.ctl' to scope=spfile; alter system set control_files='d:\oracle\oradata\sue\control01.ctl','d:\oracle\oradata\sue\control 02.ctl','d:\oracle\oradata\sue\control03.ctl' to scope=spfile * error at line 1: ora-02095: specified initialization parameter cannot be modified sql> alter system set control_files='d:\oracle\oradata\sue\control01.ctl','d:\oracle\oradata\sue\control 02.ctl','d:\oracle\oradata\sue\control03.ctl' to scope='spfile'; alter system set control_files='d:\oracle\oradata\sue\control01.ctl','d:\oracle\oradata\sue\control 02.ctl','d:\oracle\oradata\sue\control03.ctl' to scope='spfile' * error at line 1: ora-02095: specified initialization parameter cannot be modified sql> alter system set control_files='d:\oracle\oradata\sue\control01.ctl','d:\oracle\oradata\sue\control 02.ctl','d:\oracle\oradata\sue\control03.ctl' scope=spfile; system altered. sql> shutdown immediate database closed. database dismounted. oracle instance shut down. sql> startup oracle instance started. total system global area fixed size variable size database buffers redo buffers

135338868 bytes 453492 bytes 109051904 bytes 25165824 bytes 667648 bytes

ora-00205: error in identifying controlfile, check alert log for more info sql> startup

ora-01081: cannot start already-running oracle - shut it down first sql> shutdown immediate ora-01507: database not mounted oracle instance shut down. sql> startup oracle instance started. total system global area

135338868 bytes

fixed size variable size

453492 bytes 109051904 bytes

database buffers

25165824 bytes

redo buffers

667648 bytes

database mounted. database opened. sql> shutdown immediate database closed. database dismounted. oracle instance shut down. sql> startup pfile='d:\oracle\admin\sue\pfile\init.ora'; oracle instance started. total system global area

135338868 bytes

fixed size variable size

453492 bytes 109051904 bytes

database buffers

25165824 bytes

redo buffers

667648 bytes

database mounted. database opened. sql> shutdown immediate database closed. database dismounted. oracle instance shut down. sql> startup oracle instance started. total system global area fixed size variable size database buffers redo buffers

135338868 bytes 453492 bytes 109051904 bytes 25165824 bytes 667648 bytes

ora-00214: controlfile 'd:\oracle\oradata\sue\control01.ctl' version 303

inconsistent with file 'd:\oracle\oradata\sue\control03.ctl' version 300 sql> shutdown immediate ora-01507: database not mounted oracle instance shut down. sql> startup pfile='d:\oracle\admin\sue\pfile\init.ora'; oracle instance started. total system global area

135338868 bytes

fixed size variable size

453492 bytes 109051904 bytes

database buffers

25165824 bytes

redo buffers

667648 bytes

database mounted. database opened. sql> shutdown immediate database closed. database dismounted. oracle instance shut down. sql> startup oracle instance started. total system global area

135338868 bytes

fixed size variable size

453492 bytes 109051904 bytes

database buffers

25165824 bytes

redo buffers

667648 bytes

ora-00214: controlfile 'd:\oracle\oradata\sue\control01.ctl' version 306 inconsistent with file 'd:\oracle\oradata\sue\control03.ctl' version 300 sql> shutdown immediate ora-01507: database not mounted oracle instance shut down. sql> startup oracle instance started. total system global area fixed size variable size

135338868 bytes 453492 bytes 109051904 bytes

database buffers redo buffers

25165824 bytes 667648 bytes

ora-00214: controlfile 'd:\oracle\oradata\sue\control01.ctl' version 306 inconsistent with file 'd:\oracle\oradata\sue\control03.ctl' version 300 sql> startup pfile='d:\oracle\admin\sue\pfile\init.ora'; ora-01081: cannot start already-running oracle - shut it down first sql> shutdown immediate ora-01507: database not mounted oracle instance shut down. 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 bytes 453492 bytes 109051904 bytes 25165824 bytes 667648 bytes

ora-01167: two files are the same file/group number or the same file ora-00202: controlfile: 'd:\oracle\oradata\sue\control02.ctl' sql> shutdown immediate ora-01507: database not mounted oracle instance shut down. 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 bytes 453492 bytes 109051904 bytes 25165824 bytes 667648 bytes

database mounted. database opened. sql> show prameter control sp2-0158: unknown show option "prameter" sp2-0158: unknown show option "control" sql> show parameter control name

type

value

------------------------------------ ----------- -----------------------------control_file_record_keep_time

integer

7

control_files

string

d:\oracle\oradata\sue\control0 1.ctl, d:\oracle\oradata\sue\c ontrol02.ctl

sql> shutdown immediate database closed. database dismounted. oracle instance shut down. sql> startup pfile='d:\oracle\admin\pfile\inti.ora'; lrm-00109: could not open parameter file 'd:\oracle\admin\pfile\inti.ora' ora-01078: failure in processing system parameters sql> startup pfile='d:\oracle\admin\sue\pfile\inti.ora'; lrm-00109: could not open parameter file 'd:\oracle\admin\sue\pfile\inti.ora' ora-01078: failure in processing system parameters sql> startup pfile='d:\oracle\admin\pfile\inti.ora'; lrm-00109: could not open parameter file 'd:\oracle\admin\pfile\inti.ora' ora-01078: failure in processing system parameters sql> startup oracle instance started. total system global area fixed size variable size database buffers redo buffers

135338868 bytes 453492 bytes 109051904 bytes 25165824 bytes 667648 bytes

ora-00214: controlfile 'd:\oracle\oradata\sue\control01.ctl' version 309 inconsistent with file 'd:\oracle\oradata\sue\control03.ctl' version 300 sql> shutdown immediate ora-01507: database not mounted oracle instance shut down. sql> startup pfile='d:\oracle\admin\pfile\inti.ora'; lrm-00109: could not open parameter file 'd:\oracle\admin\pfile\inti.ora' ora-01078: failure in processing system parameters sql> startup oracle instance started. total system global area fixed size variable size

135338868 bytes 453492 bytes 109051904 bytes

database buffers

25165824 bytes

redo buffers

667648 bytes

ora-00205: error in identifying controlfile, check alert log for more info sql> show parameter control name

type

value

------------------------------------ ----------- -----------------------------control_file_record_keep_time

integer

7

control_files

string

d:\oracle\oradata\sue\control0 1.ctl, d:\oracle\oradata\sue\c ontrol02.ctl, d:\oracle\oradat a\sue\control03.ctl

sql> alter system set control_files='d:\oracle\oradata\sue\control01.ctl','d:\oracle\oradata\sue\control 02.ctl' scope=spfile; system altered. sql> alter system mount 2 / alter system mount * error at line 1: ora-02065: illegal option for alter system sql> alter database mount 2 / alter database mount * error at line 1: ora-00205: error in identifying controlfile, check alert log for more info sql> shutdown immediate ora-01507: database not mounted oracle instance shut down. sql> startup oracle instance started. total system global area fixed size variable size

135338868 bytes 453492 bytes 109051904 bytes

database buffers

25165824 bytes

redo buffers

667648 bytes

database mounted. database opened. sql> alter system set control_files='d:\oracle\oradata\sue\control01.ctl','d:\oracle\oradata\sue\control 02.ctl','d:\oracle\oradata\sue\control03.ctl' scope=spfile; system altered. sql> shoutdown immediate sp2-0734: unknown command beginning "shoutdown ..." - rest of line ignored. sql> shutdown immediate database closed. database dismounted. oracle instance shut down. sql> startup oracle instance started. total system global area

135338868 bytes

fixed size variable size database buffers

453492 bytes 109051904 bytes 25165824 bytes

redo buffers

667648 bytes

database mounted. database opened. sql> create pfile='d:\oracle\admin\sue\pfile\init.ora' from spfile; file created. sql> show parameter control name

type

value

------------------------------------ ----------- -----------------------------control_file_record_keep_time

integer

7

control_files

string

d:\oracle\oradata\sue\control0 1.ctl, d:\oracle\oradata\sue\c ontrol02.ctl, d:\oracle\oradat a\sue\control03.ctl

sql> spool off

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------inconsistent erroe

sql> alter system set control_files='d:\oracle\oradata\sue\control01.ctl','d:\oracle\oradata\sue\con trol02.ctl','d:\oracle\oradata\sue\control03.ctl','d:\oracle\oradata\sue\control04 .ctl' scope=spfile ; system altered. sql> shutdown immediate ora-01507: database not mounted oracle instance shut down. 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> create pfile='d:\oracle\admin\sue\pfile\init.ora' from spfile; file created. sql> show parameter control name -----------------------------------control_file_record_keep_time control_files

type ----------integer string

value -----------------------------7 d:\oracle\oradata\sue\control0 1.ctl, d:\oracle\oradata\sue\c ontrol02.ctl, d:\oracle\oradat a\sue\control03.ctl

sql> shutdown immediate database closed. database dismounted. oracle instance shut down. sql> startup ora-32004: obsolete and/or deprecated parameter(s) specified oracle instance started. total system global area fixed size

135338868 bytes 453492 bytes

variable size 109051904 bytes database buffers 25165824 bytes redo buffers 667648 bytes ora-00214: controlfile 'd:\oracle\oradata\sue\control01.ctl' version 369 inconsistent with file 'd:\oracle\oradata\sue\control04.ctl' version 360 sql> shutdown immediate ora-01507: database not mounted oracle instance shut down. sql> startup pfile='d:\oracle\admin\sue\pfile\init.ora' ora-32006: mts_servers initialization parameter has been deprecated 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\control01.ctl' version 369 inconsistent with file 'd:\oracle\oradata\sue\control04.ctl' version 360 sql> shutdown immediate ora-01507: database not mounted oracle instance shut down. sql> startup ora-32004: obsolete and/or deprecated parameter(s) specified 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\control01.ctl' version 369 inconsistent with file 'd:\oracle\oradata\sue\control04.ctl' version 360 sql> shutdown immediate ora-01507: database not mounted oracle instance shut down. //soultion: ********************************************************************************** *** go to d:\oracle\admin\sue\pfile\init.ora and change the control file parameter ********************************************************************************** *** sql> startup pfile='d:\oracle\admin\sue\pfile\init.ora'

ora-32006: mts_servers initialization parameter has been deprecated 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> show parameter control

bytes bytes bytes bytes bytes

name -----------------------------------control_file_record_keep_time control_files

type ----------integer string

value -----------------------------7 d:\oracle\oradata\sue\control0 1.ctl, d:\oracle\oradata\sue\c ontrol02.ctl, d:\oracle\oradat a\sue\control03.ctl sql> create spfile from pfile='d:\oracle\admin\sue\pfile\init.ora';