发布时间：2014-09-22 15:22:33
5.修改主库参数文件
*.audit_file_dest='/u01/app/admin/dbpay/adump'
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='/u01/app/oradata/dbpay/control01.ctl','/u01/app/flash_recovery_area/dbpay/control02.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_file_name_convert='/u01/app/oradata/dbpay/','/u01/app/oradata/dbpay/'
*.db_name='dbpay'
*.db_recovery_file_dest='/u01/app/flash_recovery_area'
*.db_recovery_file_dest_size=4070572032
*.db_unique_name='dbpay1'
*.dia......【阅读全文】
发布时间：2014-08-20 14:05:47
装完GoldenGate后需要执行两步操作,在Source端。
Sql> alter database add supplemental log data;
Sql> alter system switch logfile;
Sql> desc v$database
Sql> select supplemental_log_data_min from v$database;
在Source和target把库都起来，并创建gg用户
Sql>create user ggusr identified by ggusr default tablespace users;
Sql>grant connect,resource to ggusr;......【阅读全文】
发布时间：2014-05-21 13:25:37
ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode
......【阅读全文】
