Oracle 12c数据库配置管理器在创建新数据库方面非常缓慢

Question

我以前已经在许多机器上安装了Oracle 12c (主要是Windows 10,2012,2016 )，并使用Database在它们上创建了几个数据库，所有这些都没有真正的问题。然而，在这台机器上，我面临一个奇怪的问题，配置管理器通过以下步骤达到59% .

Copying database files: Finished
Creating and starting Oracle Instance: Finished
Completing Database Creation: In Progress 

就这样，它似乎就挂在那里。我检查了'alert_X.log‘，我看到它每10分钟就会添加一行

2019-10-17T10:32:22.090666-06:00
Resize operation completed for file# 3, old size 471040K, new size 481280K

随着尺寸的增加。我检查了其他机器的日志，我可以看到同样的事情发生了，但是在它们的机器上，它每隔1到2分钟增加一条新的行。我无法在日志文件中看到任何错误，因此无法理解为什么在这台机器上安装Oracle的方式与其他机器相同(我们已经记录了如何实现它的步骤)，为什么它会如此缓慢。

有什么设置或配置我可以查看调整吗？

警报日志：

Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on. 
IMODE=BR
ILAT =108
LICENSE_MAX_USERS = 0
SYS auditing is enabled
NOTE: remote asm mode is local (mode 0x1; from cluster type)
2019-10-17T10:07:54.316926-06:00
NOTE: Using default ASM root directory ASM
NOTE: Cluster configuration type = NONE [2]
Oracle Database 12c Standard Edition Release 12.2.0.1.0 - 64bit Production.
Windows NT Version V6.2  
ORACLE_HOME =  C:\app\oracle\virtual\product\12.2.0\dbhome_1
Node name           : 56ZY0X2
CPU                 : 8 - type 8664, 4 Physical Cores
Process Affinity    : 0x0x0000000000000000
Memory (Avail/Total): Ph:2862M/8051M, Ph
Using parameter settings in client-side pfile C:\APP\ORACLE\VIRTUAL\CFGTOOLLOGS\DBCA\ORC1\INITORC1TEMPOMF.ORA on machine 56ZY0X2
System parameters with non-default values:
  processes                = 640
  sga_target               = 2416M
  control_files            = "C:\APP\ORACLE\VIRTUAL\CFGTOOLLOGS\DBCA\ORC1\TEMPCONTROL.CTL"
  db_block_size            = 8192
  compatible               = "12.2.0"
  db_create_file_dest      = "C:\app\oracle\virtual\oradata"
  db_recovery_file_dest    = "C:\app\oracle\virtual\fast_recovery_area\ORC1"
  db_recovery_file_dest_size= 9546M
  undo_tablespace          = "UNDOTBS1"
  remote_login_passwordfile= "EXCLUSIVE"
  dispatchers              = "(PROTOCOL=TCP) (SERVICE=ORC1XDB)"
  local_listener           = "LISTENER_ORC1"
  audit_file_dest          = "C:\APP\ORACLE\VIRTUAL\ADMIN\ORC1\ADUMP"
  audit_trail              = "DB"
  db_name                  = "seeddata"
  db_unique_name           = "ORC1"
  open_cursors             = 300
  pga_aggregate_target     = 805M
  _diag_hm_rc_enabled      = FALSE
  diagnostic_dest          = "C:\APP\ORACLE\VIRTUAL"
  enable_pluggable_database= TRUE
NOTE: remote asm mode is local (mode 0x1; from cluster type)
2019-10-17T10:07:54.516372-06:00
============================================================
NOTE: PatchLevel of this instance 0
============================================================

TMON started with pid=32, OS id=8840 
ORACLE_BASE from environment = C:\app\oracle\virtual
2019-10-17T10:08:25.044601-06:00
ALTER DATABASE   MOUNT
2019-10-17T10:08:29.081585-06:00
Set as converted control file due to db_unique_name mismatch
Changing di2dbun from seeddata to ORC1
Network throttle feature is disabled as mount time
Database mounted in Exclusive Mode
Lost write protection disabled
Using STANDBY_ARCHIVE_DEST parameter default value as USE_DB_RECOVERY_FILE_DEST
Create Relation IPS_PACKAGE_UNPACK_HISTORY
Completed: ALTER DATABASE   MOUNT
2019-10-17T10:09:02.188580-06:00
Full restore complete of datafile 1 to datafile copy C:\APP\ORACLE\VIRTUAL\ORADATA\ORC1\DATAFILE\O1_MF_SYSTEM_GTK4J39T_.DBF.  Elapsed time: 0:00:27
  checkpoint is 1490581
  last deallocation scn is 1284482
  Undo Optimization current scn is 1140285
