Oracle 10GR2 DataGuard ʵÀý

server A: 10.85.10.44  SID=orcl ­
target server B: 10.85.10.43 ­
oracle version:10.2.0.1 ­
OS platform : windows XP ­
­
Data GuardĬÈÏÊÇmaximize performance£¬ ¿ÉÒÔÓÃÒÔÏÂÓï¾äÀ´½øÐÐģʽ¼äµÄÇл»¡£ ­
ALTER DATABASE SET STANDBY DATABASE TO MAXIMIZE {PROTECTION | AVAILABILITY | PERFORMANCE}; ­
ÐÞ¸ÄÖ÷Êý¾Ý¿â±£»¤Ä£Ê½ÐèÒªÖØÆôÊý¾Ý¿â²ÅÄÜÉúЧ¡£ ­
select protection_mode,protection_level from v$database; ­
­
PrimaryÉèÖ㺠­
­
1. ÉèÖÃÖ÷Êý¾Ý¿âΪforce logging ģʽ ­
SQL>sqlplus "/as sysdba" ­
SQL>alter database force logging; ­
2. ÉèÖÃÖ÷Êý¾Ý¿âΪ¹éµµÄ£Ê½ ­
SQL> archive log list ­
SQL> shutdown immediate ­
SQL> startup mount ­
SQL> alter database archivelog; ­
SQL> archive log list ­
3. Ìí¼Ó"±¸ÓÃÁª»úÈÕÖ¾Îļþ" ­
ÏȲ鿴ÈÕÖ¾ÎļþλÖ㺠­
SQL>select * from v$logfile; ­
ÔÚÌí¼Ó£º ­
SQL> alter database add standby logfile group 4 ('D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\redo04.log') size 50m; ­
SQL> alter database add standby logfile group 5 ('D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\redo05.log') size 50m; ­
SQL> alter database add standby logfile group 6 ('D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\redo06.log') size 50m; ­
SQL> alter database add standby logfile group 7 ('D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\redo07.log') size 50m; ­
­
4. ´´½¨Ö÷¿âµÄ³õʼ»¯²ÎÊý¸ø±¸¿âÓà ­
SQL>Create pfile from spfile; ­
²úÉúµÄÎļþÃûΪinitorcl.ora ´æ·ÅĿ¼ĬÈÏ·ÅÔÚ$ORACLE_HOME/databaseÏ ­
­
5. ÔÚÖ÷¿â´´½¨±¸¿âµÄ¿ØÖÆÎļþ ºÍÃÜÂëÎļþ ­
SQL>Alter database create standby controlfile as 'D:\oracle\product\10.2.0\control01.ctl'; ­
D:>orapwd file=D:\PWDorcl.ora password=admin entries=5; ­
­
6.  ÔÚÖ÷¿â´´½¨¼àÌýºÍÅäÖÃtnsnams.ora ­
­
listener.oraÅäÖÃÈçÏÂ: ­
# listener.ora Network Configuration File: D:\oracle\product\10.2.0\db_1\network\admin\listener.ora­
# Generat