Webfly Blog

Drop oracle database digital ocean

We have database with SID=RAILDB01 and drop database from server on DigitalOcean. Use the DROP DATABASE command to delete the target database, RMAN is connected to a recovery catalog and unregister it. RMAN removes all data files, online redo logs, and control files belonging to the target database.

user oracle:

[oracle@linux-oracle-fra ~]$ export ORACLE_SID=RAILDB01


[oracle@linux-oracle-fra ~]$ RMAN
RMAN> connect target /
connected to target database: RAILDB01 (DBID=3992714519)

List all backup database RAILDB01, STB_TAPE is Amazon AWS Bucket

RMAN> list backup summary;

List of Backu...

RMAN Oracle db in DigitalOcean

Backup Oracle database, where is installed in Digital Ocean droplet (virtual server).

Oracle status:

SQL*Plus: Release Production on Mon Oct 10 07:26:19 2016
Copyright (c) 1982, 2014, Oracle.  All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> select instance_name,status,database_status,archiver,version from v$instance;

---------------- ------------ ----------------- --...