Oracle11g 搭建单实例DataGuard.doc

环境：主备库都为单实例并且数据库SID相同 OS：red hat 6.5 Oracle:11.2.0.4.3 主库操作   1.?开启归档模式 ? 创建归档目录 [root@enn ~]# mkdir -p /u01/archivelog [root@enn ~]# chown -R oracle:oinstall /u01/archivelog [root@enn ~]# chmod 777 /u01/archivelog 数据库到mount状态开启归档模式 [root@enn ~]# su - oracle [oracle@enn ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Sun Jul 20 23:46:46 2014 Copyright (c) 1982, 2013, Oracle.?All rights reserved. Connected to an idle instance. SQL startup mount ORACLE instance started. ?Total System Global Area?835104768 bytes Fixed Size牋牋牋?牋?2257840 bytes Variable Size牋牋牋牋 ?541068368 bytes Database Buffers??289406976 bytes Redo Buffers牋牋?牋?2371584 bytes Database mounted. 设置主库归档目录 SQL alter system set log_archive_dest=/u01/archivelog; alter system set log_archive_dest_1=location=/data/oracle/log1/archive_log;?????最后的目录名称需要为archive_log 开启归档模式 SQL alter database archivelog; Database altered. 查看归档设置 SQL archive log list; Database log mode ?????? Archive Mode Automatic archival??? ?????? Enabled Archive destination?? ?????? /u01/archivelog Oldest online log sequence???? 2 Next log sequence to archive?? 4 Current log sequence? ?????? 4 ? 2.?启动force_logging模式 ? 查看是否force_logging模式 SQL select log_mode,force_logging from v$database; LOG_MODE???? FOR ------------ --- ARCHIVELOG?? NO 开启force_logging模式 SQL alter database force logging; Database altered. ? 3.创建备库日志文件路径 ? 查看数据库的日志组个数与大小，因为我们创建?standby?日志组的个数是原日志 组个数+1?再与?thread?的积((2+1)*3)，size?不能小于原日志文件的大小。 SQL select group#,thread#,bytes/1024/1024 M ,STATUS from v$log; ??? GROUP#??? THREAD#? ?????? M STATUS ---------- ---------- ---------- ---------------- ??? ?1?? ??? 1??? ????? 50 CURRENT ??? ?3?? ??? 1??? ????? 50 INACTIVE 牋??牋 牋?1牋?牋牋?50 INACTIVE ?SQL select member from v$logfile; MEMBER -------------------------------------------------------------------------------- /u01/app/oracle/oradata/ENN/redo03.log /u01/app/oracle/oradata/ENN/redo02.log /u01/app/oracle/oradata/ENN/redo01.log