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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- ORA-16649: possible failover to another database prevents this database from beiAIDatabase
- “alter database switchover to xx“過程不當導致的primary-primary 雙主問題Database
- [20180918]disconnect session和kill session的區別.txtSession
- kinect2.0 Self-Learning (1) - recycling disconnect (solved)
- LeetCode之All Possible Full Binary Trees(Kotlin)LeetCodeKotlin
- Play Arch LinuxLinux
- The database owner SID recorded in the master database differs from the database owner SID recorded in database 'DB_NAME'DatabaseAST
- 使用 arch-ppa 建立你自己的 Arch Linux 軟體庫Linux
- What's the maximum typical speed possible with a USB2.0 drive?
- ERROR 1062 (23000): Duplicate entry for key 'PRIMARY'Error
- Oracle Database Cloud - Database as a Service Quick StartOracleDatabaseCloudUI
- Error querying database. XXXXXXXXXXXXX, No database selected。ErrorDatabase
- Convert a Physical Standby Database into a Snapshot Standby DatabaseDatabase
- Linux基礎命令---archLinux
- Arch Linux ARM相關Linux
- Arch Linux安裝macOSLinuxMac
- Arch Linux 安裝 AnboxLinux
- chroot恢復Arch LinuxLinux
- Arch Linux配置gnome桌面Linux
- Arch Linux AUR 工具 yayLinux
- 判斷standby日誌是否同步primary
- DATAGUARD手記(PRIMARY+2STANDBY)(一)
- Elasticsearch 節點選舉和primary分片Elasticsearch
- DATAGUARD手記(PRIMARY+2STANDBY)(二)
- FastCGI sent in stderr: "Primary script unknown" 報錯AST
- Database TimeoutDatabase
- Database OverallDatabase
- database no shardingDatabase
- Arch Linux中安裝AnacondaLinux
- Arch更新時failed to prepare transactionAI
- Arch Linux 系統遷移Linux
- Vmware Station安裝Arch LinuxLinux
- Arch! 從安裝開始
- XFS: nfsd(13480) possible memory allocation deadlock size 65532 in kmem_reallocNFS
- 簡單分析MySQL中的primary key功能MySql
- Simple Neural Network
- Set介面_network
- Oracle 12.2 使用Database Link優化Standby Database WorkloadOracleDatabase優化
- 更改arch的預設終端