2019-10-17T10:09:24.616596-06:00
Full restore complete of datafile 3 to datafile copy C:\APP\ORACLE\VIRTUAL\ORADATA\ORC1\DATAFILE\O1_MF_SYSAUX_GTK4K6L5_.DBF.  Elapsed time: 0:00:14
  checkpoint is 1490581
  last deallocation scn is 1083526
2019-10-17T10:09:41.479398-06:00
Full restore complete of datafile 5 to datafile copy C:\APP\ORACLE\VIRTUAL\ORADATA\ORC1\DATAFILE\O1_MF_UNDOTBS1_GTK4KORT_.DBF.  Elapsed time: 0:00:16
  checkpoint is 1490581
  last deallocation scn is 1226060
  Undo Optimization current scn is 1140285
2019-10-17T10:09:51.155091-06:00
Full restore complete of datafile 7 to datafile copy C:\APP\ORACLE\VIRTUAL\ORADATA\ORC1\DATAFILE\O1_MF_USERS_GTK4LH0Q_.DBF.  Elapsed time: 0:00:00
  checkpoint is 1490581
  last deallocation scn is 3
2019-10-17T10:09:52.173407-06:00
Shutting down instance (abort) (OS id: 15628)
License high water mark = 4
Starting ORACLE instance (normal) (OS id: 1512)
2019-10-17T10:10:26.131393-06:00
CLI notifier numLatches:13 maxDescs:1082
2019-10-17T10:10:26.139371-06:00
All SGA segments were allocated at startup
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Initial number of CPU is 8
Number of processor cores in the system is 4
Number of processor sockets in the system is 1
Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on. 
IMODE=BR
ILAT =108
LICENSE_MAX_USERS = 0
SYS auditing is enabled
NOTE: remote asm mode is local (mode 0x1; from cluster type)
2019-10-17T10:10:30.837467-06:00
NOTE: Using default ASM root directory ASM
NOTE: Cluster configuration type = NONE [2]
Oracle Database 12c Standard Edition Release 12.2.0.1.0 - 64bit Production.
Windows NT Version V6.2  
ORACLE_HOME =  C:\app\oracle\virtual\product\12.2.0\dbhome_1
Node name           : 56ZY0X2
CPU                 : 8 - type 8664, 4 Physical Cores
Process Affinity    : 0x0x0000000000000000
Memory (Avail/Total): Ph:3369M/8051M, Ph
Using parameter settings in client-side pfile C:\APP\ORACLE\VIRTUAL\ADMIN\ORC1\PFILE\INIT.ORA on machine 56ZY0X2
System parameters with non-default values:
  processes                = 640
  sga_target               = 2416M
  db_block_size            = 8192
  compatible               = "12.2.0"
  db_create_file_dest      = "C:\app\oracle\virtual\oradata"
  db_recovery_file_dest    = "C:\app\oracle\virtual\fast_recovery_area\ORC1"
  db_recovery_file_dest_size= 9546M
  undo_tablespace          = "UNDOTBS1"
  remote_login_passwordfile= "EXCLUSIVE"
  dispatchers              = "(PROTOCOL=TCP) (SERVICE=ORC1XDB)"
  local_listener           = "LISTENER_ORC1"
  audit_file_dest          = "C:\APP\ORACLE\VIRTUAL\ADMIN\ORC1\ADUMP"
  audit_trail              = "DB"
  db_name                  = "ORC1"
  open_cursors             = 300
  pga_aggregate_target     = 805M
  diagnostic_dest          = "C:\APP\ORACLE\VIRTUAL"
NOTE: remote asm mode is local (mode 0x1; from cluster type)
2019-10-17T10:10:30.895301-06:00
============================================================
NOTE: PatchLevel of this instance 0
============================================================

starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
Starting background process TMON
2019-10-17T10:10:56.413890-06:00
ORACLE_BASE from environment = C:\app\oracle\virtual
2019-10-17T10:11:00.528389-06:00
Create controlfile reuse set database "ORC1"
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
Datafile
'C:\APP\ORACLE\VIRTUAL\ORADATA\ORC1\DATAFILE\O1_MF_SYSAUX_GTK4K6L5_.DBF',
'C:\APP\ORACLE\VIRTUAL\ORADATA\ORC1\DATAFILE\O1_MF_SYSTEM_GTK4J39T_.DBF',
'C:\APP\ORACLE\VIRTUAL\ORADATA\ORC1\DATAFILE\O1_MF_UNDOTBS1_GTK4KORT_.DBF',
'C:\APP\ORACLE\VIRTUAL\ORADATA\ORC1\DATAFILE\O1_MF_USERS_GTK4LH0Q_.DBF'
LOGFILE GROUP 1  SIZE 200M,
GROUP 2  SIZE 200M,
GROUP 3  SIZE 200M RESETLOGS
2019-10-17T10:11:00.531380-06:00
WARNING: Default Temporary Tablespace not specified in CREATE DATABASE command
Default Temporary Tablespace will be necessary for a locally managed database in future release
Expanded controlfile section 32 from 31 to 128 records
Requested to grow by 97 records; added 3 blocks of records
Network throttle feature is disabled as mount time

2019-10-17T10:11:00.775676-06:00
Successful mount of redo thread 1, with mount id 841524084
Completed: Create controlfile reuse set database "ORC1"
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
Datafile
'C:\APP\ORACLE\VIRTUAL\ORADATA\ORC1\DATAFILE\O1_MF_SYSAUX_GTK4K6L5_.DBF',
'C:\APP\ORACLE\VIRTUAL\ORADATA\ORC1\DATAFILE\O1_MF_SYSTEM_GTK4J39T_.DBF',
'C:\APP\ORACLE\VIRTUAL\ORADATA\ORC1\DATAFILE\O1_MF_UNDOTBS1_GTK4KORT_.DBF',
'C:\APP\ORACLE\VIRTUAL\ORADATA\ORC1\DATAFILE\O1_MF_USERS_GTK4LH0Q_.DBF'
LOGFILE GROUP 1  SIZE 200M,
GROUP 2  SIZE 200M,
GROUP 3  SIZE 200M RESETLOGS
2019-10-17T10:11:00.800604-06:00
zeroing database id of data file (0): C:\APP\ORACLE\VIRTUAL\ORADATA\ORC1\DATAFILE\O1_MF_SYSTEM_GTK4J39T_.DBF
zeroing database id of data file (0): C:\APP\ORACLE\VIRTUAL\ORADATA\ORC1\DATAFILE\O1_MF_SYSAUX_GTK4K6L5_.DBF
zeroing database id of data file (0): C:\APP\ORACLE\VIRTUAL\ORADATA\ORC1\DATAFILE\O1_MF_UNDOTBS1_GTK4KORT_.DBF
zeroing database id of data file (0): C:\APP\ORACLE\VIRTUAL\ORADATA\ORC1\DATAFILE\O1_MF_USERS_GTK4LH0Q_.DBF
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Initial number of CPU is 8
Number of processor cores in the system is 4
Number of processor sockets in the system is 1
Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on. 
IMODE=BR
ILAT =108
LICENSE_MAX_USERS = 0
SYS auditing is enabled
NOTE: remote asm mode is local (mode 0x1; from cluster type)
2019-10-17T10:11:43.807504-06:00
NOTE: Using default ASM root directory ASM
NOTE: Cluster configuration type = NONE [2]
Oracle Database 12c Standard Edition Release 12.2.0.1.0 - 64bit Production.
Windows NT Version V6.2  
ORACLE_HOME =  C:\app\oracle\virtual\product\12.2.0\dbhome_1
Node name           : 56ZY0X2
CPU                 : 8 - type 8664, 4 Physical Cores
Process Affinity    : 0x0x0000000000000000
Memory (Avail/Total): Ph:3435M/8051M, Ph
Using parameter settings in client-side pfile C:\APP\ORACLE\VIRTUAL\CFGTOOLLOGS\DBCA\ORC1\INITORC1TEMP.ORA on machine 56ZY0X2
System parameters with non-default values:
  processes                = 640
  sga_target               = 2416M
  db_block_size            = 8192
  compatible               = "12.2.0"
  db_create_file_dest      = "C:\app\oracle\virtual\oradata"
  db_recovery_file_dest    = "C:\app\oracle\virtual\fast_recovery_area\ORC1"
  db_recovery_file_dest_size= 9546M
  _no_recovery_through_resetlogs= TRUE
  undo_tablespace          = "UNDOTBS1"
  remote_login_passwordfile= "EXCLUSIVE"
  dispatchers              = "(PROTOCOL=TCP) (SERVICE=ORC1XDB)"
  local_listener           = "LISTENER_ORC1"
  job_queue_processes      = 0
  audit_file_dest          = "C:\APP\ORACLE\VIRTUAL\ADMIN\ORC1\ADUMP"
  audit_trail              = "DB"
  db_name                  = "ORC1"
  open_cursors             = 300
  pga_aggregate_target     = 805M
  _enable_automatic_maintenance= 0
  _diag_hm_rc_enabled      = FALSE
  diagnostic_dest          = "C:\APP\ORACLE\VIRTUAL"
