Oracle Data Guard实施方案

SQL > ALTER DATABASE ARCHIVELOG; SQL > ALTER DATABASE OPEN;

5.10 备份生产数据库

$scp -rp /home/db/oracle/oradata/ORCL oracle@192.168.204.132://home/db/oracle/oradata/ $scp –rp /home/db/oracle/admin/orcl oracle@192.168.204.132://home/db/oracle/admin

5.11 修改备库pfile

[oracle@localhost dbs]$vi initorcl.ora

*.db_unique_name=orcldg

*.log_archive_config='dg_config=(orcldg,orcl)'

*.log_archive_dest_1='location=/home/db/oracle/oradata/ORCL/archive valid_for=(all_logfiles,all_roles) db_unique_name=orcldg' *.log_archive_dest_2='service=orcl lgwr async

valid_for=(online_logfiles,primary_role) db_unique_name=orcl' *.log_archive_dest_state_1=enable *.log_archive_dest_state_2=enable *.log_archive_format=%t_%s_%r.arc *.fal_server=orcl *.fal_client=orcldg

*.standby_file_management=auto

*.control_files='/home/db/oracle/oradata/ORCL/controlfile/stdby_control01.ctl','/home/db/oracle/flash_recovery_area/ORCL/controlfile/stdby_control01.ctl'

5.12 在备库上创建spfile

sql>shutdown immediate

sql>create spfile from pfile;

Oracle Data Guard实施方案

5.13 启动物理备用数据库

SQL>startup nomount

SQL>alter database mount standby database;

5.14 配置Standby Redo Log

在两边都配置standby redo log

在主库查看日志组的数量和每个日志文件的大小 SQL> SELECT GROUP#, BYTES FROM V$LOG;

在备库库查看日志组的数量和每个日志文件的大小 SQL> SELECT GROUP#, BYTES FROM V$STANDBY_LOG; 在主备库创建日志组和redo log文件

SQL> ALTER DATABASE ADD STANDBY LOGFILE group 4('/home/db/oracle/product/11.2.0/db_1/dbs/slog4.rdo') SIZE 50M; SQL> ALTER DATABASE ADD STANDBY LOGFILE group 5 ('/home/db/oracle/product/11.2.0/db_1/dbs/slog5.rdo') SIZE 50M; SQL>ALTER DATABASE ADD STANDBY LOGFILE group 6 ('/home/db/oracle/product/11.2.0/db_1/dbs/slog6.rdo') SIZE 50M; SQL>ALTER DATABASE ADD STANDBY LOGFILE group 7('/home/db/oracle/product/11.2.0/db_1/dbs/slog7.rdo') SIZE 50M;

备注：

删除日志组redo log文件的方法

SQL>ALTER DATABASE DROP STANDBY LOGFILE GROUP N;(N代表数字)

5.15 Start Redo Apply

在主数据库上设置DataGuard的保护模式.把主数据库启动到mount状态设置好DataGuard的保护模式.

SQL>alter system set log_archive_dest_state_2=ENABLE scope=both; SQL>shutdown immediate; SQL>startup mount;

SQL>alter database set standby database to maximize availability; SQL>alter database open;

Oracle Data Guard实施方案

在备用数据库上启动日志传输 #实时应用日志

SQL>alter database recover managed standby database using current logfile disconnect from session;

查看哪些归档日志被APPLY了

SQL>select sequence#,applied from v$archived_log order by sequence#;

在主库

强制日志切换到当前的online redo log file. SQL>alter system archive log current;

在备库

查看新的被归档的redo data

SQL> SELECT SEQUENCE#, FIRST_TIME, NEXT_TIME FROM V$ARCHIVED_LOG ORDER BY SEQUENCE#;

在备库查看接收到的被应用的redo

SQL> select sequence#,applied from v$archived_log order by sequence#;

查看数据库的角色

SQL>select database_role,protection_mode,protection_level from v$database;

在主库查看日志传送情况

SQL> Select dest_name,status,error from v$archive_dest;

DEST_NAME STATUS ERROR

-------------------- --------- ------------------------------------------------- LOG_ARCHIVE_DEST_1 VALID LOG_ARCHIVE_DEST_2 VALID 31 rows selected.

两个节点都正常。

验证同步情况

在主库切换日志：

SQL> alter system switch logfile;

Oracle Data Guard实施方案

System altered.

SQL> select sequence# from v$archived_log; SEQUENCE# ---------- …

15 16

SQL> alter system switch logfile;

System altered.

SQL> select sequence# from v$archived_log; SEQUENCE# ---------- …

17 18

在备库进行验证：

SQL> select sequence#,applied from v$archived_log;

SEQUENCE# APP ---------- --- …

13 YES 4 NO 14 YES 15 YES 16 YES 18 NO 16 YES