oracle容灾技术

DBAitpub.netoraclejvm,linux,j2eedataguard+racjvmtunningIT([e-mail])Dataguard9iR2dataguarddataguard:dataguarddataguardoracle9iR1dataguard9iR2dataguard1.Logicalstandbydatabase9iR2datagauardreadonlyrecoverphysicalstandydatabasephysicalstandydatabaselogicalstandbydatabaselogicalschemareport2Databaseprotectionmodes9iR2–Maximumprotection–Maximumavailability–MaximumperformanceMaximumprotectionzerodataloss.MaximumavailabilityMaximumprotectionMaximumperformanceMaximumperformancearchivedlogarchredologredolog3CascadingstandbydatabasesR2standbydataguarddataguardphysicalstandbyarchivedlogblockphysicalstandbylogicalstandbyarchivedloglogmnrsqllogicalstandbysql:dataguard1RAC23switchoverfailover4dataguardphysicalcorruptionsdataguarda(primaryip10.2.33.100),b(standby10.1.1.78),10.2.33.41xwin32linux10.2.33.100linuxredhatadvancedserver2.110.1.1.78linuxredhatadvancedserver2.110.2.33.41win2kserver9.2.0.19irelease2dataguardoraclea,ba,b1.(root)vi/etc/sysctl.confkernel.sysrq=1kernel.shmmax=1073741824--ramkernel.msgmni=1024kernel.sem=10032000100100fs.file-max=65535net.ipv4.ip_local_port_range=102465000net.ipv4.tcp_max_syn_backlog=81922.a,b(root)/etc/init.d/networkrestartShuttingdowninterfaceeth0:[OK]Settingnetworkparameters:[OK]Bringingupinterfacelo:[OK]Bringingupinterfaceeth0:[OK]cat/proc/sys/kernel/shmmax10737418243.oracle(root)useraddoracle9ipasswdoracle9i4.a,b(root)cd/mkdirtpdatatpsyschmod777tpdatachmod777tpsys5.oracle9i(oracle9i)vi~/.bash_profileexportPATHunsetUSERNAMEexportORACLE_BASE=/tpdata/9.2.0exportORACLE_BASE1=/tpsys/app/oracle/product#exportORACLE_BASE1=/tpsys/app/oracle/product/serverexportORACLE_HOME=$ORACLE_BASE1/9.2.0exportORACLE_SID=sfssgbkexportPATH=$ORACLE_HOME/bin:$PATHexportLD_LIBRARY_PATH=$ORACLE_HOME/libexportNLS_LANG=american_america.zhs16gbkexportDISPLAY=10.2.33.41:0#6.(oracle9i).~/.bash_profileecho$ORACLE_BASE/tpdata/9.2.0echo$ORACLE_HOME/tpsys/app/oracle/product/9.2.07.oracle9201software,(oracle9i)8.$ORACLE_HOME,$ORACLE_BASEftp(oracle9i)cd/tarcvzf/tpdata/oracle9201server.tgz/tpsys/app/oracle/product9.2.0/tpdata/9.2.0/doc/tpdata/9.2.0/jre/tpdata/9.2.0/oraInventory/tpdata/9.2.0/ouiftp/tpdatacd/tarxvzf/tpdata/oracle9201server.tgz9.dbcazhs16gbk(oracle9i)10.,(oracle9i)cpredologsqlplus/nologSQLconn/assysdba;SQLselectFILE_NAMEfromdba_data_files;FILE_NAME---------------------------------------------------------------------/tpdata/9.2.0/oradata/sfssgbk/system01.dbf/tpdata/9.2.0/oradata/sfssgbk/undotbs01.dbf/tpdata/9.2.0/oradata/sfssgbk/drsys01.dbf/tpdata/9.2.0/oradata/sfssgbk/example01.dbf/tpdata/9.2.0/oradata/sfssgbk/indx01.dbf/tpdata/9.2.0/oradata/sfssgbk/odm01.dbf/tpdata/9.2.0/oradata/sfssgbk/tools01.dbf/tpdata/9.2.0/oradata/sfssgbk/users01.dbf/tpdata/9.2.0/oradata/sfssgbk/xdb01.dbfSQLselectMEMBERfromv$logfile;MEMBER---------------------------------------------------------------------/tpdata/9.2.0/oradata/sfssgbk/redo03.log/tpdata/9.2.0/oradata/sfssgbk/redo02.log/tpdata/9.2.0/oradata/sfssgbk/redo01.logSQLselectNAMEfromv$tempfile;NAME---------------------------------------------------------------------/tpdata/9.2.0/oradata/sfssgbk/temp01.dbfSQLshutdownimmediate;ftptarftpcd/tpdatatarcvzfsfssgbk.tgz/tpdata/9.2.0/oradata/sfssgbk/tpdata/9.2.0/admin/sfssgbkftpsfssgbk.tgz/tpdatacd/tpdatatarxvzfsfssgbk.tgz11.(oracle9i)mkdir-p/tpdata/9.2.0/oradata/sfssgbk/archivesqlplus/nologSQLconn/assysdba;Connected.SQLstartupmount;ORACLEinstancestarted.TotalSystemGlobalArea235999352bytesFixedSize450680bytesVariableSize201326592bytesDatabaseBuffers33554432bytesRedoBuffers667648bytesDatabasemounted.SQLarchiveloglist;DatabaselogmodeNoArchiveModeAutomaticarchivalDisabledArchivedestination/tpsys/app/oracle/product/9.2.0/dbs/archOldestonlinelogsequence0Currentlogsequence1SQLalterdatabasearchivelog;Databasealtered.SQLarchivelogstart;Statementprocessed.SQLarchiveloglist;DatabaselogmodeArchiveModeAutomaticarchivalEnabledArchivedestination/tpsys/app/oracle/product/9.2.0/dbs/archOldestonlinelogsequence0Nextlogsequencetoarchive1Currentlogsequence1SQLalterdatabaseopen;Databasealtered.SQLaltersystemsetLOG_ARCHIVE_DEST_1='LOCATION=/tpdata/9.2.0/oradata/sfssgbk/archive';Systemaltered.SQLaltersystemsetlog_archive_format='%t_%s.dbf'scope=spfile;Systemaltered.SQLaltersystemsetlog_archive_start=truescope=spfile;Systemaltered.SQLshutdownimmediate;Databaseclosed.Databasedismounted.ORACLEinstanceshutdown.SQLstartupORACLEinstancestarted.TotalSystemGlobalArea235999352bytesFixedSize450680bytesVariableSize201326592bytesDatabaseBuffers33554432bytesRedoBuffers667648bytesDatabasemounted.Databaseopened.SQLarchiveloglist;DatabaselogmodeArchiveModeAutomaticarchivalEnabledArchivedestination/tpdata/9.2.0/oradata/sfssgbk/archiveOldestonlinelogsequence0Nextlogsequencetoarchive1Currentlogsequence112.controlfile(oracle9i)sqlplus/nologSQLconn/assysdba;Connected.SQLALTERDATABASECREATESTANDBYCONTROLFILEAS'/tpdata/standby.ctl';Databasealtered.ftp/tpdata/standby.ctl/tpdata/9.2.0/oradata/sfssgbk13.listener.oratnsnames.ora(oracle9i)vi/tpsys/app/orac