lol一键喊话怎么用器上的64dg能用什么代替
点击联系发帖人
时间：2014-12-24 06:26
博客分类：
OracleData Guard 最简单的配置是主备库的环境都一样，但是在有些情况下需要异构的配置，比如在迁移时为了减少停机时间或者零停机，可能就需要使用异构的DG 配置。
关于Oralce DataGuard 异构平台的搭建，Metalink上有2篇文章专门来说明：
Data Guard Support for HeterogeneousPrimary and Logical Standbys in Same Data Guard Configuration [ID ]
Data Guard Support for HeterogeneousPrimary and Physical Standbys in Same Data Guard Configuration [ID ]
在Oracle 11g 之前，DG Broker 不支持不同word-size的DG 配置，因此需要修改word-size. 到了Oracle 11g 之后，DG 就没有了这个限制。具体可查看Metalink的下面文章
Changing between 32-bit and 64-bit WordSizes [ID 62290.1]
这里的word-size只的是数据库的位数，是32位还是64位。其查看方法，我之前的Blog 有说明。
在配置异构DG 之前，要先查看主备库的Platform ID,可以从v$database 视图中查看：
SQL& select platform_id,platform_name from v$
PLATFORM_ID PLATFORM_NAME
----------- ---------------------------------------------
7 Microsoft Windows IA (32-bit)
SQL& select platform_id,platform_name from v$
PLATFORM_ID PLATFORM_NAME
-------------------------------------------------------------------------------
10 Linux IA (32-bit)
这里的Platform_ID 是唯一的，不同的平台，即每个OS对应一个ID。
只要server 上Oracle 的软件的版本和位数是一致的，主备库就支持不同的server，即Server不影响，比如：
（1）Hardware manufacturer (e.g. Delland Sun or Hitachi and EMC)
（2）Hardware configuration (e.g. numberof CPUs, amount of RAM, storage configuration, etc)
（3）Processor (e.g. x86-64 AMD64 andx86-64 Intel 64; POWER4 and POWER5)
（4）Operating system distribution (e.g.Red Hat Linux, SUSE Linux or Oracle Enterprise Linux)
（5）Operating system version (e.g.Windows 2000 and Windows XP)物理standby
物理standby 支持的混合平台如下表所列，不在下表不受支持。
以下几点需要注意：
1、在Oracle 11g之后，不受数据库word-size的限制（数据库32还是64位）
2、在下表所列的平台中，主备库的compatible 参数必须相同。
3、A standby database cannot beopen read-only in any environment that has binary-level PL/SQL-related incompatibilities between primary and standby databases.
Support Note is referenced in the table below for any platform combinations where this is the case (the note provides instructions for eliminating incompatibilities post role transition).
It is possible to access astandby database in such environments in Oracle Database 11g by temporarily converting it to a Snapshot Standby database, or in Oracle Database 10g by opening the standby read/write as described in the Data Guard 10g Concepts and Administration guide: Usinga Physical Standby Database for Read/Write Testing and Reporting. Both procedures require following the steps in note
before making the database available to users.
4、RMAN generally supports instantiation of a physical standby database for the supported platform combinations. Please see Support Note
for details.
5、Platforms in a supporte dcombination may operate in either the primary or standby role.
--平台支持主备库角色的转换
6、在PLATFORM_ID 不一样的情况下，备库不能创建和使用EM。但可以使用DG Broker。
PLATFORM_ID
PLATFORM_NAME
Release name
PLATFORM_IDs supported within the same Data
Guard configuration when using Data Guard Redo Apply (Physical Standby)
Solaris[tm] OE (64-bit)
Solaris Operating System
(SPARC) (64-bit)
6 - This is not supported due to issues reported in Bug
HP-UX (64-bit)
HP-UX PA-RISC
4 - Oracle 10g onward, see Support Notes
HP-UX IA (64-bit)
HP-UX Itanium
3 - Oracle 10g onward, see
Support Notes
HP Tru64 UNIX
HP Tru64 UNIX
IBM AIX on POWER Systems (64-bit)
2 - This is not supported due to issues reported in Bug
Microsoft Windows (32-bit)
Microsoft Windows (x86)
- Oracle 10g onward, see Support Note
10 - Oracle 11g onward, requires patch for Bug
11, 13 - Oracle 11g onward, see Support Note , also requires patch for Bug
Microsoft Windows IA (64-bit)
Microsoft Windows (64-bit
7 - Oracle 10g
onward, see Support Note
12 - Oracle 10g onward
11, 13 - Oracle 11g onward, requires patch for Bug
IBM zSeries Based Linux
18 (64-bit zSeries only)
Linux (32-bit)
7 - Oracle 11g
onward, requires patch for Bug
11, 13 - Oracle 10g onward, see Support Note
Linux IA (64-bit)
Linux Itanium
10 - Oracle 10g onward, see Support Note
13 - Oracle 10g onward
7 - Oracle 11g onward, see Support Note , also requires patch for Bug
8, 12 - Oracle 11g onward, requires patch for Bug
Microsoft Windows 64-bit for AMD
Microsoft Windows (x86-64)
Oracle 10g
onward, see Support Note
8 - Oracle
10g onward
11, 13 - Oracle 11g onward, requires patch for Bug
Linux 64-bit for AMD
Linux x86-64
- Oracle 11g onward, see Support Note , also requires patch for Bug
10 - Oracle
10g onward, see Support Note
11 - Oracle
Oracle 11g onward, requires patch for Bug
20 - Oracle 11g onward
HP Open VMS
HP OpenVMS Alpha
HP IA OpenVMS
OpenVMS Itanium
Apple Mac OS
Mac OS X Server
Solaris Operating System (x86)
Solaris Operating System (x86)
20 - Oracle 10g onward, see Support Note
IBM Power Based Linux
Linux on Power
9 (64-bit zSeries only)
Solaris Operating System (AMD64)
Solaris Operating System
Oracle 11g onward
17 - Oracle 10g onward, see Support Note
逻辑standby
逻辑standby对于dg异构平台的支持，大体上和物理standby没有区别，大家看下下面的表格即可
PLATFORM_ID
PLATFORM_NAME
Release name
PLATFORM_IDs supported within the same Data
Guard configuration when using Data Guard SQL Apply (Logical Standby)
Solaris[tm] OE (64-bit)
Solaris Operating System
(SPARC) (64-bit)
HP-UX (64-bit)
HP-UX PA-RISC
HP-UX IA (64-bit)
HP-UX Itanium
HP Tru64 UNIX
HP Tru64 UNIX
AIX-Based Systems (64-bit)
Microsoft Windows (32-bit)
Microsoft Windows (x86)
10 requires patch for Bug
8, 12 - Replication can only occur from a 32-bit primary to a 64-bit
standby, once a role transition has promoted the 64-bit system to the
primary role, the original 32-bit primary is not supported as a standby
Microsoft Windows IA (64-bit)
Microsoft Windows (64-bit
7 - Replication
can only occur from a 32-bit primary
to a 64-bit standby, once a role transition has promoted the 64-bit
system to the primary role, the original 32-bit primary is not
supported as a standby database.
11, 13, both require patch for Bug
IBM zSeries Based Linux
Linux (32-bit)
7, requires patch for Bug
11, 13 - Replication can only occur from a 32-bit primary
to a 64-bit standby, once a role transition has promoted the 64-bit
system to the primary role, the original 32-bit primary is not
supported as a standby database.
Linux IA (64-bit)
Linux Itanium
10 - Replication can only occur from a 32-bit primary
to a 64-bit standby, once a role transition has promoted the 64-bit
system to the primary role, the original 32-bit primary is not
supported as a standby database.
8, requires patch for Bug
Microsoft Windows 64-bit for AMD
Microsoft Windows (x86-64)
7 - from Oracle
11g onward.
Replication can only occur from a 32-bit primary
to a 64-bit standby, once a role transition has promoted the 64-bit
system to the primary role, the original 32-bit primary is not
supported as a standby database.
Linux 64-bit for AMD
Linux x86-64
Replication can only
occur from a 32-bit primary
to a 64-bit standby, once a role transition has promoted the 64-bit
system to the primary role, the original 32-bit primary is not
supported as a standby database.
8, requires patch for Bug
HP Open VMS
HP OpenVMS Alpha
HP IA OpenVMS
OpenVMS Itanium
Apple Mac OS
Mac OS X Server
Solaris Operating System (x86)
Solaris Operating System (x86)
IBM Power Based Linux
Linux on Power
Solaris Operating System (AMD64)
Solaris Operating System
参考至：http://blog.csdn.net/tianlesoftware/article/details/7241488
如有错误，欢迎指正
浏览: 2978363 次
来自: 厦门
谢谢非常有用那
写的很详细
学习了，学习了
大写的赞..
作为初学者，我表示写得非常好，正在疑惑这些参数的意义呢！
(window.slotbydup=window.slotbydup || []).push({
id: '4773203',
container: s,
size: '200,200',
display: 'inlay-fix'阅读(1091)
【DATAGUARD】物理dg配置客户端无缝切换 (八.1)--Data Guard Broker 的配置
一.1  BLOG文档结构图
一.2  前言部分
一.2.1  
各位技术爱好者，看完本文后，你可以掌握如下的技能，也可以学到一些其它你所不知道的知识，~O(∩_∩)O~：
① Data Guard Broker 的配置
② Fast-Start Failover 的配置
③ Oracle DataGuard 之客户端TAF 配置
④ 使用DGMGRL 来管理数据库
⑤ 物理dg管理和维护的一些sql
⑥ DataGuard 客户端特级配置
  List of Archived Logs in backup set 11
  Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  ---- ------- ---------- ------------------- ---------- ---------
  1    32      0;  
11:09:52 0;  
  1    33      0;  
11:15:48 0;  
  2    42      0;  
10:41:18 0;  
  2    43      0;  
11:15:49 0;  
本文如有错误或不完善的地方请大家多多指正，ITPUB留言或QQ皆可，您的批评指正是我写作的最大动力。
一.2.2  
一.2.3  
【DATAGUARD】 基于同一个主机建立物理备库和逻辑备库（一）：
【DATAGUARD】 基于同一个主机建立物理备库和逻辑备库（二 ): 
【DATAGUARD】 基于同一个主机建立物理备库和逻辑备库（三 ): 
【DATAGUARD】 基于同一个主机建立物理备库和逻辑备库 (四)--添加一个物理dg节点 ：
【DATAGUARD】物理dg的switchover切换（五） ：
：  
 ： http://blog.itpub.net//viewspace-1780863/
一.2.4  
一.3  相关知识点扫盲
一.4  实验部分
一.4.1  
一.4.2  
alter system set dg_broker_start=true scope=
[oracle@rhel6_lhr lhr]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on 星期一 9月 28 10:17:04 2015
Copyright (c) , Oracle.  All rights reserved.
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
10:17:04 SQL& show parameter name
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_file_name_convert                 string      oradglg, oradg11g
db_name                              string      oradg11g
db_unique_name                       string      oradg11g
global_names                         boolean     FALSE
instance_name                        string      oradg11g
lock_name_space                      string
log_file_name_convert                string      oradglg, oradg11g
processor_group_name                 string
service_names                        string      oradg11g
10:17:08 SQL& show parameter spfile
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string      /u01/app/oracle/product/11.2.0
                                                 /dbhome_1/dbs/spfileoradg11g.o
                                                 ra
10:17:14 SQL&  show parameter DG_BROKER_CONFIG_FILE
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
dg_broker_config_file1               string      /u01/app/oracle/product/11.2.0
                                                 /dbhome_1/dbs/dr1oradg11g.dat
dg_broker_config_file2               string      /u01/app/oracle/product/11.2.0
                                                 /dbhome_1/dbs/dr2oradg11g.dat
10:20:43 SQL& set line 9999
10:20:44 SQL& col name format a10
10:20:44 SQL& col FS_FAILOVER_OBSERVER_HOST format a20
10:20:44 SQL& select dbid,name,current_scn,protection_mode,protection_level,database_role,force_logging,open_mode,switchover_status from v$
      DBID NAME       CURRENT_SCN PROTECTION_MODE      PROTECTION_LEVEL     DATABASE_ROLE    FOR OPEN_MODE            SWITCHOVER_STATUS
---------- ---------- ----------- -------------------- -------------------- ---------------- --- -------------------- --------------------
ORADG11G       2336836 MAXIMUM PERFORMANCE  MAXIMUM PERFORMANCE  PRIMARY          YES READ WRITE           TO STANDBY
已用时间:  00: 00: 00.01
10:20:44 SQL& SELECT d.DBID,
10:20:44   2         d.DB_UNIQUE_NAME,
10:20:44   3         d.FORCE_LOGGING,
10:20:44   4         d.FLASHBACK_ON,
10:20:44   5         d.FS_FAILOVER_STATUS,
10:20:44   6         d.FS_FAILOVER_CURRENT_TARGET,
10:20:44   7         d.FS_FAILOVER_THRESHOLD,
10:20:44   8         d.FS_FAILOVER_OBSERVER_PRESENT,
10:20:44   9         d.FS_FAILOVER_OBSERVER_HOST
10:20:44  10    FROM v$
      DBID DB_UNIQUE_NAME                 FOR FLASHBACK_ON       FS_FAILOVER_STATUS     FS_FAILOVER_CURRENT_TARGET     FS_FAILOVER_THRESHOLD FS_FAIL FS_FAILOVER_OBSERVER
---------- ------------------------------ --- ------------------ ---------------------- ------------------------------ --------------------- ------- --------------------
oradg11g                       YES YES                DISABLED                                                                  0
已用时间:  00: 00: 00.00
10:20:45 SQL&
10:20:45 SQL& ! ps -ef|grep dmon
oracle    ; ; 0 10:21 pts/4    00:00:00 /bin/bash -c  ps -ef|grep dmon
oracle    ; ; 0 10:21 pts/4    00:00:00 grep dmon
10:21:17 SQL& show parameter dg_broker
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
dg_broker_config_file1               string      /u01/app/oracle/product/11.2.0
                                                 /dbhome_1/dbs/dr1oradg11g.dat
dg_broker_config_file2               string      /u01/app/oracle/product/11.2.0
                                                 /dbhome_1/dbs/dr2oradg11g.dat
dg_broker_start                      boolean     FALSE
10:21:39 SQL& show parameter dg_broker_start
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
dg_broker_start                      boolean     FALSE
10:21:53 SQL& alter system set dg_broker_start=true scope=
系统已更改。
已用时间:  00: 00: 00.02
10:21:56 SQL& ! ps -ef|grep dmon
oracle    ;    1  0 10:21 ?        00:00:00 ora_dmon_oradg11g
oracle    ; ; 0 10:22 pts/4    00:00:00 /bin/bash -c  ps -ef|grep dmon
oracle    ; ; 0 10:22 pts/4    00:00:00 grep dmon
10:22:02 SQL&
10:22:02 SQL& show parameter dg_broker_start
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
dg_broker_start                      boolean     TRUE
10:23:48 SQL& set line 9999
10:23:58 SQL& col name format a10
10:23:58 SQL& col FS_FAILOVER_OBSERVER_HOST format a20
10:23:58 SQL& select dbid,name,current_scn,protection_mode,protection_level,database_role,force_logging,open_mode,switchover_status from v$
      DBID NAME       CURRENT_SCN PROTECTION_MODE      PROTECTION_LEVEL     DATABASE_ROLE    FOR OPEN_MODE            SWITCHOVER_STATUS
---------- ---------- ----------- -------------------- -------------------- ---------------- --- -------------------- --------------------
ORADG11G       2337043 MAXIMUM PERFORMANCE  MAXIMUM PERFORMANCE  PRIMARY          YES READ WRITE           TO STANDBY
已用时间:  00: 00: 00.01
10:23:58 SQL& SELECT d.DBID,
10:23:58   2         d.DB_UNIQUE_NAME,
10:23:58   3         d.FORCE_LOGGING,
10:23:58   4         d.FLASHBACK_ON,
10:23:58   5         d.FS_FAILOVER_STATUS,
10:23:58   6         d.FS_FAILOVER_CURRENT_TARGET,
10:23:58   7         d.FS_FAILOVER_THRESHOLD,
10:23:58   8         d.FS_FAILOVER_OBSERVER_PRESENT,
10:23:58   9         d.FS_FAILOVER_OBSERVER_HOST
10:23:58  10    FROM v$
      DBID DB_UNIQUE_NAME                 FOR FLASHBACK_ON       FS_FAILOVER_STATUS     FS_FAILOVER_CURRENT_TARGET     FS_FAILOVER_THRESHOLD FS_FAIL FS_FAILOVER_OBSERVER
---------- ------------------------------ --- ------------------ ---------------------- ------------------------------ --------------------- ------- --------------------
oradg11g                       YES YES                DISABLED                                                                  0
已用时间:  00: 00: 00.00
10:24:00 SQL&
Mon Sep 28 10:21:56 2015
ALTER SYSTEM SET dg_broker_start=TRUE SCOPE=BOTH;
Mon Sep 28 10:21:56 2015
DMON started with pid=37, OS id=7975
Starting Data Guard Broker (DMON)
Mon Sep 28 10:22:04 2015
INSV started with pid=38, OS id=7984
[oracle@rhel6_lhr ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on 星期一 9月 28 10:25:25 2015
Copyright (c) , Oracle.  All rights reserved.
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
10:25:25 SQL& show parameter name
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_file_name_convert                 string      oradg11g, oradgphy
db_name                              string      oradg11g
db_unique_name                       string      oradgphy
global_names                         boolean     FALSE
instance_name                        string      oradgphy
lock_name_space                      string
log_file_name_convert                string      oradg11g, oradgphy
processor_group_name                 string
service_names                        string      oradgphy
10:25:27 SQL&  show parameter spfile
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string      /u01/app/oracle/product/11.2.0
                                                 /dbhome_1/dbs/spfileoradgphy.o
                                                 ra
10:25:35 SQL& show parameter DG_BROKER_CONFIG_FILE
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
dg_broker_config_file1               string      /u01/app/oracle/product/11.2.0
                                                 /dbhome_1/dbs/dr1oradgphy.dat
dg_broker_config_file2               string      /u01/app/oracle/product/11.2.0
                                                 /dbhome_1/dbs/dr2oradgphy.dat
10:25:43 SQL& set line 9999
10:25:51 SQL& col name format a10
10:25:51 SQL& col FS_FAILOVER_OBSERVER_HOST format a20
10:25:51 SQL& select dbid,name,current_scn,protection_mode,protection_level,database_role,force_logging,open_mode,switchover_status from v$
SELECT d.DBID,
       d.DB_UNIQUE_NAME,
       d.FORCE_LOGGING,
       d.FLASHBACK_ON,
       d.FS_FAILOVER_STATUS,
      DBID NAME       CURRENT_SCN PROTECTION_MODE      PROTECTION_LEVEL     DATABASE_ROLE    FOR OPEN_MODE            SWITCHOVER_STATUS
---------- ---------- ----------- -------------------- -------------------- ---------------- --- -------------------- --------------------
ORADG11G       2337499 MAXIMUM PERFORMANCE  MAXIMUM PERFORMANCE  PHYSICAL STANDBY YES READ ONLY WITH APPLY NOT ALLOWED
已用时间:  00: 00: 00.11
10:25:52 SQL& 10:25:52   2  10:25:52   3  10:25:52   4  10:25:52   5  10:25:52   6         d.FS_FAILOVER_CURRENT_TARGET,
10:25:52   7         d.FS_FAILOVER_THRESHOLD,
10:25:52   8         d.FS_FAILOVER_OBSERVER_PRESENT,
10:25:52   9         d.FS_FAILOVER_OBSERVER_HOST
10:25:52  10    FROM v$
      DBID DB_UNIQUE_NAME                 FOR FLASHBACK_ON       FS_FAILOVER_STATUS     FS_FAILOVER_CURRENT_TARGET     FS_FAILOVER_THRESHOLD FS_FAIL FS_FAILOVER_OBSERVER
---------- ------------------------------ --- ------------------ ---------------------- ------------------------------ --------------------- ------- --------------------
oradgphy                       YES NO                 DISABLED                                                                  0
已用时间:  00: 00: 00.00
10:25:56 SQL&  ! ps -ef|grep dmon
oracle    ;    1  0 10:21 ?        00:00:00 ora_dmon_oradg11g
oracle    ; ; 0 10:26 pts/5    00:00:00 /bin/bash -c  ps -ef|grep dmon
oracle    ; ; 0 10:26 pts/5    00:00:00 grep dmon
10:26:07 SQL&  show parameter dg_broker_start
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
dg_broker_start                      boolean     FALSE
10:26:39 SQL&
alter system set dg_broker_start=true scope=
系统已更改。
已用时间:  00: 00: 00.05
10:26:46 SQL&  ! ps -ef|grep dmon
oracle    ;    1  0 10:21 ?        00:00:00 ora_dmon_oradg11g
oracle    ;    1  0 10:26 ?        00:00:00 ora_dmon_oradgphy
oracle    ; ; 0 10:26 pts/5    00:00:00 /bin/bash -c  ps -ef|grep dmon
oracle    ; ; 0 10:26 pts/5    00:00:00 grep dmon
10:26:50 SQL&
一.4.2.1  配置db_domain 和  listener 及 tnsnames
db_unique_name_DGMGRL.db_domain
14:05:05 SQL&  show parameter db_domain 
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_domain                            string
14:13:46 SQL& alter system set db_domain='lhr.com' scope=
[oracle@rhel6_lhr admin]$ lsnrctl status
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 28-9月 -:27
Copyright (c) , Oracle.  All rights reserved.
正在连接到 (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.59.130)(PORT=1521)))
LISTENER 的 STATUS
------------------------
别名                      LISTENER
版本                      TNSLSNR for Linux: Version 11.2.0.3.0 - Production
启动日期                  28-9月 -:08
正常运行时间              0 天 0 小时 33 分 18 秒
跟踪级别                  off
安全性                    ON: Local OS Authentication
SNMP                      OFF
监听程序参数文件          /u01/app/grid/11.2.0/network/admin/listener.ora
监听端点概要...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.59.130)(PORT=1521)))
服务摘要..
服务 &+ASM& 包含 1 个实例。
  实例 &+ASM&, 状态 READY, 包含此服务的 1 个处理程序...
