<<Back to DB Administration Main Page
Droping the Database in Silent Mode Using DBCA
$ export ORACLE_HOME=/u01/dbatest1/12.2.0.1/dbp1$ export PATH=$PATH:$ORACLE_HOME/bin
$dbca -silent -deleteDatabase -sourceDB TESTDB -forceArchiveLogDeletion -sysDBAPassword xxxxxxx -sysDBAUserName sys
Connecting to database
4% complete
9% complete
14% complete
19% complete
23% complete
28% complete
47% complete
Updating network configuration files
48% complete
52% complete
Deleting instance and datafiles
76% complete
100% complete
Look at the log file "/u01/dbatest1/cfgtoollogs/dbca/TESTDB.log" for further details.
4% complete
9% complete
14% complete
19% complete
23% complete
28% complete
47% complete
Updating network configuration files
48% complete
52% complete
Deleting instance and datafiles
76% complete
100% complete
Look at the log file "/u01/dbatest1/cfgtoollogs/dbca/TESTDB.log" for further details.
Note: If you are deleting the database in silent mode, DBCA will not prompt you for any confirmation
Lets Check the Log
$cat /u01/dbatest1/cfgtoollogs/dbca/TESTDB.log
[ 2018-06-18 11:14:01.891 CEST ] The Database Configuration Assistant will delete the Oracle instance and datafiles for your database. All information in the database will be destroyed. Do you want to proceed?
[ 2018-06-18 11:14:01.963 CEST ] Connecting to database
DBCA_PROGRESS : 4%
DBCA_PROGRESS : 9%
DBCA_PROGRESS : 14%
DBCA_PROGRESS : 19%
DBCA_PROGRESS : 23%
DBCA_PROGRESS : 28%
DBCA_PROGRESS : 47%
[ 2018-06-18 11:15:21.051 CEST ] Updating network configuration files
DBCA_PROGRESS : 48%
DBCA_PROGRESS : 52%
[ 2018-06-18 11:15:21.109 CEST ] Deleting instance and datafiles
DBCA_PROGRESS : 76%
DBCA_PROGRESS : 100%
[ 2018-06-18 11:15:21.475 CEST ] Database deletion completed.
[ 2018-06-18 11:14:01.891 CEST ] The Database Configuration Assistant will delete the Oracle instance and datafiles for your database. All information in the database will be destroyed. Do you want to proceed?
[ 2018-06-18 11:14:01.963 CEST ] Connecting to database
DBCA_PROGRESS : 4%
DBCA_PROGRESS : 9%
DBCA_PROGRESS : 14%
DBCA_PROGRESS : 19%
DBCA_PROGRESS : 23%
DBCA_PROGRESS : 28%
DBCA_PROGRESS : 47%
[ 2018-06-18 11:15:21.051 CEST ] Updating network configuration files
DBCA_PROGRESS : 48%
DBCA_PROGRESS : 52%
[ 2018-06-18 11:15:21.109 CEST ] Deleting instance and datafiles
DBCA_PROGRESS : 76%
DBCA_PROGRESS : 100%
[ 2018-06-18 11:15:21.475 CEST ] Database deletion completed.
DB AlertLog Extract
$ tail -f alert_TESTDB.log
2018-06-18T11:15:12.676101+02:00
USER (ospid: 4669): terminating the instance
2018-06-18T11:15:13.679109+02:00
Instance terminated by USER, pid = 4669
2018-06-18T11:15:18.679500+02:00
Completed: DROP DATABASE
Shutting down instance (abort) (OS id: 4669)
License high water mark = 4
2018-06-18T11:15:21.041128+02:00
Instance shutdown complete (OS id: 4669)
2018-06-18T11:15:12.676101+02:00
USER (ospid: 4669): terminating the instance
2018-06-18T11:15:13.679109+02:00
Instance terminated by USER, pid = 4669
2018-06-18T11:15:18.679500+02:00
Completed: DROP DATABASE
Shutting down instance (abort) (OS id: 4669)
License high water mark = 4
2018-06-18T11:15:21.041128+02:00
Instance shutdown complete (OS id: 4669)
Syntax
$ dbca -silent -deleteDatabase -help
-deleteDatabase - Command to Delete a database.
-sourceDB <Database unique name for RAC database or SID for Single Instance database>
[-deRegisterEMCloudControl ]
-emUser <EM Admin username to add or modify targets>
-omsHost <EM management server host name>
-omsPort <EM management server port number>
[-emPassword <EM Admin user password>]
[-forceArchiveLogDeletion <To delete archive logs of a database>]
[-sid <Database system identifier>]
[-sysDBAPassword <Password for sysDBAUserName user name>]
[-sysDBAUserName <User name with SYSDBA privileges>]
-deleteDatabase - Command to Delete a database.
-sourceDB <Database unique name for RAC database or SID for Single Instance database>
[-deRegisterEMCloudControl ]
-emUser <EM Admin username to add or modify targets>
-omsHost <EM management server host name>
-omsPort <EM management server port number>
[-emPassword <EM Admin user password>]
[-forceArchiveLogDeletion <To delete archive logs of a database>]
[-sid <Database system identifier>]
[-sysDBAPassword <Password for sysDBAUserName user name>]
[-sysDBAUserName <User name with SYSDBA privileges>]
Comments
Post a Comment