You might want to access your online and archived redo log files for mining with external tools such as GoldenGate, Attunity, Informatica, and others. To access these files, do the following:
-
Create directory objects that provide read-only access to the physical file paths.
Use
rdsadmin.rdsadmin_master_util.create_archivelog_dirandrdsadmin.rdsadmin_master_util.create_onlinelog_dir. -
Read the files using PL/SQL.
You can read the files by using PL/SQL. For more information about reading files from directory objects, see Listing files in a DB instance directory and Reading files in a DB instance directory.
Accessing transaction logs is supported for the following releases:
-
Oracle Database 21c
-
Oracle Database 19c
The following code creates directories that provide read-only access to your online and archived redo log files:
Important
This code also revokes the DROP ANY DIRECTORY privilege.
EXEC rdsadmin.rdsadmin_master_util.create_archivelog_dir;
EXEC rdsadmin.rdsadmin_master_util.create_onlinelog_dir;The following code drops the directories for your online and archived redo log files.
EXEC rdsadmin.rdsadmin_master_util.drop_archivelog_dir;
EXEC rdsadmin.rdsadmin_master_util.drop_onlinelog_dir;The following code grants and revokes the DROP ANY DIRECTORY
privilege.
EXEC rdsadmin.rdsadmin_master_util.revoke_drop_any_directory;
EXEC rdsadmin.rdsadmin_master_util.grant_drop_any_directory;