We need to remove database created only fr test purpose using RMAN duplicate command.
SQL> shutdown immediate;
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL>
SQL>
SQL> startup mount exclusive restrict;
ORACLE instance started.
Total System Global Area 7348420608 bytes
Fixed Size 2150272 bytes
Variable Size 1201614976 bytes
Database Buffers 6006243328 bytes
Redo Buffers 138412032 bytes
Database mounted.
SQL>
SQL> drop database;
Database dropped.
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL>
Drop database command remove data files and control files from OS level.
No comments:
Post a Comment