服务 &PLSExtProc& 包含 1 个实例。
  实例 &PLSExtProc&, 状态 UNKNOWN, 包含此服务的 1 个处理程序...
服务 &ora11g& 包含 1 个实例。
  实例 &ora11g&, 状态 UNKNOWN, 包含此服务的 1 个处理程序...
服务 &oradg11g& 包含 1 个实例。
  实例 &oradg11g&, 状态 UNKNOWN, 包含此服务的 1 个处理程序...
服务 &oradg11g.lhr.com& 包含 2 个实例。
  实例 &oradg11g&, 状态 UNKNOWN, 包含此服务的 1 个处理程序...
  实例 &oradg11g&, 状态 READY, 包含此服务的 1 个处理程序...
服务 &oradg11gXDB.lhr.com& 包含 2 个实例。
  实例 &oradg11g&, 状态 READY, 包含此服务的 1 个处理程序...
  实例 &oradgphy&, 状态 READY, 包含此服务的 1 个处理程序...
服务 &oradg11g_DGB.lhr.com& 包含 1 个实例。
  实例 &oradg11g&, 状态 READY, 包含此服务的 1 个处理程序...
服务 &oradg11g_DGMGRL.lhr.com& 包含 1 个实例。
  实例 &oradg11g&, 状态 UNKNOWN, 包含此服务的 1 个处理程序...
