ITPub博客

http://space.itpub.net/756652/viewspace-442206[@more@]FIY.

Below is the process of the testing. Primary Side. O01DMS0Target Side. O01LEE3[@more@]PURPOSE-------This Notes explains how to exclude (filter out) specific tables from the capture process and replication, when using schema level Streams replication.SCOPE & APPLICATION-------------------To be used by DBA's as a reference when configuring and implementing the Oracle Streams capture process for schema replication.PROBLEM-------You have configured the Streams capture process at the schema level

This article is intended to quickly setup a stream environment for playing in which the schema HR in primary side will be in sync with the one in target side.[@more@]Primary Side. O01DMS0Target Side. O01LEE3########################################################################################1.1> Logon to SYS to create an account for stream at primary side.SQL> show userUSER is "SYS"SQL>SQL> create user strmadmin identified by strmadmin 2 default tablespace tbs_stream t

数据库DataGuard配置文档VERSION: 1.1.0LAST UPDATE: 2005-03-28MSN: foreverlee0619@msn.com[@more@]Primary database (Oracle 10g)IP:172.16.75.35INSTANCE_NAME=ora1Standby database (Oracle 10g)IP:172.16.75.30INSTANCE_NAME=ora21 前期操作系统级别准备: 设置操作系统用户profile文件,注意ORACLE_SID,ORACLE_BASE,ORACLE_HOME,PATH,NLS_LANG变量的设置主数据库服务器端IP:172.16.75.35[oracle@db1 ora10g]$ cat .bash_profile # .bash_profile# Get the aliases and functionsif [ -f ~/.bashrc ]; then. ~/.bashrcfi# User specif

数据库采用.Primary database (Oracle 10g)IP:172.16.75.35INSTANCE_NAME=ora1Standby database (Oracle 10g)IP:172.16.75.30INSTANCE_NAME=ora2[@more@]数据库采用Oracle 10g版本.Dataguard采用最大性能模式.Primary database (Oracle 10g)IP:172.16.75.35INSTANCE_NAME=ora1Standby database (Oracle 10g)IP:172.16.75.30INSTANCE_NAME=ora2第一部分 日常维护一 正确打开主数据库和从数据库1 主数据库端: IP:172.16.75.35SQL> STARTUP MOUNT;SQL> ALTER DATABASE ARCHIVELOG;SQL> ALTER DATABASE OPEN;2 从数据库端: IP:172.16