ORA-01033 oracle initialization or shutdown in progress / Oracle

ReSQL.ru

Мобильная версия Контакт Правила FAQ Помощь

Гость

Войти | Регистрация | Профиль | Очистить

Новые сообщения | Избранное

Форумы | Пользователи | Статистика | Мод. лог | Поиск

Цитировать

Написать

Автор*:

Ввести пароль для входа

Тема*:

Сообщение

Данное сообщение тематическое

Сообщение содержит картинки или видео 18+

Автор:

ВНИМАНИЕ! На данном подфоруме действуют строгие правила. Удостоверьтесь, что ваше сообщение соответствует им!

Форум или тема закрыты для гостей. Необходима авторизация!

Загрузить последнюю сохраненную версию

Вложение:

Вставить как галерею

Максимальный размер вложений: 4,0 МБ, аудио/видео: 8,0 МБ. Картинки большего размера ужимаются, если возможно.

Введите код, изображенный на картинке. Если код нечитаемый, кликните картинку, чтобы загрузить другой вариант.

Отправляя сообщение, я выражаю свое согласие с правилами форума и принимаю пользовательское соглашение.

Доб. в избранное | Игнор. тему | Прикреп. тему | Пометить прочит. / непрочит. | Фильтр

Форумы / Oracle [игнор отключен] [закрыт для гостей] / ORA-01033 oracle initialization or shutdown in progress

24 сообщений из 24, страница 1 из 1

ORA-01033 oracle initialization or shutdown in progress

#39051215

shketok

Гость

Прошу помощи у вас, ветеранов и хорошо знающих данную тему.
Выходит сообщение об ошибке: ORA-01033 oracle initialization or shutdown in progress при подключении к ЛЮБОМУ пользователю БД. Сервер локальный. На машине, на которой запускается TOAD. Разбираюсь я в этом очень плохо. Вот логи (часть):

admin/xe/bdump/alert_xe.log
ORA-322 signalled during: alter database open...
Thu Sep 10 12:35:01 2015
db_recovery_file_dest_size of 10240 MB is 0.98% 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.
Dump file c:\oraclexe\app\oracle\admin\xe\bdump\alert_xe.log
Sat Sep 12 18:06:16 2015
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows NT Version V6.1 Service Pack 1
CPU : 4 - type 586, 2 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:3150M/3988M, Ph+PgF:7139M/7974M, VA:3969M/4095M
Sat Sep 12 18:06:16 2015
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =10
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.1.0.
System parameters with non-default values:
sessions = 49
__shared_pool_size = 201326592
__large_pool_size = 4194304
__java_pool_size = 4194304
__streams_pool_size = 0
spfile = C:\ORACLEXE\APP\ORACLE\PRODUCT\10.2.0\SERVER\DBS\SPFILEXE.ORA
sga_target = 805306368
control_files = C:\ORACLEXE\ORADATA\XE\CONTROL.DBF
__db_cache_size = 591396864
compatible = 10.2.0.1.0
db_recovery_file_dest = C:\oraclexe\app\oracle\flash_recovery_area
db_recovery_file_dest_size= 10737418240
undo_management = AUTO
undo_tablespace = UNDO
remote_login_passwordfile= EXCLUSIVE
dispatchers = (PROTOCOL=TCP) (SERVICE=XEXDB)
shared_servers = 4
job_queue_processes = 4
audit_file_dest = C:\ORACLEXE\APP\ORACLE\ADMIN\XE\ADUMP
background_dump_dest = C:\ORACLEXE\APP\ORACLE\ADMIN\XE\BDUMP
user_dump_dest = C:\ORACLEXE\APP\ORACLE\ADMIN\XE\UDUMP
core_dump_dest = C:\ORACLEXE\APP\ORACLE\ADMIN\XE\CDUMP
db_name = XE
open_cursors = 300
os_authent_prefix =
pga_aggregate_target = 268435456
PSP0 started with pid=3, OS id=2768
MMAN started with pid=4, OS id=2772
DBW0 started with pid=5, OS id=2776
LGWR started with pid=6, OS id=2780
CKPT started with pid=7, OS id=2784
SMON started with pid=8, OS id=2788
RECO started with pid=9, OS id=2792
CJQ0 started with pid=10, OS id=2796
MMON started with pid=11, OS id=2800
MMNL started with pid=12, OS id=2804
Sat Sep 12 18:06:21 2015
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 4 shared server(s) ...
Oracle Data Guard is not available in this edition of Oracle.
PMON started with pid=2, OS id=2764
Sat Sep 12 18:06:23 2015
alter database mount exclusive
Setting recovery target incarnation to 2
Sat Sep 12 18:06:30 2015
Successful mount of redo thread 1, with mount id 2771417055
Sat Sep 12 18:06:30 2015
Database mounted in Exclusive Mode
Completed: alter database mount exclusive
Sat Sep 12 18:06:30 2015
alter database open
Sat Sep 12 18:06:32 2015
Errors in file c:\oraclexe\app\oracle\admin\xe\bdump\xe_lgwr_2780.trc:
ORA-00322: log 1 of thread 1 is not current copy
ORA-00312: online log 1 thread 1: 'C:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_1_BLOKOKVT_.LOG'

Sat Sep 12 18:06:32 2015
Errors in file c:\oraclexe\app\oracle\admin\xe\bdump\xe_lgwr_2780.trc:
ORA-00322: log 1 of thread 1 is not current copy
ORA-00312: online log 1 thread 1: 'C:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_1_BLOKOKVT_.LOG'

ORA-322 signalled during: alter database open...
Sat Sep 12 18:19:16 2015
db_recovery_file_dest_size of 10240 MB is 0.98% 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.
Dump file c:\oraclexe\app\oracle\admin\xe\bdump\alert_xe.log
Mon Sep 14 01:52:27 2015
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows NT Version V6.1 Service Pack 1
CPU : 4 - type 586, 2 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:2955M/3988M, Ph+PgF:6925M/7974M, VA:3969M/4095M
Mon Sep 14 01:52:27 2015
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =10
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.1.0.
System parameters with non-default values:
sessions = 49
__shared_pool_size = 201326592
__large_pool_size = 4194304
__java_pool_size = 4194304
__streams_pool_size = 0
spfile = C:\ORACLEXE\APP\ORACLE\PRODUCT\10.2.0\SERVER\DBS\SPFILEXE.ORA
sga_target = 805306368
control_files = C:\ORACLEXE\ORADATA\XE\CONTROL.DBF
__db_cache_size = 591396864
compatible = 10.2.0.1.0
db_recovery_file_dest = C:\oraclexe\app\oracle\flash_recovery_area
db_recovery_file_dest_size= 10737418240
undo_management = AUTO
undo_tablespace = UNDO
remote_login_passwordfile= EXCLUSIVE
dispatchers = (PROTOCOL=TCP) (SERVICE=XEXDB)
shared_servers = 4
job_queue_processes = 4
audit_file_dest = C:\ORACLEXE\APP\ORACLE\ADMIN\XE\ADUMP
background_dump_dest = C:\ORACLEXE\APP\ORACLE\ADMIN\XE\BDUMP
user_dump_dest = C:\ORACLEXE\APP\ORACLE\ADMIN\XE\UDUMP
core_dump_dest = C:\ORACLEXE\APP\ORACLE\ADMIN\XE\CDUMP
db_name = XE
open_cursors = 300
os_authent_prefix =
pga_aggregate_target = 268435456
MMAN started with pid=4, OS id=2524
DBW0 started with pid=5, OS id=2528
LGWR started with pid=6, OS id=2532
CKPT started with pid=7, OS id=2536
SMON started with pid=8, OS id=2540
RECO started with pid=9, OS id=2544
CJQ0 started with pid=10, OS id=2548
MMON started with pid=11, OS id=2552
MMNL started with pid=12, OS id=2556
Mon Sep 14 01:52:31 2015
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 4 shared server(s) ...
Oracle Data Guard is not available in this edition of Oracle.
PSP0 started with pid=3, OS id=2520
PMON started with pid=2, OS id=2516
Mon Sep 14 01:52:32 2015
alter database mount exclusive
Setting recovery target incarnation to 2
Mon Sep 14 01:52:37 2015
Successful mount of redo thread 1, with mount id 2771439520
Mon Sep 14 01:52:37 2015
Database mounted in Exclusive Mode
Completed: alter database mount exclusive
Mon Sep 14 01:52:37 2015
alter database open
Mon Sep 14 01:52:39 2015
Errors in file c:\oraclexe\app\oracle\admin\xe\bdump\xe_lgwr_2532.trc:
ORA-00322: log 1 of thread 1 is not current copy
ORA-00312: online log 1 thread 1: 'C:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_1_BLOKOKVT_.LOG'

Mon Sep 14 01:52:39 2015
Errors in file c:\oraclexe\app\oracle\admin\xe\bdump\xe_lgwr_2532.trc:
ORA-00322: log 1 of thread 1 is not current copy
ORA-00312: online log 1 thread 1: 'C:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_1_BLOKOKVT_.LOG'

ORA-322 signalled during: alter database open...
Mon Sep 14 02:06:53 2015
db_recovery_file_dest_size of 10240 MB is 0.98% 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.
Mon Sep 14 02:25:36 2015
Starting ORACLE instance (normal)
Shutting down instance: further logons disabled
Mon Sep 14 02:25:56 2015
Stopping background process CJQ0
Mon Sep 14 02:25:56 2015
Stopping background process MMNL
Mon Sep 14 02:25:57 2015
Stopping background process MMON
Mon Sep 14 02:25:58 2015
Shutting down instance (immediate)
License high water mark = 1
Mon Sep 14 02:25:58 2015
Stopping Job queue slave processes
Mon Sep 14 02:25:58 2015
Job queue slave processes stopped
Waiting for dispatcher 'D000' to shutdown
All dispatchers and shared servers shutdown
Mon Sep 14 02:26:01 2015
alter database close normal
ORA-1109 signalled during: alter database close normal...
Dump file c:\oraclexe\app\oracle\admin\xe\bdump\alert_xe.log
Mon Sep 14 02:26:15 2015
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows NT Version V6.1 Service Pack 1
CPU : 4 - type 586, 2 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:1179M/3988M, Ph+PgF:4740M/7974M, VA:3969M/4095M
Mon Sep 14 02:26:15 2015
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =10
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.1.0.
System parameters with non-default values:
sessions = 49
__shared_pool_size = 201326592
__large_pool_size = 4194304
__java_pool_size = 4194304
__streams_pool_size = 0
spfile = C:\ORACLEXE\APP\ORACLE\PRODUCT\10.2.0\SERVER\DBS\SPFILEXE.ORA
sga_target = 805306368
control_files = C:\ORACLEXE\ORADATA\XE\CONTROL.DBF
__db_cache_size = 591396864
compatible = 10.2.0.1.0
db_recovery_file_dest = C:\oraclexe\app\oracle\flash_recovery_area
db_recovery_file_dest_size= 10737418240
undo_management = AUTO
undo_tablespace = UNDO
remote_login_passwordfile= EXCLUSIVE
dispatchers = (PROTOCOL=TCP) (SERVICE=XEXDB)
shared_servers = 4
job_queue_processes = 4
audit_file_dest = C:\ORACLEXE\APP\ORACLE\ADMIN\XE\ADUMP
background_dump_dest = C:\ORACLEXE\APP\ORACLE\ADMIN\XE\BDUMP
user_dump_dest = C:\ORACLEXE\APP\ORACLE\ADMIN\XE\UDUMP
core_dump_dest = C:\ORACLEXE\APP\ORACLE\ADMIN\XE\CDUMP
db_name = XE
open_cursors = 300
os_authent_prefix =
pga_aggregate_target = 268435456
PMON started with pid=2, OS id=5712
PSP0 started with pid=3, OS id=2396
MMAN started with pid=4, OS id=2612
DBW0 started with pid=5, OS id=6128
LGWR started with pid=6, OS id=2744
CKPT started with pid=7, OS id=2624
SMON started with pid=8, OS id=5292
RECO started with pid=9, OS id=3616
CJQ0 started with pid=10, OS id=4512
MMON started with pid=11, OS id=3712
Mon Sep 14 02:26:15 2015
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=12, OS id=5620
Mon Sep 14 02:26:15 2015
starting up 4 shared server(s) ...
Oracle Data Guard is not available in this edition of Oracle.
Mon Sep 14 02:26:15 2015
alter database mount exclusive
Mon Sep 14 02:26:20 2015
Setting recovery target incarnation to 2
Mon Sep 14 02:26:20 2015
Successful mount of redo thread 1, with mount id 2771462791
Mon Sep 14 02:26:20 2015
Database mounted in Exclusive Mode
Completed: alter database mount exclusive
Mon Sep 14 02:26:20 2015
alter database open
Mon Sep 14 02:26:20 2015
Errors in file c:\oraclexe\app\oracle\admin\xe\bdump\xe_lgwr_2744.trc:
ORA-00322: log 1 of thread 1 is not current copy
ORA-00312: online log 1 thread 1: 'C:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_1_BLOKOKVT_.LOG'

Mon Sep 14 02:26:20 2015
Errors in file c:\oraclexe\app\oracle\admin\xe\bdump\xe_lgwr_2744.trc:
ORA-00322: log 1 of thread 1 is not current copy
ORA-00312: online log 1 thread 1: 'C:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_1_BLOKOKVT_.LOG'

ORA-322 signalled during: alter database open...
Mon Sep 14 02:26:23 2015
Starting ORACLE instance (normal)
Mon Sep 14 02:41:23 2015
db_recovery_file_dest_size of 10240 MB is 0.98% 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.
Mon Sep 14 02:43:49 2015
Shutting down instance: further logons disabled
Mon Sep 14 02:43:49 2015
Stopping background process CJQ0
Mon Sep 14 02:43:49 2015
Stopping background process MMNL
Mon Sep 14 02:43:50 2015
Stopping background process MMON
Mon Sep 14 02:43:51 2015
Shutting down instance (immediate)
License high water mark = 1
Mon Sep 14 02:43:51 2015
Stopping Job queue slave processes
Mon Sep 14 02:43:51 2015
Job queue slave processes stopped
Waiting for dispatcher 'D000' to shutdown
All dispatchers and shared servers shutdown
Mon Sep 14 02:43:53 2015
alter database close normal
ORA-1109 signalled during: alter database close normal...
Dump file c:\oraclexe\app\oracle\admin\xe\bdump\alert_xe.log
Mon Sep 14 02:44:13 2015
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows NT Version V6.1 Service Pack 1
CPU : 4 - type 586, 2 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:1001M/3988M, Ph+PgF:4633M/7974M, VA:3969M/4095M
Mon Sep 14 02:44:13 2015
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =10
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.1.0.
System parameters with non-default values:
sessions = 49
__shared_pool_size = 201326592
__large_pool_size = 4194304
__java_pool_size = 4194304
__streams_pool_size = 0
spfile = C:\ORACLEXE\APP\ORACLE\PRODUCT\10.2.0\SERVER\DBS\SPFILEXE.ORA
sga_target = 805306368
control_files = C:\ORACLEXE\ORADATA\XE\CONTROL.DBF
__db_cache_size = 591396864
compatible = 10.2.0.1.0
db_recovery_file_dest = C:\oraclexe\app\oracle\flash_recovery_area
db_recovery_file_dest_size= 10737418240
undo_management = AUTO
undo_tablespace = UNDO
remote_login_passwordfile= EXCLUSIVE
dispatchers = (PROTOCOL=TCP) (SERVICE=XEXDB)
shared_servers = 4
job_queue_processes = 4
audit_file_dest = C:\ORACLEXE\APP\ORACLE\ADMIN\XE\ADUMP
background_dump_dest = C:\ORACLEXE\APP\ORACLE\ADMIN\XE\BDUMP
user_dump_dest = C:\ORACLEXE\APP\ORACLE\ADMIN\XE\UDUMP
core_dump_dest = C:\ORACLEXE\APP\ORACLE\ADMIN\XE\CDUMP
db_name = XE
open_cursors = 300
os_authent_prefix =
pga_aggregate_target = 268435456
PMON started with pid=2, OS id=2228
PSP0 started with pid=3, OS id=2060
MMAN started with pid=4, OS id=5336
DBW0 started with pid=5, OS id=2160
LGWR started with pid=6, OS id=4384
SMON started with pid=8, OS id=6016
MMNL started with pid=12, OS id=5272
RECO started with pid=9, OS id=3296
Mon Sep 14 02:44:14 2015
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
CJQ0 started with pid=10, OS id=5488
MMON started with pid=11, OS id=2956
CKPT started with pid=7, OS id=764
Mon Sep 14 02:44:14 2015
starting up 4 shared server(s) ...
Oracle Data Guard is not available in this edition of Oracle.
Mon Sep 14 02:44:14 2015
alter database mount exclusive
Mon Sep 14 02:44:18 2015
Setting recovery target incarnation to 2
Mon Sep 14 02:44:18 2015
Successful mount of redo thread 1, with mount id 2771432894
Mon Sep 14 02:44:18 2015
Database mounted in Exclusive Mode
Completed: alter database mount exclusive
Mon Sep 14 02:44:18 2015
alter database open
Mon Sep 14 02:44:19 2015
Errors in file c:\oraclexe\app\oracle\admin\xe\bdump\xe_lgwr_4384.trc:
ORA-00322: log 1 of thread 1 is not current copy
ORA-00312: online log 1 thread 1: 'C:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_1_BLOKOKVT_.LOG'

Mon Sep 14 02:44:19 2015
Errors in file c:\oraclexe\app\oracle\admin\xe\bdump\xe_lgwr_4384.trc:
ORA-00322: log 1 of thread 1 is not current copy
ORA-00312: online log 1 thread 1: 'C:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_1_BLOKOKVT_.LOG'

ORA-322 signalled during: alter database open...
Mon Sep 14 02:44:22 2015
Starting ORACLE instance (normal)
Mon Sep 14 02:59:20 2015
db_recovery_file_dest_size of 10240 MB is 0.98% 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.
Mon Sep 14 07:18:39 2015
Shutting down instance: further logons disabled
Mon Sep 14 07:18:40 2015
Stopping background process MMNL
Mon Sep 14 07:18:40 2015
Stopping background process CJQ0
Mon Sep 14 07:18:41 2015
Stopping background process MMON
Mon Sep 14 07:18:42 2015
Shutting down instance (immediate)
License high water mark = 1
Mon Sep 14 07:18:42 2015
Stopping Job queue slave processes
Mon Sep 14 07:18:42 2015
Job queue slave processes stopped
Waiting for dispatcher 'D000' to shutdown
All dispatchers and shared servers shutdown
Mon Sep 14 07:18:44 2015
alter database close normal
ORA-1109 signalled during: alter database close normal...
Dump file c:\oraclexe\app\oracle\admin\xe\bdump\alert_xe.log
Mon Sep 14 07:18:55 2015
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows NT Version V6.1 Service Pack 1
CPU : 4 - type 586, 2 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:883M/3988M, Ph+PgF:4141M/7974M, VA:3969M/4095M
Mon Sep 14 07:18:55 2015
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =10
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.1.0.
System parameters with non-default values:
sessions = 49
__shared_pool_size = 201326592
__large_pool_size = 4194304
__java_pool_size = 4194304
__streams_pool_size = 0
spfile = C:\ORACLEXE\APP\ORACLE\PRODUCT\10.2.0\SERVER\DBS\SPFILEXE.ORA
sga_target = 805306368
control_files = C:\ORACLEXE\ORADATA\XE\CONTROL.DBF
__db_cache_size = 591396864
compatible = 10.2.0.1.0
db_recovery_file_dest = C:\oraclexe\app\oracle\flash_recovery_area
db_recovery_file_dest_size= 10737418240
undo_management = AUTO
undo_tablespace = UNDO
remote_login_passwordfile= EXCLUSIVE
dispatchers = (PROTOCOL=TCP) (SERVICE=XEXDB)
shared_servers = 4
job_queue_processes = 4
audit_file_dest = C:\ORACLEXE\APP\ORACLE\ADMIN\XE\ADUMP
background_dump_dest = C:\ORACLEXE\APP\ORACLE\ADMIN\XE\BDUMP
user_dump_dest = C:\ORACLEXE\APP\ORACLE\ADMIN\XE\UDUMP
core_dump_dest = C:\ORACLEXE\APP\ORACLE\ADMIN\XE\CDUMP
db_name = XE
open_cursors = 300
os_authent_prefix =
pga_aggregate_target = 268435456
PMON started with pid=2, OS id=2724
PSP0 started with pid=3, OS id=6088
MMAN started with pid=4, OS id=2788
DBW0 started with pid=5, OS id=2376
LGWR started with pid=6, OS id=4352
CKPT started with pid=7, OS id=3628
SMON started with pid=8, OS id=4376
RECO started with pid=9, OS id=5216
CJQ0 started with pid=10, OS id=2940
MMON started with pid=11, OS id=3252
Mon Sep 14 07:18:56 2015
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=12, OS id=4620
Mon Sep 14 07:18:56 2015
starting up 4 shared server(s) ...
Oracle Data Guard is not available in this edition of Oracle.
Mon Sep 14 07:18:56 2015
alter database mount exclusive
Mon Sep 14 07:19:00 2015
Setting recovery target incarnation to 2
Mon Sep 14 07:19:00 2015
Successful mount of redo thread 1, with mount id 2771499296
Mon Sep 14 07:19:00 2015
Database mounted in Exclusive Mode
Completed: alter database mount exclusive
Mon Sep 14 07:19:00 2015
alter database open
Mon Sep 14 07:19:01 2015
Errors in file c:\oraclexe\app\oracle\admin\xe\bdump\xe_lgwr_4352.trc:
ORA-00322: log 1 of thread 1 is not current copy
ORA-00312: online log 1 thread 1: 'C:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_1_BLOKOKVT_.LOG'

Mon Sep 14 07:19:01 2015
Errors in file c:\oraclexe\app\oracle\admin\xe\bdump\xe_lgwr_4352.trc:
ORA-00322: log 1 of thread 1 is not current copy
ORA-00312: online log 1 thread 1: 'C:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_1_BLOKOKVT_.LOG'

ORA-322 signalled during: alter database open...
Mon Sep 14 07:19:04 2015
Starting ORACLE instance (normal)
Mon Sep 14 07:34:02 2015
db_recovery_file_dest_size of 10240 MB is 0.98% 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.
Dump file c:\oraclexe\app\oracle\admin\xe\bdump\alert_xe.log
Mon Sep 14 09:18:43 2015
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows NT Version V6.1 Service Pack 1
CPU : 4 - type 586, 2 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:3173M/3988M, Ph+PgF:7145M/7974M, VA:3972M/4095M
Mon Sep 14 09:18:43 2015
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =10
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.1.0.
System parameters with non-default values:
sessions = 49
__shared_pool_size = 201326592
__large_pool_size = 4194304
__java_pool_size = 4194304
__streams_pool_size = 0
spfile = C:\ORACLEXE\APP\ORACLE\PRODUCT\10.2.0\SERVER\DBS\SPFILEXE.ORA
sga_target = 805306368
control_files = C:\ORACLEXE\ORADATA\XE\CONTROL.DBF
__db_cache_size = 591396864
compatible = 10.2.0.1.0
db_recovery_file_dest = C:\oraclexe\app\oracle\flash_recovery_area
db_recovery_file_dest_size= 10737418240
undo_management = AUTO
undo_tablespace = UNDO
remote_login_passwordfile= EXCLUSIVE
dispatchers = (PROTOCOL=TCP) (SERVICE=XEXDB)
shared_servers = 4
job_queue_processes = 4
audit_file_dest = C:\ORACLEXE\APP\ORACLE\ADMIN\XE\ADUMP
background_dump_dest = C:\ORACLEXE\APP\ORACLE\ADMIN\XE\BDUMP
user_dump_dest = C:\ORACLEXE\APP\ORACLE\ADMIN\XE\UDUMP
core_dump_dest = C:\ORACLEXE\APP\ORACLE\ADMIN\XE\CDUMP
db_name = XE
open_cursors = 300
os_authent_prefix =
pga_aggregate_target = 268435456
PMON started with pid=2, OS id=2268
PSP0 started with pid=3, OS id=2272
MMAN started with pid=4, OS id=2276
DBW0 started with pid=5, OS id=2280
LGWR started with pid=6, OS id=2284
CKPT started with pid=7, OS id=2288
SMON started with pid=8, OS id=2292
RECO started with pid=9, OS id=2296
CJQ0 started with pid=10, OS id=2300
MMON started with pid=11, OS id=2304
MMNL started with pid=12, OS id=2308
Mon Sep 14 09:18:44 2015
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 4 shared server(s) ...
Oracle Data Guard is not available in this edition of Oracle.
Mon Sep 14 09:18:44 2015
alter database mount exclusive
Mon Sep 14 09:18:50 2015
Setting recovery target incarnation to 2
Mon Sep 14 09:18:53 2015
Successful mount of redo thread 1, with mount id 2771546164
Mon Sep 14 09:18:53 2015
Database mounted in Exclusive Mode
Completed: alter database mount exclusive
Mon Sep 14 09:18:55 2015
alter database open
Mon Sep 14 09:18:57 2015
Errors in file c:\oraclexe\app\oracle\admin\xe\bdump\xe_lgwr_2284.trc:
ORA-00322: log 1 of thread 1 is not current copy
ORA-00312: online log 1 thread 1: 'C:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_1_BLOKOKVT_.LOG'

Mon Sep 14 09:18:57 2015
Errors in file c:\oraclexe\app\oracle\admin\xe\bdump\xe_lgwr_2284.trc:
ORA-00322: log 1 of thread 1 is not current copy
ORA-00312: online log 1 thread 1: 'C:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_1_BLOKOKVT_.LOG'

ORA-322 signalled during: alter database open...
Mon Sep 14 09:31:22 2015
db_recovery_file_dest_size of 10240 MB is 0.98% 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.
Mon Sep 14 10:07:05 2015
Starting ORACLE instance (normal)
Shutting down instance: further logons disabled
Mon Sep 14 10:12:19 2015
Stopping background process MMNL
Mon Sep 14 10:12:19 2015
Stopping background process CJQ0
Mon Sep 14 10:12:20 2015
Stopping background process MMON
Mon Sep 14 10:12:21 2015
Shutting down instance (immediate)
License high water mark = 1
Mon Sep 14 10:12:21 2015
Stopping Job queue slave processes
Mon Sep 14 10:12:21 2015
Job queue slave processes stopped
Waiting for dispatcher 'D000' to shutdown
All dispatchers and shared servers shutdown
Mon Sep 14 10:12:23 2015
alter database close normal
ORA-1109 signalled during: alter database close normal...
Dump file c:\oraclexe\app\oracle\admin\xe\bdump\alert_xe.log
Mon Sep 14 10:12:29 2015
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows NT Version V6.1 Service Pack 1
CPU : 4 - type 586, 2 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:736M/3988M, Ph+PgF:4220M/7974M, VA:3972M/4095M
Mon Sep 14 10:12:29 2015
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =10
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.1.0.
System parameters with non-default values:
sessions = 49
__shared_pool_size = 201326592
__large_pool_size = 4194304
__java_pool_size = 4194304
__streams_pool_size = 0
spfile = C:\ORACLEXE\APP\ORACLE\PRODUCT\10.2.0\SERVER\DBS\SPFILEXE.ORA
sga_target = 805306368
control_files = C:\ORACLEXE\ORADATA\XE\CONTROL.DBF
__db_cache_size = 591396864
compatible = 10.2.0.1.0
db_recovery_file_dest = C:\oraclexe\app\oracle\flash_recovery_area
db_recovery_file_dest_size= 10737418240
undo_management = AUTO
undo_tablespace = UNDO
remote_login_passwordfile= EXCLUSIVE
dispatchers = (PROTOCOL=TCP) (SERVICE=XEXDB)
shared_servers = 4
job_queue_processes = 4
audit_file_dest = C:\ORACLEXE\APP\ORACLE\ADMIN\XE\ADUMP
background_dump_dest = C:\ORACLEXE\APP\ORACLE\ADMIN\XE\BDUMP
user_dump_dest = C:\ORACLEXE\APP\ORACLE\ADMIN\XE\UDUMP
core_dump_dest = C:\ORACLEXE\APP\ORACLE\ADMIN\XE\CDUMP
db_name = XE
open_cursors = 300
os_authent_prefix =
pga_aggregate_target = 268435456
PMON started with pid=2, OS id=6204
PSP0 started with pid=3, OS id=1012
MMAN started with pid=4, OS id=4244
DBW0 started with pid=5, OS id=1608
LGWR started with pid=6, OS id=1004
CKPT started with pid=7, OS id=5080
SMON started with pid=8, OS id=4292
RECO started with pid=9, OS id=6416
CJQ0 started with pid=10, OS id=3500
MMON started with pid=11, OS id=3232
Mon Sep 14 10:12:30 2015
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=12, OS id=5172
Mon Sep 14 10:12:30 2015
starting up 4 shared server(s) ...
Oracle Data Guard is not available in this edition of Oracle.
Mon Sep 14 10:12:31 2015
alter database mount exclusive
Mon Sep 14 10:12:37 2015
Setting recovery target incarnation to 2
Mon Sep 14 10:12:38 2015
Successful mount of redo thread 1, with mount id 2771523281
Mon Sep 14 10:12:38 2015
Database mounted in Exclusive Mode
Completed: alter database mount exclusive
Mon Sep 14 10:12:38 2015
alter database open
Mon Sep 14 10:12:38 2015
Errors in file c:\oraclexe\app\oracle\admin\xe\bdump\xe_lgwr_1004.trc:
ORA-00322: log 1 of thread 1 is not current copy
ORA-00312: online log 1 thread 1: 'C:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_1_BLOKOKVT_.LOG'

Mon Sep 14 10:12:38 2015
Errors in file c:\oraclexe\app\oracle\admin\xe\bdump\xe_lgwr_1004.trc:
ORA-00322: log 1 of thread 1 is not current copy
ORA-00312: online log 1 thread 1: 'C:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_1_BLOKOKVT_.LOG'

