ARCH: Possible network disconnect with primary database
在配置rac + dataguard 的過程中發現主庫日誌有
ARCH: Possible network disconnect with primary database
standby 日誌歸檔應用都很正常,但是感覺還是想把這個問題解決,
發現standby 的引數中
SQL> show parameter log_archive_dest_state_2;
NAME TYPE
------------------------------------ ----------------------
VALUE
------------------------------
log_archive_dest_state_2 string
enable
SQL>
SQL> show parameter log_archive_config;
NAME TYPE
------------------------------------ ----------------------
VALUE
------------------------------
log_archive_config string
dg_config=(standby,xinrac)
原來是也進行了反向的對主庫的歸檔 :
在從庫上執行 :
sql> alter system set log_archive_dest_state_2='defer' scope=both ;
問題解決 。
ARCH: Possible network disconnect with primary database
standby 日誌歸檔應用都很正常,但是感覺還是想把這個問題解決,
發現standby 的引數中
SQL> show parameter log_archive_dest_state_2;
NAME TYPE
------------------------------------ ----------------------
VALUE
------------------------------
log_archive_dest_state_2 string
enable
SQL>
SQL> show parameter log_archive_config;
NAME TYPE
------------------------------------ ----------------------
VALUE
------------------------------
log_archive_config string
dg_config=(standby,xinrac)
原來是也進行了反向的對主庫的歸檔 :
在從庫上執行 :
sql> alter system set log_archive_dest_state_2='defer' scope=both ;
問題解決 。
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/90618/viewspace-1103054/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- standby database to primary database.Database
- Archiving not possible: No primary destinations errorsError
- Create RAC Standby Database for RAC Primary DatabaseDatabase
- Renaming a Datafile in the Primary DatabaseDatabase
- ORA-16649: possible failover to another database prevents this database from beiAIDatabase
- ORA-600 [krslint.9] in PRIMARY databaseDatabase
- [摘錄] Refining Remote Archival Over a Slow Network with the ARCH ProcessREM
- “alter database switchover to xx“過程不當導致的primary-primary 雙主問題Database
- Standby和Primary DB出現通訊問題後的arch gap 傳輸問題
- Types of Oracle Database Users : Network Administrators (3)OracleDatabase
- ALTER SYSTEM DISCONNECT SESSION ClauseSession
- wait for possible quiesce finishAIUI
- disconnect session和kill session的區別Session
- sql primary key procedureSQL
- disconnect session和kill session的區別 轉Session
- alter system disconnect/kill session 'sid,serial#';Session
- Play Arch LinuxLinux
- 資料量大引發的disconnect Issue問題
- 使用 arch-ppa 建立你自己的 Arch Linux 軟體庫Linux
- ABS - the Arch Build System(轉)UI
- ITEM中的UNIT OF PRIMARY.
- Is it possible to use EXPDP directly with GZIP ? [ID 463336.1]
- expdp_impdp使用network_link遠端使用者需要EXP_FULL_DATABASE角色Database
- Arch Linux配置gnome桌面Linux
- Arch! 從安裝開始
- Linux基礎命令---archLinux
- chroot恢復Arch LinuxLinux
- Arch Linux AUR 工具 yayLinux
- Arch更新時failed to prepare transactionAI
- ARCH wait on SENDREQ 等待事件AI事件
- 安裝 Lantern (Arch Linux)Linux
- 等待事件ARCH wait on ATTACH事件AI
- housekeep arch logs (tested on AIX)AI
- 時間同步(Arch Linux)Linux
- Arch Linux安裝macOSLinuxMac
- Arch Linux ARM相關Linux
- What's the maximum typical speed possible with a USB2.0 drive?
- SQL Server Primary Key ConstraintsSQLServerAI