standby 的维护

显示全部楼层 · 2005-4-12 20:54:27

1 日常维护
其中10.98.33.1为主机，归档路径为/u01/arch01；10.98.33.2为从机，归档路径为/u01/arch01,stand归档路径为/u01/arch02。主机的每日监控内容主要为监控数据库告警日志，查看是否有ORA错误。
从机每日监控的内容除了查看告警日志外，还需查看数据的同步情况，具体步骤为：
1，
sqlplus “/ as sysdba”
2，
select * from v$archived_gap
查看是否有日志没有和主数据库同步。
3，
select recid,name,applied from v$archived_log;
查看所对应主机中的归档日志文件是否都已同步到了从机数据库中。
如果在主机中执行alter system switch logfile;生成的日志文件没有传输到stand归档路径中，如果没有，则查看网络环境和net8是否有问题。如果日志文件已传送到stand归档路径中，但长时间没有同步到从数据库中（applied 为‘NO’）则可能从数据库有问题（数据文件或控制文件损坏），
standby 的启动脚本：
# startup standby database
sqlplus /nolog <<EOF
connect / as sysdba
prompt STARTUP NOMOUNT
STARTUP NOMOUNT pfile='/u01/product/oracle9i/dbs/initstandby.ora';
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

千问 · 2005-4-12 20:54:27

failover 的脚本：
#cancel and startup database
sqlplus /nolog <<EOF
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 PHYSICALSTANDBY DATABASE ;
prompt shutdown immediate
shutdown immediate
prompt startup
startup pfile='/u01/product/oracle9i/dbs/inititown01.ora'
exit
EOF