配置 Oracle 10g RAC primary + RAC logical standby
上面的物理standby叢集做好以後,只需要轉換一下就可以了,rac的logical standby和單例項的轉換有一些小區別,轉換之前rac physical standby需要關閉除了apply節點以外的節點
prdb:
ALTER DATABASE SET STANDBY DATABASE TO MAXIMIZE PERFORMANCE;
lstdb:
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;prdb:
EXECUTE DBMS_LOGSTDBY.BUILD;
ALTER SYSTEM ARCHIVE LOG CURRENT;
lstdb:
ALTER SYSTEM SET CLUSTER_DATABASE=FALSE SCOPE=SPFILE;
SHUTDOWN ABORT;
STARTUP MOUNT EXCLUSIVE;
ALTER DATABASE RECOVER TO LOGICAL STANDBY lstdb;
ALTER SYSTEM SET CLUSTER_DATABASE=TRUE SCOPE=SPFILE;
STARTUP MOUNT FORCE;
ALTER DATABASE OPEN RESETLOGS;
ALTER DATABASE START LOGICAL STANDBY APPLY;
這樣logical standby rac就建立好了,可以新增standby redo進行實時的apply:
ALTER DATABASE ADD STANDBY LOGFILE THREAD 1 GROUP 5 SIZE 50M,GROUP 6 SIZE 50M,GROUP 7 SIZE 50M;
ALTER DATABASE ADD STANDBY LOGFILE THREAD 2 GROUP 8 SIZE 50M,GROUP 9 SIZE 50M,GROUP 10 SIZE 50M;
下面是轉換後的logical standby的日誌,其實除了db_name以外和pst.ora沒有變化
[oracle@jy1 ~]$ more lst.ora
lstdb2.__db_cache_size=1929379840
lstdb1.__db_cache_size=1862270976
lstdb2.__java_pool_size=16777216
lstdb1.__java_pool_size=16777216
lstdb2.__large_pool_size=16777216
lstdb1.__large_pool_size=16777216
lstdb2.__shared_pool_size=503316480
lstdb1.__shared_pool_size=570425344
lstdb2.__streams_pool_size=0
lstdb1.__streams_pool_size=0
*.audit_file_dest='/u01/app/oracle/admin/lstdb/adump'
*.background_dump_dest='/u01/app/oracle/admin/lstdb/bdump'
*.cluster_database_instances=2
*.cluster_database=TRUE
*.compatible='10.2.0.3.0'
*.control_files='+DATA/lstdb/controlfile/current.652.676829111'#Restore Controlfile
*.core_dump_dest='/u01/app/oracle/admin/lstdb/cdump'
*.db_block_size=8192
*.db_create_file_dest='+DATA'
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_file_name_convert='+data/prdb','+data/lstdb'
*.db_name='LSTDB'#db_name
*.db_unique_name='lstdb'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=lstdbXDB)'
*.fal_client='lstdb'
*.fal_server='prdb'
lstdb2.instance_number=2
lstdb1.instance_number=1
*.job_queue_processes=10
*.log_archive_dest_1='location=+data/lstdb/arch valid_for=(all_logfiles,all_roles) db_unique_name=lstdb'
*.log_archive_dest_2='service=prdb valid_for=(online_logfiles,primary_role) db_unique_name=lstdb'
*.log_file_name_convert='+data/prdb','+data/lstdb'
*.open_cursors=300
*.pga_aggregate_target=825229312
*.processes=150
*.remote_listener='LISTENERS_LSTDB'
*.remote_login_passwordfile='exclusive'
*.service_names='LSTDB'
*.sga_target=2476736512
*.standby_archive_dest='location=+data/lstdb/arch'
*.standby_file_management='AUTO'
lstdb2.thread=2
lstdb1.thread=1
*.undo_management='AUTO'
lstdb2.undo_tablespace='UNDOTBS2'
lstdb1.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/u01/app/oracle/admin/lstdb/udump'
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/79686/viewspace-1016398/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 配置 Oracle 10g RAC primary + RAC physical standby dataguardOracle 10g
- Create RAC Standby Database for RAC Primary DatabaseDatabase
- Oracle10g RAC配置standbyOracle
- 【RAC,DATAGUARD】Creating a physical standby from ASM (RAC ) primary之四ASM
- 【RAC】Creating a filesystem physical standby from ASM (RAC ) primary之三ASM
- 【RAC】Creating a filesystem physical standby from ASM (RAC ) primary 之二ASM
- 【RAC】Creating a filesystem physical standby from ASM (RAC ) primary之一ASM
- Create Logical Standby For Oracle 10GOracle 10g
- RAC環境LOGICAL STANDBY的SWITCHOVER切換
- oracle10g R2 logical standby switchover to primaryOracle
- RAC環境LOGICAL STANDBY的FAILOVER切換AI
- oracle 10g logical standby db creationOracle 10g
- AIX上配置ORACLE 10g RAC EMAIOracle 10g
- 建立三節點的10g RAC的Logical Standby, 擔心同步的及時性
- Oracle 10g RAC之配置時間同步Oracle 10g
- 【RAC】Oracle 10g RAC 重建控制檔案Oracle 10g
- Oracle 10g RAC客戶端配置監聽Oracle 10g客戶端
- Oracle 10g RAC NFSOracle 10gNFS
- Oracle 10g RAC TAFOracle 10g
- Oracle10g_RAC_Standby_MAA 3.0Oracle
- oracle 10g rac ggs關鍵引數配置Oracle 10g
- oracle實驗記錄 (oracle 10G dataguard(11)建立logical standby)Oracle
- oracle 10g rac升級Oracle 10g
- oracle 10g 之RAC 搭建Oracle 10g
- Oracle 9i R2 配置 Logical StandbyOracle
- 邏輯 rac standby和物理 rac standby的switchover 和 failoverAI
- Oracle 10g rac升級(10.2.0.1 Rac到10.2.0.4)Oracle 10g
- Oracle 10g RAC故障處理Oracle 10g
- Oracle 10g RAC TAF介紹Oracle 10g
- oracle 10g rac 解除安裝Oracle 10g
- oracle 10g rac問題(一)Oracle 10g
- Oracle 10g RAC中的DRMOracle 10g
- oracle 10g RAC簡單管理Oracle 10g
- 單例項Primary快速搭建Standby RAC參考手冊(19.16 ADG)單例
- unix/linux環境中Oracle 10G RAC OFF和RAC ONLinuxOracle 10g
- Oracle DG建立Logical Standby DatabaseOracleDatabase
- Logical Standby Database的配置步驟.Database
- Oracle RAC+DG 調整redo/standby log fileOracle