Database Administration (MOSC)

MOSC Banner

Flashback logs not deleted while importing a huge table

edited Jun 4, 2019 11:09PM in Database Administration (MOSC) 4 commentsAnswered

Hi,

Oracle 12.2.0.1. EE with OL7, we use OMF, multitenant and local undo:

Today we had to export, truncate, import a table of near 80G, because we had to freeing wasted space due former deletion of many rows in that table.

I know, enable row movement and shrink space would be also an option, but we decided to take this way.

While importing the dump with direct_path option enabled, we observed that the FRA was filled up with archived logs and flashback logs up to 95% of db_recovery_file_dest_size. No flashback logs were deleted.

There are only archived and flashback logs in the FRA. At 95 Percent occupied space we decide to increase "db_recovery_file_dest_size", the import succeded.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center