服务 &oradglg& 包含 1 个实例。
  实例 &oradglg&, 状态 UNKNOWN, 包含此服务的 1 个处理程序...
服务 &oradgphy& 包含 1 个实例。
  实例 &oradgphy&, 状态 UNKNOWN, 包含此服务的 1 个处理程序...
服务 &oradgphy.lhr.com& 包含 2 个实例。
  实例 &oradgphy&, 状态 UNKNOWN, 包含此服务的 1 个处理程序...
  实例 &oradgphy&, 状态 READY, 包含此服务的 1 个处理程序...
服务 &oradgphy_DGB.lhr.com& 包含 1 个实例。
  实例 &oradgphy&, 状态 READY, 包含此服务的 1 个处理程序...
服务 &oradgphy_DGMGRL.lhr.com& 包含 1 个实例。
  实例 &oradgphy&, 状态 UNKNOWN, 包含此服务的 1 个处理程序...
服务 &oradgss& 包含 1 个实例。
  实例 &oradgss&, 状态 UNKNOWN, 包含此服务的 1 个处理程序...
服务 &orclasm.lhr.com& 包含 1 个实例。
  实例 &orclasm&, 状态 UNKNOWN, 包含此服务的 1 个处理程序...
命令执行成功
[oracle@rhel6_lhr admin]$ more /u01/app/grid/11.2.0/network/admin/listener.ora
# listener.ora Network Configuration File: /u01/app/grid/11.2.0/network/admin/listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = orclasm.lhr.com)
      (SID_NAME = orclasm)
      (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
    )
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
      (PROGRAM = extproc)
    )
  (SID_DESC =
    (GLOBAL_DBNAME = oradg11g)
    (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
    (SID_NAME= oradg11g)
  (SID_DESC =
    (GLOBAL_DBNAME = oradgphy)
    (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
    (SID_NAME= oradgphy)
  (SID_DESC =
    (GLOBAL_DBNAME = oradglg)
    (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
    (SID_NAME= oradglg)
  (SID_DESC =
    (GLOBAL_DBNAME = oradgss)
    (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
    (SID_NAME= oradgss)
  (SID_DESC =
    (GLOBAL_DBNAME = ora11g)
    (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
    (SID_NAME= ora11g)
    (SID_DESC =
    (GLOBAL_DBNAME = oradg11g.lhr.com)
    (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
    (SID_NAME= oradg11g)
  (SID_DESC =
    (GLOBAL_DBNAME = oradgphy.lhr.com)
    (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
    (SID_NAME= oradgphy)
  (SID_DESC =
    (GLOBAL_DBNAME = oradg11g_DGMGRL.lhr.com)
    (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
    (SID_NAME= oradg11g)
  (SID_DESC =
    (GLOBAL_DBNAME = oradgphy_DGMGRL.lhr.com)
    (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
    (SID_NAME= oradgphy)
LOGGING_LISTENER = OFF
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.59.130)(PORT = 1521))
    )
ADR_BASE_LISTENER = /u01/app/grid
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER = ON
#TRACE_LEVEL_LISTENER = OFF
[oracle@rhel6_lhr admin]$
[oracle@rhel6_lhr admin]$ more tnsnames.ora
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
tns_oradg11g_DGMGRL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.59.130)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = oradg11g_DGMGRL.lhr.com)
    )
tns_oradgphy_DGMGRL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.59.130)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = oradgphy_DGMGRL.lhr.com)
    )
tns_oradg11g =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.59.130)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = oradg11g)
    )
tns_oradgphy =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.59.130)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = oradgphy)
    )
tns_oradglg =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.59.130)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = oradglg)
    )
一.4.3  
[oracle@rhel6_lhr ~]$ dgmgrl
DGMGRL for Linux: Version 11.2.0.3.0 - 64bit Production
Copyright (c) , Oracle. All rights reserved.
欢迎使用 DGMGRL, 要获取有关信息请键入 &help&。
DGMGRL& help
可使用以下命令:
add            在中介配置中添加备用数据库
connect        连接到 Oracle 数据库实例
convert        将数据库从一种类型转换为另一种
create         创建中介配置
disable        禁用配置, 数据库或快速启动故障转移
edit           编辑配置, 数据库或实例
enable         启用配置, 数据库或快速启动故障转移
exit           退出程序
failover       将备用数据库更改为主数据库
help           显示命令的说明和语法
quit           退出程序
reinstate      将标记为恢复的数据库更改为可行的备用数据库
rem            DGMGRL 会忽略注释
remove         删除配置, 数据库或实例
show           显示有关配置, 数据库或实例的信息
shutdown       关闭当前正在运行的 Oracle 数据库实例
sql            执行 SQL 语句
start          启动快速启动故障转移观察程序
startup        启动 Oracle 数据库实例
stop           停止快速启动故障转移观察程序
switchover     在主数据库和备用数据库之间切换角色
使用 &help &command&& 可以查看各个命令的语法
DGMGRL& connect sys/lhr@tns_oradg11g_dgmgrl
DGMGRL& show configuration
ORA-16532: Data Guard 中介配置不存在
配置详细资料不能由 DGMGRL 确定
DGMGRL& help create 
创建中介配置
  CREATE CONFIGURATION &configuration name& AS
    PRIMARY DATABASE IS &database name&
    CONNECT IDENTIFIER IS &connect identifier&;
DGMGRL& create configuration 'fsf_oradg11g_lhr' as
& primary database is 'oradg11g'
& connect identifier is tns_oradg11g_dgmgrl;
已创建配置 &fsf_oradg11g_lhr&, 其中主数据库为 &oradg11g&
DGMGRL& show configuration
配置 - fsf_oradg11g_lhr
  保护模式:        MaxPerformance
  数据库:
    oradg11g - 主数据库
快速启动故障转移: DISABLED
DGMGRL& add database 'oradgphy' as
& connect identifier is tns_oradgphy_dgmgrl
已添加数据库 &oradgphy&
DGMGRL& show configuration
配置 - fsf_oradg11g_lhr
  保护模式:        MaxPerformance
  数据库:
    oradg11g - 主数据库
    oradgphy - 物理备用数据库
快速启动故障转移: DISABLED
DGMGRL& enable configuration
DGMGRL& show configuration
配置 - fsf_oradg11g_lhr
  保护模式:        MaxPerformance
  数据库:
    oradg11g - 主数据库
    oradgphy - 物理备用数据库
快速启动故障转移: DISABLED
show database verbose oradg11g
数据库 - oradg11g
  角色:            PRIMARY
  预期状态:        TRANSPORT-ON
  实例:
    oradg11g
  属性:
    DGConnectIdentifier             = 'tns_oradg11g_dgmgrl'
    ObserverConnectIdentifier       = ''
    LogXptMode                      = 'ASYNC'
    DelayMins                       = '0'
    Binding                         = 'OPTIONAL'
    MaxFailure                      = '0'
    MaxConnections                  = '1'
    ReopenSecs                      = '300'
    NetTimeout                      = '30'
    RedoCompression                 = 'DISABLE'
    LogShipping                     = 'ON'
    PreferredApplyInstance          = ''
    ApplyInstanceTimeout            = '0'
    ApplyParallel                   = 'AUTO'
    StandbyFileManagement           = 'AUTO'
    ArchiveLagTarget                = '0'
    LogArchiveMaxProcesses          = '4'
    LogArchiveMinSucceedDest        = '1'
    DbFileNameConvert               = 'oradgphy, oradg11g'
    LogFileNameConvert              = 'oradgphy, oradg11g'
    FastStartFailoverTarget         = ''
    InconsistentProperties          = '(monitor)'
    InconsistentLogXptProps         = '(monitor)'
    SendQEntries                    = '(monitor)'
    LogXptStatus                    = '(monitor)'
    RecvQEntries                    = '(monitor)'
    SidName                         = 'oradg11g'
    StaticConnectIdentifier         = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=rhel6_lhr)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=oradg11g_DGMGRL.lhr.com)(INSTANCE_NAME=oradg11g)(SERVER=DEDICATED)))'
    StandbyArchiveLocation          = 'USE_DB_RECOVERY_FILE_DEST'
    AlternateLocation               = ''
    LogArchiveTrace                 = '0'
    LogArchiveFormat                = '%t_%s_%r.dbf'
    TopWaitEvents                   = '(monitor)'
数据库状态:
DGMGRL&  show database verbose oradgphy
数据库 - oradgphy
  角色:            PHYSICAL STANDBY
  预期状态:        APPLY-ON
  传输滞后:        0 秒
  应用滞后:        0 秒
  实时查询:        ON
  实例:
    oradgphy
  属性:
    DGConnectIdentifier             = 'tns_oradgphy_dgmgrl'
    ObserverConnectIdentifier       = ''
    LogXptMode                      = 'ASYNC'
    DelayMins                       = '0'
    Binding                         = 'optional'
    MaxFailure                      = '0'
    MaxConnections                  = '1'
    ReopenSecs                      = '300'
    NetTimeout                      = '30'
    RedoCompression                 = 'DISABLE'
    LogShipping                     = 'ON'
    PreferredApplyInstance          = ''
    ApplyInstanceTimeout            = '0'
    ApplyParallel                   = 'AUTO'
    StandbyFileManagement           = 'AUTO'
    ArchiveLagTarget                = '0'
    LogArchiveMaxProcesses          = '4'
    LogArchiveMinSucceedDest        = '1'
    DbFileNameConvert               = 'oradg11g, oradgphy'
    LogFileNameConvert              = 'oradg11g, oradgphy'
    FastStartFailoverTarget         = ''
    InconsistentProperties          = '(monitor)'
    InconsistentLogXptProps         = '(monitor)'
    SendQEntries                    = '(monitor)'
    LogXptStatus                    = '(monitor)'
    RecvQEntries                    = '(monitor)'
    SidName                         = 'oradgphy'
    StaticConnectIdentifier         = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=rhel6_lhr)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=oradgphy_DGMGRL.lhr.com)(INSTANCE_NAME=oradgphy)(SERVER=DEDICATED)))'
    StandbyArchiveLocation          = 'USE_DB_RECOVERY_FILE_DEST'
    AlternateLocation               = ''
    LogArchiveTrace                 = '0'
    LogArchiveFormat                = '%t_%s_%r.dbf'
    TopWaitEvents                   = '(monitor)'
数据库状态:
Mon Sep 28 15:20:28 2015
NSV1 started with pid=30, OS id=25660
Mon Sep 28 15:20:54 2015
ALTER SYSTEM SET log_archive_config='dg_config=(oradg11g,oradgphy)' SCOPE=BOTH;
Mon Sep 28 15:20:57 2015
ALTER SYSTEM SET log_archive_dest_2='service=&tns_oradgphy_dgmgrl&','LGWR ASYNC NOAFFIRM delay=0 optional compression=disable max_failure=0 max_connections=1 reopen=300 db_unique_name=&oradgphy& net_timeout=30','valid_for=(all_logfiles,primary_role)' SCOPE=BOTH;
ALTER SYSTEM SET log_archive_trace=0 SCOPE=BOTH SID='oradg11g';
ALTER SYSTEM SET log_archive_format='%t_%s_%r.dbf' SCOPE=SPFILE SID='oradg11g';
ALTER SYSTEM SET standby_file_management='AUTO' SCOPE=BOTH SID='*';
ALTER SYSTEM SET archive_lag_target=0 SCOPE=BOTH SID='*';
ALTER SYSTEM SET log_archive_max_processes=4 SCOPE=BOTH SID='*';
ALTER SYSTEM SET log_archive_min_succeed_dest=1 SCOPE=BOTH SID='*';
ALTER SYSTEM SET db_file_name_convert='oradgphy','oradg11g' SCOPE=SPFILE;
ALTER SYSTEM SET log_file_name_convert='oradgphy','oradg11g' SCOPE=SPFILE;
ALTER SYSTEM ARCHIVE LOG
Mon Sep 28 15:20:57 2015
NSA2 started with pid=34, OS id=25706
NSV0 started with pid=21, OS id=25696
Mon Sep 28 15:20:57 2015
ALTER SYSTEM SET log_archive_trace=0 SCOPE=BOTH SID='oradgphy';
ALTER SYSTEM SET log_archive_format='%t_%s_%r.dbf' SCOPE=SPFILE SID='oradgphy';
ALTER SYSTEM SET standby_file_management='AUTO' SCOPE=BOTH SID='*';
ALTER SYSTEM SET archive_lag_target=0 SCOPE=BOTH SID='*';
ALTER SYSTEM SET log_archive_max_processes=4 SCOPE=BOTH SID='*';
ALTER SYSTEM SET log_archive_min_succeed_dest=1 SCOPE=BOTH SID='*';
ALTER SYSTEM SET db_file_name_convert='oradg11g','oradgphy' SCOPE=SPFILE;
ALTER SYSTEM SET log_file_name_convert='oradg11g','oradgphy' SCOPE=SPFILE;
ALTER SYSTEM SET fal_server='tns_oradg11g_dgmgrl' SCOPE=BOTH;
Mon Sep 28 15:21:01 2015
Primary database is in MAXIMUM PERFORMANCE mode
RFS[4]: Assigned to RFS process 25708
RFS[4]: Selected log 4 for thread 1 sequence 145 dbid
一.4.4  
DGMGRL& show configuration
配置 - fsf_oradg11g_lhr
  保护模式:        MaxPerformance
  数据库:
    oradg11g - 主数据库
    oradgphy - 物理备用数据库
快速启动故障转移: DISABLED
DGMGRL& sw
立即执行切换, 请稍候...
新的主数据库 &oradgphy& 正在打开...
操作要求关闭实例 &oradg11g& (在数据库 &oradg11g& 上)
正在关闭实例 &oradg11g&...
ORACLE 例程已经关闭。
操作要求启动实例 &oradg11g& (在数据库 &oradg11g& 上)
正在启动实例 &oradg11g&...
ORACLE 例程已经启动。
数据库装载完毕。
数据库已经打开。
切换成功, 新的主数据库为 &oradgphy&
DGMGRL& show configuration
配置 - fsf_oradg11g_lhr
  保护模式:        MaxPerformance
  数据库:
    oradgphy - 主数据库
    oradg11g - 物理备用数据库
快速启动故障转移: DISABLED
DGMGRL& switchover to oradg11g;
立即执行切换, 请稍候...
新的主数据库 &oradg11g& 正在打开...
操作要求关闭实例 &oradgphy& (在数据库 &oradgphy& 上)
正在关闭实例 &oradgphy&...
ORACLE 例程已经关闭。
操作要求启动实例 &oradgphy& (在数据库 &oradgphy& 上)
正在启动实例 &oradgphy&...
ORACLE 例程已经启动。
数据库装载完毕。
数据库已经打开。
切换成功, 新的主数据库为 &oradg11g&
DGMGRL& show configuration
配置 - fsf_oradg11g_lhr
  保护模式:        MaxPerformance
  数据库:
    oradg11g - 主数据库
    oradgphy - 物理备用数据库
快速启动故障转移: DISABLED
Mon Sep 28 15:26:24 2015
ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY WITH SESSION SHUTDOWN
ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY [Process Id: 23943] (oradg11g)
Mon Sep 28 15:26:24 2015
Thread 1 advanced to log sequence 146 (LGWR switch)
  Current log# 2 seq# 146 mem# 0: /u01/app/oracle/oradata/oradg11g/redo02.log
Mon Sep 28 15:26:24 2015
Stopping background process CJQ0
Stopping background process QMNC
Stopping Job queue slave processes, flags = 27
Mon Sep 28 15:26:27 2015
Archived Log entry 501 added for thread 1 sequence 145 ID 0x5495956b dest 1:
Waiting for Job queue slaves to complete
Job queue slave processes stopped
All dispatchers and shared servers shutdown
CLOSE: killing server sessions.
Active process 25846 user 'oracle' program 'oracle@rhel6_lhr (W000)'
Active process 25846 user 'oracle' program 'oracle@rhel6_lhr (W000)'
Active process 25846 user 'oracle' program 'oracle@rhel6_lhr (W000)'
Active process 25846 user 'oracle' program 'oracle@rhel6_lhr (W000)'
Active process 25846 user 'oracle' program 'oracle@rhel6_lhr (W000)'
Active process 25846 user 'oracle' program 'oracle@rhel6_lhr (W000)'
Active process 25846 user 'oracle' program 'oracle@rhel6_lhr (W000)'
Active process 25846 user 'oracle' program 'oracle@rhel6_lhr (W000)'
Active process 25846 user 'oracle' program 'oracle@rhel6_lhr (W000)'
Active process 25846 user 'oracle' program 'oracle@rhel6_lhr (W000)'
Active process 25846 user 'oracle' program 'oracle@rhel6_lhr (W000)'
Active process 25846 user 'oracle' program 'oracle@rhel6_lhr (W000)'
Active process 25846 user 'oracle' program 'oracle@rhel6_lhr (W000)'
Active process 25846 user 'oracle' program 'oracle@rhel6_lhr (W000)'
Active process 25846 user 'oracle' program 'oracle@rhel6_lhr (W000)'
Active process 25846 user 'oracle' program 'oracle@rhel6_lhr (W000)'
Active process 25846 user 'oracle' program 'oracle@rhel6_lhr (W000)'
Active process 25846 user 'oracle' program 'oracle@rhel6_lhr (W000)'
Active process 25846 user 'oracle' program 'oracle@rhel6_lhr (W000)'
Active process 25846 user 'oracle' program 'oracle@rhel6_lhr (W000)'
Active process 25846 user 'oracle' program 'oracle@rhel6_lhr (W000)'
Active process 25846 user 'oracle' program 'oracle@rhel6_lhr (W000)'
Active process 25846 user 'oracle' program 'oracle@rhel6_lhr (W000)'
Active process 25846 user 'oracle' program 'oracle@rhel6_lhr (W000)'
Active process 25846 user 'oracle' program 'oracle@rhel6_lhr (W000)'
Active process 25846 user 'oracle' program 'oracle@rhel6_lhr (W000)'
Active process 25846 user 'oracle' program 'oracle@rhel6_lhr (W000)'
Active process 25846 user 'oracle' program 'oracle@rhel6_lhr (W000)'
Active process 25846 user 'oracle' program 'oracle@rhel6_lhr (W000)'
Active process 25846 user 'oracle' program 'oracle@rhel6_lhr (W000)'
CLOSE: all sessions shutdown successfully.
Waiting for all non-current ORLs to be archived...
All non-current ORLs have been archived.
Waiting for all FAL entries to be archived...
All FAL entries have been archived.
Waiting for dest_id 2 to become synchronized...
Active, synchronized Physical Standby switchover target has been identified
Switchover End-Of-Redo Log thread 1 sequence 146 has been fixed
Switchover: Primary highest seen SCN set to 0x0.0x262c94
ARCH: Noswitch archival of thread 1, sequence 146
ARCH: End-Of-Redo Branch archival of thread 1 sequence 146
ARCH: LGWR is actively archiving destination LOG_ARCHIVE_DEST_2
ARCH: Standby redo logfile selected for thread 1 sequence 146 for destination LOG_ARCHIVE_DEST_2
Archived Log entry 502 added for thread 1 sequence 146 ID 0x5495956b dest 1:
ARCH: Archiving is disabled due to current logfile archival
Primary will check for some target standby to have received alls redo
Final check for a synchronized target standby. Check will be made once.
Archive destination LOG_ARCHIVE_DEST_3 invalidated
DB_UNIQUE_NAME oradglg is not in the Data Guard configuration
Archive destination LOG_ARCHIVE_DEST_4 invalidated
DB_UNIQUE_NAME oradgss is not in the Data Guard configuration
LOG_ARCHIVE_DEST_2 is a potential Physical Standby switchover target
Active, synchronized target has been identified
Target has also received all redo
Backup controlfile written to trace file /u01/app/oracle/diag/rdbms/oradg11g/oradg11g/trace/oradg11g_rsm0_23943.trc
Clearing standby activation ID
(0x5495956b)
The primary database controlfile was created using the
'MAXLOGFILES 16' clause.
There is space for up to 13 standby redo logfiles
Use the following SQL commands on the standby database to create
standby redo logfiles that match the primary database:
ALTER DATABASE ADD STANDBY LOGFILE 'srl1.f' SIZE ;
ALTER DATABASE ADD STANDBY LOGFILE 'srl2.f' SIZE ;
ALTER DATABASE ADD STANDBY LOGFILE 'srl3.f' SIZE ;
ALTER DATABASE ADD STANDBY LOGFILE 'srl4.f' SIZE ;
Archivelog for thread 1 sequence 146 required for standby recovery
Switchover: Primary controlfile converted to standby controlfile succesfully.
Switchover: Complete - Database shutdown required
Completed: ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY WITH SESSION SHUTDOWN
Mon Sep 28 15:26:37 2015
Performing implicit shutdown abort due to switchover to physical standby
Shutting down instance (abort)
License high water mark = 8
USER (ospid: 26018): terminating the instance
Instance terminated by USER, pid = 26018
Mon Sep 28 15:26:38 2015
Instance shutdown complete
ORA-1092 : opitsk aborting process
Mon Sep 28 15:26:38 2015
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Archive destination LOG_ARCHIVE_DEST_3 invalidated
DB_UNIQUE_NAME oradglg is not in the Data Guard configuration
Archive destination LOG_ARCHIVE_DEST_4 invalidated
DB_UNIQUE_NAME oradgss is not in the Data Guard configuration
Autotune of undo retention is turned on.
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1
System name:    Linux
Node name:      rhel6_lhr
Release:        2.6.32-504.16.2.el6.x86_64
Version:        #1 SMP Tue Apr 21 08:37:59 PDT 2015
Machine:        x86_64
VM name:        VMWare Version: 6
Using parameter settings in server-side spfile /u01/app/oracle/product/11.2.0/dbhome_1/dbs/spfileoradg11g.ora
System parameters with non-default values:
  processes                = 150
  memory_target            = 300M
  memory_max}
