Get the App
SLTechnology News&Howtos  ›  Database  › 

Solution to control file loss

Shulou Source: shulou.com Published: 2022-06-01 17:12:21 11月16日 Update

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

Tags: File control mode space method Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno Xiaomi Linux OPPO Reno Docker NVidia