Shulou(Shulou.com)06/01 Report--

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

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.