OCM_Session8_1_PreparingthePrimaryDatabaseforStandbyDatabaseCreation(一)

要求部署物理standby并进行主备切换测试官方文档：Data Guard Concepts and Administration -> 3 Creating a physical Standby Database 和 7 Role Transitions 注意事项：（1）建议手工配置DG，手工配置和GC配置不可交叉（2）不使用real-time (实时)方式启动自动恢复，采用性能最大化模式.LGWR ASYNC （3）使用LGWR传输日志模式，也可以ARCH传输日志模式（4）备库启动多个MRP恢复进程，加快日志应用效率（5）进行两次主备切换
我的环境 OS:Oracle Linux 5.7U database:10.2.0.1
主库： ip：192.168.1.155 主库实例名：PROD hostname:ocm1.localdomain
备库： ip:192.168.1.156 备库实例名：PRODSTD hostname：ocm2.localdomain

参考官方文档： Data Guard Concepts and Administration -> 3 Creating a physical Standby Database 和 7 Role Transitions http://docs.oracle.com/cd/B19306_01/server.102/b14239/toc.htm
准备工作：
设置sqlplus命令行提示符样式：
ocm1
[oracle@ocm1 ~]$ vi $ORACLE_HOME/sqlplus/admin/glogin.sql 最后一行添加以下内容 set sqlprompt "_user'@'_connect_identifier>"
[oracle@ocm1 ~]$ sqlplus "/as sysdba"
SQL*Plus: Release 10.2.0.1.0 - Production on Tue Mar 25 08:44:19 2014
Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production With the Partitioning, OLAP and Data Mining options
SYS@PROD> SYS@PROD>select instance_name,version,status,archiver,database_status from v$instance;
INSTANCE_NAME VERSION STATUS ARCHIVE DATABASE_STATUS ---------------- ----------------- ------------ ------- ----------------- PROD 10.2.0.1.0 OPEN STARTED ACTIVE
检查数据文件和表空间 SYS@PROD>select file_name,tablespace_name from dba_data_files;
FILE_NAME TABLESPACE_NAME -------------------------------------------------- ------------------------------ /u01/app/oracle/oradata/PROD/Disk1/system01.dbf SYSTEM /u01/app/oracle/oradata/PROD/Disk1/undotbs01.dbf UNDOTBS1 /u01/app/oracle/oradata/PROD/Disk1/sysaux01.dbf SYSAUX /u01/app/oracle/oradata/PROD/Disk1/example01.dbf EXAMPLE /u01/app/oracle/oradata/PROD/Disk1/users01.dbf USERS

SYS@PROD>select * from v$tablespace;
TS# NAME INC BIG FLA ENC ---------- ------------------------------ --- --- --- --- 0 SYSTEM YES NO YES 1 UNDOTBS1 YES NO YES 2 SYSAUX YES NO YES 3 TEMPTS1 NO NO YES 7 EXAMPLE YES YES YES 10 USERS YES NO YES
6 rows selected.

ocm2也一起设置：
[oracle@ocm2 ~]$ vi $ORACLE_HOME/sqlplus/admin/glogin.sql set sqlprompt "_user'@'_connect_identifier>"
这样方便识别那个用户登录了那台数据库。避免混淆。

开始建立物理备库
1.Preparing the Primary Database for Standby Database Creation

Table 3-1 Preparing the Primary Database for Physical Standby Database Creation