Data Guard ManaGeR command-Line interface[@more@]

1．環(huán)境：Primary Database: ning
Physical Standby Database: test
2．修改初始化參數(shù)dg_broker_start
SQL> alter system set dg_broker_start=true;
3．確認(rèn)數(shù)據(jù)庫(kù)使用的是spfile啟動(dòng)

站在用戶(hù)的角度思考問(wèn)題，與客戶(hù)深入溝通，找到江口網(wǎng)站設(shè)計(jì)與江口網(wǎng)站推廣的解決方案，憑借多年的經(jīng)驗(yàn)，讓設(shè)計(jì)與互聯(lián)網(wǎng)技術(shù)結(jié)合，創(chuàng)造個(gè)性化、用戶(hù)體驗(yàn)好的作品，建站類(lèi)型包括：成都網(wǎng)站建設(shè)、網(wǎng)站設(shè)計(jì)、企業(yè)官網(wǎng)、英文網(wǎng)站、手機(jī)端網(wǎng)站、網(wǎng)站推廣、主機(jī)域名、網(wǎng)絡(luò)空間、企業(yè)郵箱。業(yè)務(wù)覆蓋江口地區(qū)。

4．啟動(dòng)DGMGRL
C:>dgmgrl
DGMGRL for 32-bit Windows: Version 10.2.0.1.0 - Production

Copyright (c) 2000, 2005, Oracle. All rights reserved.

Welcome to DGMGRL, type "help" for information.
5．連接到Primary庫(kù)DGMGRL> connect
Username: sys@ning
Password:
Connected.

6．創(chuàng)建配置
DGMGRL> create configuration 'DGTEST' as
> primary database is 'ning'
> connect identifier is ning;
Configuration "DGTEST" created with primary database "ning"
7．添加備用庫(kù)
DGMGRL> add database 'test'
> as connect identifier is test
> maintained as physical;
Database "test" added
8．查看配置DGMGRL> show configuration

Configuration
Name: DGTEST
Enabled: NO
Protection Mode: MaxPerformance
Fast-Start Failover: DISABLED
Databases:
ning - Primary database
test - Physical standby database

Current status for "DGTEST": DISABLED
9．設(shè)置數(shù)據(jù)庫(kù)屬性
DGMGRL>edit database 'ning' set property 'LogArchiveFormat' = 'log_%t_%s_%r_%d.arc';
Property "LogArchiveFormat" updated
10．顯示數(shù)據(jù)庫(kù)屬性
DGMGRL> show database verbose 'ning'

Database
Name: ning
Role: PRIMARY
Enabled: NO
Intended State: OFFLINE
Instance(s):
ning

Properties:
InitialConnectIdentifier = 'ning'
LogXptMode = 'ARCH'
Dependency = ''
DelayMins = '0'
Binding = 'OPTIONAL'
MaxFailure = '0'
MaxConnections = '1'
ReopenSecs = '300'
NetTimeout = '180'
LogShipping = 'ON'
PreferredApplyInstance = ''
ApplyInstanceTimeout = '0'
ApplyParallel = 'AUTO'
StandbyFileManagement = 'MANUAL'
ArchiveLagTarget = '0'
LogArchiveMaxProcesses = '2'
LogArchiveMinSucceedDest = '1'
DbFileNameConvert = ''
LogFileNameConvert = ''
FastStartFailoverTarget = ''
StatusReport = '(monitor)'
InconsistentProperties = '(monitor)'
InconsistentLogXptProps = '(monitor)'
SendQEntries = '(monitor)'
LogXptStatus = '(monitor)'
RecvQEntries = '(monitor)'
HostName = 'dgmis'
SidName = 'ning'
LocalListenerAddress = '(ADDRESS=(PROTOCOL=tcp)(HOST=dgmis)(PORT=
1521))'
StandbyArchiveLocation = 'e:oraclearch3ning'
AlternateLocation = ''
LogArchiveTrace = '0'
LogArchiveFormat = 'log_%t_%s_%r_%d.arc'
LatestLog = '(monitor)'
TopWaitEvents = '(monitor)'

Current status for "ning":
DISABLED

11．啟用配置
DGMGRL> enable configuration
Enabled.

DGMGRL> enable database 'ning'
Enabled.