ORA-322 signalled during: alter database open...
Mon Sep 14 10:27:34 2015
db_recovery_file_dest_size of 10240 MB is 0.98% 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.
Dump file c:\oraclexe\app\oracle\admin\xe\bdump\alert_xe.log
Mon Sep 14 12:01:19 2015
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows NT Version V6.1 Service Pack 1
CPU : 4 - type 586, 2 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:2459M/3988M, Ph+PgF:6454M/7974M, VA:3971M/4095M
Mon Sep 14 12:01:19 2015
Starting ORACLE instance (normal)
Mon Sep 14 12:01:29 2015
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =10
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.1.0.
System parameters with non-default values:
sessions = 49
__shared_pool_size = 201326592
__large_pool_size = 4194304
__java_pool_size = 4194304
__streams_pool_size = 0
spfile = C:\ORACLEXE\APP\ORACLE\PRODUCT\10.2.0\SERVER\DBS\SPFILEXE.ORA
sga_target = 805306368
control_files = C:\ORACLEXE\ORADATA\XE\CONTROL.DBF
__db_cache_size = 591396864
compatible = 10.2.0.1.0
db_recovery_file_dest = C:\oraclexe\app\oracle\flash_recovery_area
db_recovery_file_dest_size= 10737418240
undo_management = AUTO
undo_tablespace = UNDO
remote_login_passwordfile= EXCLUSIVE
dispatchers = (PROTOCOL=TCP) (SERVICE=XEXDB)
shared_servers = 4
job_queue_processes = 4
audit_file_dest = C:\ORACLEXE\APP\ORACLE\ADMIN\XE\ADUMP
background_dump_dest = C:\ORACLEXE\APP\ORACLE\ADMIN\XE\BDUMP
user_dump_dest = C:\ORACLEXE\APP\ORACLE\ADMIN\XE\UDUMP
core_dump_dest = C:\ORACLEXE\APP\ORACLE\ADMIN\XE\CDUMP
db_name = XE
open_cursors = 300
os_authent_prefix =
pga_aggregate_target = 268435456
PMON started with pid=2, OS id=4740
MMAN started with pid=4, OS id=4748
DBW0 started with pid=5, OS id=4364
LGWR started with pid=6, OS id=4756
CKPT started with pid=7, OS id=4356
SMON started with pid=8, OS id=4372
RECO started with pid=9, OS id=4752
CJQ0 started with pid=10, OS id=4852
MMON started with pid=11, OS id=4348
MMNL started with pid=12, OS id=4360
Mon Sep 14 12:01:41 2015
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 4 shared server(s) ...
Oracle Data Guard is not available in this edition of Oracle.
PSP0 started with pid=3, OS id=4744
Mon Sep 14 12:01:47 2015
alter database mount exclusive
Mon Sep 14 12:01:53 2015
Setting recovery target incarnation to 2
Mon Sep 14 12:01:54 2015
Successful mount of redo thread 1, with mount id 2771557996
Mon Sep 14 12:01:54 2015
Database mounted in Exclusive Mode
Completed: alter database mount exclusive
Mon Sep 14 12:01:55 2015
alter database open
Mon Sep 14 12:01:57 2015
Errors in file c:\oraclexe\app\oracle\admin\xe\bdump\xe_lgwr_4756.trc:
ORA-00322: log 1 of thread 1 is not current copy
ORA-00312: online log 1 thread 1: 'C:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_1_BLOKOKVT_.LOG'

Mon Sep 14 12:01:57 2015
Errors in file c:\oraclexe\app\oracle\admin\xe\bdump\xe_lgwr_4756.trc:
ORA-00322: log 1 of thread 1 is not current copy
ORA-00312: online log 1 thread 1: 'C:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_1_BLOKOKVT_.LOG'

ORA-322 signalled during: alter database open...
Mon Sep 14 22:02:47 2015
db_recovery_file_dest_size of 10240 MB is 0.98% 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.

...

Рейтинг:

0 / 0

14.09.2015, 20:24

| Ответить | Цитировать | Написать

ORA-01033 oracle initialization or shutdown in progress

#39051345

_примус

Гость

shketok,

oerr ora 322
00322, 00000, "log %s of thread %s is not current copy"
// *Cause: Check of log file header at database open found that an online
// log appears to be an incorrectly restored backup.
// *Action: Restore correct file or reset logs.

так понятней?

Если нет, то идешь к начальнику и говоришь ,что надо бы вам ораклового админа заполучить.

...

Рейтинг:

0 / 0

15.09.2015, 02:51

| Ответить | Цитировать | Написать

ORA-01033 oracle initialization or shutdown in progress

#39051836

shketok

Гость

_примус, честно не понятно. Сам студент. Курсовую задолжал, и вот после лета вылетает такая ошибка. Подскажите как лечить, и я был бы вам благодарен если бы вы писали по простому, что бы даже такой пень как я понял что делать. Благодарю за реакцию и помощь.

...

Рейтинг:

0 / 0

15.09.2015, 14:23

| Ответить | Цитировать | Написать

ORA-01033 oracle initialization or shutdown in progress

#39051874

Учисьстудент

Гость

redolog кривой лежит, база не может подняться.
Надо либо подложить правильный redo, либо alter database open resetlogs - c вероятной потерей последних транзакций

...

Рейтинг:

0 / 0

15.09.2015, 14:51

| Ответить | Цитировать | Написать

ORA-01033 oracle initialization or shutdown in progress

#39051890

tru55

Участник

Откуда: СПб

Сообщения: 16 884

Рейтинг: 0 / 0

Учисьстудентлибо alter database open resetlogs
И что, без неполного восстановления пройдет?

...

Рейтинг:

0 / 0

15.09.2015, 15:05

| Ответить | Цитировать | Написать

ORA-01033 oracle initialization or shutdown in progress

#39051900

Какфишкаляжет

Гость

tru55Учисьстудентлибо alter database open resetlogs
И что, без неполного восстановления пройдет?
Хрен его знает, студента
shketokКурсовую задолжал, и вот после лета вылетает такая ошибка.
Думаю он оракель на локальном развернул - бэкапов нет, рестора не было - сталбыть базка консистентна но, возможно, слегка поломана. Скажем, место под игрушки чистил - логи удалял :)

...

Рейтинг:

0 / 0

15.09.2015, 15:12

| Ответить | Цитировать | Написать

ORA-01033 oracle initialization or shutdown in progress

#39051910

Q.Tarantino

Участник

Откуда: Где-то рядом...

Сообщения: 13 453

Рейтинг: 0 / 0

shketok_примус, честно не понятно. Сам студент. Курсовую задолжал, и вот после лета вылетает такая ошибка. Подскажите как лечить, и я был бы вам благодарен если бы вы писали по простому, что бы даже такой пень как я понял что делать. Благодарю за реакцию и помощь.
в логгруппе по одному мемберу?
если да - open resetlogs. и как повезет :)

...

Рейтинг:

0 / 0

15.09.2015, 15:18

| Ответить | Цитировать | Написать

ORA-01033 oracle initialization or shutdown in progress

#39052200

shketok

Гость

SQL> alter database open resetlogs;
SP2-0640: Not connected.

В нете ничего не нашел по этой проблеме. Службы запускал, отключал. (OracleXETNSListner, OracleXEClrAgent, OracleServiceXE)
Правильный redo понятия не имею где взять.

Какфишкаляжет Думаю он оракель на локальном развернул - бэкапов нет, рестора не было - сталбыть базка консистентна но, возможно, слегка поломана. Скажем, место под игрушки чистил - логи удалял :)
Все верно, так оно скорее всего и было. Но ьэкапов нет. Рестора не делал.

Q.Tarantino в логгруппе по одному мемберу?
если да - open resetlogs. и как повезет :)
Честно не имею понятия о чем вы. Я слишком плохо ознакомлен с этой темой. Поэтому собственно и просил объяснять проще, как для чайника.

...

Рейтинг:

0 / 0

15.09.2015, 18:49

| Ответить | Цитировать | Написать

ORA-01033 oracle initialization or shutdown in progress

#39052290

ora601

Участник

Сообщения: 785

Рейтинг: 0 / 0

shketok,

Код: plsql

1.
2.
3.

cmd > RMAN target SYS/PWD@XE
RMAN> startup;

...

Рейтинг:

0 / 0

15.09.2015, 21:37

| Ответить | Цитировать | Написать

ORA-01033 oracle initialization or shutdown in progress

#39052302

shketok

Гость

ora601,

...

Рейтинг:

0 / 0

15.09.2015, 22:39

| Ответить | Цитировать | Написать

ORA-01033 oracle initialization or shutdown in progress

#39052306

ora601

Участник

Сообщения: 785

Рейтинг: 0 / 0

shketok,

пробуй

Код: sql

1.
2.
3.

lsnrctl > stop 
lsnrctl > start
RMAN > startup;

...

Рейтинг:

0 / 0

15.09.2015, 22:49

| Ответить | Цитировать | Написать

ORA-01033 oracle initialization or shutdown in progress

#39052324

shketok

Гость

ora601,

...

Рейтинг:

0 / 0

15.09.2015, 23:43

| Ответить | Цитировать | Написать

ORA-01033 oracle initialization or shutdown in progress

#39052554

Q.Tarantino

Участник

Откуда: Где-то рядом...

Сообщения: 13 453

Рейтинг: 0 / 0

shketok SQL> alter database open resetlogs;
SP2-0640: Not connected.

лучше так...

Код: plsql

1.
2.
3.

shu abort;
startup mount;
alter database open resetlogs;

...

Рейтинг:

0 / 0

16.09.2015, 10:56

| Ответить | Цитировать | Написать

ORA-01033 oracle initialization or shutdown in progress

#39052708

shketok

Гость

Q.Tarantinoshketok SQL> alter database open resetlogs;
SP2-0640: Not connected.

лучше так...

Код: plsql

1.
2.
3.

shu abort;
startup mount;
alter database open resetlogs;

Всем огромное спасибо. Проблему решил. После ORA-01139 сделал следующее:
sqlplus /nolog
conn / as sysdba
create spfile from pfile;
create pfile from spfile;

Добавил в $ORACLE_HOME/dbs/init<SID>.ora строку вида:*._allow_resetlogs_corruption=true
startup pfile='init<SID>.ora' mount;
recover database until cancel;
alter database open resetlogs;

Решение нашел в гугле, так понимаю ссылки на форуме на другие источники оставлять нежелательно, поэтому просто скопировал решение проблемы.

Еще раз хотел поблагодарить всех кто пытался помочь. Без вас ничего бы не получилось. Дай бог и я когда нибудь смогу так же как вы помогать другим.

...

Рейтинг:

0 / 0

16.09.2015, 13:23

| Ответить | Цитировать | Написать

ORA-01033 oracle initialization or shutdown in progress

#39052843

Q.Tarantino

Участник

Откуда: Где-то рядом...

Сообщения: 13 453

Рейтинг: 0 / 0

shketokПроблему решил.
а теперь лучше всего сделать экспорт данных, создать новую БД и в нее это все залить.

...

Рейтинг:

0 / 0

16.09.2015, 14:16

| Ответить | Цитировать | Написать

Период между сообщениями больше года.

ORA-01033 oracle initialization or shutdown in progress

#39522712

revizor

Участник

Сообщения: 21

Рейтинг: 0 / 0

Добрый день! у нас после отключение электропитании не запустился один сервер.
ошибка ora-01033. пытался зарустить через:
shu abort
startup mount , тут без каких либо ошибок работает
alter database open resetlogs; ошибки ora-01194,01110. Не знаю что делать дальше. Дайте советы чтобы исправить ошибку.

выложил алерт за сегодня

Код: plsql

1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
43.
44.
45.
46.
47.
48.
49.
50.
51.
52.
53.
54.
55.
56.
57.
58.
59.
60.
61.
62.
63.
64.
65.
66.
67.
68.
69.
70.
71.
72.
73.
74.
75.
76.
77.
78.
79.
80.
81.
82.
83.
84.
85.
86.
87.
88.
89.
90.
91.
92.
93.
94.
95.
96.
97.
98.
99.
100.
101.
102.
103.
104.
105.
106.
107.
108.
109.
110.
111.
112.
113.
114.
115.
116.
117.
118.
119.
120.
121.
122.
123.
124.
125.
126.
127.
128.
129.
130.
131.
132.
133.
134.
135.
136.
137.
138.
139.
140.
141.
142.
143.
144.
145.
146.
147.
148.
149.
150.
151.
152.
153.
154.
155.
156.
157.
158.
159.
160.
161.
162.
163.
164.
165.
166.
167.
168.
169.
170.
171.
172.
173.
174.
175.
176.
177.
178.
179.
180.
181.
182.
183.
184.
185.
186.
187.
188.
189.
190.
191.
192.
193.
194.
195.
196.
197.
198.
199.
200.
201.
202.
203.
204.
205.
206.
207.
208.
209.
210.
211.
212.
213.
214.
215.
216.
217.
218.
219.
220.
221.
222.
223.
224.
225.
226.
227.
228.
229.
230.
231.
232.
233.
234.
235.
236.
237.
238.
239.
240.
241.
242.
243.
244.
245.
246.
247.
248.
249.
250.
251.
252.
253.
254.
255.
256.
257.
258.
259.
260.
261.
262.
263.
264.
265.
266.
267.
268.
269.
270.
271.
272.
273.
274.
275.
276.
277.
278.
279.
280.
281.
282.
283.
284.
285.
286.
287.
288.
289.
290.
291.
292.
293.
294.
295.
296.
297.
298.
299.
300.
301.
302.
303.
304.
305.
306.
307.
308.
309.
310.
311.
312.
313.
314.
315.
316.
317.
318.
319.
320.
321.
322.
323.
324.
325.
326.
327.
328.
329.
330.
331.
332.
333.
334.
335.
336.
337.
338.
339.
340.
341.
342.
343.
344.
345.
346.
347.
348.
349.
350.
351.
352.
353.
354.
355.
356.
357.
358.
359.
360.
361.
362.
363.
364.
365.
366.
367.
368.
369.
370.
371.
372.
373.
374.
375.
376.
377.
378.
379.
380.
381.
382.
383.
384.
385.
386.
387.
388.
389.
390.
391.
392.
393.
394.
395.
396.
397.
398.
399.
400.
401.
402.
403.
404.
405.
406.
407.
408.
409.
410.
411.
412.
413.
414.
415.
416.
417.
418.
419.
420.
421.
422.
423.
424.
425.
426.
427.
428.
429.
430.
431.
432.
433.
434.
435.
436.
437.
438.
439.
440.
441.
442.
443.
444.
445.
446.
447.
448.
449.
450.
451.
452.
453.
454.
455.
456.
457.
458.
459.
460.
461.
462.
463.
464.
465.
466.
467.
468.
469.
470.
471.
472.
473.
474.
475.
476.
477.
478.
479.
480.
481.
482.
483.
484.
485.
486.
487.
488.
489.
490.
491.
492.
493.
494.
495.
496.
497.
498.
499.
500.
501.
502.
503.
504.
505.
506.
507.
508.
509.
510.
511.
512.
513.
514.
515.
516.
517.
518.
519.
520.
521.
522.
523.
524.
525.
526.
527.
528.
529.
530.
531.
532.
533.
534.
535.
536.
537.
538.
539.
540.
541.
542.
543.
544.
545.
546.
547.
548.
549.
550.
551.
552.
553.
554.
555.
556.
557.
558.
559.
560.
561.
562.
563.
564.
565.
566.
567.
568.
569.
570.
571.
572.
573.
574.
575.
576.
577.
578.
579.
580.
581.
582.
583.
584.
585.
586.
587.
588.
589.
590.
591.
592.
593.
594.
595.
596.
597.
598.
599.
600.
601.
602.
603.
604.
605.
606.
607.
608.
609.
610.
611.
612.
613.
614.
615.
616.
617.
618.
619.
620.
621.
622.
623.
624.
625.
626.
627.
628.
629.
630.
631.
632.
633.
634.
635.
636.
637.
638.
639.
640.
641.
642.
643.
644.
645.
646.
647.
648.
649.
650.
651.
652.
653.
654.
655.
656.
657.
658.
659.
660.
661.
662.
663.
664.
665.
666.
667.
668.
669.
670.
671.
672.
673.
674.
675.
676.
677.
678.
679.
680.
681.
682.
683.
684.
685.
686.
687.
688.
689.
690.
691.
692.
693.
694.
695.
696.
697.
698.
699.
700.
701.
702.
703.
704.
705.
706.
707.
708.
709.
710.
711.
712.
713.
714.
715.
716.
717.
718.
719.
720.
721.
722.
723.
724.
725.
726.
727.
728.
729.
730.
731.
732.
733.
734.
735.
736.
737.
738.
739.
740.
741.
742.
743.
744.
745.
746.
747.
748.
749.
750.
751.
752.
753.
754.
755.
756.
757.
758.
759.
760.
761.
762.
763.
764.
765.
766.
767.
768.
769.
770.
771.
772.
773.
774.
775.
776.
777.
778.
779.
780.
781.
782.
783.
784.
785.
786.
787.
788.
789.
790.
791.
792.
793.
794.
795.
796.
797.
798.
799.
800.
801.
802.
803.
804.
805.
806.
807.
808.
809.
810.
811.
812.
813.
814.
815.
816.
817.
818.
819.
820.
821.
822.
823.
824.
825.
826.
827.
828.
829.
830.
831.
832.
833.
834.
835.
836.
837.
838.
839.
840.
841.
842.
843.
844.
845.
846.
847.
848.
849.
850.
851.
852.
853.
854.
855.
856.
857.
858.
859.
860.
861.
862.
863.
864.
865.
866.
867.
868.
869.
870.
871.
872.
873.
874.
875.
876.
877.
878.
879.
880.
881.
882.
883.
884.
885.
886.
887.
888.
889.
890.
891.
892.
893.
894.
895.
896.
897.
898.
899.
900.
901.
902.
903.
904.
905.
906.
907.
908.
909.
910.
911.
912.
913.
914.
915.
916.
917.
918.
919.
920.
921.
922.
923.
924.
925.
926.
927.
928.
929.
930.
931.
932.
933.
934.
935.
936.
937.
938.
939.
940.
941.
942.
943.
944.
945.
946.
947.
948.
949.
950.
951.
952.
953.
954.
955.
956.
957.
958.
959.
960.
961.
962.
963.
964.
965.
966.
967.
968.
969.
970.
971.
972.
973.
974.
975.
976.
977.
978.
979.
980.
981.
982.
983.
984.
985.
986.
987.
988.
989.
990.
991.
992.
993.
994.
995.
996.
997.
998.
999.
1000.
1001.
1002.
1003.
1004.
1005.
1006.
1007.
1008.
1009.
1010.
1011.
1012.
1013.
1014.
1015.
1016.
1017.
1018.
1019.
1020.
1021.
1022.
1023.
1024.
1025.
1026.
1027.
1028.
1029.
1030.
1031.
1032.
1033.
1034.
1035.
1036.
1037.
1038.
1039.
1040.
1041.
1042.
1043.
1044.
1045.
1046.
1047.
1048.
1049.
1050.
1051.
1052.
1053.
1054.
1055.
1056.
1057.
1058.
1059.
1060.
1061.
1062.
1063.
1064.
1065.
1066.
1067.
1068.
1069.
1070.
1071.
1072.
1073.
1074.
1075.
1076.
1077.
1078.
1079.
1080.
1081.
1082.
1083.
1084.
1085.
1086.
1087.
1088.
1089.
1090.
1091.
1092.
1093.
1094.
1095.
1096.
1097.
1098.
1099.
1100.
1101.
1102.
1103.
1104.
1105.
1106.
1107.
1108.
1109.
1110.
1111.
1112.
1113.
1114.
1115.
1116.
1117.
1118.
1119.
1120.
1121.
1122.
1123.
1124.
1125.
1126.
1127.
1128.
1129.
1130.
1131.
1132.
1133.
1134.
1135.
1136.
1137.
1138.
1139.
1140.
1141.
1142.
1143.
1144.
1145.
1146.
1147.
1148.
1149.
1150.
1151.
1152.
1153.
1154.
1155.
1156.
1157.
1158.
1159.
1160.
1161.
1162.
1163.
1164.
1165.
1166.
1167.
1168.
1169.
1170.
1171.
1172.
1173.
1174.
1175.
1176.
1177.
1178.
1179.
1180.
1181.
1182.
1183.
1184.
1185.
1186.
1187.
1188.
1189.
1190.
1191.
1192.
1193.
1194.
1195.
1196.
1197.
1198.
1199.
1200.
1201.
1202.
1203.
1204.
1205.
1206.
1207.
1208.
1209.
1210.
1211.
1212.
1213.
1214.
1215.
1216.
1217.
1218.
1219.
1220.
1221.
1222.
1223.
1224.
1225.
1226.
1227.
1228.
1229.
1230.
1231.
1232.
1233.
1234.
1235.
1236.
1237.
1238.
1239.
1240.
1241.
1242.
1243.
1244.
1245.
1246.
1247.
1248.
1249.
1250.
1251.
1252.
1253.
1254.
1255.
1256.
1257.
1258.
1259.
1260.
1261.
1262.
1263.
1264.
1265.
1266.
1267.
1268.
1269.
1270.
1271.
1272.
1273.
1274.
1275.
1276.
1277.
1278.
1279.
1280.
1281.
1282.
1283.
1284.
1285.
1286.
1287.
1288.
1289.
1290.
1291.
1292.
1293.
1294.
1295.
1296.
1297.
1298.
1299.
1300.
1301.
1302.
1303.
1304.
1305.
1306.
1307.
1308.
1309.
1310.
1311.
1312.
1313.
1314.
1315.
1316.
1317.
1318.
1319.
1320.
1321.
1322.
1323.
1324.
1325.
1326.
1327.
1328.
1329.
1330.
1331.
1332.
1333.
1334.
1335.
1336.
1337.
1338.
1339.
1340.
1341.
1342.
1343.
1344.
1345.
1346.
1347.
1348.
1349.
1350.
1351.
1352.
1353.
1354.
1355.
1356.
1357.
1358.
1359.
1360.
1361.
1362.
1363.
1364.
1365.
1366.
1367.
1368.
1369.
1370.
1371.
1372.
1373.
1374.
1375.
1376.
1377.
1378.
1379.
1380.
1381.
1382.
1383.
1384.
1385.
1386.
1387.
1388.
1389.
1390.
1391.
1392.
1393.
1394.
1395.
1396.
1397.
1398.
1399.
1400.
1401.
1402.
1403.
1404.
1405.
1406.
1407.
1408.
1409.
1410.
1411.
1412.
1413.
1414.
1415.
1416.
1417.
1418.
1419.
1420.
1421.
1422.
1423.
1424.
1425.
1426.
1427.
1428.
1429.
1430.
1431.
1432.
1433.
1434.
1435.
1436.
1437.
1438.
1439.
1440.
1441.
1442.
1443.
1444.
1445.
1446.
1447.
1448.
1449.
1450.
1451.
1452.
1453.
1454.
1455.
1456.
1457.
1458.
1459.
1460.
1461.
1462.
1463.
1464.
1465.
1466.
1467.
1468.
1469.
1470.
1471.
1472.
1473.
1474.
1475.
1476.
1477.
1478.
1479.
1480.
1481.
1482.
1483.
1484.
1485.
1486.
1487.
1488.
1489.
1490.
1491.
1492.
1493.
1494.
1495.
1496.
1497.
1498.
1499.
1500.
1501.
1502.
1503.
1504.
1505.
1506.
1507.
1508.
1509.
1510.
1511.
1512.
1513.
1514.
1515.
1516.
1517.
1518.
1519.
1520.
1521.
1522.
1523.
1524.
1525.
1526.
1527.
1528.
1529.
1530.
1531.
1532.
1533.
1534.
1535.
1536.
1537.
1538.
1539.
1540.
1541.
1542.
1543.
1544.
1545.
1546.
1547.
1548.
1549.
1550.
1551.
1552.
1553.
1554.
1555.
1556.
1557.
1558.
1559.
1560.
1561.
1562.
1563.
1564.
1565.
1566.
1567.
1568.
1569.
1570.
1571.
1572.
1573.
1574.
1575.
1576.
1577.
1578.
1579.
1580.
1581.
1582.
1583.
1584.
1585.
1586.
1587.
1588.
1589.
1590.
1591.
1592.
1593.
1594.
1595.
1596.
1597.
1598.
1599.
1600.
1601.
1602.
1603.
1604.
1605.
1606.
1607.
1608.
1609.
1610.
1611.
1612.
1613.
1614.
1615.
1616.
1617.
1618.
1619.
1620.
1621.
1622.
1623.
1624.
1625.
1626.
1627.
1628.
1629.
1630.
1631.
1632.
1633.
1634.
1635.
1636.
1637.
1638.
1639.
1640.
1641.
1642.
1643.
1644.
1645.
1646.
1647.
1648.
1649.
1650.
1651.
1652.
1653.
1654.
1655.
1656.
1657.
1658.
1659.
1660.
1661.
1662.
1663.
1664.
1665.
1666.
1667.
1668.
1669.
1670.
1671.
1672.
1673.
1674.
1675.
1676.
1677.
1678.
1679.
1680.
1681.
1682.
1683.
1684.
1685.
1686.
1687.
1688.
1689.
1690.
1691.
1692.
1693.
1694.
1695.
1696.
1697.
1698.
1699.
1700.
1701.
1702.
1703.
1704.
1705.
1706.
1707.
1708.
1709.
1710.
1711.
1712.
1713.
1714.
1715.
1716.
1717.
1718.
1719.
1720.
1721.
1722.
1723.
1724.
1725.
1726.
1727.
1728.
1729.
1730.
1731.
1732.
1733.
1734.
1735.
1736.
1737.
1738.
1739.
1740.
1741.
1742.
1743.
1744.
1745.
1746.
1747.
1748.
1749.
1750.
1751.
1752.
1753.
1754.
1755.
1756.
1757.
1758.
1759.
1760.
1761.
1762.
1763.
1764.
1765.
1766.
1767.
1768.
1769.
1770.
1771.
1772.
1773.
1774.
1775.
1776.
1777.
1778.
1779.
1780.
1781.
1782.
1783.
1784.
1785.
1786.
1787.
1788.
1789.
1790.
1791.
1792.
1793.
1794.
1795.
1796.
1797.
1798.
1799.
1800.
1801.
1802.
1803.
1804.
1805.
1806.
1807.
1808.
1809.
1810.
1811.
1812.
1813.
1814.
1815.
1816.
1817.
1818.
1819.
1820.
1821.
1822.
1823.
1824.
1825.
1826.
1827.
1828.
1829.
1830.
1831.
1832.
1833.
1834.
1835.
1836.
1837.
1838.
1839.
1840.
1841.
1842.
1843.
1844.
1845.
1846.
1847.
1848.
1849.
1850.
1851.
1852.
1853.
1854.
1855.
1856.
1857.
1858.
1859.
1860.
1861.
1862.
1863.
1864.
1865.
1866.
1867.
1868.
1869.
1870.
1871.
1872.
1873.
1874.
1875.
1876.
1877.
1878.
1879.
1880.
1881.
1882.
1883.
1884.
1885.
1886.
1887.
1888.
1889.
1890.
1891.
1892.
1893.
1894.
1895.
1896.
1897.
1898.
1899.
1900.
1901.
1902.
1903.
1904.
1905.
1906.
1907.
1908.
1909.
1910.
1911.
1912.
1913.
1914.
1915.
1916.
1917.
1918.
1919.
1920.
1921.
1922.
1923.
1924.
1925.
1926.
1927.
1928.
1929.
1930.
1931.
1932.
1933.
1934.
1935.
1936.
1937.
1938.
1939.
1940.
1941.
1942.
1943.
1944.
1945.
1946.
1947.
1948.
1949.
1950.
1951.
1952.
1953.
1954.
1955.
1956.
1957.
1958.
1959.
1960.
1961.
1962.
1963.
1964.
1965.
1966.
1967.
1968.
1969.
1970.
1971.
1972.
1973.
1974.
1975.
1976.
1977.
1978.
1979.
1980.
1981.
1982.
1983.
1984.
1985.
1986.
1987.
1988.
1989.
1990.
1991.
1992.
1993.
1994.
1995.
1996.
1997.
1998.
1999.
2000.
2001.
2002.
2003.
2004.
2005.
2006.
2007.
2008.
2009.
2010.
2011.
2012.
2013.
2014.
2015.
2016.
2017.
2018.
2019.
2020.
2021.
2022.
2023.
2024.
2025.
2026.
2027.
2028.
2029.
2030.
2031.
2032.
2033.
2034.
2035.
2036.
2037.
2038.
2039.
2040.
2041.
2042.
2043.
2044.
2045.
2046.
2047.
2048.
2049.
2050.
2051.
2052.
2053.
2054.
2055.
2056.
2057.
2058.
2059.
2060.
2061.
2062.
2063.
2064.
2065.
2066.
2067.
2068.
2069.
2070.
2071.
2072.
2073.
2074.
2075.
2076.
2077.
2078.
2079.
2080.
2081.
2082.
2083.
2084.
2085.
2086.
2087.
2088.
2089.
2090.
2091.
2092.
2093.
2094.
2095.
2096.
2097.
2098.
2099.
2100.
2101.
2102.
2103.
2104.
2105.
2106.
2107.
2108.
2109.
2110.
2111.
2112.
2113.
2114.
2115.
2116.
2117.
2118.
2119.
2120.
2121.
2122.
2123.
2124.
2125.
2126.
2127.
2128.
2129.
2130.
2131.
2132.
2133.
2134.
2135.
2136.
2137.
2138.
2139.
2140.
2141.
2142.
2143.
2144.
2145.
2146.
2147.
2148.
2149.
2150.
2151.
2152.
2153.
2154.
2155.
2156.
2157.
2158.
2159.
2160.
2161.
2162.
2163.
2164.
2165.
2166.
2167.
2168.
2169.
2170.
2171.
2172.
2173.
2174.
2175.
2176.
2177.
2178.
2179.
2180.
2181.
2182.
2183.
2184.
2185.
2186.
2187.
2188.
2189.
2190.
2191.
2192.
2193.
2194.
2195.
2196.
2197.
2198.
2199.
2200.
2201.
2202.
2203.
2204.
2205.
2206.
2207.
2208.
2209.
2210.
2211.
2212.
2213.
2214.
2215.
2216.
2217.
2218.
2219.
2220.
2221.
2222.
2223.
2224.
2225.
2226.
2227.
2228.
2229.
2230.
2231.
2232.
2233.
2234.
2235.
2236.
2237.
2238.
2239.
2240.
2241.
2242.
2243.
2244.
2245.
2246.
2247.
2248.
2249.
2250.
2251.
2252.
2253.
2254.
2255.
2256.
2257.
2258.
2259.
2260.
2261.
2262.
2263.
2264.
2265.
2266.
2267.
2268.
2269.
2270.
2271.
2272.
2273.
2274.
2275.
2276.
2277.
2278.
2279.
2280.
2281.
2282.
2283.
2284.
2285.
2286.
2287.
2288.
2289.
2290.
2291.
2292.
2293.

***********************************************************************

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

  VERSION INFORMATION:
	TNS for 32-bit Windows: Version 11.2.0.1.0 - Production
	Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 11.2.0.1.0 - Production
  Time: 18-СЕН-2017 01:39:02
  Tracing not turned on.
  Tns error struct:
    ns main err code: 12638
    
TNS-12638: Сбой при извлечении реквизитов
    ns secondary err code: 0
    nt main err code: 0
    nt secondary err code: 0
    nt OS err code: 0
Mon Sep 18 08:43:24 2017
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on. 
IMODE=BR
ILAT =27
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
Using parameter settings in server-side spfile D:\DATABASE\PRODUCT\11.2.0\DBHOME_1\DATABASE\SPFILEDBA1.ORA
System parameters with non-default values:
  processes                = 150
  memory_target            = 1232M
  control_files            = "D:\DATABASE\ORADATA\DBA1\CONTROL01.CTL"
  control_files            = "D:\DATABASE\FLASH_RECOVERY_AREA\DBA1\CONTROL02.CTL"
  db_block_size            = 8192
  compatible               = "11.2.0.0.0"
  db_recovery_file_dest    = "D:\database\flash_recovery_area"
  db_recovery_file_dest_size= 3852M
  undo_tablespace          = "UNDOTBS1"
  remote_login_passwordfile= "EXCLUSIVE"
  db_domain                = ""
  dispatchers              = "(PROTOCOL=TCP) (SERVICE=dba1XDB)"
  audit_file_dest          = "D:\DATABASE\ADMIN\DBA1\ADUMP"
  audit_trail              = "DB"
  db_name                  = "dba1"
  open_cursors             = 300
  diagnostic_dest          = "D:\DATABASE"
