redo日志和归档日志挖掘 1.生产环境日志在测试环境挖掘 生产环境为11G,测试环境为12C 1.1生产库创建目录,生成字典文件 SQL> CREATE OR REPLACE DIRECTORY MYDATA AS '/path/to/directory'; set line 999 pages 999 col OWNER for a10 col DIRECTORY_NAME for a2
环境:源端Windows2008,目标端Centos7.9 1、两端创建备份恢复目录 CREATE DIRECTORY directory_name AS 'path_to_directory'; grant read,write on DIRECTORY directory_name to public ; 2、源端数据泵导出数据 expdp system/Passwd@servername d