New 'drop database' statement in oracle 10g RMAN (Oracle Recovery Manager) Database Dropping and Deregistration - The new DROP DATABASE and its UNREGISTER DATABASE using RMAN commands. Its removes the database and its from the RMAN recovery catalog.
This command drop the entire database and its database files also.
Code:
DROP DATABASE INCLUDING BACKUPS;
This statement to remove the database, remove the database files and deleted the all backup files include archive files.
Code:
SQL> UNREGISTER DATABASE GRID;
This statement to remove the database information from the RMAN catalog.