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．確認數(shù)據(jù)庫使用的是spfile啟動

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

4．啟動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庫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．添加備用庫
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ù)據(jù)庫屬性
DGMGRL>edit database 'ning' set property 'LogArchiveFormat' = 'log_%t_%s_%r_%d.arc';
Property "LogArchiveFormat" updated
10．顯示數(shù)據(jù)庫屬性
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ù)庫狀態(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的保護模式
DGMGRL> edit configuration set protection mode as maxperformance;
Succeeded.

14．更改備用庫到只讀狀態(tài)
DGMGRL> edit database test set state='read-only';
Succeeded.
15．停止主庫到從庫的日志傳送DGMGRL> edit database ning set state='log-transport-off';
Succeeded.
16．將主庫離線
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.
注：要將主庫重新上線，需要先手動啟動數(shù)據(jù)庫，然后
DGMGRL> connect sys@ning
Password:
Connected.
DGMGRL> edit database ning set state='online';
Succeeded.
17．禁用配置
DGMGRL> disable configuration
Disabled.
18．禁用某個備用庫DGMGRL> disable database 'test';
Disabled.
19．從配置中刪除備用庫
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ù)庫狀態(tài)報告（如果你遇到Ora-16810時可以使用）
DGMGRL> show database 'ning' 'statusreport'
STATUS REPORT
INSTANCE_NAME SEVERITY ERROR_TEXT

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

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

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

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

名稱欄目：使用DGMGRL管理DataGuard-創(chuàng)新互聯(lián)
轉載源于：http://aaarwkj.com/article22/dpjojc.html

成都網(wǎng)站建設公司_創(chuàng)新互聯(lián)，為您提供微信小程序、網(wǎng)頁設計公司、營銷型網(wǎng)站建設、網(wǎng)站營銷、動態(tài)網(wǎng)站、企業(yè)建站

廣告

聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶投稿、用戶轉載內(nèi)容為主，如果涉及侵權請盡快告知，我們將會在第一時間刪除。文章觀點不代表本網(wǎng)站立場，如需處理請聯(lián)系客服。電話：028-86922220；郵箱：631063699@qq.com。內(nèi)容未經(jīng)允許不得轉載，或轉載時需注明來源： 創(chuàng)新互聯(lián)