Добро пожаловать в форум, Guest  >>   Войти | Регистрация | Поиск | Правила | В избранное | Подписаться
Все форумы / Oracle Новый топик    Ответить
Топик располагается на нескольких страницах: [1] 2 3   вперед  Ctrl      все
 Плиз, помогите восстановить базу!!  [new]
TaysonSQL
Member

Откуда:
Сообщений: 31
Упала база, зависла винда ХП, перегрузка и оракл 9 - не стартует. База в состоянии маунт. Ругается на файл system01.dbf. Есть образ диска с ораклом 3х дневной давности и есть холодная копия 2х недельной давности. Пожалуйста, помогите восстановить рабботоспособность. Сам чайник, полный .
16 май 07, 17:03    [4145927]     Ответить | Цитировать Сообщить модератору
 Re: Плиз, помогите восстановить базу!!  [new]
tru55
Member

Откуда: СПб
Сообщений: 19790
Как минимум
1. как ругается, полностью с момента выдачи startup ?
2. база в ARCHIVELOG ?
3. если в ARCHIVELOG, все ли arch logs в наличии ?
16 май 07, 17:06    [4145944]     Ответить | Цитировать Сообщить модератору
 Re: Плиз, помогите восстановить базу!!  [new]
juks@gala.net
Member

Откуда: Киев
Сообщений: 4212
Архивлоги есть ?
Насколько это критичная база ?
Алерт сюда
16 май 07, 17:06    [4145951]     Ответить | Цитировать Сообщить модератору
 Re: Плиз, помогите восстановить базу!!  [new]
orlangur
Member

Откуда: Санкт-Петербург
Сообщений: 149
1.Можно про ругань подробнее
2.Режим архив лог или нет?
16 май 07, 17:07    [4145958]     Ответить | Цитировать Сообщить модератору
 Re: Плиз, помогите восстановить базу!!  [new]
TaysonSQL
Member

Откуда:
Сообщений: 31
в дополнение: с образа диска могу вытащить любой файл. Пробовал подкидывать system01.dbf и давать команду recover database automatic - не помогло
16 май 07, 17:07    [4145964]     Ответить | Цитировать Сообщить модератору
 Re: Плиз, помогите восстановить базу!!  [new]
TaysonSQL
Member

Откуда:
Сообщений: 31
да в режиме arhivlog


В образе диска - есть все !!! Т.е. весь диск - где стоит Оракл
16 май 07, 17:09    [4145971]     Ответить | Цитировать Сообщить модератору
 Re: Плиз, помогите восстановить базу!!  [new]
tru55
Member

Откуда: СПб
Сообщений: 19790
TaysonSQL
да в режиме arhivlog


В образе диска - есть все !!! Т.е. весь диск - где стоит Оракл


1. Образ диска делался при открытой базе или при закрытой?
2. и все таки - как ругается без recover и при выдаче recover?
3. образ диска - енто конечно хорощо, но есть ли arch logs, созданные ПОСЛЕ снятия образа ?

PS образ диска в качестве backup - енто зачем, чем не устраивает стандартные методы Oracle ?
16 май 07, 17:12    [4145996]     Ответить | Цитировать Сообщить модератору
 Re: Плиз, помогите восстановить базу!!  [new]
TaysonSQL
Member

Откуда:
Сообщений: 31
ругается - когда пытаюсь в интерпрайз менеджере нажать на "опен " Пишит ора-01251 неизвестный заголовок файла - и идет ссылка на файл систем01
16 май 07, 17:14    [4146017]     Ответить | Цитировать Сообщить модератору
 Re: Плиз, помогите восстановить базу!!  [new]
juks@gala.net
Member

Откуда: Киев
Сообщений: 4212
Ругань при открытии ?
16 май 07, 17:14    [4146018]     Ответить | Цитировать Сообщить модератору
 Re: Плиз, помогите восстановить базу!!  [new]
TaysonSQL
Member

Откуда:
Сообщений: 31
tru55
TaysonSQL
да в режиме arhivlog


В образе диска - есть все !!! Т.е. весь диск - где стоит Оракл


1. Образ диска делался при открытой базе или при закрытой?
2. и все таки - как ругается без recover и при выдаче recover?
3. образ диска - енто конечно хорощо, но есть ли arch logs, созданные ПОСЛЕ снятия образа ?

PS образ диска в качестве backup - енто зачем, чем не устраивает стандартные методы Oracle ?



1. При открытой , Акронисом
2 -
3. Вся папка с ораклом есть. Есть еще архив файла с:\оракле\орадата\база\архиве - на начал дня
16 май 07, 17:17    [4146036]     Ответить | Цитировать Сообщить модератору
 Re: Плиз, помогите восстановить базу!!  [new]
juks@gala.net
Member

Откуда: Киев
Сообщений: 4212
Копию текущего system01 в сторонку и recover datafile 1 в плюсе.
Алерт глянуть не мешает
16 май 07, 17:18    [4146042]     Ответить | Цитировать Сообщить модератору
 Re: Плиз, помогите восстановить базу!!  [new]
TaysonSQL
Member

Откуда:
Сообщений: 31
juks@gala.net
Копию текущего system01 в сторонку и recover datafile 1 в плюсе.
Алерт глянуть не мешает


как глянуть ? подробнее плиз
16 май 07, 17:20    [4146064]     Ответить | Цитировать Сообщить модератору
 Re: Плиз, помогите восстановить базу!!  [new]
orlangur
Member

Откуда: Санкт-Петербург
Сообщений: 149
TaysonSQL

как глянуть ? подробнее плиз

есть такой файлик alert_%ORACLE_SID%.log поишите где он у вас лежит. Обычно в %ORACLE_BASE%\admin\%ORACLE_SID%\bdump
16 май 07, 17:24    [4146097]     Ответить | Цитировать Сообщить модератору
 Re: Плиз, помогите восстановить базу!!  [new]
juks@gala.net
Member

Откуда: Киев
Сообщений: 4212
TaysonSQL
juks@gala.net
Копию текущего system01 в сторонку и recover datafile 1 в плюсе.
Алерт глянуть не мешает


как глянуть ? подробнее плиз

На него указывает значение параметра инициализиции экземпляра background_bump_dest
В плюсе
sho parameter  background_d
16 май 07, 17:28    [4146144]     Ответить | Цитировать Сообщить модератору
 Re: Плиз, помогите восстановить базу!!  [new]
TaysonSQL
Member

Откуда:
Сообщений: 31
нашел. оч большой - 7 метров.какие именно строки показать ?
16 май 07, 17:32    [4146194]     Ответить | Цитировать Сообщить модератору
 Re: Плиз, помогите восстановить базу!!  [new]
orlangur
Member

Откуда: Санкт-Петербург
Сообщений: 149
TaysonSQL
нашел. оч большой - 7 метров.какие именно строки показать ?

По дате, на момент попытки поднять базу
16 май 07, 17:34    [4146213]     Ответить | Цитировать Сообщить модератору
 Re: Плиз, помогите восстановить базу!!  [new]
juks@gala.net
Member

Откуда: Киев
Сообщений: 4212
С дня перезагрузки
16 май 07, 17:35    [4146220]     Ответить | Цитировать Сообщить модератору
 Re: Плиз, помогите восстановить базу!!  [new]
TaysonSQL
Member

Откуда:
Сообщений: 31
ща сделаю, инет в другой комнате...
16 май 07, 17:57    [4146396]     Ответить | Цитировать Сообщить модератору
 Re: Плиз, помогите восстановить базу!!  [new]
TaysonSQL
Member

Откуда:
Сообщений: 31
алерт, примерно за час до того как накрылась база:
Tue May 15 13:11:07 2007
ARC0: Evaluating archive   log 2 thread 1 sequence 2261
ARC0: Beginning to archive log 2 thread 1 sequence 2261
Creating archive destination LOG_ARCHIVE_DEST_1: 'C:\ORACLE\ORADATA\BRANCH\ARCHIVE\1_2261.ARC'
Tue May 15 13:11:07 2007
Thread 1 advanced to log sequence 2262
  Current log# 3 seq# 2262 mem# 0: C:\ORACLE\ORADATA\BRANCH\REDO03.LOG
Tue May 15 13:12:28 2007
ARC0: Completed archiving  log 2 thread 1 sequence 2261
Dump file c:\oracle\admin\branch\bdump\alert_branch.log
Tue May 15 13:57:00 2007
ORACLE V9.2.0.6.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.1 Service Pack 2, CPU type 586
Tue May 15 13:57:00 2007
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.6.0.
System parameters with non-default values:
  processes                = 150
  timed_statistics         = TRUE
  resource_limit           = TRUE
  shared_pool_size         = 192937984
  large_pool_size          = 142606336
  java_pool_size           = 33554432
  control_files            = C:\oracle\oradata\branch\control01.ctl, C:\oracle\oradata\branch\control02.ctl, C:\oracle\oradata\branch\control03.ctl
  db_block_size            = 8192
  db_cache_size            = 578813952
  compatible               = 9.2.0.0.0
  log_archive_start        = TRUE
  log_archive_dest_1       = LOCATION=C:\oracle\oradata\branch\archive
  log_archive_format       = %t_%s.arc
  db_file_multiblock_read_count= 16
  fast_start_mttr_target   = 300
  undo_management          = AUTO
  undo_tablespace          = UNDOTBS1
  undo_retention           = 10800
  remote_login_passwordfile= EXCLUSIVE
  db_domain                = STALKER
  instance_name            = branch
  dispatchers              = (PROTOCOL=TCP) (SERVICE=branchXDB)
  utl_file_dir             = *
  job_queue_processes      = 10
  hash_join_enabled        = TRUE
  background_dump_dest     = C:\oracle\admin\branch\bdump
  user_dump_dest           = C:\oracle\admin\branch\udump
  core_dump_dest           = C:\oracle\admin\branch\cdump
  sort_area_size           = 1048576
  db_name                  = branch
  open_cursors             = 300
  star_transformation_enabled= FALSE
  query_rewrite_enabled    = FALSE
  pga_aggregate_target     = 512753664
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
CJQ0 started with pid=8
Tue May 15 13:57:03 2007
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
ARCH: STARTING ARCH PROCESSES
ARC0 started with pid=11
ARC0: Archival started
ARC1 started with pid=12
ARC1: Archival started
Tue May 15 13:57:05 2007
ARCH: STARTING ARCH PROCESSES COMPLETE
Tue May 15 13:57:05 2007
ARC0: Thread not mounted
Tue May 15 13:57:05 2007
ARC1: Thread not mounted
Tue May 15 13:57:05 2007
alter database mount exclusive
Tue May 15 13:57:12 2007
Successful mount of redo thread 1, with mount id 2869412275
Tue May 15 13:57:12 2007
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Tue May 15 13:57:12 2007
alter database open
Tue May 15 13:57:12 2007
Beginning crash recovery of 1 threads
Tue May 15 13:57:12 2007
Started redo scan
Tue May 15 13:57:12 2007
Completed redo scan
 2182 redo blocks read, 193 data blocks need recovery
Tue May 15 13:57:12 2007
Started recovery at
 Thread 1: logseq 2262, block 454, scn 0.0
Tue May 15 13:57:13 2007
Recovery of Online Redo Log: Thread 1 Group 3 Seq 2262 Reading mem 0
  Mem# 0 errs 0: C:\ORACLE\ORADATA\BRANCH\REDO03.LOG
Tue May 15 13:57:13 2007
Completed redo application
Tue May 15 13:57:15 2007
Ended recovery at
 Thread 1: logseq 2262, block 2636, scn 0.95764594
 193 data blocks read, 193 data blocks written, 2182 redo blocks read
Crash recovery completed successfully
Tue May 15 13:57:16 2007
LGWR: Primary database is in CLUSTER CONSISTENT mode
Thread 1 advanced to log sequence 2263
Thread 1 opened at log sequence 2263
  Current log# 1 seq# 2263 mem# 0: C:\ORACLE\ORADATA\BRANCH\REDO01.LOG
