Oracle 10g 单实例数据库 Data Guard 之 Physical Standby 配置详解（根据官方文档总结）

--------Creating Physical Standby Database-------------------------------
--------Settings for the primary database--------------------------------


1、Enable Forced Logging
ALTER DATABASE FORCE LOGGING;




2、Create a Password File
orapwd file=orapw$ORACLE_SID password=oracle entries=5 force=y


3、Configure a Standby Redo Log
  3.1 、conn / as sysdba
  3.2 、select * from v$log;
  3.3 、select * from v$logfile;
  3.4 、prepare add standby redo log clause:
  ALTER DATABASE ADD STANDBY LOGFILE GROUP 4
  '/u01/app/oracle/oradata/cuug/redo04.log' SIZE 10M;
  
  ALTER DATABASE ADD STANDBY LOGFILE GROUP 5
  '/u01/app/oracle/oradata/cuug/redo05.log' SIZE 10M;


  ALTER DATABASE ADD STANDBY LOGFILE GROUP 6
  '/u01/app/oracle/oradata/cuug/redo06.log' SIZE 10M;


4、Set Primary Database Initialization Parameters




   DB_UNIQUE_NAME=cuug
   LOG_ARCHIVE_CONFIG='DG_CONFIG=(cuug,cuuo)'
   LOG_ARCHIVE_DEST_1='LOCATION=/u01/app/oracle/oradata/cuug/arch VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=cuug'
   LOG_ARCHIVE_DEST_2='SERVICE=cuuo LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=cuuo'
   log_archive_format='%t_%s_%r.log'   


   FAL_SERVER=cuuo
   FAL_CLIENT=cuug
   DB_FILE_NAME_CONVERT='/u02/app/oracle/oradata/cuuo/','/u01/app/oracle/oradata/cuug/'
   LOG_FILE_NAME_CONVERT='/u02/app/oracle/oradata/cuuo/','/u01/app/oracle/oradata/cuug/' 
   STANDBY_FILE_MANAGEMENT=AUTO
   


5、archive log list or show parameter archive;


6、Create a Backup Copy of the Primary Database Datafiles(IGNORE or OPTIONAL)


7、 Create a Control File for the Standby Database
 6.1 startup mount;
 6.2 alter database create standby controlfile as '/u02/app/oracle/oradata/cuuo/control01.ctl';


8、Prepare an Initialization Parameter File for the Standby Database
 8.1  Copy the primary database parameter file to the standby database.
      create pfile='/u02/app/oracle/oradata/cuuo/initcuuo.ora' from spfile;
 8.2  Modifying Initialization Parameters for a Physical Standby Database


      ------If you choose the parameter value for the standby database other than the pfile created from the Primary database, the              Controlfiles,user_dump_dest,background_dump_dest, core_dump_dest should also be changed for the standby database if necessary.------     




      DB_UNIQUE_NAME=cuuo
      LOG_ARCHIVE_CONFIG='DG_CONFIG=(cuuo,cuug)'---此处不修改
      LOG_ARCHIVE_DEST_1='LOCATION=/u02/app/oracle/oradata/cuuo/arch VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_N