Mon Sep 18 08:43:30 2017
PMON started with pid=2, OS id=2836 
Mon Sep 18 08:43:30 2017
VKTM started with pid=3, OS id=2692 at elevated priority
Mon Sep 18 08:43:31 2017
GEN0 started with pid=4, OS id=1984 
VKTM running at (10)millisec precision with DBRM quantum (100)ms
OER 7451 in Load Indicator : Error Code = OSD-04500: задан недопустимый параметр !
Mon Sep 18 08:43:31 2017
DIAG started with pid=5, OS id=2436 
Mon Sep 18 08:43:31 2017
DBRM started with pid=6, OS id=3076 
Mon Sep 18 08:43:31 2017
PSP0 started with pid=7, OS id=3092 
Mon Sep 18 08:43:31 2017
DIA0 started with pid=8, OS id=3096 
Mon Sep 18 08:43:31 2017
MMAN started with pid=9, OS id=3100 
Mon Sep 18 08:43:31 2017
DBW0 started with pid=10, OS id=3104 
Mon Sep 18 08:43:31 2017
LGWR started with pid=11, OS id=3108 
Mon Sep 18 08:43:31 2017
CKPT started with pid=12, OS id=3112 
Mon Sep 18 08:43:31 2017
SMON started with pid=13, OS id=3116 
Mon Sep 18 08:43:31 2017
RECO started with pid=14, OS id=3120 
Mon Sep 18 08:43:31 2017
MMON started with pid=15, OS id=3124 
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Mon Sep 18 08:43:31 2017
MMNL started with pid=16, OS id=3128 
starting up 1 shared server(s) ...
ORACLE_BASE from environment = D:\database
Mon Sep 18 08:43:36 2017
alter database mount exclusive
ORA-214 signalled during: alter database mount exclusive...
Mon Sep 18 09:34:02 2017
Starting ORACLE instance (normal)
Mon Sep 18 09:34:26 2017
Shutting down instance (immediate)
Shutting down instance: further logons disabled
Stopping background process MMNL
Stopping background process MMON
License high water mark = 1
All dispatchers and shared servers shutdown
ALTER DATABASE CLOSE NORMAL
ORA-1507 signalled during: ALTER DATABASE CLOSE NORMAL...
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
Mon Sep 18 09:34:29 2017
Stopping background process VKTM: 
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Mon Sep 18 09:34:31 2017
Instance shutdown complete
Mon Sep 18 09:34:38 2017
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on. 
IMODE=BR
ILAT =27
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
Using parameter settings in server-side spfile D:\DATABASE\PRODUCT\11.2.0\DBHOME_1\DATABASE\SPFILEDBA1.ORA
System parameters with non-default values:
  processes                = 150
  memory_target            = 1232M
  control_files            = "D:\DATABASE\ORADATA\DBA1\CONTROL01.CTL"
  control_files            = "D:\DATABASE\FLASH_RECOVERY_AREA\DBA1\CONTROL02.CTL"
  db_block_size            = 8192
  compatible               = "11.2.0.0.0"
  db_recovery_file_dest    = "D:\database\flash_recovery_area"
  db_recovery_file_dest_size= 3852M
  undo_tablespace          = "UNDOTBS1"
  remote_login_passwordfile= "EXCLUSIVE"
  db_domain                = ""
  dispatchers              = "(PROTOCOL=TCP) (SERVICE=dba1XDB)"
  audit_file_dest          = "D:\DATABASE\ADMIN\DBA1\ADUMP"
  audit_trail              = "DB"
  db_name                  = "dba1"
  open_cursors             = 300
  diagnostic_dest          = "D:\DATABASE"
Mon Sep 18 09:34:38 2017
PMON started with pid=2, OS id=3392 
Mon Sep 18 09:34:38 2017
VKTM started with pid=3, OS id=1380 at elevated priority
Mon Sep 18 09:34:38 2017
GEN0 started with pid=4, OS id=5060 
VKTM running at (10)millisec precision with DBRM quantum (100)ms
OER 7451 in Load Indicator : Error Code = OSD-04500: задан недопустимый параметр !
Mon Sep 18 09:34:38 2017
DIAG started with pid=5, OS id=4140 
Mon Sep 18 09:34:38 2017
DBRM started with pid=6, OS id=5084 
Mon Sep 18 09:34:38 2017
PSP0 started with pid=7, OS id=1936 
Mon Sep 18 09:34:38 2017
DIA0 started with pid=8, OS id=3888 
Mon Sep 18 09:34:38 2017
MMAN started with pid=9, OS id=1624 
Mon Sep 18 09:34:38 2017
DBW0 started with pid=10, OS id=4700 
Mon Sep 18 09:34:38 2017
LGWR started with pid=11, OS id=4616 
Mon Sep 18 09:34:38 2017
CKPT started with pid=12, OS id=844 
Mon Sep 18 09:34:38 2017
SMON started with pid=13, OS id=2492 
Mon Sep 18 09:34:38 2017
RECO started with pid=14, OS id=4120 
Mon Sep 18 09:34:38 2017
MMON started with pid=15, OS id=3328 
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
ORACLE_BASE from environment = D:\database
Mon Sep 18 09:34:38 2017
ALTER DATABASE   MOUNT
ORA-214 signalled during: ALTER DATABASE   MOUNT...
Mon Sep 18 09:34:38 2017
MMNL started with pid=16, OS id=2528 
Mon Sep 18 09:35:27 2017
Starting ORACLE instance (normal)
Mon Sep 18 09:36:14 2017
Shutting down instance (normal)
Shutting down instance: further logons disabled
Stopping background process MMNL
Stopping background process MMON
License high water mark = 2
All dispatchers and shared servers shutdown
ALTER DATABASE CLOSE NORMAL
ORA-1507 signalled during: ALTER DATABASE CLOSE NORMAL...
ARCH: Archival disabled due to shutdown: 1090
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archival disabled due to shutdown: 1090
Mon Sep 18 09:36:22 2017
Stopping background process VKTM: 
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Mon Sep 18 09:36:24 2017
Instance shutdown complete
Mon Sep 18 09:36:43 2017
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on. 
IMODE=BR
ILAT =27
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
Using parameter settings in server-side spfile D:\DATABASE\PRODUCT\11.2.0\DBHOME_1\DATABASE\SPFILEDBA1.ORA
System parameters with non-default values:
  processes                = 150
  memory_target            = 1232M
  control_files            = "D:\DATABASE\ORADATA\DBA1\CONTROL01.CTL"
  control_files            = "D:\DATABASE\FLASH_RECOVERY_AREA\DBA1\CONTROL02.CTL"
  db_block_size            = 8192
  compatible               = "11.2.0.0.0"
  db_recovery_file_dest    = "D:\database\flash_recovery_area"
  db_recovery_file_dest_size= 3852M
  undo_tablespace          = "UNDOTBS1"
  remote_login_passwordfile= "EXCLUSIVE"
  db_domain                = ""
  dispatchers              = "(PROTOCOL=TCP) (SERVICE=dba1XDB)"
  audit_file_dest          = "D:\DATABASE\ADMIN\DBA1\ADUMP"
  audit_trail              = "DB"
  db_name                  = "dba1"
  open_cursors             = 300
  diagnostic_dest          = "D:\DATABASE"
Mon Sep 18 09:36:43 2017
PMON started with pid=2, OS id=4788 
Mon Sep 18 09:36:43 2017
VKTM started with pid=3, OS id=2952 at elevated priority
OER 7451 in Load Indicator : Error Code = OSD-04500: задан недопустимый параметр !
Mon Sep 18 09:36:43 2017
GEN0 started with pid=4, OS id=724 
Mon Sep 18 09:36:43 2017
DIAG started with pid=5, OS id=4368 
VKTM running at (10)millisec precision with DBRM quantum (100)ms
Mon Sep 18 09:36:43 2017
DBRM started with pid=6, OS id=4864 
Mon Sep 18 09:36:43 2017
PSP0 started with pid=7, OS id=4808 
Mon Sep 18 09:36:43 2017
DIA0 started with pid=8, OS id=4376 
Mon Sep 18 09:36:43 2017
MMAN started with pid=9, OS id=3196 
Mon Sep 18 09:36:43 2017
DBW0 started with pid=10, OS id=3200 
Mon Sep 18 09:36:43 2017
LGWR started with pid=11, OS id=340 
Mon Sep 18 09:36:43 2017
CKPT started with pid=12, OS id=4968 
Mon Sep 18 09:36:43 2017
SMON started with pid=13, OS id=1644 
Mon Sep 18 09:36:43 2017
RECO started with pid=14, OS id=320 
Mon Sep 18 09:36:43 2017
MMON started with pid=15, OS id=4456 
Mon Sep 18 09:36:43 2017
MMNL started with pid=16, OS id=4724 
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
ORACLE_BASE from environment = D:\database
Mon Sep 18 09:36:45 2017
ALTER DATABASE   MOUNT
ORA-214 signalled during: ALTER DATABASE   MOUNT...
Mon Sep 18 09:37:20 2017


***********************************************************************

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

  VERSION INFORMATION:
	TNS for 32-bit Windows: Version 11.2.0.1.0 - Production
	Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 11.2.0.1.0 - Production
  Time: 18-СЕН-2017 09:37:20
  Tracing not turned on.
  Tns error struct:
    ns main err code: 12638
    
TNS-12638: Сбой при извлечении реквизитов
    ns secondary err code: 0
    nt main err code: 0
    nt secondary err code: 0
    nt OS err code: 0
Mon Sep 18 09:38:10 2017
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on. 
IMODE=BR
ILAT =27
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
Using parameter settings in server-side spfile D:\DATABASE\PRODUCT\11.2.0\DBHOME_1\DATABASE\SPFILEDBA1.ORA
System parameters with non-default values:
  processes                = 150
  memory_target            = 1232M
  control_files            = "D:\DATABASE\ORADATA\DBA1\CONTROL01.CTL"
  control_files            = "D:\DATABASE\FLASH_RECOVERY_AREA\DBA1\CONTROL02.CTL"
  db_block_size            = 8192
  compatible               = "11.2.0.0.0"
  db_recovery_file_dest    = "D:\database\flash_recovery_area"
  db_recovery_file_dest_size= 3852M
  undo_tablespace          = "UNDOTBS1"
  remote_login_passwordfile= "EXCLUSIVE"
  db_domain                = ""
  dispatchers              = "(PROTOCOL=TCP) (SERVICE=dba1XDB)"
  audit_file_dest          = "D:\DATABASE\ADMIN\DBA1\ADUMP"
  audit_trail              = "DB"
  db_name                  = "dba1"
  open_cursors             = 300
  diagnostic_dest          = "D:\DATABASE"
Mon Sep 18 09:38:20 2017
PMON started with pid=2, OS id=2888 
Mon Sep 18 09:38:20 2017
VKTM started with pid=3, OS id=2892 at elevated priority
Mon Sep 18 09:38:20 2017
GEN0 started with pid=4, OS id=2896 
VKTM running at (10)millisec precision with DBRM quantum (100)ms
OER 7451 in Load Indicator : Error Code = OSD-04500: задан недопустимый параметр !
Mon Sep 18 09:38:20 2017
DIAG started with pid=5, OS id=2900 
Mon Sep 18 09:38:20 2017
DBRM started with pid=6, OS id=2904 
Mon Sep 18 09:38:20 2017
PSP0 started with pid=7, OS id=2908 
Mon Sep 18 09:38:20 2017
DIA0 started with pid=8, OS id=2912 
Mon Sep 18 09:38:20 2017
MMAN started with pid=9, OS id=2916 
Mon Sep 18 09:38:20 2017
DBW0 started with pid=10, OS id=2920 
Mon Sep 18 09:38:20 2017
LGWR started with pid=11, OS id=2924 
Mon Sep 18 09:38:20 2017
CKPT started with pid=12, OS id=2928 
Mon Sep 18 09:38:20 2017
SMON started with pid=13, OS id=2932 
Mon Sep 18 09:38:20 2017
RECO started with pid=14, OS id=2936 
Mon Sep 18 09:38:20 2017
MMON started with pid=15, OS id=2940 
Mon Sep 18 09:38:20 2017
MMNL started with pid=16, OS id=2944 
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
ORACLE_BASE from environment = D:\database
Mon Sep 18 09:38:22 2017
alter database mount exclusive
ORA-214 signalled during: alter database mount exclusive...
Mon Sep 18 09:43:46 2017
Starting ORACLE instance (normal)
Mon Sep 18 09:47:11 2017
Shutting down instance (abort)
License high water mark = 2
USER (ospid: 3856): terminating the instance
Instance terminated by USER, pid = 3856
Mon Sep 18 09:47:16 2017
Instance shutdown complete
Mon Sep 18 09:47:27 2017
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on. 
IMODE=BR
ILAT =27
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
Using parameter settings in server-side spfile D:\DATABASE\PRODUCT\11.2.0\DBHOME_1\DATABASE\SPFILEDBA1.ORA
System parameters with non-default values:
  processes                = 150
  memory_target            = 1232M
  control_files            = "D:\DATABASE\ORADATA\DBA1\CONTROL01.CTL"
  control_files            = "D:\DATABASE\FLASH_RECOVERY_AREA\DBA1\CONTROL02.CTL"
  db_block_size            = 8192
  compatible               = "11.2.0.0.0"
  db_recovery_file_dest    = "D:\database\flash_recovery_area"
  db_recovery_file_dest_size= 3852M
  undo_tablespace          = "UNDOTBS1"
  remote_login_passwordfile= "EXCLUSIVE"
  db_domain                = ""
  dispatchers              = "(PROTOCOL=TCP) (SERVICE=dba1XDB)"
  audit_file_dest          = "D:\DATABASE\ADMIN\DBA1\ADUMP"
  audit_trail              = "DB"
  db_name                  = "dba1"
  open_cursors             = 300
  diagnostic_dest          = "D:\DATABASE"
Mon Sep 18 09:47:28 2017
PMON started with pid=2, OS id=1036 
Mon Sep 18 09:47:28 2017
VKTM started with pid=3, OS id=1044 at elevated priority
VKTM running at (10)millisec precision with DBRM quantum (100)ms
OER 7451 in Load Indicator : Error Code = OSD-04500: задан недопустимый параметр !
Mon Sep 18 09:47:28 2017
DIAG started with pid=5, OS id=4432 
Mon Sep 18 09:47:28 2017
DBRM started with pid=6, OS id=3316 
Mon Sep 18 09:47:28 2017
PSP0 started with pid=7, OS id=2444 
Mon Sep 18 09:47:28 2017
DIA0 started with pid=8, OS id=1348 
Mon Sep 18 09:47:28 2017
MMAN started with pid=9, OS id=4132 
Mon Sep 18 09:47:28 2017
DBW0 started with pid=10, OS id=4200 
Mon Sep 18 09:47:28 2017
LGWR started with pid=11, OS id=3616 
Mon Sep 18 09:47:28 2017
CKPT started with pid=12, OS id=2116 
Mon Sep 18 09:47:28 2017
SMON started with pid=13, OS id=3980 
Mon Sep 18 09:47:28 2017
RECO started with pid=14, OS id=4204 
Mon Sep 18 09:47:28 2017
MMON started with pid=15, OS id=684 
Mon Sep 18 09:47:28 2017
MMNL started with pid=16, OS id=3252 
Mon Sep 18 09:47:28 2017
GEN0 started with pid=4, OS id=3588 
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
ORACLE_BASE from environment = D:\database
Mon Sep 18 09:47:29 2017
ALTER DATABASE   MOUNT
ORA-214 signalled during: ALTER DATABASE   MOUNT...
Mon Sep 18 09:51:02 2017
Starting ORACLE instance (normal)
Mon Sep 18 09:51:51 2017
Starting ORACLE instance (normal)
Mon Sep 18 09:52:14 2017
Shutting down instance (abort)
License high water mark = 2
USER (ospid: 1556): terminating the instance
Instance terminated by USER, pid = 1556
Mon Sep 18 09:52:20 2017
Instance shutdown complete
Mon Sep 18 09:52:22 2017
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on. 
IMODE=BR
ILAT =27
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
Using parameter settings in server-side spfile D:\DATABASE\PRODUCT\11.2.0\DBHOME_1\DATABASE\SPFILEDBA1.ORA
System parameters with non-default values:
  processes                = 150
  memory_target            = 1232M
  control_files            = "D:\DATABASE\ORADATA\DBA1\CONTROL01.CTL"
  control_files            = "D:\DATABASE\FLASH_RECOVERY_AREA\DBA1\CONTROL02.CTL"
  db_block_size            = 8192
  compatible               = "11.2.0.0.0"
  db_recovery_file_dest    = "D:\database\flash_recovery_area"
  db_recovery_file_dest_size= 3852M
  undo_tablespace          = "UNDOTBS1"
  remote_login_passwordfile= "EXCLUSIVE"
  db_domain                = ""
  dispatchers              = "(PROTOCOL=TCP) (SERVICE=dba1XDB)"
  audit_file_dest          = "D:\DATABASE\ADMIN\DBA1\ADUMP"
  audit_trail              = "DB"
  db_name                  = "dba1"
  open_cursors             = 300
  diagnostic_dest          = "D:\DATABASE"
Mon Sep 18 09:52:22 2017
PMON started with pid=2, OS id=4988 
Mon Sep 18 09:52:22 2017
VKTM started with pid=3, OS id=2980 at elevated priority
OER 7451 in Load Indicator : Error Code = OSD-04500: задан недопустимый параметр !
VKTM running at (10)millisec precision with DBRM quantum (100)ms
Mon Sep 18 09:52:22 2017
GEN0 started with pid=4, OS id=1960 
Mon Sep 18 09:52:22 2017
DIAG started with pid=5, OS id=4692 
Mon Sep 18 09:52:22 2017
DBRM started with pid=6, OS id=4720 
Mon Sep 18 09:52:22 2017
PSP0 started with pid=7, OS id=4740 
Mon Sep 18 09:52:22 2017
DIA0 started with pid=8, OS id=4756 
Mon Sep 18 09:52:22 2017
MMAN started with pid=9, OS id=4780 
Mon Sep 18 09:52:22 2017
DBW0 started with pid=10, OS id=4764 
Mon Sep 18 09:52:22 2017
LGWR started with pid=11, OS id=4760 
Mon Sep 18 09:52:22 2017
CKPT started with pid=12, OS id=4820 
Mon Sep 18 09:52:22 2017
SMON started with pid=13, OS id=4804 
Mon Sep 18 09:52:22 2017
RECO started with pid=14, OS id=4776 
Mon Sep 18 09:52:22 2017
MMON started with pid=15, OS id=4772 
Mon Sep 18 09:52:22 2017
MMNL started with pid=16, OS id=4784 
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
ORACLE_BASE from environment = D:\database
Mon Sep 18 09:52:23 2017
ALTER DATABASE   MOUNT
ORA-214 signalled during: ALTER DATABASE   MOUNT...
Mon Sep 18 10:01:01 2017
Shutting down instance (immediate)
Shutting down instance: further logons disabled
Stopping background process MMNL
Stopping background process MMON
License high water mark = 2
All dispatchers and shared servers shutdown
Mon Sep 18 10:01:14 2017
alter database close normal
ORA-1507 signalled during: alter database close normal...
Mon Sep 18 10:01:14 2017
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on. 
IMODE=BR
ILAT =27
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
Using parameter settings in server-side spfile D:\DATABASE\PRODUCT\11.2.0\DBHOME_1\DATABASE\SPFILEDBA1.ORA
System parameters with non-default values:
  processes                = 150
  memory_target            = 1232M
  control_files            = "D:\DATABASE\ORADATA\DBA1\CONTROL01.CTL"
  control_files            = "D:\DATABASE\FLASH_RECOVERY_AREA\DBA1\CONTROL02.CTL"
  db_block_size            = 8192
  compatible               = "11.2.0.0.0"
  db_recovery_file_dest    = "D:\database\flash_recovery_area"
  db_recovery_file_dest_size= 3852M
  undo_tablespace          = "UNDOTBS1"
  remote_login_passwordfile= "EXCLUSIVE"
  db_domain                = ""
  dispatchers              = "(PROTOCOL=TCP) (SERVICE=dba1XDB)"
  audit_file_dest          = "D:\DATABASE\ADMIN\DBA1\ADUMP"
  audit_trail              = "DB"
  db_name                  = "dba1"
  open_cursors             = 300
  diagnostic_dest          = "D:\DATABASE"
Mon Sep 18 10:01:15 2017
PMON started with pid=2, OS id=1908 
OER 7451 in Load Indicator : Error Code = OSD-04500: задан недопустимый параметр !
Mon Sep 18 10:01:15 2017
VKTM started with pid=3, OS id=1428 at elevated priority
VKTM running at (10)millisec precision with DBRM quantum (100)ms
Mon Sep 18 10:01:15 2017
GEN0 started with pid=4, OS id=2892 
Mon Sep 18 10:01:15 2017
DIAG started with pid=5, OS id=1764 
Mon Sep 18 10:01:15 2017
DBRM started with pid=6, OS id=2944 
Mon Sep 18 10:01:15 2017
PSP0 started with pid=7, OS id=4896 
Mon Sep 18 10:01:15 2017
DIA0 started with pid=8, OS id=3012 
Mon Sep 18 10:01:15 2017
MMAN started with pid=9, OS id=4312 
Mon Sep 18 10:01:15 2017
DBW0 started with pid=10, OS id=320 
Mon Sep 18 10:01:15 2017
LGWR started with pid=11, OS id=4252 
Mon Sep 18 10:01:15 2017
CKPT started with pid=12, OS id=4428 
Mon Sep 18 10:01:15 2017
SMON started with pid=13, OS id=4424 
Mon Sep 18 10:01:15 2017
RECO started with pid=14, OS id=2912 
Mon Sep 18 10:01:15 2017
MMON started with pid=15, OS id=1916 
Mon Sep 18 10:01:15 2017
MMNL started with pid=16, OS id=2996 
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
ORACLE_BASE from environment = D:\database
Mon Sep 18 10:01:15 2017
alter database mount exclusive
ORA-214 signalled during: alter database mount exclusive...
Mon Sep 18 10:03:32 2017
Starting ORACLE instance (normal)
Mon Sep 18 10:04:47 2017
Shutting down instance (abort)
License high water mark = 2
USER (ospid: 4500): terminating the instance
Instance terminated by USER, pid = 4500
Mon Sep 18 10:04:53 2017
Instance shutdown complete
Mon Sep 18 10:05:15 2017
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on. 
IMODE=BR
ILAT =27
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
Using parameter settings in server-side spfile D:\DATABASE\PRODUCT\11.2.0\DBHOME_1\DATABASE\SPFILEDBA1.ORA
System parameters with non-default values:
  processes                = 150
  memory_target            = 1232M
  control_files            = "D:\DATABASE\ORADATA\DBA1\CONTROL01.CTL"
  control_files            = "D:\DATABASE\FLASH_RECOVERY_AREA\DBA1\CONTROL02.CTL"
  db_block_size            = 8192
  compatible               = "11.2.0.0.0"
  db_recovery_file_dest    = "D:\database\flash_recovery_area"
  db_recovery_file_dest_size= 3852M
  undo_tablespace          = "UNDOTBS1"
  remote_login_passwordfile= "EXCLUSIVE"
  db_domain                = ""
  dispatchers              = "(PROTOCOL=TCP) (SERVICE=dba1XDB)"
  audit_file_dest          = "D:\DATABASE\ADMIN\DBA1\ADUMP"
  audit_trail              = "DB"
  db_name                  = "dba1"
  open_cursors             = 300
  diagnostic_dest          = "D:\DATABASE"
Mon Sep 18 10:05:15 2017
PMON started with pid=2, OS id=708 
OER 7451 in Load Indicator : Error Code = OSD-04500: задан недопустимый параметр !
Mon Sep 18 10:05:15 2017
GEN0 started with pid=4, OS id=412 
Mon Sep 18 10:05:15 2017
DIAG started with pid=5, OS id=3120 
Mon Sep 18 10:05:15 2017
DBRM started with pid=6, OS id=1776 
Mon Sep 18 10:05:15 2017
PSP0 started with pid=7, OS id=4580 
Mon Sep 18 10:05:15 2017
DIA0 started with pid=8, OS id=204 
Mon Sep 18 10:05:15 2017
MMAN started with pid=9, OS id=1032 
Mon Sep 18 10:05:15 2017
DBW0 started with pid=10, OS id=2928 
Mon Sep 18 10:05:15 2017
LGWR started with pid=11, OS id=5052 
Mon Sep 18 10:05:15 2017
CKPT started with pid=12, OS id=2280 
Mon Sep 18 10:05:15 2017
SMON started with pid=13, OS id=2356 
Mon Sep 18 10:05:15 2017
RECO started with pid=14, OS id=3616 
Mon Sep 18 10:05:15 2017
MMON started with pid=15, OS id=4680 
Mon Sep 18 10:05:16 2017
MMNL started with pid=16, OS id=1580 
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
ORACLE_BASE from environment = D:\database
Mon Sep 18 10:05:16 2017
ALTER DATABASE   MOUNT
ORA-214 signalled during: ALTER DATABASE   MOUNT...
Mon Sep 18 10:05:15 2017
VKTM started with pid=3, OS id=2896 at elevated priority
VKTM running at (10)millisec precision with DBRM quantum (100)ms
Mon Sep 18 10:43:38 2017
alter database mount
ORA-214 signalled during: alter database mount...
Mon Sep 18 10:53:31 2017


***********************************************************************

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

  VERSION INFORMATION:
	TNS for 32-bit Windows: Version 11.2.0.1.0 - Production
	Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 11.2.0.1.0 - Production
  Time: 18-СЕН-2017 10:53:31
  Tracing not turned on.
  Tns error struct:
    ns main err code: 12638
    
TNS-12638: Сбой при извлечении реквизитов
    ns secondary err code: 0
    nt main err code: 0
    nt secondary err code: 0
    nt OS err code: 0
Mon Sep 18 10:56:24 2017
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on. 
IMODE=BR
ILAT =27
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
Using parameter settings in server-side spfile D:\DATABASE\PRODUCT\11.2.0\DBHOME_1\DATABASE\SPFILEDBA1.ORA
System parameters with non-default values:
  processes                = 150
  memory_target            = 1232M
  control_files            = "D:\DATABASE\ORADATA\DBA1\CONTROL01.CTL"
  control_files            = "D:\DATABASE\FLASH_RECOVERY_AREA\DBA1\CONTROL02.CTL"
  db_block_size            = 8192
  compatible               = "11.2.0.0.0"
  db_recovery_file_dest    = "D:\database\flash_recovery_area"
  db_recovery_file_dest_size= 3852M
  undo_tablespace          = "UNDOTBS1"
  remote_login_passwordfile= "EXCLUSIVE"
  db_domain                = ""
  dispatchers              = "(PROTOCOL=TCP) (SERVICE=dba1XDB)"
  audit_file_dest          = "D:\DATABASE\ADMIN\DBA1\ADUMP"
  audit_trail              = "DB"
  db_name                  = "dba1"
  open_cursors             = 300
  diagnostic_dest          = "D:\DATABASE"
Mon Sep 18 10:56:34 2017
PMON started with pid=2, OS id=3168 
Mon Sep 18 10:56:34 2017
VKTM started with pid=3, OS id=3172 at elevated priority
VKTM running at (10)millisec precision with DBRM quantum (100)ms
Mon Sep 18 10:56:35 2017
GEN0 started with pid=4, OS id=3176 
OER 7451 in Load Indicator : Error Code = OSD-04500: задан недопустимый параметр !
Mon Sep 18 10:56:35 2017
DIAG started with pid=5, OS id=3180 
Mon Sep 18 10:56:35 2017
DBRM started with pid=6, OS id=3184 
Mon Sep 18 10:56:35 2017
PSP0 started with pid=7, OS id=3188 
Mon Sep 18 10:56:35 2017
DIA0 started with pid=8, OS id=3192 
Mon Sep 18 10:56:35 2017
MMAN started with pid=9, OS id=3196 
Mon Sep 18 10:56:35 2017
DBW0 started with pid=10, OS id=3200 
Mon Sep 18 10:56:35 2017
LGWR started with pid=11, OS id=3204 
Mon Sep 18 10:56:35 2017
CKPT started with pid=12, OS id=3208 
Mon Sep 18 10:56:35 2017
SMON started with pid=13, OS id=3212 
Mon Sep 18 10:56:35 2017
RECO started with pid=14, OS id=3216 
Mon Sep 18 10:56:35 2017
MMON started with pid=15, OS id=3220 
Mon Sep 18 10:56:35 2017
MMNL started with pid=16, OS id=3224 
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
ORACLE_BASE from environment = D:\database
Mon Sep 18 10:56:37 2017
alter database mount exclusive
ORA-214 signalled during: alter database mount exclusive...
Mon Sep 18 11:00:47 2017
Shutting down instance (abort)
License high water mark = 1
USER (ospid: 4612): terminating the instance
Instance terminated by USER, pid = 4612
Mon Sep 18 11:00:52 2017
Instance shutdown complete
Mon Sep 18 11:01:22 2017
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on. 
IMODE=BR
ILAT =27
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
Using parameter settings in server-side spfile D:\DATABASE\PRODUCT\11.2.0\DBHOME_1\DATABASE\SPFILEDBA1.ORA
System parameters with non-default values:
  processes                = 150
  memory_target            = 1232M
  control_files            = "D:\DATABASE\ORADATA\DBA1\CONTROL01.CTL"
  control_files            = "D:\DATABASE\FLASH_RECOVERY_AREA\DBA1\CONTROL02.CTL"
  db_block_size            = 8192
  compatible               = "11.2.0.0.0"
  db_recovery_file_dest    = "D:\database\flash_recovery_area"
  db_recovery_file_dest_size= 3852M
  undo_tablespace          = "UNDOTBS1"
  remote_login_passwordfile= "EXCLUSIVE"
  db_domain                = ""
  dispatchers              = "(PROTOCOL=TCP) (SERVICE=dba1XDB)"
  audit_file_dest          = "D:\DATABASE\ADMIN\DBA1\ADUMP"
  audit_trail              = "DB"
  db_name                  = "dba1"
  open_cursors             = 300
  diagnostic_dest          = "D:\DATABASE"
Mon Sep 18 11:01:23 2017
PMON started with pid=2, OS id=4828 
Mon Sep 18 11:01:23 2017
VKTM started with pid=3, OS id=5036 at elevated priority
OER 7451 in Load Indicator : Error Code = OSD-04500: задан недопустимый параметр !
VKTM running at (10)millisec precision with DBRM quantum (100)ms
Mon Sep 18 11:01:23 2017
GEN0 started with pid=4, OS id=4748 
Mon Sep 18 11:01:23 2017
DIAG started with pid=5, OS id=4840 
Mon Sep 18 11:01:23 2017
DBRM started with pid=6, OS id=4844 
Mon Sep 18 11:01:23 2017
PSP0 started with pid=7, OS id=4832 
Mon Sep 18 11:01:23 2017
DIA0 started with pid=8, OS id=1468 
Mon Sep 18 11:01:23 2017
MMAN started with pid=9, OS id=4688 
Mon Sep 18 11:01:23 2017
DBW0 started with pid=10, OS id=4684 
Mon Sep 18 11:01:23 2017
LGWR started with pid=11, OS id=5060 
Mon Sep 18 11:01:23 2017
CKPT started with pid=12, OS id=4924 
Mon Sep 18 11:01:23 2017
SMON started with pid=13, OS id=5080 
Mon Sep 18 11:01:23 2017
RECO started with pid=14, OS id=4680 
Mon Sep 18 11:01:23 2017
MMON started with pid=15, OS id=4948 
Mon Sep 18 11:01:23 2017
MMNL started with pid=16, OS id=4952 
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
ORACLE_BASE from environment = D:\database
Mon Sep 18 11:01:24 2017
ALTER DATABASE   MOUNT
ORA-214 signalled during: ALTER DATABASE   MOUNT...
Mon Sep 18 11:23:35 2017
alter database open resetlogs
ORA-1507 signalled during: alter database open resetlogs...
Mon Sep 18 11:38:47 2017
ALTER SYSTEM SET control_files='d:\database\oradata\dba1\control01.ctl' SCOPE=SPFILE;
Mon Sep 18 11:39:14 2017
Shutting down instance (immediate)
Shutting down instance: further logons disabled
Stopping background process MMNL
Stopping background process MMON
License high water mark = 2
All dispatchers and shared servers shutdown
ALTER DATABASE CLOSE NORMAL
ORA-1507 signalled during: ALTER DATABASE CLOSE NORMAL...
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
Mon Sep 18 11:39:16 2017
Stopping background process VKTM: 
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Mon Sep 18 11:39:18 2017
Instance shutdown complete
Mon Sep 18 11:39:33 2017
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on. 
IMODE=BR
ILAT =27
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
Using parameter settings in server-side spfile D:\DATABASE\PRODUCT\11.2.0\DBHOME_1\DATABASE\SPFILEDBA1.ORA
System parameters with non-default values:
  processes                = 150
  memory_target            = 1232M
  control_files            = "D:\DATABASE\ORADATA\DBA1\CONTROL01.CTL"
  db_block_size            = 8192
  compatible               = "11.2.0.0.0"
  db_recovery_file_dest    = "D:\database\flash_recovery_area"
  db_recovery_file_dest_size= 3852M
  undo_tablespace          = "UNDOTBS1"
  remote_login_passwordfile= "EXCLUSIVE"
  db_domain                = ""
  dispatchers              = "(PROTOCOL=TCP) (SERVICE=dba1XDB)"
  audit_file_dest          = "D:\DATABASE\ADMIN\DBA1\ADUMP"
  audit_trail              = "DB"
  db_name                  = "dba1"
  open_cursors             = 300
  diagnostic_dest          = "D:\DATABASE"
Mon Sep 18 11:39:34 2017
PMON started with pid=2, OS id=1884 
Mon Sep 18 11:39:34 2017
VKTM started with pid=3, OS id=4892 at elevated priority
VKTM running at (10)millisec precision with DBRM quantum (100)ms
Mon Sep 18 11:39:34 2017
GEN0 started with pid=4, OS id=792 
Mon Sep 18 11:39:34 2017
DIAG started with pid=5, OS id=4632 
Mon Sep 18 11:39:34 2017
DBRM started with pid=6, OS id=4664 
Mon Sep 18 11:39:34 2017
PSP0 started with pid=7, OS id=4920 
Mon Sep 18 11:39:34 2017
DIA0 started with pid=8, OS id=3020 
Mon Sep 18 11:39:34 2017
MMAN started with pid=9, OS id=4404 
Mon Sep 18 11:39:34 2017
DBW0 started with pid=10, OS id=2952 
Mon Sep 18 11:39:34 2017
LGWR started with pid=11, OS id=2376 
Mon Sep 18 11:39:34 2017
CKPT started with pid=12, OS id=2172 
Mon Sep 18 11:39:34 2017
SMON started with pid=13, OS id=4608 
Mon Sep 18 11:39:34 2017
RECO started with pid=14, OS id=3676 
Mon Sep 18 11:39:34 2017
MMON started with pid=15, OS id=4392 
Mon Sep 18 11:39:34 2017
MMNL started with pid=16, OS id=4712 
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
ORACLE_BASE from environment = D:\database
Mon Sep 18 11:39:34 2017
ALTER DATABASE   MOUNT
OER 7451 in Load Indicator : Error Code = OSD-04500: задан недопустимый параметр !
Successful mount of redo thread 1, with mount id 2265417398
Database mounted in Exclusive Mode
Lost write protection disabled
Completed: ALTER DATABASE   MOUNT
Mon Sep 18 11:40:35 2017
alter database open
Beginning crash recovery of 1 threads
 parallel recovery started with 2 processes
Started redo scan
Errors in file d:\database\diag\rdbms\dba1\dba1\trace\dba1_ora_1908.trc:
ORA-00322: протокол 2 процесса 1 не является текущей копией
ORA-00312: оперативный протокол 2 процесса 1: 'D:\DATABASE\ORADATA\DBA1\REDO02.LOG'
Mon Sep 18 11:40:36 2017
Errors in file d:\database\diag\rdbms\dba1\dba1\trace\dba1_m000_4772.trc:
ORA-00322: log 1 of thread 1 is not current copy
ORA-00312: online log 1 thread 1: 'D:\DATABASE\ORADATA\DBA1\REDO01.LOG'
Aborting crash recovery due to error 322
Errors in file d:\database\diag\rdbms\dba1\dba1\trace\dba1_ora_1908.trc:
ORA-00322: протокол 2 процесса 1 не является текущей копией
ORA-00312: оперативный протокол 2 процесса 1: 'D:\DATABASE\ORADATA\DBA1\REDO02.LOG'
Errors in file d:\database\diag\rdbms\dba1\dba1\trace\dba1_ora_1908.trc:
ORA-00322: протокол 2 процесса 1 не является текущей копией
ORA-00312: оперативный протокол 2 процесса 1: 'D:\DATABASE\ORADATA\DBA1\REDO02.LOG'
ORA-322 signalled during: alter database open...
Errors in file d:\database\diag\rdbms\dba1\dba1\trace\dba1_m000_4772.trc:
ORA-00322: log 2 of thread 1 is not current copy
ORA-00312: online log 2 thread 1: 'D:\DATABASE\ORADATA\DBA1\REDO02.LOG'
Checker run found 4 new persistent data failures
Mon Sep 18 11:46:05 2017
Starting ORACLE instance (normal)
Mon Sep 18 11:52:28 2017
Starting ORACLE instance (normal)
Mon Sep 18 11:52:37 2017
Starting ORACLE instance (normal)
Mon Sep 18 11:52:48 2017
Starting ORACLE instance (normal)
Mon Sep 18 11:53:18 2017
Shutting down instance (immediate)
Shutting down instance: further logons disabled
Stopping background process MMNL
Stopping background process MMON
License high water mark = 3
All dispatchers and shared servers shutdown
ALTER DATABASE CLOSE NORMAL
ORA-1109 signalled during: ALTER DATABASE CLOSE NORMAL...
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
Mon Sep 18 11:53:26 2017
Stopping background process VKTM: 
Mon Sep 18 11:53:28 2017
Instance shutdown complete
Mon Sep 18 11:53:36 2017
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on. 
IMODE=BR
ILAT =27
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
Using parameter settings in server-side spfile D:\DATABASE\PRODUCT\11.2.0\DBHOME_1\DATABASE\SPFILEDBA1.ORA
System parameters with non-default values:
  processes                = 150
  memory_target            = 1232M
  control_files            = "D:\DATABASE\ORADATA\DBA1\CONTROL01.CTL"
  db_block_size            = 8192
  compatible               = "11.2.0.0.0"
  db_recovery_file_dest    = "D:\database\flash_recovery_area"
  db_recovery_file_dest_size= 3852M
  undo_tablespace          = "UNDOTBS1"
  remote_login_passwordfile= "EXCLUSIVE"
  db_domain                = ""
  dispatchers              = "(PROTOCOL=TCP) (SERVICE=dba1XDB)"
  audit_file_dest          = "D:\DATABASE\ADMIN\DBA1\ADUMP"
  audit_trail              = "DB"
  db_name                  = "dba1"
  open_cursors             = 300
  diagnostic_dest          = "D:\DATABASE"
Mon Sep 18 11:53:36 2017
PMON started with pid=2, OS id=816 
OER 7451 in Load Indicator : Error Code = OSD-04500: задан недопустимый параметр !
Mon Sep 18 11:53:36 2017
GEN0 started with pid=4, OS id=3184 
Mon Sep 18 11:53:36 2017
DIAG started with pid=5, OS id=3908 
Mon Sep 18 11:53:36 2017
DBRM started with pid=6, OS id=5012 
Mon Sep 18 11:53:36 2017
PSP0 started with pid=7, OS id=3564 
Mon Sep 18 11:53:36 2017
DIA0 started with pid=8, OS id=3172 
Mon Sep 18 11:53:36 2017
MMAN started with pid=9, OS id=4556 
Mon Sep 18 11:53:36 2017
DBW0 started with pid=10, OS id=4452 
Mon Sep 18 11:53:36 2017
LGWR started with pid=11, OS id=4988 
Mon Sep 18 11:53:36 2017
CKPT started with pid=12, OS id=368 
Mon Sep 18 11:53:36 2017
SMON started with pid=13, OS id=2896 
Mon Sep 18 11:53:36 2017
RECO started with pid=14, OS id=4072 
Mon Sep 18 11:53:36 2017
MMON started with pid=15, OS id=3252 
Mon Sep 18 11:53:36 2017
MMNL started with pid=16, OS id=4872 
Mon Sep 18 11:53:36 2017
VKTM started with pid=3, OS id=812 at elevated priority
VKTM running at (10)millisec precision with DBRM quantum (100)ms
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
ORACLE_BASE from environment = D:\database
Mon Sep 18 11:53:37 2017
ALTER DATABASE   MOUNT
Successful mount of redo thread 1, with mount id 2265442305
Database mounted in Exclusive Mode
Lost write protection disabled
Completed: ALTER DATABASE   MOUNT
Mon Sep 18 11:58:08 2017
Shutting down instance (abort)
License high water mark = 2
USER (ospid: 4928): terminating the instance
Instance terminated by USER, pid = 4928
Mon Sep 18 11:58:09 2017
Instance shutdown complete
Mon Sep 18 11:58:25 2017
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on. 
IMODE=BR
ILAT =27
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
Using parameter settings in server-side spfile D:\DATABASE\PRODUCT\11.2.0\DBHOME_1\DATABASE\SPFILEDBA1.ORA
System parameters with non-default values:
  processes                = 150
  memory_target            = 1232M
  control_files            = "D:\DATABASE\ORADATA\DBA1\CONTROL01.CTL"
  db_block_size            = 8192
  compatible               = "11.2.0.0.0"
  db_recovery_file_dest    = "D:\database\flash_recovery_area"
  db_recovery_file_dest_size= 3852M
  undo_tablespace          = "UNDOTBS1"
  remote_login_passwordfile= "EXCLUSIVE"
  db_domain                = ""
  dispatchers              = "(PROTOCOL=TCP) (SERVICE=dba1XDB)"
  audit_file_dest          = "D:\DATABASE\ADMIN\DBA1\ADUMP"
  audit_trail              = "DB"
  db_name                  = "dba1"
  open_cursors             = 300
  diagnostic_dest          = "D:\DATABASE"
Mon Sep 18 11:58:25 2017
PMON started with pid=2, OS id=4372 
OER 7451 in Load Indicator : Error Code = OSD-04500: задан недопустимый параметр !
Mon Sep 18 11:58:25 2017
GEN0 started with pid=4, OS id=2168 
Mon Sep 18 11:58:25 2017
DIAG started with pid=5, OS id=3976 
Mon Sep 18 11:58:25 2017
DBRM started with pid=6, OS id=5088 
Mon Sep 18 11:58:25 2017
PSP0 started with pid=7, OS id=2856 
Mon Sep 18 11:58:25 2017
DIA0 started with pid=8, OS id=2692 
Mon Sep 18 11:58:25 2017
MMAN started with pid=9, OS id=4048 
Mon Sep 18 11:58:25 2017
DBW0 started with pid=10, OS id=3604 
Mon Sep 18 11:58:25 2017
LGWR started with pid=11, OS id=392 
Mon Sep 18 11:58:25 2017
CKPT started with pid=12, OS id=3176 
Mon Sep 18 11:58:25 2017
SMON started with pid=13, OS id=980 
Mon Sep 18 11:58:25 2017
RECO started with pid=14, OS id=3332 
Mon Sep 18 11:58:25 2017
MMON started with pid=15, OS id=3556 
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
ORACLE_BASE from environment = D:\database
Mon Sep 18 11:58:25 2017
ALTER DATABASE   MOUNT
Mon Sep 18 11:58:25 2017
VKTM started with pid=3, OS id=4684 at elevated priority
VKTM running at (10)millisec precision with DBRM quantum (100)ms
Mon Sep 18 11:58:25 2017
MMNL started with pid=16, OS id=440 
Successful mount of redo thread 1, with mount id 2265418017
Database mounted in Exclusive Mode
Lost write protection disabled
Completed: ALTER DATABASE   MOUNT
Mon Sep 18 11:59:05 2017
alter database open resetlogs
ORA-1139 signalled during: alter database open resetlogs...
Mon Sep 18 12:04:29 2017
ALTER DATABASE RECOVER  database until cancel  
Media Recovery Start
 started logmerger process
Parallel Media Recovery started with 2 slaves
ORA-279 signalled during: ALTER DATABASE RECOVER  database until cancel  ...
Mon Sep 18 12:04:57 2017
ALTER DATABASE RECOVER    LOGFILE 'alter'  
Media Recovery Log alter
Mon Sep 18 12:04:57 2017
Errors with log alter
Errors in file d:\database\diag\rdbms\dba1\dba1\trace\dba1_pr00_5080.trc:
ORA-00308: cannot open archived log 'alter'
ORA-27041: unable to open file
OSD-04002: невозможно открыть файл
O/S-Error: (OS 2) Не удается найти указанный файл.
ORA-308 signalled during: ALTER DATABASE RECOVER    LOGFILE 'alter'  ...
Mon Sep 18 12:05:26 2017
ALTER DATABASE RECOVER    CONTINUE DEFAULT  
Media Recovery Log D:\DATABASE\FLASH_RECOVERY_AREA\DBA1\ARCHIVELOG\2017_09_18\O1_MF_1_1667_%U_.ARC
Mon Sep 18 12:05:26 2017
Errors with log D:\DATABASE\FLASH_RECOVERY_AREA\DBA1\ARCHIVELOG\2017_09_18\O1_MF_1_1667_%U_.ARC
Errors in file d:\database\diag\rdbms\dba1\dba1\trace\dba1_pr00_5080.trc:
ORA-00308: cannot open archived log 'D:\DATABASE\FLASH_RECOVERY_AREA\DBA1\ARCHIVELOG\2017_09_18\O1_MF_1_1667_%U_.ARC'
ORA-27041: unable to open file
OSD-04002: невозможно открыть файл
O/S-Error: (OS 2) Не удается найти указанный файл.
ORA-308 signalled during: ALTER DATABASE RECOVER    CONTINUE DEFAULT  ...
ALTER DATABASE RECOVER    CONTINUE DEFAULT  
Media Recovery Log D:\DATABASE\FLASH_RECOVERY_AREA\DBA1\ARCHIVELOG\2017_09_18\O1_MF_1_1667_%U_.ARC
Errors with log D:\DATABASE\FLASH_RECOVERY_AREA\DBA1\ARCHIVELOG\2017_09_18\O1_MF_1_1667_%U_.ARC
Errors in file d:\database\diag\rdbms\dba1\dba1\trace\dba1_pr00_5080.trc:
ORA-00308: cannot open archived log 'D:\DATABASE\FLASH_RECOVERY_AREA\DBA1\ARCHIVELOG\2017_09_18\O1_MF_1_1667_%U_.ARC'
ORA-27041: unable to open file
OSD-04002: невозможно открыть файл
O/S-Error: (OS 2) Не удается найти указанный файл.
ORA-308 signalled during: ALTER DATABASE RECOVER    CONTINUE DEFAULT  ...
ALTER DATABASE RECOVER CANCEL 
Mon Sep 18 12:05:28 2017
Errors in file d:\database\diag\rdbms\dba1\dba1\trace\dba1_m000_564.trc:
ORA-00322: log 1 of thread 1 is not current copy
ORA-00312: online log 1 thread 1: 'D:\DATABASE\ORADATA\DBA1\REDO01.LOG'
Errors in file d:\database\diag\rdbms\dba1\dba1\trace\dba1_pr00_5080.trc:
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: 'D:\DATABASE\ORADATA\DBA1\SYSTEM01.DBF'
ORA-10879 signalled during: ALTER DATABASE RECOVER CANCEL ...
Errors in file d:\database\diag\rdbms\dba1\dba1\trace\dba1_m000_564.trc:
ORA-00322: log 2 of thread 1 is not current copy
ORA-00312: online log 2 thread 1: 'D:\DATABASE\ORADATA\DBA1\REDO02.LOG'
Checker run found 10 new persistent data failures
Mon Sep 18 12:06:26 2017
Shutting down instance (abort)
License high water mark = 4
USER (ospid: 2788): terminating the instance
Instance terminated by USER, pid = 2788
Mon Sep 18 12:06:31 2017
Instance shutdown complete
Mon Sep 18 12:07:03 2017
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on. 
IMODE=BR
ILAT =27
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
Using parameter settings in server-side spfile D:\DATABASE\PRODUCT\11.2.0\DBHOME_1\DATABASE\SPFILEDBA1.ORA
System parameters with non-default values:
  processes                = 150
  memory_target            = 1232M
  control_files            = "D:\DATABASE\ORADATA\DBA1\CONTROL01.CTL"
  db_block_size            = 8192
  compatible               = "11.2.0.0.0"
  db_recovery_file_dest    = "D:\database\flash_recovery_area"
  db_recovery_file_dest_size= 3852M
  undo_tablespace          = "UNDOTBS1"
  remote_login_passwordfile= "EXCLUSIVE"
  db_domain                = ""
  dispatchers              = "(PROTOCOL=TCP) (SERVICE=dba1XDB)"
  audit_file_dest          = "D:\DATABASE\ADMIN\DBA1\ADUMP"
  audit_trail              = "DB"
  db_name                  = "dba1"
  open_cursors             = 300
  diagnostic_dest          = "D:\DATABASE"
Mon Sep 18 12:07:03 2017
PMON started with pid=2, OS id=4996 
OER 7451 in Load Indicator : Error Code = OSD-04500: задан недопустимый параметр !
Mon Sep 18 12:07:03 2017
VKTM started with pid=3, OS id=3228 at elevated priority
VKTM running at (10)millisec precision with DBRM quantum (100)ms
Mon Sep 18 12:07:03 2017
GEN0 started with pid=4, OS id=3608 
Mon Sep 18 12:07:03 2017
DIAG started with pid=5, OS id=2112 
Mon Sep 18 12:07:03 2017
DBRM started with pid=6, OS id=5044 
Mon Sep 18 12:07:03 2017
PSP0 started with pid=7, OS id=5008 
Mon Sep 18 12:07:03 2017
DIA0 started with pid=8, OS id=1484 
Mon Sep 18 12:07:03 2017
MMAN started with pid=9, OS id=5064 
Mon Sep 18 12:07:03 2017
DBW0 started with pid=10, OS id=3344 
Mon Sep 18 12:07:03 2017
LGWR started with pid=11, OS id=3192 
Mon Sep 18 12:07:03 2017
CKPT started with pid=12, OS id=3404 
Mon Sep 18 12:07:03 2017
SMON started with pid=13, OS id=3728 
Mon Sep 18 12:07:03 2017
RECO started with pid=14, OS id=3216 
Mon Sep 18 12:07:03 2017
MMON started with pid=15, OS id=3140 
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Mon Sep 18 12:07:03 2017
MMNL started with pid=16, OS id=400 
starting up 1 shared server(s) ...
ORACLE_BASE from environment = D:\database
Mon Sep 18 12:07:03 2017
ALTER DATABASE   MOUNT
Successful mount of redo thread 1, with mount id 2265453607
Database mounted in Exclusive Mode
Lost write protection disabled
Completed: ALTER DATABASE   MOUNT
Mon Sep 18 12:07:25 2017
alter database open resetlogs
ORA-1194 signalled during: alter database open resetlogs...
Mon Sep 18 12:07:25 2017
Errors in file d:\database\diag\rdbms\dba1\dba1\trace\dba1_m000_3800.trc:
ORA-00322: log 1 of thread 1 is not current copy
ORA-00312: online log 1 thread 1: 'D:\DATABASE\ORADATA\DBA1\REDO01.LOG'
Errors in file d:\database\diag\rdbms\dba1\dba1\trace\dba1_m000_3800.trc:
ORA-00322: log 2 of thread 1 is not current copy
ORA-00312: online log 2 thread 1: 'D:\DATABASE\ORADATA\DBA1\REDO02.LOG'
Mon Sep 18 12:13:26 2017
alter database open resetlogs
ORA-1194 signalled during: alter database open resetlogs...
Mon Sep 18 12:13:27 2017
Errors in file d:\database\diag\rdbms\dba1\dba1\trace\dba1_m000_1172.trc:
ORA-00322: log 1 of thread 1 is not current copy
ORA-00312: online log 1 thread 1: 'D:\DATABASE\ORADATA\DBA1\REDO01.LOG'
Errors in file d:\database\diag\rdbms\dba1\dba1\trace\dba1_m000_1172.trc:
ORA-00322: log 2 of thread 1 is not current copy
ORA-00312: online log 2 thread 1: 'D:\DATABASE\ORADATA\DBA1\REDO02.LOG'
Mon Sep 18 12:23:50 2017
db_recovery_file_dest_size of 3852 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.
Mon Sep 18 12:31:42 2017


***********************************************************************

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

  VERSION INFORMATION:
	TNS for 32-bit Windows: Version 11.2.0.1.0 - Production
	Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 11.2.0.1.0 - Production
  Time: 18-СЕН-2017 12:31:44
  Tracing not turned on.
  Tns error struct:
    ns main err code: 12638
    
TNS-12638: Сбой при извлечении реквизитов
    ns secondary err code: 0
    nt main err code: 0
    nt secondary err code: 0
    nt OS err code: 0
Mon Sep 18 12:32:29 2017
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on. 
IMODE=BR
ILAT =27
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
Using parameter settings in server-side spfile D:\DATABASE\PRODUCT\11.2.0\DBHOME_1\DATABASE\SPFILEDBA1.ORA
System parameters with non-default values:
  processes                = 150
  memory_target            = 1232M
  control_files            = "D:\DATABASE\ORADATA\DBA1\CONTROL01.CTL"
  db_block_size            = 8192
  compatible               = "11.2.0.0.0"
  db_recovery_file_dest    = "D:\database\flash_recovery_area"
  db_recovery_file_dest_size= 3852M
  undo_tablespace          = "UNDOTBS1"
  remote_login_passwordfile= "EXCLUSIVE"
  db_domain                = ""
  dispatchers              = "(PROTOCOL=TCP) (SERVICE=dba1XDB)"
  audit_file_dest          = "D:\DATABASE\ADMIN\DBA1\ADUMP"
  audit_trail              = "DB"
  db_name                  = "dba1"
  open_cursors             = 300
  diagnostic_dest          = "D:\DATABASE"
Mon Sep 18 12:32:34 2017
PMON started with pid=2, OS id=2168 
Mon Sep 18 12:32:34 2017
VKTM started with pid=3, OS id=2172 at elevated priority
VKTM running at (10)millisec precision with DBRM quantum (100)ms
Mon Sep 18 12:32:34 2017
GEN0 started with pid=4, OS id=2176 
OER 7451 in Load Indicator : Error Code = OSD-04500: задан недопустимый параметр !
Mon Sep 18 12:32:34 2017
DIAG started with pid=5, OS id=2180 
Mon Sep 18 12:32:34 2017
DBRM started with pid=6, OS id=2184 
Mon Sep 18 12:32:34 2017
PSP0 started with pid=7, OS id=2188 
Mon Sep 18 12:32:34 2017
DIA0 started with pid=8, OS id=2192 
Mon Sep 18 12:32:34 2017
MMAN started with pid=9, OS id=2196 
Mon Sep 18 12:32:34 2017
DBW0 started with pid=10, OS id=2200 
Mon Sep 18 12:32:34 2017
LGWR started with pid=11, OS id=2204 
Mon Sep 18 12:32:34 2017
CKPT started with pid=12, OS id=2208 
Mon Sep 18 12:32:34 2017
SMON started with pid=13, OS id=2212 
Mon Sep 18 12:32:34 2017
RECO started with pid=14, OS id=2216 
Mon Sep 18 12:32:34 2017
MMON started with pid=15, OS id=2220 
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Mon Sep 18 12:32:34 2017
MMNL started with pid=16, OS id=2224 
starting up 1 shared server(s) ...
ORACLE_BASE from environment = D:\database
Mon Sep 18 12:32:36 2017
alter database mount exclusive
Successful mount of redo thread 1, with mount id 2265404964
Database mounted in Exclusive Mode
Lost write protection disabled
Completed: alter database mount exclusive
alter database open
Errors in file d:\database\diag\rdbms\dba1\dba1\trace\dba1_ora_2240.trc:
ORA-01589: ??? ???????? ?? ?????? ???? ???????????? ????????? RESETLOGS ??? NORESETLOGS
ORA-1589 signalled during: alter database open...
Mon Sep 18 12:44:42 2017
Starting ORACLE instance (normal)
Mon Sep 18 12:45:08 2017
alter database open
Errors in file d:\database\diag\rdbms\dba1\dba1\trace\dba1_ora_4628.trc:
ORA-01589: для открытия БД должны быть использованы параметры RESETLOGS или NORESETLOGS
ORA-1589 signalled during: alter database open...
Mon Sep 18 12:47:06 2017
db_recovery_file_dest_size of 3852 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.
Mon Sep 18 12:48:16 2017
Starting ORACLE instance (normal)
Mon Sep 18 12:48:53 2017
alter database open
Errors in file d:\database\diag\rdbms\dba1\dba1\trace\dba1_ora_2752.trc:
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
ORA-1589 signalled during: alter database open...
Mon Sep 18 12:50:33 2017
Shutting down instance (normal)
Shutting down instance: further logons disabled
Stopping background process MMNL
Stopping background process MMON
License high water mark = 2
All dispatchers and shared servers shutdown
ALTER DATABASE CLOSE NORMAL
ORA-1109 signalled during: ALTER DATABASE CLOSE NORMAL...
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archival disabled due to shutdown: 1090
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archival disabled due to shutdown: 1090
Mon Sep 18 12:50:41 2017
Stopping background process VKTM: 
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Mon Sep 18 12:50:45 2017
Instance shutdown complete
Mon Sep 18 12:50:53 2017
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on. 
IMODE=BR
ILAT =27
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
Using parameter settings in server-side spfile D:\DATABASE\PRODUCT\11.2.0\DBHOME_1\DATABASE\SPFILEDBA1.ORA
System parameters with non-default values:
  processes                = 150
  memory_target            = 1232M
  control_files            = "D:\DATABASE\ORADATA\DBA1\CONTROL01.CTL"
  db_block_size            = 8192
  compatible               = "11.2.0.0.0"
  db_recovery_file_dest    = "D:\database\flash_recovery_area"
  db_recovery_file_dest_size= 3852M
  undo_tablespace          = "UNDOTBS1"
  remote_login_passwordfile= "EXCLUSIVE"
  db_domain                = ""
  dispatchers              = "(PROTOCOL=TCP) (SERVICE=dba1XDB)"
  audit_file_dest          = "D:\DATABASE\ADMIN\DBA1\ADUMP"
  audit_trail              = "DB"
  db_name                  = "dba1"
  open_cursors             = 300
  diagnostic_dest          = "D:\DATABASE"
Mon Sep 18 12:50:53 2017
PMON started with pid=2, OS id=4264 
Mon Sep 18 12:50:53 2017
VKTM started with pid=3, OS id=4204 at elevated priority
VKTM running at (10)millisec precision with DBRM quantum (100)ms
OER 7451 in Load Indicator : Error Code = OSD-04500: задан недопустимый параметр !
Mon Sep 18 12:50:54 2017
GEN0 started with pid=4, OS id=4960 
Mon Sep 18 12:50:54 2017
DIAG started with pid=5, OS id=4736 
Mon Sep 18 12:50:54 2017
DBRM started with pid=6, OS id=2564 
Mon Sep 18 12:50:54 2017
PSP0 started with pid=7, OS id=3880 
Mon Sep 18 12:50:54 2017
DIA0 started with pid=8, OS id=4884 
Mon Sep 18 12:50:54 2017
MMAN started with pid=9, OS id=4336 
Mon Sep 18 12:50:54 2017
DBW0 started with pid=10, OS id=4904 
Mon Sep 18 12:50:54 2017
LGWR started with pid=11, OS id=428 
Mon Sep 18 12:50:54 2017
CKPT started with pid=12, OS id=3592 
Mon Sep 18 12:50:54 2017
SMON started with pid=13, OS id=3780 
Mon Sep 18 12:50:54 2017
RECO started with pid=14, OS id=4192 
Mon Sep 18 12:50:54 2017
MMON started with pid=15, OS id=3796 
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
ORACLE_BASE from environment = D:\database
Mon Sep 18 12:50:54 2017
ALTER DATABASE   MOUNT
Mon Sep 18 12:50:54 2017
MMNL started with pid=16, OS id=288 
Successful mount of redo thread 1, with mount id 2265444462
Database mounted in Exclusive Mode
Lost write protection disabled
Completed: ALTER DATABASE   MOUNT
Mon Sep 18 12:50:58 2017
ALTER DATABASE OPEN
Errors in file d:\database\diag\rdbms\dba1\dba1\trace\dba1_ora_4544.trc:
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
ORA-1589 signalled during: ALTER DATABASE OPEN...
Mon Sep 18 12:57:16 2017
Shutting down instance (abort)
License high water mark = 1
USER (ospid: 4544): terminating the instance
Instance terminated by USER, pid = 4544
Mon Sep 18 12:57:17 2017
Instance shutdown complete
Mon Sep 18 12:59:33 2017
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on. 
IMODE=BR
ILAT =27
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
Using parameter settings in server-side spfile D:\DATABASE\PRODUCT\11.2.0\DBHOME_1\DATABASE\SPFILEDBA1.ORA
System parameters with non-default values:
  processes                = 150
  memory_target            = 1232M
  control_files            = "D:\DATABASE\ORADATA\DBA1\CONTROL01.CTL"
  db_block_size            = 8192
  compatible               = "11.2.0.0.0"
  db_recovery_file_dest    = "D:\database\flash_recovery_area"
  db_recovery_file_dest_size= 3852M
  undo_tablespace          = "UNDOTBS1"
  remote_login_passwordfile= "EXCLUSIVE"
  db_domain                = ""
  dispatchers              = "(PROTOCOL=TCP) (SERVICE=dba1XDB)"
  audit_file_dest          = "D:\DATABASE\ADMIN\DBA1\ADUMP"
  audit_trail              = "DB"
  db_name                  = "dba1"
  open_cursors             = 300
  diagnostic_dest          = "D:\DATABASE"
Mon Sep 18 12:59:34 2017
PMON started with pid=2, OS id=4992 
OER 7451 in Load Indicator : Error Code = OSD-04500: задан недопустимый параметр !
Mon Sep 18 12:59:34 2017
VKTM started with pid=3, OS id=3600 at elevated priority
VKTM running at (10)millisec precision with DBRM quantum (100)ms
Mon Sep 18 12:59:34 2017
GEN0 started with pid=4, OS id=4628 
Mon Sep 18 12:59:34 2017
DIAG started with pid=5, OS id=3004 
Mon Sep 18 12:59:34 2017
DBRM started with pid=6, OS id=4696 
Mon Sep 18 12:59:34 2017
PSP0 started with pid=7, OS id=3788 
Mon Sep 18 12:59:34 2017
DIA0 started with pid=8, OS id=3736 
Mon Sep 18 12:59:34 2017
MMAN started with pid=9, OS id=4180 
Mon Sep 18 12:59:34 2017
DBW0 started with pid=10, OS id=4656 
Mon Sep 18 12:59:34 2017
LGWR started with pid=11, OS id=4476 
Mon Sep 18 12:59:34 2017
CKPT started with pid=12, OS id=3836 
Mon Sep 18 12:59:34 2017
SMON started with pid=13, OS id=1220 
Mon Sep 18 12:59:34 2017
RECO started with pid=14, OS id=3468 
Mon Sep 18 12:59:34 2017
MMON started with pid=15, OS id=4684 
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Mon Sep 18 12:59:34 2017
MMNL started with pid=16, OS id=1704 
starting up 1 shared server(s) ...
ORACLE_BASE from environment = D:\database
Mon Sep 18 12:59:34 2017
ALTER DATABASE   MOUNT
Successful mount of redo thread 1, with mount id 2265456502
Database mounted in Exclusive Mode
Lost write protection disabled
Completed: ALTER DATABASE   MOUNT
Mon Sep 18 13:03:42 2017
alter database open
Errors in file d:\database\diag\rdbms\dba1\dba1\trace\dba1_ora_4152.trc:
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
ORA-1589 signalled during: alter database open...
Mon Sep 18 13:08:17 2017
Shutting down instance (immediate)
Shutting down instance: further logons disabled
Stopping background process MMNL
Stopping background process MMON
License high water mark = 1
All dispatchers and shared servers shutdown
ALTER DATABASE CLOSE NORMAL
ORA-1109 signalled during: ALTER DATABASE CLOSE NORMAL...
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
Mon Sep 18 13:08:20 2017
Stopping background process VKTM: 
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Mon Sep 18 13:08:22 2017
Instance shutdown complete
Mon Sep 18 13:08:36 2017
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on. 
IMODE=BR
ILAT =27
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
Using parameter settings in server-side spfile D:\DATABASE\PRODUCT\11.2.0\DBHOME_1\DATABASE\SPFILEDBA1.ORA
System parameters with non-default values:
  processes                = 150
  memory_target            = 1232M
  control_files            = "D:\DATABASE\ORADATA\DBA1\CONTROL01.CTL"
  db_block_size            = 8192
  compatible               = "11.2.0.0.0"
  db_recovery_file_dest    = "D:\database\flash_recovery_area"
  db_recovery_file_dest_size= 3852M
  undo_tablespace          = "UNDOTBS1"
  remote_login_passwordfile= "EXCLUSIVE"
  db_domain                = ""
  dispatchers              = "(PROTOCOL=TCP) (SERVICE=dba1XDB)"
  audit_file_dest          = "D:\DATABASE\ADMIN\DBA1\ADUMP"
  audit_trail              = "DB"
  db_name                  = "dba1"
  open_cursors             = 300
  diagnostic_dest          = "D:\DATABASE"
Mon Sep 18 13:08:36 2017
PMON started with pid=2, OS id=3488 
OER 7451 in Load Indicator : Error Code = OSD-04500: задан недопустимый параметр !
Mon Sep 18 13:08:36 2017
VKTM started with pid=3, OS id=4164 at elevated priority
VKTM running at (10)millisec precision with DBRM quantum (100)ms
Mon Sep 18 13:08:36 2017
GEN0 started with pid=4, OS id=3760 
Mon Sep 18 13:08:36 2017
DIAG started with pid=5, OS id=4004 
Mon Sep 18 13:08:36 2017
DBRM started with pid=6, OS id=4268 
Mon Sep 18 13:08:36 2017
PSP0 started with pid=7, OS id=1324 
Mon Sep 18 13:08:36 2017
DIA0 started with pid=8, OS id=3012 
Mon Sep 18 13:08:36 2017
MMAN started with pid=9, OS id=1668 
Mon Sep 18 13:08:36 2017
DBW0 started with pid=10, OS id=756 
Mon Sep 18 13:08:36 2017
LGWR started with pid=11, OS id=4928 
Mon Sep 18 13:08:36 2017
CKPT started with pid=12, OS id=2248 
Mon Sep 18 13:08:36 2017
SMON started with pid=13, OS id=4900 
Mon Sep 18 13:08:36 2017
RECO started with pid=14, OS id=4272 
Mon Sep 18 13:08:36 2017
MMON started with pid=15, OS id=4320 
Mon Sep 18 13:08:36 2017
MMNL started with pid=16, OS id=3684 
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
ORACLE_BASE from environment = D:\database
Mon Sep 18 13:08:37 2017
ALTER DATABASE   MOUNT
Successful mount of redo thread 1, with mount id 2265403285
Database mounted in Exclusive Mode
Lost write protection disabled
Completed: ALTER DATABASE   MOUNT
Mon Sep 18 13:08:42 2017
ALTER DATABASE OPEN MIGRATE
Errors in file d:\database\diag\rdbms\dba1\dba1\trace\dba1_ora_4624.trc:
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
ORA-1589 signalled during: ALTER DATABASE OPEN MIGRATE...
Mon Sep 18 14:41:50 2017
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on. 
IMODE=BR
ILAT =27
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
Using parameter settings in server-side spfile D:\DATABASE\PRODUCT\11.2.0\DBHOME_1\DATABASE\SPFILEDBA1.ORA
System parameters with non-default values:
  processes                = 150
  memory_target            = 1232M
  control_files            = "D:\DATABASE\ORADATA\DBA1\CONTROL01.CTL"
  db_block_size            = 8192
  compatible               = "11.2.0.0.0"
  db_recovery_file_dest    = "D:\database\flash_recovery_area"
  db_recovery_file_dest_size= 3852M
  undo_tablespace          = "UNDOTBS1"
  remote_login_passwordfile= "EXCLUSIVE"
  db_domain                = ""
  dispatchers              = "(PROTOCOL=TCP) (SERVICE=dba1XDB)"
  audit_file_dest          = "D:\DATABASE\ADMIN\DBA1\ADUMP"
  audit_trail              = "DB"
  db_name                  = "dba1"
  open_cursors             = 300
  diagnostic_dest          = "D:\DATABASE"
Mon Sep 18 14:41:54 2017
PMON started with pid=2, OS id=2664 
Mon Sep 18 14:41:54 2017
VKTM started with pid=3, OS id=2668 at elevated priority
VKTM running at (10)millisec precision with DBRM quantum (100)ms
Mon Sep 18 14:41:54 2017
GEN0 started with pid=4, OS id=2672 
OER 7451 in Load Indicator : Error Code = OSD-04500: задан недопустимый параметр !
Mon Sep 18 14:41:54 2017
DIAG started with pid=5, OS id=2676 
Mon Sep 18 14:41:54 2017
DBRM started with pid=6, OS id=2680 
Mon Sep 18 14:41:54 2017
PSP0 started with pid=7, OS id=2684 
Mon Sep 18 14:41:54 2017
DIA0 started with pid=8, OS id=2688 
Mon Sep 18 14:41:54 2017
MMAN started with pid=9, OS id=2692 
Mon Sep 18 14:41:54 2017
DBW0 started with pid=10, OS id=2696 
Mon Sep 18 14:41:54 2017
LGWR started with pid=11, OS id=2700 
Mon Sep 18 14:41:54 2017
CKPT started with pid=12, OS id=2704 
Mon Sep 18 14:41:54 2017
SMON started with pid=13, OS id=2708 
Mon Sep 18 14:41:54 2017
RECO started with pid=14, OS id=2712 
Mon Sep 18 14:41:54 2017
MMON started with pid=15, OS id=2716 
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
ORACLE_BASE from environment = D:\database
Mon Sep 18 14:41:55 2017
alter database mount exclusive
Mon Sep 18 14:41:54 2017
MMNL started with pid=16, OS id=2720 
Successful mount of redo thread 1, with mount id 2265443187
Database mounted in Exclusive Mode
Lost write protection disabled
Completed: alter database mount exclusive
alter database open
Errors in file d:\database\diag\rdbms\dba1\dba1\trace\dba1_ora_2736.trc:
ORA-01589: ??? ???????? ?? ?????? ???? ???????????? ????????? RESETLOGS ??? NORESETLOGS
ORA-1589 signalled during: alter database open...
Mon Sep 18 14:52:28 2017
Shutting down instance (immediate)
Shutting down instance: further logons disabled
Stopping background process MMNL
Stopping background process MMON
License high water mark = 2
All dispatchers and shared servers shutdown
alter database close normal
ORA-1109 signalled during: alter database close normal...
Mon Sep 18 14:52:36 2017
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on. 
IMODE=BR
ILAT =27
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
Using parameter settings in server-side spfile D:\DATABASE\PRODUCT\11.2.0\DBHOME_1\DATABASE\SPFILEDBA1.ORA
System parameters with non-default values:
  processes                = 150
  memory_target            = 1232M
  control_files            = "D:\DATABASE\ORADATA\DBA1\CONTROL01.CTL"
  db_block_size            = 8192
  compatible               = "11.2.0.0.0"
  db_recovery_file_dest    = "D:\database\flash_recovery_area"
  db_recovery_file_dest_size= 3852M
  undo_tablespace          = "UNDOTBS1"
  remote_login_passwordfile= "EXCLUSIVE"
  db_domain                = ""
  dispatchers              = "(PROTOCOL=TCP) (SERVICE=dba1XDB)"
  audit_file_dest          = "D:\DATABASE\ADMIN\DBA1\ADUMP"
  audit_trail              = "DB"
  db_name                  = "dba1"
  open_cursors             = 300
  diagnostic_dest          = "D:\DATABASE"
Mon Sep 18 14:52:36 2017
PMON started with pid=2, OS id=2640 
Mon Sep 18 14:52:36 2017
VKTM started with pid=3, OS id=3620 at elevated priority
OER 7451 in Load Indicator : Error Code = OSD-04500: задан недопустимый параметр !
VKTM running at (10)millisec precision with DBRM quantum (100)ms
Mon Sep 18 14:52:36 2017
GEN0 started with pid=4, OS id=844 
Mon Sep 18 14:52:36 2017
DIAG started with pid=5, OS id=1700 
Mon Sep 18 14:52:36 2017
DBRM started with pid=6, OS id=3724 
Mon Sep 18 14:52:36 2017
PSP0 started with pid=7, OS id=2788 
Mon Sep 18 14:52:36 2017
DIA0 started with pid=8, OS id=3560 
Mon Sep 18 14:52:36 2017
MMAN started with pid=9, OS id=4452 
Mon Sep 18 14:52:36 2017
DBW0 started with pid=10, OS id=4556 
Mon Sep 18 14:52:36 2017
LGWR started with pid=11, OS id=3084 
Mon Sep 18 14:52:36 2017
CKPT started with pid=12, OS id=2928 
Mon Sep 18 14:52:36 2017
SMON started with pid=13, OS id=2400 
Mon Sep 18 14:52:36 2017
RECO started with pid=14, OS id=3748 
Mon Sep 18 14:52:36 2017
MMON started with pid=15, OS id=1280 
Mon Sep 18 14:52:36 2017
MMNL started with pid=16, OS id=5008 
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
ORACLE_BASE from environment = D:\database
Mon Sep 18 14:52:37 2017
alter database mount exclusive
Successful mount of redo thread 1, with mount id 2265448949
Database mounted in Exclusive Mode
Lost write protection disabled
Completed: alter database mount exclusive
alter database open
Errors in file d:\database\diag\rdbms\dba1\dba1\trace\dba1_ora_4680.trc:
ORA-01589: ??? ???????? ?? ?????? ???? ???????????? ????????? RESETLOGS ??? NORESETLOGS
ORA-1589 signalled during: alter database open...
Mon Sep 18 14:56:23 2017
db_recovery_file_dest_size of 3852 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.
Mon Sep 18 14:57:50 2017
Starting ORACLE instance (normal)
Mon Sep 18 14:58:11 2017
Shutting down instance (abort)
License high water mark = 1
USER (ospid: 2964): terminating the instance
Instance terminated by USER, pid = 2964
Mon Sep 18 14:58:12 2017
Instance shutdown complete
Mon Sep 18 14:58:24 2017
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on. 
IMODE=BR
ILAT =27
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
Using parameter settings in server-side spfile D:\DATABASE\PRODUCT\11.2.0\DBHOME_1\DATABASE\SPFILEDBA1.ORA
System parameters with non-default values:
  processes                = 150
  memory_target            = 1232M
  control_files            = "D:\DATABASE\ORADATA\DBA1\CONTROL01.CTL"
  db_block_size            = 8192
  compatible               = "11.2.0.0.0"
  db_recovery_file_dest    = "D:\database\flash_recovery_area"
  db_recovery_file_dest_size= 3852M
  undo_tablespace          = "UNDOTBS1"
  remote_login_passwordfile= "EXCLUSIVE"
  db_domain                = ""
  dispatchers              = "(PROTOCOL=TCP) (SERVICE=dba1XDB)"
  audit_file_dest          = "D:\DATABASE\ADMIN\DBA1\ADUMP"
  audit_trail              = "DB"
  db_name                  = "dba1"
  open_cursors             = 300
  diagnostic_dest          = "D:\DATABASE"
Mon Sep 18 14:58:24 2017
PMON started with pid=2, OS id=4788 
Mon Sep 18 14:58:24 2017
VKTM started with pid=3, OS id=5104 at elevated priority
VKTM running at (10)millisec precision with DBRM quantum (100)ms
Mon Sep 18 14:58:24 2017
GEN0 started with pid=4, OS id=3304 
Mon Sep 18 14:58:24 2017
DIAG started with pid=5, OS id=2624 
OER 7451 in Load Indicator : Error Code = OSD-04500: задан недопустимый параметр !
Mon Sep 18 14:58:24 2017
DBRM started with pid=6, OS id=1284 
Mon Sep 18 14:58:24 2017
PSP0 started with pid=7, OS id=2872 
Mon Sep 18 14:58:24 2017
DIA0 started with pid=8, OS id=2824 
Mon Sep 18 14:58:24 2017
MMAN started with pid=9, OS id=1040 
Mon Sep 18 14:58:24 2017
DBW0 started with pid=10, OS id=3288 
Mon Sep 18 14:58:24 2017
LGWR started with pid=11, OS id=4840 
Mon Sep 18 14:58:24 2017
CKPT started with pid=12, OS id=4548 
Mon Sep 18 14:58:24 2017
SMON started with pid=13, OS id=4764 
Mon Sep 18 14:58:24 2017
RECO started with pid=14, OS id=4296 
Mon Sep 18 14:58:24 2017
MMON started with pid=15, OS id=764 
Mon Sep 18 14:58:24 2017
MMNL started with pid=16, OS id=4660 
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
ORACLE_BASE from environment = D:\database
Mon Sep 18 14:58:24 2017
ALTER DATABASE   MOUNT
Successful mount of redo thread 1, with mount id 2265406288
Database mounted in Exclusive Mode
Lost write protection disabled
Completed: ALTER DATABASE   MOUNT
Mon Sep 18 14:58:29 2017
ALTER DATABASE OPEN
Errors in file d:\database\diag\rdbms\dba1\dba1\trace\dba1_ora_2644.trc:
ORA-01589: для открытия БД должны быть использованы параметры RESETLOGS или NORESETLOGS
ORA-1589 signalled during: ALTER DATABASE OPEN...
Mon Sep 18 14:59:04 2017
alter database open resetlogs
ORA-1194 signalled during: alter database open resetlogs...
Mon Sep 18 14:59:04 2017
Errors in file d:\database\diag\rdbms\dba1\dba1\trace\dba1_m000_3764.trc:
ORA-00322: log 1 of thread 1 is not current copy
ORA-00312: online log 1 thread 1: 'D:\DATABASE\ORADATA\DBA1\REDO01.LOG'
Errors in file d:\database\diag\rdbms\dba1\dba1\trace\dba1_m000_3764.trc:
ORA-00322: log 2 of thread 1 is not current copy
ORA-00312: online log 2 thread 1: 'D:\DATABASE\ORADATA\DBA1\REDO02.LOG'
Mon Sep 18 15:04:36 2017
Shutting down instance (abort)
License high water mark = 1
USER (ospid: 2644): terminating the instance
Instance terminated by USER, pid = 2644
Mon Sep 18 15:04:37 2017
Instance shutdown complete
Mon Sep 18 15:04:56 2017
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on. 
IMODE=BR
ILAT =27
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
Using parameter settings in server-side spfile D:\DATABASE\PRODUCT\11.2.0\DBHOME_1\DATABASE\SPFILEDBA1.ORA
System parameters with non-default values:
  processes                = 150
  memory_target            = 1232M
  control_files            = "D:\DATABASE\ORADATA\DBA1\CONTROL01.CTL"
  db_block_size            = 8192
  compatible               = "11.2.0.0.0"
  db_recovery_file_dest    = "D:\database\flash_recovery_area"
  db_recovery_file_dest_size= 3852M
  undo_tablespace          = "UNDOTBS1"
  remote_login_passwordfile= "EXCLUSIVE"
  db_domain                = ""
  dispatchers              = "(PROTOCOL=TCP) (SERVICE=dba1XDB)"
  audit_file_dest          = "D:\DATABASE\ADMIN\DBA1\ADUMP"
  audit_trail              = "DB"
  db_name                  = "dba1"
  open_cursors             = 300
  diagnostic_dest          = "D:\DATABASE"
Mon Sep 18 15:04:56 2017
PMON started with pid=2, OS id=4872 
OER 7451 in Load Indicator : Error Code = OSD-04500: задан недопустимый параметр !
Mon Sep 18 15:04:56 2017
VKTM started with pid=3, OS id=3960 at elevated priority
VKTM running at (10)millisec precision with DBRM quantum (100)ms
Mon Sep 18 15:04:56 2017
GEN0 started with pid=4, OS id=3628 
Mon Sep 18 15:04:56 2017
DIAG started with pid=5, OS id=4956 
Mon Sep 18 15:04:56 2017
DBRM started with pid=6, OS id=1308 
Mon Sep 18 15:04:56 2017
PSP0 started with pid=7, OS id=4420 
Mon Sep 18 15:04:56 2017
DIA0 started with pid=8, OS id=4888 
Mon Sep 18 15:04:56 2017
MMAN started with pid=9, OS id=4572 
Mon Sep 18 15:04:56 2017
DBW0 started with pid=10, OS id=3408 
Mon Sep 18 15:04:56 2017
LGWR started with pid=11, OS id=4668 
Mon Sep 18 15:04:56 2017
CKPT started with pid=12, OS id=2248 
Mon Sep 18 15:04:56 2017
SMON started with pid=13, OS id=3636 
Mon Sep 18 15:04:56 2017
RECO started with pid=14, OS id=3048 
Mon Sep 18 15:04:56 2017
MMON started with pid=15, OS id=3868 
Mon Sep 18 15:04:56 2017
MMNL started with pid=16, OS id=5068 
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
ORACLE_BASE from environment = D:\database
Mon Sep 18 15:04:56 2017
ALTER DATABASE   MOUNT
Successful mount of redo thread 1, with mount id 2265427416
Database mounted in Exclusive Mode
Lost write protection disabled
Completed: ALTER DATABASE   MOUNT
Mon Sep 18 15:05:58 2017
alter database open resetlogs
ORA-1194 signalled during: alter database open resetlogs...
Mon Sep 18 15:05:59 2017
Errors in file d:\database\diag\rdbms\dba1\dba1\trace\dba1_m000_3292.trc:
ORA-00322: log 1 of thread 1 is not current copy
ORA-00312: online log 1 thread 1: 'D:\DATABASE\ORADATA\DBA1\REDO01.LOG'
Errors in file d:\database\diag\rdbms\dba1\dba1\trace\dba1_m000_3292.trc:
ORA-00322: log 2 of thread 1 is not current copy
ORA-00312: online log 2 thread 1: 'D:\DATABASE\ORADATA\DBA1\REDO02.LOG'
Mon Sep 18 15:07:35 2017
alter database open
Errors in file d:\database\diag\rdbms\dba1\dba1\trace\dba1_ora_2664.trc:
ORA-01589: для открытия БД должны быть использованы параметры RESETLOGS или NORESETLOGS
ORA-1589 signalled during: alter database open
...
Mon Sep 18 15:07:56 2017


***********************************************************************

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

  VERSION INFORMATION:
	TNS for 32-bit Windows: Version 11.2.0.1.0 - Production
	Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 11.2.0.1.0 - Production
  Time: 18-СЕН-2017 15:07:56
  Tracing not turned on.
  Tns error struct:
    ns main err code: 12638
    
TNS-12638: Сбой при извлечении реквизитов
    ns secondary err code: 0
    nt main err code: 0
    nt secondary err code: 0
    nt OS err code: 0
Mon Sep 18 15:08:47 2017
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on. 
IMODE=BR
ILAT =27
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
Using parameter settings in server-side spfile D:\DATABASE\PRODUCT\11.2.0\DBHOME_1\DATABASE\SPFILEDBA1.ORA
System parameters with non-default values:
  processes                = 150
  memory_target            = 1232M
  control_files            = "D:\DATABASE\ORADATA\DBA1\CONTROL01.CTL"
  db_block_size            = 8192
  compatible               = "11.2.0.0.0"
  db_recovery_file_dest    = "D:\database\flash_recovery_area"
  db_recovery_file_dest_size= 3852M
  undo_tablespace          = "UNDOTBS1"
  remote_login_passwordfile= "EXCLUSIVE"
  db_domain                = ""
  dispatchers              = "(PROTOCOL=TCP) (SERVICE=dba1XDB)"
  audit_file_dest          = "D:\DATABASE\ADMIN\DBA1\ADUMP"
  audit_trail              = "DB"
  db_name                  = "dba1"
  open_cursors             = 300
  diagnostic_dest          = "D:\DATABASE"
Mon Sep 18 15:08:51 2017
PMON started with pid=2, OS id=2144 
Mon Sep 18 15:08:51 2017
VKTM started with pid=3, OS id=2148 at elevated priority
VKTM running at (10)millisec precision with DBRM quantum (100)ms
Mon Sep 18 15:08:51 2017
GEN0 started with pid=4, OS id=2152 
OER 7451 in Load Indicator : Error Code = OSD-04500: задан недопустимый параметр !
Mon Sep 18 15:08:51 2017
DIAG started with pid=5, OS id=2156 
Mon Sep 18 15:08:51 2017
DBRM started with pid=6, OS id=2160 
Mon Sep 18 15:08:51 2017
PSP0 started with pid=7, OS id=2164 
Mon Sep 18 15:08:51 2017
DIA0 started with pid=8, OS id=2168 
Mon Sep 18 15:08:51 2017
MMAN started with pid=9, OS id=2172 
Mon Sep 18 15:08:51 2017
DBW0 started with pid=10, OS id=2176 
Mon Sep 18 15:08:51 2017
LGWR started with pid=11, OS id=2180 
Mon Sep 18 15:08:51 2017
CKPT started with pid=12, OS id=2184 
Mon Sep 18 15:08:51 2017
SMON started with pid=13, OS id=2188 
Mon Sep 18 15:08:51 2017
RECO started with pid=14, OS id=2192 
Mon Sep 18 15:08:51 2017
MMON started with pid=15, OS id=2196 
Mon Sep 18 15:08:51 2017
MMNL started with pid=16, OS id=2200 
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
ORACLE_BASE from environment = D:\database
Mon Sep 18 15:08:56 2017
alter database mount exclusive
Mon Sep 18 15:09:02 2017
Successful mount of redo thread 1, with mount id 2265418953
Database mounted in Exclusive Mode
Lost write protection disabled
Completed: alter database mount exclusive
alter database open
Errors in file d:\database\diag\rdbms\dba1\dba1\trace\dba1_ora_2484.trc:
ORA-01589: ??? ???????? ?? ?????? ???? ???????????? ????????? RESETLOGS ??? NORESETLOGS
ORA-1589 signalled during: alter database open...
Mon Sep 18 15:10:54 2017
Starting ORACLE instance (normal)
Mon Sep 18 15:11:19 2017
Shutting down instance (immediate)
Shutting down instance: further logons disabled
Stopping background process MMNL
Stopping background process MMON
License high water mark = 1
All dispatchers and shared servers shutdown
ALTER DATABASE CLOSE NORMAL
ORA-1109 signalled during: ALTER DATABASE CLOSE NORMAL...
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
Mon Sep 18 15:11:21 2017
Stopping background process VKTM: 
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Mon Sep 18 15:11:23 2017
Instance shutdown complete
Mon Sep 18 15:11:48 2017
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on. 
IMODE=BR
ILAT =27
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
Using parameter settings in server-side spfile D:\DATABASE\PRODUCT\11.2.0\DBHOME_1\DATABASE\SPFILEDBA1.ORA
System parameters with non-default values:
  processes                = 150
  memory_target            = 1232M
  control_files            = "D:\DATABASE\ORADATA\DBA1\CONTROL01.CTL"
  db_block_size            = 8192
  compatible               = "11.2.0.0.0"
  db_recovery_file_dest    = "D:\database\flash_recovery_area"
  db_recovery_file_dest_size= 3852M
  undo_tablespace          = "UNDOTBS1"
  remote_login_passwordfile= "EXCLUSIVE"
  db_domain                = ""
  dispatchers              = "(PROTOCOL=TCP) (SERVICE=dba1XDB)"
  audit_file_dest          = "D:\DATABASE\ADMIN\DBA1\ADUMP"
  audit_trail              = "DB"
  db_name                  = "dba1"
  open_cursors             = 300
  diagnostic_dest          = "D:\DATABASE"
Mon Sep 18 15:11:48 2017
PMON started with pid=2, OS id=2228 
Mon Sep 18 15:11:48 2017
VKTM started with pid=3, OS id=1052 at elevated priority
OER 7451 in Load Indicator : Error Code = OSD-04500: задан недопустимый параметр !
Mon Sep 18 15:11:48 2017
GEN0 started with pid=4, OS id=2528 
Mon Sep 18 15:11:48 2017
DIAG started with pid=5, OS id=2520 
Mon Sep 18 15:11:48 2017
DBRM started with pid=6, OS id=2092 
Mon Sep 18 15:11:48 2017
PSP0 started with pid=7, OS id=212 
Mon Sep 18 15:11:48 2017
DIA0 started with pid=8, OS id=2692 
Mon Sep 18 15:11:48 2017
MMAN started with pid=9, OS id=2748 
Mon Sep 18 15:11:48 2017
DBW0 started with pid=10, OS id=2136 
Mon Sep 18 15:11:48 2017
LGWR started with pid=11, OS id=1428 
Mon Sep 18 15:11:48 2017
CKPT started with pid=12, OS id=2548 
Mon Sep 18 15:11:48 2017
SMON started with pid=13, OS id=3156 
Mon Sep 18 15:11:48 2017
RECO started with pid=14, OS id=3152 
Mon Sep 18 15:11:48 2017
MMON started with pid=15, OS id=2132 
Mon Sep 18 15:11:48 2017
MMNL started with pid=16, OS id=696 
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
ORACLE_BASE from environment = D:\database
Mon Sep 18 15:11:48 2017
ALTER DATABASE   MOUNT
VKTM running at (10)millisec precision with DBRM quantum (100)ms
Successful mount of redo thread 1, with mount id 2265404276
Database mounted in Exclusive Mode
Lost write protection disabled
Completed: ALTER DATABASE   MOUNT

...

Рейтинг:

0 / 0

18.09.2017, 13:27

| Ответить | Цитировать | Написать

ORA-01033 oracle initialization or shutdown in progress

#39522716

Добрый Э - Эх

Гость

Такие портянки нужно под спойлер убирать....
revizorДобрый день! у нас после отключение электропитании не запустился один сервер.
ошибка ora-01033. пытался зарустить через:
shu abort
startup mount , тут без каких либо ошибок работает
alter database open resetlogs; ошибки ora-01194,01110. Не знаю что делать дальше. Дайте советы чтобы исправить ошибку.
выложил алерт за сегодня

Если хочется выложить много текста...

Код: plsql

***********************************************************************

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

  VERSION INFORMATION:
	TNS for 32-bit Windows: Version 11.2.0.1.0 - Production
	Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 11.2.0.1.0 - Production
  Time: 18-СЕН-2017 01:39:02
  Tracing not turned on.
  Tns error struct:
    ns main err code: 12638
    
TNS-12638: Сбой при извлечении реквизитов
    ns secondary err code: 0
    nt main err code: 0
    nt secondary err code: 0
    nt OS err code: 0
Mon Sep 18 08:43:24 2017
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on. 
IMODE=BR
ILAT =27
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
Using parameter settings in server-side spfile D:\DATABASE\PRODUCT\11.2.0\DBHOME_1\DATABASE\SPFILEDBA1.ORA
System parameters with non-default values:
  processes                = 150
  memory_target            = 1232M
  control_files            = "D:\DATABASE\ORADATA\DBA1\CONTROL01.CTL"
  control_files            = "D:\DATABASE\FLASH_RECOVERY_AREA\DBA1\CONTROL02.CTL"
  db_block_size            = 8192
  compatible               = "11.2.0.0.0"
  db_recovery_file_dest    = "D:\database\flash_recovery_area"
  db_recovery_file_dest_size= 3852M
  undo_tablespace          = "UNDOTBS1"
  remote_login_passwordfile= "EXCLUSIVE"
  db_domain                = ""
  dispatchers              = "(PROTOCOL=TCP) (SERVICE=dba1XDB)"
  audit_file_dest          = "D:\DATABASE\ADMIN\DBA1\ADUMP"
  audit_trail              = "DB"
  db_name                  = "dba1"
  open_cursors             = 300
  diagnostic_dest          = "D:\DATABASE"
