Accessing online and archived redo logs
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;
Warning Javascript is disabled or is unavailable in your browser.
To use the Amazon Web Services Documentation, Javascript must be enabled. Please refer to your browser's Help pages for instructions.