Deleting orphaned data files after a tablespace import
Use the rdsadmin.rdsadmin_transport_util.list_xtts_orphan_files
procedure to
delete data files that were orphaned after a tablespace import. Running this command
generates a log file that uses the name format
rds-xtts-delete_xtts_orphaned_files-
in the YYYY-MM-DD.HH24-MI-SS.FF
.logBDUMP
directory. Use the procedure
rdsadmin.rdsadmin_transport_util.cleanup_incomplete_xtts_import
to find the
orphaned files. You can read the log file by calling the procedure
rdsadmin.rds_file_util.read_text_file
. For more information, see Phase 6: Clean up leftover files.
Syntax
PROCEDURE cleanup_incomplete_xtts_import( p_directory_name IN VARCHAR2);
Parameters
Parameter name | Data type | Default | Required | Description |
---|---|---|---|---|
|
|
— |
Yes |
The directory that contains the orphaned data files. |
Examples
The following example deletes the orphaned data files in
DATA_PUMP_DIR
.
BEGIN rdsadmin.rdsadmin_transport_util.cleanup_incomplete_xtts_import('
DATA_PUMP_DIR
'); END; /
The following example reads the log file generated by the previous command.
SELECT * FROM TABLE(rdsadmin.rds_file_util.read_text_file( p_directory => 'BDUMP', p_filename => '
rds-xtts-delete_xtts_orphaned_files-2023-06-01.09-33-11.868894000.log
')); TEXT -------------------------------------------------------------------------------- orphan transported datafile datafile_7.dbf deleted. orphan transported datafile datafile_8.dbf deleted.