NOTE: remote asm mode is local (mode 0x1; from cluster type)
2019-10-17T10:11:43.891211-06:00
============================================================
NOTE: PatchLevel of this instance 0
============================================================
 VKTM started with pid=5, OS id=14732 at elevated (Time Critical) priority
2019-10-17T10:11:48.613136-06:00
VKTM running at (5)millisec precision with DBRM quantum (100)ms
2019-10-17T10:11:49.613230-06:00

MMNL started with pid=29, OS id=14240 
2019-10-17T10:12:08.035144-06:00
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
2019-10-17T10:12:09.064561-06:00
ORACLE_BASE from environment = C:\app\oracle\virtual
2019-10-17T10:12:13.197430-06:00
Create controlfile reuse set database "ORC1"
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
Datafile
'C:\APP\ORACLE\VIRTUAL\ORADATA\ORC1\DATAFILE\O1_MF_SYSAUX_GTK4K6L5_.DBF',
'C:\APP\ORACLE\VIRTUAL\ORADATA\ORC1\DATAFILE\O1_MF_SYSTEM_GTK4J39T_.DBF',
'C:\APP\ORACLE\VIRTUAL\ORADATA\ORC1\DATAFILE\O1_MF_UNDOTBS1_GTK4KORT_.DBF',
'C:\APP\ORACLE\VIRTUAL\ORADATA\ORC1\DATAFILE\O1_MF_USERS_GTK4LH0Q_.DBF'
LOGFILE GROUP 1  SIZE 200M,
GROUP 2  SIZE 200M,
GROUP 3  SIZE 200M RESETLOGS
2019-10-17T10:12:13.199424-06:00
WARNING: Default Temporary Tablespace not specified in CREATE DATABASE command
Default Temporary Tablespace will be necessary for a locally managed database in future release
Expanded controlfile section 32 from 31 to 128 records
Requested to grow by 97 records; added 3 blocks of records
Network throttle feature is disabled as mount time

2019-10-17T10:12:13.424982-06:00
Successful mount of redo thread 1, with mount id 841517245
Completed: Create controlfile reuse set database "ORC1"
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
Datafile
'C:\APP\ORACLE\VIRTUAL\ORADATA\ORC1\DATAFILE\O1_MF_SYSAUX_GTK4K6L5_.DBF',
'C:\APP\ORACLE\VIRTUAL\ORADATA\ORC1\DATAFILE\O1_MF_SYSTEM_GTK4J39T_.DBF',
'C:\APP\ORACLE\VIRTUAL\ORADATA\ORC1\DATAFILE\O1_MF_UNDOTBS1_GTK4KORT_.DBF',
'C:\APP\ORACLE\VIRTUAL\ORADATA\ORC1\DATAFILE\O1_MF_USERS_GTK4LH0Q_.DBF'
LOGFILE GROUP 1  SIZE 200M,
GROUP 2  SIZE 200M,
GROUP 3  SIZE 200M RESETLOGS
Stopping background process MMNL
Starting background process MMNL
2019-10-17T10:12:16.508716-06:00
alter database "ORC1" open resetlogs
RESETLOGS after incomplete recovery UNTIL CHANGE 1490581 time 03/08/2017 19:42:10
2019-10-17T10:12:17.595584-06:00
Errors in file C:\APP\ORACLE\VIRTUAL\diag\rdbms\ORC1\ORC1\trace\ORC1_ora_4820.trc:
ORA-00313: open failed for members of log group 1 of thread 1
2019-10-17T10:12:17.596581-06:00
Errors in file C:\APP\ORACLE\VIRTUAL\diag\rdbms\ORC1\ORC1\trace\ORC1_ora_4820.trc:
ORA-00313: open failed for members of log group 1 of thread 1
Clearing online redo logfile 1 C:\APP\ORACLE\VIRTUAL\ORADATA\ORC1\ONLINELOG\O1_MF_1_%U_.LOG

