dg standby lgwr

主庫一直在線：

主庫：
 alter database force logging;
 ALTER SYSTEM SET LOG_ARCHIVE_CONFIG='DG_CONFIG=(dt2as,dt2asdg)';
 alter system set log_archive_dest_1='LOCATION=/data/dt2as/arch VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=dt2as';
 alter system set  log_archive_dest_2='SERVICE=dt2asdg LGWR SYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=dt2asdg';
 ALTER SYSTEM SET FAL_CLIENT = dt2as sid='dt2as';
 ALTER SYSTEM SET FAL_SERVER = dt2asdg;

DG的pile可以用主庫的pfile然後再進行相應的修改；
 *.db_unique_name='dt2asdg'
 *.fal_client='dt2asdg'
 *.fal_server='dt2as'
 *.log_archive_config='DG_CONFIG=(dt2as,dt2asdg)'
 *.log_archive_dest_1='LOCATION=/data/dt2as1/arch VALID_FOR=(ALL_LOGFILES,ALL_ROLES)  DB_UNIQUE_NAME=dt2asdg'
 *.log_archive_dest_2='SERVICE=dt2as LGWR SYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)  DB_UNIQUE_NAME=dt2as'

主庫做一次全庫備份：
 $mkdir /data/rman_backup
 $chmod 770 /data/rman_backup
 $rman target /
 Rman> backup database format='/data/rman_backup/%U_%s.bak';
 Rman> sql"alter system archive log current";
 Rman>backup filesperset 10 archivelog all format='/data/backup/%U_%s.bak';(當刪除了以前的歸檔，該動作可能報錯，所以執行 crosscheck archivelog all;
                     crosscheck backupset;)
 備份完主庫及當后，再生成備庫的controlfile
 alter database create standby controlfile as '/data/rman_backup/dgcon.ctl'

配置網絡連接
 主庫 tnsname.ora
 # tnsnames.ora Network Configuration File: /u01/product/oracle/network/admin/tnsnames.ora
 # Generated by Oracle configuration tools.

 DT2AS =
   (DESCRIPTION =
     (ADDRESS = (PROTOCOL = TCP)(HOST = 10.203.98.204)(PORT = 1526))
     (CONNECT_DATA =
       (SERVER = DEDICATED)
       (SERVICE_NAME = dt2as)
     )
   )

 LISTENER_DT2AS =
   (ADDRESS = (PROTOCOL = TCP)(HOST = 10.203.98.204)(PORT = 1526))

 dt2asdg =
   (DESCRIPTION =
     (ADDRESS = (PROTOCOL = TCP)(HOST = 10.203.98.205)(PORT = 1526))
     (CONNECT_DATA =
       (SERVER = DEDICATED)
       (SERVICE_NAME = dt2asdg)
     )
   )
 備庫的listener.ora
 # listener.ora Network Configuration File: /u01/product/oracle/network/admin/listener.ora
 # Generated by Oracle configuration tools.

 LISTENER =
   (DESCRIPTION_LIST =
     (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.203.98.205)(PORT = 1526))
     )
   )

 ADR_BASE_LISTENER = /u01/product
 備庫的tnsnames.ora

 DT2AS =
   (DESCRIPTION =
     (ADDRESS = (PROTOCOL = TCP)(HOST = 10.203.98.204)(PORT = 1526))
     (CONNECT_DATA =
       (SERVER = DEDICATED)
       (SERVICE_NAME = dt2as)
     )
   )
 
 dt2asdg =
   (DESCRIPTION =
     (ADDRESS = (PROTOCOL = TCP)(HOST = 10.203.98.205)(PORT = 1526))
     (CONNECT_DATA =
       (SERVER = DEDICATED)
       (SERVICE_NAME = dt2asdg)
     )
   )
 LISTENER_DT2AS =
   (ADDRESS = (PROTOCOL = TCP)(HOST = 10.203.98.205)(PORT = 1526))
不管是10g還是11g的---》開啟備庫的時候，都要做以下工作
 備庫  11g
 lsnrctl start
 mkdir /u01/product/flash_recovery_area
 mkdir /u01/product/admin
 mkdir /u01/product/diag
  cd admin
  mkdir dt2as
  mkdir {adump,dpdump,pfile}
  cd diag           service dbname
  mkdir /diag/rdbms     ----&gt最後自動生成/diag/rdbms/dt2asdg/dt2as/
 mkdir /data/dt2as/arch
 cp /data/rman_backup/dgcon.ctl /data/dt2as/control01.ctl /data/dt2as/control02.ctl .....
 sqlplus / as sysdba
 startup nomount pfile='/u01/product/oracle/dbs/initdt2as.ora'
 alter database mount standby database;
              節點一
 SQL>ALTER DATABASE ADD STANDBY LOGFILE THREAD 1 group 111 ('/data/dt2as/dgredo111a.log','/data/dt2as/dgredo111b.log') SIZE 50M;
 SQL>ALTER DATABASE ADD STANDBY LOGFILE THREAD 1 group 112 ('/data/dt2as/dgredo112a.log','/data/dt2as/dgredo112b.log') SIZE 50M;
 SQL>ALTER DATABASE ADD STANDBY LOGFILE THREAD 1 group 113 ('/data/dt2as/dgredo113a.log','/data/dt2as/dgredo113b.log') SIZE 50M;
 SQL>ALTER DATABASE ADD STANDBY LOGFILE THREAD 1 group 114 ('/data/dt2as/dgredo114a.log','/data/dt2as/dgredo114b.log') SIZE 50M;
 SQL>ALTER DATABASE ADD STANDBY LOGFILE THREAD 1 group 115 ('/data/dt2as/dgredo115a.log','/data/dt2as/dgredo115b.log') SIZE 50M;
 SQL>ALTER DATABASE ADD STANDBY LOGFILE THREAD 1 group 116 ('/data/dt2as/dgredo116a.log','/data/dt2as/dgredo116b.log') SIZE 50M;
 $rman target /
 Rman> restore database;
 Rman> restore archivelog all;
 $ sqlplus / as sysdba
 SQL > atler database recover managed standby database disconnect from session;
 SQL > alter database recover managed standby database cancel;
為了備庫以後切換能夠正常工作 需要增加tempfile
 alter database tempfile '/data/dt2as/temp01.dbf' offline;
 alter database tempfile '/data/dt2as/temp02.dbf' drop;
 alter tablespace temp add tempfile '/data/dt2as/temp01.dbf' size 2000m reuse;
 alter tablespace temp add tempfile '/data/dt2as/temp01.dbf' size 2000m reuse;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/25072296/viewspace-697047/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/25072296/viewspace-697047/