解決 CRS-2640: Required resource
當你刪除了一個磁碟組後沒有及時在crs裡更新,這樣當你重啟crs後 db不會起來,因為crs裡仍然記錄以前的 diskgroup
當你啟動時候就是報錯如下
srvctl start instance -d darin -i darin1
PRCR-1013 : Failed to start resource ora.darin.db
PRCR-1064 : Failed to start resource ora.darin.db on node darin1
CRS-2640: Required resource 'ora.DATA.dg' is missin
解決此問題很簡單
首先檢視我的db
srvctl config database -d darin
Database unique name: darin
Database name: darin
Oracle home: /oracle/product/11.2.0
Oracle user: oracle
Spfile: +DATA_NEW/darin/spfiledarin.ora
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: darin
Database instances: darin1,darin2
PRCD-1012 : Failed to retrieve disk group list for database darin.
PRCR-1035 : Failed to look up CRS resource ora.DATA.dg for darin
PRCA-1000 : ASM Disk Group DATA does not exist
PRCR-1001 : Resource ora.DATA.dg does not exist
提示我的 DATA 不存在,這個data dg是我已經刪除了,但是沒有來得及在crs更新
看一下db 資訊,發現任然保留著以前的兩個dg
crsctl status resource ora.darin.db -f
SERVER_POOLS=ora.darin
SPFILE=+DATA_NEW/darin/spfiledarin.ora
START_DEPENDENCIES=hard(ora.DATA.dg,ora.FRA.dg,ora.DATA_NEW.dg,ora.FRA_NEW.dg)
更新crs中db 中dg的資訊,注意這裡要用root使用者,如果用grid則提示許可權不足
as root user login
srvctl modify database -d darin -a "DATA_NEW,FRA_NEW"
再次啟動一下db,正常。
當你啟動時候就是報錯如下
srvctl start instance -d darin -i darin1
PRCR-1013 : Failed to start resource ora.darin.db
PRCR-1064 : Failed to start resource ora.darin.db on node darin1
CRS-2640: Required resource 'ora.DATA.dg' is missin
解決此問題很簡單
首先檢視我的db
srvctl config database -d darin
Database unique name: darin
Database name: darin
Oracle home: /oracle/product/11.2.0
Oracle user: oracle
Spfile: +DATA_NEW/darin/spfiledarin.ora
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: darin
Database instances: darin1,darin2
PRCD-1012 : Failed to retrieve disk group list for database darin.
PRCR-1035 : Failed to look up CRS resource ora.DATA.dg for darin
PRCA-1000 : ASM Disk Group DATA does not exist
PRCR-1001 : Resource ora.DATA.dg does not exist
提示我的 DATA 不存在,這個data dg是我已經刪除了,但是沒有來得及在crs更新
看一下db 資訊,發現任然保留著以前的兩個dg
crsctl status resource ora.darin.db -f
SERVER_POOLS=ora.darin
SPFILE=+DATA_NEW/darin/spfiledarin.ora
START_DEPENDENCIES=hard(ora.DATA.dg,ora.FRA.dg,ora.DATA_NEW.dg,ora.FRA_NEW.dg)
更新crs中db 中dg的資訊,注意這裡要用root使用者,如果用grid則提示許可權不足
as root user login
srvctl modify database -d darin -a "DATA_NEW,FRA_NEW"
再次啟動一下db,正常。
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/26175573/viewspace-1288966/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- maven eclipse miss required library解決MavenEclipseUI
- ORA-25507: resource 解決方法
- Access restriction: The type 'Resource' is not API 解決辦法RESTAPI
- phpmyadmin 提示 PHP 5.2+ is required 的解決辦法PHPUI
- 解決nltk_data LookupError: Resource punkt not found.Error
- Laravel Resource Routes和API Resource Routes講解LaravelAPI
- 解決 The ‘supervisor==3.2.0‘ distribution was not found and is required by the application錯誤UIAPP
- 使用命令登入harbor報錯authentication required解決方法UI
- su cannot set user id Resource temporarily unavailable故障解決AI
- Myeclipse:resource is out of sync with the file system的解決辦法Eclipse
- Python安裝MySQL庫詳解(解決Microsoft Visual C++ 9.0 is required )PythonMySqlROSC++UI
- ora-00054:resource busy and acquire with nowait specified解決方法UIAI
- 解決eclipse中出現Resource is out of sync with the file system問題Eclipse
- _resource_manager_always_on=FALSE引起排程異常的解決案例False
- "ORA-00054 resource busy and acquire with NOWAIT specified"的解決方法UIAI
- Python成功解決TypeError: __init__() missing 1 required positional argument: ‘comment‘PythonErrorUI
- 解決Eclipse/STS 中出現Resource is out of sync with the file system 的異常Eclipse
- Drawable Resource 之旅(一):BitmapDrawable 詳解
- Adobe Flashplayer orHTML5 Browser with WebGL or CSS3D support required 解決方案HTMLWebCSSS33DUI
- Could not open ServletContext resource [/WEB-INF/applicationContext.xml]解決ServletContextWebAPPXML
- @Resource 與 @Service註解的區別
- @Autowire和@Resource註解的區別
- “Use Legacy Swift Language Version” (SWIFT_VERSION) is required to be configured 這個錯誤解決方案SwiftUI
- SpringBoot 專案打包後獲取不到resource下資源的解決Spring Boot
- 異常解決 java.io.FileNotFoundException: class path resource [spring/springmvc.xml]JavaExceptionSpringMVCXML
- 關於Linux主機報錯(Resource temporarily unavailable)的解決辦法LinuxAI
- 解決 " lib64 libc so 6 version `GLIBC_2 18' not found (required by libUI
- 聊聊依賴注入註解@Resource和@Autowired依賴注入
- spingboot使用@Resource注入靜態變數報空指標的問題解決boot變數指標
- 【kingsql分享】解決RAC大量UNKNOWN和CRS-0216: Could not stop resourceSQL
- Spring5:@Autowired註解、@Resource註解和@Service註解Spring
- 完美解決未能正確載入“Visual C++ Resource Editor Package”的錯誤提示C++Package
- @Resource,@Autowired,@Inject3種注入方式詳解
- Several ports (8005, 8080) required by Tomcatv9.0 Server at localhost are already in use.Tomcat解決方案UITomcatServerlocalhost
- 解決PHP 7.4安裝xdebug出現configure: error: rtnetlink.h is required, please...PHPErrorUI
- 解決Android中No resource found that matches android:TextAppearance.Material.Widget.Button.Inverse問題AndroidAPP
- CSS :required 選擇器CSSUI
- 成功解決building ‘snappy._snappy‘ extension error: Microsoft Visual C++ 14.0 is required. Get it with “BUIAPPErrorROSC++