Mon Sep 18 08:43:30 2017
PMON started with pid=2, OS id=2836 
Mon Sep 18 08:43:30 2017
VKTM started with pid=3, OS id=2692 at elevated priority
Mon Sep 18 08:43:31 2017
GEN0 started with pid=4, OS id=1984 
VKTM running at (10)millisec precision with DBRM quantum (100)ms
OER 7451 in Load Indicator : Error Code = OSD-04500: задан недопустимый параметр !
Mon Sep 18 08:43:31 2017
DIAG started with pid=5, OS id=2436 
Mon Sep 18 08:43:31 2017
DBRM started with pid=6, OS id=3076 
Mon Sep 18 08:43:31 2017
PSP0 started with pid=7, OS id=3092 
Mon Sep 18 08:43:31 2017
DIA0 started with pid=8, OS id=3096 
Mon Sep 18 08:43:31 2017
MMAN started with pid=9, OS id=3100 
Mon Sep 18 08:43:31 2017
DBW0 started with pid=10, OS id=3104 
Mon Sep 18 08:43:31 2017
LGWR started with pid=11, OS id=3108 
Mon Sep 18 08:43:31 2017
CKPT started with pid=12, OS id=3112 
Mon Sep 18 08:43:31 2017
SMON started with pid=13, OS id=3116 
Mon Sep 18 08:43:31 2017
RECO started with pid=14, OS id=3120 
Mon Sep 18 08:43:31 2017
MMON started with pid=15, OS id=3124 
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Mon Sep 18 08:43:31 2017
MMNL started with pid=16, OS id=3128 
starting up 1 shared server(s) ...
ORACLE_BASE from environment = D:\database
Mon Sep 18 08:43:36 2017
alter database mount exclusive
ORA-214 signalled during: alter database mount exclusive...
Mon Sep 18 09:34:02 2017
Starting ORACLE instance (normal)
Mon Sep 18 09:34:26 2017
Shutting down instance (immediate)
Shutting down instance: further logons disabled
Stopping background process MMNL
Stopping background process MMON
License high water mark = 1
All dispatchers and shared servers shutdown
ALTER DATABASE CLOSE NORMAL
ORA-1507 signalled during: ALTER DATABASE CLOSE NORMAL...
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
Mon Sep 18 09:34:29 2017
Stopping background process VKTM: 
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Mon Sep 18 09:34:31 2017
Instance shutdown complete
Mon Sep 18 09:34:38 2017
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on. 
IMODE=BR
ILAT =27
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
Using parameter settings in server-side spfile D:\DATABASE\PRODUCT\11.2.0\DBHOME_1\DATABASE\SPFILEDBA1.ORA
System parameters with non-default values:
  processes                = 150
  memory_target            = 1232M
  control_files            = "D:\DATABASE\ORADATA\DBA1\CONTROL01.CTL"
  control_files            = "D:\DATABASE\FLASH_RECOVERY_AREA\DBA1\CONTROL02.CTL"
  db_block_size            = 8192
  compatible               = "11.2.0.0.0"
  db_recovery_file_dest    = "D:\database\flash_recovery_area"
  db_recovery_file_dest_size= 3852M
  undo_tablespace          = "UNDOTBS1"
  remote_login_passwordfile= "EXCLUSIVE"
  db_domain                = ""
  dispatchers              = "(PROTOCOL=TCP) (SERVICE=dba1XDB)"
  audit_file_dest          = "D:\DATABASE\ADMIN\DBA1\ADUMP"
  audit_trail              = "DB"
  db_name                  = "dba1"
  open_cursors             = 300
  diagnostic_dest          = "D:\DATABASE"
Mon Sep 18 09:34:38 2017
PMON started with pid=2, OS id=3392 
Mon Sep 18 09:34:38 2017
VKTM started with pid=3, OS id=1380 at elevated priority
Mon Sep 18 09:34:38 2017
GEN0 started with pid=4, OS id=5060 
VKTM running at (10)millisec precision with DBRM quantum (100)ms
OER 7451 in Load Indicator : Error Code = OSD-04500: задан недопустимый параметр !
Mon Sep 18 09:34:38 2017
DIAG started with pid=5, OS id=4140 
Mon Sep 18 09:34:38 2017
DBRM started with pid=6, OS id=5084 
Mon Sep 18 09:34:38 2017
PSP0 started with pid=7, OS id=1936 
Mon Sep 18 09:34:38 2017
DIA0 started with pid=8, OS id=3888 
Mon Sep 18 09:34:38 2017
MMAN started with pid=9, OS id=1624 
Mon Sep 18 09:34:38 2017
DBW0 started with pid=10, OS id=4700 
Mon Sep 18 09:34:38 2017
LGWR started with pid=11, OS id=4616 
Mon Sep 18 09:34:38 2017
CKPT started with pid=12, OS id=844 
Mon Sep 18 09:34:38 2017
SMON started with pid=13, OS id=2492 
Mon Sep 18 09:34:38 2017
RECO started with pid=14, OS id=4120 
Mon Sep 18 09:34:38 2017
MMON started with pid=15, OS id=3328 
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
ORACLE_BASE from environment = D:\database
Mon Sep 18 09:34:38 2017
ALTER DATABASE   MOUNT
ORA-214 signalled during: ALTER DATABASE   MOUNT...
Mon Sep 18 09:34:38 2017
MMNL started with pid=16, OS id=2528 
Mon Sep 18 09:35:27 2017
Starting ORACLE instance (normal)
Mon Sep 18 09:36:14 2017
Shutting down instance (normal)
Shutting down instance: further logons disabled
Stopping background process MMNL
Stopping background process MMON
License high water mark = 2
All dispatchers and shared servers shutdown
ALTER DATABASE CLOSE NORMAL
ORA-1507 signalled during: ALTER DATABASE CLOSE NORMAL...
ARCH: Archival disabled due to shutdown: 1090
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archival disabled due to shutdown: 1090
Mon Sep 18 09:36:22 2017
Stopping background process VKTM: 
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Mon Sep 18 09:36:24 2017
Instance shutdown complete
Mon Sep 18 09:36:43 2017
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on. 
IMODE=BR
ILAT =27
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
Using parameter settings in server-side spfile D:\DATABASE\PRODUCT\11.2.0\DBHOME_1\DATABASE\SPFILEDBA1.ORA
System parameters with non-default values:
  processes                = 150
  memory_target            = 1232M
  control_files            = "D:\DATABASE\ORADATA\DBA1\CONTROL01.CTL"
  control_files            = "D:\DATABASE\FLASH_RECOVERY_AREA\DBA1\CONTROL02.CTL"
  db_block_size            = 8192
  compatible               = "11.2.0.0.0"
  db_recovery_file_dest    = "D:\database\flash_recovery_area"
  db_recovery_file_dest_size= 3852M
  undo_tablespace          = "UNDOTBS1"
  remote_login_passwordfile= "EXCLUSIVE"
  db_domain                = ""
  dispatchers              = "(PROTOCOL=TCP) (SERVICE=dba1XDB)"
  audit_file_dest          = "D:\DATABASE\ADMIN\DBA1\ADUMP"
  audit_trail              = "DB"
  db_name                  = "dba1"
  open_cursors             = 300
  diagnostic_dest          = "D:\DATABASE"
Mon Sep 18 09:36:43 2017
PMON started with pid=2, OS id=4788 
Mon Sep 18 09:36:43 2017
VKTM started with pid=3, OS id=2952 at elevated priority
OER 7451 in Load Indicator : Error Code = OSD-04500: задан недопустимый параметр !
Mon Sep 18 09:36:43 2017
GEN0 started with pid=4, OS id=724 
Mon Sep 18 09:36:43 2017
DIAG started with pid=5, OS id=4368 
VKTM running at (10)millisec precision with DBRM quantum (100)ms
Mon Sep 18 09:36:43 2017
DBRM started with pid=6, OS id=4864 
Mon Sep 18 09:36:43 2017
PSP0 started with pid=7, OS id=4808 
Mon Sep 18 09:36:43 2017
DIA0 started with pid=8, OS id=4376 
Mon Sep 18 09:36:43 2017
MMAN started with pid=9, OS id=3196 
Mon Sep 18 09:36:43 2017
DBW0 started with pid=10, OS id=3200 
Mon Sep 18 09:36:43 2017
LGWR started with pid=11, OS id=340 
Mon Sep 18 09:36:43 2017
CKPT started with pid=12, OS id=4968 
Mon Sep 18 09:36:43 2017
SMON started with pid=13, OS id=1644 
Mon Sep 18 09:36:43 2017
RECO started with pid=14, OS id=320 
Mon Sep 18 09:36:43 2017
MMON started with pid=15, OS id=4456 
Mon Sep 18 09:36:43 2017
MMNL started with pid=16, OS id=4724 
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
ORACLE_BASE from environment = D:\database
Mon Sep 18 09:36:45 2017
ALTER DATABASE   MOUNT
ORA-214 signalled during: ALTER DATABASE   MOUNT...
Mon Sep 18 09:37:20 2017


***********************************************************************

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

  VERSION INFORMATION:
	TNS for 32-bit Windows: Version 11.2.0.1.0 - Production
	Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 11.2.0.1.0 - Production
  Time: 18-СЕН-2017 09:37:20
  Tracing not turned on.
  Tns error struct:
    ns main err code: 12638
    
TNS-12638: Сбой при извлечении реквизитов
    ns secondary err code: 0
    nt main err code: 0
    nt secondary err code: 0
    nt OS err code: 0
Mon Sep 18 09:38:10 2017
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on. 
IMODE=BR
ILAT =27
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
Using parameter settings in server-side spfile D:\DATABASE\PRODUCT\11.2.0\DBHOME_1\DATABASE\SPFILEDBA1.ORA
System parameters with non-default values:
  processes                = 150
  memory_target            = 1232M
  control_files            = "D:\DATABASE\ORADATA\DBA1\CONTROL01.CTL"
  control_files            = "D:\DATABASE\FLASH_RECOVERY_AREA\DBA1\CONTROL02.CTL"
  db_block_size            = 8192
  compatible               = "11.2.0.0.0"
  db_recovery_file_dest    = "D:\database\flash_recovery_area"
  db_recovery_file_dest_size= 3852M
  undo_tablespace          = "UNDOTBS1"
  remote_login_passwordfile= "EXCLUSIVE"
  db_domain                = ""
  dispatchers              = "(PROTOCOL=TCP) (SERVICE=dba1XDB)"
  audit_file_dest          = "D:\DATABASE\ADMIN\DBA1\ADUMP"
  audit_trail              = "DB"
  db_name                  = "dba1"
  open_cursors             = 300
  diagnostic_dest          = "D:\DATABASE"
Mon Sep 18 09:38:20 2017
PMON started with pid=2, OS id=2888 
Mon Sep 18 09:38:20 2017
VKTM started with pid=3, OS id=2892 at elevated priority
Mon Sep 18 09:38:20 2017
GEN0 started with pid=4, OS id=2896 
VKTM running at (10)millisec precision with DBRM quantum (100)ms
OER 7451 in Load Indicator : Error Code = OSD-04500: задан недопустимый параметр !
Mon Sep 18 09:38:20 2017
DIAG started with pid=5, OS id=2900 
Mon Sep 18 09:38:20 2017
DBRM started with pid=6, OS id=2904 
Mon Sep 18 09:38:20 2017
PSP0 started with pid=7, OS id=2908 
Mon Sep 18 09:38:20 2017
DIA0 started with pid=8, OS id=2912 
Mon Sep 18 09:38:20 2017
MMAN started with pid=9, OS id=2916 
Mon Sep 18 09:38:20 2017
DBW0 started with pid=10, OS id=2920 
Mon Sep 18 09:38:20 2017
LGWR started with pid=11, OS id=2924 
Mon Sep 18 09:38:20 2017
CKPT started with pid=12, OS id=2928 
Mon Sep 18 09:38:20 2017
SMON started with pid=13, OS id=2932 
Mon Sep 18 09:38:20 2017
RECO started with pid=14, OS id=2936 
Mon Sep 18 09:38:20 2017
MMON started with pid=15, OS id=2940 
Mon Sep 18 09:38:20 2017
MMNL started with pid=16, OS id=2944 
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
ORACLE_BASE from environment = D:\database
Mon Sep 18 09:38:22 2017
alter database mount exclusive
ORA-214 signalled during: alter database mount exclusive...
Mon Sep 18 09:43:46 2017
Starting ORACLE instance (normal)
Mon Sep 18 09:47:11 2017
Shutting down instance (abort)
License high water mark = 2
USER (ospid: 3856): terminating the instance
Instance terminated by USER, pid = 3856
Mon Sep 18 09:47:16 2017
Instance shutdown complete
Mon Sep 18 09:47:27 2017
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on. 
IMODE=BR
ILAT =27
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
Using parameter settings in server-side spfile D:\DATABASE\PRODUCT\11.2.0\DBHOME_1\DATABASE\SPFILEDBA1.ORA
System parameters with non-default values:
  processes                = 150
  memory_target            = 1232M
  control_files            = "D:\DATABASE\ORADATA\DBA1\CONTROL01.CTL"
  control_files            = "D:\DATABASE\FLASH_RECOVERY_AREA\DBA1\CONTROL02.CTL"
  db_block_size            = 8192
  compatible               = "11.2.0.0.0"
  db_recovery_file_dest    = "D:\database\flash_recovery_area"
  db_recovery_file_dest_size= 3852M
  undo_tablespace          = "UNDOTBS1"
  remote_login_passwordfile= "EXCLUSIVE"
  db_domain                = ""
  dispatchers              = "(PROTOCOL=TCP) (SERVICE=dba1XDB)"
  audit_file_dest          = "D:\DATABASE\ADMIN\DBA1\ADUMP"
  audit_trail              = "DB"
  db_name                  = "dba1"
  open_cursors             = 300
  diagnostic_dest          = "D:\DATABASE"
Mon Sep 18 09:47:28 2017
PMON started with pid=2, OS id=1036 
Mon Sep 18 09:47:28 2017
VKTM started with pid=3, OS id=1044 at elevated priority
VKTM running at (10)millisec precision with DBRM quantum (100)ms
OER 7451 in Load Indicator : Error Code = OSD-04500: задан недопустимый параметр !
Mon Sep 18 09:47:28 2017
DIAG started with pid=5, OS id=4432 
Mon Sep 18 09:47:28 2017
DBRM started with pid=6, OS id=3316 
Mon Sep 18 09:47:28 2017
PSP0 started with pid=7, OS id=2444 
Mon Sep 18 09:47:28 2017
DIA0 started with pid=8, OS id=1348 
Mon Sep 18 09:47:28 2017
MMAN started with pid=9, OS id=4132 
Mon Sep 18 09:47:28 2017
DBW0 started with pid=10, OS id=4200 
Mon Sep 18 09:47:28 2017
LGWR started with pid=11, OS id=3616 
Mon Sep 18 09:47:28 2017
CKPT started with pid=12, OS id=2116 
Mon Sep 18 09:47:28 2017
SMON started with pid=13, OS id=3980 
Mon Sep 18 09:47:28 2017
RECO started with pid=14, OS id=4204 
Mon Sep 18 09:47:28 2017
MMON started with pid=15, OS id=684 
Mon Sep 18 09:47:28 2017
MMNL started with pid=16, OS id=3252 
Mon Sep 18 09:47:28 2017
GEN0 started with pid=4, OS id=3588 
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
ORACLE_BASE from environment = D:\database
Mon Sep 18 09:47:29 2017
ALTER DATABASE   MOUNT
ORA-214 signalled during: ALTER DATABASE   MOUNT...
Mon Sep 18 09:51:02 2017
Starting ORACLE instance (normal)
Mon Sep 18 09:51:51 2017
Starting ORACLE instance (normal)
Mon Sep 18 09:52:14 2017
Shutting down instance (abort)
License high water mark = 2
USER (ospid: 1556): terminating the instance
Instance terminated by USER, pid = 1556
Mon Sep 18 09:52:20 2017
Instance shutdown complete
Mon Sep 18 09:52:22 2017
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on. 
IMODE=BR
ILAT =27
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
Using parameter settings in server-side spfile D:\DATABASE\PRODUCT\11.2.0\DBHOME_1\DATABASE\SPFILEDBA1.ORA
System parameters with non-default values:
  processes                = 150
  memory_target            = 1232M
  control_files            = "D:\DATABASE\ORADATA\DBA1\CONTROL01.CTL"
  control_files            = "D:\DATABASE\FLASH_RECOVERY_AREA\DBA1\CONTROL02.CTL"
  db_block_size            = 8192
  compatible               = "11.2.0.0.0"
  db_recovery_file_dest    = "D:\database\flash_recovery_area"
  db_recovery_file_dest_size= 3852M
  undo_tablespace          = "UNDOTBS1"
  remote_login_passwordfile= "EXCLUSIVE"
  db_domain                = ""
  dispatchers              = "(PROTOCOL=TCP) (SERVICE=dba1XDB)"
  audit_file_dest          = "D:\DATABASE\ADMIN\DBA1\ADUMP"
  audit_trail              = "DB"
  db_name                  = "dba1"
  open_cursors             = 300
  diagnostic_dest          = "D:\DATABASE"
Mon Sep 18 09:52:22 2017
PMON started with pid=2, OS id=4988 
Mon Sep 18 09:52:22 2017
VKTM started with pid=3, OS id=2980 at elevated priority
OER 7451 in Load Indicator : Error Code = OSD-04500: задан недопустимый параметр !
VKTM running at (10)millisec precision with DBRM quantum (100)ms
Mon Sep 18 09:52:22 2017
GEN0 started with pid=4, OS id=1960 
Mon Sep 18 09:52:22 2017
DIAG started with pid=5, OS id=4692 
Mon Sep 18 09:52:22 2017
DBRM started with pid=6, OS id=4720 
Mon Sep 18 09:52:22 2017
PSP0 started with pid=7, OS id=4740 
Mon Sep 18 09:52:22 2017
DIA0 started with pid=8, OS id=4756 
Mon Sep 18 09:52:22 2017
MMAN started with pid=9, OS id=4780 
Mon Sep 18 09:52:22 2017
DBW0 started with pid=10, OS id=4764 
Mon Sep 18 09:52:22 2017
LGWR started with pid=11, OS id=4760 
Mon Sep 18 09:52:22 2017
CKPT started with pid=12, OS id=4820 
Mon Sep 18 09:52:22 2017
SMON started with pid=13, OS id=4804 
Mon Sep 18 09:52:22 2017
RECO started with pid=14, OS id=4776 
Mon Sep 18 09:52:22 2017
MMON started with pid=15, OS id=4772 
Mon Sep 18 09:52:22 2017
MMNL started with pid=16, OS id=4784 
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
ORACLE_BASE from environment = D:\database
Mon Sep 18 09:52:23 2017
ALTER DATABASE   MOUNT
ORA-214 signalled during: ALTER DATABASE   MOUNT...
Mon Sep 18 10:01:01 2017
Shutting down instance (immediate)
Shutting down instance: further logons disabled
Stopping background process MMNL
Stopping background process MMON
License high water mark = 2
All dispatchers and shared servers shutdown
Mon Sep 18 10:01:14 2017
alter database close normal
ORA-1507 signalled during: alter database close normal...
Mon Sep 18 10:01:14 2017
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on. 
IMODE=BR
ILAT =27
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
Using parameter settings in server-side spfile D:\DATABASE\PRODUCT\11.2.0\DBHOME_1\DATABASE\SPFILEDBA1.ORA
System parameters with non-default values:
  processes                = 150
  memory_target            = 1232M
  control_files            = "D:\DATABASE\ORADATA\DBA1\CONTROL01.CTL"
  control_files            = "D:\DATABASE\FLASH_RECOVERY_AREA\DBA1\CONTROL02.CTL"
  db_block_size            = 8192
  compatible               = "11.2.0.0.0"
  db_recovery_file_dest    = "D:\database\flash_recovery_area"
  db_recovery_file_dest_size= 3852M
  undo_tablespace          = "UNDOTBS1"
  remote_login_passwordfile= "EXCLUSIVE"
  db_domain                = ""
  dispatchers              = "(PROTOCOL=TCP) (SERVICE=dba1XDB)"
  audit_file_dest          = "D:\DATABASE\ADMIN\DBA1\ADUMP"
  audit_trail              = "DB"
  db_name                  = "dba1"
  open_cursors             = 300
  diagnostic_dest          = "D:\DATABASE"
Mon Sep 18 10:01:15 2017
PMON started with pid=2, OS id=1908 
OER 7451 in Load Indicator : Error Code = OSD-04500: задан недопустимый параметр !
Mon Sep 18 10:01:15 2017
VKTM started with pid=3, OS id=1428 at elevated priority
VKTM running at (10)millisec precision with DBRM quantum (100)ms
Mon Sep 18 10:01:15 2017
GEN0 started with pid=4, OS id=2892 
Mon Sep 18 10:01:15 2017
DIAG started with pid=5, OS id=1764 
Mon Sep 18 10:01:15 2017
DBRM started with pid=6, OS id=2944 
Mon Sep 18 10:01:15 2017
PSP0 started with pid=7, OS id=4896 
Mon Sep 18 10:01:15 2017
DIA0 started with pid=8, OS id=3012 
Mon Sep 18 10:01:15 2017
MMAN started with pid=9, OS id=4312 
Mon Sep 18 10:01:15 2017
DBW0 started with pid=10, OS id=320 
Mon Sep 18 10:01:15 2017
LGWR started with pid=11, OS id=4252 
Mon Sep 18 10:01:15 2017
CKPT started with pid=12, OS id=4428 
Mon Sep 18 10:01:15 2017
SMON started with pid=13, OS id=4424 
Mon Sep 18 10:01:15 2017
RECO started with pid=14, OS id=2912 
Mon Sep 18 10:01:15 2017
MMON started with pid=15, OS id=1916 
Mon Sep 18 10:01:15 2017
MMNL started with pid=16, OS id=2996 
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
ORACLE_BASE from environment = D:\database
Mon Sep 18 10:01:15 2017
alter database mount exclusive
ORA-214 signalled during: alter database mount exclusive...
Mon Sep 18 10:03:32 2017
Starting ORACLE instance (normal)
Mon Sep 18 10:04:47 2017
Shutting down instance (abort)
License high water mark = 2
USER (ospid: 4500): terminating the instance
Instance terminated by USER, pid = 4500
Mon Sep 18 10:04:53 2017
Instance shutdown complete
Mon Sep 18 10:05:15 2017
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on. 
IMODE=BR
ILAT =27
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
Using parameter settings in server-side spfile D:\DATABASE\PRODUCT\11.2.0\DBHOME_1\DATABASE\SPFILEDBA1.ORA
System parameters with non-default values:
  processes                = 150
  memory_target            = 1232M
  control_files            = "D:\DATABASE\ORADATA\DBA1\CONTROL01.CTL"
  control_files            = "D:\DATABASE\FLASH_RECOVERY_AREA\DBA1\CONTROL02.CTL"
  db_block_size            = 8192
  compatible               = "11.2.0.0.0"
  db_recovery_file_dest    = "D:\database\flash_recovery_area"
  db_recovery_file_dest_size= 3852M
  undo_tablespace          = "UNDOTBS1"
  remote_login_passwordfile= "EXCLUSIVE"
  db_domain                = ""
  dispatchers              = "(PROTOCOL=TCP) (SERVICE=dba1XDB)"
  audit_file_dest          = "D:\DATABASE\ADMIN\DBA1\ADUMP"
  audit_trail              = "DB"
  db_name                  = "dba1"
  open_cursors             = 300
  diagnostic_dest          = "D:\DATABASE"
Mon Sep 18 10:05:15 2017
PMON started with pid=2, OS id=708 
OER 7451 in Load Indicator : Error Code = OSD-04500: задан недопустимый параметр !
Mon Sep 18 10:05:15 2017
GEN0 started with pid=4, OS id=412 
Mon Sep 18 10:05:15 2017
DIAG started with pid=5, OS id=3120 
Mon Sep 18 10:05:15 2017
DBRM started with pid=6, OS id=1776 
Mon Sep 18 10:05:15 2017
PSP0 started with pid=7, OS id=4580 
Mon Sep 18 10:05:15 2017
DIA0 started with pid=8, OS id=204 
Mon Sep 18 10:05:15 2017
MMAN started with pid=9, OS id=1032 
Mon Sep 18 10:05:15 2017
DBW0 started with pid=10, OS id=2928 
Mon Sep 18 10:05:15 2017
LGWR started with pid=11, OS id=5052 
Mon Sep 18 10:05:15 2017
CKPT started with pid=12, OS id=2280 
Mon Sep 18 10:05:15 2017
SMON started with pid=13, OS id=2356 
Mon Sep 18 10:05:15 2017
RECO started with pid=14, OS id=3616 
Mon Sep 18 10:05:15 2017
MMON started with pid=15, OS id=4680 
Mon Sep 18 10:05:16 2017
MMNL started with pid=16, OS id=1580 
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
ORACLE_BASE from environment = D:\database
Mon Sep 18 10:05:16 2017
ALTER DATABASE   MOUNT
ORA-214 signalled during: ALTER DATABASE   MOUNT...
Mon Sep 18 10:05:15 2017
VKTM started with pid=3, OS id=2896 at elevated priority
VKTM running at (10)millisec precision with DBRM quantum (100)ms
Mon Sep 18 10:43:38 2017
alter database mount
ORA-214 signalled during: alter database mount...
Mon Sep 18 10:53:31 2017


***********************************************************************

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

  VERSION INFORMATION:
	TNS for 32-bit Windows: Version 11.2.0.1.0 - Production
	Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 11.2.0.1.0 - Production
  Time: 18-СЕН-2017 10:53:31
  Tracing not turned on.
  Tns error struct:
    ns main err code: 12638
    
TNS-12638: Сбой при извлечении реквизитов
    ns secondary err code: 0
    nt main err code: 0
    nt secondary err code: 0
    nt OS err code: 0
Mon Sep 18 10:56:24 2017
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on. 
IMODE=BR
ILAT =27
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
Using parameter settings in server-side spfile D:\DATABASE\PRODUCT\11.2.0\DBHOME_1\DATABASE\SPFILEDBA1.ORA
System parameters with non-default values:
  processes                = 150
  memory_target            = 1232M
  control_files            = "D:\DATABASE\ORADATA\DBA1\CONTROL01.CTL"
  control_files            = "D:\DATABASE\FLASH_RECOVERY_AREA\DBA1\CONTROL02.CTL"
  db_block_size            = 8192
  compatible               = "11.2.0.0.0"
  db_recovery_file_dest    = "D:\database\flash_recovery_area"
  db_recovery_file_dest_size= 3852M
  undo_tablespace          = "UNDOTBS1"
  remote_login_passwordfile= "EXCLUSIVE"
  db_domain                = ""
  dispatchers              = "(PROTOCOL=TCP) (SERVICE=dba1XDB)"
  audit_file_dest          = "D:\DATABASE\ADMIN\DBA1\ADUMP"
  audit_trail              = "DB"
  db_name                  = "dba1"
  open_cursors             = 300
  diagnostic_dest          = "D:\DATABASE"
Mon Sep 18 10:56:34 2017
PMON started with pid=2, OS id=3168 
Mon Sep 18 10:56:34 2017
VKTM started with pid=3, OS id=3172 at elevated priority
VKTM running at (10)millisec precision with DBRM quantum (100)ms
Mon Sep 18 10:56:35 2017
GEN0 started with pid=4, OS id=3176 
OER 7451 in Load Indicator : Error Code = OSD-04500: задан недопустимый параметр !
Mon Sep 18 10:56:35 2017
DIAG started with pid=5, OS id=3180 
Mon Sep 18 10:56:35 2017
DBRM started with pid=6, OS id=3184 
Mon Sep 18 10:56:35 2017
PSP0 started with pid=7, OS id=3188 
Mon Sep 18 10:56:35 2017
DIA0 started with pid=8, OS id=3192 
Mon Sep 18 10:56:35 2017
MMAN started with pid=9, OS id=3196 
Mon Sep 18 10:56:35 2017
DBW0 started with pid=10, OS id=3200 
Mon Sep 18 10:56:35 2017
LGWR started with pid=11, OS id=3204 
Mon Sep 18 10:56:35 2017
CKPT started with pid=12, OS id=3208 
Mon Sep 18 10:56:35 2017
SMON started with pid=13, OS id=3212 
Mon Sep 18 10:56:35 2017
RECO started with pid=14, OS id=3216 
Mon Sep 18 10:56:35 2017
MMON started with pid=15, OS id=3220 
Mon Sep 18 10:56:35 2017
MMNL started with pid=16, OS id=3224 
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
ORACLE_BASE from environment = D:\database
Mon Sep 18 10:56:37 2017
alter database mount exclusive
ORA-214 signalled during: alter database mount exclusive...
Mon Sep 18 11:00:47 2017
Shutting down instance (abort)
License high water mark = 1
USER (ospid: 4612): terminating the instance
Instance terminated by USER, pid = 4612
Mon Sep 18 11:00:52 2017
Instance shutdown complete
Mon Sep 18 11:01:22 2017
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on. 
IMODE=BR
ILAT =27
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
Using parameter settings in server-side spfile D:\DATABASE\PRODUCT\11.2.0\DBHOME_1\DATABASE\SPFILEDBA1.ORA
System parameters with non-default values:
  processes                = 150
  memory_target            = 1232M
  control_files            = "D:\DATABASE\ORADATA\DBA1\CONTROL01.CTL"
  control_files            = "D:\DATABASE\FLASH_RECOVERY_AREA\DBA1\CONTROL02.CTL"
  db_block_size            = 8192
  compatible               = "11.2.0.0.0"
  db_recovery_file_dest    = "D:\database\flash_recovery_area"
  db_recovery_file_dest_size= 3852M
  undo_tablespace          = "UNDOTBS1"
  remote_login_passwordfile= "EXCLUSIVE"
  db_domain                = ""
  dispatchers              = "(PROTOCOL=TCP) (SERVICE=dba1XDB)"
  audit_file_dest          = "D:\DATABASE\ADMIN\DBA1\ADUMP"
  audit_trail              = "DB"
  db_name                  = "dba1"
  open_cursors             = 300
  diagnostic_dest          = "D:\DATABASE"
