Oracle8i 创建 Standby Database 步骤

create standby database

1.backup primary database datafiles


2.backup primary database controlfiles
 
   alter database create standby controlfile as 'd:/standby1.ctl'

3.copy primary server pfile and standby controlfile to standby server

  d:/oracle/admin/orcl/pfile.init.ora and d:/standby1.ctl

4. config standby database parameter file

   modify parameter control_files = ("D:/oracle/oradata/orcl/control01.ctl",...)
  
   add standby_archive_dest=D:/oracle/oradata/orcl/archive

5. startup standby database
   svrmgrl>connect sys/pwd@orcl as sysdba
   svrmgrl>shutdown immediate
   svrmgrl>startup nomount
   svrmgrl>alter database mount standby database
   svrmgrl>recover [managed] standby database

6. config primary database parameter files
 
   add tnsnames 'orcl70' to standby database

   add log_archive_dest_2 = 'SERVICE=orcl70' to parameter file

   alter database force log;