Oracle Linux 6.8에 Oracle 11g R2 dbca silent mode 생성

OS환경 : Oracle Linux 6.8 (64bit)

DB 환경 : Oracle Database 10.2.0.4

방법 : Oracle Linux 6.8에 Oracle 11g R2 dbca silent mode 생성

DB 설치파일 있는 경로 이동

$ cd /oracle/database/response/

rsp 원본파일 백업

$ cp ./dbca.rsp ./dbca.rsp.bak

dbca rsp 파일 수정

$ vi /oracle/database/response/dbca.rsp
GDBNAME = "orcl"
SID = "orcl" 
CHARACTERSET = "KO16MSWIN949"
NATIONALCHARACTERSET= "UTF8"

다른 내용도 많지만 위 4가지만 수정해주면 샘플db 생성가능

dbca silent 모드로 실행

$ dbca -silent -templateName General_Purpose.dbc -responseFile /oracle/database/response/dbca.rsp

빠르게 db 생성 완료됨

dbca 시 alert.log

$ cd /oracle/app/oracle/admin/orcl/bdump
$ tail -f alert_orcl.log 
Fri Mar 23 12:58:09 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
  sga_target               = 285212672
  control_files            = /oracle/app/oracle/oradata/orcl/control01.ctl, /oracle/app/oracle/oradata/orcl/control02.ctl, /oracle/app/oracle/oradata/orcl/control03.ctl
  db_block_size            = 8192
  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=7588
PSP0 started with pid=3, OS id=7590
MMAN started with pid=4, OS id=7592
DBW0 started with pid=5, OS id=7594
LGWR started with pid=6, OS id=7596
CKPT started with pid=7, OS id=7598
SMON started with pid=8, OS id=7600
RECO started with pid=9, OS id=7602
CJQ0 started with pid=10, OS id=7604
MMON started with pid=11, OS id=7606
MMNL started with pid=12, OS id=7609
Fri Mar 23 12:58:09 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:58:09 KST 2018
SeedDB에 있는 내용 restore(General_Purpose 기능)
The input backup piece /oracle/app/oracle/product/10.2.0/db_1/assistants/dbca/templates/Seed_Database.dfb is in compressed format.
Full restore complete of datafile 4 to datafile copy /oracle/app/oracle/oradata/orcl/users01.dbf.  Elapsed time: 0:00:01 
  checkpoint is 388264
Full restore complete of datafile 2 to datafile copy /oracle/app/oracle/oradata/orcl/undotbs01.dbf.  Elapsed time: 0:00:01 
  checkpoint is 388264
Fri Mar 23 12:58:20 KST 2018
Full restore complete of datafile 3 to datafile copy /oracle/app/oracle/oradata/orcl/sysaux01.dbf.  Elapsed time: 0:00:11 
  checkpoint is 388264
  last deallocation scn is 388007
Full restore complete of datafile 1 to datafile copy /oracle/app/oracle/oradata/orcl/system01.dbf.  Elapsed time: 0:00:17 
  checkpoint is 388264
  last deallocation scn is 384611
Fri Mar 23 12:58:27 KST 2018
Controlfile 생성
Create controlfile reuse set database "orcl"
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
Datafile
'/oracle/app/oracle/oradata/orcl/system01.dbf',
'/oracle/app/oracle/oradata/orcl/undotbs01.dbf',
'/oracle/app/oracle/oradata/orcl/sysaux01.dbf',
'/oracle/app/oracle/oradata/orcl/users01.dbf'
LOGFILE GROUP 1 ('/oracle/app/oracle/oradata/orcl/redo01.log') SIZE 51200K,
GROUP 2 ('/oracle/app/oracle/oradata/orcl/redo02.log') SIZE 51200K,
GROUP 3 ('/oracle/app/oracle/oradata/orcl/redo03.log') SIZE 51200K RESETLOGS
WARNING: Default Temporary Tablespace not specified in CREATE DATABASE command
Default Temporary Tablespace will be necessary for a locally managed database in future release
kcv_lh_or_upgrade: 10.2 upgrading 1 incarnations
Setting recovery target incarnation to 1
Fri Mar 23 12:58:27 KST 2018
Successful mount of redo thread 1, with mount id 1499339763
Fri Mar 23 12:58:27 KST 2018
Completed: Create controlfile reuse set database "orcl"
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
Datafile
'/oracle/app/oracle/oradata/orcl/system01.dbf',
'/oracle/app/oracle/oradata/orcl/undotbs01.dbf',
'/oracle/app/oracle/oradata/orcl/sysaux01.dbf',
'/oracle/app/oracle/oradata/orcl/users01.dbf'
LOGFILE GROUP 1 ('/oracle/app/oracle/oradata/orcl/redo01.log') SIZE 51200K,
GROUP 2 ('/oracle/app/oracle/oradata/orcl/redo02.log') SIZE 51200K,
GROUP 3 ('/oracle/app/oracle/oradata/orcl/redo03.log') SIZE 51200K RESETLOGS
Fri Mar 23 12:58:27 KST 2018
DB 종료
Shutting down instance (immediate)
Fri Mar 23 12:58:27 KST 2018
Shutting down instance: further logons disabled
Fri Mar 23 12:58:27 KST 2018
Stopping background process CJQ0
Fri Mar 23 12:58:27 KST 2018
Stopping background process MMNL
Fri Mar 23 12:58:27 KST 2018
Stopping background process MMON
License high water mark = 1
Fri Mar 23 12:58:27 KST 2018
Job queue slave processes stopped
All dispatchers and shared servers shutdown
Fri Mar 23 12:58:27 KST 2018
ALTER DATABASE CLOSE NORMAL
ORA-1109 signalled during: ALTER DATABASE CLOSE NORMAL...
Fri Mar 23 12:58:27 KST 2018
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
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:58:28 KST 2018
DB 기동
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
  sga_target               = 285212672
  control_files            = /oracle/app/oracle/oradata/orcl/control01.ctl, /oracle/app/oracle/oradata/orcl/control02.ctl, /oracle/app/oracle/oradata/orcl/control03.ctl
  db_block_size            = 8192
  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
  _no_recovery_through_resetlogs= TRUE
  undo_management          = AUTO
  undo_tablespace          = UNDOTBS1
  remote_login_passwordfile= EXCLUSIVE
  db_domain                = 
  dispatchers              = (PROTOCOL=TCP) (SERVICE=orclXDB)
  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=7625
