频道栏目
首页 > 数据库 > 其他综合 > 正文
DG搭建逻辑备库
2015-01-24 10:13:31         来源:雪域飞鸿  
收藏   我要投稿

逻辑备库是在物理备库的基础上搭建的,所以需要先搭建好物理备库。

备库执行如下操作:

[oracle@localhost ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production onFri Nov 7 15:03:30 2014

Copyright (c) 1982, 2011, Oracle. All rights reserved.

Connected to:

Oracle Database 11g Enterprise EditionRelease 11.2.0.3.0 - 64bit Production

With the Partitioning, Oracle LabelSecurity, OLAP, Data Mining,

Oracle Database Vault and Real ApplicationTesting options

SQL> alter database recover managed standby database cancel;

Database altered.

SQL> exit

Disconnected from Oracle Database 11gEnterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, Oracle LabelSecurity, OLAP, Data Mining,

Oracle Database Vault and Real ApplicationTesting options

主库:

[oracle@localhost ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production onFri Nov 7 15:04:46 2014

Copyright (c) 1982, 2011, Oracle. All rights reserved.

Connected to:

Oracle Database 11g Enterprise EditionRelease 11.2.0.3.0 - 64bit Production

With the Partitioning, Oracle LabelSecurity, OLAP, Data Mining,

Oracle Database Vault and Real ApplicationTesting options

SQL> alter database force logging; ---强制日志记录

Database altered.

SQL> alter database add supplemental log data; ----增加附加日志

Database altered.

SQL> exec dbms_logstdby.build; ---脚本

PL/SQL procedure successfully completed.

SQL>

备库

[oracle@localhost ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production onFri Nov 7 15:11:37 2014

Copyright (c) 1982, 2011, Oracle. All rights reserved.

Connected to:

Oracle Database 11g Enterprise EditionRelease 11.2.0.3.0 - 64bit Production

With the Partitioning, Oracle LabelSecurity, OLAP, Data Mining,

Oracle Database Vault and Real ApplicationTesting options

SQL> alter database recover to logical standby jadl11g;

Database altered.

SQL> shutdown immediate----注意必须一致性性关闭数据库

ORA-01507: database not mounted

ORACLE instance shut down.

SQL> startup mount

ORACLE instance started.

Total System Global Area 626327552 bytes

Fixed Size 2230952 bytes

Variable Size 268436824 bytes

Database Buffers 352321536 bytes

Redo Buffers 3338240 bytes

Database mounted.

SQL> alter database open resetlogs; *********

Database altered.

SQL> alter database start logical standby apply;

Database altered.

登录DGMGRL:

DGMGRL> createconfiguration dgc as primary database is pjadl11g connect identifier ispjadl11g;

Configuration "dgc" created withprimary database "pjadl11g"

DGMGRL> add database sjadl11g as connect identifier issjadl11g maintained as logical;

Database "sjadl11g" added

DGMGRL> enable configuration

Enabled.

DGMGRL> show configuration

Configuration - dgc

Protection Mode: MaxPerformance

Databases:

pjadl11g - Primary database

sjadl11g - Logical standby database

Fast-Start Failover: DISABLED

Configuration Status:

SUCCESS

至此逻辑备库搭建完毕!!!!!!!

DGMGRL> show configuration verbose;

Configuration - dgc

Protection Mode: MaxPerformance

Databases:

pjadl11g - Primary database

sjadl11g - Logical standby database

Properties:

FastStartFailoverThreshold ='30'

OperationTimeout ='30'

FastStartFailoverLagLimit ='30'

CommunicationTimeout ='180'

FastStartFailoverAutoReinstate ='TRUE'

FastStartFailoverPmyShutdown ='TRUE'

BystandersFollowRoleChange ='ALL'

Fast-Start Failover: DISABLED

Configuration Status:

SUCCESS

DGMGRL> show database verbose sjadl11g;

Database - sjadl11g

Role: LOGICAL STANDBY

Intended State: APPLY-ON

Transport Lag: 0 seconds

Apply Lag: 0 seconds

Instance(s):

jadl11g

Properties:

DGConnectIdentifier ='sjadl11g'

ObserverConnectIdentifier =''

LogXptMode = 'ASYNC'

DelayMins ='0'

Binding ='optional'

MaxFailure ='0'

MaxConnections ='1'

ReopenSecs ='300'

NetTimeout ='30'

RedoCompression ='DISABLE'

LogShipping ='ON'

PreferredApplyInstance = ''

ApplyInstanceTimeout ='0'

LsbyASkipTxnCfgPr ='0,0,0'

LsbyDSkipTxnCfgPr ='0,0,0'

LsbyASkipCfgPr =''

LsbyDSkipCfgPr =''

LsbyASkipErrorCfgPr = ''

LsbyDSkipErrorCfgPr =''

LsbyMaxEventsRecorded ='0'

LsbyPreserveCommitOrder =''

LsbyRecordSkipErrors =''

LsbyRecordSkipDdl =''

LsbyRecordAppliedDdl =''

ArchiveLagTarget ='0'

LogArchiveMaxProcesses ='4'

LogArchiveMinSucceedDest ='1'

FastStartFailoverTarget =''

InconsistentProperties ='(monitor)'

InconsistentLogXptProps ='(monitor)'

SendQEntries ='(monitor)'

LogXptStatus ='(monitor)'

RecvQEntries ='(monitor)'

LsbyParameters ='(monitor)'

LsbySkipTxnTable ='(monitor)'

LsbySkipTable ='(monitor)'

LsbyFailedTxnInfo ='(monitor)'

SidName ='jadl11g'

StaticConnectIdentifier ='(DESCRIPTION=(ADDRESS=(PROTOCOL=tc =localhost.localdomain)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=sjadl11g_D INSTANCE_NAME=jadl11g)(SERVER=DEDICATED)))'

StandbyArchiveLocation ='USE_DB_RECOVERY_FILE_DEST'

AlternateLocation = ''

LogArchiveTrace ='0'

LogArchiveFormat ='%t_%s_%r.dbf'

LsbyMaxSga ='0'

LsbyMaxServers ='0'

TopWaitEvents ='(monitor)'

Database Status:

SUCCESS

DGMGRL> edit database sjadl11g set propertylogxptmode='sync';---修改参数

Property"logxptmode" updated
点击复制链接 与好友分享!回本站首页
相关TAG标签 逻辑
上一篇:IIS的安装和配置
下一篇:DG搭建物理备库
相关文章
图文推荐
点击排行

关于我们 | 联系我们 | 广告服务 | 投资合作 | 版权申明 | 在线帮助 | 网站地图 | 作品发布 | Vip技术培训 | 举报中心

版权所有: 红黑联盟--致力于做实用的IT技术学习网站