Mon Sep 18 11:01:23 2017
PMON started with pid=2, OS id=4828 
Mon Sep 18 11:01:23 2017
VKTM started with pid=3, OS id=5036 at elevated priority
OER 7451 in Load Indicator : Error Code = OSD-04500: задан недопустимый параметр !
VKTM running at (10)millisec precision with DBRM quantum (100)ms
Mon Sep 18 11:01:23 2017
GEN0 started with pid=4, OS id=4748 
Mon Sep 18 11:01:23 2017
DIAG started with pid=5, OS id=4840 
Mon Sep 18 11:01:23 2017
DBRM started with pid=6, OS id=4844 
Mon Sep 18 11:01:23 2017
PSP0 started with pid=7, OS id=4832 
Mon Sep 18 11:01:23 2017
DIA0 started with pid=8, OS id=1468 
Mon Sep 18 11:01:23 2017
MMAN started with pid=9, OS id=4688 
Mon Sep 18 11:01:23 2017
DBW0 started with pid=10, OS id=4684 
Mon Sep 18 11:01:23 2017
LGWR started with pid=11, OS id=5060 
Mon Sep 18 11:01:23 2017
CKPT started with pid=12, OS id=4924 
Mon Sep 18 11:01:23 2017
SMON started with pid=13, OS id=5080 
Mon Sep 18 11:01:23 2017
RECO started with pid=14, OS id=4680 
Mon Sep 18 11:01:23 2017
MMON started with pid=15, OS id=4948 
Mon Sep 18 11:01:23 2017
MMNL started with pid=16, OS id=4952 
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
ORACLE_BASE from environment = D:\database
Mon Sep 18 11:01:24 2017
ALTER DATABASE   MOUNT
ORA-214 signalled during: ALTER DATABASE   MOUNT...
Mon Sep 18 11:23:35 2017
alter database open resetlogs
ORA-1507 signalled during: alter database open resetlogs...
Mon Sep 18 11:38:47 2017
ALTER SYSTEM SET control_files='d:\database\oradata\dba1\control01.ctl' SCOPE=SPFILE;
Mon Sep 18 11:39:14 2017
Shutting down instance (immediate)
Shutting down instance: further logons disabled
Stopping background process MMNL
Stopping background process MMON
License high water mark = 2
All dispatchers and shared servers shutdown
ALTER DATABASE CLOSE NORMAL
ORA-1507 signalled during: ALTER DATABASE CLOSE NORMAL...
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
Mon Sep 18 11:39:16 2017
Stopping background process VKTM: 
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Mon Sep 18 11:39:18 2017
Instance shutdown complete
Mon Sep 18 11:39:33 2017
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on. 
IMODE=BR
ILAT =27
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
Using parameter settings in server-side spfile D:\DATABASE\PRODUCT\11.2.0\DBHOME_1\DATABASE\SPFILEDBA1.ORA
System parameters with non-default values:
  processes                = 150
  memory_target            = 1232M
  control_files            = "D:\DATABASE\ORADATA\DBA1\CONTROL01.CTL"
  db_block_size            = 8192
  compatible               = "11.2.0.0.0"
  db_recovery_file_dest    = "D:\database\flash_recovery_area"
  db_recovery_file_dest_size= 3852M
  undo_tablespace          = "UNDOTBS1"
  remote_login_passwordfile= "EXCLUSIVE"
  db_domain                = ""
  dispatchers              = "(PROTOCOL=TCP) (SERVICE=dba1XDB)"
  audit_file_dest          = "D:\DATABASE\ADMIN\DBA1\ADUMP"
  audit_trail              = "DB"
  db_name                  = "dba1"
  open_cursors             = 300
  diagnostic_dest          = "D:\DATABASE"
Mon Sep 18 11:39:34 2017
PMON started with pid=2, OS id=1884 
Mon Sep 18 11:39:34 2017
VKTM started with pid=3, OS id=4892 at elevated priority
VKTM running at (10)millisec precision with DBRM quantum (100)ms
Mon Sep 18 11:39:34 2017
GEN0 started with pid=4, OS id=792 
Mon Sep 18 11:39:34 2017
DIAG started with pid=5, OS id=4632 
Mon Sep 18 11:39:34 2017
DBRM started with pid=6, OS id=4664 
Mon Sep 18 11:39:34 2017
PSP0 started with pid=7, OS id=4920 
Mon Sep 18 11:39:34 2017
DIA0 started with pid=8, OS id=3020 
Mon Sep 18 11:39:34 2017
MMAN started with pid=9, OS id=4404 
Mon Sep 18 11:39:34 2017
DBW0 started with pid=10, OS id=2952 
Mon Sep 18 11:39:34 2017
LGWR started with pid=11, OS id=2376 
Mon Sep 18 11:39:34 2017
CKPT started with pid=12, OS id=2172 
Mon Sep 18 11:39:34 2017
SMON started with pid=13, OS id=4608 
Mon Sep 18 11:39:34 2017
RECO started with pid=14, OS id=3676 
Mon Sep 18 11:39:34 2017
MMON started with pid=15, OS id=4392 
Mon Sep 18 11:39:34 2017
MMNL started with pid=16, OS id=4712 
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
ORACLE_BASE from environment = D:\database
Mon Sep 18 11:39:34 2017
ALTER DATABASE   MOUNT
OER 7451 in Load Indicator : Error Code = OSD-04500: задан недопустимый параметр !
Successful mount of redo thread 1, with mount id 2265417398
Database mounted in Exclusive Mode
Lost write protection disabled
Completed: ALTER DATABASE   MOUNT
Mon Sep 18 11:40:35 2017
alter database open
Beginning crash recovery of 1 threads
 parallel recovery started with 2 processes
Started redo scan
Errors in file d:\database\diag\rdbms\dba1\dba1\trace\dba1_ora_1908.trc:
ORA-00322: протокол 2 процесса 1 не является текущей копией
ORA-00312: оперативный протокол 2 процесса 1: 'D:\DATABASE\ORADATA\DBA1\REDO02.LOG'
Mon Sep 18 11:40:36 2017
Errors in file d:\database\diag\rdbms\dba1\dba1\trace\dba1_m000_4772.trc:
ORA-00322: log 1 of thread 1 is not current copy
ORA-00312: online log 1 thread 1: 'D:\DATABASE\ORADATA\DBA1\REDO01.LOG'
Aborting crash recovery due to error 322
Errors in file d:\database\diag\rdbms\dba1\dba1\trace\dba1_ora_1908.trc:
ORA-00322: протокол 2 процесса 1 не является текущей копией
ORA-00312: оперативный протокол 2 процесса 1: 'D:\DATABASE\ORADATA\DBA1\REDO02.LOG'
Errors in file d:\database\diag\rdbms\dba1\dba1\trace\dba1_ora_1908.trc:
ORA-00322: протокол 2 процесса 1 не является текущей копией
ORA-00312: оперативный протокол 2 процесса 1: 'D:\DATABASE\ORADATA\DBA1\REDO02.LOG'
ORA-322 signalled during: alter database open...
Errors in file d:\database\diag\rdbms\dba1\dba1\trace\dba1_m000_4772.trc:
ORA-00322: log 2 of thread 1 is not current copy
ORA-00312: online log 2 thread 1: 'D:\DATABASE\ORADATA\DBA1\REDO02.LOG'
Checker run found 4 new persistent data failures
Mon Sep 18 11:46:05 2017
Starting ORACLE instance (normal)
Mon Sep 18 11:52:28 2017
Starting ORACLE instance (normal)
Mon Sep 18 11:52:37 2017
Starting ORACLE instance (normal)
Mon Sep 18 11:52:48 2017
Starting ORACLE instance (normal)
Mon Sep 18 11:53:18 2017
Shutting down instance (immediate)
Shutting down instance: further logons disabled
Stopping background process MMNL
Stopping background process MMON
License high water mark = 3
All dispatchers and shared servers shutdown
ALTER DATABASE CLOSE NORMAL
ORA-1109 signalled during: ALTER DATABASE CLOSE NORMAL...
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
Mon Sep 18 11:53:26 2017
Stopping background process VKTM: 
Mon Sep 18 11:53:28 2017
Instance shutdown complete
Mon Sep 18 11:53:36 2017
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on. 
IMODE=BR
ILAT =27
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
Using parameter settings in server-side spfile D:\DATABASE\PRODUCT\11.2.0\DBHOME_1\DATABASE\SPFILEDBA1.ORA
System parameters with non-default values:
  processes                = 150
  memory_target            = 1232M
  control_files            = "D:\DATABASE\ORADATA\DBA1\CONTROL01.CTL"
  db_block_size            = 8192
  compatible               = "11.2.0.0.0"
  db_recovery_file_dest    = "D:\database\flash_recovery_area"
  db_recovery_file_dest_size= 3852M
  undo_tablespace          = "UNDOTBS1"
  remote_login_passwordfile= "EXCLUSIVE"
  db_domain                = ""
  dispatchers              = "(PROTOCOL=TCP) (SERVICE=dba1XDB)"
  audit_file_dest          = "D:\DATABASE\ADMIN\DBA1\ADUMP"
  audit_trail              = "DB"
  db_name                  = "dba1"
  open_cursors             = 300
  diagnostic_dest          = "D:\DATABASE"
Mon Sep 18 11:53:36 2017
PMON started with pid=2, OS id=816 
OER 7451 in Load Indicator : Error Code = OSD-04500: задан недопустимый параметр !
Mon Sep 18 11:53:36 2017
GEN0 started with pid=4, OS id=3184 
Mon Sep 18 11:53:36 2017
DIAG started with pid=5, OS id=3908 
Mon Sep 18 11:53:36 2017
DBRM started with pid=6, OS id=5012 
Mon Sep 18 11:53:36 2017
PSP0 started with pid=7, OS id=3564 
Mon Sep 18 11:53:36 2017
DIA0 started with pid=8, OS id=3172 
Mon Sep 18 11:53:36 2017
MMAN started with pid=9, OS id=4556 
Mon Sep 18 11:53:36 2017
DBW0 started with pid=10, OS id=4452 
Mon Sep 18 11:53:36 2017
LGWR started with pid=11, OS id=4988 
Mon Sep 18 11:53:36 2017
CKPT started with pid=12, OS id=368 
Mon Sep 18 11:53:36 2017
SMON started with pid=13, OS id=2896 
Mon Sep 18 11:53:36 2017
RECO started with pid=14, OS id=4072 
Mon Sep 18 11:53:36 2017
MMON started with pid=15, OS id=3252 
Mon Sep 18 11:53:36 2017
MMNL started with pid=16, OS id=4872 
Mon Sep 18 11:53:36 2017
VKTM started with pid=3, OS id=812 at elevated priority
VKTM running at (10)millisec precision with DBRM quantum (100)ms
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
ORACLE_BASE from environment = D:\database
Mon Sep 18 11:53:37 2017
ALTER DATABASE   MOUNT
Successful mount of redo thread 1, with mount id 2265442305
Database mounted in Exclusive Mode
Lost write protection disabled
Completed: ALTER DATABASE   MOUNT
Mon Sep 18 11:58:08 2017
Shutting down instance (abort)
License high water mark = 2
USER (ospid: 4928): terminating the instance
Instance terminated by USER, pid = 4928
Mon Sep 18 11:58:09 2017
Instance shutdown complete
Mon Sep 18 11:58:25 2017
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on. 
IMODE=BR
ILAT =27
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
Using parameter settings in server-side spfile D:\DATABASE\PRODUCT\11.2.0\DBHOME_1\DATABASE\SPFILEDBA1.ORA
System parameters with non-default values:
  processes                = 150
  memory_target            = 1232M
  control_files            = "D:\DATABASE\ORADATA\DBA1\CONTROL01.CTL"
  db_block_size            = 8192
  compatible               = "11.2.0.0.0"
  db_recovery_file_dest    = "D:\database\flash_recovery_area"
  db_recovery_file_dest_size= 3852M
  undo_tablespace          = "UNDOTBS1"
  remote_login_passwordfile= "EXCLUSIVE"
  db_domain                = ""
  dispatchers              = "(PROTOCOL=TCP) (SERVICE=dba1XDB)"
  audit_file_dest          = "D:\DATABASE\ADMIN\DBA1\ADUMP"
  audit_trail              = "DB"
  db_name                  = "dba1"
  open_cursors             = 300
  diagnostic_dest          = "D:\DATABASE"
Mon Sep 18 11:58:25 2017
PMON started with pid=2, OS id=4372 
OER 7451 in Load Indicator : Error Code = OSD-04500: задан недопустимый параметр !
Mon Sep 18 11:58:25 2017
GEN0 started with pid=4, OS id=2168 
Mon Sep 18 11:58:25 2017
DIAG started with pid=5, OS id=3976 
Mon Sep 18 11:58:25 2017
DBRM started with pid=6, OS id=5088 
Mon Sep 18 11:58:25 2017
PSP0 started with pid=7, OS id=2856 
Mon Sep 18 11:58:25 2017
DIA0 started with pid=8, OS id=2692 
Mon Sep 18 11:58:25 2017
MMAN started with pid=9, OS id=4048 
Mon Sep 18 11:58:25 2017
DBW0 started with pid=10, OS id=3604 
Mon Sep 18 11:58:25 2017
LGWR started with pid=11, OS id=392 
Mon Sep 18 11:58:25 2017
CKPT started with pid=12, OS id=3176 
Mon Sep 18 11:58:25 2017
SMON started with pid=13, OS id=980 
Mon Sep 18 11:58:25 2017
RECO started with pid=14, OS id=3332 
Mon Sep 18 11:58:25 2017
MMON started with pid=15, OS id=3556 
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
ORACLE_BASE from environment = D:\database
Mon Sep 18 11:58:25 2017
ALTER DATABASE   MOUNT
Mon Sep 18 11:58:25 2017
VKTM started with pid=3, OS id=4684 at elevated priority
VKTM running at (10)millisec precision with DBRM quantum (100)ms
Mon Sep 18 11:58:25 2017
MMNL started with pid=16, OS id=440 
Successful mount of redo thread 1, with mount id 2265418017
Database mounted in Exclusive Mode
Lost write protection disabled
Completed: ALTER DATABASE   MOUNT
Mon Sep 18 11:59:05 2017
alter database open resetlogs
ORA-1139 signalled during: alter database open resetlogs...
Mon Sep 18 12:04:29 2017
ALTER DATABASE RECOVER  database until cancel  
Media Recovery Start
 started logmerger process
Parallel Media Recovery started with 2 slaves
ORA-279 signalled during: ALTER DATABASE RECOVER  database until cancel  ...
Mon Sep 18 12:04:57 2017
ALTER DATABASE RECOVER    LOGFILE 'alter'  
Media Recovery Log alter
Mon Sep 18 12:04:57 2017
Errors with log alter
Errors in file d:\database\diag\rdbms\dba1\dba1\trace\dba1_pr00_5080.trc:
ORA-00308: cannot open archived log 'alter'
ORA-27041: unable to open file
OSD-04002: невозможно открыть файл
O/S-Error: (OS 2) Не удается найти указанный файл.
ORA-308 signalled during: ALTER DATABASE RECOVER    LOGFILE 'alter'  ...
Mon Sep 18 12:05:26 2017
ALTER DATABASE RECOVER    CONTINUE DEFAULT  
Media Recovery Log D:\DATABASE\FLASH_RECOVERY_AREA\DBA1\ARCHIVELOG\2017_09_18\O1_MF_1_1667_%U_.ARC
Mon Sep 18 12:05:26 2017
Errors with log D:\DATABASE\FLASH_RECOVERY_AREA\DBA1\ARCHIVELOG\2017_09_18\O1_MF_1_1667_%U_.ARC
Errors in file d:\database\diag\rdbms\dba1\dba1\trace\dba1_pr00_5080.trc:
ORA-00308: cannot open archived log 'D:\DATABASE\FLASH_RECOVERY_AREA\DBA1\ARCHIVELOG\2017_09_18\O1_MF_1_1667_%U_.ARC'
ORA-27041: unable to open file
OSD-04002: невозможно открыть файл
O/S-Error: (OS 2) Не удается найти указанный файл.
ORA-308 signalled during: ALTER DATABASE RECOVER    CONTINUE DEFAULT  ...
ALTER DATABASE RECOVER    CONTINUE DEFAULT  
Media Recovery Log D:\DATABASE\FLASH_RECOVERY_AREA\DBA1\ARCHIVELOG\2017_09_18\O1_MF_1_1667_%U_.ARC
Errors with log D:\DATABASE\FLASH_RECOVERY_AREA\DBA1\ARCHIVELOG\2017_09_18\O1_MF_1_1667_%U_.ARC
Errors in file d:\database\diag\rdbms\dba1\dba1\trace\dba1_pr00_5080.trc:
ORA-00308: cannot open archived log 'D:\DATABASE\FLASH_RECOVERY_AREA\DBA1\ARCHIVELOG\2017_09_18\O1_MF_1_1667_%U_.ARC'
ORA-27041: unable to open file
OSD-04002: невозможно открыть файл
O/S-Error: (OS 2) Не удается найти указанный файл.
ORA-308 signalled during: ALTER DATABASE RECOVER    CONTINUE DEFAULT  ...
ALTER DATABASE RECOVER CANCEL 
Mon Sep 18 12:05:28 2017
Errors in file d:\database\diag\rdbms\dba1\dba1\trace\dba1_m000_564.trc:
ORA-00322: log 1 of thread 1 is not current copy
ORA-00312: online log 1 thread 1: 'D:\DATABASE\ORADATA\DBA1\REDO01.LOG'
Errors in file d:\database\diag\rdbms\dba1\dba1\trace\dba1_pr00_5080.trc:
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: 'D:\DATABASE\ORADATA\DBA1\SYSTEM01.DBF'
ORA-10879 signalled during: ALTER DATABASE RECOVER CANCEL ...
Errors in file d:\database\diag\rdbms\dba1\dba1\trace\dba1_m000_564.trc:
ORA-00322: log 2 of thread 1 is not current copy
ORA-00312: online log 2 thread 1: 'D:\DATABASE\ORADATA\DBA1\REDO02.LOG'
Checker run found 10 new persistent data failures
Mon Sep 18 12:06:26 2017
Shutting down instance (abort)
License high water mark = 4
USER (ospid: 2788): terminating the instance
Instance terminated by USER, pid = 2788
Mon Sep 18 12:06:31 2017
Instance shutdown complete
Mon Sep 18 12:07:03 2017
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on. 
IMODE=BR
ILAT =27
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
Using parameter settings in server-side spfile D:\DATABASE\PRODUCT\11.2.0\DBHOME_1\DATABASE\SPFILEDBA1.ORA
System parameters with non-default values:
  processes                = 150
  memory_target            = 1232M
  control_files            = "D:\DATABASE\ORADATA\DBA1\CONTROL01.CTL"
  db_block_size            = 8192
  compatible               = "11.2.0.0.0"
  db_recovery_file_dest    = "D:\database\flash_recovery_area"
  db_recovery_file_dest_size= 3852M
  undo_tablespace          = "UNDOTBS1"
  remote_login_passwordfile= "EXCLUSIVE"
  db_domain                = ""
  dispatchers              = "(PROTOCOL=TCP) (SERVICE=dba1XDB)"
  audit_file_dest          = "D:\DATABASE\ADMIN\DBA1\ADUMP"
  audit_trail              = "DB"
  db_name                  = "dba1"
  open_cursors             = 300
  diagnostic_dest          = "D:\DATABASE"
Mon Sep 18 12:07:03 2017
PMON started with pid=2, OS id=4996 
OER 7451 in Load Indicator : Error Code = OSD-04500: задан недопустимый параметр !
Mon Sep 18 12:07:03 2017
VKTM started with pid=3, OS id=3228 at elevated priority
VKTM running at (10)millisec precision with DBRM quantum (100)ms
Mon Sep 18 12:07:03 2017
GEN0 started with pid=4, OS id=3608 
Mon Sep 18 12:07:03 2017
DIAG started with pid=5, OS id=2112 
Mon Sep 18 12:07:03 2017
DBRM started with pid=6, OS id=5044 
Mon Sep 18 12:07:03 2017
PSP0 started with pid=7, OS id=5008 
Mon Sep 18 12:07:03 2017
DIA0 started with pid=8, OS id=1484 
Mon Sep 18 12:07:03 2017
MMAN started with pid=9, OS id=5064 
Mon Sep 18 12:07:03 2017
DBW0 started with pid=10, OS id=3344 
Mon Sep 18 12:07:03 2017
LGWR started with pid=11, OS id=3192 
Mon Sep 18 12:07:03 2017
CKPT started with pid=12, OS id=3404 
Mon Sep 18 12:07:03 2017
SMON started with pid=13, OS id=3728 
Mon Sep 18 12:07:03 2017
RECO started with pid=14, OS id=3216 
Mon Sep 18 12:07:03 2017
MMON started with pid=15, OS id=3140 
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Mon Sep 18 12:07:03 2017
MMNL started with pid=16, OS id=400 
starting up 1 shared server(s) ...
ORACLE_BASE from environment = D:\database
Mon Sep 18 12:07:03 2017
ALTER DATABASE   MOUNT
Successful mount of redo thread 1, with mount id 2265453607
Database mounted in Exclusive Mode
Lost write protection disabled
Completed: ALTER DATABASE   MOUNT
Mon Sep 18 12:07:25 2017
alter database open resetlogs
ORA-1194 signalled during: alter database open resetlogs...
Mon Sep 18 12:07:25 2017
Errors in file d:\database\diag\rdbms\dba1\dba1\trace\dba1_m000_3800.trc:
ORA-00322: log 1 of thread 1 is not current copy
ORA-00312: online log 1 thread 1: 'D:\DATABASE\ORADATA\DBA1\REDO01.LOG'
Errors in file d:\database\diag\rdbms\dba1\dba1\trace\dba1_m000_3800.trc:
ORA-00322: log 2 of thread 1 is not current copy
ORA-00312: online log 2 thread 1: 'D:\DATABASE\ORADATA\DBA1\REDO02.LOG'
Mon Sep 18 12:13:26 2017
alter database open resetlogs
ORA-1194 signalled during: alter database open resetlogs...
Mon Sep 18 12:13:27 2017
Errors in file d:\database\diag\rdbms\dba1\dba1\trace\dba1_m000_1172.trc:
ORA-00322: log 1 of thread 1 is not current copy
ORA-00312: online log 1 thread 1: 'D:\DATABASE\ORADATA\DBA1\REDO01.LOG'
Errors in file d:\database\diag\rdbms\dba1\dba1\trace\dba1_m000_1172.trc:
ORA-00322: log 2 of thread 1 is not current copy
ORA-00312: online log 2 thread 1: 'D:\DATABASE\ORADATA\DBA1\REDO02.LOG'
Mon Sep 18 12:23:50 2017
db_recovery_file_dest_size of 3852 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.
Mon Sep 18 12:31:42 2017


***********************************************************************

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

  VERSION INFORMATION:
	TNS for 32-bit Windows: Version 11.2.0.1.0 - Production
	Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 11.2.0.1.0 - Production
  Time: 18-СЕН-2017 12:31:44
  Tracing not turned on.
  Tns error struct:
    ns main err code: 12638
    
TNS-12638: Сбой при извлечении реквизитов
    ns secondary err code: 0
    nt main err code: 0
    nt secondary err code: 0
    nt OS err code: 0
Mon Sep 18 12:32:29 2017
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on. 
IMODE=BR
ILAT =27
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
Using parameter settings in server-side spfile D:\DATABASE\PRODUCT\11.2.0\DBHOME_1\DATABASE\SPFILEDBA1.ORA
System parameters with non-default values:
  processes                = 150
  memory_target            = 1232M
  control_files            = "D:\DATABASE\ORADATA\DBA1\CONTROL01.CTL"
  db_block_size            = 8192
  compatible               = "11.2.0.0.0"
  db_recovery_file_dest    = "D:\database\flash_recovery_area"
  db_recovery_file_dest_size= 3852M
  undo_tablespace          = "UNDOTBS1"
  remote_login_passwordfile= "EXCLUSIVE"
  db_domain                = ""
  dispatchers              = "(PROTOCOL=TCP) (SERVICE=dba1XDB)"
  audit_file_dest          = "D:\DATABASE\ADMIN\DBA1\ADUMP"
  audit_trail              = "DB"
  db_name                  = "dba1"
  open_cursors             = 300
  diagnostic_dest          = "D:\DATABASE"
Mon Sep 18 12:32:34 2017
PMON started with pid=2, OS id=2168 
Mon Sep 18 12:32:34 2017
VKTM started with pid=3, OS id=2172 at elevated priority
VKTM running at (10)millisec precision with DBRM quantum (100)ms
Mon Sep 18 12:32:34 2017
GEN0 started with pid=4, OS id=2176 
OER 7451 in Load Indicator : Error Code = OSD-04500: задан недопустимый параметр !
Mon Sep 18 12:32:34 2017
DIAG started with pid=5, OS id=2180 
Mon Sep 18 12:32:34 2017
DBRM started with pid=6, OS id=2184 
Mon Sep 18 12:32:34 2017
PSP0 started with pid=7, OS id=2188 
Mon Sep 18 12:32:34 2017
DIA0 started with pid=8, OS id=2192 
Mon Sep 18 12:32:34 2017
MMAN started with pid=9, OS id=2196 
Mon Sep 18 12:32:34 2017
DBW0 started with pid=10, OS id=2200 
Mon Sep 18 12:32:34 2017
LGWR started with pid=11, OS id=2204 
Mon Sep 18 12:32:34 2017
CKPT started with pid=12, OS id=2208 
Mon Sep 18 12:32:34 2017
SMON started with pid=13, OS id=2212 
Mon Sep 18 12:32:34 2017
RECO started with pid=14, OS id=2216 
Mon Sep 18 12:32:34 2017
MMON started with pid=15, OS id=2220 
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Mon Sep 18 12:32:34 2017
MMNL started with pid=16, OS id=2224 
starting up 1 shared server(s) ...
ORACLE_BASE from environment = D:\database
Mon Sep 18 12:32:36 2017
alter database mount exclusive
Successful mount of redo thread 1, with mount id 2265404964
Database mounted in Exclusive Mode
Lost write protection disabled
Completed: alter database mount exclusive
alter database open
Errors in file d:\database\diag\rdbms\dba1\dba1\trace\dba1_ora_2240.trc:
ORA-01589: ??? ???????? ?? ?????? ???? ???????????? ????????? RESETLOGS ??? NORESETLOGS
ORA-1589 signalled during: alter database open...
Mon Sep 18 12:44:42 2017
Starting ORACLE instance (normal)
Mon Sep 18 12:45:08 2017
alter database open
Errors in file d:\database\diag\rdbms\dba1\dba1\trace\dba1_ora_4628.trc:
ORA-01589: для открытия БД должны быть использованы параметры RESETLOGS или NORESETLOGS
ORA-1589 signalled during: alter database open...
Mon Sep 18 12:47:06 2017
db_recovery_file_dest_size of 3852 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.
Mon Sep 18 12:48:16 2017
Starting ORACLE instance (normal)
Mon Sep 18 12:48:53 2017
alter database open
Errors in file d:\database\diag\rdbms\dba1\dba1\trace\dba1_ora_2752.trc:
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
ORA-1589 signalled during: alter database open...
Mon Sep 18 12:50:33 2017
Shutting down instance (normal)
Shutting down instance: further logons disabled
Stopping background process MMNL
Stopping background process MMON
License high water mark = 2
All dispatchers and shared servers shutdown
ALTER DATABASE CLOSE NORMAL
ORA-1109 signalled during: ALTER DATABASE CLOSE NORMAL...
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archival disabled due to shutdown: 1090
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archival disabled due to shutdown: 1090
Mon Sep 18 12:50:41 2017
Stopping background process VKTM: 
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Mon Sep 18 12:50:45 2017
Instance shutdown complete
Mon Sep 18 12:50:53 2017
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on. 
IMODE=BR
ILAT =27
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
Using parameter settings in server-side spfile D:\DATABASE\PRODUCT\11.2.0\DBHOME_1\DATABASE\SPFILEDBA1.ORA
System parameters with non-default values:
  processes                = 150
  memory_target            = 1232M
  control_files            = "D:\DATABASE\ORADATA\DBA1\CONTROL01.CTL"
  db_block_size            = 8192
  compatible               = "11.2.0.0.0"
  db_recovery_file_dest    = "D:\database\flash_recovery_area"
  db_recovery_file_dest_size= 3852M
  undo_tablespace          = "UNDOTBS1"
  remote_login_passwordfile= "EXCLUSIVE"
  db_domain                = ""
  dispatchers              = "(PROTOCOL=TCP) (SERVICE=dba1XDB)"
  audit_file_dest          = "D:\DATABASE\ADMIN\DBA1\ADUMP"
  audit_trail              = "DB"
  db_name                  = "dba1"
  open_cursors             = 300
  diagnostic_dest          = "D:\DATABASE"
Mon Sep 18 12:50:53 2017
PMON started with pid=2, OS id=4264 
Mon Sep 18 12:50:53 2017
VKTM started with pid=3, OS id=4204 at elevated priority
VKTM running at (10)millisec precision with DBRM quantum (100)ms
OER 7451 in Load Indicator : Error Code = OSD-04500: задан недопустимый параметр !
Mon Sep 18 12:50:54 2017
GEN0 started with pid=4, OS id=4960 
Mon Sep 18 12:50:54 2017
DIAG started with pid=5, OS id=4736 
Mon Sep 18 12:50:54 2017
DBRM started with pid=6, OS id=2564 
Mon Sep 18 12:50:54 2017
PSP0 started with pid=7, OS id=3880 
Mon Sep 18 12:50:54 2017
DIA0 started with pid=8, OS id=4884 
Mon Sep 18 12:50:54 2017
MMAN started with pid=9, OS id=4336 
Mon Sep 18 12:50:54 2017
DBW0 started with pid=10, OS id=4904 
Mon Sep 18 12:50:54 2017
LGWR started with pid=11, OS id=428 
Mon Sep 18 12:50:54 2017
CKPT started with pid=12, OS id=3592 
Mon Sep 18 12:50:54 2017
SMON started with pid=13, OS id=3780 
Mon Sep 18 12:50:54 2017
RECO started with pid=14, OS id=4192 
Mon Sep 18 12:50:54 2017
MMON started with pid=15, OS id=3796 
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
ORACLE_BASE from environment = D:\database
Mon Sep 18 12:50:54 2017
ALTER DATABASE   MOUNT
Mon Sep 18 12:50:54 2017
MMNL started with pid=16, OS id=288 
Successful mount of redo thread 1, with mount id 2265444462
Database mounted in Exclusive Mode
Lost write protection disabled
Completed: ALTER DATABASE   MOUNT
Mon Sep 18 12:50:58 2017
ALTER DATABASE OPEN
Errors in file d:\database\diag\rdbms\dba1\dba1\trace\dba1_ora_4544.trc:
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
ORA-1589 signalled during: ALTER DATABASE OPEN...
Mon Sep 18 12:57:16 2017
Shutting down instance (abort)
License high water mark = 1
USER (ospid: 4544): terminating the instance
Instance terminated by USER, pid = 4544
Mon Sep 18 12:57:17 2017
Instance shutdown complete
Mon Sep 18 12:59:33 2017
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on. 
IMODE=BR
ILAT =27
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
Using parameter settings in server-side spfile D:\DATABASE\PRODUCT\11.2.0\DBHOME_1\DATABASE\SPFILEDBA1.ORA
System parameters with non-default values:
  processes                = 150
  memory_target            = 1232M
  control_files            = "D:\DATABASE\ORADATA\DBA1\CONTROL01.CTL"
  db_block_size            = 8192
  compatible               = "11.2.0.0.0"
  db_recovery_file_dest    = "D:\database\flash_recovery_area"
  db_recovery_file_dest_size= 3852M
  undo_tablespace          = "UNDOTBS1"
  remote_login_passwordfile= "EXCLUSIVE"
  db_domain                = ""
  dispatchers              = "(PROTOCOL=TCP) (SERVICE=dba1XDB)"
  audit_file_dest          = "D:\DATABASE\ADMIN\DBA1\ADUMP"
  audit_trail              = "DB"
  db_name                  = "dba1"
  open_cursors             = 300
  diagnostic_dest          = "D:\DATABASE"
