Database Backup and Recovery (MOSC)

MOSC Banner

Oracle v19 RMAN > drop database including backups noprompt; taking over 2 hours. Why? Hung?

edited Apr 29, 2025 6:42PM in Database Backup and Recovery (MOSC) 5 commentsAnswered

Oracle v19 database on Linux 64bit RHEL 7 server.

We want to drop a test/dev database which has corrupted data files and backup files it was the secondary db replicated from a primary db (also test db). Because it is only for testing we thought rebuilding was fastest option.

The DROP DATABASE command has been running for over 2 hours and we are worried something is very wrong.

We did the following:

DGMGRL > disable configuration;

Disabled.

SQL> shutdown immediate;

RMAN> startup force mount;

RMAN> alter system enable restricted session;

RMAN> drop database including backups noprompt;

we saw all back up files removed… all archivelog files removed….

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