Поиск  Пользователи  Правила 
Закрыть
Логин:
Пароль:
Забыли свой пароль?
Войти
 
Страницы: 1
RSS
ORA-01033 ORACLE initialization or shutdown in progress, КАК ВОССТАНОВИТЬ БАЗУ ПОДЕЛИТЕСЬ ОПЫТОМ
 
Помогите плз. решить задачу, БД не открывается, ошибку выдаёт
ORA-01033 ORACLE initialization or shutdown in progress

ЛОГ OraDim

Wed May 07 17:02:30 2008
ORA-01113: file 11 needs media recovery
ORA-01110: data file 11: 'E:\ORACLE\ORADATA\MAGICASH\MG_INDX.DBF'
________________________________

ЛОГ АЛЕРТА

Wed May 07 17:07:51 2008
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Wed May 07 17:07:52 2008
alter database mount exclusive
Wed May 07 17:07:56 2008
Successful mount of redo thread 1, with mount id 2075919464
Wed May 07 17:07:56 2008
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Wed May 07 17:07:56 2008
alter database open
ORA-1113 signalled during: alter database open...
Dump file e:\oracle\admin\magicash\bdump\alert_magicash.log
Wed May 07 17:09:35 2008
ORACLE V9.2.0.8.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.1 Service Pack 2, CPU type 586
Wed May 07 17:09:35 2008
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.8.0.
System parameters with non-default values:
 processes                = 150
 timed_statistics         = TRUE
 shared_pool_size         = 50331648
 large_pool_size          = 8388608
 java_pool_size           = 33554432
 control_files            = E:\oracle\oradata\MAGICASH\CONTROL01.CTL, E:\oracle\oradata\MAGICASH\CONTROL02.CTL, E:\oracle\oradata\MAGICASH\CONTROL03.CTL
 db_block_size            = 8192
 db_cache_size            = 25165824
 compatible               = 9.2.0.0.0
 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                =
 instance_name            = MAGICASH
 dispatchers              = (PROTOCOL=TCP) (SERVICE=MAGICASHXDB)
 job_queue_processes      = 10
 hash_join_enabled        = TRUE
 background_dump_dest     = E:\oracle\admin\MAGICASH\bdump
 user_dump_dest           = E:\oracle\admin\MAGICASH\udump
 core_dump_dest           = E:\oracle\admin\MAGICASH\cdump
 sort_area_size           = 524288
 db_name                  = MAGICASH
 open_cursors             = 300
 ifile                    = E:\oracle\admin\MAGICASH\pfile\init.ora
 star_transformation_enabled= FALSE
 query_rewrite_enabled    = FALSE
 pga_aggregate_target     = 25165824
 aq_tm_processes          = 1
PMON started with pid=2, OS id=284
DBW0 started with pid=3, OS id=108
LGWR started with pid=4, OS id=404
CKPT started with pid=5, OS id=460
SMON started with pid=6, OS id=484
RECO started with pid=7, OS id=476
CJQ0 started with pid=8, OS id=696
QMN0 started with pid=9, OS id=704
Wed May 07 17:09:39 2008
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Wed May 07 17:09:41 2008
alter database mount exclusive
Wed May 07 17:09:46 2008
Successful mount of redo thread 1, with mount id 2075925205
Wed May 07 17:09:46 2008
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Wed May 07 17:09:46 2008
alter database open
ORA-1113 signalled during: alter database open...
Dump file e:\oracle\admin\magicash\bdump\alert_magicash.log
Wed May 07 17:14:42 2008
ORACLE V9.2.0.8.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.1 Service Pack 2, CPU type 586
Wed May 07 17:14:42 2008
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.8.0.
System parameters with non-default values:
 processes                = 150
 timed_statistics         = TRUE
 shared_pool_size         = 50331648
 large_pool_size          = 8388608
 java_pool_size           = 33554432
 control_files            = E:\oracle\oradata\MAGICASH\CONTROL01.CTL, E:\oracle\oradata\MAGICASH\CONTROL02.CTL, E:\oracle\oradata\MAGICASH\CONTROL03.CTL
 db_block_size            = 8192
 db_cache_size            = 25165824
 compatible               = 9.2.0.0.0
 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                =
 instance_name            = MAGICASH
 dispatchers              = (PROTOCOL=TCP) (SERVICE=MAGICASHXDB)
 job_queue_processes      = 10
 hash_join_enabled        = TRUE
 background_dump_dest     = E:\oracle\admin\MAGICASH\bdump
 user_dump_dest           = E:\oracle\admin\MAGICASH\udump
 core_dump_dest           = E:\oracle\admin\MAGICASH\cdump
 sort_area_size           = 524288
 db_name                  = MAGICASH
 open_cursors             = 300
 ifile                    = E:\oracle\admin\MAGICASH\pfile\init.ora
 star_transformation_enabled= FALSE
 query_rewrite_enabled    = FALSE
 pga_aggregate_target     = 25165824
 aq_tm_processes          = 1
