dbca silent mode deleteDB 실행하기(테스트 db 날릴때 유용)

OS환경 : Oracle Linux 6.8(64bit)

DB 환경 : Oracle Database 10.2.0.4

방법 : dbca -silent -deleteDatabase -sourceDB orcl -sysDBAUserName sys -sysDBAPassword 패스워드

1. DB를 open 상태로 만들어 둔다.

SYS@orcl> startup

ORACLE instance started.

Total System Global Area  285212672 bytes

Fixed Size     2095704 bytes

Variable Size   184550824 bytes

Database Buffers    92274688 bytes

Redo Buffers     6291456 bytes

Database mounted.

Database opened.

2. 아래 명령어를 실행한다.

[oracle@oracle ]$ dbca -silent -deleteDatabase -sourceDB orcl -sysDBAUserName sys -sysDBAPassword 패스워드

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 "/oracle/app/oracle/pro

99. deleteDatabase 명령어 실행 시 alert.log

Fri Mar 23 12:53:07 KST 2018 

Shutting down instance (immediate)

Fri Mar 23 12:53:07 KST 2018

Shutting down instance: further logons disabled

Fri Mar 23 12:53:07 KST 2018

Stopping background process CJQ0

Fri Mar 23 12:53:07 KST 2018 

Stopping background process QMNC

Fri Mar 23 12:53:08 KST 2018

Stopping background process MMNL

Fri Mar 23 12:53:08 KST 2018

Stopping background process MMON

Fri Mar 23 12:53:08 KST 2018

statement in resumable session 'SYSTEM.SYS_IMPORT_FULL_01.1' was aborted

Fri Mar 23 12:53:09 KST 2018

License high water mark = 23

Fri Mar 23 12:53:09 KST 2018

Job queue slave processes stopped

All dispatchers and shared servers shutdown

Fri Mar 23 12:53:12 KST 2018

ALTER DATABASE CLOSE NORMAL

Fri Mar 23 12:53:12 KST 2018

SMON: disabling tx recovery

SMON: disabling cache recovery

Fri Mar 23 12:53:12 KST 2018

Shutting down archive processes

Archiving is disabled

Archive process shutdown avoided: 0 active

Thread 1 closed at log sequence 8

Successful close of redo thread 1

Fri Mar 23 12:53:12 KST 2018

Completed: ALTER DATABASE CLOSE NORMAL

Fri Mar 23 12:53:12 KST 2018

ALTER DATABASE DISMOUNT

Completed: ALTER DATABASE DISMOUNT

ARCH: Archival disabled due to shutdown: 1089

Archive process shutdown avoided: 0 active

ARCH: Archival disabled due to shutdown: 1089

Shutting down archive processes

Archiving is disabled

Archive process shutdown avoided: 0 active

Fri Mar 23 12:53:12 KST 2018

Starting ORACLE instance (normal)

LICENSE_MAX_SESSION = 0

LICENSE_SESSIONS_WARNING = 0

Picked latch-free SCN scheme 3

Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST

IMODE=BR

ILAT =18

LICENSE_MAX_USERS = 0

SYS auditing is disabled

ksdpec: called for event 13740 prior to event group initialization

Starting up ORACLE RDBMS Version: 10.2.0.5.0.

System parameters with non-default values:

  processes                = 150

  __shared_pool_size       = 117440512

  __large_pool_size        = 4194304

  __java_pool_size         = 16777216

  __streams_pool_size      = 8388608

  sga_target               = 285212672

  db_block_size            = 8192

  __db_cache_size          = 130023424

  compatible               = 10.2.0.5.0

  db_file_multiblock_read_count= 16

  db_recovery_file_dest    = /oracle/app/oracle/flash_recovery_area

  db_recovery_file_dest_size= 2147483648

  undo_management          = AUTO

  undo_tablespace          = UNDOTBS1

  remote_login_passwordfile= EXCLUSIVE

  db_domain                =

  dispatchers              = (PROTOCOL=TCP) (SERVICE=orclXDB)

  job_queue_processes      = 10

  background_dump_dest     = /oracle/app/oracle/admin/orcl/bdump

  user_dump_dest           = /oracle/app/oracle/admin/orcl/udump

  core_dump_dest           = /oracle/app/oracle/admin/orcl/cdump

  audit_file_dest          = /oracle/app/oracle/admin/orcl/adump

  db_name                  = orcl

  open_cursors             = 300

  pga_aggregate_target     = 94371840

