ORACLE DG之備庫角色

<div style="font-family:微軟雅黑;font-size:14px;line-height:21px;white-space:normal;widows:auto;background-color:#FFFFFF;"> <span style="color:#222222;font-family:Tahoma, sans-serif;font-size:small;"><b style="background-color:inherit;">The types of standby databases are as follows:</b></span><br style="background-color:inherit;" /> </div> <div style="font-family:微軟雅黑;font-size:14px;line-height:21px;white-space:normal;widows:auto;background-color:#FFFFFF;"> <ul style="margin-top:0px;margin-bottom:0px;background-color:inherit;"> <li style="font-size:small;font-family:Tahoma, sans-serif;color:#222222;"> <p style="background-color:inherit;"> <span style="background-color:inherit;font-weight:bold;">hysical standby database //物理備庫 ----只讀</span> </p> <p style="background-color:inherit;"> Provides a physically identical copy of the primary database, with&nbsp;on disk database structures that are identical to the primary database on a block-for-block basis. The database schema, including indexes, are the same. A physical standby database is kept synchronized with the primary database, through Redo Apply, which recovers the redo data received from the primary database and applies the redo to the physical standby database. </p> <p style="background-color:inherit;"> As of Oracle Database 11<span style="background-color:inherit;font-style:italic;">g</span>&nbsp;release 1 (11.1), a physical standby database can receive and apply redo while it is open for read-only access. A physical standby database can therefore be used concurrently for data protection and reporting. </p> <p style="background-color:inherit;"> <span data-aligning="#tran_0,#src_0" style="color:#666666;font-family:Tahoma, Arial;font-size:12px;text-align:justify;background-color:rgba(255, 255, 255, 0.8);">提供了一個物理上相同的主資料庫的副本,與磁碟上資料庫結構與主資料庫block-for-block基礎上。</span><span data-aligning="#tran_1,#src_1" style="color:#666666;font-family:Tahoma, Arial;font-size:12px;text-align:justify;background-color:rgba(255, 255, 255, 0.8);">資料庫模式,包括索引,是相同的。</span><span data-aligning="#tran_2,#src_2" style="color:#666666;font-family:Tahoma, Arial;font-size:12px;text-align:justify;background-color:rgba(255, 255, 255, 0.8);">物理備用資料庫與主資料庫保持同步,透過重做,重做資料恢復了從主資料庫和應用物理備用資料庫的重做。</span><br style="color:#434343;font-family:Tahoma, Arial;font-size:12px;text-align:justify;background-color:rgba(255, 255, 255, 0.8);" /> <span data-aligning="#tran_3,#src_3" style="color:#666666;font-family:Tahoma, Arial;font-size:12px;text-align:justify;background-color:#EEEEEE;">Oracle資料庫11g的版本1(11.1),物理備用資料庫可以接收和重做時它是開放申請</span><span data-aligning="#tran_3,#src_3" style="color:#666666;font-family:Tahoma, Arial;font-size:12px;text-align:justify;background-color:#EEEEEE;"><b style="background-color:inherit;">只讀訪問</b></span><span data-aligning="#tran_3,#src_3" style="color:#666666;font-family:Tahoma, Arial;font-size:12px;text-align:justify;background-color:#EEEEEE;">。</span><span data-aligning="#tran_4,#src_4" style="color:#666666;font-family:Tahoma, Arial;font-size:12px;text-align:justify;background-color:rgba(255, 255, 255, 0.8);"><b style="background-color:inherit;">物理備用資料庫因此可以同時用於資料保護和報告。</b></span> </p> <p style="background-color:inherit;"> <br /> </p> </li> <li style="font-size:small;font-family:Tahoma, sans-serif;color:#222222;"> <p style="background-color:inherit;"> <span style="background-color:inherit;font-weight:bold;">Logical standby database //邏輯備庫------可sql查詢和檢視統計報告、升級資料庫和補丁集</span> </p> <p style="background-color:inherit;"> Contains the same logical information as the production database, although the physical organization and structure of the data can be different. The logical standby database is kept synchronized with the primary database through&nbsp;<span style="background-color:inherit;font-weight:bold;">SQL Apply</span>, which transforms the data in the redo received from the primary database into&nbsp;SQL statements and then executes the SQL statements on the standby database. </p> <p style="background-color:inherit;"> A logical standby database can be used for other business purposes in addition to disaster recovery requirements. This allows users to access a logical standby database for queries and&nbsp;reporting purposes at any time. Also, using a logical standby database, you can upgrade Oracle Database software and patch sets with almost no downtime. Thus, a logical standby database can be used concurrently for data protection, reporting, and database upgrades. </p> <p style="background-color:inherit;"> <span data-aligning="#tran_0,#src_0" style="color:#666666;font-family:Tahoma, Arial;font-size:12px;text-align:justify;background-color:rgba(255, 255, 255, 0.8);">包含相同的邏輯資訊生產資料庫,儘管資料的物理組織和結構可以是不同的。</span><span data-aligning="#tran_1,#src_1" style="color:#666666;font-family:Tahoma, Arial;font-size:12px;text-align:justify;background-color:rgba(255, 255, 255, 0.8);">邏輯備用資料庫與主資料庫透過SQL應用保持同步,從而使資料重做了從主資料庫為SQL語句然後在備用資料庫上執行SQL語句。</span><br style="color:#434343;font-family:Tahoma, Arial;font-size:12px;text-align:justify;background-color:rgba(255, 255, 255, 0.8);" /> <span data-aligning="#tran_2,#src_2" style="color:#666666;font-family:Tahoma, Arial;font-size:12px;text-align:justify;background-color:rgba(255, 255, 255, 0.8);">一個邏輯備用資料庫可用於其他商業用途除了災難恢復需求。</span><span data-aligning="#tran_3,#src_3" style="color:#666666;font-family:Tahoma, Arial;font-size:12px;text-align:justify;background-color:rgba(255, 255, 255, 0.8);"><b style="background-color:inherit;">這</b></span><span data-aligning="#tran_3,#src_3" style="color:#666666;font-family:Tahoma, Arial;font-size:12px;text-align:justify;background-color:rgba(255, 255, 255, 0.8);"><b style="background-color:inherit;">允許使用者訪問一個邏輯備用資料庫來進行查詢和報告</b></span><span data-aligning="#tran_3,#src_3" style="color:#666666;font-family:Tahoma, Arial;font-size:12px;text-align:justify;background-color:rgba(255, 255, 255, 0.8);">。</span><span data-aligning="#tran_4,#src_4" style="color:#666666;font-family:Tahoma, Arial;font-size:12px;text-align:justify;background-color:rgba(255, 255, 255, 0.8);">此外,使用一個邏輯備用資料庫,您可以升級Oracle資料庫軟體和補丁集幾乎沒有停機時間。</span><span data-aligning="#tran_5,#src_5" style="color:#666666;font-family:Tahoma, Arial;font-size:12px;text-align:justify;background-color:rgba(255, 255, 255, 0.8);">因此,可以</span><span data-aligning="#tran_5,#src_5" style="color:#666666;font-family:Tahoma, Arial;font-size:12px;text-align:justify;background-color:rgba(255, 255, 255, 0.8);"><b style="background-color:inherit;">使用一個邏輯備用資料庫併發資料保護,報告和資料庫升級。</b></span> </p> </li> <li style="font-size:small;font-family:Tahoma, sans-serif;color:#222222;"> <p style="background-color:inherit;"> <span style="background-color:inherit;font-weight:bold;">Snapshot Standby Database //快照備庫----read write</span><b style="line-height:1.5;font-family:微軟雅黑;font-size:14px;"><span style="background-color:inherit;color:#222222;font-family:'Tahoma, sans-serif';font-size:x-small;">完全可更新備用資料庫</span></b> </p> </li> </ul> </div> <div style="font-family:微軟雅黑;font-size:14px;line-height:21px;white-space:normal;widows:auto;background-color:#FFFFFF;"> <ul style="margin-top:0px;margin-bottom:0px;color:#222222;font-family:Tahoma, sans-serif;font-size:small;"> <li style="background-color:inherit;"> <p style="background-color:inherit;"> <span style="background-color:inherit;font-weight:bold;"><b style="color:#666666;font-family:Tahoma, Arial;font-size:12px;text-align:justify;background-color:rgba(255, 255, 255, 0.8);"></b></span> </p> <p style="background-color:inherit;"> A snapshot standby database is a fully updatable standby database. </p> <p style="background-color:inherit;"> Like a physical or logical standby database, a snapshot standby database receives and archives redo data from a primary database. Unlike a physical or logical standby database, a snapshot standby database does not apply the redo data that it receives. The redo data received by a snapshot standby database is not applied until the snapshot standby is converted back into a physical standby database, after first discarding any local updates made to the snapshot standby database. </p> <p style="background-color:inherit;"> A snapshot standby database is best used in scenarios that require a temporary, updatable snapshot of a physical standby database. Note that because redo data received by a snapshot standby database is not applied until it is converted back into a physical standby, the time needed to recover from a primary database failure is directly proportional to the amount of redo data that needs to be applied. </p> <p style="background-color:inherit;"> <span data-aligning="#tran_0,#src_0" style="color:#666666;font-family:Tahoma, Arial;font-size:12px;text-align:justify;background-color:rgba(255, 255, 255, 0.8);"><b style="background-color:inherit;">備用資料庫快照是一個完全可更新備用資料庫。</b></span><br style="color:#434343;font-family:Tahoma, Arial;font-size:12px;text-align:justify;background-color:rgba(255, 255, 255, 0.8);" /> <span data-aligning="#tran_1,#src_1" style="color:#666666;font-family:Tahoma, Arial;font-size:12px;text-align:justify;background-color:rgba(255, 255, 255, 0.8);">就像一個物理或邏輯備用資料庫,備用資料庫快照從主資料庫和檔案接收重做資料。</span><span data-aligning="#tran_2,#src_2" style="color:#666666;font-family:Tahoma, Arial;font-size:12px;text-align:justify;background-color:rgba(255, 255, 255, 0.8);">不像物理或邏輯備用資料庫,備用資料庫快照不適用它收到的重做資料。</span><span data-aligning="#tran_2,#src_2" style="color:#666666;font-family:Tahoma, Arial;font-size:12px;text-align:justify;background-color:rgba(255, 255, 255, 0.8);"><b style="background-color:inherit;">不想對快照備份資料庫進行本地更新（指dml）後，</b></span><span data-aligning="#tran_2,#src_2" style="color:#666666;font-family:Tahoma, Arial;font-size:12px;text-align:justify;background-color:rgba(255, 255, 255, 0.8);"><b style="background-color:inherit;">直到</b></span><span data-aligning="#tran_3,#src_3" style="color:#666666;font-family:Tahoma, Arial;font-size:12px;text-align:justify;background-color:rgba(255, 255, 255, 0.8);"><b style="background-color:inherit;">重做資料接收到一個備用資料庫快照被應用後，快照備庫才轉換為物理備用資料庫</b></span><span data-aligning="#tran_3,#src_3" style="color:#666666;font-family:Tahoma, Arial;font-size:12px;text-align:justify;background-color:rgba(255, 255, 255, 0.8);">,</span><br style="color:#434343;font-family:Tahoma, Arial;font-size:12px;text-align:justify;background-color:rgba(255, 255, 255, 0.8);" /> <span data-aligning="#tran_4,#src_4" style="color:#666666;font-family:Tahoma, Arial;font-size:12px;text-align:justify;background-color:rgba(255, 255, 255, 0.8);">備用資料庫快照最好需要一個臨時的場景中使用,可更新快照的一個物理備用資料庫。</span><span data-aligning="#tran_5,#src_5" style="color:#666666;font-family:Tahoma, Arial;font-size:12px;text-align:justify;background-color:rgba(255, 255, 255, 0.8);">注意,因為重做資料接收到一個備用資料庫快照不是應用,直到它被轉換回一個物理備用,從主資料庫故障恢復所需的時間成正比的重做資料量,需要應用。</span> </p> </li> </ul> </div>