PSP0 started with pid=3, OS id=7627
MMAN started with pid=4, OS id=7629
DBW0 started with pid=5, OS id=7631
LGWR started with pid=6, OS id=7633
CKPT started with pid=7, OS id=7635
SMON started with pid=8, OS id=7637
RECO started with pid=9, OS id=7639
MMON started with pid=10, OS id=7641
MMNL started with pid=11, OS id=7643
Fri Mar 23 12:58:28 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:58:28 KST 2018
Controlfile 재생성
Create controlfile reuse set database "orcl"
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
Datafile
'/oracle/app/oracle/oradata/orcl/system01.dbf',
'/oracle/app/oracle/oradata/orcl/undotbs01.dbf',
'/oracle/app/oracle/oradata/orcl/sysaux01.dbf',
'/oracle/app/oracle/oradata/orcl/users01.dbf'
LOGFILE GROUP 1 ('/oracle/app/oracle/oradata/orcl/redo01.log') SIZE 51200K,
GROUP 2 ('/oracle/app/oracle/oradata/orcl/redo02.log') SIZE 51200K,
GROUP 3 ('/oracle/app/oracle/oradata/orcl/redo03.log') SIZE 51200K RESETLOGS
Fri Mar 23 12:58:28 KST 2018
WARNING: Default Temporary Tablespace not specified in CREATE DATABASE command
Default Temporary Tablespace will be necessary for a locally managed database in future release
kcv_lh_or_upgrade: 10.2 upgrading 1 incarnations
Setting recovery target incarnation to 1
Fri Mar 23 12:58:28 KST 2018
Successful mount of redo thread 1, with mount id 1499317748
Fri Mar 23 12:58:28 KST 2018
Completed: Create controlfile reuse set database "orcl"
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
Datafile
'/oracle/app/oracle/oradata/orcl/system01.dbf',
'/oracle/app/oracle/oradata/orcl/undotbs01.dbf',
'/oracle/app/oracle/oradata/orcl/sysaux01.dbf',
'/oracle/app/oracle/oradata/orcl/users01.dbf'
LOGFILE GROUP 1 ('/oracle/app/oracle/oradata/orcl/redo01.log') SIZE 51200K,
GROUP 2 ('/oracle/app/oracle/oradata/orcl/redo02.log') SIZE 51200K,
GROUP 3 ('/oracle/app/oracle/oradata/orcl/redo03.log') SIZE 51200K RESETLOGS
Fri Mar 23 12:58:28 KST 2018
Stopping background process MMNL
Fri Mar 23 12:58:29 KST 2018
Stopping background process MMON
Starting background process MMON
Starting background process MMNL
MMON started with pid=10, OS id=7652
Fri Mar 23 12:58:30 KST 2018
세션 restrict mode로 변경
ALTER SYSTEM enable restricted session;
Fri Mar 23 12:58:30 KST 2018
resetlogs 옵션으로 DB open
alter database "orcl" open resetlogs
MMNL started with pid=11, OS id=7654
Fri Mar 23 12:58:30 KST 2018
incomplete recovery 진행
RESETLOGS after incomplete recovery UNTIL CHANGE 388264
Fri Mar 23 12:58:30 KST 2018
Errors in file /oracle/app/oracle/admin/orcl/udump/orcl_ora_7650.trc:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: '/oracle/app/oracle/oradata/orcl/redo01.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Fri Mar 23 12:58:30 KST 2018
Errors in file /oracle/app/oracle/admin/orcl/udump/orcl_ora_7650.trc:
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: '/oracle/app/oracle/oradata/orcl/redo02.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Fri Mar 23 12:58:31 KST 2018
Errors in file /oracle/app/oracle/admin/orcl/udump/orcl_ora_7650.trc:
ORA-00313: open failed for members of log group 3 of thread 1
ORA-00312: online log 3 thread 1: '/oracle/app/oracle/oradata/orcl/redo03.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Fri Mar 23 12:58:31 KST 2018
Setting recovery target incarnation to 2
Fri Mar 23 12:58:31 KST 2018
Assigning activation ID 1499317748 (0x595dc5f4)
Thread 1 opened at log sequence 1
  Current log# 1 seq# 1 mem# 0: /oracle/app/oracle/oradata/orcl/redo01.log