PMON started with pid=2, OS id=1916
DBW0 started with pid=3, OS id=1920
LGWR started with pid=4, OS id=1924
CKPT started with pid=5, OS id=1928
SMON started with pid=6, OS id=1932
RECO started with pid=7, OS id=1936
CJQ0 started with pid=8, OS id=1940
QMN0 started with pid=9, OS id=1944
Wed May 07 17:14:46 2008
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Wed May 07 17:14:47 2008
alter database mount exclusive
Wed May 07 17:14:51 2008
Successful mount of redo thread 1, with mount id 2075944967
Wed May 07 17:14:51 2008
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Wed May 07 17:14:51 2008
alter database open
ORA-1113 signalled during: alter database open...
Wed May 07 17:20:49 2008
Restarting dead background process QMN0
QMN0 started with pid=9, OS id=2160
Dump file e:\oracle\admin\magicash\bdump\alert_magicash.log
Wed May 07 17:23:24 2008
ORACLE V9.2.0.8.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.1 Service Pack 2, CPU type 586
Wed May 07 17:23:24 2008
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.8.0.
System parameters with non-default values:
 processes                = 150
 timed_statistics         = TRUE
 shared_pool_size         = 50331648
 large_pool_size          = 8388608
 java_pool_size           = 33554432
 control_files            = E:\oracle\oradata\MAGICASH\CONTROL01.CTL, E:\oracle\oradata\MAGICASH\CONTROL02.CTL, E:\oracle\oradata\MAGICASH\CONTROL03.CTL
 db_block_size            = 8192
 db_cache_size            = 25165824
 compatible               = 9.2.0.0.0
 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                =
 instance_name            = MAGICASH
 dispatchers              = (PROTOCOL=TCP) (SERVICE=MAGICASHXDB)
 job_queue_processes      = 10
 hash_join_enabled        = TRUE
 background_dump_dest     = E:\oracle\admin\MAGICASH\bdump
 user_dump_dest           = E:\oracle\admin\MAGICASH\udump
 core_dump_dest           = E:\oracle\admin\MAGICASH\cdump
 sort_area_size           = 524288
 db_name                  = MAGICASH
 open_cursors             = 300
 ifile                    = E:\oracle\admin\MAGICASH\pfile\init.ora
 star_transformation_enabled= FALSE
 query_rewrite_enabled    = FALSE
 pga_aggregate_target     = 25165824
 aq_tm_processes          = 1
