Log mining a Redo log file / Archive log file on a remote database
At the source site Enable the database to write to a directory you choose, in this example I use /tmp alter system set utl_file_dir='/tmp' scope=spfile; Restart of the database is required in order for the parameter utl_file_dir be active Extract the LogMiner dictionary to a flat file called dictionary.ora EXECUTE DBMS_LOGMNR_D.BUILD('dictionary.ora', '/tmp', DBMS_LOGMNR_D.STORE_IN_FLAT_FILE); Copy redo log file from source to target: Copy redo log file from ASM to the operating system asmcmd cp '+DATA/PDB/ONLINELOG/group_1.259.919359545' /tmp Copy the the redo log file to the target host scp /tmp/dictionary.ora /tmp/group_1.259.919359545 target_host:/tmp Copy the dictionary file from source to target scp /tmp/dictionary.ora /tmp/group_1.259.919359545 target_host:/tmp On target db alter system set utl_file_dir='/tmp' scope=spfile; Restart of the database is required in order for the...