OGG-01028 Opening file error
2014-12-16 13:59:01 ERROR OGG-01028 Opening file +FRA/1_13536_857160808.dbf in DBLOGREADER mode: (308) ORA-00308: cannot open archived log '+FRA/1_13536_857160808.dbf'
ORA-17503: ksfdopn:2 Failed to open file +FRA/1_13536_857160808.dbf
ORA-15173: entry '1_13536_857160808.dbf' does not exist in directory '/'.
故障描述:由於生產庫開啟關閉歸檔時間點與啟動OGG不同步!ogg抽取程式啟動報錯,將抽取程式的讀取時間調整到開啟歸檔時前後!時間差不超過1分鐘最好!
解決:alter extract ezg_cx2 ,begin 2014-12-16 08:10:00
順便說下ogg情況下正確起停歸檔和ogg的順序
1.停止OGG;
2;關閉歸檔;
shutdown immediate;
startup mount; #開啟控制檔案,不開啟資料檔案
alter database noarchivelog; #將資料庫切換為非歸檔模式
alter database open;
3.開啟歸檔;
shutdown immediate;
startup mount; #開啟控制檔案,不開啟資料檔案
alter database archivelog; #將資料庫切換為非歸檔模式
alter database open;
archive log list;
4.記錄開啟歸檔時間點;
5;alter extract ezg_cx2 ,begin 《時間點》
6.start ezg_cx2;
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/29863023/viewspace-1369833/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- ORA-01116: error in opening database file 14ErrorDatabase
- ERROR OGG-00446 Missing filename opening checkpoint file.Error
- ERROR 23 (HY000) at line 29963: Out of resources when opening fileError996
- 關於WAS當中FFDC報告error in opening zip file剖析及解決Error
- ERROR OGG-01028Error
- OGG-01028 Recovery record is missing ERRORError
- OGG-01028 Recovery record is missing ERROR[續]Error
- Error 15: File not found for RedhatErrorRedhat
- HPUX Error 23 File table overflowUXError
- GoldenGate extract process abended with error OGG-01028的處理GoError
- Solaris syntax error: unexpected end of fileError
- java.io.IOException: Error opening job jar: hadoop-0.20.2-examples.jarJavaExceptionErrorJARHadoop
- "Failed to create empty document" error message appears when opening the BrightStor ARCserve BackupAIErrorAPP
- 452 Error writing file: A file cannot be larger than the value set by ulimit.ErrorMIT
- fatal error: openssl/sha.h: No such file or directoryError
- fatal error: sys/cdefs.h: No such file or directoryError
- Error on opening a connection to slave1:33061 on local port: 33061Error
- psql: error: could not connect to server: No such file or directorySQLErrorServer
- fatal error: libmemcached/memcached.h: No such file or directoryErrorIBM
- ScalaSigParserError: Unexpected error: Not a valid class fileError
- line 10:syntax error: unexpected end of fileError
- R安裝package報ERROR: a 'NAMESPACE' file is requiredPackageErrornamespaceUI
- linux:ora-27054:nfs file system errorLinuxNFSError
- 3.2.2 Opening a Closed DatabaseDatabase
- Failed: error reading separator after document # 1: bad JSON array format - found no opening brackAIErrorJSONORM
- "Fatal error: Call to undefined function: file_put_contents()"ErrorUndefinedFunction
- Oracle Database on NFS : unable to lock file - already in use" ErrorOracleDatabaseNFSError
- /usr/bin/xauth: error in locking authority file錯誤Error
- ERROR: Check /etc/pam.conf file permissions and ownershipError
- O/S-Error: (OS 33) The process cannot access the fileError
- 配置NDK syntax error: unexpected end of file 解決Error
- 10.2.0.2 RAC DB ">>> ERROR IN KQLMBIVG SEE LCK TRACE FILEError
- TNS-04414 file error 錯誤解決Error
- Binary XML file line #2: Error inflatingXMLError
- Log check error: Log file /var/log/messages is not readable!Error
- FILE ON OCFS CANNOT BE DELETED LINUX ERROR: 16: DEVICE OR RESOURCE BUSYdeleteLinuxErrordev
- su - grid 提示E297: Write error in swap fileError
- OPatch failed with error code 135, Given 'ocmrf' file does not existsAIError