RAC to single instance Data Guard Physical Standby
DataGuard Broker Yapılandırması
Primary veritabanı için - her nodda;
node 1’de
|
1 2 3 |
alter system set dg_broker_config_file1='+DATA/MX/mx1.dat' scope=both sid='*'; alter system set dg_broker_config_file2='+DATA/MX/mx2.dat' scope=both sid='*'; alter system set dg_broker_start=true scope=both sid='*'; |
Standby veritabanı için ise her nodda;
|
1 2 3 |
alter system set dg_broker_config_file1='+DATA/STDMX/stdmx1.dat' scope=both; alter system set dg_broker_config_file2='+DATA/STDMX/stdmx2.dat' scope=both; alter system set dg_broker_start=true scope=both sid='*'; |
|
1 2 3 4 5 6 7 8 9 10 |
dgmgrl connect / CREATE CONFIGURATION 'dg_broker' AS PRIMARY DATABASE IS 'mx' CONNECT IDENTIFIER IS mx; ADD DATABASE 'stdmx' AS CONNECT IDENTIFIER IS stdmx; EDIT DATABASE 'mx' SET PROPERTY FastStartFailoverTarget='stdmx'; EDIT DATABASE 'stdmx' SET PROPERTY FastStartFailoverTarget='mx'; EDIT DATABASE "mx" SET PROPERTY 'LogXptMode'='SYNC'; EDIT DATABASE "stdmx" SET PROPERTY 'LogXptMode'='SYNC'; EDIT DATABASE 'mx' SET PROPERTY NetTimeout=180 ; EDIT DATABASE 'stdmx' SET PROPERTY NetTimeout=180 ; |
11.2.0.2.0 sürümündeki bug dan dolayi NetTimeout=180 yapildi
Bu ikisi dikkatli kullanilmali protection modelarin durumuna gore db yi kapatabiliyor..
|
1 2 |
enable database 'stdmx' ; enable configuration ; |
|
1 |
enable fast_start failover; |
Bilgi
|
1 2 3 4 5 6 7 8 |
select FS_FAILOVER_OBSERVER_HOST from v$database; show configuration ; show configuration verbose; SHOW DATABASE VERBOSE 'mx' ; SHOW DATABASE VERBOSE 'stdmx' ; show instance verbose stdmx; show instance verbose mx1; show instance verbose mx2; |
|
1 2 |
DISABLE FAST_START FAILOVER force ; REMOVE CONFIGURATION; |
Log
|
1 2 |
/u01/app/oracle/diag/rdbms/mx/mx1/trace/drcmx1.log SwitchOVER |
|
1 |
switchover to 'stdmx'; (o andaki standBY DB nin ismi yazilir.) |
Not ; switCHOVER dan sonra dgmgrl show configuration da bazi hatalar gorunebiliyor ama bir sure sonra kendini topluyor ve hatalar gidiyor. Iki tarafa da basarili bir sekilde switchoVER gerceklesti.
*****************************************************************************************************
GAP resolutıon
|
1 |
SELECT * FROM V$ARCHIVE_GAP; |
|
1 |
SELECT STATUS, GAP_STATUS FROM V$ARCHIVE_DEST_STATUS WHERE DEST_ID = 2; |
|
1 2 |
SELECT NAME FROM V$ARCHIVED_LOG WHERE THREAD#=1 AND - DEST_ID=1 AND SEQUENCE# BETWEEN 7 AND 10; |
|
1 |
ALTER DATABASE REGISTER LOGFILE '/physical_standby1/thread1_dest/arcr_1_7.arc'; |
|
1 |
SELECT * FROM V$ARCHIVE_GAP; |
ArchiveLOG ların ASM’ye alınıp kayıt edilmesi
|
1 2 3 |
catalog archivelog '/cluster/home/oracle/o1_mf_1_245440_8dp02lsr_.arc'; copy archivelog '/tmp/thread_1_seq_105.345.813673069' to '+fra'; ALTER DATABASE REGISTER LOGFILE '+FRA/stdmx/archivelog/2013_04_26/thread_1_seq_105.317.813752707' ; |
Kategori seçin...