现场故障案例：控制文件损坏
现场故障 案例：控制文件损坏 本文出自 深蓝的blog 博客，若转载，请务必保留此出处：http://blog.csdn.net/huangyanlong 1、手工切归档时出错； 2、查看告警信息； 3、转储/disk2下的控制文件； 4、启库，切归档； 5、手工执行0级全备。 时间 目的 操作 09:
现场故障 案例：控制文件损坏
本文出自 “深蓝的blog” 博客，若转载，请务必保留此出处：http://blog.csdn.net/huangyanlong
1、手工切归档时出错；
2、查看告警信息；
3、转储/disk2下的控制文件；
4、启库，切归档；
5、手工执行0级全备。
|
时间 |
目的 |
操作 |
|
09:50 |
正常巡检，开启告警日志， 检查数据库时间、状态 |
#tail -f /u01/app/oracle/admin/metro/bdump/alert_metro.log
SQL> SELECT sysdate from dual; SYSDATE ----------------- 21-05-14 09:50:24 SQL> select status from v$instance; STATUS ------------ OPEN
|
|
09:51 |
发现告警日志中 一条cannot提示信息 |
Wed May 21 09:47:15 2014 Thread 1 cannot allocate new log, sequence 104 Checkpoint not complete Current log# 3 seq# 103 mem# 0: /u01/app/oracle/oradata/metro/redo03.log Current log# 3 seq# 103 mem# 1: /disk1/metro/redofile/redo03a.log Thread 1 advanced to log sequence 104 Current log# 1 seq# 104 mem# 0: /u01/app/oracle/oradata/metro/redo01.log Current log# 1 seq# 104 mem# 1: /disk1/metro/redofile/redo01a.log |
|
09:53 |
发现告警日志中 连续出现ORA-00202告警信息
|
Wed May 21 09:53:25 2014 Hex dump of (file 0, block 1) in trace file /u01/app/oracle/admin/metro/bdump/metro_arc0_385212.trc Corrupt block relative dba: 0x00000001 (file 0, block 1) Completely zero block found during control file header read Wed May 21 09:53:25 2014 Errors in file /u01/app/oracle/admin/metro/bdump/metro_arc0_385212.trc: ORA-00202: control file: '/disk2/metro/control_file/control03.ctl' Wed May 21 09:53:26 2014 Errors in file /u01/app/oracle/admin/metro/bdump/metro_arc0_385212.trc: ORA-00227: corrupt block detected in control file: (block 1, # blocks 1) ORA-00202: control file: '/disk2/metro/control_file/control03.ctl' |
|
10:10 |
到数据库下进行手工归档， 报错并断开连接 |
SQL> alter system switch logfile; alter system switch logfile * ERROR at line 1: ORA-03135: connection lost contact |
|
10:12 |
尝试启库，失败，报错 |
SQL> startup ORACLE instance started. Total System Global Area 612368384 bytes Fixed Size 2022800 bytes Variable Size 226493040 bytes Database Buffers 377487360 bytes Redo Buffers 6365184 bytes ORA-00205: error in identifying control file, check alert log for more info
|
|
10:13 |
根据启库时提示信息 及告警日志信息， 初判控制文件存在问题 |
启库时提示： ORA-00205: error in identifying control file, check alert log for more info 告警日志中提示： ORA-00202: control file: '/disk2/metro/control_file/control03.ctl' |
|
10:16 |
根据提示转储disk2下控制文件
|
[oracle@aix203]$cd /disk2/metro/control_file [oracle@aix203]$ls control03.ctl [oracle@aix203]$mv control03.ctl control03.ctl.bak [oracle@aix203]$cd /disk1/metro/control_file [oracle@aix203]$ls control02.ctl [oracle@aix203]$cp control02.ctl /disk2/metro/control_file/control03.ctl |
|
10:19 |
启库，成功 |
SQL> startup; ORACLE instance started.
Total System Global Area 612368384 bytes Fixed Size 2022800 bytes Variable Size 226493040 bytes Database Buffers 377487360 bytes Redo Buffers 6365184 bytes Database mounted. Database opened. |
|
10:20 |
删除有问题的控制文件 |
[oracle@aix203]$ls control03.ctl control03.ctl.bak [oracle@aix203]$rm control03.ctl.bak [oracle@aix203]$ls control03.ctl |
|
10:22 |
0级全备 |
[oracle@aix203]$cd /home/oracle/ [oracle@aix203]$ls ctl.sh scripts smit.log smit.script smit.transaction [oracle@aix203]$cd scripts [oracle@aix203]$ls bin log tmp [oracle@aix203]$cd bin [oracle@aix203]$ls rmanlevel0.sh rmanlevel0.sh.bak rmanlevel1.sh rmanlevel1.sh.bak [oracle@aix203]$sh rmanlevel0.sh
|
|
10:28 |
完成全备 |
|
|
10:29 |
切归档 |
SQL> alter system archive log current; System altered. |
原创作品，允许转载，转载时请务必注明出处（http://blog.csdn.net/huangyanlong）、作者信息和本声明 。关于涉及版权事宜，作者有权追究法律责任。
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
AI Hentai Generator
Generate AI Hentai for free.
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
1376
52
How to recover expired WeChat files? Can expired WeChat files be recovered?
Feb 22, 2024 pm 02:46 PM
Open WeChat, select Settings in Me, select General and then select Storage Space, select Management in Storage Space, select the conversation in which you want to restore files and select the exclamation mark icon. Tutorial Applicable Model: iPhone13 System: iOS15.3 Version: WeChat 8.0.24 Analysis 1 First open WeChat and click the Settings option on the My page. 2 Then find and click General Options on the settings page. 3Then click Storage Space on the general page. 4 Next, click Manage on the storage space page. 5Finally, select the conversation in which you want to recover files and click the exclamation mark icon on the right. Supplement: WeChat files generally expire in a few days. If the file received by WeChat has not been clicked, the WeChat system will clear it after 72 hours. If the WeChat file has been viewed,
Photos cannot open this file because the format is not supported or the file is corrupted
Feb 22, 2024 am 09:49 AM
In Windows, the Photos app is a convenient way to view and manage photos and videos. Through this application, users can easily access their multimedia files without installing additional software. However, sometimes users may encounter some problems, such as encountering a "This file cannot be opened because the format is not supported" error message when using the Photos app, or file corruption when trying to open photos or videos. This situation can be confusing and inconvenient for users, requiring some investigation and fixes to resolve the issues. Users see the following error when they try to open photos or videos on the Photos app. Sorry, Photos cannot open this file because the format is not currently supported, or the file
Can Tmp format files be deleted?
Feb 24, 2024 pm 04:33 PM
Tmp format files are a temporary file format usually generated by a computer system or program during execution. The purpose of these files is to store temporary data to help the program run properly or improve performance. Once the program execution is completed or the computer is restarted, these tmp files are often no longer necessary. Therefore, for Tmp format files, they are essentially deletable. Moreover, deleting these tmp files can free up hard disk space and ensure the normal operation of the computer. However, before deleting Tmp format files, we need to
What to do if the 0x80004005 error code appears. The editor will teach you how to solve the 0x80004005 error code.
Mar 21, 2024 pm 09:17 PM
When deleting or decompressing a folder on your computer, sometimes a prompt dialog box "Error 0x80004005: Unspecified Error" will pop up. How should you solve this situation? There are actually many reasons why the error code 0x80004005 is prompted, but most of them are caused by viruses. We can re-register the dll to solve the problem. Below, the editor will explain to you the experience of handling the 0x80004005 error code. Some users are prompted with error code 0X80004005 when using their computers. The 0x80004005 error is mainly caused by the computer not correctly registering certain dynamic link library files, or by a firewall that does not allow HTTPS connections between the computer and the Internet. So how about
How to transfer files from Quark Cloud Disk to Baidu Cloud Disk?
Mar 14, 2024 pm 02:07 PM
Quark Netdisk and Baidu Netdisk are currently the most commonly used Netdisk software for storing files. If you want to save the files in Quark Netdisk to Baidu Netdisk, how do you do it? In this issue, the editor has compiled the tutorial steps for transferring files from Quark Network Disk computer to Baidu Network Disk. Let’s take a look at how to operate it. How to save Quark network disk files to Baidu network disk? To transfer files from Quark Network Disk to Baidu Network Disk, you first need to download the required files from Quark Network Disk, then select the target folder in the Baidu Network Disk client and open it. Then, drag and drop the files downloaded from Quark Cloud Disk into the folder opened by the Baidu Cloud Disk client, or use the upload function to add the files to Baidu Cloud Disk. Make sure to check whether the file was successfully transferred in Baidu Cloud Disk after the upload is completed. That's it
What is hiberfil.sys file? Can hiberfil.sys be deleted?
Mar 15, 2024 am 09:49 AM
Recently, many netizens have asked the editor, what is the file hiberfil.sys? Can hiberfil.sys take up a lot of C drive space and be deleted? The editor can tell you that the hiberfil.sys file can be deleted. Let’s take a look at the details below. hiberfil.sys is a hidden file in the Windows system and also a system hibernation file. It is usually stored in the root directory of the C drive, and its size is equivalent to the size of the system's installed memory. This file is used when the computer is hibernated and contains the memory data of the current system so that it can be quickly restored to the previous state during recovery. Since its size is equal to the memory capacity, it may take up a larger amount of hard drive space. hiber
What should I do if my Black Shark phone cannot be turned on? Teach you how to save yourself!
Mar 23, 2024 pm 04:06 PM
What should I do if my Black Shark phone cannot be turned on? Teach you how to save yourself! In our daily lives, mobile phones have become an indispensable part of us. For many people, the Black Shark mobile phone is a beloved gaming phone. But it is inevitable that you will encounter various problems, one of which is that the phone cannot be turned on. When you encounter such a situation, don't panic. Here are some solutions that I hope will help you. First of all, when the Black Shark phone cannot be turned on, first check whether the phone has enough power. It may be that the phone cannot be turned on due to exhausted battery.
Different uses of slashes and backslashes in file paths
Feb 26, 2024 pm 04:36 PM
A file path is a string used by the operating system to identify and locate a file or folder. In file paths, there are two common symbols separating paths, namely forward slash (/) and backslash (). These two symbols have different uses and meanings in different operating systems. The forward slash (/) is a commonly used path separator in Unix and Linux systems. On these systems, file paths start from the root directory (/) and are separated by forward slashes between each directory. For example, the path /home/user/Docume
