Oracle 11.2.0.4.0 Dataguard Deployment and ongoing maintenance (2)

1. Primary library settings Dataguard related parameters

1.1. Force the Primay Library to log in any state

SYS@userdata>SelectForce_logging fromv$Database; Force_log---------Nosys@userdata>Alter DatabaseForce logging;Databasealtered. SYS@userdata>SelectForce_logging fromv$Database; Force_log---------YES

1.2. Set the Primay Library in archive mode

SYS@userdata>shutdownimmediate; SYS@userdata>sTartup Mount; SYS@userdata>Alter DatabaseArchivelog; SYS@userdata>Alter Database Open; SYS@userdata>ArchiveLoglist;Database Logmode Archive modeautomatic archival enabledarchive destination Use_db_recovery_fi Le_destOldest onlineLogSequence2Next LogSequence toArchive4 Current LogSequence4

1.3. Set the tnsnames of the primary and standby libraries

$Cat$ORACLE _home/network/admin/tnsnames.ora# Tnsnames.ora Network Configuration File:/u01/app/oracle/product/11.2.0/db_1/network/admin/tnsnames.ora# Generated by Oracle configuration tools.userdata1=(DESCRIPTION=(ADDRESS= (PROTOCOL = TCP) (HOST = ec2t-userdata- on) (PORT =1521)) (Connect_data=(SERVER=dedicated) (Service_Name=UserData)) ) Userdata2=(DESCRIPTION=(ADDRESS= (PROTOCOL = TCP) (HOST = ec2t-userdata- Geneva) (PORT =1521)) (Connect_data=(SERVER=dedicated) (Service_Name=UserData)) )

1.4. Create an updatable Pfile file based on SPFile

SYS@userdata>Create pfile='/home/oracle/pfile.ora'   from spfile; File created.

1.5. Update the Pfile file, add Dataguard related parameters

$mkdir/u01/app/oracle/arch$Cat/home/oracle/pfile.orauserdata.__db_cache_size=620756992userdata.__java_pool_size=16777216userdata.__large_pool_size=33554432Userdata.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from Environmentuserdata.__pga_aggregate_target=620756992Userdata.__sga_target=905969664userdata.__shared_io_pool_size=0userdata.__shared_pool_size=218103808userdata.__streams_pool_size=0*.audit_file_dest='/u01/app/oracle/admin/userdata/adump'*.audit_trail='DB'*.compatible='11.2.0.4.0'*.control_files='/u01/app/oracle/oradata/userdata/control01.ctl','/u01/app/oracle/fast_recovery_area/userdata/control02.ctl'*.db_block_size=8192*.db_domain="'*.db_name='UserData'*.db_recovery_file_dest='/u01/app/oracle/fast_recovery_area'*.db_recovery_file_dest_size=4294967296*.diagnostic_dest='/u01/app/oracle'*.dispatchers='(PROTOCOL=TCP) (SERVICE=USERDATAXDB)'*.java_jit_enabled=FALSE*.memory_target=1526726656*.open_cursors= -*.processes= -*.remote_login_passwordfile='EXCLUSIVE'*.undo_tablespace='UNDOTBS1'*.db_unique_name='userdata1'*.log_archive_config='dg_config= (USERDATA1,USERDATA2)'*.log_archive_dest_1='Location=/u01/app/oracle/arch'*.log_archive_dest_2='service=userdata2 lgwr ASYNC valid_for= (online_logfiles,primary_role) db_unique_name=userdata2'*.log_archive_dest_state_1='ENABLE'*.log_archive_dest_state_2='ENABLE'*.standby_file_management='AUTO'*.fal_client='userdata1'*.fal_server='Userdata2 '

1.5. Import the new parameter file to make the Dataguard configuration effective

SYS@userdata>shutdown  immediate; SYS@userdata>Create from pfile='/home/oracle/ Pfile.ora'; SYS@userdata>startup;

2. Standby Library settings Dataguard related parameters

3. Make a backup of the primary library

4. Transfer Backup to Standby library

5. Restore the Standby library

6. Create standby online logs

7. Turn on the Stanby library recovery process

8.primary Library archive To see if Dataguard data synchronization was successful

Oracle 11.2.0.4.0 Dataguard Deployment and ongoing maintenance (2)