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

What is the solution to ORA-00205 error?

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

Share

Shulou(Shulou.com)05/31 Report--

This article shows you what the solution to ORA-00205 error is, the content is concise and easy to understand, it will definitely brighten your eyes. I hope you can get something through the detailed introduction of this article.

SQL > startup

The ORACLE instance has been started.

The total global area of the system is 68108236 bytes

65484 bytes of Fixed Size

21708800 bytes of Variable Size

46260224 bytes of Database Buffers

73728 bytes of Redo Buffers

ORA-00205: error in identifying control file, check alert log for more info

Checked alert log.

Thu May 31 16:55:23 2011

ORA-00202: controlfile:'c:\ Oracle\ oradata\ SMZY\ control02.ctl'

ORA-27048: skgfifi: file header information is invalid

OSD-04004: invalid file header

Is to control the file control02.ctl corruption, so look at the control01.ctl file, this file is normal, use this file to copy the backup, change the file name to control02.ctl.

SVRMGR > shutdown

Closed the ORACLE instance.

SVRMGR > startup

The ORACLE instance has been started.

The total global area of the system is 68108236 bytes

65484 bytes of Fixed Size

21708800 bytes of Variable Size

46260224 bytes of Database Buffers

73728 bytes of Redo Buffers

The database is mounted.

Opened the database.

Database opened successfully, do a full backup.

Or: if the database tablespace is migrated to the disk array of optical storage, it is normal to modify the ctl control file and restart the database application.

The above content is what is the solution to the ORA-00205 error? have you learned the knowledge or skills? If you want to learn more skills or enrich your knowledge reserve, you are welcome to follow the industry information channel.

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

Servers

Wechat

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

12
Report