OracleData Guard 最简单的配置是主备库的环境都一样，但是在有些情况下需要异构的配置，比如在迁移时为了减少停机时间或者零停机，可能就需要使用异构的DG 配置。
关于Oralce DataGuard 异构平台的搭建，Metalink上有2篇文章专门来说明：
Data Guard Support for HeterogeneousPrimary and Logical Standbys in Same Data Guard Configuration [ID ]
Data Guard Support for HeterogeneousPrimary and Physical Standbys in Same Data Guard Configuration [ID ]
在Oracle 11g 之前，DG Broker 不支持不同word-size的DG 配置，因此需要修改word-size. 到了Oracle 11g 之后，DG 就没有了这个限制。具体可查看Metalink的下面文章
Changing between 32-bit and 64-bit WordSizes [ID 62290.1]
这里的word-size只的是数据库的位数，是32位还是64位。其查看方法，我之前的Blog 有说明。
在配置异构DG 之前，要先查看主备库的Platform ID,可以从v$database 视图中查看：
SQL& select platform_id,platform_name from v$
PLATFORM_ID PLATFORM_NAME
----------- ---------------------------------------------
7 Microsoft Windows IA (32-bit)
SQL& select platform_id,platform_name from v$
PLATFORM_ID PLATFORM_NAME
-------------------------------------------------------------------------------
10 Linux IA (32-bit)
这里的Platform_ID 是唯一的，不同的平台，即每个OS对应一个ID。
只要server 上Oracle 的软件的版本和位数是一致的，主备库就支持不同的server，即Server不影响，比如：
（1）Hardware manufacturer (e.g. Delland Sun or Hitachi and EMC)
（2）Hardware configuration (e.g. numberof CPUs, amount of RAM, storage configuration, etc)
（3）Processor (e.g. x86-64 AMD64 andx86-64 Intel 64; POWER4 and POWER5)
（4）Operating system distribution (e.g.Red Hat Linux, SUSE Linux or Oracle Enterprise Linux)
（5）Operating system version (e.g.Windows 2000 and Windows XP)物理standby
物理standby 支持的混合平台如下表所列，不在下表不受支持。
以下几点需要注意：
1、在Oracle 11g之后，不受数据库word-size的限制（数据库32还是64位）
2、在下表所列的平台中，主备库的compatible 参数必须相同。
3、A standby database cannot beopen read-only in any environment that has binary-level PL/SQL-related incompatibilities between primary and standby databases.
Support Note is referenced in the table below for any platform combinations where this is the case (the note provides instructions for eliminating incompatibilities post role transition).
It is possible to access astandby database in such environments in Oracle Database 11g by temporarily converting it to a Snapshot Standby database, or in Oracle Database 10g by opening the standby read/write as described in the Data Guard 10g Concepts and Administration guide: Usinga Physical Standby Database for Read/Write Testing and Reporting. Both procedures require following the steps in note
before making the database available to users.
4、RMAN generally supports instantiation of a physical standby database for the supported platform combinations. Please see Support Note
for details.
5、Platforms in a supporte dcombination may operate in either the primary or standby role.
--平台支持主备库角色的转换
6、在PLATFORM_ID 不一样的情况下，备库不能创建和使用EM。但可以使用DG Broker。
PLATFORM_ID
PLATFORM_NAME
Release name
PLATFORM_IDs supported within the same Data
Guard configuration when using Data Guard Redo Apply (Physical Standby)
Solaris[tm] OE (64-bit)
Solaris Operating System
(SPARC) (64-bit)
6 - This is not supported due to issues reported in Bug
HP-UX (64-bit)
HP-UX PA-RISC
4 - Oracle 10g onward, see Support Notes
HP-UX IA (64-bit)
HP-UX Itanium
3 - Oracle 10g onward, see
Support Notes
HP Tru64 UNIX
HP Tru64 UNIX
IBM AIX on POWER Systems (64-bit)
2 - This is not supported due to issues reported in Bug
Microsoft Windows (32-bit)
Microsoft Windows (x86)
- Oracle 10g onward, see Support Note
10 - Oracle 11g onward, requires patch for Bug
11, 13 - Oracle 11g onward, see Support Note , also requires patch for Bug
Microsoft Windows IA (64-bit)
Microsoft Windows (64-bit
7 - Oracle 10g
onward, see Support Note
12 - Oracle 10g onward
11, 13 - Oracle 11g onward, requires patch for Bug
IBM zSeries Based Linux
18 (64-bit zSeries only)
Linux (32-bit)
7 - Oracle 11g
onward, requires patch for Bug
11, 13 - Oracle 10g onward, see Support Note
Linux IA (64-bit)
Linux Itanium
10 - Oracle 10g onward, see Support Note
13 - Oracle 10g onward
7 - Oracle 11g onward, see Support Note , also requires patch for Bug
8, 12 - Oracle 11g onward, requires patch for Bug
Microsoft Windows 64-bit for AMD
Microsoft Windows (x86-64)
Oracle 10g
onward, see Support Note
8 - Oracle
10g onward
11, 13 - Oracle 11g onward, requires patch for Bug
Linux 64-bit for AMD
Linux x86-64
- Oracle 11g onward, see Support Note , also requires patch for Bug
10 - Oracle
10g onward, see Support Note
11 - Oracle
Oracle 11g onward, requires patch for Bug
20 - Oracle 11g onward
HP Open VMS
HP OpenVMS Alpha
HP IA OpenVMS
OpenVMS Itanium
Apple Mac OS
Mac OS X Server
Solaris Operating System (x86)
Solaris Operating System (x86)
20 - Oracle 10g onward, see Support Note
IBM Power Based Linux
Linux on Power
9 (64-bit zSeries only)
Solaris Operating System (AMD64)
Solaris Operating System
Oracle 11g onward
17 - Oracle 10g onward, see Support Note
逻辑standby
逻辑standby对于dg异构平台的支持，大体上和物理standby没有区别，大家看下下面的表格即可
PLATFORM_ID
PLATFORM_NAME
Release name
PLATFORM_IDs supported within the same Data
Guard configuration when using Data Guard SQL Apply (Logical Standby)
Solaris[tm] OE (64-bit)
Solaris Operating System
(SPARC) (64-bit)
HP-UX (64-bit)
HP-UX PA-RISC
HP-UX IA (64-bit)
HP-UX Itanium
HP Tru64 UNIX
HP Tru64 UNIX
AIX-Based Systems (64-bit)
Microsoft Windows (32-bit)
Microsoft Windows (x86)
10 requires patch for Bug
8, 12 - Replication can only occur from a 32-bit primary to a 64-bit
standby, once a role transition has promoted the 64-bit system to the
primary role, the original 32-bit primary is not supported as a standby
Microsoft Windows IA (64-bit)
Microsoft Windows (64-bit
7 - Replication
can only occur from a 32-bit primary
to a 64-bit standby, once a role transition has promoted the 64-bit
system to the primary role, the original 32-bit primary is not
supported as a standby database.
11, 13, both require patch for Bug
IBM zSeries Based Linux
Linux (32-bit)
7, requires patch for Bug
11, 13 - Replication can only occur from a 32-bit primary
to a 64-bit standby, once a role transition has promoted the 64-bit
system to the primary role, the original 32-bit primary is not
supported as a standby database.
Linux IA (64-bit)
Linux Itanium
10 - Replication can only occur from a 32-bit primary
to a 64-bit standby, once a role transition has promoted the 64-bit
system to the primary role, the original 32-bit primary is not
supported as a standby database.
8, requires patch for Bug
Microsoft Windows 64-bit for AMD
Microsoft Windows (x86-64)
7 - from Oracle
11g onward.
Replication can only occur from a 32-bit primary
to a 64-bit standby, once a role transition has promoted the 64-bit
system to the primary role, the original 32-bit primary is not
supported as a standby database.
Linux 64-bit for AMD
Linux x86-64
Replication can only
occur from a 32-bit primary
to a 64-bit standby, once a role transition has promoted the 64-bit
system to the primary role, the original 32-bit primary is not
supported as a standby database.
8, requires patch for Bug
HP Open VMS
HP OpenVMS Alpha
HP IA OpenVMS
OpenVMS Itanium
Apple Mac OS
Mac OS X Server
Solaris Operating System (x86)
Solaris Operating System (x86)
IBM Power Based Linux
Linux on Power
Solaris Operating System (AMD64)
Solaris Operating System
参考至：http://blog.csdn.net/tianlesoftware/article/details/7241488
如有错误，欢迎指正
浏览: 2978363 次
来自: 厦门
谢谢非常有用那
写的很详细
学习了，学习了
大写的赞..
作为初学者，我表示写得非常好，正在疑惑这些参数的意义呢！
(window.slotbydup=window.slotbydup || []).push({
id: '4773203',
container: s,
size: '200,200',
display: 'inlay-fix'阅读(1091)
【DATAGUARD】物理dg配置客户端无缝切换 (八.1)--Data Guard Broker 的配置
一.1  BLOG文档结构图
一.2  前言部分
一.2.1  
各位技术爱好者，看完本文后，你可以掌握如下的技能，也可以学到一些其它你所不知道的知识，~O(∩_∩)O~：
① Data Guard Broker 的配置
② Fast-Start Failover 的配置
③ Oracle DataGuard 之客户端TAF 配置
④ 使用DGMGRL 来管理数据库
⑤ 物理dg管理和维护的一些sql
⑥ DataGuard 客户端特级配置
  List of Archived Logs in backup set 11
  Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  ---- ------- ---------- ------------------- ---------- ---------
  1    32      0;  
11:09:52 0;  
  1    33      0;  
11:15:48 0;  
  2    42      0;  
10:41:18 0;  
  2    43      0;  
11:15:49 0;  
本文如有错误或不完善的地方请大家多多指正，ITPUB留言或QQ皆可，您的批评指正是我写作的最大动力。
一.2.2  
一.2.3  
【DATAGUARD】 基于同一个主机建立物理备库和逻辑备库（一）：
【DATAGUARD】 基于同一个主机建立物理备库和逻辑备库（二 ): 
【DATAGUARD】 基于同一个主机建立物理备库和逻辑备库（三 ): 
【DATAGUARD】 基于同一个主机建立物理备库和逻辑备库 (四)--添加一个物理dg节点 ：
【DATAGUARD】物理dg的switchover切换（五） ：
：  
 ： http://blog.itpub.net//viewspace-1780863/
一.2.4  
一.3  相关知识点扫盲
一.4  实验部分
一.4.1  
一.4.2  
alter system set dg_broker_start=true scope=
[oracle@rhel6_lhr lhr]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on 星期一 9月 28 10:17:04 2015
Copyright (c) , Oracle.  All rights reserved.
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
10:17:04 SQL& show parameter name
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_file_name_convert                 string      oradglg, oradg11g
db_name                              string      oradg11g
db_unique_name                       string      oradg11g
global_names                         boolean     FALSE
instance_name                        string      oradg11g
lock_name_space                      string
log_file_name_convert                string      oradglg, oradg11g
processor_group_name                 string
service_names                        string      oradg11g
10:17:08 SQL& show parameter spfile
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string      /u01/app/oracle/product/11.2.0
                                                 /dbhome_1/dbs/spfileoradg11g.o
                                                 ra
10:17:14 SQL&  show parameter DG_BROKER_CONFIG_FILE
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
dg_broker_config_file1               string      /u01/app/oracle/product/11.2.0
                                                 /dbhome_1/dbs/dr1oradg11g.dat
dg_broker_config_file2               string      /u01/app/oracle/product/11.2.0
                                                 /dbhome_1/dbs/dr2oradg11g.dat
10:20:43 SQL& set line 9999
10:20:44 SQL& col name format a10
10:20:44 SQL& col FS_FAILOVER_OBSERVER_HOST format a20
10:20:44 SQL& select dbid,name,current_scn,protection_mode,protection_level,database_role,force_logging,open_mode,switchover_status from v$
      DBID NAME       CURRENT_SCN PROTECTION_MODE      PROTECTION_LEVEL     DATABASE_ROLE    FOR OPEN_MODE            SWITCHOVER_STATUS
---------- ---------- ----------- -------------------- -------------------- ---------------- --- -------------------- --------------------
ORADG11G       2336836 MAXIMUM PERFORMANCE  MAXIMUM PERFORMANCE  PRIMARY          YES READ WRITE           TO STANDBY
已用时间:  00: 00: 00.01
10:20:44 SQL& SELECT d.DBID,
10:20:44   2         d.DB_UNIQUE_NAME,
10:20:44   3         d.FORCE_LOGGING,
10:20:44   4         d.FLASHBACK_ON,
10:20:44   5         d.FS_FAILOVER_STATUS,
10:20:44   6         d.FS_FAILOVER_CURRENT_TARGET,
10:20:44   7         d.FS_FAILOVER_THRESHOLD,
10:20:44   8         d.FS_FAILOVER_OBSERVER_PRESENT,
10:20:44   9         d.FS_FAILOVER_OBSERVER_HOST
10:20:44  10    FROM v$
      DBID DB_UNIQUE_NAME                 FOR FLASHBACK_ON       FS_FAILOVER_STATUS     FS_FAILOVER_CURRENT_TARGET     FS_FAILOVER_THRESHOLD FS_FAIL FS_FAILOVER_OBSERVER
---------- ------------------------------ --- ------------------ ---------------------- ------------------------------ --------------------- ------- --------------------
oradg11g                       YES YES                DISABLED                                                                  0
已用时间:  00: 00: 00.00
10:20:45 SQL&
10:20:45 SQL& ! ps -ef|grep dmon
oracle    ; ; 0 10:21 pts/4    00:00:00 /bin/bash -c  ps -ef|grep dmon
oracle    ; ; 0 10:21 pts/4    00:00:00 grep dmon
10:21:17 SQL& show parameter dg_broker
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
dg_broker_config_file1               string      /u01/app/oracle/product/11.2.0
                                                 /dbhome_1/dbs/dr1oradg11g.dat
dg_broker_config_file2               string      /u01/app/oracle/product/11.2.0
                                                 /dbhome_1/dbs/dr2oradg11g.dat
dg_broker_start                      boolean     FALSE
10:21:39 SQL& show parameter dg_broker_start
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
dg_broker_start                      boolean     FALSE
10:21:53 SQL& alter system set dg_broker_start=true scope=
系统已更改。
已用时间:  00: 00: 00.02
10:21:56 SQL& ! ps -ef|grep dmon
oracle    ;    1  0 10:21 ?        00:00:00 ora_dmon_oradg11g
oracle    ; ; 0 10:22 pts/4    00:00:00 /bin/bash -c  ps -ef|grep dmon
oracle    ; ; 0 10:22 pts/4    00:00:00 grep dmon
10:22:02 SQL&
10:22:02 SQL& show parameter dg_broker_start
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
dg_broker_start                      boolean     TRUE
10:23:48 SQL& set line 9999
10:23:58 SQL& col name format a10
10:23:58 SQL& col FS_FAILOVER_OBSERVER_HOST format a20
10:23:58 SQL& select dbid,name,current_scn,protection_mode,protection_level,database_role,force_logging,open_mode,switchover_status from v$
      DBID NAME       CURRENT_SCN PROTECTION_MODE      PROTECTION_LEVEL     DATABASE_ROLE    FOR OPEN_MODE            SWITCHOVER_STATUS
---------- ---------- ----------- -------------------- -------------------- ---------------- --- -------------------- --------------------
ORADG11G       2337043 MAXIMUM PERFORMANCE  MAXIMUM PERFORMANCE  PRIMARY          YES READ WRITE           TO STANDBY
已用时间:  00: 00: 00.01
10:23:58 SQL& SELECT d.DBID,
10:23:58   2         d.DB_UNIQUE_NAME,
10:23:58   3         d.FORCE_LOGGING,
10:23:58   4         d.FLASHBACK_ON,
10:23:58   5         d.FS_FAILOVER_STATUS,
10:23:58   6         d.FS_FAILOVER_CURRENT_TARGET,
10:23:58   7         d.FS_FAILOVER_THRESHOLD,
10:23:58   8         d.FS_FAILOVER_OBSERVER_PRESENT,
10:23:58   9         d.FS_FAILOVER_OBSERVER_HOST
10:23:58  10    FROM v$
      DBID DB_UNIQUE_NAME                 FOR FLASHBACK_ON       FS_FAILOVER_STATUS     FS_FAILOVER_CURRENT_TARGET     FS_FAILOVER_THRESHOLD FS_FAIL FS_FAILOVER_OBSERVER
---------- ------------------------------ --- ------------------ ---------------------- ------------------------------ --------------------- ------- --------------------
oradg11g                       YES YES                DISABLED                                                                  0
已用时间:  00: 00: 00.00
10:24:00 SQL&
Mon Sep 28 10:21:56 2015
ALTER SYSTEM SET dg_broker_start=TRUE SCOPE=BOTH;
Mon Sep 28 10:21:56 2015
DMON started with pid=37, OS id=7975
Starting Data Guard Broker (DMON)
Mon Sep 28 10:22:04 2015
INSV started with pid=38, OS id=7984
[oracle@rhel6_lhr ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on 星期一 9月 28 10:25:25 2015
Copyright (c) , Oracle.  All rights reserved.
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
10:25:25 SQL& show parameter name
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_file_name_convert                 string      oradg11g, oradgphy
db_name                              string      oradg11g
db_unique_name                       string      oradgphy
global_names                         boolean     FALSE
instance_name                        string      oradgphy
lock_name_space                      string
log_file_name_convert                string      oradg11g, oradgphy
processor_group_name                 string
service_names                        string      oradgphy
10:25:27 SQL&  show parameter spfile
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string      /u01/app/oracle/product/11.2.0
                                                 /dbhome_1/dbs/spfileoradgphy.o
                                                 ra
10:25:35 SQL& show parameter DG_BROKER_CONFIG_FILE
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
dg_broker_config_file1               string      /u01/app/oracle/product/11.2.0
                                                 /dbhome_1/dbs/dr1oradgphy.dat
dg_broker_config_file2               string      /u01/app/oracle/product/11.2.0
                                                 /dbhome_1/dbs/dr2oradgphy.dat
10:25:43 SQL& set line 9999
10:25:51 SQL& col name format a10
10:25:51 SQL& col FS_FAILOVER_OBSERVER_HOST format a20
10:25:51 SQL& select dbid,name,current_scn,protection_mode,protection_level,database_role,force_logging,open_mode,switchover_status from v$
SELECT d.DBID,
       d.DB_UNIQUE_NAME,
       d.FORCE_LOGGING,
       d.FLASHBACK_ON,
       d.FS_FAILOVER_STATUS,
      DBID NAME       CURRENT_SCN PROTECTION_MODE      PROTECTION_LEVEL     DATABASE_ROLE    FOR OPEN_MODE            SWITCHOVER_STATUS
---------- ---------- ----------- -------------------- -------------------- ---------------- --- -------------------- --------------------
ORADG11G       2337499 MAXIMUM PERFORMANCE  MAXIMUM PERFORMANCE  PHYSICAL STANDBY YES READ ONLY WITH APPLY NOT ALLOWED
已用时间:  00: 00: 00.11
10:25:52 SQL& 10:25:52   2  10:25:52   3  10:25:52   4  10:25:52   5  10:25:52   6         d.FS_FAILOVER_CURRENT_TARGET,
10:25:52   7         d.FS_FAILOVER_THRESHOLD,
10:25:52   8         d.FS_FAILOVER_OBSERVER_PRESENT,
10:25:52   9         d.FS_FAILOVER_OBSERVER_HOST
10:25:52  10    FROM v$
      DBID DB_UNIQUE_NAME                 FOR FLASHBACK_ON       FS_FAILOVER_STATUS     FS_FAILOVER_CURRENT_TARGET     FS_FAILOVER_THRESHOLD FS_FAIL FS_FAILOVER_OBSERVER
---------- ------------------------------ --- ------------------ ---------------------- ------------------------------ --------------------- ------- --------------------
oradgphy                       YES NO                 DISABLED                                                                  0
已用时间:  00: 00: 00.00
10:25:56 SQL&  ! ps -ef|grep dmon
oracle    ;    1  0 10:21 ?        00:00:00 ora_dmon_oradg11g
oracle    ; ; 0 10:26 pts/5    00:00:00 /bin/bash -c  ps -ef|grep dmon
oracle    ; ; 0 10:26 pts/5    00:00:00 grep dmon
10:26:07 SQL&  show parameter dg_broker_start
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
dg_broker_start                      boolean     FALSE
10:26:39 SQL&
alter system set dg_broker_start=true scope=
系统已更改。
已用时间:  00: 00: 00.05
10:26:46 SQL&  ! ps -ef|grep dmon
oracle    ;    1  0 10:21 ?        00:00:00 ora_dmon_oradg11g
oracle    ;    1  0 10:26 ?        00:00:00 ora_dmon_oradgphy
oracle    ; ; 0 10:26 pts/5    00:00:00 /bin/bash -c  ps -ef|grep dmon
oracle    ; ; 0 10:26 pts/5    00:00:00 grep dmon
10:26:50 SQL&
一.4.2.1  配置db_domain 和  listener 及 tnsnames
db_unique_name_DGMGRL.db_domain
14:05:05 SQL&  show parameter db_domain 
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_domain                            string
14:13:46 SQL& alter system set db_domain='lhr.com' scope=
[oracle@rhel6_lhr admin]$ lsnrctl status
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 28-9月 -:27
Copyright (c) , Oracle.  All rights reserved.
正在连接到 (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.59.130)(PORT=1521)))
LISTENER 的 STATUS
------------------------
别名                      LISTENER
版本                      TNSLSNR for Linux: Version 11.2.0.3.0 - Production
启动日期                  28-9月 -:08
正常运行时间              0 天 0 小时 33 分 18 秒
跟踪级别                  off
安全性                    ON: Local OS Authentication
SNMP                      OFF
监听程序参数文件          /u01/app/grid/11.2.0/network/admin/listener.ora
监听端点概要...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.59.130)(PORT=1521)))
服务摘要..
服务 &+ASM& 包含 1 个实例。
  实例 &+ASM&, 状态 READY, 包含此服务的 1 个处理程序...
