Solution to control file loss
Control file loss resolution:
1 alter database backup controlfile to trace
2 paste out this paragraph in the trace file
Vi / home/oracle/control.sql
CREATE CONTROLFILE REUSE DATABASE "ORA11GR2" NORESETLOGS NOARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 292
LOGFILE
GROUP 1'/ u01 SIZE SIZE BLOCKSIZE 512
GROUP 2'/ u01 SIZE SIZE BLOCKSIZE 512
GROUP 3'/ u01 SIZE SIZE 50m oradata BLOCKSIZE
-- STANDBY LOGFILE
DATAFILE
'/ u01 apprenticeship oradataPlus ORA11GR2 Universe system01.dbf'
'/ u01 apprenticeship oradataPlus ORA11GR2 Universe sysaux01.dbf'
'/ u01 apprenticeship oradataPlus ORA11GR2 Universe undotbs01.dbf'
'/ u01GR2 / u01ActionUniverse oradataPlus ORA11GR2 max users01.dbf'
'/ u01 apprenticeship oraclecospact ORA11GR2max example01.dbf'
CHARACTER SET WE8MSWIN1252
3 shutdown immediate
four
[oracle@wdd58 ORA11GR2] $mv control01.ctl control01.ctl.bak
[oracle@wdd58 ORA11GR2] $mv control02.ctl control02.ctl.bak
5 startup nomount
@ / home/oracle/control.sql
SQL > select status from v$instance
STATUS
-
MOUNTED
6 alter database open
7 select name from v$tempfile
Found no files corresponding to temporary tablespaces
eight
Alter tablespace temp add tempfile'/ u01 reuse. ORA11GR2 reuse.
nine
Select name from v$tempfile