2019-10-17T10:12:17.612541-06:00
Errors in file C:\APP\ORACLE\VIRTUAL\diag\rdbms\ORC1\ORC1\trace\ORC1_ora_4820.trc:
ORA-00313: open failed for members of log group 2 of thread 1
2019-10-17T10:12:17.613531-06:00
Errors in file C:\APP\ORACLE\VIRTUAL\diag\rdbms\ORC1\ORC1\trace\ORC1_ora_4820.trc:
ORA-00313: open failed for members of log group 2 of thread 1
Clearing online redo logfile 2 C:\APP\ORACLE\VIRTUAL\ORADATA\ORC1\ONLINELOG\O1_MF_2_%U_.LOG

2019-10-17T10:12:17.631479-06:00
Errors in file C:\APP\ORACLE\VIRTUAL\diag\rdbms\ORC1\ORC1\trace\ORC1_ora_4820.trc:
ORA-00313: open failed for members of log group 3 of thread 1
2019-10-17T10:12:17.632476-06:00
Errors in file C:\APP\ORACLE\VIRTUAL\diag\rdbms\ORC1\ORC1\trace\ORC1_ora_4820.trc:
ORA-00313: open failed for members of log group 3 of thread 1
Clearing online redo logfile 3 C:\APP\ORACLE\VIRTUAL\ORADATA\ORC1\ONLINELOG\O1_MF_3_%U_.LOG

Clearing online log 1 of thread 1 sequence number 0
2019-10-17T10:12:17.643444-06:00
Errors in file C:\APP\ORACLE\VIRTUAL\diag\rdbms\ORC1\ORC1\trace\ORC1_ora_4820.trc:
ORA-00313: open failed for members of log group 1 of thread 1
2019-10-17T10:12:17.645439-06:00
Errors in file C:\APP\ORACLE\VIRTUAL\diag\rdbms\ORC1\ORC1\trace\ORC1_ora_4820.trc:
ORA-00313: open failed for members of log group 1 of thread 1
Clearing online log 2 of thread 1 sequence number 0
2019-10-17T10:12:17.648430-06:00
Errors in file C:\APP\ORACLE\VIRTUAL\diag\rdbms\ORC1\ORC1\trace\ORC1_ora_4820.trc:
ORA-00313: open failed for members of log group 2 of thread 1
2019-10-17T10:12:17.650425-06:00
Errors in file C:\APP\ORACLE\VIRTUAL\diag\rdbms\ORC1\ORC1\trace\ORC1_ora_4820.trc:
ORA-00313: open failed for members of log group 2 of thread 1
Clearing online log 3 of thread 1 sequence number 0
2019-10-17T10:12:17.652419-06:00
Errors in file C:\APP\ORACLE\VIRTUAL\diag\rdbms\ORC1\ORC1\trace\ORC1_ora_4820.trc:
ORA-00313: open failed for members of log group 3 of thread 1
2019-10-17T10:12:17.654414-06:00
Errors in file C:\APP\ORACLE\VIRTUAL\diag\rdbms\ORC1\ORC1\trace\ORC1_ora_4820.trc:
ORA-00313: open failed for members of log group 3 of thread 1
2019-10-17T10:12:23.323872-06:00
Clearing online redo logfile 1 complete
Clearing online redo logfile 2 complete
Clearing online redo logfile 3 complete
Online log C:\APP\ORACLE\VIRTUAL\ORADATA\ORC1\ONLINELOG\O1_MF_1_GTK4Q1O5_.LOG: Thread 1 Group 1 was previously cleared
Online log C:\APP\ORACLE\VIRTUAL\FAST_RECOVERY_AREA\ORC1\ORC1\ONLINELOG\O1_MF_1_GTK4Q3HB_.LOG: Thread 1 Group 1 was previously cleared
Online log C:\APP\ORACLE\VIRTUAL\ORADATA\ORC1\ONLINELOG\O1_MF_2_GTK4Q1O5_.LOG: Thread 1 Group 2 was previously cleared
Online log C:\APP\ORACLE\VIRTUAL\FAST_RECOVERY_AREA\ORC1\ORC1\ONLINELOG\O1_MF_2_GTK4Q3HF_.LOG: Thread 1 Group 2 was previously cleared
Online log C:\APP\ORACLE\VIRTUAL\ORADATA\ORC1\ONLINELOG\O1_MF_3_GTK4Q1O9_.LOG: Thread 1 Group 3 was previously cleared
Online log C:\APP\ORACLE\VIRTUAL\FAST_RECOVERY_AREA\ORC1\ORC1\ONLINELOG\O1_MF_3_GTK4Q3HC_.LOG: Thread 1 Group 3 was previously cleared
2019-10-17T10:12:23.497021-06:00
Setting recovery target incarnation to 2
2019-10-17T10:12:23.551863-06:00
Ping without log force is disabled:
  instance mounted in exclusive mode.