服务 &PLSExtProc& 包含 1 个实例。
  实例 &PLSExtProc&, 状态 UNKNOWN, 包含此服务的 1 个处理程序...
服务 &ora11g& 包含 1 个实例。
  实例 &ora11g&, 状态 UNKNOWN, 包含此服务的 1 个处理程序...
服务 &oradg11g& 包含 1 个实例。
  实例 &oradg11g&, 状态 UNKNOWN, 包含此服务的 1 个处理程序...
服务 &oradg11g.lhr.com& 包含 2 个实例。
  实例 &oradg11g&, 状态 UNKNOWN, 包含此服务的 1 个处理程序...
  实例 &oradg11g&, 状态 READY, 包含此服务的 1 个处理程序...
服务 &oradg11gXDB.lhr.com& 包含 2 个实例。
  实例 &oradg11g&, 状态 READY, 包含此服务的 1 个处理程序...
  实例 &oradgphy&, 状态 READY, 包含此服务的 1 个处理程序...
服务 &oradg11g_DGB.lhr.com& 包含 1 个实例。
  实例 &oradg11g&, 状态 READY, 包含此服务的 1 个处理程序...
服务 &oradg11g_DGMGRL.lhr.com& 包含 1 个实例。
  实例 &oradg11g&, 状态 UNKNOWN, 包含此服务的 1 个处理程序...
服务 &oradglg& 包含 1 个实例。
  实例 &oradglg&, 状态 UNKNOWN, 包含此服务的 1 个处理程序...
服务 &oradgphy& 包含 1 个实例。
  实例 &oradgphy&, 状态 UNKNOWN, 包含此服务的 1 个处理程序...
服务 &oradgphy.lhr.com& 包含 2 个实例。
  实例 &oradgphy&, 状态 UNKNOWN, 包含此服务的 1 个处理程序...
  实例 &oradgphy&, 状态 READY, 包含此服务的 1 个处理程序...
服务 &oradgphy_DGB.lhr.com& 包含 1 个实例。
  实例 &oradgphy&, 状态 READY, 包含此服务的 1 个处理程序...
服务 &oradgphy_DGMGRL.lhr.com& 包含 1 个实例。
  实例 &oradgphy&, 状态 UNKNOWN, 包含此服务的 1 个处理程序...
服务 &oradgss& 包含 1 个实例。
  实例 &oradgss&, 状态 UNKNOWN, 包含此服务的 1 个处理程序...
服务 &orclasm.lhr.com& 包含 1 个实例。
  实例 &orclasm&, 状态 UNKNOWN, 包含此服务的 1 个处理程序...
