Oracle 10G DataGuard

http://hi.baidu.com/firefly5002/blog/item/5b5719fcb5bd3e1d08244d11.html
Oracle 10G DataGuard
server A: 10.85.10.44 SID=mesdb
target server B: 10.85.10.43
oracle version:10.2.0.1
OS platform : windows 2003
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;
ȱʡÇé¿öÏ£¬winÏ¿ÚÁîÎļþµÄ¸ñʽÊÇpwdsid.ora£¬unixϵĸñʽÊÇorapwSID(´óСдÃô¸Ð£©
6. ÔÚÖ÷¿â´´½¨¼àÌýºÍÅäÖÃtnsnams.ora
listener.oraÅäÖÃÈçÏÂ:
# listener.ora Network Configuration File: D:\oracle\product\10.2.0\db_1
\network\admin\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =