一：环境信息
1)主库（单实例）
主机平台：AIX6.1
数据库版本：11.2.0.3（psu5）
2)备库（部署了crs）
主机平台：AIX6.1
数据库版本：11.2.0.3（psu5）
二：方案背景
由于业务量增加，数据库需要由单实例，改成两节点rac。为了减少停机时间，采用DG方式迁移。
三迁移方案：
1.检查数据库是否支持Data Guard（只有企业版才支持DG）
SQL> select * from v$option where parameter = 'Managed Standby';
PARAMETER VALUE
---------------------------------------------------------------- ----------------------------------------------------------------
Managed Standby TRUE
2.修改主库为归档模式及force logging状态
1）
SQL> alter database force logging;
Database altered.
2）
SQL> archive log list;
如果未开归档，开启归档模式
alter system setlog_archive_dest_2='location=/archlog/egap';
alter system setlog_archive_format='egap_%t_%s_%r.arch'scope=spfile; --静态参数，重启后生效
shutdown immediate;
startup mount;
alter database archivelog;
alter database open;
archive log list;
3.创建备库pfile文件
在主库上创建pfile，修改，并添加DG备库所有参数，然后传至备库
SQL> create pfile='/data01/pfileegap'from spfile;
改变前参数文件
*.__db_cache_size=27648851968
*.__java_pool_size=67108864
*.__large_pool_size=67108864
*.__oracle_base='/apps/oracle'#ORACLE_BASE setfrom environment
*.__pga_aggregate_target=10334765056
*.__sga_target=30937186304
*.__shared_io_pool_size=0
*.__shared_pool_size=2952790016
*.__streams_pool_size=0
*.audit_file_dest='/apps/oracle/admin/egap/adump'
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='/data01/egap/control01.ctl','/data01/egap/control02.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_name='egap'
*.diagnostic_dest='/apps/oracle'
*.log_archive_dest_1='location=/archlog/egap'
*.log_archive_format='egap_%t_%s_%r.arch'
*.open_cursors=300
*.pga_aggregate_target=10307502080
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=30922506240
*.undo_tablespace='UNDOTBS1'
改变后参数文件
*.__db_cache_size=27648851968
*.__java_pool_size=67108864
*.__large_pool_size=67108864
*.__oracle_base='/apps/oracle'#ORACLE_BASE setfrom environment
*.__pga_aggregate_target=10334765056
*.__sga_target=30937186304
*.__shared_io_pool_size=0
*.__shared_pool_size=2952790016
*.__streams_pool_size=0
*.audit_file_dest='/apps/oracle/admin/egapdb/adump'
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='/data01/egapdb/control01.ctl','/data01/egapdb/control02.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_name='egap'
*.diagnostic_dest='/apps/oracle'
*.log_archive_dest_1='location=/archlog/egapdb1'
*.log_archive_dest_2='SERVICE=primary LGWR ASYNC
VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)
DB_UNIQUE_NAME=egap'
*.log_archive_format='egapdb_%t_%s_%r.arch'
*.open_cursors=300
*.pga_aggregate_target=10307502080
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=30922506240
*.undo_tablespace='UNDOTBS1'
*.DB_UNIQUE_NAME=egapdb
*.FAL_SERVER=primary
*.FAL_CLIENT=standby1
*.STANDBY_FILE_MANAGEMENT=AUTO
*.DB_FILE_NAME_CONVERT='/data01/egap','/data01/egapdb'
*.LOG_FILE_NAME_CONVERT='/data01/egap','/data01/egapdb'
*.LOG_ARCHIVE_CONFIG='DG_CONFIG=(egap,egapdb)'
###注意db_file_name_convert和log_file_name_convert参数指定的路径要存在
4）根据修改后的pfile创建备库spfile
export ORACLE_SID=egapdb1
sqlplus / assysdba
create spfile from pfile;
--使用新生成的spfile检查是否能够成功启动实例
4.生成备库的密码文件
scp主库密码文件到备库，并改名
如果主库没有密码文件，需要新建
orapwd file=/oracle/app/oracle/product/v11