DGMGRL> enable database 'test'
Enabled.
12．檢查數(shù)據(jù)庫(kù)狀態(tài)
DGMGRL> show database 'ning'

Database
Name: ning
Role: PRIMARY
Enabled: YES
Intended State: ONLINE
Instance(s):
ning

Current status for "ning":
SUCCESS

DGMGRL> show database 'test'

Database
Name: test
Role: PHYSICAL STANDBY
Enabled: YES
Intended State: ONLINE
Instance(s):
test

Current status for "test":
SUCCESS

DGMGRL> show configuration

Configuration
Name: DGTEST
Enabled: YES
Protection Mode: MaxPerformance
Fast-Start Failover: DISABLED
Databases:
ning - Primary database
test - Physical standby database

Current status for "DGTEST":
SUCCESS
13．修改Data Guard的保護(hù)模式
DGMGRL> edit configuration set protection mode as maxperformance;
Succeeded.

14．更改備用庫(kù)到只讀狀態(tài)
DGMGRL> edit database test set state='read-only';
Succeeded.
15．停止主庫(kù)到從庫(kù)的日志傳送DGMGRL> edit database ning set state='log-transport-off';
Succeeded.
16．將主庫(kù)離線
DGMGRL> edit database ning set state='offline';
Operation requires shutdown of instance "ning" on database "ning"
Shutting down instance "ning"...
Database closed.
Database dismounted.
ORACLE instance shut down.
注：要將主庫(kù)重新上線，需要先手動(dòng)啟動(dòng)數(shù)據(jù)庫(kù)，然后
DGMGRL> connect sys@ning
Password:
Connected.
DGMGRL> edit database ning set state='online';
Succeeded.
17．禁用配置
DGMGRL> disable configuration
Disabled.
18．禁用某個(gè)備用庫(kù)DGMGRL> disable database 'test';
Disabled.
19．從配置中刪除備用庫(kù)
DGMGRL> remove database 'test'
Removed database "test" from the configuration
20．刪除配置
DGMGRL> remove configuration
Removed configuration.

21．執(zhí)行Switchover切換
DGMGRL> switchover to 'test';
Performing switchover NOW, please wait...
Operation requires shutdown of instance "ning" on database "ning"
Shutting down instance "ning"...
ORA-01109: database not open

Database dismounted.
ORACLE instance shut down.
Operation requires shutdown of instance "test" on database "test"
Shutting down instance "test"...
ORA-01109: database not open

Database dismounted.
ORACLE instance shut down.
Operation requires startup of instance "ning" on database "ning"
Starting instance "ning"...
ORACLE instance started.
Database mounted.

Operation requires startup of instance "test" on database "test"
ORACLE instance started.
Database mounted
Switchover succeeded. New primary is "test"

DGMGRL> show configuration

Configuration
Name: DGTEST
Enabled: YES
Protection Mode: MaxPerformance
Fast-Start Failover: DISABLED
Databases:
ning - Physical standby database
test - Primary database

Current status for "DGTEST":
SUCCESS
22．執(zhí)行Failover切換
DGMGRL> FAILOVER TO "test";

23．生成數(shù)據(jù)庫(kù)狀態(tài)報(bào)告（如果你遇到Ora-16810時(shí)可以使用）
DGMGRL> show database 'ning' 'statusreport'
STATUS REPORT
INSTANCE_NAME SEVERITY ERROR_TEXT

附錄：
ORA-16525: the Data Guard broker is not yet available請(qǐng)檢查數(shù)據(jù)庫(kù)的初始化參數(shù)dg_broker_start是否為true

ORA-16797: database is not using a server parameter file請(qǐng)檢查數(shù)據(jù)庫(kù)是否以spfile啟動(dòng)

ORA-16792: configuration property value is inconsistent with database setting
檢查數(shù)據(jù)庫(kù)的某些屬性和數(shù)據(jù)的初始化參數(shù)設(shè)置是否一致，例如LogArchiveFormat屬性和log_archive_format參數(shù)的設(shè)置是否一致

ORA-16505: site ID is invalid
檢查該數(shù)據(jù)庫(kù)是否處于enable狀態(tài)

新聞標(biāo)題：使用DGMGRL管理DataGuard-創(chuàng)新互聯(lián)
文章URL：http://weahome.cn/article/dpjojc.html