Oracle Drop Database ..
SQL> select name from v$datafile;
NAME
--------------------------------------------------------------------------------
/u01/app/oracle/oradata/vihcdb/system01.dbf
/u01/app/oracle/oradata/vihcdb/pdbseed/system01.dbf
/u01/app/oracle/oradata/vihcdb/sysaux01.dbf
/u01/app/oracle/oradata/vihcdb/pdbseed/sysaux01.dbf
/u01/app/oracle/oradata/vihcdb/undotbs01.dbf
/u01/app/oracle/oradata/vihcdb/users01.dbf
/u01/app/oracle/oradata/vihcdb/pdbseed/users01.dbf
/u01/app/oracle/oradata/vihcdb/pdbseed/usertbs01.dbf
/u01/app/oracle/oradata/ORA12CP/ao1_mf_system_dw9fo2v9_.dbf
/u01/app/oracle/oradata/ORA12CP/ao1_mf_sysaux_dw9fmon4_.dbf
/u01/app/oracle/oradata/ORA12CP/ao1_mf_users_dw9fpt4j_.dbf
11 rows selected.
SQL> !ls -ltr /u01/app/oracle/oradata/vihcdb/*
-rw-r----- 1 oracle oinstall 52429312 Sep 27 03:40 /u01/app/oracle/oradata/vihcdb/redo02a.log
-rw-r----- 1 oracle oinstall 52429312 Sep 27 03:40 /u01/app/oracle/oradata/vihcdb/redo03a.log
-rw-r----- 1 oracle oinstall 734011392 Sep 27 03:40 /u01/app/oracle/oradata/vihcdb/system01.dbf
-rw-r----- 1 oracle oinstall 634396672 Sep 27 03:40 /u01/app/oracle/oradata/vihcdb/undotbs01.dbf
-rw-r----- 1 oracle oinstall 524296192 Sep 27 03:40 /u01/app/oracle/oradata/vihcdb/users01.dbf
-rw-r----- 1 oracle oinstall 576724992 Sep 27 03:40 /u01/app/oracle/oradata/vihcdb/sysaux01.dbf
-rw-r----- 1 oracle oinstall 20979712 Sep 27 03:41 /u01/app/oracle/oradata/vihcdb/temp01.dbf
-rw-r----- 1 oracle oinstall 52429312 Sep 27 03:43 /u01/app/oracle/oradata/vihcdb/redo01a.log
-rw-r----- 1 oracle oinstall 17842176 Sep 27 03:43 /u01/app/oracle/oradata/vihcdb/ora_control1.ctl
-rw-r----- 1 oracle oinstall 17842176 Sep 27 03:43 /u01/app/oracle/oradata/vihcdb/ora_control2.ctl
/u01/app/oracle/oradata/vihcdb/pdbseed:
total 1092280
-rw-r----- 1 oracle oinstall 20979712 Sep 25 06:35 temp01.dbf
-rw-r----- 1 oracle oinstall 209723392 Sep 26 10:07 usertbs01.dbf
-rw-r----- 1 oracle oinstall 524296192 Sep 26 10:07 users01.dbf
-rw-r----- 1 oracle oinstall 209723392 Sep 26 10:07 sysaux01.dbf
-rw-r----- 1 oracle oinstall 173023232 Sep 26 10:07 system01.dbf
Imp !!!!!
**************************************
SQL> startup force mount restrict ;
ORACLE instance started.
Total System Global Area 1073741824 bytes
Fixed Size 2932632 bytes
Variable Size 713031784 bytes
Database Buffers 352321536 bytes
Redo Buffers 5455872 bytes
Database mounted.
Drop database command will delete Datafiles, Controlfiles, online redologfiles, Spfile
Drop database command will not delete init.ora file, password files, listener.ora file and it will also not remove entries from the oratab files.
SQL> drop database;
Database dropped.
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
No file now !!!!
SQL> !ls -ltr /u01/app/oracle/oradata/vihcdb/*
total 0
SQL> !cat /etc/oratab
#
vihcdb:/u01/app/oracle/product/12.1.0/db_1:N
No comments:
Post a Comment