Successful open of redo thread 1
Tue May 15 13:57:17 2007
SMON: enabling cache recovery
Tue May 15 13:57:17 2007
ARC0: Evaluating archive   log 3 thread 1 sequence 2262
ARC0: Beginning to archive log 3 thread 1 sequence 2262
Creating archive destination LOG_ARCHIVE_DEST_1: 'C:\ORACLE\ORADATA\BRANCH\ARCHIVE\1_2262.ARC'
ARC0: Completed archiving  log 3 thread 1 sequence 2262
Tue May 15 13:57:19 2007
Successfully onlined Undo Tablespace 1.
Tue May 15 13:57:19 2007
SMON: enabling tx recovery
Tue May 15 13:57:19 2007
Database Characterset is CL8MSWIN1251
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: alter database open
Dump file c:\oracle\admin\branch\bdump\alert_branch.log
Tue May 15 14:01:45 2007
ORACLE V9.2.0.6.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.1 Service Pack 2, CPU type 586
Tue May 15 14:01:45 2007
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.6.0.
System parameters with non-default values:
  processes                = 150
  timed_statistics         = TRUE
  resource_limit           = TRUE
  shared_pool_size         = 192937984
  large_pool_size          = 142606336
  java_pool_size           = 33554432
  control_files            = C:\oracle\oradata\branch\control01.ctl, C:\oracle\oradata\branch\control02.ctl, C:\oracle\oradata\branch\control03.ctl
  db_block_size            = 8192
  db_cache_size            = 578813952
  compatible               = 9.2.0.0.0
  log_archive_start        = TRUE
  log_archive_dest_1       = LOCATION=C:\oracle\oradata\branch\archive
  log_archive_format       = %t_%s.arc
  db_file_multiblock_read_count= 16
  fast_start_mttr_target   = 300
  undo_management          = AUTO
  undo_tablespace          = UNDOTBS1
  undo_retention           = 10800
  remote_login_passwordfile= EXCLUSIVE
  db_domain                = STALKER
  instance_name            = branch
  dispatchers              = (PROTOCOL=TCP) (SERVICE=branchXDB)
  utl_file_dir             = *
  job_queue_processes      = 10
  hash_join_enabled        = TRUE
  background_dump_dest     = C:\oracle\admin\branch\bdump
  user_dump_dest           = C:\oracle\admin\branch\udump
  core_dump_dest           = C:\oracle\admin\branch\cdump
  sort_area_size           = 1048576
  db_name                  = branch
  open_cursors             = 300
  star_transformation_enabled= FALSE
  query_rewrite_enabled    = FALSE
  pga_aggregate_target     = 512753664
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
CJQ0 started with pid=8
Tue May 15 14:01:48 2007
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
ARCH: STARTING ARCH PROCESSES
ARC0 started with pid=11
ARC0: Archival started
ARC1 started with pid=12
ARC1: Archival started
Tue May 15 14:01:49 2007
ARCH: STARTING ARCH PROCESSES COMPLETE
Tue May 15 14:01:49 2007
ARC0: Thread not mounted
Tue May 15 14:01:49 2007
ARC1: Thread not mounted
Tue May 15 14:01:49 2007
alter database mount exclusive

Tue May 15 14:02:54 2007
ORACLE V9.2.0.6.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.1 Service Pack 2, CPU type 586
Tue May 15 14:02:54 2007
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.6.0.
System parameters with non-default values:
  processes                = 150
  timed_statistics         = TRUE
  resource_limit           = TRUE
  shared_pool_size         = 192937984
  large_pool_size          = 142606336
  java_pool_size           = 33554432
  control_files            = C:\oracle\oradata\branch\control01.ctl, C:\oracle\oradata\branch\control02.ctl, C:\oracle\oradata\branch\control03.ctl
  db_block_size            = 8192
  db_cache_size            = 578813952
  compatible               = 9.2.0.0.0
  log_archive_start        = TRUE
  log_archive_dest_1       = LOCATION=C:\oracle\oradata\branch\archive
  log_archive_format       = %t_%s.arc
  db_file_multiblock_read_count= 16
  fast_start_mttr_target   = 300
  undo_management          = AUTO
  undo_tablespace          = UNDOTBS1
  undo_retention           = 10800
  remote_login_passwordfile= EXCLUSIVE
  db_domain                = STALKER
  instance_name            = branch
  dispatchers              = (PROTOCOL=TCP) (SERVICE=branchXDB)
  utl_file_dir             = *
  job_queue_processes      = 10
  hash_join_enabled        = TRUE
  background_dump_dest     = C:\oracle\admin\branch\bdump
  user_dump_dest           = C:\oracle\admin\branch\udump
  core_dump_dest           = C:\oracle\admin\branch\cdump
  sort_area_size           = 1048576
  db_name                  = branch
  open_cursors             = 300
  star_transformation_enabled= FALSE
  query_rewrite_enabled    = FALSE
  pga_aggregate_target     = 512753664
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
CJQ0 started with pid=8
Tue May 15 14:02:56 2007
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
ARCH: STARTING ARCH PROCESSES
ARC0 started with pid=11
ARC0: Archival started
ARC1 started with pid=12
ARC1: Archival started
Tue May 15 14:02:58 2007
ARCH: STARTING ARCH PROCESSES COMPLETE
Tue May 15 14:02:58 2007
ARC0: Thread not mounted
Tue May 15 14:02:58 2007
ARC1: Thread not mounted
Tue May 15 14:02:58 2007
alter database mount exclusive
Tue May 15 14:03:02 2007
Successful mount of redo thread 1, with mount id 2869402898
Tue May 15 14:03:02 2007
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Tue May 15 14:03:02 2007
alter database open
Tue May 15 14:03:03 2007
LGWR: Primary database is in CLUSTER CONSISTENT mode
Repairing half complete open of thread 1
Thread 1 opened at log sequence 2264
  Current log# 2 seq# 2264 mem# 0: C:\ORACLE\ORADATA\BRANCH\REDO02.LOG
Successful open of redo thread 1
Tue May 15 14:03:03 2007
SMON: enabling cache recovery
Tue May 15 14:03:03 2007
ARC1: Evaluating archive   log 1 thread 1 sequence 2263
ARC1: Beginning to archive log 1 thread 1 sequence 2263
Creating archive destination LOG_ARCHIVE_DEST_1: 'C:\ORACLE\ORADATA\BRANCH\ARCHIVE\1_2263.ARC'
ARC1: Completed archiving  log 1 thread 1 sequence 2263
Tue May 15 14:03:04 2007
Successfully onlined Undo Tablespace 1.
Tue May 15 14:03:04 2007
SMON: enabling tx recovery
Tue May 15 14:03:07 2007
Database Characterset is CL8MSWIN1251
Tue May 15 14:03:08 2007
Errors in file c:\oracle\admin\branch\bdump\branch_smon_1140.trc:
ORA-00600: internal error code, arguments: [4194], [15], [17], [], [], [], [], []

replication_dependency_tracking turned off (no async multimaster replication found)
Completed: alter database open
Tue May 15 14:03:13 2007
Doing block recovery for fno: 2 blk: 43715
Tue May 15 14:03:14 2007
Recovery of Online Redo Log: Thread 1 Group 2 Seq 2264 Reading mem 0
  Mem# 0 errs 0: C:\ORACLE\ORADATA\BRANCH\REDO02.LOG
Doing block recovery for fno: 2 blk: 57
Tue May 15 14:03:14 2007
Recovery of Online Redo Log: Thread 1 Group 2 Seq 2264 Reading mem 0
  Mem# 0 errs 0: C:\ORACLE\ORADATA\BRANCH\REDO02.LOG
Tue May 15 14:03:15 2007
Errors in file c:\oracle\admin\branch\bdump\branch_smon_1140.trc:
ORA-01595: error freeing extent (90) of rollback segment (4))
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [4194], [15], [17], [], [], [], [], []

Dump file c:\oracle\admin\branch\bdump\alert_branch.log
Tue May 15 14:07:26 2007
ORACLE V9.2.0.6.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.1 Service Pack 2, CPU type 586
Tue May 15 14:07:26 2007
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.6.0.
System parameters with non-default values:
  processes                = 150
  timed_statistics         = TRUE
  resource_limit           = TRUE
  shared_pool_size         = 192937984
  large_pool_size          = 142606336
  java_pool_size           = 33554432
  control_files            = C:\oracle\oradata\branch\control01.ctl, C:\oracle\oradata\branch\control02.ctl, C:\oracle\oradata\branch\control03.ctl
  db_block_size            = 8192
  db_cache_size            = 578813952
  compatible               = 9.2.0.0.0
  log_archive_start        = TRUE
  log_archive_dest_1       = LOCATION=C:\oracle\oradata\branch\archive
  log_archive_format       = %t_%s.arc
  db_file_multiblock_read_count= 16
  fast_start_mttr_target   = 300
  undo_management          = AUTO
  undo_tablespace          = UNDOTBS1
  undo_retention           = 10800
  remote_login_passwordfile= EXCLUSIVE
  db_domain                = STALKER
  instance_name            = branch
  dispatchers              = (PROTOCOL=TCP) (SERVICE=branchXDB)
  utl_file_dir             = *
  job_queue_processes      = 10
  hash_join_enabled        = TRUE
  background_dump_dest     = C:\oracle\admin\branch\bdump
  user_dump_dest           = C:\oracle\admin\branch\udump
  core_dump_dest           = C:\oracle\admin\branch\cdump
  sort_area_size           = 1048576
  db_name                  = branch
  open_cursors             = 300
  star_transformation_enabled= FALSE
  query_rewrite_enabled    = FALSE
  pga_aggregate_target     = 512753664
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
CJQ0 started with pid=8
Tue May 15 14:07:29 2007
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
ARCH: STARTING ARCH PROCESSES
ARC0 started with pid=11
ARC0: Archival started
ARC1 started with pid=12
ARC1: Archival started
Tue May 15 14:07:30 2007
ARCH: STARTING ARCH PROCESSES COMPLETE
Tue May 15 14:07:30 2007
ARC0: Thread not mounted
Tue May 15 14:07:30 2007
ARC1: Thread not mounted
Tue May 15 14:07:30 2007
alter database mount exclusive

Tue May 15 14:18:50 2007
ORACLE V9.2.0.6.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.1 Service Pack 2, CPU type 586
Tue May 15 14:18:50 2007
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.6.0.
System parameters with non-default values:
  processes                = 150
  timed_statistics         = TRUE
  resource_limit           = TRUE
  shared_pool_size         = 192937984
  large_pool_size          = 142606336
  java_pool_size           = 33554432
  control_files            = C:\oracle\oradata\branch\control01.ctl, C:\oracle\oradata\branch\control02.ctl, C:\oracle\oradata\branch\control03.ctl
  db_block_size            = 8192
  db_cache_size            = 578813952
  compatible               = 9.2.0.0.0
  log_archive_start        = TRUE
  log_archive_dest_1       = LOCATION=C:\oracle\oradata\branch\archive
  log_archive_format       = %t_%s.arc
  db_file_multiblock_read_count= 16
  fast_start_mttr_target   = 300
  undo_management          = AUTO
  undo_tablespace          = UNDOTBS1
  undo_retention           = 10800
  remote_login_passwordfile= EXCLUSIVE
  db_domain                = STALKER
  instance_name            = branch
  dispatchers              = (PROTOCOL=TCP) (SERVICE=branchXDB)
  utl_file_dir             = *
  job_queue_processes      = 10
  hash_join_enabled        = TRUE
  background_dump_dest     = C:\oracle\admin\branch\bdump
  user_dump_dest           = C:\oracle\admin\branch\udump
  core_dump_dest           = C:\oracle\admin\branch\cdump
  sort_area_size           = 1048576
  db_name                  = branch
  open_cursors             = 300
  star_transformation_enabled= FALSE
  query_rewrite_enabled    = FALSE
  pga_aggregate_target     = 512753664
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
CJQ0 started with pid=8
Tue May 15 14:18:53 2007
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
ARCH: STARTING ARCH PROCESSES
ARC0 started with pid=11
ARC0: Archival started
ARC1 started with pid=12
ARC1: Archival started
Tue May 15 14:18:54 2007
ARCH: STARTING ARCH PROCESSES COMPLETE
Tue May 15 14:18:54 2007
ARC0: Thread not mounted
Tue May 15 14:18:54 2007
ARC1: Thread not mounted
Tue May 15 14:18:54 2007
alter database mount exclusive
Tue May 15 14:19:01 2007
Successful mount of redo thread 1, with mount id 2869365457
Tue May 15 14:19:01 2007
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Tue May 15 14:19:01 2007
alter database open
Tue May 15 14:19:01 2007
Beginning crash recovery of 1 threads
Tue May 15 14:19:01 2007
Started redo scan
Tue May 15 14:19:02 2007
Completed redo scan
 313 redo blocks read, 114 data blocks need recovery