命令执行成功
[oracle@rhel6_lhr admin]$ more /u01/app/grid/11.2.0/network/admin/listener.ora
# listener.ora Network Configuration File: /u01/app/grid/11.2.0/network/admin/listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = orclasm.lhr.com)
      (SID_NAME = orclasm)
      (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
    )
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
      (PROGRAM = extproc)
    )
  (SID_DESC =
    (GLOBAL_DBNAME = oradg11g)
    (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
    (SID_NAME= oradg11g)
  (SID_DESC =
    (GLOBAL_DBNAME = oradgphy)
    (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
    (SID_NAME= oradgphy)
  (SID_DESC =
    (GLOBAL_DBNAME = oradglg)
    (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
    (SID_NAME= oradglg)
  (SID_DESC =
    (GLOBAL_DBNAME = oradgss)
    (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
    (SID_NAME= oradgss)
  (SID_DESC =
    (GLOBAL_DBNAME = ora11g)
    (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
    (SID_NAME= ora11g)
    (SID_DESC =
    (GLOBAL_DBNAME = oradg11g.lhr.com)
    (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
    (SID_NAME= oradg11g)
  (SID_DESC =
    (GLOBAL_DBNAME = oradgphy.lhr.com)
    (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
    (SID_NAME= oradgphy)
  (SID_DESC =
    (GLOBAL_DBNAME = oradg11g_DGMGRL.lhr.com)
    (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
    (SID_NAME= oradg11g)
  (SID_DESC =
    (GLOBAL_DBNAME = oradgphy_DGMGRL.lhr.com)
    (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
    (SID_NAME= oradgphy)
LOGGING_LISTENER = OFF
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.59.130)(PORT = 1521))
    )
ADR_BASE_LISTENER = /u01/app/grid
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER = ON
#TRACE_LEVEL_LISTENER = OFF
[oracle@rhel6_lhr admin]$
[oracle@rhel6_lhr admin]$ more tnsnames.ora
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
tns_oradg11g_DGMGRL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.59.130)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = oradg11g_DGMGRL.lhr.com)
    )
tns_oradgphy_DGMGRL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.59.130)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = oradgphy_DGMGRL.lhr.com)
    )
tns_oradg11g =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.59.130)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = oradg11g)
    )
tns_oradgphy =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.59.130)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = oradgphy)
    )
tns_oradglg =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.59.130)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = oradglg)
    )
一.4.3  
[oracle@rhel6_lhr ~]$ dgmgrl
DGMGRL for Linux: Version 11.2.0.3.0 - 64bit Production
Copyright (c) , Oracle. All rights reserved.
欢迎使用 DGMGRL, 要获取有关信息请键入 &help&。
DGMGRL& help
可使用以下命令:
add            在中介配置中添加备用数据库
connect        连接到 Oracle 数据库实例
convert        将数据库从一种类型转换为另一种
create         创建中介配置
disable        禁用配置, 数据库或快速启动故障转移
edit           编辑配置, 数据库或实例
enable         启用配置, 数据库或快速启动故障转移
exit           退出程序
failover       将备用数据库更改为主数据库
help           显示命令的说明和语法
quit           退出程序
reinstate      将标记为恢复的数据库更改为可行的备用数据库
rem            DGMGRL 会忽略注释
remove         删除配置, 数据库或实例
show           显示有关配置, 数据库或实例的信息
shutdown       关闭当前正在运行的 Oracle 数据库实例
sql            执行 SQL 语句
start          启动快速启动故障转移观察程序
startup        启动 Oracle 数据库实例
stop           停止快速启动故障转移观察程序
switchover     在主数据库和备用数据库之间切换角色
使用 &help &command&& 可以查看各个命令的语法
DGMGRL& connect sys/lhr@tns_oradg11g_dgmgrl
DGMGRL& show configuration
ORA-16532: Data Guard 中介配置不存在
配置详细资料不能由 DGMGRL 确定
DGMGRL& help create 
创建中介配置
  CREATE CONFIGURATION &configuration name& AS
    PRIMARY DATABASE IS &database name&
    CONNECT IDENTIFIER IS &connect identifier&;
DGMGRL& create configuration 'fsf_oradg11g_lhr' as
& primary database is 'oradg11g'
& connect identifier is tns_oradg11g_dgmgrl;
已创建配置 &fsf_oradg11g_lhr&, 其中主数据库为 &oradg11g&
DGMGRL& show configuration
配置 - fsf_oradg11g_lhr
  保护模式:        MaxPerformance
  数据库:
    oradg11g - 主数据库
快速启动故障转移: DISABLED
DGMGRL& add database 'oradgphy' as
& connect identifier is tns_oradgphy_dgmgrl
已添加数据库 &oradgphy&
DGMGRL& show configuration
配置 - fsf_oradg11g_lhr
  保护模式:        MaxPerformance
  数据库:
    oradg11g - 主数据库
    oradgphy - 物理备用数据库
快速启动故障转移: DISABLED
DGMGRL& enable configuration
DGMGRL& show configuration
配置 - fsf_oradg11g_lhr
  保护模式:        MaxPerformance
  数据库:
    oradg11g - 主数据库
    oradgphy - 物理备用数据库
快速启动故障转移: DISABLED
show database verbose oradg11g
数据库 - oradg11g
  角色:            PRIMARY
  预期状态:        TRANSPORT-ON
  实例:
    oradg11g
  属性:
    DGConnectIdentifier             = 'tns_oradg11g_dgmgrl'
    ObserverConnectIdentifier       = ''
    LogXptMode                      = 'ASYNC'
    DelayMins                       = '0'
    Binding                         = 'OPTIONAL'
    MaxFailure                      = '0'
    MaxConnections                  = '1'
    ReopenSecs                      = '300'
    NetTimeout                      = '30'
    RedoCompression                 = 'DISABLE'
    LogShipping                     = 'ON'
    PreferredApplyInstance          = ''
    ApplyInstanceTimeout            = '0'
    ApplyParallel                   = 'AUTO'
    StandbyFileManagement           = 'AUTO'
    ArchiveLagTarget                = '0'
    LogArchiveMaxProcesses          = '4'
    LogArchiveMinSucceedDest        = '1'
    DbFileNameConvert               = 'oradgphy, oradg11g'
    LogFileNameConvert              = 'oradgphy, oradg11g'
    FastStartFailoverTarget         = ''
    InconsistentProperties          = '(monitor)'
    InconsistentLogXptProps         = '(monitor)'
    SendQEntries                    = '(monitor)'
    LogXptStatus                    = '(monitor)'
    RecvQEntries                    = '(monitor)'
    SidName                         = 'oradg11g'
    StaticConnectIdentifier         = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=rhel6_lhr)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=oradg11g_DGMGRL.lhr.com)(INSTANCE_NAME=oradg11g)(SERVER=DEDICATED)))'
    StandbyArchiveLocation          = 'USE_DB_RECOVERY_FILE_DEST'
    AlternateLocation               = ''
    LogArchiveTrace                 = '0'
    LogArchiveFormat                = '%t_%s_%r.dbf'
    TopWaitEvents                   = '(monitor)'
数据库状态:
DGMGRL&  show database verbose oradgphy
数据库 - oradgphy
  角色:            PHYSICAL STANDBY
  预期状态:        APPLY-ON
  传输滞后:        0 秒
  应用滞后:        0 秒
  实时查询:        ON
  实例:
    oradgphy
  属性:
    DGConnectIdentifier             = 'tns_oradgphy_dgmgrl'
    ObserverConnectIdentifier       = ''
    LogXptMode                      = 'ASYNC'
    DelayMins                       = '0'
    Binding                         = 'optional'
    MaxFailure                      = '0'
    MaxConnections                  = '1'
    ReopenSecs                      = '300'
    NetTimeout                      = '30'
    RedoCompression                 = 'DISABLE'
    LogShipping                     = 'ON'
    PreferredApplyInstance          = ''
    ApplyInstanceTimeout            = '0'
    ApplyParallel                   = 'AUTO'
    StandbyFileManagement           = 'AUTO'
    ArchiveLagTarget                = '0'
    LogArchiveMaxProcesses          = '4'
    LogArchiveMinSucceedDest        = '1'
    DbFileNameConvert               = 'oradg11g, oradgphy'
    LogFileNameConvert              = 'oradg11g, oradgphy'
    FastStartFailoverTarget         = ''
    InconsistentProperties          = '(monitor)'
    InconsistentLogXptProps         = '(monitor)'
    SendQEntries                    = '(monitor)'
    LogXptStatus                    = '(monitor)'
    RecvQEntries                    = '(monitor)'
    SidName                         = 'oradgphy'
    StaticConnectIdentifier         = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=rhel6_lhr)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=oradgphy_DGMGRL.lhr.com)(INSTANCE_NAME=oradgphy)(SERVER=DEDICATED)))'
    StandbyArchiveLocation          = 'USE_DB_RECOVERY_FILE_DEST'
    AlternateLocation               = ''
    LogArchiveTrace                 = '0'
    LogArchiveFormat                = '%t_%s_%r.dbf'
    TopWaitEvents                   = '(monitor)'
数据库状态:
Mon Sep 28 15:20:28 2015
NSV1 started with pid=30, OS id=25660
Mon Sep 28 15:20:54 2015
ALTER SYSTEM SET log_archive_config='dg_config=(oradg11g,oradgphy)' SCOPE=BOTH;
Mon Sep 28 15:20:57 2015
ALTER SYSTEM SET log_archive_dest_2='service=&tns_oradgphy_dgmgrl&','LGWR ASYNC NOAFFIRM delay=0 optional compression=disable max_failure=0 max_connections=1 reopen=300 db_unique_name=&oradgphy& net_timeout=30','valid_for=(all_logfiles,primary_role)' SCOPE=BOTH;
ALTER SYSTEM SET log_archive_trace=0 SCOPE=BOTH SID='oradg11g';
ALTER SYSTEM SET log_archive_format='%t_%s_%r.dbf' SCOPE=SPFILE SID='oradg11g';
ALTER SYSTEM SET standby_file_management='AUTO' SCOPE=BOTH SID='*';
ALTER SYSTEM SET archive_lag_target=0 SCOPE=BOTH SID='*';
ALTER SYSTEM SET log_archive_max_processes=4 SCOPE=BOTH SID='*';
ALTER SYSTEM SET log_archive_min_succeed_dest=1 SCOPE=BOTH SID='*';
ALTER SYSTEM SET db_file_name_convert='oradgphy','oradg11g' SCOPE=SPFILE;
ALTER SYSTEM SET log_file_name_convert='oradgphy','oradg11g' SCOPE=SPFILE;
ALTER SYSTEM ARCHIVE LOG
Mon Sep 28 15:20:57 2015
NSA2 started with pid=34, OS id=25706
NSV0 started with pid=21, OS id=25696
Mon Sep 28 15:20:57 2015
ALTER SYSTEM SET log_archive_trace=0 SCOPE=BOTH SID='oradgphy';
ALTER SYSTEM SET log_archive_format='%t_%s_%r.dbf' SCOPE=SPFILE SID='oradgphy';
ALTER SYSTEM SET standby_file_management='AUTO' SCOPE=BOTH SID='*';
ALTER SYSTEM SET archive_lag_target=0 SCOPE=BOTH SID='*';
ALTER SYSTEM SET log_archive_max_processes=4 SCOPE=BOTH SID='*';
ALTER SYSTEM SET log_archive_min_succeed_dest=1 SCOPE=BOTH SID='*';
ALTER SYSTEM SET db_file_name_convert='oradg11g','oradgphy' SCOPE=SPFILE;
ALTER SYSTEM SET log_file_name_convert='oradg11g','oradgphy' SCOPE=SPFILE;
ALTER SYSTEM SET fal_server='tns_oradg11g_dgmgrl' SCOPE=BOTH;
Mon Sep 28 15:21:01 2015
Primary database is in MAXIMUM PERFORMANCE mode
RFS[4]: Assigned to RFS process 25708
RFS[4]: Selected log 4 for thread 1 sequence 145 dbid
一.4.4  
DGMGRL& show configuration
配置 - fsf_oradg11g_lhr
  保护模式:        MaxPerformance
  数据库:
    oradg11g - 主数据库
    oradgphy - 物理备用数据库
