Dropping 9i Database (PROD/RMAN)

1. Drop backups using rman

rman target=sys/pwd@connect_string catalog rman/pwd@rman

RMAN> LIST BACKUP SUMMARY;

RMAN> DELETE BACKUP

 2. Unregister database

SQL> CONNECT rman/rman@rman Connected.

SQL> SELECT db_key, db_id FROM   db;


  DB_KEY      DB_ID

       1 1465981354

SQL> EXECUTE dbms_rcvcat.unregisterdatabase(1, 1465981354);

PL/SQL procedure successfully completed.

3. Drop rman database

Use dbca to drop database

4. Drop prod database

Use dbca to drop database

Note: If Database is created manually without using DBCA utility then add the entry in ORATAB for DBCA to identify the database

5. Removing 9i Software:

Login as software owner

Run /install/runinstaller and uninstall oracle software