Zhong Weicheng Study Notes

Operating System:Oracle Linux 5.7 x86_64Oracle version:10.2.0.5RAC Primary database192.168.1.51            racnode1192.168.1.151           racnode1-vip172.168.1.51            racnode1-

DB_UNIQUE_NAME定义数据库唯一名称，因为DB_NAME参数对于物理数据库是必须相同，对于逻辑数据库必须不同，所以在Oracle 10g中引入DB_UNIQUE_NAME参数来确定DataGuard配置中的每个数据库，如果未定义该参数，默认使用DB_NAME参数值。LOG_ARCHIVE_CONFIG定义DataGuard配置的有效DB_UNIQUE_NAME参数列表

primary 环境DB version:oracle10.2.0.4IP:192.168.1.7hostname:vzwcdb_name:dbserverdb_unique_name:dbserverservice_name:dbserverinstance_name:ORCLstandby 环境DB version:oracle10.2.0.4IP:

The following Unix shell scripts can be used to automate the Data Guard Switchover process of a physical standby database.It is very important that the scripts are run in the correct order and on

当Physical DataGuard主库归档日志丢失，使用RMAN或者OS命令删除了归档日志，并且归档日志未传输到Standby端，这样Standby端会产生GAP，可以将Primary端的归档拷贝到Standby端然后使用register命令注册，例如ALTER DATABASE REGISTER LOGFILE '/arch/ARC0000000068_0839199018.0001'，

primary databasedb_name=zwc, db_unique_name=zwcstandby databasedb_name=zwc, db_unique_name=standbyon primary database[oracle@vmdb12c ~]$ sqlplus sys/oracle@zwc as sysdbaSQL*Plu

操作环境PrimaryStandbyClusterware11.2.0.3 Grid Infrastructure11.2.0.3 Grid InfrastructureCluster Nodesvzwc1,vzwc2,vzwc3(3-Nodes)sd-vzwc1,s

on primary databaseSQL> select database_role from v$database;DATABASE_ROLE----------------PRIMARYSQL> alter database commit to switchover to physical standby;Database altered.SQL> select o

ON STANDBY SITESQL> select * from v$version;BANNER--------------------------------------------------------------------------------Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bi

on primary databaseSQL> alter database force logging;Database altered.SQL> alter database add standby logfile group 4 size 50M;Database altered.SQL> alter database add standby logfile grou

Step By Step Configuring Oracle 10gR2 (10.2.0.5) 3-Nodes RAC to Single DataguardDG配置参考上面链接。主库环境是3-nodes的 RAC,保证实例racdb1正常运行,关闭racdb2和racdb3实例。备库至于mount状态。[oracle@standby arch]$ sqlplus / a

logical standby是在physical standby基础上搭建Oracle10g Physical DataGuard 详细搭建过程--停止standby上的日志应用SQL> alter database recover managed standby database  cancel;Database altered.--