Problem: Netbackup performs rman backup job on RAC and then outputs error message 2023/12/24 上午 11:04:39 - Info bphdb (pid=1857897) INF - RMAN-03009: failure of backup command on ch00 channel…

Find table type in recyclebin select * from dba_recyclebin where owner = 'USERNAME' and type like '%TABLE%' and droptime > '2023-11-06:06:00:00' order by original…

Problem: 執行datapump資料庫匯出到NFS空間，發生ORA-錯誤 $ cat expdp_PST_20231004.par userid=system/password directory=stdump dumpfile=expdp_PST_20231004_%U.dmp logfile=expdp_PST_20231004.log parallel=16 co…

記錄一下處理Oracle測試環境Datafile放在NFS上效能緩慢的問題 Problem: 測試環境Datafile放於NFS上，正式環境放於SAM Storage AP提供問題的SQL，在測試環境跑一天出不來，正式環境則跑5分鐘 SELECT COUNT(1) FROM META_202302 WHERE TO_CHAR(PDATE, 'YYYYMMDD')…

SQL> ALTER TABLE MGR.SAVE_MT ADD PARTITION 2023M04 VALUES LESS THAN (TO_DATE(' 2023-05-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS')); ALTER TABLE MGR.SAVE_MT ADD PARTITION 2023M…

resource busy output message when dropping a table SQL> / DROP TABLE MGR.PFS_CRT_INV_SAVE_DT_C_TMP_202109 PURGE * ERROR at line 1: ORA-00054: resource busy and acquire with …

Problem: Query feback ORA-01775: looping chain of synonyms SQL> SELECT IM.ID,  IM.NAME,  IM.SID,  IM.SNAME,  IM.INUMBER,  to_date(IM.IDATE, 'yyyy/mm/dd…

check dataguard broker status show lag on Node Standby 1 , but Node Standby 2 is normal DGMGRL> show database dbdg1 Database - DBDG1 Role: PHYSICAL STANDBY Intended Sta…

Problem: ORA-01686 error was encountered when adding files to a tablespace. Is there a way to add new data files to this tablespace? SQL> begin for i in 1..96 loop execute immediate '…

在執行排除部份 table 匯出時，發生ORA-39071的錯誤，經查後主要與 Exclude=TABLE 的參數有關，調整了以下三種方式，都會出錯 oracle@ppdb /> N,TABLE:"IN (INVOICE_METADATA,CRT_INV_SAVE_MT,CRT_INV_SAVE_DT)" schemas=MGR oracle@ppdb…

在測試大dump檔匯入時，發生錯誤 ORA-31693 ORA-02354 ORA-02368 ORA-02369，以錯誤訊息來看，似乎是檔案損壞 比對了一下來源檔案與目標檔案的MD5數值是相同的，只能重新從來源端做expdp資料匯出的動作

Problem: 客戶19c版本的 alert.log 出現部份的 16063 錯誤訊息 2022-06-03T00:06:09.685391+08:00 Resize operation completed for file# 33, old size 7782400K, new size 7884800K 2022-06-03T00:06:24.219496+08:00 TTO…

Problem: # su - oracle -c 'adrci exec="set homepath diag/asmcmd/user_oracle/dgdb1;purge -age 10 -type incident"' DIA-49803: Purge not possible due to incompatible schema ver…

Problem: Output ORA-00059: maximum number of DB_FILES exceeded error when add datafile. SQL> alter tablespace data add datafile '/oracle/oradata/orcl/data186.dbf' size 32767M; alte…

Prolbem: ORA-00959: tablespace '_$deleted11$' does not exist. and Check Partition DDL store is '_$deleted11$' Solution: Updating the store in clause to new tablespace r…

收到客戶的錯誤訊息，一般來說遇到ORA-00322、ORA-00312沒有其他錯誤，可以呼略，但這次多帶了ORA-17502、ORA-15041的錯誤 ORA-00322: log 42 of thread 2 is not current copy ORA-00312: online log 42 thread 2: '+FRADG/ESBDBSTBY/ONLINELO…

在做LAB測試時，之前刪除tablespace忘了帶入including datafile，現在要建立新的tablespace時，datafile名稱已存在OS中 SQL> create tablespace testtbs datafile '/ACFS/ORCL1/TESTTBS.dbf' size 100M autoextend off; create…

Problem: 在DR備份時，發生 ORA-20079: full resync from primary database is not done 的錯誤訊息， ORA-20079: full resync from primary database is not done starting resync from primary resyncing from datab…

客戶DR主機在備份時，出現RMAN-20035錯誤訊息，手動下resync也會有一樣的錯誤 在嘗試unregister database時，出現RMAN-01005錯誤訊息，Standby RMAN註冊需透過連線至Primary註冊完後，再連回Standby才能執行 (Doc ID 2581991.1) 由於無法unregister database，因此需連至standby…

在11gR2使用AP帳號做datapump匯出時，發現執行很久，檢查發現parallel設定8個，但產生出來的dump檔只有2個 (真正執行只有parallel 1) datapump parfile內容 $ cat expdp_meta.par userid=schema/password tables=SCHEMA.METADATA:2022M02 directory=dm…