Applies to:
Oracle Server - Enterprise Edition - Version: 10.2.0.3
Information in this document applies to any platform.
Symptoms
-- Problem Statement:
After removing the ASM disks from ASM diskgroup and overwrite them using dd command, the disks still appear in the v$ASM_DISK dynamic performance view. Even after adding the disks to another diskgroup, the old disks labels still exists with status of missing in v$ASM_DISK. Restarting the ASM instance did not solve the problem
-- Steps To Reproduce:
1) Drop ASM disks from an existing ASM diskgroup
2) Overwrite the disks using dd command
3) Add the disks to another ASM diskgroup
4) Query the v$ASM_DISK view, old disks labels are still there with status of missing.
-- Business Impact:
This has no effect with the operation of ASM existing and new diskgroups. However, you may want to make sure that v$ASM_DISK contain only up to date data.
Cause
There was a problem with the sun storage system. The ASM Disk was a short time offline. after fixing the problem, two disks in the ASM diskgroup were shown as missing. The 2 disks were dropped and then used to create new diskgroup as indicated above.
Some remaining information still exists in ASM cache and Oracle Cluster Registry (OCR) which is used by Cluster Synchronization Service (CSS). The only way to remove them is at least to bounce the ASM instance, and if this is not enough, to restart the CSS (or reboot the machine) to reset the registry information.
Solution
-- To implement the solution, please execute the following steps::
Execute the following command:
1) Shutdown ASM instance
2) Stop Oracle Cluster Synchronization Service Daemon (OCSSD) using
/etc/init.cssd stop
3) Run Oracle Cluster Synchronization Service Daemon (OCSSD) using
/etc/init.cssd run
4) Startup ASM instance and query v$ASM_DISK view and make sure that the problem no longer exists.
分享到:
相关推荐
- `V$ASM_DISKGROUP` - `V$ASM_DISK` - `V$ASM_OPERATION` - `V$ASM_ALIAS` - `V$ASM_ATTRIBUTE` **14. Parameters (参数)** - **定义:** 控制ASM行为的初始化参数。 - **关键参数:** - `ASM_DISKGROUP` ...
6) If your version of Delphi does not support text format DFM files (e.g. Delphi 4 doesn't), you will have to use the convert.exe utility supplied with Delphi to convert all the demo form files to ...
It is not the best capture tool around, but I think this is why so many people have been using it: its a tool, not a program trying to show it is better than the user, or a ANSI C skill contest. ...
This makes it easy to use the tools on machines with limited memory (but enough disk space) as well as computer clusters (from a terminal). In addition, the interactive tools can optionally write the...
SELECT db_flashback_retention_target FROM v$database; ``` 如果回收站功能未启用,可以使用以下命令开启: ```sql ALTER DATABASE FLASHBACK ON; ``` ##### 2. 删除操作与回收站 当一个对象被删除时,它不会立即...
Q486834 - Ribbon - TdxRibbonBackstageView - Invoking the BackstageView does not move focus to it from the currently focused control that resides on a form with this BackstageView B233045 - Ribbon - ...
Q486834 - Ribbon - TdxRibbonBackstageView - Invoking the BackstageView does not move focus to it from the currently focused control that resides on a form with this BackstageView B233045 - Ribbon - ...
This is a breaking change for any other clients that are using it. New Features Issue 6029: Add support for downloading binary files. Issue 11205: Allow Gerrit admins to reindex a change even when...
Dropping a Collection 12 Programming with the MySQL Document Store Programming Examples Python Example Node.JS Example PHP Example Traditional SQL vs. MySQL Document Store The MySQL Shell and ...
After you find a framework file you could pull it via adb pull /path/to/file or use a file manager application. After you have the file locally, pay attention to how Apktool installs it. The number ...
v3.17 * updated libFLAC to version 1.2.1 * added a flush after every log line to help GUIs * "eac3to some.mpls" now also works if the stream files aren't there, anymore * fixed: number of subtitles ...
- `SELECT * FROM V$LOGMNR_CONTENTS(V$LOGMNR_DICTIONARY, V$LOGMNR_PARAMETERS V$LOGMNR_LOGS);`查询分析结果。 - `EXECUTE DBMS_LOGMNR.END_LOGMNR;`结束LogMiner进程。 ### 二表空间管理 表空间是Oracle数据库...
Well here it is, the TBMThread is a native VCL component implementing everything you do need to create the thread and the synchronization, just dropping the component on the form. Sounds great, right...
* Order of items after "Open All Items" from a project was not correct * Project Groups could be removed after doing project options * Find would not work correctly with a column selection scope * ...
`SELECT * FROM V$LOGMNR_CONTENTS(V$LOGMNR_DICTIONARY,V$LOGMNR_PARAMETERS V$LOGMNR_LOGS);` - g. `EXECUTE DBMS_LOGMNR.END_LOGMNR;` - 解析:LogMiner工具用于分析重做日志文件,以提取和报告数据库中所做的...
SQL> SELECT * FROM V$LOGMNR_CONTENTS(V$LOGMNR_DICTIONARY,V$LOGMNR_PARAMETERS V$LOGMNR_LOGS); g. SQL> EXECUTE DBMS_LOGMNR.END_LOGMNR; ``` ### 第二章:表空间管理 #### 1. 创建表空间(Creating ...
IntraWeb and the TMS Components for IntraWeb allow an unprecedented RAD way of web application development with Delphi, making web development as easy as dropping components on a form. Message ...
"It is as easy as dropping a few components on a form, write a few lines of code and what I could not previous get done in a month was now done in two hours!" says one customer. Applications which ...
SELECT * FROM V$LOGMNR_CONTENTS(V$LOGMNR_DICTIONARY, V$LOGMNR_PARAMETERS, V$LOGMNR_LOGS); ``` 6. **结束 LogMiner**: ```sql EXECUTE DBMS_LOGMNR.END_LOGMNR(); ``` #### 创建表空间 (Creating ...