Tue May 15 14:19:02 2007
Started recovery at
 Thread 1: logseq 2264, block 3, scn 0.0
Tue May 15 14:19:02 2007
Recovery of Online Redo Log: Thread 1 Group 2 Seq 2264 Reading mem 0
  Mem# 0 errs 0: C:\ORACLE\ORADATA\BRANCH\REDO02.LOG
RECOVERY OF THREAD 1 STUCK AT BLOCK 12800 OF FILE 1
ORA-1172 signalled during: alter database open...
Dump file c:\oracle\admin\branch\bdump\alert_branch.log
Tue May 15 14:29:47 2007
ORACLE V9.2.0.6.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.1 Service Pack 2, CPU type 586
Tue May 15 14:29:47 2007
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.6.0.
System parameters with non-default values:
  processes                = 150
  timed_statistics         = TRUE
  resource_limit           = TRUE
  shared_pool_size         = 192937984
  large_pool_size          = 142606336
  java_pool_size           = 33554432
  control_files            = C:\oracle\oradata\branch\control01.ctl, C:\oracle\oradata\branch\control02.ctl, C:\oracle\oradata\branch\control03.ctl
  db_block_size            = 8192
  db_cache_size            = 578813952
  compatible               = 9.2.0.0.0
  log_archive_start        = TRUE
  log_archive_dest_1       = LOCATION=C:\oracle\oradata\branch\archive
  log_archive_format       = %t_%s.arc
  db_file_multiblock_read_count= 16
  fast_start_mttr_target   = 300
  undo_management          = AUTO
  undo_tablespace          = UNDOTBS1
  undo_retention           = 10800
  remote_login_passwordfile= EXCLUSIVE
  db_domain                = STALKER
  instance_name            = branch
  dispatchers              = (PROTOCOL=TCP) (SERVICE=branchXDB)
  utl_file_dir             = *
  job_queue_processes      = 10
  hash_join_enabled        = TRUE
  background_dump_dest     = C:\oracle\admin\branch\bdump
  user_dump_dest           = C:\oracle\admin\branch\udump
  core_dump_dest           = C:\oracle\admin\branch\cdump
  sort_area_size           = 1048576
  db_name                  = branch
  open_cursors             = 300
  star_transformation_enabled= FALSE
  query_rewrite_enabled    = FALSE
  pga_aggregate_target     = 512753664
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
CJQ0 started with pid=8
Tue May 15 14:29:49 2007
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
ARCH: STARTING ARCH PROCESSES
ARC0 started with pid=11
ARC0: Archival started
ARC1 started with pid=12
ARC1: Archival started
Tue May 15 14:29:51 2007
ARCH: STARTING ARCH PROCESSES COMPLETE
Tue May 15 14:29:51 2007
ARC0: Thread not mounted
Tue May 15 14:29:51 2007
ARC1: Thread not mounted
Tue May 15 14:29:51 2007
alter database mount exclusive
Tue May 15 14:29:55 2007
Successful mount of redo thread 1, with mount id 2869390431
Tue May 15 14:29:55 2007
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Tue May 15 14:29:55 2007
alter database open
Tue May 15 14:29:56 2007
Beginning crash recovery of 1 threads
Tue May 15 14:29:56 2007
Started redo scan
Tue May 15 14:29:56 2007
Completed redo scan
 313 redo blocks read, 114 data blocks need recovery
Tue May 15 14:29:56 2007
Started recovery at
 Thread 1: logseq 2264, block 3, scn 0.0
Tue May 15 14:29:56 2007
Recovery of Online Redo Log: Thread 1 Group 2 Seq 2264 Reading mem 0
  Mem# 0 errs 0: C:\ORACLE\ORADATA\BRANCH\REDO02.LOG
RECOVERY OF THREAD 1 STUCK AT BLOCK 12800 OF FILE 1
ORA-1172 signalled during: alter database open...
Tue May 15 14:40:54 2007
/* OracleOEM */ ALTER DATABASE OPEN 
Tue May 15 14:40:55 2007
Beginning crash recovery of 1 threads
Tue May 15 14:40:55 2007
Started redo scan
Tue May 15 14:40:55 2007
Completed redo scan
 313 redo blocks read, 114 data blocks need recovery
Tue May 15 14:40:55 2007
Started recovery at
 Thread 1: logseq 2264, block 3, scn 0.0
Tue May 15 14:40:55 2007
Recovery of Online Redo Log: Thread 1 Group 2 Seq 2264 Reading mem 0
  Mem# 0 errs 0: C:\ORACLE\ORADATA\BRANCH\REDO02.LOG
RECOVERY OF THREAD 1 STUCK AT BLOCK 12800 OF FILE 1
ORA-1172 signalled during: /* OracleOEM */ ALTER DATABASE OPEN ...
Tue May 15 14:42:02 2007
/* OracleOEM */ ALTER DATABASE OPEN 
Tue May 15 14:42:02 2007
Beginning crash recovery of 1 threads
Tue May 15 14:42:02 2007
Started redo scan
Tue May 15 14:42:03 2007
Completed redo scan
 313 redo blocks read, 114 data blocks need recovery
Tue May 15 14:42:03 2007
Started recovery at
 Thread 1: logseq 2264, block 3, scn 0.0
Tue May 15 14:42:03 2007
Recovery of Online Redo Log: Thread 1 Group 2 Seq 2264 Reading mem 0
  Mem# 0 errs 0: C:\ORACLE\ORADATA\BRANCH\REDO02.LOG
RECOVERY OF THREAD 1 STUCK AT BLOCK 12800 OF FILE 1
ORA-1172 signalled during: /* OracleOEM */ ALTER DATABASE OPEN ...
Tue May 15 14:47:32 2007
/* OracleOEM */ ALTER DATABASE OPEN 
Tue May 15 14:47:32 2007
Beginning crash recovery of 1 threads
Tue May 15 14:47:32 2007
Started redo scan
Tue May 15 14:47:33 2007
Completed redo scan
 313 redo blocks read, 114 data blocks need recovery
Tue May 15 14:47:33 2007
Started recovery at
 Thread 1: logseq 2264, block 3, scn 0.0
Tue May 15 14:47:33 2007
Recovery of Online Redo Log: Thread 1 Group 2 Seq 2264 Reading mem 0
  Mem# 0 errs 0: C:\ORACLE\ORADATA\BRANCH\REDO02.LOG
RECOVERY OF THREAD 1 STUCK AT BLOCK 12800 OF FILE 1
ORA-1172 signalled during: /* OracleOEM */ ALTER DATABASE OPEN ...
Tue May 15 14:52:16 2007
ALTER DATABASE RECOVER  automatic database  
Tue May 15 14:52:16 2007
Media Recovery Start
Tue May 15 14:52:16 2007
Recovery of Online Redo Log: Thread 1 Group 2 Seq 2264 Reading mem 0
  Mem# 0 errs 0: C:\ORACLE\ORADATA\BRANCH\REDO02.LOG
