>Dataguard BROKER -1

>http:// stanford.edu/dept/itss/docs/oracle/10g/server.101/b10822/cli.htm#i1005666
http://download.oracle.com/docs/cd/B10501_01/server.920/a96629/dgmgrl.htm#73729

show parameter DG_BROKER_START — dmon process

ALTER SYSTEM SET DG_BROKER_START=TRUE;
–restart isteyebilir
SQL> SHOW PARAMETER DB_UNIQUE NAME;

DGMGRL> CREATE CONFIGURATION ‘DRTest’ AS
PRIMARY DATABASE IS ‘dg1’
CONNECT IDENTIFIER IS dg1;

SHOW CONFIGURATION;

DGMGRL> ADD DATABASE ‘dg2’ AS
CONNECT IDENTIFIER IS dg2
MAINTAINED AS PHYSICAL;

———–
DGMGRL> EDIT DATABASE ‘dg2’ SET PROPERTY ‘LogArchiveFormat’=’log_%t_%s_%r_%d.arc’;
Property “LogArchiveFormat” updated.

DGMGRL> EDIT DATABASE ‘dg2’ SET PROPERTY ‘StandbyArchiveLocation’=’C:\archives’;
Property “StandbyArchiveLocation” updated.

SHOW DATABASE VERBOSE ‘dg2’;

ENABLE CONFIGURATION;

SHOW CONFIGURATION;

ORA-19527: physical standby redo log must be renamed
# Uncomment is filename conversion is needed–sid ler farklı ise
#DB_FILE_NAME_CONVERT=(“/primary”,”/standby”)
#LOG_FILE_NAME_CONVERT=(“/primary”,”/standby”)
C:\oracle\product\10.2.0\oradata\orcl

enable database ‘dg2’;
–iptal EDIT DATABASE ‘dg2’ SET PROPERTY ‘LogXptMode’=’SYNC’;

EDIT DATABASE ‘dg1’ SET PROPERTY ‘LogArchiveTrace’=’127’;

EDIT DATABASE ‘dg2′ SET STATE=’READ-ONLY’;

EDIT DATABASE ‘dg1′ SET STATE=’Offline’;

EDIT DATABASE ‘dg2′ SET STATE=’ONLINE’ WITH APPLY INSTANCE=’dg2′;

EDIT DATABASE ‘dg2’ SET PROPERTY ‘delaymins’=’30’;

DGMGRL> SHOW LOG LATEST ON SITE ‘dg2’;

DGMGRL> SHOW LOG ALERT LATEST ON SITE ‘dg2’

DGMGRL> SHOW RESOURCE ‘dg2’;

DGMGRL> SHOW RESOURCE db ;

DGMGRL> SHOW RESOURCE db ‘InconsistentProperties’ ;

DGMGRL> SHOW SITE ‘dg2’;

DGMGRL> SHOW SITE VERBOSE ‘dg2’;

C:\Documents and Settings\ferhantekin>dgmgrl
DGMGRL for 32-bit Windows: Version 10.2.0.1.0 – Production

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

DGMGRL ÷≡esine ho■ geldiniz, bilgi iτin “yard²m”² t²klat²n.
DGMGRL> connect sys@dg1
Password:
Ba≡lan²ld².
DGMGRL> show configuration;

Configuration
Name: DRTest
Enabled: YES
Protection Mode: MaxPerformance
Fast-Start Failover: DISABLED
Databases:
dg1 – Primary database
dg2 – Physical standby database

Geτerli “DRTest” statⁿsⁿ:
SUCCESS

DGMGRL> show database verbose dg1;

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

Properties:
InitialConnectIdentifier = ‘dg1’
LogXptMode = ‘ARCH’
Dependency = ”
DelayMins = ‘0’
Binding = ‘OPTIONAL’
MaxFailure = ‘0’
MaxConnections = ‘1’
ReopenSecs = ‘300’
NetTimeout = ‘180’
LogShipping = ‘ON’
PreferredApplyInstance = ”
ApplyInstanceTimeout = ‘0’
ApplyParallel = ‘AUTO’
StandbyFileManagement = ‘AUTO’
ArchiveLagTarget = ‘0’
LogArchiveMaxProcesses = ‘2’
LogArchiveMinSucceedDest = ‘1’
DbFileNameConvert = ”
LogFileNameConvert = ”
FastStartFailoverTarget = ”
StatusReport = ‘(monitor)’
InconsistentProperties = ‘(monitor)’
InconsistentLogXptProps = ‘(monitor)’
SendQEntries = ‘(monitor)’
LogXptStatus = ‘(monitor)’
RecvQEntries = ‘(monitor)’
HostName = ‘HLD-KAY-DG1’
SidName = ‘orcl’
LocalListenerAddress = ‘(ADDRESS=(PROTOCOL=tcp)(HOST=HLD-KAY-DG1)
(PORT=1521))’
StandbyArchiveLocation = ‘dgsby_dg1’
AlternateLocation = ”
LogArchiveTrace = ‘127’
LogArchiveFormat = ‘%t_%s_%r.arc’
LatestLog = ‘(monitor)’
TopWaitEvents = ‘(monitor)’

Geτerli “dg1” statⁿsⁿ:
SUCCESS

DGMGRL> show database verbose dg2;

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

Properties:
InitialConnectIdentifier = ‘dg2’
LogXptMode = ‘ARCH’
Dependency = ”
DelayMins = ‘3’
Binding = ‘OPTIONAL’
MaxFailure = ‘0’
MaxConnections = ‘1’
ReopenSecs = ‘300’
NetTimeout = ‘180’
LogShipping = ‘ON’
PreferredApplyInstance = ‘dg2’
ApplyInstanceTimeout = ‘0’
ApplyParallel = ‘AUTO’
StandbyFileManagement = ‘AUTO’
ArchiveLagTarget = ‘0’
LogArchiveMaxProcesses = ‘2’
LogArchiveMinSucceedDest = ‘1’
DbFileNameConvert = ”
LogFileNameConvert = ”
FastStartFailoverTarget = ”
StatusReport = ‘(monitor)’
InconsistentProperties = ‘(monitor)’
InconsistentLogXptProps = ‘(monitor)’
SendQEntries = ‘(monitor)’
LogXptStatus = ‘(monitor)’
RecvQEntries = ‘(monitor)’
HostName = ‘HLD-KAY-DG2’
SidName = ‘orcl’
LocalListenerAddress = ‘(ADDRESS=(PROTOCOL=tcp)(HOST=HLD-KAY-DG2)
(PORT=1521))’
StandbyArchiveLocation = ‘C:\arc’
AlternateLocation = ”
LogArchiveTrace = ‘0’
LogArchiveFormat = ‘log_%t_%s_%r_%d.arc’
LatestLog = ‘(monitor)’
TopWaitEvents = ‘(monitor)’

Geτerli “dg2” statⁿsⁿ:
SUCCESS

DGMGRL>

This entry was posted in Uncategorized. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s