ITPub博客

来自oracle 9i文档 《Advanced Replication》3-26[@more@]具有快速刷新特性的物化视图的子查询遵循的限制1 Materialized views must be primary key materialized views.2 the master's materialized view logs must include certain columns referenced in the subquery.3 if the subquery is many to many or one to many , join columns that are not part of a primary key must be include in the materialized view log of the master .this restriction dose not apply to many to one subqueries.4 the subquery must be a posit

dataguard日常维护[@more@]l 启用备用数据库的方法startup nomount;alter database mount standby database; 手工恢复模式alter database recover managed standby database disconnect from session; 管理恢复模式l 备用库只能以read noly方式打开，步骤如下：alter database recover managed standby database finish/cancel;alter database open read only;切换回恢复模式alter database recover managed standby database disconnect from session;打开之后，为了避免排序出错，需要Alter tablespace add tempfile ‘

可能看着有点儿乱，基本思路是利用控制文件复制一个库到灾备机，然后配置dataguard，最后由最大性能升级到最大可用性。[@more@]环境描述A机：primary（这里A机在现场为HA的主，对于主的所有参数调整都要对备作相应调整）192.168.1.4B机：standby（这里指现场的灾备机）192.168.1.7Oracle_SID是testdb。环境：aix , Oracle版本：9.2.0.6第一步：核查并创建oracle软件副本检查A机、B机的oracle版本是否一致如果一致，不做任何操作。检查路径profile文件如果不一致，将A机的$ORACLE_HOME目录打包，然后传送到B机，解压缩，路径保持一致，调整

控制文件复制oracle数据库,standby ,dataguard实施的一部分[@more@]1、利用tar复制oracle安装软件。保证两边oracle版本一致。2、主库操作调整为归档模式>startup mount>alter database archivelog;>archive log list;创建RMAN备份rman target / nocatalogRMAN> run{ allocate channel d1 type disk; backup database format '/tape_backup/temp/backup%d%U.rman';}创建standby的控制文件上一步成功做完之后SQL>alter database create standby controlfile as '/oracle/final/syrunstandby.ctl';3、复制库主机操作创建如下目

rman，复制[@more@]一次数据库复制试验环境sun v490,solaris 9,oracle 9201数据库的备份1、定时0 4 * * * /space/oracle_backup/db_backup.sh >> /space/oracle_backup/backup.log 2>&12、shell脚本内容#!/bin/sh. /oracle/.bash_profileecho "Beginning time:" `date +'%Y-%m-%d %H:%M'`env/oracle/OraHome/bin/rman @/space/oracle_backup/backup.rmanecho "End time:" `date +'%Y-%m-%d %H:%M'3、rman备份脚本内容connect target /connect catalog rman/password@db_rman2;list backup;report obsole