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

Ora-00327,ora-00312

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

Share

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

Do log switch, database handle live, cancel command execution, power off and close the database.

Then log in to the database again, start the database, and the data crashes.

Check the alert log and report ORA-00327 and ORA-00312 failures

The failure indicates that the physical size of the log2 log is 2, which is less than the required 102400, that is, the redo02.log file is corrupted.

Restart the database to the mount state and clean up the redo02.log file

An error is reported, indicating that log2 has not yet filed and needs to be filed. Use the clear unarchived command to clean up the log2 file

The database started successfully.

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

Wechat

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

12
Report