Initializing SCN for created control file
Database SCN compatibility initialized to 3
Endian type of dictionary set to little
2019-10-17T10:12:23.594898-06:00
Assigning activation ID 841517245 (0x322888bd)
2019-10-17T10:12:23.600880-06:00
TT00: Gap Manager starting (PID:8016)
2019-10-17T10:12:23.660911-06:00
Thread 1 opened at log sequence 1
  Current log# 1 seq# 1 mem# 0: C:\APP\ORACLE\VIRTUAL\ORADATA\ORC1\ONLINELOG\O1_MF_1_GTK4Q1O5_.LOG
  Current log# 1 seq# 1 mem# 1: C:\APP\ORACLE\VIRTUAL\FAST_RECOVERY_AREA\ORC1\ORC1\ONLINELOG\O1_MF_1_GTK4Q3HB_.LOG
Successful open of redo thread 1
2019-10-17T10:12:23.688837-06:00
Sleep 5 seconds and then try to clear SRLs in 2 time(s)
2019-10-17T10:12:24.031848-06:00
[4820] Successfully onlined Undo Tablespace 2.
Undo initialization finished serial:0 start:8064218 end:8064328 diff:110 ms (0.1 seconds)
Dictionary check beginning
Tablespace 'TEMP' #3 found in data dictionary,
but not in the controlfile. Adding to controlfile.
Dictionary check complete
Verifying minimum file header compatibility for tablespace encryption..
Verifying file header compatibility for tablespace encryption completed for pdb 0
*********************************************************************
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  ADD TEMPFILE

         Alternatively, if these temporary tablespaces are no longer
         needed, then they can be dropped.
           Empty temporary tablespace: TEMP
