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

Use RMAN:

[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 12.1.0.2.0 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 12.1.0.2.0 - 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;

INSTANCE_NAME    STATUS       DATABASE_STATUS   ARCHIVE VERSION
---------------- ------------ ----------------- --...