oracle ORA-01157: cannot identify/lock data file 64
有人誤在RAC端建立本地資料檔案
資料庫後臺告警
Errors in file /orasoft/oracle/diag/rdbms/ptdb/ptdb1/trace/ptdb1_dbw0_4838.trc:
ORA-01157: cannot identify/lock data file 64 - see DBWR trace file
ORA-01110: data file 64: '/orasoft/product/11.2.0/db_1/ts_st.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
1.無法正常查詢
select file_name,tablespace_name from dba_data_files where tablespace_name='TS_ST';
2.發現該資料檔案的物理檔案已經被刪除
select name from v$datafile;
3.客戶確認後 ,進行邏輯刪除
alter database datafile 64 offline drop;
4.再次查詢發現資料檔案的狀態為AVAILABLE
select file_name,tablespace_name from dba_data_files where tablespace_name='TS_ST';
5.刪除整個表空間及資料檔案
drop tablespace TL_SL including contents and datafiles;
正常情況來說,是可以刪掉,但是刪除表空間出現ORA-22868錯誤
在當前要刪除的表空間中含有大型別比如blob型別的欄位,並且該段可能儲存於不同的表空間內
6.EVENT_FORM存在bolb型別的欄位,drop掉即可
select owner,table_name,tablespace_name from dba_lobs where tablespace_name='TS_ST';
7.drop成功
drop tablespace TS_ST including contents and datafiles;
來自 “ ITPUB部落格 ” ,連結:https://blog.itpub.net/69980685/viewspace-3001494/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- ORA-01157: cannot identify/lock data file n 故障一例IDE
- ORA-01157: cannot identify/lock data file %s - see DBWR trace file的處理IDE
- Unload data to a flat file from Oracle databaseOracleDatabase
- Oracle Database on NFS : unable to lock file - already in use" ErrorOracleDatabaseNFSError
- [轉載]Oracle等待事件Data file init writeOracle事件
- unable to get file lock, will retry ...
- ORA-19505: failed to identify file "/home/oracle/dmp/20150625.DMP"AIIDEOracle
- oracle 匯入報錯:field in data file exceeds maximum lengthOracle
- 【蓋國強】Oracle Wait Event:Data file init writeOracleAI
- oracle10g 資料檔案頭data file header(file header)OracleHeader
- ThunderSoft File Lock for Mac檔案鎖Mac
- sqlplus cannot execute binary fileSQL
- libmysqlclient.so.16: cannot open shared object file: No such file or directoryIBMMySqlclientObject
- libcap.so.1:cannot open shared object file: No such file or directoryObject
- libXext.so.6: cannot open shared object file: No such file or directoryObject
- libz.so.1: cannot open shared object file: No such file or directoryObject
- 452 Error writing file: A file cannot be larger than the value set by ulimit.ErrorMIT
- VMware vmdk錯誤: Failed to lock the file.AI
- HP -Data Protector Restore file systemREST
- Error: DPI-1047: Cannot locate a 64-bit Oracle Client library: "問題ErrorOracleclient
- ImportError: libffi.so.7: cannot open shared object file: No such file or directoryImportErrorObject
- ulimit: core file size: cannot modify limit: Operation not permittedMIT
- oracle lock鎖_v$lock_轉Oracle
- Unable to create index.lock File exists錯誤Index
- Android:Unexpected lock protocol found in lock file. Expected 3, found 0.AndroidProtocol
- kafka啟動報錯:kafka.common.KafkaException: Failed to acquire lock on file .lockKafkaExceptionAIUI
- [Oracle Script] LockOracle
- About Oracle LockOracle
- oracle enqueue lockOracleENQ
- Oracle Latch & LockOracle
- sqlldr Field in data file exceeds maximum lengthSQL
- data file int write和db file sequential read個人想法
- OUI-10020 'A Write Lock Cannot be Obtained' During Oracle Installation_358550.1UIAIOracle
- Cannot find SS.INI file for user *** 解決方法
- O/S-Error: (OS 33) The process cannot access the fileError
- conda環境下ImportError: libmkl_intel_lp64.so.1: cannot open shared object file問題解決ImportErrorIBMIntelObject
- 記錄 libldap-2.4.so.2: cannot open shared object file: No such file or directoryLDAObject
- 問題1.libXp.so.6: cannot open shared object file: No such file or directoryObject