*********************************************************************
Database Characterset is US7ASCII
2019-10-17T10:12:24.780890-06:00
Opening with Resource Manager plan: DEFAULT_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.
If files cannot be cataloged, then manually delete them
using OS command.
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.
**********************************************************
2019-10-17T10:12:25.088006-06:00
replication_dependency_tracking turned off (no async multimaster replication found)
AQ Processes can not start in restrict mode
LOGSTDBY: Validating controlfile with logical metadata
LOGSTDBY: Validation complete
Global Name changed to ORC1
2019-10-17T10:12:25.476191-06:00
db_recovery_file_dest_size of 9546 MB is 6.40% 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.
Starting background process CJQ0
2019-10-17T10:12:25.760590-06:00
CJQ0 started with pid=37, OS id=15684 
2019-10-17T10:12:26.261147-06:00
Completed: alter database "ORC1" open resetlogs
alter database rename global_name to "ORC1"
Completed: alter database rename global_name to "ORC1"
ALTER TABLESPACE TEMP ADD TEMPFILE SIZE 20480K AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
Completed: ALTER TABLESPACE TEMP ADD TEMPFILE SIZE 20480K AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
ALTER DATABASE DEFAULT TABLESPACE "USERS"
Completed: ALTER DATABASE DEFAULT TABLESPACE "USERS"
TABLE AUDSYS.AUD$UNIFIED: ADDED INTERVAL PARTITION SYS_P221 (64) VALUES LESS THAN (TIMESTAMP' 2019-11-01 00:00:00')
2019-10-17T10:12:26.857553-06:00
alter database character set INTERNAL_CONVERT AL32UTF8
2019-10-17T10:12:28.987681-06:00
Updating character set in controlfile to AL32UTF8
Synchronizing connection with database character set information
 SYS.EXTERNAL_TAB$ (PARAM_CLOB) - CLOB representation altered
 SYS.RULE$ (CONDITION) - CLOB representation altered
 SYS.ATTRIBUTE_TRANSFORMATIONS$ (XSL_TRANSFORMATION) - CLOB representation altered
 SYS.WRI$_ADV_DIRECTIVE_META (DATA) - CLOB representation altered
 SYS.WRI$_ADV_OBJECTS (ATTR4) - CLOB representation altered
 SYS.WRI$_ADV_OBJECTS (OTHER) - CLOB representation altered
 SYS.WRI$_ADV_RATIONALE (ATTR5) - CLOB representation altered
 SYS.SMB$CONFIG (PARAMETER_DATA) - CLOB representation altered
 SYS.WRI$_DBU_FEATURE_METADATA (INST_CHK_LOGIC) - CLOB representation altered
Shared IO Pool defaulting to 128MB. Trying to get it from Buffer Cache for process 12976.
 SYS.WRI$_DBU_FEATURE_METADATA (USG_DET_LOGIC) - CLOB representation altered
 SYS.WRI$_DBU_FEATURE_USAGE (FEATURE_INFO) - CLOB representation altered
 SYS.WRI$_DBU_HWM_METADATA (LOGIC) - CLOB representation altered
 SYS.WRI$_EMX_FILES (DATA) - CLOB representation altered
 SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY (EXPRESSION) - CLOB representation altered
 SYS.SCHEDULER$_EVENT_LOG (ADDITIONAL_INFO) - CLOB representation altered
2019-10-17T10:12:29.997825-06:00
 SYS.ORA_FCP_PARAMS$ (VALUE) - CLOB representation altered
 SYS.PDB_SYNC$ (LONGSQLTXT) - CLOB representation altered
 XDB.XDB$RESOURCE (SYS_NC00027$) - CLOB representation altered
 XDB.XDB$XDB_READY (DATA) - CLOB representation altered
 SYS.RADM_FPTM_LOB$ (CLOBCOL) - CLOB representation altered
 SYS.METASTYLESHEET (STYLESHEET) - CLOB representation altered
 AUDSYS.AUD$UNIFIED (SQL_TEXT) - CLOB representation altered
 AUDSYS.AUD$UNIFIED (SQL_BINDS) - CLOB representation altered
 AUDSYS.AUD$UNIFIED (RLS_INFO) - CLOB representation altered
 MDSYS.SDO_STYLES_TABLE (DEFINITION) - CLOB representation altered
Resize operation completed for file# 201, old size 20480K, new size 21504K
Resize operation completed for file# 201, old size 21504K, new size 22528K
Resize operation completed for file# 201, old size 22528K, new size 23552K
Resize operation completed for file# 201, old size 23552K, new size 24576K
2019-10-17T10:12:31.008348-06:00
Resize operation completed for file# 201, old size 24576K, new size 25600K
Resize operation completed for file# 201, old size 25600K, new size 26624K
Resize operation completed for file# 201, old size 26624K, new size 27648K
Resize operation completed for file# 201, old size 27648K, new size 28672K
Resize operation completed for file# 201, old size 28672K, new size 29696K
Resize operation completed for file# 201, old size 29696K, new size 30720K
Resize operation completed for file# 201, old size 30720K, new size 31744K
Resize operation completed for file# 201, old size 31744K, new size 32768K
 MDSYS.SDO_COORD_OP_PARAM_VALS (PARAM_VALUE_FILE) - CLOB representation altered
 MDSYS.SDO_GEOR_XMLSCHEMA_TABLE (XMLSCHEMA) - CLOB representation altered
 MDSYS.SDO_XML_SCHEMAS (XMLSCHEMA) - CLOB representation altered
 MDSYS.SDO_XSD_TABLE (XSD_DOC) - CLOB representation altered