Mon Sep 18 12:59:34 2017
PMON started with pid=2, OS id=4992 
OER 7451 in Load Indicator : Error Code = OSD-04500: задан недопустимый параметр !
Mon Sep 18 12:59:34 2017
VKTM started with pid=3, OS id=3600 at elevated priority
VKTM running at (10)millisec precision with DBRM quantum (100)ms
Mon Sep 18 12:59:34 2017
GEN0 started with pid=4, OS id=4628 
Mon Sep 18 12:59:34 2017
DIAG started with pid=5, OS id=3004 
Mon Sep 18 12:59:34 2017
DBRM started with pid=6, OS id=4696 
Mon Sep 18 12:59:34 2017
PSP0 started with pid=7, OS id=3788 
Mon Sep 18 12:59:34 2017
DIA0 started with pid=8, OS id=3736 
Mon Sep 18 12:59:34 2017
MMAN started with pid=9, OS id=4180 
Mon Sep 18 12:59:34 2017
DBW0 started with pid=10, OS id=4656 
Mon Sep 18 12:59:34 2017
LGWR started with pid=11, OS id=4476 
Mon Sep 18 12:59:34 2017
CKPT started with pid=12, OS id=3836 
Mon Sep 18 12:59:34 2017
SMON started with pid=13, OS id=1220 
Mon Sep 18 12:59:34 2017
RECO started with pid=14, OS id=3468 
Mon Sep 18 12:59:34 2017
MMON started with pid=15, OS id=4684 
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Mon Sep 18 12:59:34 2017
MMNL started with pid=16, OS id=1704 
starting up 1 shared server(s) ...
ORACLE_BASE from environment = D:\database
Mon Sep 18 12:59:34 2017
ALTER DATABASE   MOUNT
Successful mount of redo thread 1, with mount id 2265456502
Database mounted in Exclusive Mode
Lost write protection disabled
Completed: ALTER DATABASE   MOUNT
Mon Sep 18 13:03:42 2017
alter database open
Errors in file d:\database\diag\rdbms\dba1\dba1\trace\dba1_ora_4152.trc:
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
ORA-1589 signalled during: alter database open...
Mon Sep 18 13:08:17 2017
Shutting down instance (immediate)
Shutting down instance: further logons disabled
Stopping background process MMNL
Stopping background process MMON
License high water mark = 1
All dispatchers and shared servers shutdown
ALTER DATABASE CLOSE NORMAL
ORA-1109 signalled during: ALTER DATABASE CLOSE NORMAL...
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
Mon Sep 18 13:08:20 2017
Stopping background process VKTM: 
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Mon Sep 18 13:08:22 2017
Instance shutdown complete
Mon Sep 18 13:08:36 2017
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on. 
IMODE=BR
ILAT =27
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
Using parameter settings in server-side spfile D:\DATABASE\PRODUCT\11.2.0\DBHOME_1\DATABASE\SPFILEDBA1.ORA
System parameters with non-default values:
  processes                = 150
  memory_target            = 1232M
  control_files            = "D:\DATABASE\ORADATA\DBA1\CONTROL01.CTL"
  db_block_size            = 8192
  compatible               = "11.2.0.0.0"
  db_recovery_file_dest    = "D:\database\flash_recovery_area"
  db_recovery_file_dest_size= 3852M
  undo_tablespace          = "UNDOTBS1"
  remote_login_passwordfile= "EXCLUSIVE"
  db_domain                = ""
  dispatchers              = "(PROTOCOL=TCP) (SERVICE=dba1XDB)"
  audit_file_dest          = "D:\DATABASE\ADMIN\DBA1\ADUMP"
  audit_trail              = "DB"
  db_name                  = "dba1"
  open_cursors             = 300
  diagnostic_dest          = "D:\DATABASE"
Mon Sep 18 13:08:36 2017
PMON started with pid=2, OS id=3488 
OER 7451 in Load Indicator : Error Code = OSD-04500: задан недопустимый параметр !
Mon Sep 18 13:08:36 2017
VKTM started with pid=3, OS id=4164 at elevated priority
VKTM running at (10)millisec precision with DBRM quantum (100)ms
Mon Sep 18 13:08:36 2017
GEN0 started with pid=4, OS id=3760 
Mon Sep 18 13:08:36 2017
DIAG started with pid=5, OS id=4004 
Mon Sep 18 13:08:36 2017
DBRM started with pid=6, OS id=4268 
Mon Sep 18 13:08:36 2017
PSP0 started with pid=7, OS id=1324 
Mon Sep 18 13:08:36 2017
DIA0 started with pid=8, OS id=3012 
Mon Sep 18 13:08:36 2017
MMAN started with pid=9, OS id=1668 
Mon Sep 18 13:08:36 2017
DBW0 started with pid=10, OS id=756 
Mon Sep 18 13:08:36 2017
LGWR started with pid=11, OS id=4928 
Mon Sep 18 13:08:36 2017
CKPT started with pid=12, OS id=2248 
Mon Sep 18 13:08:36 2017
SMON started with pid=13, OS id=4900 
Mon Sep 18 13:08:36 2017
RECO started with pid=14, OS id=4272 
Mon Sep 18 13:08:36 2017
MMON started with pid=15, OS id=4320 
Mon Sep 18 13:08:36 2017
MMNL started with pid=16, OS id=3684 
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
ORACLE_BASE from environment = D:\database
Mon Sep 18 13:08:37 2017
ALTER DATABASE   MOUNT
Successful mount of redo thread 1, with mount id 2265403285
Database mounted in Exclusive Mode
Lost write protection disabled
Completed: ALTER DATABASE   MOUNT
Mon Sep 18 13:08:42 2017
ALTER DATABASE OPEN MIGRATE
Errors in file d:\database\diag\rdbms\dba1\dba1\trace\dba1_ora_4624.trc:
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
ORA-1589 signalled during: ALTER DATABASE OPEN MIGRATE...
Mon Sep 18 14:41:50 2017
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on. 
IMODE=BR
ILAT =27
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
Using parameter settings in server-side spfile D:\DATABASE\PRODUCT\11.2.0\DBHOME_1\DATABASE\SPFILEDBA1.ORA
System parameters with non-default values:
  processes                = 150
  memory_target            = 1232M
  control_files            = "D:\DATABASE\ORADATA\DBA1\CONTROL01.CTL"
  db_block_size            = 8192
  compatible               = "11.2.0.0.0"
  db_recovery_file_dest    = "D:\database\flash_recovery_area"
  db_recovery_file_dest_size= 3852M
  undo_tablespace          = "UNDOTBS1"
  remote_login_passwordfile= "EXCLUSIVE"
  db_domain                = ""
  dispatchers              = "(PROTOCOL=TCP) (SERVICE=dba1XDB)"
  audit_file_dest          = "D:\DATABASE\ADMIN\DBA1\ADUMP"
  audit_trail              = "DB"
  db_name                  = "dba1"
  open_cursors             = 300
  diagnostic_dest          = "D:\DATABASE"
Mon Sep 18 14:41:54 2017
PMON started with pid=2, OS id=2664 
Mon Sep 18 14:41:54 2017
VKTM started with pid=3, OS id=2668 at elevated priority
VKTM running at (10)millisec precision with DBRM quantum (100)ms
Mon Sep 18 14:41:54 2017
GEN0 started with pid=4, OS id=2672 
OER 7451 in Load Indicator : Error Code = OSD-04500: задан недопустимый параметр !
Mon Sep 18 14:41:54 2017
DIAG started with pid=5, OS id=2676 
Mon Sep 18 14:41:54 2017
DBRM started with pid=6, OS id=2680 
Mon Sep 18 14:41:54 2017
PSP0 started with pid=7, OS id=2684 
Mon Sep 18 14:41:54 2017
DIA0 started with pid=8, OS id=2688 
Mon Sep 18 14:41:54 2017
MMAN started with pid=9, OS id=2692 
Mon Sep 18 14:41:54 2017
DBW0 started with pid=10, OS id=2696 
Mon Sep 18 14:41:54 2017
LGWR started with pid=11, OS id=2700 
Mon Sep 18 14:41:54 2017
CKPT started with pid=12, OS id=2704 
Mon Sep 18 14:41:54 2017
SMON started with pid=13, OS id=2708 
Mon Sep 18 14:41:54 2017
RECO started with pid=14, OS id=2712 
Mon Sep 18 14:41:54 2017
MMON started with pid=15, OS id=2716 
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
ORACLE_BASE from environment = D:\database
Mon Sep 18 14:41:55 2017
alter database mount exclusive
Mon Sep 18 14:41:54 2017
MMNL started with pid=16, OS id=2720 
Successful mount of redo thread 1, with mount id 2265443187
Database mounted in Exclusive Mode
Lost write protection disabled
Completed: alter database mount exclusive
alter database open
Errors in file d:\database\diag\rdbms\dba1\dba1\trace\dba1_ora_2736.trc:
ORA-01589: ??? ???????? ?? ?????? ???? ???????????? ????????? RESETLOGS ??? NORESETLOGS
ORA-1589 signalled during: alter database open...
Mon Sep 18 14:52:28 2017
Shutting down instance (immediate)
Shutting down instance: further logons disabled
Stopping background process MMNL
Stopping background process MMON
License high water mark = 2
All dispatchers and shared servers shutdown
alter database close normal
ORA-1109 signalled during: alter database close normal...
Mon Sep 18 14:52:36 2017
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on. 
IMODE=BR
ILAT =27
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
Using parameter settings in server-side spfile D:\DATABASE\PRODUCT\11.2.0\DBHOME_1\DATABASE\SPFILEDBA1.ORA
System parameters with non-default values:
  processes                = 150
  memory_target            = 1232M
  control_files            = "D:\DATABASE\ORADATA\DBA1\CONTROL01.CTL"
  db_block_size            = 8192
  compatible               = "11.2.0.0.0"
  db_recovery_file_dest    = "D:\database\flash_recovery_area"
  db_recovery_file_dest_size= 3852M
  undo_tablespace          = "UNDOTBS1"
  remote_login_passwordfile= "EXCLUSIVE"
  db_domain                = ""
  dispatchers              = "(PROTOCOL=TCP) (SERVICE=dba1XDB)"
  audit_file_dest          = "D:\DATABASE\ADMIN\DBA1\ADUMP"
  audit_trail              = "DB"
  db_name                  = "dba1"
  open_cursors             = 300
  diagnostic_dest          = "D:\DATABASE"
Mon Sep 18 14:52:36 2017
PMON started with pid=2, OS id=2640 
Mon Sep 18 14:52:36 2017
VKTM started with pid=3, OS id=3620 at elevated priority
OER 7451 in Load Indicator : Error Code = OSD-04500: задан недопустимый параметр !
VKTM running at (10)millisec precision with DBRM quantum (100)ms
Mon Sep 18 14:52:36 2017
GEN0 started with pid=4, OS id=844 
Mon Sep 18 14:52:36 2017
DIAG started with pid=5, OS id=1700 
Mon Sep 18 14:52:36 2017
DBRM started with pid=6, OS id=3724 
Mon Sep 18 14:52:36 2017
PSP0 started with pid=7, OS id=2788 
Mon Sep 18 14:52:36 2017
DIA0 started with pid=8, OS id=3560 
Mon Sep 18 14:52:36 2017
MMAN started with pid=9, OS id=4452 
Mon Sep 18 14:52:36 2017
DBW0 started with pid=10, OS id=4556 
Mon Sep 18 14:52:36 2017
LGWR started with pid=11, OS id=3084 
Mon Sep 18 14:52:36 2017
CKPT started with pid=12, OS id=2928 
Mon Sep 18 14:52:36 2017
SMON started with pid=13, OS id=2400 
Mon Sep 18 14:52:36 2017
RECO started with pid=14, OS id=3748 
Mon Sep 18 14:52:36 2017
MMON started with pid=15, OS id=1280 
Mon Sep 18 14:52:36 2017
MMNL started with pid=16, OS id=5008 
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
ORACLE_BASE from environment = D:\database
Mon Sep 18 14:52:37 2017
alter database mount exclusive
Successful mount of redo thread 1, with mount id 2265448949
Database mounted in Exclusive Mode
Lost write protection disabled
Completed: alter database mount exclusive
alter database open
Errors in file d:\database\diag\rdbms\dba1\dba1\trace\dba1_ora_4680.trc:
ORA-01589: ??? ???????? ?? ?????? ???? ???????????? ????????? RESETLOGS ??? NORESETLOGS
ORA-1589 signalled during: alter database open...
Mon Sep 18 14:56:23 2017
db_recovery_file_dest_size of 3852 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.
Mon Sep 18 14:57:50 2017
Starting ORACLE instance (normal)
Mon Sep 18 14:58:11 2017
Shutting down instance (abort)
License high water mark = 1
USER (ospid: 2964): terminating the instance
Instance terminated by USER, pid = 2964
Mon Sep 18 14:58:12 2017
Instance shutdown complete
Mon Sep 18 14:58:24 2017
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on. 
IMODE=BR
ILAT =27
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
Using parameter settings in server-side spfile D:\DATABASE\PRODUCT\11.2.0\DBHOME_1\DATABASE\SPFILEDBA1.ORA
System parameters with non-default values:
  processes                = 150
  memory_target            = 1232M
  control_files            = "D:\DATABASE\ORADATA\DBA1\CONTROL01.CTL"
  db_block_size            = 8192
  compatible               = "11.2.0.0.0"
  db_recovery_file_dest    = "D:\database\flash_recovery_area"
  db_recovery_file_dest_size= 3852M
  undo_tablespace          = "UNDOTBS1"
  remote_login_passwordfile= "EXCLUSIVE"
  db_domain                = ""
  dispatchers              = "(PROTOCOL=TCP) (SERVICE=dba1XDB)"
  audit_file_dest          = "D:\DATABASE\ADMIN\DBA1\ADUMP"
  audit_trail              = "DB"
  db_name                  = "dba1"
  open_cursors             = 300
  diagnostic_dest          = "D:\DATABASE"
Mon Sep 18 14:58:24 2017
PMON started with pid=2, OS id=4788 
Mon Sep 18 14:58:24 2017
VKTM started with pid=3, OS id=5104 at elevated priority
VKTM running at (10)millisec precision with DBRM quantum (100)ms
Mon Sep 18 14:58:24 2017
GEN0 started with pid=4, OS id=3304 
Mon Sep 18 14:58:24 2017
DIAG started with pid=5, OS id=2624 
OER 7451 in Load Indicator : Error Code = OSD-04500: задан недопустимый параметр !
Mon Sep 18 14:58:24 2017
DBRM started with pid=6, OS id=1284 
Mon Sep 18 14:58:24 2017
PSP0 started with pid=7, OS id=2872 
Mon Sep 18 14:58:24 2017
DIA0 started with pid=8, OS id=2824 
Mon Sep 18 14:58:24 2017
MMAN started with pid=9, OS id=1040 
Mon Sep 18 14:58:24 2017
DBW0 started with pid=10, OS id=3288 
Mon Sep 18 14:58:24 2017
LGWR started with pid=11, OS id=4840 
Mon Sep 18 14:58:24 2017
CKPT started with pid=12, OS id=4548 
Mon Sep 18 14:58:24 2017
SMON started with pid=13, OS id=4764 
Mon Sep 18 14:58:24 2017
RECO started with pid=14, OS id=4296 
Mon Sep 18 14:58:24 2017
MMON started with pid=15, OS id=764 
Mon Sep 18 14:58:24 2017
MMNL started with pid=16, OS id=4660 
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
ORACLE_BASE from environment = D:\database
Mon Sep 18 14:58:24 2017
ALTER DATABASE   MOUNT
Successful mount of redo thread 1, with mount id 2265406288
Database mounted in Exclusive Mode
Lost write protection disabled
Completed: ALTER DATABASE   MOUNT
Mon Sep 18 14:58:29 2017
ALTER DATABASE OPEN
Errors in file d:\database\diag\rdbms\dba1\dba1\trace\dba1_ora_2644.trc:
ORA-01589: для открытия БД должны быть использованы параметры RESETLOGS или NORESETLOGS
ORA-1589 signalled during: ALTER DATABASE OPEN...
Mon Sep 18 14:59:04 2017
alter database open resetlogs
ORA-1194 signalled during: alter database open resetlogs...
Mon Sep 18 14:59:04 2017
Errors in file d:\database\diag\rdbms\dba1\dba1\trace\dba1_m000_3764.trc:
ORA-00322: log 1 of thread 1 is not current copy
ORA-00312: online log 1 thread 1: 'D:\DATABASE\ORADATA\DBA1\REDO01.LOG'
Errors in file d:\database\diag\rdbms\dba1\dba1\trace\dba1_m000_3764.trc:
ORA-00322: log 2 of thread 1 is not current copy
ORA-00312: online log 2 thread 1: 'D:\DATABASE\ORADATA\DBA1\REDO02.LOG'
Mon Sep 18 15:04:36 2017
Shutting down instance (abort)
License high water mark = 1
USER (ospid: 2644): terminating the instance
Instance terminated by USER, pid = 2644
Mon Sep 18 15:04:37 2017
Instance shutdown complete
Mon Sep 18 15:04:56 2017
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on. 
IMODE=BR
ILAT =27
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
Using parameter settings in server-side spfile D:\DATABASE\PRODUCT\11.2.0\DBHOME_1\DATABASE\SPFILEDBA1.ORA
System parameters with non-default values:
  processes                = 150
  memory_target            = 1232M
  control_files            = "D:\DATABASE\ORADATA\DBA1\CONTROL01.CTL"
  db_block_size            = 8192
  compatible               = "11.2.0.0.0"
  db_recovery_file_dest    = "D:\database\flash_recovery_area"
  db_recovery_file_dest_size= 3852M
  undo_tablespace          = "UNDOTBS1"
  remote_login_passwordfile= "EXCLUSIVE"
  db_domain                = ""
  dispatchers              = "(PROTOCOL=TCP) (SERVICE=dba1XDB)"
  audit_file_dest          = "D:\DATABASE\ADMIN\DBA1\ADUMP"
  audit_trail              = "DB"
  db_name                  = "dba1"
  open_cursors             = 300
  diagnostic_dest          = "D:\DATABASE"
Mon Sep 18 15:04:56 2017
PMON started with pid=2, OS id=4872 
OER 7451 in Load Indicator : Error Code = OSD-04500: задан недопустимый параметр !
Mon Sep 18 15:04:56 2017
VKTM started with pid=3, OS id=3960 at elevated priority
VKTM running at (10)millisec precision with DBRM quantum (100)ms
Mon Sep 18 15:04:56 2017
GEN0 started with pid=4, OS id=3628 
Mon Sep 18 15:04:56 2017
DIAG started with pid=5, OS id=4956 
Mon Sep 18 15:04:56 2017
DBRM started with pid=6, OS id=1308 
Mon Sep 18 15:04:56 2017
PSP0 started with pid=7, OS id=4420 
Mon Sep 18 15:04:56 2017
DIA0 started with pid=8, OS id=4888 
Mon Sep 18 15:04:56 2017
MMAN started with pid=9, OS id=4572 
Mon Sep 18 15:04:56 2017
DBW0 started with pid=10, OS id=3408 
Mon Sep 18 15:04:56 2017
LGWR started with pid=11, OS id=4668 
Mon Sep 18 15:04:56 2017
CKPT started with pid=12, OS id=2248 
Mon Sep 18 15:04:56 2017
SMON started with pid=13, OS id=3636 
Mon Sep 18 15:04:56 2017
RECO started with pid=14, OS id=3048 
Mon Sep 18 15:04:56 2017
MMON started with pid=15, OS id=3868 
Mon Sep 18 15:04:56 2017
MMNL started with pid=16, OS id=5068 
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
ORACLE_BASE from environment = D:\database
Mon Sep 18 15:04:56 2017
ALTER DATABASE   MOUNT
Successful mount of redo thread 1, with mount id 2265427416
Database mounted in Exclusive Mode
Lost write protection disabled
Completed: ALTER DATABASE   MOUNT
Mon Sep 18 15:05:58 2017
alter database open resetlogs
ORA-1194 signalled during: alter database open resetlogs...
Mon Sep 18 15:05:59 2017
Errors in file d:\database\diag\rdbms\dba1\dba1\trace\dba1_m000_3292.trc:
ORA-00322: log 1 of thread 1 is not current copy
ORA-00312: online log 1 thread 1: 'D:\DATABASE\ORADATA\DBA1\REDO01.LOG'
Errors in file d:\database\diag\rdbms\dba1\dba1\trace\dba1_m000_3292.trc:
ORA-00322: log 2 of thread 1 is not current copy
ORA-00312: online log 2 thread 1: 'D:\DATABASE\ORADATA\DBA1\REDO02.LOG'
Mon Sep 18 15:07:35 2017
alter database open
Errors in file d:\database\diag\rdbms\dba1\dba1\trace\dba1_ora_2664.trc:
ORA-01589: для открытия БД должны быть использованы параметры RESETLOGS или NORESETLOGS
ORA-1589 signalled during: alter database open
...
Mon Sep 18 15:07:56 2017


***********************************************************************

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

  VERSION INFORMATION:
	TNS for 32-bit Windows: Version 11.2.0.1.0 - Production
	Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 11.2.0.1.0 - Production
  Time: 18-СЕН-2017 15:07:56
  Tracing not turned on.
  Tns error struct:
    ns main err code: 12638
    
TNS-12638: Сбой при извлечении реквизитов
    ns secondary err code: 0
    nt main err code: 0
    nt secondary err code: 0
    nt OS err code: 0
Mon Sep 18 15:08:47 2017
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on. 
IMODE=BR
ILAT =27
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
Using parameter settings in server-side spfile D:\DATABASE\PRODUCT\11.2.0\DBHOME_1\DATABASE\SPFILEDBA1.ORA
System parameters with non-default values:
  processes                = 150
  memory_target            = 1232M
  control_files            = "D:\DATABASE\ORADATA\DBA1\CONTROL01.CTL"
  db_block_size            = 8192
  compatible               = "11.2.0.0.0"
  db_recovery_file_dest    = "D:\database\flash_recovery_area"
  db_recovery_file_dest_size= 3852M
  undo_tablespace          = "UNDOTBS1"
  remote_login_passwordfile= "EXCLUSIVE"
  db_domain                = ""
  dispatchers              = "(PROTOCOL=TCP) (SERVICE=dba1XDB)"
  audit_file_dest          = "D:\DATABASE\ADMIN\DBA1\ADUMP"
  audit_trail              = "DB"
  db_name                  = "dba1"
  open_cursors             = 300
  diagnostic_dest          = "D:\DATABASE"
Mon Sep 18 15:08:51 2017
PMON started with pid=2, OS id=2144 
Mon Sep 18 15:08:51 2017
VKTM started with pid=3, OS id=2148 at elevated priority
VKTM running at (10)millisec precision with DBRM quantum (100)ms
Mon Sep 18 15:08:51 2017
GEN0 started with pid=4, OS id=2152 
OER 7451 in Load Indicator : Error Code = OSD-04500: задан недопустимый параметр !
Mon Sep 18 15:08:51 2017
DIAG started with pid=5, OS id=2156 
Mon Sep 18 15:08:51 2017
DBRM started with pid=6, OS id=2160 
Mon Sep 18 15:08:51 2017
PSP0 started with pid=7, OS id=2164 
Mon Sep 18 15:08:51 2017
DIA0 started with pid=8, OS id=2168 
Mon Sep 18 15:08:51 2017
MMAN started with pid=9, OS id=2172 
Mon Sep 18 15:08:51 2017
DBW0 started with pid=10, OS id=2176 
Mon Sep 18 15:08:51 2017
LGWR started with pid=11, OS id=2180 
Mon Sep 18 15:08:51 2017
CKPT started with pid=12, OS id=2184 
Mon Sep 18 15:08:51 2017
SMON started with pid=13, OS id=2188 
Mon Sep 18 15:08:51 2017
RECO started with pid=14, OS id=2192 
Mon Sep 18 15:08:51 2017
MMON started with pid=15, OS id=2196 
Mon Sep 18 15:08:51 2017
MMNL started with pid=16, OS id=2200 
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
ORACLE_BASE from environment = D:\database
Mon Sep 18 15:08:56 2017
alter database mount exclusive
Mon Sep 18 15:09:02 2017
Successful mount of redo thread 1, with mount id 2265418953
Database mounted in Exclusive Mode
Lost write protection disabled
Completed: alter database mount exclusive
alter database open
Errors in file d:\database\diag\rdbms\dba1\dba1\trace\dba1_ora_2484.trc:
ORA-01589: ??? ???????? ?? ?????? ???? ???????????? ????????? RESETLOGS ??? NORESETLOGS
ORA-1589 signalled during: alter database open...
Mon Sep 18 15:10:54 2017
Starting ORACLE instance (normal)
Mon Sep 18 15:11:19 2017
Shutting down instance (immediate)
Shutting down instance: further logons disabled
Stopping background process MMNL
Stopping background process MMON
License high water mark = 1
All dispatchers and shared servers shutdown
ALTER DATABASE CLOSE NORMAL
ORA-1109 signalled during: ALTER DATABASE CLOSE NORMAL...
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
Mon Sep 18 15:11:21 2017
Stopping background process VKTM: 
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Mon Sep 18 15:11:23 2017
Instance shutdown complete
Mon Sep 18 15:11:48 2017
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on. 
IMODE=BR
ILAT =27
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
Using parameter settings in server-side spfile D:\DATABASE\PRODUCT\11.2.0\DBHOME_1\DATABASE\SPFILEDBA1.ORA
System parameters with non-default values:
  processes                = 150
  memory_target            = 1232M
  control_files            = "D:\DATABASE\ORADATA\DBA1\CONTROL01.CTL"
  db_block_size            = 8192
  compatible               = "11.2.0.0.0"
  db_recovery_file_dest    = "D:\database\flash_recovery_area"
  db_recovery_file_dest_size= 3852M
  undo_tablespace          = "UNDOTBS1"
  remote_login_passwordfile= "EXCLUSIVE"
  db_domain                = ""
  dispatchers              = "(PROTOCOL=TCP) (SERVICE=dba1XDB)"
  audit_file_dest          = "D:\DATABASE\ADMIN\DBA1\ADUMP"
  audit_trail              = "DB"
  db_name                  = "dba1"
  open_cursors             = 300
  diagnostic_dest          = "D:\DATABASE"
Mon Sep 18 15:11:48 2017
PMON started with pid=2, OS id=2228 
Mon Sep 18 15:11:48 2017
VKTM started with pid=3, OS id=1052 at elevated priority
OER 7451 in Load Indicator : Error Code = OSD-04500: задан недопустимый параметр !
Mon Sep 18 15:11:48 2017
GEN0 started with pid=4, OS id=2528 
Mon Sep 18 15:11:48 2017
DIAG started with pid=5, OS id=2520 
Mon Sep 18 15:11:48 2017
DBRM started with pid=6, OS id=2092 
Mon Sep 18 15:11:48 2017
PSP0 started with pid=7, OS id=212 
Mon Sep 18 15:11:48 2017
DIA0 started with pid=8, OS id=2692 
Mon Sep 18 15:11:48 2017
MMAN started with pid=9, OS id=2748 
Mon Sep 18 15:11:48 2017
DBW0 started with pid=10, OS id=2136 
Mon Sep 18 15:11:48 2017
LGWR started with pid=11, OS id=1428 
Mon Sep 18 15:11:48 2017
CKPT started with pid=12, OS id=2548 
Mon Sep 18 15:11:48 2017
SMON started with pid=13, OS id=3156 
Mon Sep 18 15:11:48 2017
RECO started with pid=14, OS id=3152 
Mon Sep 18 15:11:48 2017
MMON started with pid=15, OS id=2132 
Mon Sep 18 15:11:48 2017
MMNL started with pid=16, OS id=696 
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
ORACLE_BASE from environment = D:\database
Mon Sep 18 15:11:48 2017
ALTER DATABASE   MOUNT
VKTM running at (10)millisec precision with DBRM quantum (100)ms
Successful mount of redo thread 1, with mount id 2265404276
Database mounted in Exclusive Mode
Lost write protection disabled
Completed: ALTER DATABASE   MOUNT

...

Рейтинг:

0 / 0

18.09.2017, 13:31

| Ответить | Цитировать | Написать

ORA-01033 oracle initialization or shutdown in progress

#39522721

revizor

Участник

Сообщения: 21

Рейтинг: 0 / 0

Добрый Э - Эх, спасибо за совет. С утра не могу решить проблему и торопясь закинул в таком виде.

...

Рейтинг:

0 / 0

18.09.2017, 13:40

| Ответить | Цитировать | Написать

ORA-01033 oracle initialization or shutdown in progress

#39522725

archlog

Гость

revizor,

OER 7451 in Load Indicator : Error Code = OSD-04500: задан недопустимый параметр !

...

Рейтинг:

0 / 0

18.09.2017, 13:54

| Ответить | Цитировать | Написать

ORA-01033 oracle initialization or shutdown in progress

#39522734

revizor

Участник

Сообщения: 21

Рейтинг: 0 / 0

archlog, а как должно быть?

...

Рейтинг:

0 / 0

18.09.2017, 14:07

| Ответить | Цитировать | Написать

ORA-01033 oracle initialization or shutdown in progress

#39522736

--Eugene--

Участник

Откуда: Боярышник

Сообщения: 2 193

Рейтинг: 0 / 0

revizorarchlog, а как должно быть?должно быть:
Congrats! задан допустимый параметр !

...

Рейтинг:

0 / 0

18.09.2017, 14:09

| Ответить | Цитировать | Написать

ORA-01033 oracle initialization or shutdown in progress

#39522738

revizor

Участник

Сообщения: 21

Рейтинг: 0 / 0

--Eugene--,

но как сделать чтобы было Задано допустимый параметр? Спрашиваю от не знания решение этой проблемы.

...

Рейтинг:

0 / 0

18.09.2017, 14:13

| Ответить | Цитировать | Написать

ORA-01033 oracle initialization or shutdown in progress

#39522772

помощник!

Гость

revizor,

наймите специалиста - так однозначно будет проще. Или вы как себе представляете помощь? Угадать какой из параметров у вас установлен не корректно?!?!

...

Рейтинг:

0 / 0

18.09.2017, 14:56

| Ответить | Цитировать | Написать

ORA-01033 oracle initialization or shutdown in progress

#39522818

понимаю в этом деле

Гость

Самое интересное здесь :

Код: plaintext

1.
2.
3.
4.
5.

ORA-214 signalled during: alter database mount exclusive...
Mon Sep 18 11:40:36 2017
ORA-00322: log 1 of thread 1 is not current copy
ORA-00312: online log 1 thread 1: 'D:\DATABASE\ORADATA\DBA1\REDO01.LOG'
Aborting crash recovery due to error 322

(ORA-214 значит 00214, 00000, "control file '%s' version %s inconsistent with file '%s' version %s")

Файлы на диске повреждены, надо восстанавливать с резервной копии.
Можно пробовать упражнения с _allow_resetlogs_corruption (ищи на форуме), но не факт, что закончиться успешно.

Чтобы такого не происходило в будущем надо использовать серверные диски: с выключенным кешем на запись, RAID-контроллеры c BBU/Flash+Supercap или SSD с PLP (power loss protection).

...

Рейтинг:

0 / 0

18.09.2017, 15:52

| Ответить | Цитировать | Написать

24 сообщений из 24, страница 1 из 1

Форумы / Oracle [игнор отключен] [закрыт для гостей] / ORA-01033 oracle initialization or shutdown in progress

Читали тему (0):

Читали форум (0):

Пользователи онлайн (0):

start [/forum/topic.php?fid=52&fpage=145&tid=1885231]:	0ms
get settings:	8ms
get forum list:	19ms
check forum access:	3ms
check topic access:	3ms
track hit:	175ms
get topic data:	13ms
get forum data:	4ms
get page messages:	79ms
get tp. blocked users:	2ms
others:	255ms

total:	561ms

	Необходимые cookie
	Cookie для сбора статистики
	Cookie для маркетинга и рекламы