Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

Solution to control file loss

2025-04-03 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

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.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report