本文共 3681 字，大约阅读时间需要 12 分钟。
????Primary????Data Guard???
1.1??Data Guard?
SQL> $ sqlplus '/as sysdba' SQL> select * from v$option where parameter = 'Managed Standby';
2.2??archive???
SQL> archive log list SQL> startup mount SQL> alter database archivelog;
2.3??force logging?
SQL> alter database force logging;
2.4??Redo????
SQL> alter database add standby logfile group 4 ('/u01/app/oracle/oradata/ora11g/stdby_redo04.log') size 50m; SQL> alter database add standby logfile group 5 ('/u01/app/oracle/oradata/ora11g/stdby_redo05.log') size 50m; SQL> alter database add standby logfile group 6 ('/u01/app/oracle/oradata/ora11g/stdby_redo06.log') size 50m; SQL> alter database add standby logfile group 7 ('/u01/app/oracle/oradata/ora11g/stdby_redo07.log') size 50m;
2.5??Redo????
standby redolog (online redolog + 1) * (1) RAC 2
2.1??Standby?????
SQL> alter database create standby controlfile as '/u01/standby_ctl01.ctl';
2.2??listener.ora?
Listener.ora?????
SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = ora11g)(SID_NAME = ora11g)(ORACLE_HOME = /home/db/oracle/product/11.2.0/dbhome_1)))
LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = DG-Primary)(PORT = 1521))))
ADR_BASE_LISTENER = /u01/app/oracle
tnsnames.ora???
ORA11G_PRIMARY = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.122)(PORT = 1521))(CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = ora11g)))
ORA11G_STANDBY = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.123)(PORT = 1521))(CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = ora11g)))
3.1???????
mkdir -p $ORACLE_BASE/oradata/ora11g mkdir -p $ORACLE_BASE/admin/ora11g mkdir -p $ORACLE_BASE/admin/ora11g/adump mkdir -p $ORACLE_BASE/admin/ora11g/bdump mkdir -p $ORACLE_BASE/admin/ora11g/cdump mkdir -p $ORACLE_BASE/admin/ora11g/dpdump mkdir -p $ORACLE_BASE/admin/ora11g/pfile mkdir -p $ORACLE_BASE/admin/ora11g/udump mkdir -p $ORACLE_BASE/diag/rdbms mkdir -p $ORACLE_BASE/diag/tnslsnr mkdir -p $ORACLE_BASE/flash_recovery_area/ora11g mkdir -p $ORACLE_BASE/flash_recovery_area/ORA11g mkdir -p $ORACLE_BASE/archive
3.2??????Standby????
$ scp $ORACLE_BASE/oradata/.dbf 192.168.1.123:$ORACLE_BASE/oradata/ora11g $ scp $ORACLE_BASE/oradata/.log 192.168.1.123:$ORACLE_BASE/oradata/ora11g $ scp /u01/standby_ctl01.ctl 192.168.1.123:$ORACLE_BASE/oradata/ora11g $ scp $ORACLE_HOME/dbs/initora11g.ora 192.168.1.123:$ORACLE_HOME/dbs/
4.1??Data Guard?
SQL> shutdown immediate SQL> startup SQL> alter database create standby controlfile as '/u01/standby_ctl01.ctl';
4.2??Data Guard???
SQL> select open_mode, database_role from v$database; OPEN_MODE DATABASE_ROLE
5.1 Switchover???
5.1.1?Primary???????
SQL> SELECT SWITCHOVER_STATUS FROM V$DATABASE; -- ??SWITCHOVER_STATUS
5.1.2?????
SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY;
5.1.3??????
SQL> shutdown immediate SQL> startup nomount SQL> alter database mount standby database;
5.1.4?Standby???????
SQL> SELECT SWITCHOVER_STATUS FROM V$DATABASE;
5.2 Failover???
SQL> alter database recover managed standby database finish;
SQL> alter database commit to switchover to primary;
5.3?????
SQL> alter database recover managed standby database using current logfile disconnect from session;
6.1??archive_dest???
SQL> select dest_name, status, error from v$archive_dest;
6.2??Redo???
alter database add/drop logfile alter database add/drop standby logfile member alter database create datafile as;
6.3Switchover???
SQL> alter database commit to switchover to physical standby with session shutdown;
6.4??Dataguard???
SQL> SELECT MESSAGE FROM V$DATAGUARD_STATUS;
转载地址：http://popfk.baihongyu.com/