ORACLE 11G 擴充套件表空間增加資料檔案導致DG日誌應用失敗
ORACLE 11G 擴充套件表空間增加資料檔案導致DG日誌應用失敗
SQL> select sequence#, first_time, next_time, applied from v$archived_log where applied='NO' order by sequence# ;
SEQUENCE# FIRST_TIME NEXT_TIME APPLIED
---------- ------------------- ------------------- ---------
5854 2017-03-07 09:45:15 2017-03-07 10:25:32 NO
5855 2017-03-07 10:25:32 2017-03-07 11:07:54 NO
5856 2017-03-07 11:07:54 2017-03-07 13:11:58 NO
5857 2017-03-07 13:11:58 2017-03-07 13:53:35 NO
5858 2017-03-07 13:53:35 2017-03-07 13:56:08 NO
5859 2017-03-07 13:56:08 2017-03-07 13:57:02 NO
7934 2017-03-07 10:11:37 2017-03-07 10:25:29 NO
7935 2017-03-07 10:25:29 2017-03-07 10:39:35 NO
7936 2017-03-07 10:39:35 2017-03-07 10:53:36 NO
7937 2017-03-07 10:53:36 2017-03-07 11:07:53 NO
7938 2017-03-07 11:07:53 2017-03-07 11:22:17 NO
SEQUENCE# FIRST_TIME NEXT_TIME APPLIED
---------- ------------------- ------------------- ---------
7939 2017-03-07 11:22:17 2017-03-07 12:01:19 NO
7940 2017-03-07 12:01:19 2017-03-07 13:11:57 NO
7941 2017-03-07 13:11:57 2017-03-07 13:26:16 NO
7942 2017-03-07 13:26:16 2017-03-07 13:39:49 NO
7943 2017-03-07 13:39:49 2017-03-07 13:53:34 NO
7944 2017-03-07 13:53:34 2017-03-07 13:56:11 NO
7945 2017-03-07 13:56:11 2017-03-07 13:56:17 NO
18 rows selected.
alert日誌報錯如下:
Errors in file /home/db/oracle/diag/rdbms/shdbdg/shdbdg/trace/shdbdg_pr00_13185.trc:
ORA-01119: error in creating database file '+DATADG/db/trade07.dbf'
ORA-17502: ksfdcre:4 Failed to create file +DATADG/db/trade07.dbf
ORA-15001: diskgroup "DATADG" does not exist or is not mounted
ORA-15077: could not locate ASM instance serving a required diskgroup
ORA-29701: unable to connect to Cluster Synchronization Service
File #13 added to control file as 'UNNAMED00013'.
處理過程如下:
ALTER SYSTEM SET db_create_file_dest='/home/db/oracle/oradata/shassdbdg' SCOPE=BOTH;
shutdown immediate
startup mount
alter database recover managed standby database disconnect from session
Errors in file /home/db/oracle/diag/rdbms/shassdbdg/shassdbdg/trace/shassdbdg_pr00_20795.trc:
ORA-01111: name for data file 13 is unknown - rename to correct file
ORA-01110: data file 13: '/app/oracle/ora11g/dbs/UNNAMED00013'
ORA-01157: cannot identify/lock data file 13 - see DBWR trace file
ORA-01111: name for data file 13 is unknown - rename to correct file
ORA-01110: data file 13: '/app/oracle/ora11g/dbs/UNNAMED00013'
Completed: alter database recover managed standby database disconnect from session
Recovery Slave PR00 previously exited with exception 1111
MRP0: Background Media Recovery process shutdown (shassdbdg)
Tue Mar 07 13:56:33 2017
Archived Log entry 13168 added for thread 1 sequence 7944 ID 0xf2cfba52 dest 1:
Tue Mar 07 13:57:02 2017
Primary database is in MAXIMUM PERFORMANCE mode
ALTER DATABASE RECOVER managed standby database cancel
ALTER SYSTEM SET standby_file_management='MANUAL' SCOPE=BOTH;
alter database create datafile '/app/oracle/ora11g/dbs/UNNAMED00013' as '/home/db/oracle/oradata/shass
ALTER SYSTEM SET standby_file_management='AUTO' SCOPE=BOTH;
ALTER DATABASE RECOVER managed standby database using current logfile disconnect from session
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/29500582/viewspace-2134858/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 擴充套件表空間套件
- python擴充套件檔案import失敗Python套件Import
- Oracle 表空間增加檔案Oracle
- 【Oracle】 Oracle11gR2 擴充套件資料庫聯機日誌檔案Oracle套件資料庫
- 誤刪歸檔日誌除導致備份歸檔日誌失敗
- 增加自動擴充套件臨時表空間及改變預設表空間套件
- oracle dg庫資料檔案空間不足Oracle
- oracle UNDO表空間一個bug——undo表空間快速擴充套件Oracle套件
- oracle rac on aix 下為表空間增加資料檔案OracleAI
- 檢視Oracle資料庫表空間大小,是否需要增加表空間的資料檔案Oracle資料庫
- 【實驗】修改資料庫檔案為自動擴充套件以達到表空間自動擴充套件的目的資料庫套件
- oracle 日誌檔案佔空間Oracle
- Oracle 10g 物理DataGuard擴充套件表空間Oracle 10g套件
- 表空間自動擴充套件 AUTOALLOCATE 的擴充套件規律套件
- ORA-03206,當表空間不夠時,如何以新增資料檔案的方式擴充套件表空間套件
- Oracle RAC+DG 表空間擴容Oracle
- oracle 關閉資料檔案的擴充套件Oracle套件
- ORACLE 11G RAC 增加日誌組及增大日誌檔案Oracle
- 擴充套件資料檔案大小套件
- Oracle資料檔案自動擴充套件會充分利用最後剩餘空間Oracle套件
- 表空間擴充套件過程 停電導致異常中斷, 無法啟動套件
- 如何檢視Oracle資料庫表空間大小(空閒、已使用),是否要增加表空間的資料檔案...Oracle資料庫
- 【學習日記】oracle之表空間、資料檔案、控制檔案Oracle
- Oracle 表空間與資料檔案Oracle
- oracle 資料檔案表空間管理Oracle
- testng擴充套件 失敗的用例重跑套件
- TSM備份時因歸檔日誌丟失而導致備份失敗
- mysql臨時表空間不夠導致主從複製失敗MySql
- MySQL 磁碟空間滿導致表空間相關資料檔案損壞故障處理MySql
- oracle 表空間 資料檔案 筆記Oracle筆記
- Oracle 表空間資料檔案遷移Oracle
- 查詢表空間是否具備自動擴充套件空間套件
- 新建的表空間(或資料檔案)丟失以及控制檔案丟失,有新建表空間(或資料檔案)前的控制文
- Oracle dg歸檔同步失敗Oracle
- Oracle10g中的flashback啟用日誌歸檔,寫滿空間導致錯誤Oracle
- oracle 失誤刪掉資料檔案後,刪除表空間操作Oracle
- 回滾段擴充套件資料檔案套件
- oracle 表空間、段、資料擴充和資料塊——來自網路Oracle