standby database No RFS 程式
standby database
看到沒有RFS程式,從庫接受不到了
檢視主庫
啟備庫監聽
ok了
這個程式不用像MRP程式得用命令啟動,會自己啟動的~
點選(此處)摺疊或開啟
-
SQL> select * from v$managed_standby;
-
-
PROCESS PID STATUS CLIENT_P CLIENT_P CLIENT_DBID GROUP# RESETLOG_ID THREAD# SEQUENCE# BLOCK# BLOCKS DELAY_MINS KNOWN_AGENTS ACTIVE_AGENTS
-
--------- ------ ------------ -------- -------- --------------- ---------- ----------- ---------- ---------- ---------- ---------- ---------
-
ARCH 2602 CONNECTED ARCH 2602 845781194 N/A 0 0 0 0 0 0 0 0
-
ARCH 2604 CONNECTED ARCH 2604 845781194 N/A 0 0 0 0 0 0 0 0
-
ARCH 2606 CONNECTED ARCH 2606 845781194 N/A 0 0 0 0 0 0 0 0
-
ARCH 2608 CONNECTED ARCH 2608 845781194 N/A 0 0 0 0 0 0 0 0
- MRP0 2655 WAIT_FOR_LOG N/A N/A N/A N/A 881314188 1 33 0 0 0 0 0
檢視主庫
點選(此處)摺疊或開啟
-
SQL> select dest_id,error from v$archive_dest;
-
-
DEST_ID ERROR
-
---------- -----------------------------------------------------------------
-
1
- 2 ORA-12541: TNS:no listener
點選(此處)摺疊或開啟
-
SQL> r
-
1* select * from v$managed_standby
-
-
PROCESS PID STATUS CLIENT_P CLIENT_PID CLIENT_DBID GROUP# RESETLOG_ID THREAD# SEQUENCE# BLOCK# BLOCKS DELAY_MINS KNOWN_AGENTS ACTIVE_AGENTS
-
--------- ---------- ------------ -------- ---------- ------------------ -------- ----------- ---------- ---------- ---------- ---------- ----
-
ARCH 2602 CONNECTED ARCH 2602 845781194 N/A 0 0 0 0 0 0 0 0
-
ARCH 2604 CONNECTED ARCH 2604 845781194 N/A 0 0 0 0 0 0 0 0
-
ARCH 2606 CONNECTED ARCH 2606 845781194 N/A 0 0 0 0 0 0 0 0
-
ARCH 2608 CLOSING ARCH 2608 845781194 4 881314188 1 33 124928 867 0 0 0
-
MRP0 2655 WAIT_FOR_LOG N/A N/A N/A N/A 881314188 1 42 0 0 0 0 0
-
RFS 2691 IDLE UNKNOWN 2600 845781194 N/A 0 0 0 0 0 0 0 0
-
RFS 2693 IDLE UNKNOWN 2604 845781194 N/A 0 0 0 0 0 0 0 0
-
RFS 2687 IDLE UNKNOWN 2606 845781194 N/A 0 0 0 0 0 0 0 0
- RFS 2689 IDLE LGWR 2608 845781194 3 881314188 1 42 32 1 0 0 0
這個程式不用像MRP程式得用命令啟動,會自己啟動的~
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/29990276/viewspace-1695955/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- standby databaseDatabase
- Convert a Physical Standby Database into a Snapshot Standby DatabaseDatabase
- standby database to primary database.Database
- Physical Standby Database 切換到 Snapshot Standby DatabaseDatabase
- Standby Database ---09Database
- rfs (PID:146054): Database mount ID mismatch案例Database
- Create RAC Standby Database for RAC Primary DatabaseDatabase
- Rman backup standby databaseDatabase
- Standby Database for reportDatabase
- Standby Database的工作原理Database
- 建立 Logical Standby DatabaseDatabase
- manage logical standby databaseDatabase
- How a Standby Database Is Mounted (295)Database
- Oracle DG 出現 RFS[6]: No standby redo logfiles created for thread 1Oraclethread
- Setup Standby Database on One PC(轉)Database
- Oracle DG Standby Database型別OracleDatabase型別
- Oracle DG建立Physical Standby DatabaseOracleDatabase
- Creating a Physical Standby DatabaseDatabase
- rman 建 Standby Database 筆記Database筆記
- (轉)Standby Database的工作原理Database
- 監控Logical standby databaseDatabase
- 11g 新特性—— Active Database Duplication for A standby databaseDatabase
- RFS 理解
- Performing a Failover to a Physical Standby DatabaseORMAIDatabase
- Oracle DG建立Logical Standby DatabaseOracleDatabase
- Data Guard - Snapshot Standby Database配置Database
- 物理standby database的日常維護Database
- PROTECTION_MODE is UNPROTECTED at standby database 分析Database
- standby database -- Compatibility and Operational RequirementsDatabaseUIREM
- Oracle10G Physical Standby Database setupOracleDatabase
- Logical Standby Database的配置步驟.Database
- Performing a Switchover to a Physical Standby Database and failoverORMDatabaseAI
- Oracle DataGuard Standby database ID mismatch錯誤OracleDatabase
- 使用rman建立standby database的過程Database
- Oracle 12.2 使用Database Link優化Standby Database WorkloadOracleDatabase優化
- 11g rman新特性 duplicate target database for standby from active databaseDatabase
- Restore standby database controlfile in ASM (refreshing standby controlfile)RESTDatabaseASM
- Oracle 11g Data Guard 使用 duplicate from active database 建立 standby databaseOracleDatabase