Shulou(Shulou.com)06/01 Report--

Oracle 11g dataguard configuration reduction step this step is implemented by duplicate of rman. This method is suitable for large databases and can also be used as a reference for replicating databases. Edit / etc/hosts 1. Open force logging alter database force logging; 2. 0 in the main database. Network configuration (listeners use static registration, network service names primary, standby, use the tnsping command to test connectivity) 3. The directory structure of copying directory to standby machine 11g is slightly different from that of 10g. To create a password file in the target database, the password needs to be the same as the main database orapwd file=orapwdb01 password=Oracle01 entries=5 5. Generate pfile parameter files in the main library, edit parameters, meet dg needs, and copy parameter files to standby library And make corresponding modifications to db_unique_name='PRIMARY' LOG_ARCHIVE_CONFIG='DG_CONFIG= (primary,standby) 'LOG_ARCHIVE_DEST_1='LOCATION=/home/oracle/archdest VALID_FOR= (ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=primary' LOG_ARCHIVE_DEST_2='SERVICE=standby LGWR SYNC VALID_FOR= (ONLINE_LOGFILES) PRIMARY_ROLE) DB_UNIQUE_NAME=standby' LOG_ARCHIVE_DEST_STATE_1=ENABLE LOG_ARCHIVE_DEST_STATE_2=ENABLE REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE fal_server=standby fal_client=primary STANDBY_FILE_MANAGEMENT=AUTO 6. The standby connects the main library (target) and the standby library (duplicate) rman target sys/Oracle01@primary auxiliary sys/Oracle01@standby nocatalog 7. Use the duplicate command to generate standby database duplicate target database for standby from active database nofilenamecheck; 8. 0. Add the spare redo log files alter database add standby logfile group 4 ('/ u01Actionoradata) to the master and standby database, group 5 ('/ u01aphoracleredo05.log') size 50m, group 6 ('/ u01approradata) size 50m Group 7 ('/ u01 size size 50m) 9. Simply test the datagurad.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.