Oracle v19 RMAN > drop database including backups noprompt; taking over 2 hours. Why? Hung?
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….