快速启动故障转移: DISABLED
DGMGRL& sw
立即执行切换, 请稍候...
新的主数据库 &oradgphy& 正在打开...
操作要求关闭实例 &oradg11g& (在数据库 &oradg11g& 上)
正在关闭实例 &oradg11g&...
ORACLE 例程已经关闭。
操作要求启动实例 &oradg11g& (在数据库 &oradg11g& 上)
正在启动实例 &oradg11g&...
ORACLE 例程已经启动。
数据库装载完毕。
数据库已经打开。
切换成功, 新的主数据库为 &oradgphy&
DGMGRL& show configuration
配置 - fsf_oradg11g_lhr
  保护模式:        MaxPerformance
  数据库:
    oradgphy - 主数据库
    oradg11g - 物理备用数据库
快速启动故障转移: DISABLED
DGMGRL& switchover to oradg11g;
立即执行切换, 请稍候...
新的主数据库 &oradg11g& 正在打开...
操作要求关闭实例 &oradgphy& (在数据库 &oradgphy& 上)
正在关闭实例 &oradgphy&...
ORACLE 例程已经关闭。
操作要求启动实例 &oradgphy& (在数据库 &oradgphy& 上)
正在启动实例 &oradgphy&...
ORACLE 例程已经启动。
数据库装载完毕。
数据库已经打开。
切换成功, 新的主数据库为 &oradg11g&
DGMGRL& show configuration
配置 - fsf_oradg11g_lhr
  保护模式:        MaxPerformance
  数据库:
    oradg11g - 主数据库
    oradgphy - 物理备用数据库
快速启动故障转移: DISABLED
Mon Sep 28 15:26:24 2015
ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY WITH SESSION SHUTDOWN
ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY [Process Id: 23943] (oradg11g)
Mon Sep 28 15:26:24 2015
Thread 1 advanced to log sequence 146 (LGWR switch)
  Current log# 2 seq# 146 mem# 0: /u01/app/oracle/oradata/oradg11g/redo02.log
Mon Sep 28 15:26:24 2015
Stopping background process CJQ0
Stopping background process QMNC
Stopping Job queue slave processes, flags = 27
Mon Sep 28 15:26:27 2015
Archived Log entry 501 added for thread 1 sequence 145 ID 0x5495956b dest 1:
Waiting for Job queue slaves to complete
Job queue slave processes stopped
All dispatchers and shared servers shutdown
CLOSE: killing server sessions.
Active process 25846 user 'oracle' program 'oracle@rhel6_lhr (W000)'
Active process 25846 user 'oracle' program 'oracle@rhel6_lhr (W000)'
Active process 25846 user 'oracle' program 'oracle@rhel6_lhr (W000)'
Active process 25846 user 'oracle' program 'oracle@rhel6_lhr (W000)'
Active process 25846 user 'oracle' program 'oracle@rhel6_lhr (W000)'
Active process 25846 user 'oracle' program 'oracle@rhel6_lhr (W000)'
Active process 25846 user 'oracle' program 'oracle@rhel6_lhr (W000)'
Active process 25846 user 'oracle' program 'oracle@rhel6_lhr (W000)'
Active process 25846 user 'oracle' program 'oracle@rhel6_lhr (W000)'
Active process 25846 user 'oracle' program 'oracle@rhel6_lhr (W000)'
Active process 25846 user 'oracle' program 'oracle@rhel6_lhr (W000)'
Active process 25846 user 'oracle' program 'oracle@rhel6_lhr (W000)'
Active process 25846 user 'oracle' program 'oracle@rhel6_lhr (W000)'
Active process 25846 user 'oracle' program 'oracle@rhel6_lhr (W000)'
Active process 25846 user 'oracle' program 'oracle@rhel6_lhr (W000)'
Active process 25846 user 'oracle' program 'oracle@rhel6_lhr (W000)'
Active process 25846 user 'oracle' program 'oracle@rhel6_lhr (W000)'
Active process 25846 user 'oracle' program 'oracle@rhel6_lhr (W000)'
Active process 25846 user 'oracle' program 'oracle@rhel6_lhr (W000)'
Active process 25846 user 'oracle' program 'oracle@rhel6_lhr (W000)'
Active process 25846 user 'oracle' program 'oracle@rhel6_lhr (W000)'
Active process 25846 user 'oracle' program 'oracle@rhel6_lhr (W000)'
Active process 25846 user 'oracle' program 'oracle@rhel6_lhr (W000)'
Active process 25846 user 'oracle' program 'oracle@rhel6_lhr (W000)'
Active process 25846 user 'oracle' program 'oracle@rhel6_lhr (W000)'
Active process 25846 user 'oracle' program 'oracle@rhel6_lhr (W000)'
Active process 25846 user 'oracle' program 'oracle@rhel6_lhr (W000)'
Active process 25846 user 'oracle' program 'oracle@rhel6_lhr (W000)'
Active process 25846 user 'oracle' program 'oracle@rhel6_lhr (W000)'
Active process 25846 user 'oracle' program 'oracle@rhel6_lhr (W000)'
CLOSE: all sessions shutdown successfully.
Waiting for all non-current ORLs to be archived...
All non-current ORLs have been archived.
Waiting for all FAL entries to be archived...
All FAL entries have been archived.
Waiting for dest_id 2 to become synchronized...
Active, synchronized Physical Standby switchover target has been identified
Switchover End-Of-Redo Log thread 1 sequence 146 has been fixed
Switchover: Primary highest seen SCN set to 0x0.0x262c94
ARCH: Noswitch archival of thread 1, sequence 146
ARCH: End-Of-Redo Branch archival of thread 1 sequence 146
ARCH: LGWR is actively archiving destination LOG_ARCHIVE_DEST_2
ARCH: Standby redo logfile selected for thread 1 sequence 146 for destination LOG_ARCHIVE_DEST_2
Archived Log entry 502 added for thread 1 sequence 146 ID 0x5495956b dest 1:
ARCH: Archiving is disabled due to current logfile archival
Primary will check for some target standby to have received alls redo
Final check for a synchronized target standby. Check will be made once.
Archive destination LOG_ARCHIVE_DEST_3 invalidated
DB_UNIQUE_NAME oradglg is not in the Data Guard configuration
Archive destination LOG_ARCHIVE_DEST_4 invalidated
DB_UNIQUE_NAME oradgss is not in the Data Guard configuration
LOG_ARCHIVE_DEST_2 is a potential Physical Standby switchover target
Active, synchronized target has been identified
Target has also received all redo
Backup controlfile written to trace file /u01/app/oracle/diag/rdbms/oradg11g/oradg11g/trace/oradg11g_rsm0_23943.trc
Clearing standby activation ID
(0x5495956b)
The primary database controlfile was created using the
'MAXLOGFILES 16' clause.
There is space for up to 13 standby redo logfiles
Use the following SQL commands on the standby database to create
standby redo logfiles that match the primary database:
ALTER DATABASE ADD STANDBY LOGFILE 'srl1.f' SIZE ;
ALTER DATABASE ADD STANDBY LOGFILE 'srl2.f' SIZE ;
ALTER DATABASE ADD STANDBY LOGFILE 'srl3.f' SIZE ;
ALTER DATABASE ADD STANDBY LOGFILE 'srl4.f' SIZE ;
Archivelog for thread 1 sequence 146 required for standby recovery
Switchover: Primary controlfile converted to standby controlfile succesfully.
Switchover: Complete - Database shutdown required
Completed: ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY WITH SESSION SHUTDOWN
Mon Sep 28 15:26:37 2015
Performing implicit shutdown abort due to switchover to physical standby
Shutting down instance (abort)
License high water mark = 8
USER (ospid: 26018): terminating the instance
Instance terminated by USER, pid = 26018
Mon Sep 28 15:26:38 2015
Instance shutdown complete
ORA-1092 : opitsk aborting process
Mon Sep 28 15:26:38 2015
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Archive destination LOG_ARCHIVE_DEST_3 invalidated
DB_UNIQUE_NAME oradglg is not in the Data Guard configuration
Archive destination LOG_ARCHIVE_DEST_4 invalidated
DB_UNIQUE_NAME oradgss is not in the Data Guard configuration
Autotune of undo retention is turned on.
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1
System name:    Linux
Node name:      rhel6_lhr
Release:        2.6.32-504.16.2.el6.x86_64
Version:        #1 SMP Tue Apr 21 08:37:59 PDT 2015
Machine:        x86_64
VM name:        VMWare Version: 6
Using parameter settings in server-side spfile /u01/app/oracle/product/11.2.0/dbhome_1/dbs/spfileoradg11g.ora
System parameters with non-default values:
  processes                = 150
  memory_target            = 300M
  memory_max}
我要回帖
更多关于 七秀技能喊话 的文章
更多推荐
- ·魔剑侠传奇正派和邪派哪个好紫阳加点(魔剑侠传奇正派和邪派哪个好怪物克星职业：紫阳)介绍_魔剑侠传奇正派和邪派哪个好紫阳加点(魔剑侠传奇正派和邪派哪个好怪物克星职业：紫阳)是什么
- ·05345051095属于0534开头的是什么电话号码？
- ·孩子不想上学了高情商说什么话放假啦！幽默金句来袭
- ·赌博看场对于参赌人员的处罚怎样处理
- ·《龙腾世纪1斯坦个人任务2》过石头人Boss的最简单有效办法！介绍_《龙腾世纪1斯坦个人任务2》过石头人Boss的最简单有效办法！是什么
- ·谁有付壮壮的《再见恶魔完整版》完整版 无删节版？
- ·暗黑复仇者2破解自己创建工会好处
- ·怎么开启一段unity哪鹅的奇幻之旅 动漫
- ·海信led50k2200怎么调清一点
- ·现在地下城能双开吗怎么双开好。？老是开了就卡死，还有说运行中的！
- ·17175官方下载游戏破解求高手帮助
- ·我应该去爱你歌词怎么样子回答呢？请爱请高手帮帮我解答一下
- ·红警3 d3dx9 35.dllTurretCount=9什么意思
- ·古墓丽影周年纪念版十周年纪念版好用的修改器,
- ·6228481316750628561是什么地方的帐号登录爱奇艺地方
- ·请问，谁玩过单挑王游戏？它筹码的下浮比例怎么算是怎么算的。
- ·傻儿传奇2之抗战到底中王竹山是谁演的？
- ·玩网络游戏经常有“wow帧数低怎么解决限制”到底需不需要限制？
- ·lol一键喊话怎么用器上的64dg能用什么代替
- ·后援团需要支付多少炫舞炫贝怎么获得可以创建
- ·5s怎么连苹果5s收不到彩信米四的热点
- ·一将成名2013里面的密码怎么改?
- ·在YY直播90888那个5元3万yylol点券券的各位知道吗
- ·qq炫舞地鼠里打地鼠!请问什么是坏地鼠长什么样子
- ·幸运饼 有哪些平台,【喜微信公众平台官网网】 平台多
- ·植物大战僵尸全明星吧闪电芦苇怎么得
- ·lr录制脚本为空的时候，禁止了插件的的打开导致流程不能往下走怎么办
- ·魔兽世界报错，按照上面说的还是解决不了苦恼，求大神f1帮帮我
- ·天天飞车金橘子凯瑟琳好还是暗影橘子好
- ·求 迅 雷 爱奇艺vip共享享
- ·天天飞车破解版下载1.7.5.4111版本最新破解版
- ·qq360斗地主赢话费手机话费购买上限是多少
- ·英雄战魂怎么样99个火龙鳞片怎么锻造紫色武器