2019-10-17T10:12:32.156865-06:00
Refreshing type attributes with new character set information
2019-10-17T10:12:33.387314-06:00
Completed: alter database character set INTERNAL_CONVERT AL32UTF8
2019-10-17T10:12:35.988833-06:00
ALTER SYSTEM disable restricted session;
Starting background process AQPC
2019-10-17T10:12:36.040684-06:00
AQPC started with pid=38, OS id=13644 
WARNING: AQ 12C time manager not started, no enabled queue 
2019-10-17T10:12:37.251194-06:00
QPI : Found directory objects and ORACLE_HOME out of sync
QPI : Trying to patch with the current ORACLE_HOME
QPI: ------QPI Old Directories -------
QPI: OPATCH_SCRIPT_DIR:c:\ade\aime_v\oracle\QOpatch
QPI: OPATCH_LOG_DIR:c:\ade\aime_v\oracle\QOpatch
QPI: OPATCH_INST_DIR:c:\ade\aime_v\oracle\OPatch
QPI: op_scpt_path C:\app\oracle\virtual\product\12.2.0\dbhome_1\QOpatch
QPI: Found QPI install at :C:\app\oracle\virtual\product\12.2.0\dbhome_1\QOpatch
QPI: Self adjusting the directories
QPI: ------QPI New Directories-------
QPI: OPATCH_SCRIPT_DIR:C:\app\oracle\virtual\product\12.2.0\dbhome_1\QOpatch
QPI: OPATCH_LOG_DIR:C:\app\oracle\virtual\product\12.2.0\dbhome_1\rdbms\log
QPI: OPATCH_INST_DIR:C:\app\oracle\virtual\product\12.2.0\dbhome_1\OPatch
2019-10-17T10:12:44.168250-06:00
Resize operation completed for file# 3, old size 409600K, new size 419840K
2019-10-17T10:12:45.316938-06:00
Resize operation completed for file# 3, old size 419840K, new size 430080K
Resize operation completed for file# 3, old size 430080K, new size 440320K
2019-10-17T10:12:46.816614-06:00
===========================================================
Dumping current patch information
===========================================================
No patches have been applied
===========================================================
2019-10-17T10:12:47.050941-06:00
Resize operation completed for file# 3, old size 440320K, new size 450560K
2019-10-17T10:22:21.203177-06:00
Resize operation completed for file# 3, old size 450560K, new size 471040K
2019-10-17T10:32:22.090666-06:00
Resize operation completed for file# 3, old size 471040K, new size 481280K

在将近一个小时之后，它刚刚将这个添加到日志中。

Fatal NI connect error 12637, connecting to:
 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))

  VERSION INFORMATION:
    TNS for 64-bit Windows: Version 12.2.0.1.0 - Production
    Oracle Bequeath NT Protocol Adapter for 64-bit Windows: Version 12.2.0.1.0 - Production
  Time: 17-OCT-2019 11:13:34
  Tracing not turned on.
  Tns error struct:
    ns main err code: 12637

TNS-12637: Packet receive failed
    ns secondary err code: 12532
    nt main err code: 0
    nt secondary err code: 0
    nt OS err code: 0

Answer 1

也许你只是有一个慢C:驾驶。我认为数据文件是自动增长的，如果它们以较小的增量增长，这也是相当缓慢的。如果您可以选择对它们进行更大的大小调整，那么它应该运行得更快，因为它不需要调整数据文件的大小。但这可能只是一个缓慢的驱动器或一个繁忙的。

鲍比

Answer 2

这是正常的，它正在恢复oracle维护的对象，您希望在新数据库中的所有内容都将被创建。“调整操作完成”意味着自动扩展刚刚被写入的扩展数据文件。

这一步完全依赖于HW，所以给它一些时间。