Tue May 15 14:52:17 2007
Errors in file c:\oracle\admin\branch\udump\branch_ora_3804.trc:
ORA-00600: internal error code, arguments: [3020], [4207104], [1], [2264], [220], [48], [], []
ORA-10567: Redo is inconsistent with data block (file# 1, block# 12800)
ORA-10564: tablespace SYSTEM
ORA-01110: data file 1: 'C:\ORACLE\ORADATA\BRANCH\SYSTEM01.DBF'
ORA-10561: block type 'TRANSACTION MANAGED DATA BLOCK', data object# 2

Tue May 15 14:52:18 2007
Media Recovery failed with error 600
ORA-283 signalled during: ALTER DATABASE RECOVER  automatic database  ...
Dump file c:\oracle\admin\branch\bdump\alert_branch.log
Tue May 15 14:57:08 2007
ORACLE V9.2.0.6.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.1 Service Pack 2, CPU type 586
Tue May 15 14:57:08 2007
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.6.0.
System parameters with non-default values:
  processes                = 150
  timed_statistics         = TRUE
  resource_limit           = TRUE
  shared_pool_size         = 192937984
  large_pool_size          = 142606336
  java_pool_size           = 33554432
  control_files            = C:\oracle\oradata\branch\control01.ctl, C:\oracle\oradata\branch\control02.ctl, C:\oracle\oradata\branch\control03.ctl
  db_block_size            = 8192
  db_cache_size            = 578813952
  compatible               = 9.2.0.0.0
  log_archive_start        = TRUE
  log_archive_dest_1       = LOCATION=C:\oracle\oradata\branch\archive
  log_archive_format       = %t_%s.arc
  db_file_multiblock_read_count= 16
  fast_start_mttr_target   = 300
  undo_management          = AUTO
  undo_tablespace          = UNDOTBS1
  undo_retention           = 10800
  remote_login_passwordfile= EXCLUSIVE
  db_domain                = STALKER
  instance_name            = branch
  dispatchers              = (PROTOCOL=TCP) (SERVICE=branchXDB)
  utl_file_dir             = *
  job_queue_processes      = 10
  hash_join_enabled        = TRUE
  background_dump_dest     = C:\oracle\admin\branch\bdump
  user_dump_dest           = C:\oracle\admin\branch\udump
  core_dump_dest           = C:\oracle\admin\branch\cdump
  sort_area_size           = 1048576
  db_name                  = branch
  open_cursors             = 300
  star_transformation_enabled= FALSE
  query_rewrite_enabled    = FALSE
  pga_aggregate_target     = 512753664
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
CJQ0 started with pid=8
Tue May 15 14:57:11 2007
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
ARCH: STARTING ARCH PROCESSES
ARC0 started with pid=11
ARC0: Archival started
ARC1 started with pid=12
ARC1: Archival started
Tue May 15 14:57:13 2007
ARCH: STARTING ARCH PROCESSES COMPLETE
Tue May 15 14:57:13 2007
ARC0: Thread not mounted
Tue May 15 14:57:13 2007
ARC1: Thread not mounted
Tue May 15 14:57:13 2007
alter database mount exclusive
Tue May 15 14:57:17 2007
Successful mount of redo thread 1, with mount id 2869407689
Tue May 15 14:57:17 2007
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Tue May 15 14:57:17 2007
alter database open
Tue May 15 14:57:18 2007
Beginning crash recovery of 1 threads
Tue May 15 14:57:18 2007
Started redo scan
Tue May 15 14:57:18 2007
Completed redo scan
 313 redo blocks read, 71 data blocks need recovery
Tue May 15 14:57:19 2007
Started recovery at
 Thread 1: logseq 2264, block 3, scn 0.0
Tue May 15 14:57:19 2007
Recovery of Online Redo Log: Thread 1 Group 2 Seq 2264 Reading mem 0
  Mem# 0 errs 0: C:\ORACLE\ORADATA\BRANCH\REDO02.LOG
RECOVERY OF THREAD 1 STUCK AT BLOCK 12800 OF FILE 1
ORA-1172 signalled during: alter database open...
Tue May 15 15:03:41 2007
/* OracleOEM */ ALTER DATABASE OPEN 
Tue May 15 15:03:41 2007
Beginning crash recovery of 1 threads
Tue May 15 15:03:41 2007
Started redo scan
Tue May 15 15:03:42 2007
Completed redo scan
 313 redo blocks read, 71 data blocks need recovery
Tue May 15 15:03:42 2007
Started recovery at
 Thread 1: logseq 2264, block 3, scn 0.0
Tue May 15 15:03:42 2007
Recovery of Online Redo Log: Thread 1 Group 2 Seq 2264 Reading mem 0
  Mem# 0 errs 0: C:\ORACLE\ORADATA\BRANCH\REDO02.LOG
RECOVERY OF THREAD 1 STUCK AT BLOCK 12800 OF FILE 1
ORA-1172 signalled during: /* OracleOEM */ ALTER DATABASE OPEN ...
Tue May 15 15:05:52 2007
ALTER DATABASE RECOVER  automatic database  
Tue May 15 15:05:52 2007
Media Recovery Start
Tue May 15 15:05:52 2007
Recovery of Online Redo Log: Thread 1 Group 2 Seq 2264 Reading mem 0
  Mem# 0 errs 0: C:\ORACLE\ORADATA\BRANCH\REDO02.LOG
Tue May 15 15:05:53 2007
Errors in file c:\oracle\admin\branch\udump\branch_ora_2440.trc:
ORA-00600: internal error code, arguments: [3020], [4207104], [1], [2264], [220], [48], [], []
ORA-10567: Redo is inconsistent with data block (file# 1, block# 12800)
ORA-10564: tablespace SYSTEM
ORA-01110: data file 1: 'C:\ORACLE\ORADATA\BRANCH\SYSTEM01.DBF'
ORA-10561: block type 'TRANSACTION MANAGED DATA BLOCK', data object# 2

Tue May 15 15:05:54 2007
Media Recovery failed with error 600
ORA-283 signalled during: ALTER DATABASE RECOVER  automatic database  ...
Tue May 15 15:09:01 2007
Shutting down instance: further logons disabled
Shutting down instance (immediate)
License high water mark = 2
All dispatchers and shared servers shutdown
Tue May 15 15:09:10 2007
ALTER DATABASE CLOSE NORMAL
ORA-1109 signalled during: ALTER DATABASE CLOSE NORMAL...
Tue May 15 15:09:10 2007
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Tue May 15 15:09:13 2007
ARCH shutting down
ARC0: Archival stopped
Tue May 15 15:09:13 2007
ARCH shutting down
ARC1: Archival stopped
Tue May 15 15:09:14 2007
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Tue May 15 15:10:33 2007
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.6.0.
System parameters with non-default values:
  processes                = 150
  timed_statistics         = TRUE
  resource_limit           = TRUE
  shared_pool_size         = 192937984
  large_pool_size          = 142606336
  java_pool_size           = 33554432
  control_files            = C:\oracle\oradata\branch\control01.ctl, C:\oracle\oradata\branch\control02.ctl, C:\oracle\oradata\branch\control03.ctl
  db_block_size            = 8192
  db_cache_size            = 578813952
  compatible               = 9.2.0.0.0
  log_archive_start        = TRUE
  log_archive_dest_1       = LOCATION=C:\oracle\oradata\branch\archive
  log_archive_format       = %t_%s.arc
  db_file_multiblock_read_count= 16
  fast_start_mttr_target   = 300
  undo_management          = AUTO
  undo_tablespace          = UNDOTBS1
  undo_retention           = 10800
  remote_login_passwordfile= EXCLUSIVE
  db_domain                = STALKER
  instance_name            = branch
  dispatchers              = (PROTOCOL=TCP) (SERVICE=branchXDB)
  utl_file_dir             = *
  job_queue_processes      = 10
  hash_join_enabled        = TRUE
  background_dump_dest     = C:\oracle\admin\branch\bdump
  user_dump_dest           = C:\oracle\admin\branch\udump
  core_dump_dest           = C:\oracle\admin\branch\cdump
  sort_area_size           = 1048576
  db_name                  = branch
  open_cursors             = 300
  star_transformation_enabled= FALSE
  query_rewrite_enabled    = FALSE
  pga_aggregate_target     = 512753664
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
CJQ0 started with pid=8
Tue May 15 15:10:35 2007
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
ARCH: STARTING ARCH PROCESSES
ARC0 started with pid=11
ARC0: Archival started
ARC1 started with pid=12
ARC1: Archival started
Tue May 15 15:10:37 2007
ARCH: STARTING ARCH PROCESSES COMPLETE
Tue May 15 15:10:37 2007
ARC0: Thread not mounted
Tue May 15 15:10:37 2007
ARC1: Thread not mounted
Tue May 15 15:10:37 2007
ALTER DATABASE   MOUNT
Tue May 15 15:10:41 2007
Successful mount of redo thread 1, with mount id 2869397229
Tue May 15 15:10:41 2007
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE   MOUNT
Tue May 15 15:10:41 2007
ALTER DATABASE OPEN
Tue May 15 15:10:41 2007
Beginning crash recovery of 1 threads
Tue May 15 15:10:41 2007
Started redo scan
Tue May 15 15:10:42 2007
Completed redo scan
 314 redo blocks read, 71 data blocks need recovery
Tue May 15 15:10:42 2007
Started recovery at
 Thread 1: logseq 2264, block 2, scn 0.95784782
Tue May 15 15:10:42 2007
Recovery of Online Redo Log: Thread 1 Group 2 Seq 2264 Reading mem 0
  Mem# 0 errs 0: C:\ORACLE\ORADATA\BRANCH\REDO02.LOG
RECOVERY OF THREAD 1 STUCK AT BLOCK 12800 OF FILE 1
ORA-1172 signalled during: ALTER DATABASE OPEN...
Tue May 15 15:12:06 2007
ALTER DATABASE RECOVER  automatic database  
Tue May 15 15:12:06 2007
Media Recovery Start
Tue May 15 15:12:06 2007
Recovery of Online Redo Log: Thread 1 Group 2 Seq 2264 Reading mem 0
  Mem# 0 errs 0: C:\ORACLE\ORADATA\BRANCH\REDO02.LOG
Tue May 15 15:12:07 2007
Errors in file c:\oracle\admin\branch\udump\branch_ora_528.trc:
ORA-00600: internal error code, arguments: [3020], [4207104], [1], [2264], [220], [48], [], []
ORA-10567: Redo is inconsistent with data block (file# 1, block# 12800)
ORA-10564: tablespace SYSTEM
ORA-01110: data file 1: 'C:\ORACLE\ORADATA\BRANCH\SYSTEM01.DBF'
ORA-10561: block type 'TRANSACTION MANAGED DATA BLOCK', data object# 2

Tue May 15 15:12:09 2007
Media Recovery failed with error 600
ORA-283 signalled during: ALTER DATABASE RECOVER  automatic database  ...
Tue May 15 15:14:33 2007
ALTER DATABASE RECOVER  datafile 'c:\oracle\oradata\branch\system01.dbf'  
Media Recovery Start
Tue May 15 15:14:33 2007
Recovery of Online Redo Log: Thread 1 Group 2 Seq 2264 Reading mem 0
  Mem# 0 errs 0: C:\ORACLE\ORADATA\BRANCH\REDO02.LOG
Tue May 15 15:14:34 2007
Errors in file c:\oracle\admin\branch\udump\branch_ora_528.trc:
ORA-00600: internal error code, arguments: [3020], [4207104], [1], [2264], [220], [48], [], []
ORA-10567: Redo is inconsistent with data block (file# 1, block# 12800)
ORA-10564: tablespace SYSTEM
ORA-01110: data file 1: 'C:\ORACLE\ORADATA\BRANCH\SYSTEM01.DBF'
ORA-10561: block type 'TRANSACTION MANAGED DATA BLOCK', data object# 2

Tue May 15 15:14:35 2007
Media Recovery failed with error 600
ORA-283 signalled during: ALTER DATABASE RECOVER  datafile 'c:\oracle\oradat...
Dump file c:\oracle\admin\branch\bdump\alert_branch.log
Wed May 16 15:28:11 2007
ORACLE V9.2.0.6.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.1 Service Pack 2, CPU type 586
Wed May 16 15:28:11 2007
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.6.0.
System parameters with non-default values:
  processes                = 150
  timed_statistics         = TRUE
  resource_limit           = TRUE
  shared_pool_size         = 192937984
  large_pool_size          = 142606336
  java_pool_size           = 33554432
  control_files            = C:\oracle\oradata\branch\control01.ctl, C:\oracle\oradata\branch\control02.ctl, C:\oracle\oradata\branch\control03.ctl
  db_block_size            = 8192
  db_cache_size            = 578813952
  compatible               = 9.2.0.0.0
  log_archive_start        = TRUE
  log_archive_dest_1       = LOCATION=C:\oracle\oradata\branch\archive
  log_archive_format       = %t_%s.arc
  db_file_multiblock_read_count= 16
  fast_start_mttr_target   = 300
  undo_management          = AUTO
  undo_tablespace          = UNDOTBS1
  undo_retention           = 10800
  remote_login_passwordfile= EXCLUSIVE
  db_domain                = STALKER
  instance_name            = branch
  dispatchers              = (PROTOCOL=TCP) (SERVICE=branchXDB)
  utl_file_dir             = *
  job_queue_processes      = 10
  hash_join_enabled        = TRUE
  background_dump_dest     = C:\oracle\admin\branch\bdump
  user_dump_dest           = C:\oracle\admin\branch\udump
  core_dump_dest           = C:\oracle\admin\branch\cdump
  sort_area_size           = 1048576
  db_name                  = branch
  open_cursors             = 300
  star_transformation_enabled= FALSE
  query_rewrite_enabled    = FALSE
  pga_aggregate_target     = 512753664
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
CJQ0 started with pid=8
Wed May 16 15:28:13 2007
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
ARCH: STARTING ARCH PROCESSES
ARC0 started with pid=11
ARC0: Archival started
ARC1 started with pid=12
ARC1: Archival started
Wed May 16 15:28:14 2007
ARCH: STARTING ARCH PROCESSES COMPLETE
Wed May 16 15:28:14 2007
ARC0: Thread not mounted
Wed May 16 15:28:14 2007
ARC1: Thread not mounted
Wed May 16 15:28:14 2007
alter database mount exclusive
Wed May 16 15:28:19 2007
Successful mount of redo thread 1, with mount id 2869543566
Wed May 16 15:28:19 2007
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Wed May 16 15:28:19 2007
alter database open
Wed May 16 15:28:19 2007
Beginning crash recovery of 1 threads
Wed May 16 15:28:19 2007
Started redo scan
Wed May 16 15:28:20 2007
Completed redo scan
 314 redo blocks read, 71 data blocks need recovery
Wed May 16 15:28:20 2007
Started recovery at
 Thread 1: logseq 2264, block 2, scn 0.95784782
Wed May 16 15:28:20 2007
Recovery of Online Redo Log: Thread 1 Group 2 Seq 2264 Reading mem 0
  Mem# 0 errs 0: C:\ORACLE\ORADATA\BRANCH\REDO02.LOG
RECOVERY OF THREAD 1 STUCK AT BLOCK 12800 OF FILE 1
ORA-1172 signalled during: alter database open...
Wed May 16 15:29:13 2007
/* OracleOEM */ ALTER DATABASE OPEN 
Wed May 16 15:29:14 2007
Beginning crash recovery of 1 threads
Wed May 16 15:29:14 2007
Started redo scan
Wed May 16 15:29:14 2007
Completed redo scan
 314 redo blocks read, 71 data blocks need recovery
Wed May 16 15:29:14 2007
Started recovery at
 Thread 1: logseq 2264, block 2, scn 0.95784782
Wed May 16 15:29:14 2007
Recovery of Online Redo Log: Thread 1 Group 2 Seq 2264 Reading mem 0
  Mem# 0 errs 0: C:\ORACLE\ORADATA\BRANCH\REDO02.LOG
RECOVERY OF THREAD 1 STUCK AT BLOCK 12800 OF FILE 1
ORA-1172 signalled during: /* OracleOEM */ ALTER DATABASE OPEN ...
Wed May 16 15:43:14 2007
alter database recover datafile 'c:\oracle\oradata\branch\system01.dbf'

Wed May 16 15:43:14 2007
Media Recovery Start
Wed May 16 15:43:14 2007
Recovery of Online Redo Log: Thread 1 Group 2 Seq 2264 Reading mem 0
  Mem# 0 errs 0: C:\ORACLE\ORADATA\BRANCH\REDO02.LOG
Wed May 16 15:43:15 2007
Errors in file c:\oracle\admin\branch\udump\branch_ora_3228.trc:
ORA-00600: internal error code, arguments: [3020], [4207104], [1], [2264], [220], [48], [], []
ORA-10567: Redo is inconsistent with data block (file# 1, block# 12800)
ORA-10564: tablespace SYSTEM
ORA-01110: data file 1: 'C:\ORACLE\ORADATA\BRANCH\SYSTEM01.DBF'
ORA-10561: block type 'TRANSACTION MANAGED DATA BLOCK', data object# 2

Wed May 16 15:43:15 2007
Media Recovery failed with error 600
ORA-283 signalled during: alter database recover datafile 'c:\oracle\oradata...
Dump file c:\oracle\admin\branch\bdump\alert_branch.log
Wed May 16 15:59:41 2007
ORACLE V9.2.0.6.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.1 Service Pack 2, CPU type 586
Wed May 16 15:59:41 2007
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.6.0.
System parameters with non-default values:
  processes                = 150
  timed_statistics         = TRUE
  resource_limit           = TRUE
  shared_pool_size         = 192937984
  large_pool_size          = 142606336
  java_pool_size           = 33554432
  control_files            = C:\oracle\oradata\branch\control01.ctl, C:\oracle\oradata\branch\control02.ctl, C:\oracle\oradata\branch\control03.ctl
  db_block_size            = 8192
  db_cache_size            = 578813952
  compatible               = 9.2.0.0.0
  log_archive_start        = TRUE
  log_archive_dest_1       = LOCATION=C:\oracle\oradata\branch\archive
  log_archive_format       = %t_%s.arc
  db_file_multiblock_read_count= 16
  fast_start_mttr_target   = 300
  undo_management          = AUTO
  undo_tablespace          = UNDOTBS1
  undo_retention           = 10800
  remote_login_passwordfile= EXCLUSIVE
  db_domain                = STALKER
  instance_name            = branch
  dispatchers              = (PROTOCOL=TCP) (SERVICE=branchXDB)
  utl_file_dir             = *
  job_queue_processes      = 10
  hash_join_enabled        = TRUE
  background_dump_dest     = C:\oracle\admin\branch\bdump
  user_dump_dest           = C:\oracle\admin\branch\udump
  core_dump_dest           = C:\oracle\admin\branch\cdump
  sort_area_size           = 1048576
  db_name                  = branch
  open_cursors             = 300
  star_transformation_enabled= FALSE
  query_rewrite_enabled    = FALSE
  pga_aggregate_target     = 512753664
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
CJQ0 started with pid=8
Wed May 16 15:59:44 2007
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
ARCH: STARTING ARCH PROCESSES
ARC0 started with pid=11
ARC0: Archival started
ARC1 started with pid=12
ARC1: Archival started
Wed May 16 15:59:46 2007
ARCH: STARTING ARCH PROCESSES COMPLETE
Wed May 16 15:59:46 2007
ARC0: Thread not mounted
Wed May 16 15:59:46 2007
ARC1: Thread not mounted
Wed May 16 15:59:46 2007
alter database mount exclusive
Wed May 16 15:59:52 2007
Successful mount of redo thread 1, with mount id 2869535476
Wed May 16 15:59:52 2007
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Wed May 16 15:59:52 2007
alter database open
ORA-1122 signalled during: alter database open...
Wed May 16 16:01:34 2007
/* OracleOEM */ ALTER DATABASE OPEN 
Wed May 16 16:01:34 2007
ORA-1122 signalled during: /* OracleOEM */ ALTER DATABASE OPEN ...
Wed May 16 16:01:51 2007
/* OracleOEM */ ALTER DATABASE OPEN 
Wed May 16 16:01:51 2007
ORA-1122 signalled during: /* OracleOEM */ ALTER DATABASE OPEN ...
Wed May 16 16:04:00 2007
/* OracleOEM */ ALTER DATABASE OPEN 
Wed May 16 16:04:00 2007
ORA-1122 signalled during: /* OracleOEM */ ALTER DATABASE OPEN ...
Wed May 16 16:05:18 2007
ALTER DATABASE RECOVER  datafile 'c:\oracle\oradata\branch\system01.dbf'  
Wed May 16 16:05:18 2007
Media Recovery Start
Wed May 16 16:05:18 2007
Media Recovery failed with error 1110
ORA-283 signalled during: ALTER DATABASE RECOVER  datafile 'c:\oracle\oradat...
Wed May 16 16:05:44 2007
Shutting down instance: further logons disabled
Shutting down instance (immediate)
License high water mark = 5
Waiting for dispatcher 'D000' to shutdown
All dispatchers and shared servers shutdown
Wed May 16 16:05:46 2007
ALTER DATABASE CLOSE NORMAL
ORA-1109 signalled during: ALTER DATABASE CLOSE NORMAL...
Wed May 16 16:05:46 2007
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Wed May 16 16:05:49 2007
ARCH shutting down
Wed May 16 16:05:49 2007
ARCH shutting down
Wed May 16 16:05:49 2007
ARC0: Archival stopped
Wed May 16 16:05:49 2007
ARC1: Archival stopped
Wed May 16 16:05:50 2007
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Wed May 16 16:10:07 2007
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.6.0.
System parameters with non-default values:
  processes                = 150
  timed_statistics         = TRUE
  resource_limit           = TRUE
  shared_pool_size         = 192937984
  large_pool_size          = 142606336
  java_pool_size           = 33554432
  control_files            = C:\oracle\oradata\branch\control01.ctl, C:\oracle\oradata\branch\control02.ctl, C:\oracle\oradata\branch\control03.ctl
  db_block_size            = 8192
  db_cache_size            = 578813952
  compatible               = 9.2.0.0.0
  log_archive_start        = TRUE
  log_archive_dest_1       = LOCATION=C:\oracle\oradata\branch\archive
  log_archive_format       = %t_%s.arc
  db_file_multiblock_read_count= 16
  fast_start_mttr_target   = 300
  undo_management          = AUTO
  undo_tablespace          = UNDOTBS1
  undo_retention           = 10800
  remote_login_passwordfile= EXCLUSIVE
  db_domain                = STALKER
  instance_name            = branch
  dispatchers              = (PROTOCOL=TCP) (SERVICE=branchXDB)
  utl_file_dir             = *
  job_queue_processes      = 10
  hash_join_enabled        = TRUE
  background_dump_dest     = C:\oracle\admin\branch\bdump
  user_dump_dest           = C:\oracle\admin\branch\udump
  core_dump_dest           = C:\oracle\admin\branch\cdump
  sort_area_size           = 1048576
  db_name                  = branch
  open_cursors             = 300
  star_transformation_enabled= FALSE
  query_rewrite_enabled    = FALSE
  pga_aggregate_target     = 512753664
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
CJQ0 started with pid=8
Wed May 16 16:10:10 2007
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
ARCH: STARTING ARCH PROCESSES
ARC0 started with pid=11
ARC0: Archival started
ARC1 started with pid=12
ARC1: Archival started
Wed May 16 16:10:11 2007
ARCH: STARTING ARCH PROCESSES COMPLETE
Wed May 16 16:10:11 2007
ARC0: Thread not mounted
Wed May 16 16:10:11 2007
ARC1: Thread not mounted
Wed May 16 16:22:52 2007
create controlfile set database test resetlogs noarchivelog
maxlogfiles 50
maxlogmembers 5
maxdatafiles 100
maxinstances 1
maxloghistory 226
logfile
group 1 'c:\oracle\oradata\branch\redo01.log' size 100m,
group 2 'c:\oracle\oradata\branch\redo02.log' size 100m,
group 3 'c:\oracle\oradata\branch\redo03.log' size 100m
datafile 'c:\oracle\oradata\branch\system01.dbf','c:\oracle\oradata\branch\undotbs01.dbf'
character set cl8mswin1251
Wed May 16 16:22:52 2007
ORA-1503 signalled during: create controlfile set database test resetlogs noa...
Wed May 16 16:24:41 2007
ALTER DATABASE RECOVER  datafile 1  
Wed May 16 16:24:41 2007
ORA-1507 signalled during: ALTER DATABASE RECOVER  datafile 1  ...
Wed May 16 16:25:31 2007
Shutting down instance: further logons disabled
Shutting down instance (immediate)
License high water mark = 3
All dispatchers and shared servers shutdown
Wed May 16 16:25:35 2007
ALTER DATABASE CLOSE NORMAL
ORA-1507 signalled during: ALTER DATABASE CLOSE NORMAL...
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Wed May 16 16:25:35 2007
ARCH shutting down
ARC0: Archival stopped
Wed May 16 16:25:35 2007
ARCH shutting down
ARC1: Archival stopped
Wed May 16 16:25:38 2007
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Wed May 16 16:25:47 2007
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.6.0.
System parameters with non-default values:
  processes                = 150
  timed_statistics         = TRUE
  resource_limit           = TRUE
  shared_pool_size         = 192937984
  large_pool_size          = 142606336
  java_pool_size           = 33554432
  control_files            = C:\oracle\oradata\branch\control01.ctl, C:\oracle\oradata\branch\control02.ctl, C:\oracle\oradata\branch\control03.ctl
  db_block_size            = 8192
  db_cache_size            = 578813952
  compatible               = 9.2.0.0.0
  log_archive_start        = TRUE
  log_archive_dest_1       = LOCATION=C:\oracle\oradata\branch\archive
  log_archive_format       = %t_%s.arc
  db_file_multiblock_read_count= 16
  fast_start_mttr_target   = 300
  undo_management          = AUTO
  undo_tablespace          = UNDOTBS1
  undo_retention           = 10800
  remote_login_passwordfile= EXCLUSIVE
  db_domain                = STALKER
  instance_name            = branch
  dispatchers              = (PROTOCOL=TCP) (SERVICE=branchXDB)
  utl_file_dir             = *
  job_queue_processes      = 10
  hash_join_enabled        = TRUE
  background_dump_dest     = C:\oracle\admin\branch\bdump
  user_dump_dest           = C:\oracle\admin\branch\udump
  core_dump_dest           = C:\oracle\admin\branch\cdump
  sort_area_size           = 1048576
  db_name                  = branch
  open_cursors             = 300
  star_transformation_enabled= FALSE
  query_rewrite_enabled    = FALSE
  pga_aggregate_target     = 512753664
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
CJQ0 started with pid=8
Wed May 16 16:25:49 2007
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
ARCH: STARTING ARCH PROCESSES
ARC0 started with pid=11
ARC0: Archival started
ARC1 started with pid=12
ARC1: Archival started
Wed May 16 16:25:50 2007
ARCH: STARTING ARCH PROCESSES COMPLETE
Wed May 16 16:25:50 2007
ARC0: Thread not mounted
Wed May 16 16:25:50 2007
ARC1: Thread not mounted
Wed May 16 16:25:50 2007
ALTER DATABASE   MOUNT
Wed May 16 16:25:50 2007
ORA-00202: controlfile: 'C:\oracle\oradata\branch\control01.ctl'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) ═х єфрхЄё  эрщЄш єърчрээ√щ Їрщы.

Wed May 16 16:25:53 2007
ORA-205 signalled during: ALTER DATABASE   MOUNT...
Wed May 16 16:26:03 2007
ALTER DATABASE RECOVER  datafile 1  
ORA-1507 signalled during: ALTER DATABASE RECOVER  datafile 1  ...
Wed May 16 16:26:25 2007
Starting ORACLE instance (normal)
Wed May 16 16:26:41 2007
Shutting down instance: further logons disabled
Shutting down instance (immediate)
License high water mark = 2
All dispatchers and shared servers shutdown
Wed May 16 16:26:44 2007
ALTER DATABASE CLOSE NORMAL
ORA-1507 signalled during: ALTER DATABASE CLOSE NORMAL...
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Wed May 16 16:26:44 2007
ARCH shutting down
ARC0: Archival stopped
Wed May 16 16:26:44 2007
ARCH shutting down
ARC1: Archival stopped
Wed May 16 16:26:48 2007
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Wed May 16 16:26:52 2007
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.6.0.
System parameters with non-default values:
  processes                = 150
  timed_statistics         = TRUE
  resource_limit           = TRUE
  shared_pool_size         = 192937984
  large_pool_size          = 142606336
  java_pool_size           = 33554432
  control_files            = C:\oracle\oradata\branch\control01.ctl, C:\oracle\oradata\branch\control02.ctl, C:\oracle\oradata\branch\control03.ctl
  db_block_size            = 8192
  db_cache_size            = 578813952
  compatible               = 9.2.0.0.0
  log_archive_start        = TRUE
  log_archive_dest_1       = LOCATION=C:\oracle\oradata\baza01\archive
  log_archive_format       = %t_%s.arc
  db_file_multiblock_read_count= 16
  fast_start_mttr_target   = 300
  undo_management          = AUTO
  undo_tablespace          = UNDOTBS1
  undo_retention           = 10800
  remote_login_passwordfile= EXCLUSIVE
  db_domain                = STALKER
  instance_name            = baza01
  dispatchers              = (PROTOCOL=TCP) (SERVICE=baza01XDB)
  utl_file_dir             = *
  job_queue_processes      = 10
  hash_join_enabled        = TRUE
  background_dump_dest     = C:\oracle\admin\baza01\bdump
  user_dump_dest           = C:\oracle\admin\baza01\udump
  core_dump_dest           = C:\oracle\admin\baza01\cdump
  sort_area_size           = 1048576
  db_name                  = baza01
  open_cursors             = 300
  star_transformation_enabled= FALSE
  query_rewrite_enabled    = FALSE
  pga_aggregate_target     = 512753664
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
CJQ0 started with pid=8
Wed May 16 16:26:55 2007
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
ARCH: STARTING ARCH PROCESSES
ARC0 started with pid=11
ARC0: Archival started
ARC1 started with pid=12
ARC1: Archival started
Wed May 16 16:26:56 2007
ARCH: STARTING ARCH PROCESSES COMPLETE
Wed May 16 16:26:56 2007
ARC0: Thread not mounted
Wed May 16 16:26:56 2007
ARC1: Thread not mounted
Wed May 16 16:26:56 2007
ALTER DATABASE   MOUNT
Wed May 16 16:27:00 2007
Successful mount of redo thread 1, with mount id 2869529168
Wed May 16 16:27:00 2007
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE   MOUNT
Wed May 16 16:27:04 2007
ALTER DATABASE RECOVER  datafile 1  
Media Recovery Start
Wed May 16 16:27:04 2007
Errors in file c:\oracle\admin\baza01\bdump\baza01_dbw0_2324.trc:
ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
ORA-01110: data file 1: 'C:\ORACLE\ORADATA\baza01\SYSTEM01.DBF'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) ═х єфрхЄё  эрщЄш єърчрээ√щ Їрщы.

Wed May 16 16:27:04 2007
Media Recovery failed with error 1110
ORA-283 signalled during: ALTER DATABASE RECOVER  datafile 1  ...
Wed May 16 16:27:28 2007
Shutting down instance: further logons disabled
Shutting down instance (immediate)
License high water mark = 2
All dispatchers and shared servers shutdown
Wed May 16 16:27:31 2007
ALTER DATABASE CLOSE NORMAL
ORA-1109 signalled during: ALTER DATABASE CLOSE NORMAL...
Wed May 16 16:27:31 2007
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Wed May 16 16:27:34 2007
ARCH shutting down
ARC0: Archival stopped
Wed May 16 16:27:34 2007
ARCH shutting down
ARC1: Archival stopped
Wed May 16 16:27:35 2007
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Wed May 16 16:27:54 2007
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.6.0.
System parameters with non-default values:
  processes                = 150
  timed_statistics         = TRUE
  resource_limit           = TRUE
  shared_pool_size         = 192937984
  large_pool_size          = 142606336
  java_pool_size           = 33554432
  control_files            = C:\oracle\oradata\baza01\control01.ctl, C:\oracle\oradata\baza01\control02.ctl, C:\oracle\oradata\baza01\control03.ctl
  db_block_size            = 8192
  db_cache_size            = 578813952
  compatible               = 9.2.0.0.0
  log_archive_start        = TRUE
  log_archive_dest_1       = LOCATION=C:\oracle\oradata\baza01\archive
  log_archive_format       = %t_%s.arc
  db_file_multiblock_read_count= 16
  fast_start_mttr_target   = 300
  undo_management          = AUTO
  undo_tablespace          = UNDOTBS1
  undo_retention           = 10800
  remote_login_passwordfile= EXCLUSIVE
  db_domain                = STALKER
  instance_name            = baza01
  dispatchers              = (PROTOCOL=TCP) (SERVICE=baza01XDB)
  utl_file_dir             = *
  job_queue_processes      = 10
  hash_join_enabled        = TRUE
  background_dump_dest     = C:\oracle\admin\baza01\bdump
  user_dump_dest           = C:\oracle\admin\baza01\udump
  core_dump_dest           = C:\oracle\admin\baza01\cdump
  sort_area_size           = 1048576
  db_name                  = baza01
  open_cursors             = 300
  star_transformation_enabled= FALSE
  query_rewrite_enabled    = FALSE
  pga_aggregate_target     = 512753664
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
CJQ0 started with pid=8
Wed May 16 16:27:56 2007
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
ARCH: STARTING ARCH PROCESSES
ARC0 started with pid=11
ARC0: Archival started
ARC1 started with pid=12
ARC1: Archival started
Wed May 16 16:27:57 2007
ARCH: STARTING ARCH PROCESSES COMPLETE
Wed May 16 16:27:57 2007
ARC0: Thread not mounted
Wed May 16 16:27:57 2007
ARC1: Thread not mounted
Wed May 16 16:32:14 2007
create controlfile set database baza01 noresetlogs archivelog
maxlogfiles 50
maxlogmembers 5
maxdatafiles 100
maxinstances 1
maxloghistory 226
logfile
group 1 'c:\oracle\oradata\baza01\redo01.log' size 100m,
group 2 'c:\oracle\oradata\baza01\redo02.log' size 100m,
group 3 'c:\oracle\oradata\baza01\redo03.log' size 100m
datafile 'c:\oracle\oradata\baza01\system01.dbf','c:\oracle\oradata\baza01\undotbs01.dbf'
character set cl8mswin1251
Wed May 16 16:32:14 2007
ORA-1503 signalled during: create controlfile set database baza01 noresetlogs...
Wed May 16 16:32:53 2007
create controlfile set database baza01 resetlogs archivelog
maxlogfiles 50
maxlogmembers 5
maxdatafiles 100
maxinstances 1
maxloghistory 226
logfile
group 1 'c:\oracle\oradata\baza01\redo01.log' size 100m,
group 2 'c:\oracle\oradata\baza01\redo02.log' size 100m,
group 3 'c:\oracle\oradata\baza01\redo03.log' size 100m
datafile 'c:\oracle\oradata\baza01\system01.dbf','c:\oracle\oradata\baza01\undotbs01.dbf'
character set cl8mswin1251
Wed May 16 16:32:56 2007
ORA-1503 signalled during: create controlfile set database baza01 resetlogs a...
Wed May 16 16:35:54 2007
create controlfile set database baza01 noresetlogs archivelog
maxlogfiles 50
maxlogmembers 5
maxdatafiles 100
maxinstances 1
maxloghistory 226
logfile
group 1 'c:\oracle\oradata\baza01\redo01.log' size 100m,
group 2 'c:\oracle\oradata\baza01\redo02.log' size 100m,
group 3 'c:\oracle\oradata\baza01\redo03.log' size 100m
datafile
'c:\oracle\oradata\baza01\SYSTEM01.DBF',
'c:\oracle\oradata\baza01\UNDOTBS01.DBF'
character set cl8mswin1251
Wed May 16 16:35:54 2007
ORA-1503 signalled during: create controlfile set database baza01 noresetlogs...
Wed May 16 16:36:26 2007
create controlfile set database baza01 resetlogs archivelog
maxlogfiles 50
maxlogmembers 5
maxdatafiles 100
maxinstances 1
maxloghistory 226
logfile
group 1 'c:\oracle\oradata\baza01\redo01.log' size 100m,
group 2 'c:\oracle\oradata\baza01\redo02.log' size 100m,
group 3 'c:\oracle\oradata\baza01\redo03.log' size 100m
datafile
'c:\oracle\oradata\baza01\SYSTEM01.DBF',
'c:\oracle\oradata\baza01\UNDOTBS01.DBF'
character set cl8mswin1251
Wed May 16 16:36:29 2007
ORA-1503 signalled during: create controlfile set database baza01 resetlogs a...
Wed May 16 16:37:38 2007
create controlfile set database baza01 resetlogs archivelog
maxlogfiles 50
maxlogmembers 5
maxdatafiles 100
maxinstances 1
maxloghistory 226
logfile
group 1 'c:\oracle\oradata\baza01\redo01.log' size 100m,
group 2 'c:\oracle\oradata\baza01\redo02.log' size 100m,
group 3 'c:\oracle\oradata\baza01\redo03.log' size 100m
datafile
'c:\oracle\oradata\baza01\SYS01.DBF',
'c:\oracle\oradata\baza01\UNDOTBS01.DBF'
character set cl8mswin1251
Wed May 16 16:37:41 2007
ORA-1503 signalled during: create controlfile set database baza01 resetlogs a...
Wed May 16 16:38:07 2007
create controlfile set database baza01 resetlogs archivelog
maxlogfiles 50
maxlogmembers 5
maxdatafiles 100
maxinstances 1
maxloghistory 226
logfile
group 1 'c:\oracle\oradata\baza01\redo01.log' size 100m,
group 2 'c:\oracle\oradata\baza01\redo02.log' size 100m,
group 3 'c:\oracle\oradata\baza01\redo03.log' size 100m
datafile
'c:\oracle\oradata\baza01\SYSTEM01.DBF',
'c:\oracle\oradata\baza01\UNDOTBS01.DBF'
character set cl8mswin1251
Wed May 16 16:38:10 2007
ORA-1503 signalled during: create controlfile set database baza01 resetlogs a...
Wed May 16 16:40:03 2007
create controlfile set database baza01 resetlogs archivelog
maxlogfiles 50
maxlogmembers 5
maxdatafiles 100
maxinstances 1
maxloghistory 226
logfile
group 1 'c:\oracle\oradata\baza01\redo01.log' size 100m,
group 2 'c:\oracle\oradata\baza01\redo02.log' size 100m,
group 3 'c:\oracle\oradata\baza01\redo03.log' size 100m
datafile
'c:\SYSTEM01.DBF',
'c:\oracle\oradata\baza01\UNDOTBS01.DBF'
character set cl8mswin1251
Wed May 16 16:40:06 2007
ORA-1503 signalled during: create controlfile set database baza01 resetlogs a...
Wed May 16 16:42:10 2007
CREATE CONTROLFILE  SET DATABASE baza01 RESETLOGS  NOARCHIVELOG
    MAXLOGFILES 50
    MAXLOGMEMBERS 5
    MAXDATAFILES 100
    MAXINSTANCES 1
    MAXLOGHISTORY 226
LOGFILE
  GROUP 1 'C:\ORACLE\ORADATA\baza01\REDO01.LOG'  SIZE 100M,
  GROUP 2 'C:\ORACLE\ORADATA\baza01\REDO02.LOG'  SIZE 100M,
  GROUP 3 'C:\ORACLE\ORADATA\baza01\REDO03.LOG'  SIZE 100M
DATAFILE
  'C:\ORACLE\ORADATA\baza01\SYSTEM01.DBF',
  'C:\ORACLE\ORADATA\baza01\UNDO1.DBF'
CHARACTER SET CL8MSWIN1251
Wed May 16 16:42:13 2007
ORA-1503 signalled during: CREATE CONTROLFILE  SET DATABASE baza01 RESETLOGS ...
Wed May 16 16:43:01 2007
CREATE CONTROLFILE  SET DATABASE baza01 RESETLOGS  NOARCHIVELOG
    MAXLOGFILES 50
    MAXLOGMEMBERS 5
    MAXDATAFILES 100
    MAXINSTANCES 1
    MAXLOGHISTORY 226
LOGFILE
  GROUP 1 'C:\ORACLE\ORADATA\baza01\REDO01.LOG'  SIZE 100M,
  GROUP 2 'C:\ORACLE\ORADATA\baza01\REDO02.LOG'  SIZE 100M,
  GROUP 3 'C:\ORACLE\ORADATA\baza01\REDO03.LOG'  SIZE 100M
DATAFILE
  'C:\oracle\oradata\baza01\SYSTEM01.DBF',
  'C:\ORACLE\ORADATA\baza01\UNDO1.DBF'
CHARACTER SET CL8MSWIN1251
Wed May 16 16:43:04 2007
ORA-1503 signalled during: CREATE CONTROLFILE  SET DATABASE baza01 RESETLOGS ...
Wed May 16 16:43:24 2007
CREATE CONTROLFILE  SET DATABASE baza01 RESETLOGS  NOARCHIVELOG
    MAXLOGFILES 50
    MAXLOGMEMBERS 5
    MAXDATAFILES 100
    MAXINSTANCES 1
    MAXLOGHISTORY 226
LOGFILE
  GROUP 1 'C:\ORACLE\ORADATA\baza01\REDO01.LOG'  SIZE 100M,
  GROUP 2 'C:\ORACLE\ORADATA\baza01\REDO02.LOG'  SIZE 100M,
  GROUP 3 'C:\ORACLE\ORADATA\baza01\REDO03.LOG'  SIZE 100M
DATAFILE
  'C:\oracle\oradata\baza01\SYSTEM01.DBF',
  'C:\ORACLE\ORADATA\baza01\UNDO1.DBF'
CHARACTER SET CL8MSWIN1251
Wed May 16 16:43:27 2007
ORA-1503 signalled during: CREATE CONTROLFILE  SET DATABASE baza01 RESETLOGS ...
Wed May 16 16:43:47 2007
CREATE CONTROLFILE  SET DATABASE baza01 RESETLOGS  NOARCHIVELOG
    MAXLOGFILES 50
    MAXLOGMEMBERS 5
    MAXDATAFILES 100
    MAXINSTANCES 1
    MAXLOGHISTORY 226
LOGFILE
  GROUP 1 'C:\ORACLE\ORADATA\baza01\REDO01.LOG'  SIZE 100M,
  GROUP 2 'C:\ORACLE\ORADATA\baza01\REDO02.LOG'  SIZE 100M,
  GROUP 3 'C:\ORACLE\ORADATA\baza01\REDO03.LOG'  SIZE 100M
DATAFILE
  'C:\oracle\oradata\baza01\SYSTEM01.DBF',
  'C:\ORACLE\ORADATA\baza01\UNDTBSO1.DBF'
CHARACTER SET CL8MSWIN1251
Wed May 16 16:43:50 2007
ORA-1503 signalled during: CREATE CONTROLFILE  SET DATABASE baza01 RESETLOGS ...
Wed May 16 16:44:03 2007
CREATE CONTROLFILE  SET DATABASE baza01 RESETLOGS  NOARCHIVELOG
    MAXLOGFILES 50
    MAXLOGMEMBERS 5
    MAXDATAFILES 100
    MAXINSTANCES 1
    MAXLOGHISTORY 226
LOGFILE
  GROUP 1 'C:\ORACLE\ORADATA\baza01\REDO01.LOG'  SIZE 100M,
  GROUP 2 'C:\ORACLE\ORADATA\baza01\REDO02.LOG'  SIZE 100M,
  GROUP 3 'C:\ORACLE\ORADATA\baza01\REDO03.LOG'  SIZE 100M
DATAFILE
  'C:\oracle\oradata\baza01\SYSTEM01.DBF',
  'C:\ORACLE\ORADATA\baza01\UNDTBSO1.DBF'
CHARACTER SET CL8MSWIN1251
Wed May 16 16:44:06 2007
ORA-1503 signalled during: CREATE CONTROLFILE  SET DATABASE baza01 RESETLOGS ...
Wed May 16 16:44:07 2007
CREATE CONTROLFILE  SET DATABASE baza01 RESETLOGS  NOARCHIVELOG
    MAXLOGFILES 50
    MAXLOGMEMBERS 5
    MAXDATAFILES 100
    MAXINSTANCES 1
    MAXLOGHISTORY 226
LOGFILE
  GROUP 1 'C:\ORACLE\ORADATA\baza01\REDO01.LOG'  SIZE 100M,
  GROUP 2 'C:\ORACLE\ORADATA\baza01\REDO02.LOG'  SIZE 100M,
  GROUP 3 'C:\ORACLE\ORADATA\baza01\REDO03.LOG'  SIZE 100M
DATAFILE
  'C:\oracle\oradata\baza01\SYSTEM01.DBF',
  'C:\ORACLE\ORADATA\baza01\UNDTBSO1.DBF'
CHARACTER SET CL8MSWIN1251
ORA-1503 signalled during: CREATE CONTROLFILE  SET DATABASE baza01 RESETLOGS ...
Wed May 16 16:44:39 2007
CREATE CONTROLFILE  SET DATABASE baza01 RESETLOGS  NOARCHIVELOG
    MAXLOGFILES 50
    MAXLOGMEMBERS 5
    MAXDATAFILES 100
    MAXINSTANCES 1
    MAXLOGHISTORY 226
LOGFILE
  GROUP 1 'C:\ORACLE\ORADATA\baza01\REDO01.LOG'  SIZE 100M,
  GROUP 2 'C:\ORACLE\ORADATA\baza01\REDO02.LOG'  SIZE 100M,
  GROUP 3 'C:\ORACLE\ORADATA\baza01\REDO03.LOG'  SIZE 100M
DATAFILE
  'C:\oracle\oradata\baza01\SYSTEM01.DBF',
  'C:\ORACLE\ORADATA\baza01\UNDOTBSO1.DBF'
CHARACTER SET CL8MSWIN1251
Wed May 16 16:44:42 2007
ORA-1503 signalled during: CREATE CONTROLFILE  SET DATABASE baza01 RESETLOGS ...
Wed May 16 16:45:49 2007
CREATE CONTROLFILE  SET DATABASE baza01 RESETLOGS  NOARCHIVELOG
    MAXLOGFILES 50
    MAXLOGMEMBERS 5
    MAXDATAFILES 100
    MAXINSTANCES 1
    MAXLOGHISTORY 226
LOGFILE
  GROUP 1 'C:\ORACLE\ORADATA\baza01\REDO01.LOG'  SIZE 100M,
  GROUP 2 'C:\ORACLE\ORADATA\baza01\REDO02.LOG'  SIZE 100M,
  GROUP 3 'C:\ORACLE\ORADATA\baza01\REDO03.LOG'  SIZE 100M
DATAFILE
  'C:\oracle\oradata\baza01\SYSTEM01.DBF',
  'C:\ORACLE\ORADATA\baza01\UNDOTBS01.DBF'
CHARACTER SET CL8MSWIN1251
Wed May 16 16:45:50 2007
Successful mount of redo thread 1, with mount id 2869498813
Wed May 16 16:45:50 2007
Completed: CREATE CONTROLFILE  SET DATABASE baza01 RESETLOGS 
Wed May 16 16:46:04 2007
alter database open
Wed May 16 16:46:04 2007
ORA-1589 signalled during: alter database open...
Wed May 16 16:46:37 2007
alter database open resetlogs
Wed May 16 16:46:37 2007
ORA-1194 signalled during: alter database open resetlogs...
Wed May 16 16:46:48 2007
alter database open noresetlogs
Wed May 16 16:46:48 2007
ORA-1588 signalled during: alter database open noresetlogs...
Wed May 16 16:47:19 2007
Shutting down instance: further logons disabled
Shutting down instance (immediate)
License high water mark = 3
All dispatchers and shared servers shutdown
Wed May 16 16:47:23 2007
ALTER DATABASE CLOSE NORMAL
ORA-1109 signalled during: ALTER DATABASE CLOSE NORMAL...
Wed May 16 16:47:23 2007
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Wed May 16 16:47:25 2007
ARCH shutting down
ARC0: Archival stopped
Wed May 16 16:47:25 2007
ARCH shutting down
ARC1: Archival stopped
Wed May 16 16:47:26 2007
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Wed May 16 16:51:02 2007
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.6.0.
System parameters with non-default values:
  processes                = 150
  timed_statistics         = TRUE
  resource_limit           = TRUE
  shared_pool_size         = 192937984
  large_pool_size          = 142606336
  java_pool_size           = 33554432
  control_files            = C:\oracle\oradata\baza01\control01.ctl, C:\oracle\oradata\baza01\control02.ctl, C:\oracle\oradata\baza01\control03.ctl
  db_block_size            = 8192
  db_cache_size            = 578813952
  compatible               = 9.2.0.0.0
  log_archive_start        = TRUE
  log_archive_dest_1       = LOCATION=C:\oracle\oradata\baza01\archive
  log_archive_format       = %t_%s.arc
  db_file_multiblock_read_count= 16
  fast_start_mttr_target   = 300
  undo_management          = AUTO
  undo_tablespace          = UNDOTBS1
  undo_retention           = 10800
  remote_login_passwordfile= EXCLUSIVE
  db_domain                = STALKER
  instance_name            = baza01
  dispatchers              = (PROTOCOL=TCP) (SERVICE=baza01XDB)
  utl_file_dir             = *
  job_queue_processes      = 10
  hash_join_enabled        = TRUE
  background_dump_dest     = C:\oracle\admin\baza01\bdump
  user_dump_dest           = C:\oracle\admin\baza01\udump
  core_dump_dest           = C:\oracle\admin\baza01\cdump
  sort_area_size           = 1048576
  db_name                  = baza01
  open_cursors             = 300
  star_transformation_enabled= FALSE
  query_rewrite_enabled    = FALSE
  pga_aggregate_target     = 512753664
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
CJQ0 started with pid=8
Wed May 16 16:51:05 2007
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
ARCH: STARTING ARCH PROCESSES
ARC0 started with pid=11
ARC0: Archival started
ARC1 started with pid=12
ARC1: Archival started
Wed May 16 16:51:06 2007
ARCH: STARTING ARCH PROCESSES COMPLETE
Wed May 16 16:51:06 2007
ARC0: Thread not mounted
Wed May 16 16:51:06 2007
ARC1: Thread not mounted
Wed May 16 16:51:38 2007
CREATE CONTROLFILE  SET DATABASE baza01 RESETLOGS  NOARCHIVELOG
    MAXLOGFILES 50
    MAXLOGMEMBERS 5
    MAXDATAFILES 100
    MAXINSTANCES 1
    MAXLOGHISTORY 226
LOGFILE
  GROUP 1 'C:\ORACLE\ORADATA\baza01\REDO01.LOG'  SIZE 100M,
  GROUP 2 'C:\ORACLE\ORADATA\baza01\REDO02.LOG'  SIZE 100M,
  GROUP 3 'C:\ORACLE\ORADATA\baza01\REDO03.LOG'  SIZE 100M
DATAFILE
  'C:\oracle\oradata\baza01\SYSTEM01.DBF',
  'C:\ORACLE\ORADATA\baza01\UNDOTBS01.DBF'
CHARACTER SET CL8MSWIN1251
Wed May 16 16:51:41 2007
ORA-1503 signalled during: CREATE CONTROLFILE  SET DATABASE baza01 RESETLOGS ...
Wed May 16 16:53:56 2007
Shutting down instance: further logons disabled
Shutting down instance (immediate)
License high water mark = 3
All dispatchers and shared servers shutdown
Wed May 16 16:53:59 2007
ALTER DATABASE CLOSE NORMAL
ORA-1507 signalled during: ALTER DATABASE CLOSE NORMAL...
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Wed May 16 16:53:59 2007
ARCH shutting down
ARC0: Archival stopped
Wed May 16 16:53:59 2007
ARCH shutting down
ARC1: Archival stopped
Wed May 16 16:54:03 2007
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Wed May 16 16:55:25 2007
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.6.0.
System parameters with non-default values:
  processes                = 150
  timed_statistics         = TRUE
  resource_limit           = TRUE
  shared_pool_size         = 192937984
  large_pool_size          = 142606336
  java_pool_size           = 33554432
  control_files            = C:\oracle\oradata\baza01\control01.ctl, C:\oracle\oradata\baza01\control02.ctl, C:\oracle\oradata\baza01\control03.ctl
  db_block_size            = 8192
  db_cache_size            = 578813952
  compatible               = 9.2.0.0.0
  log_archive_start        = TRUE
  log_archive_dest_1       = LOCATION=C:\oracle\oradata\baza01\archive
  log_archive_format       = %t_%s.arc
  db_file_multiblock_read_count= 16
  fast_start_mttr_target   = 300
  undo_management          = AUTO
  undo_tablespace          = UNDOTBS1
  undo_retention           = 10800
  remote_login_passwordfile= EXCLUSIVE
  db_domain                = STALKER
  instance_name            = baza01
  dispatchers              = (PROTOCOL=TCP) (SERVICE=baza01XDB)
  utl_file_dir             = *
  job_queue_processes      = 10
  hash_join_enabled        = TRUE
  background_dump_dest     = C:\oracle\admin\baza01\bdump
  user_dump_dest           = C:\oracle\admin\baza01\udump
  core_dump_dest           = C:\oracle\admin\baza01\cdump
  sort_area_size           = 1048576
  db_name                  = baza01
  open_cursors             = 300
  star_transformation_enabled= FALSE
  query_rewrite_enabled    = FALSE
  pga_aggregate_target     = 512753664
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
CJQ0 started with pid=8
Wed May 16 16:55:27 2007
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
ARCH: STARTING ARCH PROCESSES
ARC0 started with pid=11
ARC0: Archival started
ARC1 started with pid=12
ARC1: Archival started
Wed May 16 16:55:28 2007
ARCH: STARTING ARCH PROCESSES COMPLETE
Wed May 16 16:55:28 2007
ARC0: Thread not mounted
Wed May 16 16:55:28 2007
ARC1: Thread not mounted
Wed May 16 16:56:51 2007
CREATE CONTROLFILE  SET DATABASE baza01 RESETLOGS  NOARCHIVELOG
    MAXLOGFILES 50
    MAXLOGMEMBERS 5
    MAXDATAFILES 100
    MAXINSTANCES 1
    MAXLOGHISTORY 226
LOGFILE
  GROUP 1 'C:\ORACLE\ORADATA\baza01\REDO01.LOG'  SIZE 100M,
  GROUP 2 'C:\ORACLE\ORADATA\baza01\REDO02.LOG'  SIZE 100M,
  GROUP 3 'C:\ORACLE\ORADATA\baza01\REDO03.LOG'  SIZE 100M
DATAFILE
  'C:\oracle\oradata\baza01\SYSTEM01.DBF',
  'C:\ORACLE\ORADATA\baza01\UNDOTBS01.DBF'
CHARACTER SET CL8MSWIN1251
Wed May 16 16:56:51 2007
Successful mount of redo thread 1, with mount id 2869511251
Wed May 16 16:56:51 2007
Completed: CREATE CONTROLFILE  SET DATABASE baza01 RESETLOGS 
Wed May 16 16:57:23 2007
alter database open
Wed May 16 16:57:23 2007
ORA-1589 signalled during: alter database open...
Wed May 16 16:57:38 2007
alter database open resetlogs
Wed May 16 16:57:38 2007
ORA-1194 signalled during: alter database open resetlogs...
Wed May 16 16:57:45 2007
alter database open noresetlogs
ORA-1588 signalled during: alter database open noresetlogs...
Wed May 16 16:58:20 2007
Shutting down instance: further logons disabled
Shutting down instance (immediate)
License high water mark = 3
All dispatchers and shared servers shutdown
Wed May 16 16:58:25 2007
ALTER DATABASE CLOSE NORMAL
ORA-1109 signalled during: ALTER DATABASE CLOSE NORMAL...
Wed May 16 16:58:25 2007
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Wed May 16 16:58:27 2007
ARCH shutting down
ARC0: Archival stopped
Wed May 16 16:58:27 2007
ARCH shutting down
ARC1: Archival stopped
Wed May 16 16:58:28 2007
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Wed May 16 16:58:43 2007
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.6.0.
System parameters with non-default values:
  processes                = 150
  timed_statistics         = TRUE
  resource_limit           = TRUE
  shared_pool_size         = 192937984
  large_pool_size          = 142606336
  java_pool_size           = 33554432
  control_files            = C:\oracle\oradata\baza01\control01.ctl, C:\oracle\oradata\baza01\control02.ctl, C:\oracle\oradata\baza01\control03.ctl
  db_block_size            = 8192
  db_cache_size            = 578813952
  compatible               = 9.2.0.0.0
  log_archive_start        = TRUE
  log_archive_dest_1       = LOCATION=C:\oracle\oradata\baza01\archive
  log_archive_format       = %t_%s.arc
  db_file_multiblock_read_count= 16
  fast_start_mttr_target   = 300
  undo_management          = AUTO
  undo_tablespace          = UNDOTBS1
  undo_retention           = 10800
  remote_login_passwordfile= EXCLUSIVE
  db_domain                = STALKER
  instance_name            = baza01
  dispatchers              = (PROTOCOL=TCP) (SERVICE=baza01XDB)
  utl_file_dir             = *
  job_queue_processes      = 10
  hash_join_enabled        = TRUE
  background_dump_dest     = C:\oracle\admin\baza01\bdump
  user_dump_dest           = C:\oracle\admin\baza01\udump
  core_dump_dest           = C:\oracle\admin\baza01\cdump
  sort_area_size           = 1048576
  db_name                  = baza01
  open_cursors             = 300
  star_transformation_enabled= FALSE
  query_rewrite_enabled    = FALSE
  pga_aggregate_target     = 512753664
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
CJQ0 started with pid=8
Wed May 16 16:58:45 2007
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
ARCH: STARTING ARCH PROCESSES
ARC0 started with pid=11
ARC0: Archival started
ARC1 started with pid=12
ARC1: Archival started
Wed May 16 16:58:46 2007
ARCH: STARTING ARCH PROCESSES COMPLETE
Wed May 16 16:58:46 2007
ARC0: Thread not mounted
Wed May 16 16:58:46 2007
ARC1: Thread not mounted
Wed May 16 16:58:46 2007
ALTER DATABASE   MOUNT
Wed May 16 16:58:50 2007
Successful mount of redo thread 1, with mount id 2869509318
Wed May 16 16:58:50 2007
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE   MOUNT
Wed May 16 16:58:51 2007
ALTER DATABASE OPEN
ORA-1589 signalled during: ALTER DATABASE OPEN...
Wed May 16 16:59:25 2007
ALTER DATABASE RECOVER  datafile 'c:\oracle\oradata\baza01\system01.dbf'  
Media Recovery Start
Wed May 16 16:59:25 2007
Media Recovery failed with error 1610
ORA-283 signalled during: ALTER DATABASE RECOVER  datafile 'c:\oracle\oradat...

16 май 07, 18:17    [4146520]     Ответить | Цитировать Сообщить модератору
 Re: Плиз, помогите восстановить базу!!  [new]
juks@gala.net
Member

Откуда: Киев
Сообщений: 4212
STUCK recovery выходит

Есть ли архивлоги с момента снятия образа диска ?
А еще лучше с момента холодной копии
16 май 07, 18:51    [4146688]     Ответить | Цитировать Сообщить модератору
 Re: Плиз, помогите восстановить базу!!  [new]
marguren
Member

Откуда:
Сообщений: 1256
если controlfile was configured autobackup on and you do have archive logs, so just do:

SQL> conn / as sysdba
SQL> startup nomount
RMAN> connect target /
RMAN> set dbid (RMAN displays the DBID whenever you connect to the target. You can also obtain it by inspecting saved RMAN log files, querying the catalog, or looking at the filenames of control file autobackup)
RMAN> restore controfile from autobackup;
RMAN> alter database mount;
RMAN> recover database;
alter database open resetlogs;

sorry, chto po anglijski, na rabote net russkix bukv. dbid mozhno najti v nazvanii controlfile, tam, gde lezzhit ego autobackup.

hth, good luck!
16 май 07, 18:58    [4146723]     Ответить | Цитировать Сообщить модератору
 Re: Плиз, помогите восстановить базу!!  [new]
TaysonSQL
Member

Откуда:
Сообщений: 31
думаю что есть....так образ содержит полностью диск С
16 май 07, 19:02    [4146751]     Ответить | Цитировать Сообщить модератору
 Re: Плиз, помогите восстановить базу!!  [new]
marguren
Member

Откуда:
Сообщений: 1256
btw, vy mozhete sdelat' incomplete recovery, esli znaete tochnoe vremya failure:

v cmd
set NLS_DATE_FORMAT=DD-MM-YYYY HH24:MI:SS
SQL> startup mount
SQL> recover database until time '15-MAY-2007 13:11:07';
SQL> alter database open resetlogs;
16 май 07, 19:04    [4146762]     Ответить | Цитировать Сообщить модератору
 Re: Плиз, помогите восстановить базу!!  [new]
juks@gala.net
Member

Откуда: Киев
Сообщений: 4212
marguren
btw, vy mozhete sdelat' incomplete recovery, esli znaete tochnoe vremya failure:

v cmd
set NLS_DATE_FORMAT=DD-MM-YYYY HH24:MI:SS
SQL> startup mount
SQL> recover database until time '15-MAY-2007 13:11:07';
SQL> alter database open resetlogs;

А STUCK Recovery вас не смущает ?
16 май 07, 19:07    [4146778]     Ответить | Цитировать Сообщить модератору
 Re: Плиз, помогите восстановить базу!!  [new]
HX
Member

Откуда: Moscow
Сообщений: 2454
juks@gala.net
STUCK recovery выходит

Есть ли архивлоги с момента снятия образа диска ?
А еще лучше с момента холодной копии


Со stuck recovery можно попытаться побороться без восстановления из бекапа.
автор попробуйте:
recover database test; и посмотрите alert.log
потом можно попробовать (а бывает и такое что проходит при recover database rest ):

recover database allow 1 corruption;
16 май 07, 19:12    [4146799]     Ответить | Цитировать Сообщить модератору
Топик располагается на нескольких страницах: [1] 2 3   вперед  Ctrl      все
Все форумы / Oracle Ответить