Oracle Data+Guard+Administration D17316GC20_L05_Phys_SQL

——ACE GENE学习俱乐部
10
——自由IT技术支持中心
Specifying Values for DB_FILE_NAME_CONVERT
• Must be defined on standby databases that have different disk or directory structures from the primary • Allows multiple pairs of file names • Applies to a database when in physical standby mode
LOG_FILE_NAME_CONVERT = ('/oracle1/logs/', '/ora1/stby_logs/')
——ACE GENE学习俱乐部
12
——自由IT技术支持中心
Specifying a Value for LOG_ARCHIVE_FORMAT
Specifying Values for LOG_FILE_NAME_CONVERT
• Similar to DB_FILE_NAME_CONVERT • Must be defined on standby databases that have different disk or directory structures from the primary • Online redo log files are used only when the standby becomes a primary. • Applies to a database when in physical standby mode
——ACE GENE学习俱乐部
8
——自由IT技术支持中心
LOCATION and SERVICE Attributes
Each archive log destination includes one of the following attributes: • LOCATION: specifies a valid path name. • SERVICE: specifies a valid Oracle Net Services name referencing a standby database.
——ACE GENE学习俱乐部
3
——自由IT技术支持中心
Preparing the Primary Database
• Enable FORCE LOGGING at the database level.
• Indicates the format for redo log file names • Format directives:
– – – – – – – – – %t: Thread number %T: Zero-filled thread number %s: Sequence number %S: Zero-filled sequence number %d: Database ID %D: Zero-filled database ID %a: Current activation ID %A: Zero-filled activation ID %r: Resetlogs ID
DB_FILE_NAME_CONVERT =('/oracle1/dba/', '/ora1/stby_dba/', '/oracle2/dba/', '/ora2/stby_dba/')
——ACE GENE学习俱乐部
11
——自由IT技术支持中心
LOG_ARCHIVE_DEST_1= 'LOCATION=/arch1/chicago/ VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=chicago' LOG_ARCHIVE_DEST_2= 'SERVICE=boston VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=boston'
– SEND: enables a database to send redo data to remote destinations. – RECEIVE: enables the standby database to receive redo from another database. – Use the NOSEND and NORECEIVE keywords to disable these settings. DB_NAME=chicago DB_UNIQUE_NAME=chicago LOG_ARCHIVE_CONFIG='DG_CONFIG=(chicago,boston)'
Traces redo data transmission
5
——自由IT技术支持中心
LOG_ARCHIVE_CONFIG
• Specify the DG_CONFIG attribute to list the DB_UNIQUE_NAME for the primary database and each standby database in the Data Guard configuration. • Additional LOG_ARCHIVE_CONFIG parameter values:
——ACE GENE学习俱乐部
4
——自由IT技术支持中心
Setting Initialization Parameters on the Primary Database
Parameter Name
ARCHIVE_LAG_TARGET
Controls automatic standby file management
Forces a log switch after the specified number ofACE
——ACE GENE学习俱乐部
SQL> ALTER DATABASE FORCE LOGGING;
• Create a password file. • Set initialization parameters. • Enable archiving.
SQL> SQL> SQL> SQL> SHUTDOWN IMMEDIATE; STARTUP MOUNT; ALTER DATABASE ARCHIVELOG; ALTER DATABASE OPEN;
——ACE GENE学习俱乐部
6
——自由IT技术支持中心
LOG_ARCHIVE_DEST_n
• Specify at least two LOG_ARCHIVE_DEST_n parameters. • Must contain (at a minimum) one of the following:
– LOCATION – SERVICE
• LOG_ARCHIVE_DEST_STATE_n parameter for each defined destination
LOG_ARCHIVE_DEST_2= 'SERVICE=boston VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=boston' LOG_ARCHIVE_DEST_STATE_2=ENABLE
– ENABLE (default) – DEFER – RESET
• Applies to the primary and standby database
log_archive_dest_3='SERVICE=stby1_path1 ALTERNATE=LOG_ARCHIVE_DEST_4' log_archive_dest_4='SERVICE=stby1_path2' log_archive_dest_state_3=ENABLE
• Default value is operating-system dependent.
LOG_ARCHIVE_FORMAT = %d_%t_%s_%r.arc
——ACE GENE学习俱乐部
LOG_ARCHIVE_CONFIG
LOG_ARCHIVE_DEST_n LOG_ARCHIVE_DEST_STATE_n DB_FILE_NAME_CONVERT LOG_FILE_NAME_CONVERT
Description
Specifies the unique database name for each database in the configuration
——ACE GENE学习俱乐部
2
——自由IT技术支持中心
Steps to Create a Physical Standby Database
1. 2. 3. 4. 5. 6. 7. 8. Prepare the primary database. Back up the primary database. Copy files to the standby system. Set parameters on the physical standby database. Start the standby database. Configure Oracle Net Services. Set parameters on the primary database. Start the transport of redo.
Creating a Physical Standby Database by Using SQL