-
编辑 删除
Data Guard出现gap sequence修复
<p><strong>一、出现gap sequence现象</strong><br />备库</p><div><div id="highlighter_406805" class="syntaxhighlighter nogutter bash"><table class="ke-zeroborder" border="0" cellpadding="0" cellspacing="0"><tbody><tr><td class="code"><div class="container"><div...
-
编辑 删除
ORACLE 锁表的解决方法及查找引起锁表SQL语句[转]
1. ORACLE中查看当前系统中锁表情况 select * from v$locked_object 可以通过查询v$locked_object拿到sid和objectid，然后用sid和v$session链表查询是哪里锁的表，用v$session中的objectid字段和dba_o...
-
编辑 删除
【DataGuard】Oracle 11g物理Active Data Guard实时查询（Real-time query）特性
在Oracle 11g以前版本中的的Data Guard物理备用数据库，可以以只读的方式打开数据库，但此时Media Recovery利用日志进行数据同步的过程就停止了，如果物理备用数据库处于恢复的过程中数据库就不能打开...
-
编辑 删除
Data Guard之Snapshot Standby数据库功能[转]
Oracle 11g的Data Guard不仅仅带给我们的是Active Data Guard实时查询特性，参见文章《【DataGuard】Oracle 11g物理Active Data Guard实时查询（Real-time query）特性...
-
编辑 删除
ANYDATA Queues and User Messages
Streams enables messaging with queues of type ANYDATA. These queues can stage user messages whose payloads are of ANYDATA type. An ANYDATA payload can be a wrapper for payloads of different datatypes....
-
编辑 删除
Downstream Capture
Figure 2-2 Real-Time Downstream CaptureDescription of "Figure 2-2 Real-Time Downstream Capture" Figure 2-3 Archived-Log Downstream CaptureDescription of "Figure 2-3 Archived-Log...
-
编辑 删除
Local Capture and Downstream Capture
The Source Database Performs All Change Capture ActionsIf you configure local capture, then the following actions are performed at the source database:The DBMS_CAPTURE_ADM.BUILD procedure is run ...
-
编辑 删除
LOG_ARCHIVE_DEST_n Parameter Attributes
AFFIRM and NOAFFIRMControls whether redo transport services use synchronous or asynchronous I/O to write redo data to diskAFFIRM—specifies that all disk I/O to archived redo log files and standby...
-
编辑 删除
Setting the Data Protection Mode of a Data Guard Configuration
Step 1 Configure the LOG_ARCHIVE_DEST_n parameters on the primary database.The following example shows how to configure the maximum availability mode:SQL> ALTER SYSTEM SET LOG_ARCHIV...
