How do I resolve the error that I receive when I use the rdsadmin.rds_file_util.listdir command in Amazon RDS for Oracle?

1 minute read
0

I want to resolve the error that I receive when I run the rdsadmin.rds_file_util.listdir command in Amazon Relational Database System (Amazon RDS) for Oracle.

Short description

When you use the rdsadmin.rds_file_util.listdir command to view the list of files in the DATA_PUMP_DIR and BDUMP directories, you might receive the following error message:

“SQL> select * from table(RDSADMIN.RDS_FILE_UTIL.LISTDIR(p_directory => 'BDUMP'));
select * from table(RDSADMIN.RDS_FILE_UTIL.LISTDIR(p_directory => 'BDUMP')) * ERROR at line 1:
ORA-20199: Error in rdsadmin.rds_file_util.
ORA-06512: at "RDSADMIN.RDS_FILE_UTIL", line 47"

Resolution

To resolve this error, use one of the following workarounds:

  • Turn on automated backups.
  • Run the following RMAN validate command:

Note: Replace example-users with your users.

exec rdsadmin.rdsadmin_rman_util.validate_tablespace('example-users');

Example output:

SQL> exec rdsadmin.rdsadmin_rman_util.validate_tablespace('example-users');
PL/SQL procedure successfully completed.

Related information

Listing files in a DB instance directory

Enabling automated backups

Validating a tablespace

AWS OFFICIAL
AWS OFFICIALUpdated 5 months ago