Oracle_Data_Guard安装配置与操作维护使用指南.docx

准备工作主机Hosts表要添加两台数据库的主机名和IP地址；主机是primary，配置两机监听备机是standby，配置两机监听启动关闭命名dbstartdbshutlsnrctl startlsnrctl stoptnsping primarytnsping standby安装数据库配置监听器主数据库配置SQL alter database force logging;SQL shutdown immediateSQL startup mountSQL alter database archivelog;SQL archive log list$ sqlplus /nologSQL*Plus: Release .0 - Production on Mon May 30 10:06:47 2011Copyright (c) 1982, 2005, Oracle. All rights reserved.SQL conn /as sysdbaConnected.SQL alter database force logging;Database altered.SQL shutdown immediateDatabase closed.Database dismounted.ORACLE instance shut down.SQL startup mountORACLE instance started.Total System Global Area 364904448 bytesFixed Size 1219424 bytesVariable Size bytesDatabase Buffers 264241152 bytesRedo Buffers 7168000 bytesDatabase mounted.SQL alter database archivelog;Database altered.SQL archive log listDatabase log mode Archive ModeAutomatic archival EnabledArchive destination /opt/oracle/oradata/primary/archiveOldest online log sequence 1Next log sequence to archive 2Current log sequence 2主拷贝数据库文件SQL select name from v$datafile;SQL shutdown immediate;SQL select name from v$datafile;NAME------------------------------------------------/opt/oracle/oradata/primary/system01.dbf/opt/oracle/oradata/primary/undotbs01.dbf/opt/oracle/oradata/primary/sysaux01.dbf/opt/oracle/oradata/primary/users01.dbfSQL shutdown immediate;ORA-01109: database not openDatabase dismounted.ORACLE instance shut down.主创建控制文件SQL startup mountSQL alter database create standby controlfile as $ORACLE_BASE/oradata/primary/standby.ctl;SQL startup mountORACLE instance started.Total System Global Area 364904448 bytesFixed Size 1219424 bytesVariable Size bytesDatabase Buffers 264241152 bytesRedo Buffers 7168000 bytesDatabase mounted.SQL alter database create standby controlfile as /opt/oracle/oradata/primar