Successful open of redo thread 1
Fri Mar 23 12:58:31 KST 2018
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Fri Mar 23 12:58:31 KST 2018
SMON: enabling cache recovery
Fri Mar 23 12:58:31 KST 2018
Successfully onlined Undo Tablespace 1.
Dictionary check beginning
Tablespace 'TEMP' #3 found in data dictionary,
but not in the controlfile. Adding to controlfile.
Dictionary check complete
Fri Mar 23 12:58:31 KST 2018
SMON: enabling tx recovery
Fri Mar 23 12:58:31 KST 2018
TEMP TABLESPACE 생성하라는 경고
*********************************************************************
WARNING: The following temporary tablespaces contain no files.
         This condition can occur when a backup controlfile has
         been restored.  It may be necessary to add files to these
         tablespaces.  That can be done using the SQL statement:
 
         ALTER TABLESPACE <tablespace_name> ADD TEMPFILE
 
         Alternatively, if these temporary tablespaces are no longer
         needed, then they can be dropped.
           Empty temporary tablespace: TEMP
*********************************************************************
Database Characterset is US7ASCII
Opening with internal Resource Manager plan 
**********************************************************
WARNING: Files may exists in db_recovery_file_dest
that are not known to the database. Use the RMAN command
CATALOG RECOVERY AREA to re-catalog any such files.
One of the following events caused this:
1. A backup controlfile was restored.
2. A standby controlfile was restored.
3. The controlfile was re-created.
4. db_recovery_file_dest had previously been enabled and
   then disabled.
**********************************************************
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=15, OS id=7656
Fri Mar 23 12:58:32 KST 2018
LOGSTDBY: Validating controlfile with logical metadata
Fri Mar 23 12:58:32 KST 2018
LOGSTDBY: Validation complete
Global Name changed to ORCL
Completed: alter database "orcl" open resetlogs
Fri Mar 23 12:58:32 KST 2018
DB global 네임 변경
alter database rename global_name to "orcl"
Completed: alter database rename global_name to "orcl"
Fri Mar 23 12:58:32 KST 2018
TEMP TABLESPACE 추가
ALTER TABLESPACE TEMP ADD TEMPFILE '/oracle/app/oracle/oradata/orcl/temp01.dbf' SIZE 20480K REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
Completed: ALTER TABLESPACE TEMP ADD TEMPFILE '/oracle/app/oracle/oradata/orcl/temp01.dbf' SIZE 20480K REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
Fri Mar 23 12:58:32 KST 2018
DEFAULT TABLESPACE 를 USERS로 지정
ALTER DATABASE DEFAULT TABLESPACE "USERS"
Completed: ALTER DATABASE DEFAULT TABLESPACE "USERS"
Fri Mar 23 12:58:32 KST 2018
캐릭터셋 설정
alter database character set INTERNAL_CONVERT KO16MSWIN949
Fri Mar 23 12:58:33 KST 2018
db_recovery_file_dest_size of 2048 MB is 0.00% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Fri Mar 23 12:58:36 KST 2018
변경된 캐릭터셋이 컨트롤파일에 적용된다는 메세지
Updating character set in controlfile to KO16MSWIN949
Synchronizing connection with database character set information
 SYS.METASTYLESHEET (STYLESHEET) - CLOB representation altered
 SYS.ATTRIBUTE_TRANSFORMATIONS$ (XSL_TRANSFORMATION) - CLOB representation altered
 SYS.RULE$ (CONDITION) - CLOB representation altered
 SYS.SCHEDULER$_EVENT_LOG (ADDITIONAL_INFO) - CLOB representation altered
 SYS.WRI$_DBU_FEATURE_METADATA (INST_CHK_LOGIC) - CLOB representation altered
 SYS.WRI$_DBU_FEATURE_METADATA (USG_DET_LOGIC) - CLOB representation altered
 SYS.WRI$_DBU_HWM_METADATA (LOGIC) - CLOB representation altered
 XDB.XDB$RESOURCE (SYS_NC00027$) - CLOB representation altered