PMON started with pid=2, OS id=3060
DBW0 started with pid=3, OS id=3064
LGWR started with pid=4, OS id=3068
CKPT started with pid=5, OS id=3072
SMON started with pid=6, OS id=3076
RECO started with pid=7, OS id=3080
CJQ0 started with pid=8, OS id=3092
QMN0 started with pid=9, OS id=3284
Wed May 07 17:23:28 2008
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Wed May 07 17:23:29 2008
alter database mount exclusive
Wed May 07 17:23:34 2008
Successful mount of redo thread 1, with mount id 2075942161
Wed May 07 17:23:34 2008
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Wed May 07 17:23:34 2008
alter database open
ORA-1113 signalled during: alter database open...
Wed May 07 17:29:31 2008
Restarting dead background process QMN0
QMN0 started with pid=9, OS id=2204
Wed May 07 17:35:34 2008
Restarting dead background process QMN0
QMN0 started with pid=9, OS id=496
Wed May 07 17:41:37 2008
Restarting dead background process QMN0
QMN0 started with pid=9, OS id=3144
Wed May 07 17:47:40 2008
Restarting dead background process QMN0
QMN0 started with pid=9, OS id=3688
Wed May 07 17:53:43 2008
Restarting dead background process QMN0
QMN0 started with pid=9, OS id=2260
Wed May 07 17:59:46 2008
Restarting dead background process QMN0
QMN0 started with pid=9, OS id=2516
Wed May 07 18:05:46 2008
Restarting dead background process QMN0
QMN0 started with pid=9, OS id=3144
Wed May 07 18:11:49 2008
Restarting dead background process QMN0
QMN0 started with pid=9, OS id=480
Wed May 07 18:17:52 2008
Restarting dead background process QMN0
QMN0 started with pid=9, OS id=712
Wed May 07 18:23:55 2008
Restarting dead background process QMN0
QMN0 started with pid=9, OS id=3964
Wed May 07 18:29:58 2008
Restarting dead background process QMN0
QMN0 started with pid=9, OS id=3932
Wed May 07 18:36:01 2008
Restarting dead background process QMN0
QMN0 started with pid=9, OS id=2408
Wed May 07 18:42:04 2008
Restarting dead background process QMN0
QMN0 started with pid=9, OS id=2704
Wed May 07 18:48:04 2008
Restarting dead background process QMN0
QMN0 started with pid=9, OS id=2376
Wed May 07 18:54:07 2008
Restarting dead background process QMN0
QMN0 started with pid=9, OS id=3216
Wed May 07 19:00:10 2008
Restarting dead background process QMN0
QMN0 started with pid=9, OS id=3588
Wed May 07 19:06:13 2008
Restarting dead background process QMN0
QMN0 started with pid=9, OS id=3960
Wed May 07 19:12:16 2008
Restarting dead background process QMN0
QMN0 started with pid=9, OS id=1116
Wed May 07 19:18:20 2008
Restarting dead background process QMN0
QMN0 started with pid=9, OS id=2640
Wed May 07 19:24:23 2008
Restarting dead background process QMN0
QMN0 started with pid=9, OS id=2884
Wed May 07 19:30:26 2008
Restarting dead background process QMN0
QMN0 started with pid=9, OS id=2648
Wed May 07 19:36:29 2008
Restarting dead background process QMN0
QMN0 started with pid=9, OS id=3280
Wed May 07 19:42:32 2008
Restarting dead background process QMN0
QMN0 started with pid=9, OS id=3248
Wed May 07 19:48:32 2008
Restarting dead background process QMN0
QMN0 started with pid=9, OS id=3716
Wed May 07 19:54:35 2008
Restarting dead background process QMN0
QMN0 started with pid=9, OS id=2236
Wed May 07 20:00:38 2008
Restarting dead background process QMN0
QMN0 started with pid=9, OS id=1928
Wed May 07 20:06:41 2008
Restarting dead background process QMN0
QMN0 started with pid=9, OS id=2536
Wed May 07 20:12:44 2008
Restarting dead background process QMN0
QMN0 started with pid=9, OS id=4008
Wed May 07 20:18:47 2008
Restarting dead background process QMN0
QMN0 started with pid=9, OS id=3672
Wed May 07 20:24:50 2008
Restarting dead background process QMN0
QMN0 started with pid=9, OS id=3240
Wed May 07 20:30:53 2008
Restarting dead background process QMN0
QMN0 started with pid=9, OS id=2832
Wed May 07 20:36:56 2008
Restarting dead background process QMN0
QMN0 started with pid=9, OS id=1980
Wed May 07 20:42:59 2008
Restarting dead background process QMN0
QMN0 started with pid=9, OS id=2152
Wed May 07 20:48:59 2008
Restarting dead background process QMN0
QMN0 started with pid=9, OS id=636
Wed May 07 20:55:02 2008
Restarting dead background process QMN0
QMN0 started with pid=9, OS id=4020
Wed May 07 21:01:05 2008
Restarting dead background process QMN0
QMN0 started with pid=9, OS id=3248
Wed May 07 21:07:08 2008
Restarting dead background process QMN0
QMN0 started with pid=9, OS id=2996
Wed May 07 21:13:11 2008
Restarting dead background process QMN0
QMN0 started with pid=9, OS id=3304
Wed May 07 21:19:14 2008
Restarting dead background process QMN0
QMN0 started with pid=9, OS id=3808
Wed May 07 21:25:17 2008
Restarting dead background process QMN0
QMN0 started with pid=9, OS id=3740
Wed May 07 21:31:20 2008
Restarting dead background process QMN0
QMN0 started with pid=9, OS id=2168
Wed May 07 21:37:23 2008
Restarting dead background process QMN0
QMN0 started with pid=9, OS id=2692
Wed May 07 21:43:26 2008
Restarting dead background process QMN0
QMN0 started with pid=9, OS id=3588
Wed May 07 21:49:26 2008
Restarting dead background process QMN0
QMN0 started with pid=9, OS id=2280
Wed May 07 21:55:29 2008
Restarting dead background process QMN0
QMN0 started with pid=9, OS id=2112
Wed May 07 22:01:32 2008
Restarting dead background process QMN0
QMN0 started with pid=9, OS id=3468
Wed May 07 22:07:35 2008
Restarting dead background process QMN0
QMN0 started with pid=9, OS id=2160
Wed May 07 22:13:39 2008
Restarting dead background process QMN0
QMN0 started with pid=9, OS id=3504
Wed May 07 22:19:42 2008
Restarting dead background process QMN0
QMN0 started with pid=9, OS id=2372
Wed May 07 22:25:45 2008
Restarting dead background process QMN0
QMN0 started with pid=9, OS id=3468
Wed May 07 22:31:48 2008
Restarting dead background process QMN0
QMN0 started with pid=9, OS id=3200
Wed May 07 22:37:51 2008
Restarting dead background process QMN0
QMN0 started with pid=9, OS id=3480
Wed May 07 22:43:54 2008
Restarting dead background process QMN0
QMN0 started with pid=9, OS id=2708
Wed May 07 22:49:54 2008
Restarting dead background process QMN0
QMN0 started with pid=9, OS id=2176
Wed May 07 22:55:57 2008
Restarting dead background process QMN0
QMN0 started with pid=9, OS id=3952
Wed May 07 23:02:00 2008
Restarting dead background process QMN0
QMN0 started with pid=9, OS id=2764
Wed May 07 23:08:03 2008
Restarting dead background process QMN0
QMN0 started with pid=9, OS id=256
Wed May 07 23:14:06 2008
Restarting dead background process QMN0
QMN0 started with pid=9, OS id=3540
Wed May 07 23:20:09 2008
Restarting dead background process QMN0
QMN0 started with pid=9, OS id=2320
Wed May 07 23:26:12 2008
Restarting dead background process QMN0
QMN0 started with pid=9, OS id=2868
Wed May 07 23:32:15 2008
Restarting dead background process QMN0
QMN0 started with pid=9, OS id=3344
Wed May 07 23:38:18 2008
Restarting dead background process QMN0
QMN0 started with pid=9, OS id=484
Wed May 07 23:44:18 2008
Restarting dead background process QMN0
QMN0 started with pid=9, OS id=2484
Wed May 07 23:50:21 2008
Restarting dead background process QMN0
QMN0 started with pid=9, OS id=4004
Wed May 07 23:56:24 2008
Restarting dead background process QMN0
 
sql> shutdown immediate
sql> startup mount
sql> recover database
sql> startup
Страницы: 1
Читают тему