主库：vsgpdb
备库：dgdb
1、确认主库处于归档模式
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /gp/arch
Oldest online log sequence 1307
Next log sequence to archive 1312
Current log sequence 1312
2、将primary 数据库置为FORCE LOGGING 模式。通过下列语句：
SQL> select force_logging from v$database;
FOR
---
YES
SQL> alter database force logging;
3.配置Primary数据库的初始化参数
修改客户端初始化参数文件，增加下列内容
*.DB_UNIQUE_NAME=vsgpdb
*.LOG_ARCHIVE_CONFIG='DG_CONFIG=(vsgpdb,dgdb)'
*.LOG_ARCHIVE_DEST_2='SERVICE=dgdb LGWR SYNC AFFIRM VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=dgdb'
*.LOG_ARCHIVE_DEST_STATE_2=DEFER
SQL> alter system set LOG_ARCHIVE_CONFIG='DG_CONFIG=(vsgpdb,dgdb)';
SQL> alter system set LOG_ARCHIVE_DEST_2='SERVICE=dgdb LGWR SYNC AFFIRM
VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=dgdb';
SQL> alter system set LOG_ARCHIVE_DEST_STATE_2=DEFER;
#--------配置standby 角色的参数用于角色转换
*.FAL_SERVER=DGDB
*.FAL_CLIENT=VSGPDB
*.DB_FILE_NAME_CONVERT='/opt/ora10g/oradata/vsgpdb','/opt/dgdb/oradata/dgdb'
*.LOG_FILE_NAME_CONVERT='/opt/ora10g/oradata/vsgpdb','/opt/dgdb/oradata/dgdb'
*.STANDBY_FILE_MANAGEMENT=AUTO
SQL> alter system set FAL_SERVER=DGDB;
System altered.
SQL> alter system set FAL_CLIENT=VSGPDB;
System altered.
SQL> alter system set DB_FILE_NAME_CONVERT='/opt/ora10g/oradata/vsgpdb','/opt/dgdb/oradata/dgdb';
alter system set DB_FILE_NAME_CONVERT='/opt/ora10g/oradata/vsgpdb','/opt/dgdb/oradata/dgdb'
*
ERROR at line 1:
ORA-02096: specified initialization parameter is not modifiable with this
option
SQL> alter system set DB_FILE_NAME_CONVERT='/opt/ora10g/oradata/vsgpdb','/opt/dgdb/oradata/dgdb','/gp/oradata', '/opt/dgdb/oradata/dgdb' scope=spfile;
System altered.
SQL>
SQL> alter system set LOG_FILE_NAME_CONVERT='/opt/ora10g/oradata/vsgpdb','/opt/dgdb/oradata/dgdb' scope=spfile;
SQL> alter system set STANDBY_FILE_MANAGEMENT=AUTO;
修改完之后重启
4.创建控制文件--primary 库操作
SQL> alter database create standby controlfile as '/opt/ora10g/oradata/vsgpdb/dgdb03.ctl';
SQL> create pfile from spfile;
File created.
shutdown immediate --一定要关掉主库再传送数据文件
5.传送文件到备库
初始化参数文件+控制文件+数据文件
备：192.168.165.26是备库IP
scp /opt/ora10g/product/10.2.0/db_1/dbs/initvsgpdb.ora dgdb@192.168.165.26:/opt/dgdb/product/10.2.0/db_1/dbs/initdgdb.ora
scp /opt/ora10g/oradata/vsgpdb/dgdb03.ctl dgdb@192.168.165.26:/opt/dgdb/oradata/dgdb/dgdb01.ctl
scp /opt/ora10g/oradata/vsgpdb/dgdb03.ctl dgdb@192.168.165.26:/opt/dgdb/oradata/dgdb/dgdb02.ctl
scp /opt/ora10g/oradata/vsgpdb/dgdb03.ctl dgdb@192.168.165.26:/opt/dgdb/oradata/dgdb/dgdb03.ctl
scp /opt/ora10g/oradata/vsgpdb/redo02.log dgdb@192.168.165.26:/opt/dgdb/oradata/dgdb/
scp /opt/ora10g/oradata/vsgpdb/system01.dbf dgdb@192.168.165.26:/opt/dgdb/oradata/dgdb/
scp /gp/oradata/undo0201.dbf dgdb@192.168.165.26:/opt/dgdb/oradata/dgdb/
scp /opt/ora10g/oradata/vsgpdb/redo01.log dgdb@192.168.165.26:/opt/dgdb/oradata/dgdb/
scp /opt/ora10g/oradata/vsgpdb/redo03.log dgdb@192.168.165.26:/opt/dgdb/oradata/dgdb/
scp /opt/ora10g/oradata/vsgpdb/sysaux01.dbf dgdb@192.168.165.26:/opt/dgdb/oradata/dgdb/
scp /opt/ora10g/oradata/vsgpdb/temp01.dbf dgdb@192.168.165