Fri Mar 23 12:58:38 KST 2018
Thread 1 advanced to log sequence 2 (LGWR switch)
  Current log# 2 seq# 2 mem# 0: /oracle/app/oracle/oradata/orcl/redo02.log
Fri Mar 23 12:58:38 KST 2018
 MDSYS.SDO_COORD_OP_PARAM_VALS (PARAM_VALUE_FILE) - CLOB representation altered
 MDSYS.SDO_COORD_OP_PARAM_VALS (SYS_NC00008$) - CLOB representation altered
 MDSYS.SDO_STYLES_TABLE (DEFINITION) - CLOB representation altered
 MDSYS.SDO_XML_SCHEMAS (XMLSCHEMA) - CLOB representation altered
 MDSYS.SDO_GEOR_XMLSCHEMA_TABLE (XMLSCHEMA) - CLOB representation altered
Refreshing type attributes with new character set information
Completed: alter database character set INTERNAL_CONVERT KO16MSWIN949
Fri Mar 23 12:58:40 KST 2018
세션 restrict mode를 disable로 변경
ALTER SYSTEM disable restricted session;
Fri Mar 23 12:58:42 KST 2018
DB 종료
Shutting down instance (immediate)
Fri Mar 23 12:58:42 KST 2018
Shutting down instance: further logons disabled
Fri Mar 23 12:58:43 KST 2018
Stopping background process QMNC
Fri Mar 23 12:58:45 KST 2018
Stopping background process MMNL
Fri Mar 23 12:58:46 KST 2018
Stopping background process MMON
License high water mark = 1
Waiting for dispatcher 'D000' to shutdown
All dispatchers and shared servers shutdown
Fri Mar 23 12:58:49 KST 2018
ALTER DATABASE CLOSE NORMAL
Fri Mar 23 12:58:49 KST 2018
SMON: disabling tx recovery
SMON: disabling cache recovery
Fri Mar 23 12:58:49 KST 2018
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Thread 1 closed at log sequence 2
Successful close of redo thread 1
Fri Mar 23 12:58:49 KST 2018
Completed: ALTER DATABASE CLOSE NORMAL
Fri Mar 23 12:58:49 KST 2018
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
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:58:49 KST 2018
DB기동
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
  sga_target               = 285212672
  control_files            = /oracle/app/oracle/oradata/orcl/control01.ctl, /oracle/app/oracle/oradata/orcl/control02.ctl, /oracle/app/oracle/oradata/orcl/control03.ctl
  db_block_size            = 8192
  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=7688
PSP0 started with pid=3, OS id=7690
MMAN started with pid=4, OS id=7692
DBW0 started with pid=5, OS id=7694
LGWR started with pid=6, OS id=7696
CKPT started with pid=7, OS id=7698
SMON started with pid=8, OS id=7700
RECO started with pid=9, OS id=7702
CJQ0 started with pid=10, OS id=7704
MMON started with pid=11, OS id=7706
MMNL started with pid=12, OS id=7708
Fri Mar 23 12:58:50 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:58:50 KST 2018
ALTER DATABASE   MOUNT
Fri Mar 23 12:58:54 KST 2018
Setting recovery target incarnation to 2
Fri Mar 23 12:58:54 KST 2018
Successful mount of redo thread 1, with mount id 1499341066
Fri Mar 23 12:58:54 KST 2018
Database mounted in Exclusive Mode
Completed: ALTER DATABASE   MOUNT
Fri Mar 23 12:58:54 KST 2018
ALTER DATABASE OPEN
Fri Mar 23 12:58:54 KST 2018
Thread 1 opened at log sequence 2
  Current log# 2 seq# 2 mem# 0: /oracle/app/oracle/oradata/orcl/redo02.log
Successful open of redo thread 1
Fri Mar 23 12:58:54 KST 2018
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Fri Mar 23 12:58:54 KST 2018
SMON: enabling cache recovery
Fri Mar 23 12:58:54 KST 2018
Successfully onlined Undo Tablespace 1.
Fri Mar 23 12:58:54 KST 2018
SMON: enabling tx recovery
Fri Mar 23 12:58:54 KST 2018
Database Characterset is KO16MSWIN949
Opening with internal Resource Manager plan 
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=16, OS id=7718
Fri Mar 23 12:58:54 KST 2018
db_recovery_file_dest_size of 2048 MB is 0.00% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Fri Mar 23 12:58:54 KST 2018
Completed: ALTER DATABASE OPEN
.