PMON started with pid=2, OS id=7467

PSP0 started with pid=3, OS id=7469

MMAN started with pid=4, OS id=7471

DBW0 started with pid=5, OS id=7473

LGWR started with pid=6, OS id=7475

CKPT started with pid=7, OS id=7477

SMON started with pid=8, OS id=7479

RECO started with pid=9, OS id=7481

CJQ0 started with pid=10, OS id=7483

MMON started with pid=11, OS id=7485

MMNL started with pid=12, OS id=7487

Fri Mar 23 12:53:12 KST 2018

starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...

starting up 1 shared server(s) ...

Fri Mar 23 12:53:12 KST 2018

ALTER DATABASE   MOUNT

Fri Mar 23 12:53:16 KST 2018

Setting recovery target incarnation to 2

Fri Mar 23 12:53:16 KST 2018

Successful mount of redo thread 1, with mount id 1499323576

Fri Mar 23 12:53:16 KST 2018

Database mounted in Exclusive Mode

Completed: ALTER DATABASE   MOUNT

Fri Mar 23 12:53:16 KST 2018

Stopping background process MMNL

Fri Mar 23 12:53:16 KST 2018

Stopping background process MMON

Starting background process MMON

MMON started with pid=11, OS id=7497

Fri Mar 23 12:53:16 KST 2018

Starting background process MMNL

MMNL started with pid=12, OS id=7499

Fri Mar 23 12:53:16 KST 2018

ALTER SYSTEM enable restricted session;

Fri Mar 23 12:53:16 KST 2018

DROP DATABASE

Deleted file /oracle/app/oracle/oradata/orcl/system01.dbf

Deleted file /oracle/app/oracle/oradata/orcl/undotbs01.dbf

Deleted file /oracle/app/oracle/oradata/orcl/sysaux01.dbf

Deleted file /oracle/app/oracle/oradata/orcl/users01.dbf

Deleted file /oracle/app/oracle/oradata/orcl/perfstat01.bdf

Deleted file /oracle/app/oracle/oradata/orcl/jshts01.dbf

Deleted file /oracle/app/oracle/oradata/orcl/redo01.log

Deleted file /oracle/app/oracle/oradata/orcl/redo02.log

Deleted file /oracle/app/oracle/oradata/orcl/redo03.log

Deleted file /oracle/app/oracle/oradata/orcl/temp01.dbf

Deleted file /oracle/app/oracle/oradata/orcl/temp99.dbf

Instance terminated by USER, pid = 7495

Deleted file /oracle/app/oracle/oradata/orcl/control01.ctl

Deleted file /oracle/app/oracle/oradata/orcl/control02.ctl

Deleted file /oracle/app/oracle/oradata/orcl/control03.ctl

Completed: DROP DATABASE

Fri Mar 23 12:53:25 KST 2018

Shutting down instance (abort)

License high water mark = 1

에러 발생 시 : 

[oracle@oracle dbs]$ dbca -silent -deleteDatabase -sourceDB orcl -sysDBAUserName sys -sysDBAPassword oracle

ORA-01078: failure in processing system parameters

명령어 실행 시 위 오류가 발생한다면 initorcl.ora(pfile)에 #으로 주석처리 되어있는 것들을 지워 준후

DB 재기동 후 다시 진행한다.

또는 -sourceDB 명이 틀리진 않은지 확인한다.(대문자,소문자 등)

참조 : http://www.dbaexpert.com/blog/dbca-delete-database-in-silent-mode-2/