Oracle 9i standby安装步骤总结

1：两边/etc/hosts
[oracle@s8 /etc]$ cat hosts
10.98.110.1             s8
10.98.110.2             s9
127.0.0.1               localhost.localdomain localhost
2: 两边$oracle_home/.rhosts
[oracle@s8 oracle9i]$ cat .rhosts
s8
s9
3：在一边建立数据库，并建立好所有表空间，表，索引等。
4：stop listener.创建standby control file;
alter database create standby controlfile as 'stactl01.ctl';
5:拷贝所有数据文件及日志文件，init文件拷贝至从机
6：修改standby的init文件
主：
*.log_archive_format='dzzds20%S_%T.arc'
*.log_archive_max_processes=10
*.log_archive_start=true
*.log_archive_dest_1='location=/u01/product/admin/dzzds20/arch'
*.log_archive_dest_2='SERVICE=s22  LGWR ASYNC NOAFFIRM'
*.log_archive_dest_state_2='ENABLE'
备：
*.log_archive_format='dzzds20%S_%T.arc'
*.log_archive_max_processes=10
*.log_archive_start=true
*.log_archive_dest='/u01/product/admin/dzzds20/arch'
*.REMOTE_ARCHIVE_ENABLE=TRUE
*.STANDBY_ARCHIVE_DEST='location=/u01/product/admin/dzzds20/arch2'
*.STANDBY_FILE_MANAGEMENT=AUTO
*.FAL_SERVER=s20
*.FAL_CLIENT=s22
7:tnsnames.ora里两边分别添加指向。
8:在备端
ALTER DATABASE ADD STANDBY LOGFILE ('/u01/product/oradata/dzzds20/stdredo41','/u01/product/oradata/dzzds20/stdredo42') size 100m;
9：备端启动脚本
#startup standby database

sqlplus /nolog <connect / as sysdba
prompt STARTUP NOMOUNT
STARTUP NOMOUNT;
prompt ALTER DATABASE MOUNT STANDBY DATABASE
ALTER DATABASE MOUNT STANDBY DATABASE;
prompt ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;
exit
EOF
10:切换脚本
#cancel and startup database
sqlplus /nolog <connect / as sysdba
prompt ALTER DATABASE RECOVER MANAGED STANDBY DATABASE nodelay
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE nodelay;
prompt #prompt ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH
prompt #ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH ;
prompt ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH SKIP STANDBY LOGFILE
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH SKIP STANDBY LOGFILE;
prompt ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY
ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY ;
prompt #prompt ALTER DATABASE ACTIVATE [PHYSICAL | LOGICAL] STANDBY DATABASE [SKIP [STANDBY LOGFILE]]
prompt #ALTER DATABASE ACTIVATE PHYSICAL  STANDBY DATABASE ;
prompt shutdown immediate
shutdown immediate
prompt startup
startup pfile='/u01/product/oracle9i/dbs/initusermng.ora'
exit