Добро пожаловать в форум, Guest  >>   Войти | Регистрация | Поиск | Правила | В избранное | Подписаться
Все форумы / Oracle Новый топик    Ответить
 не стартует база  [new]
listener31
Guest
Народ помогите пожалуйста!
Не поднимается база при startup, выдает ошибку
ora-03113: end-of-file on communication!
6 июн 08, 10:20    [5768546]     Ответить | Цитировать Сообщить модератору
 Re: не стартует база  [new]
concepts
Member

Откуда: из засады
Сообщений: 279
Алертлог приведите, и расскажите что предшествовало попытке ее поднять
6 июн 08, 10:22    [5768563]     Ответить | Цитировать Сообщить модератору
 Re: не стартует база  [new]
listener31
Guest
Fri Jun 6 09:59:11 2008
ALTER DATABASE OPEN
RSM0 started with pid=21, OS id=2951
Fri Jun 6 09:59:16 2008
Beginning crash recovery of 1 threads
Fri Jun 6 09:59:16 2008
Started redo scan
Fri Jun 6 09:59:18 2008
Completed redo scan
130782 redo blocks read, 8886 data blocks need recovery
Fri Jun 6 09:59:18 2008
ALTER SYSTEM SET log_archive_dest_2='service="realty_standby"','ARCH SYNC NOAFFIRM delay=0 OPTIONAL max_failure=0 reopen=60 register ' S
Fri Jun 6 09:59:18 2008
ALTER SYSTEM SET log_archive_dest_state_2='ENABLE' SCOPE=BOTH;
Fri Jun 6 10:00:07 2008
Started recovery at
Thread 1: logseq 3658, block 2, scn 1.563173634
Fri Jun 6 10:00:07 2008
Recovery of Online Redo Log: Thread 1 Group 2 Seq 3658 Reading mem 0
Mem# 0 errs 0: /opt/oracle/oradata2/realty/redo02a.log
Mem# 1 errs 0: /opt/oracle/oradata3/realty/redo02b.log
Fri Jun 6 10:00:08 2008
Errors in file /opt/oracle/admin/realty/udump/realty_ora_2941.trc:
ORA-00600: internal error code, arguments: [6101], [18446744073709541391], [40], [0], [], [], [], []
Fri Jun 6 10:00:09 2008
Errors in file /opt/oracle/admin/realty/udump/realty_ora_2941.trc:
ORA-07445: exception encountered: core dump [ksmerr()+81] [SIGSEGV] [Address not mapped to object] [0xAA2C9C2C8E2C8014] [] []
ORA-00600: internal error code, arguments: [6101], [18446744073709541391], [40], [0], [], [], [], []
Fri Jun 6 10:01:18 2008
ALTER DATABASE OPEN
Fri Jun 6 10:01:19 2008
Beginning crash recovery of 1 threads
Fri Jun 6 10:01:19 2008
Started redo scan
Fri Jun 6 10:01:21 2008
Completed redo scan
130782 redo blocks read, 8886 data blocks need recovery
Fri Jun 6 10:02:09 2008
Started recovery at
Thread 1: logseq 3658, block 2, scn 1.563173634
Fri Jun 6 10:02:09 2008
Recovery of Online Redo Log: Thread 1 Group 2 Seq 3658 Reading mem 0
Mem# 0 errs 0: /opt/oracle/oradata2/realty/redo02a.log
Mem# 1 errs 0: /opt/oracle/oradata3/realty/redo02b.log
Fri Jun 6 10:02:11 2008
Errors in file /opt/oracle/admin/realty/bdump/realty_rsm0_2951.trc:
ORA-07445: exception encountered: core dump [__milli_memcpy()+3392] [SIGSEGV] [Address not mapped to object] [0xCCD3D8CAC82D3120] [] []
6 июн 08, 10:43    [5768730]     Ответить | Цитировать Сообщить модератору
 Re: не стартует база  [new]
pravednik
Member

Откуда: Jacksonville, FL
Сообщений: 16268
вытащите из трейсов
/opt/oracle/admin/realty/udump/realty_ora_2941.trc
/opt/oracle/admin/realty/bdump/realty_rsm0_2951.trc

SQL satement-ы для 600-ой и 7445-ой ошибок и покажите
6 июн 08, 10:51    [5768812]     Ответить | Цитировать Сообщить модератору
 Re: не стартует база  [new]
DBA - слесарь
Guest
1) Точная версия + начало старта базы в alert.log (Чтобы параметры видны были)
2) Испоьзуйте SRC таг
3) Попробуйте startup migrate (если 9+) или _sys_trig_enabled=flase
и смотреть на тригера базы
p.s. ORA-600 - скорее всего битый индекс
6 июн 08, 10:54    [5768827]     Ответить | Цитировать Сообщить модератору
 Re: не стартует база  [new]
listener31
Guest
2941.
/opt/oracle/admin/realty/udump/realty_ora_2941.trc
Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.8.0 - Production
ORACLE_HOME = /opt/oracle/product/9iR2
System name: HP-UX
Node name: clres1
Release: B.11.23
Version: U
Machine: ia64
Instance name: realty
Redo thread mounted by this instance: 1
Oracle process number: 18
Unix process pid: 2941, image: oracle@clres1 (TNS V1-V3)

*** SESSION ID:(15.3) 2008-06-06 09:59:18.548
----- Redo read statistics for thread 1 -----
Read rate (SYNC): 130782Kb in 1.74s => 72.99 Mb/sec
Longest record: 16Kb, moves: 13/502518 (0%)
Change moves: 195/1664 (11%), moved: 0Mb
----------------------------------------------
----- Recovery Hash Table Statistics ---------
Hash table buckets = 32768
Longest hash chain = 5
Average hash chain = 8886/7796 = 1.1
Max compares per lookup = 4
Avg compares per lookup = 1014995/1013378 = 1.0
----------------------------------------------
*** 2008-06-06 09:59:18.593
KCRA: start recovery claims for 8886 data blocks
*** 2008-06-06 10:00:07.379
KCRA: buffers claimed = 8886/8886, eliminated = 0
*** 2008-06-06 10:00:07.417
Recovery of Online Redo Log: Thread 1 Group 2 Seq 3658 Reading mem 0
*** 2008-06-06 10:00:08.788
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [6101], [18446744073709541391], [40], [0], [], [], [], []
Current SQL statement for this session:
ALTER DATABASE OPEN
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
Cannot find symbol in .
ksedmp()+528 call c00000024ff6e138 000000000 ?
C000000000000996 ?
4000000002A537C0 ?
ksfdmp()+64 call c00000024ff6e138 000000003 ?




2951

/opt/oracle/admin/realty/bdump/realty_rsm0_2951.trc
Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.8.0 - Production
ORACLE_HOME = /opt/oracle/product/9iR2
System name: HP-UX
Node name: clres1
Release: B.11.23
Version: U
Machine: ia64
Instance name: realty
Redo thread mounted by this instance: 1
Oracle process number: 21
Unix process pid: 2951, image: oracle@clres1 (RSM0)

*** SESSION ID:(21.1) 2008-06-06 10:01:21.084
----- Redo read statistics for thread 1 -----
Read rate (SYNC): 130782Kb in 1.65s => 76.97 Mb/sec
Longest record: 16Kb, moves: 13/502518 (0%)
Change moves: 195/1664 (11%), moved: 0Mb
----------------------------------------------
----- Recovery Hash Table Statistics ---------
Hash table buckets = 32768
Longest hash chain = 5
Average hash chain = 8886/7796 = 1.1
Max compares per lookup = 4
Avg compares per lookup = 1014995/1013378 = 1.0
----------------------------------------------
*** 2008-06-06 10:01:21.089
KCRA: start recovery claims for 8886 data blocks
*** 2008-06-06 10:02:09.800
KCRA: buffers claimed = 8886/8886, eliminated = 0
*** 2008-06-06 10:02:09.828
Recovery of Online Redo Log: Thread 1 Group 2 Seq 3658 Reading mem 0
Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object), addr: 0xccd3d8cac82d3120, PC: [0x400000000182a720, __milli_memcpy()+3392]
r1: 6000000000524870 r20: c000000045bec024 br5: 0
r2: 0 r21: c000000045bf0140 br6: 40000000018cf5c0
r3: eb11 r22: 1e br7: e000000130001400
r4: 0 r23: 1100000000 ip: 400000000182a720
r5: 9fffffffbf55fcb8 r24: 8 iipa: 0
r6: 9fffffffffff80e4 r25: 0 cfm: 408
r7: 9fffffffffff8148 r26: ccd3d8cac82d3146 um: 1a
r8: c000000045bec808 r27: 100 rsc: 1f
r9: ccd3d8cac82d3122 r28: ccd3d8cac82d3120 bsp: 9fffffffbf8013a8
r10: 0 r29: c000000045bec808 bspstore: 9fffffffbf8013a8
r11: c000000045bec808 r30: 2 rnat: 0
r12: 9ffffffffffea2b0 r31: 0 ccv: 20000000
r13: 9fffffffbf5a9420 NaTs: 0 unat: 0
r13: 9fffffffbf5a9420 NaTs: 0 unat: 0
r14: 0 PRs: 5b11 fpsr: 9804c8274433f
r15: c br0: 40000000018cebd0 pfs: c000000000005abd
r16: 0 br1: 0 lc: 0
r17: 0 br2: 0 ec: 0
r18: 10 br3: 0 isr: 9fffffffbf8013a8
r19: 20 br4: 0 ifa: 0
Reason code: 0008
*** 2008-06-06 10:02:11.194
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [__milli_memcpy()+3392] [SIGSEGV] [Address not mapped to object] [0xCCD3D8CAC82D3120] [] []
Current SQL statement for this session:
ALTER DATABASE OPEN
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
Cannot find symbol in .
ksedmp()+528 call c00000024ff6e138 000000001 ?
C000000000000996 ?
4000000002A537C0 ?
ssexhd()+1184 call c00000024ff6e138 000000003 ?
C0000000000010A9 ?
40000000025E0D80 ?
000009051 ?
9FFFFFFFFFFE42E0 ?
6000000000514398 ?
6000000000514390 ?
6000000000517850 ?
<kernel> call _etext_f()+23058430 400000000086EEF0 ?
09100548552 000000015 ? 000000007 ?
C000000000000085 ?
__milli_memcpy()+33 call _etext_f()+23058430
92 09100548552
kdxlin()+1264 call _etext_f()+23058430 C000000045BEC808 ?
09100548552 CCD3D8CAC82D3122 ?
000000024 ?
C000000000005ABD ?
000000000 ?
6000000000524870 ?
000000900 ? 000000000 ?
kcoapl()+1664 call 60000000008c3900 6000000000630938 ?
60000000008C38E2 ?
0000000FF ?
C000000045BEC014 ?
9FFFFFFFFFFEA2D0 ?
C000000045BEC808 ?
C000000045BEC024 ?
6 июн 08, 11:02    [5768886]     Ответить | Цитировать Сообщить модератору
 Re: не стартует база  [new]
listener31
Guest
Oracle 9.2.0.8!!!
HP UX операционная система!
6 июн 08, 11:16    [5769014]     Ответить | Цитировать Сообщить модератору
 Re: не стартует база  [new]
listener31
Guest
ARCH shutting down
ARC1: Archival stopped
Fri Jun 6 10:13:57 2008
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Shutting down Data Guard Broker processes
Fri Jun 6 10:13:59 2008
Completed: Data Guard Broker shutdown
Fri Jun 6 10:14:30 2008
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 3
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 = 400
timed_statistics = TRUE
shared_pool_size = 1073741824
large_pool_size = 16777216
java_pool_size = 117440512
filesystemio_options = NONE
disk_asynch_io = FALSE
control_files = /opt/oracle/oradata1/realty/control01.ctl, /opt/oracle/oradata2/realty/control02.ctl, /opt/oracle/oradata3/realty/control03.ctl
db_file_name_convert = ,
log_file_name_convert = ,
db_block_size = 16384
db_writer_processes = 4
db_cache_size = 8589934592
db_cache_advice = ON
compatible = 9.2.0.0.0
log_archive_start = TRUE
log_archive_dest_1 = LOCATION=/opt/oracle/oradata4/realty/archivelogs
log_archive_dest_2 = service="realty_standby", ARCH SYNC NOAFFIRM delay=0 OPTIONAL max_failure=0 reopen=60 register
log_archive_dest_state_1 = enable
log_archive_dest_state_2 = ENABLE
log_archive_max_processes= 2
log_archive_min_succeed_dest= 1
standby_archive_dest = /opt/oracle/oradata4/realty/archivelogs
log_archive_trace = 0
fal_server = realty_standby
fal_client = realty_primary
log_archive_format = log_%S_%T.arc
log_buffer = 10485760
archive_lag_target = 0
db_files = 2000
db_file_multiblock_read_count= 16
standby_file_management = AUTO
fast_start_mttr_target = 300
log_checkpoints_to_alert = TRUE
control_file_record_keep_time= 20
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 86400
fast_start_parallel_rollback= LOW
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = realty
dispatchers = (PROTOCOL=TCP) (SERVICE=realtyXDB)
job_queue_processes = 10
parallel_max_servers = 16
parallel_execution_message_size= 65536
hash_join_enabled = TRUE
background_dump_dest = /opt/oracle/admin/realty/bdump
user_dump_dest = /opt/oracle/admin/realty/udump
core_dump_dest = /opt/oracle/admin/realty/cdump
db_name = realty
open_cursors = 300
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 1073741824
workarea_size_policy = AUTO
aq_tm_processes = 1
dg_broker_start = TRUE
PMON started with pid=2, OS id=9011
DBW0 started with pid=3, OS id=9013
DBW1 started with pid=4, OS id=9015
DBW2 started with pid=5, OS id=9017
DBW3 started with pid=6, OS id=9019
LGWR started with pid=7, OS id=9021
CKPT started with pid=8, OS id=9023
SMON started with pid=9, OS id=9025
RECO started with pid=10, OS id=9027
CJQ0 started with pid=11, OS id=9031
QMN0 started with pid=12, OS id=9033
Fri Jun 6 10:14:34 2008
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=15, OS id=9045
ARC0: Archival started
ARC1 started with pid=16, OS id=9049
ARC1: Archival started
Fri Jun 6 10:14:35 2008
ARCH: STARTING ARCH PROCESSES COMPLETE
Fri Jun 6 10:14:35 2008
ARC1: Becoming the 'no FAL' ARCH
ARC1: Becoming the 'no FAL' ARCHARC1: Thread not mounted
Fri Jun 6 10:14:35 2008
ARC0: Becoming the heartbeat ARCH
ARC0: Becoming the heartbeat ARCHARC0: Thread not mounted
DMON started with pid=17, OS id=9053
Fri Jun 6 10:14:35 2008
ALTER DATABASE MOUNT
Starting Data Guard Broker (DMON)
NSV1 started with pid=19, OS id=9060
Fri Jun 6 10:14:39 2008
Successful mount of redo thread 1, with mount id 1512862155
Fri Jun 6 10:14:39 2008
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Fri Jun 6 10:14:39 2008
ALTER DATABASE OPEN
Fri Jun 6 10:14:43 2008
Beginning crash recovery of 1 threads
Fri Jun 6 10:14:43 2008
Started redo scan
RSM0 started with pid=21, OS id=9084
Fri Jun 6 10:14:44 2008
Completed redo scan
130782 redo blocks read, 8886 data blocks need recovery
Fri Jun 6 10:14:47 2008
ALTER SYSTEM SET log_archive_dest_2='service="realty_standby"','ARCH SYNC NOAFFIRM delay=0 OPTIONAL max_failure=0 reopen=60 register ' SCOPE=BOTH;
Fri Jun 6 10:14:47 2008
ALTER SYSTEM SET log_archive_dest_state_2='ENABLE' SCOPE=BOTH;
Fri Jun 6 10:15:36 2008
Started recovery at
Thread 1: logseq 3658, block 2, scn 1.563173634
Fri Jun 6 10:15:36 2008
Recovery of Online Redo Log: Thread 1 Group 2 Seq 3658 Reading mem 0
Mem# 0 errs 0: /opt/oracle/oradata2/realty/redo02a.log
Mem# 1 errs 0: /opt/oracle/oradata3/realty/redo02b.log
Fri Jun 6 10:15:37 2008
Errors in file /opt/oracle/admin/realty/udump/realty_ora_9067.trc:
ORA-00600: internal error code, arguments: [6101], [18446744073709541391], [40], [0], [], [], [], []
Fri Jun 6 10:15:38 2008
Errors in file /opt/oracle/admin/realty/udump/realty_ora_9067.trc:
ORA-07445: exception encountered: core dump [ksmerr()+81] [SIGSEGV] [Address not mapped to object] [0xAA2C9C2C8E2C8014] [] []
ORA-00600: internal error code, arguments: [6101], [18446744073709541391], [40], [0], [], [], [], []
Fri Jun 6 10:16:32 2008
ALTER DATABASE OPEN
Fri Jun 6 10:16:32 2008
Beginning crash recovery of 1 threads
Fri Jun 6 10:16:32 2008
Started redo scan
Fri Jun 6 10:16:34 2008
Completed redo scan
130782 redo blocks read, 8886 data blocks need recovery
Fri Jun 6 10:17:18 2008
Started recovery at
Thread 1: logseq 3658, block 2, scn 1.563173634
Fri Jun 6 10:17:18 2008
Recovery of Online Redo Log: Thread 1 Group 2 Seq 3658 Reading mem 0
Mem# 0 errs 0: /opt/oracle/oradata2/realty/redo02a.log
Mem# 1 errs 0: /opt/oracle/oradata3/realty/redo02b.log
Fri Jun 6 10:17:20 2008
Errors in file /opt/oracle/admin/realty/bdump/realty_rsm0_9084.trc:
ORA-07445: exception encountered: core dump [__milli_memcpy()+3392] [SIGSEGV] [Address not mapped to object] [0xCCD3D8CAC82D3120] [] []
RSM0 started with pid=21, OS id=10727
Fri Jun 6 10:19:58 2008
Starting ORACLE instance (normal)
Fri Jun 6 10:20:34 2008
Restarting dead background process QMN0
QMN0 started with pid=22, OS id=11318
Fri Jun 6 10:26:34 2008
Restarting dead background process QMN0
QMN0 started with pid=22, OS id=13180
Fri Jun 6 10:32:29 2008
Restarting dead background process QMN0
QMN0 started with pid=22, OS id=14906
Fri Jun 6 10:36:26 2008
Starting ORACLE instance (normal)
Fri Jun 6 10:38:24 2008
Restarting dead background process QMN0
QMN0 started with pid=23, OS id=16737
Fri Jun 6 10:42:40 2008
Starting ORACLE instance (normal)
Fri Jun 6 10:42:50 2008
alter database open
Fri Jun 6 10:42:51 2008
Beginning crash recovery of 1 threads
Fri Jun 6 10:42:51 2008
Started redo scan
Fri Jun 6 10:42:53 2008
Completed redo scan
130782 redo blocks read, 8886 data blocks need recovery
Fri Jun 6 10:43:36 2008
Started recovery at
Thread 1: logseq 3658, block 2, scn 1.563173634
Fri Jun 6 10:43:36 2008
Recovery of Online Redo Log: Thread 1 Group 2 Seq 3658 Reading mem 0
Mem# 0 errs 0: /opt/oracle/oradata2/realty/redo02a.log
Mem# 1 errs 0: /opt/oracle/oradata3/realty/redo02b.log
Fri Jun 6 10:43:37 2008
Errors in file /opt/oracle/admin/realty/udump/realty_ora_11035.trc:
ORA-00600: internal error code, arguments: [6101], [0], [40], [0], [], [], [], []
Fri Jun 6 10:43:38 2008
Errors in file /opt/oracle/admin/realty/udump/realty_ora_11035.trc:
ORA-07445: exception encountered: core dump [ksmerr()+289] [SIGSEGV] [Address not mapped to object] [0xC10306238040AA08] [] []
ORA-00600: internal error code, arguments: [6101], [0], [40], [0], [], [], [], []
Fri Jun 6 10:44:18 2008
Restarting dead background process QMN0
QMN0 started with pid=12, OS id=18337
Fri Jun 6 10:48:39 2008
alter database open
Fri Jun 6 10:48:39 2008
Beginning crash recovery of 1 threads
Fri Jun 6 10:48:39 2008
Started redo scan
Fri Jun 6 10:48:41 2008
Completed redo scan
130782 redo blocks read, 8886 data blocks need recovery
Fri Jun 6 10:49:24 2008
Started recovery at
Thread 1: logseq 3658, block 2, scn 1.563173634
Fri Jun 6 10:49:24 2008
Recovery of Online Redo Log: Thread 1 Group 2 Seq 3658 Reading mem 0
Mem# 0 errs 0: /opt/oracle/oradata2/realty/redo02a.log
Mem# 1 errs 0: /opt/oracle/oradata3/realty/redo02b.log
Fri Jun 6 10:49:26 2008
Errors in file /opt/oracle/admin/realty/udump/realty_ora_19541.trc:
ORA-07445: exception encountered: core dump [__milli_memcpy()+3392] [SIGSEGV] [Address not mapped to object] [0xCCD3D8CAC82D3120] [] []
Fri Jun 6 10:50:12 2008
Restarting dead background process QMN0
QMN0 started with pid=12, OS id=19888
Fri Jun 6 10:56:07 2008
Restarting dead background process QMN0
QMN0 started with pid=12, OS id=21644
Fri Jun 6 11:01:34 2008
alter database open
Fri Jun 6 11:01:34 2008
Beginning crash recovery of 1 threads
Fri Jun 6 11:01:34 2008
Started redo scan
Fri Jun 6 11:01:36 2008
Completed redo scan
130782 redo blocks read, 8886 data blocks need recovery
Fri Jun 6 11:02:04 2008
Restarting dead background process QMN0
QMN0 started with pid=23, OS id=23408
Fri Jun 6 11:02:18 2008
Started recovery at
Thread 1: logseq 3658, block 2, scn 1.563173634
Fri Jun 6 11:02:18 2008
Recovery of Online Redo Log: Thread 1 Group 2 Seq 3658 Reading mem 0
Mem# 0 errs 0: /opt/oracle/oradata2/realty/redo02a.log
Mem# 1 errs 0: /opt/oracle/oradata3/realty/redo02b.log
Fri Jun 6 11:02:19 2008
Errors in file /opt/oracle/admin/realty/udump/realty_ora_23317.trc:
ORA-07445: exception encountered: core dump [__milli_memcpy()+3392] [SIGSEGV] [Address not mapped to object] [0xCCD3D8CAC82D3120] [] []
Fri Jun 6 11:03:01 2008
/* OracleOEM */ ALTER DATABASE OPEN
Fri Jun 6 11:03:01 2008
ORA-1154 signalled during: /* OracleOEM */ ALTER DATABASE OPEN ...
Fri Jun 6 11:03:09 2008
/* OracleOEM */ ALTER DATABASE OPEN
Fri Jun 6 11:03:10 2008
Beginning crash recovery of 1 threads
Fri Jun 6 11:03:10 2008
Started redo scan
Fri Jun 6 11:03:12 2008
Completed redo scan
130782 redo blocks read, 8886 data blocks need recovery
Fri Jun 6 11:03:51 2008
Started recovery at
Thread 1: logseq 3658, block 2, scn 1.563173634
Fri Jun 6 11:03:51 2008
Recovery of Online Redo Log: Thread 1 Group 2 Seq 3658 Reading mem 0
Mem# 0 errs 0: /opt/oracle/oradata2/realty/redo02a.log
Mem# 1 errs 0: /opt/oracle/oradata3/realty/redo02b.log
Fri Jun 6 11:03:53 2008
Errors in file /opt/oracle/admin/realty/udump/realty_ora_23503.trc:
ORA-07445: exception encountered: core dump [__milli_memcpy()+3392] [SIGSEGV] [Address not mapped to object] [0xCCD3D8CAC82D3120] [] []
Fri Jun 6 11:08:05 2008
Restarting dead background process QMN0
QMN0 started with pid=23, OS id=24956
Fri Jun 6 11:14:05 2008
Restarting dead background process QMN0
QMN0 started with pid=23, OS id=26600
6 июн 08, 11:20    [5769054]     Ответить | Цитировать Сообщить модератору
 Re: не стартует база  [new]
listener31
Guest
startup migrate не помогло!
Народ помогите, может кто знает!
130782 redo blocks read, 8886 data blocks need recovery- может быть блок надо восстановить чтбы база стартанула!

даже при startup migrate пишет :
ora-03113: end-of-file on com chanel!

Вообще не представляю что делать!
6 июн 08, 11:32    [5769164]     Ответить | Цитировать Сообщить модератору
 Re: не стартует база  [new]
listener31
Guest
Есть ли какой-нибудь еще вариант поднять базу?
6 июн 08, 11:57    [5769408]     Ответить | Цитировать Сообщить модератору
 Re: не стартует база  [new]
Alert.log
Guest
ARCH shutting down
ARC1: Archival stopped
Fri Jun  6 10:13:57 2008
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Shutting down Data Guard Broker processes
Fri Jun  6 10:13:59 2008
Completed: Data Guard Broker shutdown
Fri Jun  6 10:14:30 2008
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 3
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                = 400
  timed_statistics         = TRUE
  shared_pool_size         = 1073741824
  large_pool_size          = 16777216
  java_pool_size           = 117440512
  filesystemio_options     = NONE
  disk_asynch_io           = FALSE
  control_files            = /opt/oracle/oradata1/realty/control01.ctl, /opt/oracle/oradata2/realty/control02.ctl, /opt/oracle/oradata3/realty/control03.ctl
  db_file_name_convert     =  ,  
  log_file_name_convert    =  ,  
  db_block_size            = 16384
  db_writer_processes      = 4
  db_cache_size            = 8589934592
  db_cache_advice          = ON
  compatible               = 9.2.0.0.0
  log_archive_start        = TRUE
  log_archive_dest_1       = LOCATION=/opt/oracle/oradata4/realty/archivelogs
  log_archive_dest_2       = service="realty_standby", ARCH SYNC NOAFFIRM delay=0 OPTIONAL max_failure=0   reopen=60  register 
  log_archive_dest_state_1 = enable
  log_archive_dest_state_2 = ENABLE
  log_archive_max_processes= 2
  log_archive_min_succeed_dest= 1
  standby_archive_dest     = /opt/oracle/oradata4/realty/archivelogs
  log_archive_trace        = 0
  fal_server               = realty_standby
  fal_client               = realty_primary
  log_archive_format       = log_%S_%T.arc
  log_buffer               = 10485760
  archive_lag_target       = 0
  db_files                 = 2000
  db_file_multiblock_read_count= 16
  standby_file_management  = AUTO
  fast_start_mttr_target   = 300
  log_checkpoints_to_alert = TRUE
  control_file_record_keep_time= 20
  undo_management          = AUTO
  undo_tablespace          = UNDOTBS1
  undo_retention           = 86400
  fast_start_parallel_rollback= LOW
  remote_login_passwordfile= EXCLUSIVE
  db_domain                = 
  instance_name            = realty
  dispatchers              = (PROTOCOL=TCP) (SERVICE=realtyXDB)
  job_queue_processes      = 10
  parallel_max_servers     = 16
  parallel_execution_message_size= 65536
  hash_join_enabled        = TRUE
  background_dump_dest     = /opt/oracle/admin/realty/bdump
  user_dump_dest           = /opt/oracle/admin/realty/udump
  core_dump_dest           = /opt/oracle/admin/realty/cdump
  db_name                  = realty
  open_cursors             = 300
  star_transformation_enabled= FALSE
  query_rewrite_enabled    = FALSE
  pga_aggregate_target     = 1073741824
  workarea_size_policy     = AUTO
  aq_tm_processes          = 1
  dg_broker_start          = TRUE
PMON started with pid=2, OS id=9011
DBW0 started with pid=3, OS id=9013
DBW1 started with pid=4, OS id=9015
DBW2 started with pid=5, OS id=9017
DBW3 started with pid=6, OS id=9019
LGWR started with pid=7, OS id=9021
CKPT started with pid=8, OS id=9023
SMON started with pid=9, OS id=9025
RECO started with pid=10, OS id=9027
CJQ0 started with pid=11, OS id=9031
QMN0 started with pid=12, OS id=9033
Fri Jun  6 10:14:34 2008
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=15, OS id=9045
ARC0: Archival started
ARC1 started with pid=16, OS id=9049
ARC1: Archival started
Fri Jun  6 10:14:35 2008
ARCH: STARTING ARCH PROCESSES COMPLETE
Fri Jun  6 10:14:35 2008
ARC1: Becoming the 'no FAL' ARCH
ARC1: Becoming the 'no FAL' ARCHARC1: Thread not mounted
Fri Jun  6 10:14:35 2008
ARC0: Becoming the heartbeat ARCH
ARC0: Becoming the heartbeat ARCHARC0: Thread not mounted
DMON started with pid=17, OS id=9053
Fri Jun  6 10:14:35 2008
ALTER DATABASE   MOUNT
Starting Data Guard Broker (DMON)
NSV1 started with pid=19, OS id=9060
Fri Jun  6 10:14:39 2008
Successful mount of redo thread 1, with mount id 1512862155
Fri Jun  6 10:14:39 2008
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE   MOUNT
Fri Jun  6 10:14:39 2008
ALTER DATABASE OPEN
Fri Jun  6 10:14:43 2008
Beginning crash recovery of 1 threads
Fri Jun  6 10:14:43 2008
Started redo scan
RSM0 started with pid=21, OS id=9084
Fri Jun  6 10:14:44 2008
Completed redo scan
 130782 redo blocks read, 8886 data blocks need recovery
Fri Jun  6 10:14:47 2008
ALTER SYSTEM SET log_archive_dest_2='service="realty_standby"','ARCH SYNC NOAFFIRM delay=0 OPTIONAL max_failure=0   reopen=60  register ' SCOPE=BOTH;
Fri Jun  6 10:14:47 2008
ALTER SYSTEM SET log_archive_dest_state_2='ENABLE' SCOPE=BOTH;
Fri Jun  6 10:15:36 2008
Started recovery at
 Thread 1: logseq 3658, block 2, scn 1.563173634
Fri Jun  6 10:15:36 2008
Recovery of Online Redo Log: Thread 1 Group 2 Seq 3658 Reading mem 0
  Mem# 0 errs 0: /opt/oracle/oradata2/realty/redo02a.log
  Mem# 1 errs 0: /opt/oracle/oradata3/realty/redo02b.log
Fri Jun  6 10:15:37 2008
Errors in file /opt/oracle/admin/realty/udump/realty_ora_9067.trc:
ORA-00600: internal error code, arguments: [6101], [18446744073709541391], [40], [0], [], [], [], []
Fri Jun  6 10:15:38 2008
Errors in file /opt/oracle/admin/realty/udump/realty_ora_9067.trc:
ORA-07445: exception encountered: core dump [ksmerr()+81] [SIGSEGV] [Address not mapped to object] [0xAA2C9C2C8E2C8014] [] []
ORA-00600: internal error code, arguments: [6101], [18446744073709541391], [40], [0], [], [], [], []
Fri Jun  6 10:16:32 2008
ALTER DATABASE OPEN
Fri Jun  6 10:16:32 2008
Beginning crash recovery of 1 threads
Fri Jun  6 10:16:32 2008
Started redo scan
Fri Jun  6 10:16:34 2008
Completed redo scan
 130782 redo blocks read, 8886 data blocks need recovery
Fri Jun  6 10:17:18 2008
Started recovery at
 Thread 1: logseq 3658, block 2, scn 1.563173634
Fri Jun  6 10:17:18 2008
Recovery of Online Redo Log: Thread 1 Group 2 Seq 3658 Reading mem 0
  Mem# 0 errs 0: /opt/oracle/oradata2/realty/redo02a.log
  Mem# 1 errs 0: /opt/oracle/oradata3/realty/redo02b.log
Fri Jun  6 10:17:20 2008
Errors in file /opt/oracle/admin/realty/bdump/realty_rsm0_9084.trc:
ORA-07445: exception encountered: core dump [__milli_memcpy()+3392] [SIGSEGV] [Address not mapped to object] [0xCCD3D8CAC82D3120] [] []
RSM0 started with pid=21, OS id=10727
Fri Jun  6 10:19:58 2008
Starting ORACLE instance (normal)
Fri Jun  6 10:20:34 2008
Restarting dead background process QMN0
QMN0 started with pid=22, OS id=11318
Fri Jun  6 10:26:34 2008
Restarting dead background process QMN0
QMN0 started with pid=22, OS id=13180
Fri Jun  6 10:32:29 2008
Restarting dead background process QMN0
QMN0 started with pid=22, OS id=14906
Fri Jun  6 10:36:26 2008
Starting ORACLE instance (normal)
Fri Jun  6 10:38:24 2008
Restarting dead background process QMN0
QMN0 started with pid=23, OS id=16737
Fri Jun  6 10:42:40 2008
Starting ORACLE instance (normal)
Fri Jun  6 10:42:50 2008
alter database open
Fri Jun  6 10:42:51 2008
Beginning crash recovery of 1 threads
Fri Jun  6 10:42:51 2008
Started redo scan
Fri Jun  6 10:42:53 2008
Completed redo scan
 130782 redo blocks read, 8886 data blocks need recovery
Fri Jun  6 10:43:36 2008
Started recovery at
 Thread 1: logseq 3658, block 2, scn 1.563173634
Fri Jun  6 10:43:36 2008
Recovery of Online Redo Log: Thread 1 Group 2 Seq 3658 Reading mem 0
  Mem# 0 errs 0: /opt/oracle/oradata2/realty/redo02a.log
  Mem# 1 errs 0: /opt/oracle/oradata3/realty/redo02b.log
Fri Jun  6 10:43:37 2008
Errors in file /opt/oracle/admin/realty/udump/realty_ora_11035.trc:
ORA-00600: internal error code, arguments: [6101], [0], [40], [0], [], [], [], []
Fri Jun  6 10:43:38 2008
Errors in file /opt/oracle/admin/realty/udump/realty_ora_11035.trc:
ORA-07445: exception encountered: core dump [ksmerr()+289] [SIGSEGV] [Address not mapped to object] [0xC10306238040AA08] [] []
ORA-00600: internal error code, arguments: [6101], [0], [40], [0], [], [], [], []
Fri Jun  6 10:44:18 2008
Restarting dead background process QMN0
QMN0 started with pid=12, OS id=18337
Fri Jun  6 10:48:39 2008
alter database open
Fri Jun  6 10:48:39 2008
Beginning crash recovery of 1 threads
Fri Jun  6 10:48:39 2008
Started redo scan
Fri Jun  6 10:48:41 2008
Completed redo scan
 130782 redo blocks read, 8886 data blocks need recovery
Fri Jun  6 10:49:24 2008
Started recovery at
 Thread 1: logseq 3658, block 2, scn 1.563173634
Fri Jun  6 10:49:24 2008
Recovery of Online Redo Log: Thread 1 Group 2 Seq 3658 Reading mem 0
  Mem# 0 errs 0: /opt/oracle/oradata2/realty/redo02a.log
  Mem# 1 errs 0: /opt/oracle/oradata3/realty/redo02b.log
Fri Jun  6 10:49:26 2008
Errors in file /opt/oracle/admin/realty/udump/realty_ora_19541.trc:
ORA-07445: exception encountered: core dump [__milli_memcpy()+3392] [SIGSEGV] [Address not mapped to object] [0xCCD3D8CAC82D3120] [] []
Fri Jun  6 10:50:12 2008
Restarting dead background process QMN0
QMN0 started with pid=12, OS id=19888
Fri Jun  6 10:56:07 2008
Restarting dead background process QMN0
QMN0 started with pid=12, OS id=21644
Fri Jun  6 11:01:34 2008
alter database open
Fri Jun  6 11:01:34 2008
Beginning crash recovery of 1 threads
Fri Jun  6 11:01:34 2008
Started redo scan
Fri Jun  6 11:01:36 2008
Completed redo scan
 130782 redo blocks read, 8886 data blocks need recovery
Fri Jun  6 11:02:04 2008
Restarting dead background process QMN0
QMN0 started with pid=23, OS id=23408
Fri Jun  6 11:02:18 2008
Started recovery at
 Thread 1: logseq 3658, block 2, scn 1.563173634
Fri Jun  6 11:02:18 2008
Recovery of Online Redo Log: Thread 1 Group 2 Seq 3658 Reading mem 0
  Mem# 0 errs 0: /opt/oracle/oradata2/realty/redo02a.log
  Mem# 1 errs 0: /opt/oracle/oradata3/realty/redo02b.log
Fri Jun  6 11:02:19 2008
Errors in file /opt/oracle/admin/realty/udump/realty_ora_23317.trc:
ORA-07445: exception encountered: core dump [__milli_memcpy()+3392] [SIGSEGV] [Address not mapped to object] [0xCCD3D8CAC82D3120] [] []
Fri Jun  6 11:03:01 2008
/* OracleOEM */ ALTER DATABASE OPEN 
Fri Jun  6 11:03:01 2008
ORA-1154 signalled during: /* OracleOEM */ ALTER DATABASE OPEN ...
Fri Jun  6 11:03:09 2008
/* OracleOEM */ ALTER DATABASE OPEN 
Fri Jun  6 11:03:10 2008
Beginning crash recovery of 1 threads
Fri Jun  6 11:03:10 2008
Started redo scan
Fri Jun  6 11:03:12 2008
Completed redo scan
 130782 redo blocks read, 8886 data blocks need recovery
Fri Jun  6 11:03:51 2008
Started recovery at
 Thread 1: logseq 3658, block 2, scn 1.563173634
Fri Jun  6 11:03:51 2008
Recovery of Online Redo Log: Thread 1 Group 2 Seq 3658 Reading mem 0
  Mem# 0 errs 0: /opt/oracle/oradata2/realty/redo02a.log
  Mem# 1 errs 0: /opt/oracle/oradata3/realty/redo02b.log
Fri Jun  6 11:03:53 2008
Errors in file /opt/oracle/admin/realty/udump/realty_ora_23503.trc:
ORA-07445: exception encountered: core dump [__milli_memcpy()+3392] [SIGSEGV] [Address not mapped to object] [0xCCD3D8CAC82D3120] [] []
Fri Jun  6 11:08:05 2008
Restarting dead background process QMN0
QMN0 started with pid=23, OS id=24956
Fri Jun  6 11:14:05 2008
Restarting dead background process QMN0
QMN0 started with pid=23, OS id=26600
6 июн 08, 12:15    [5769542]     Ответить | Цитировать Сообщить модератору
 Re: не стартует база  [new]
listener31
Guest
Не стартует..Ошибка в коммуникационном канале сохраняется!
6 июн 08, 12:25    [5769651]     Ответить | Цитировать Сообщить модератору
 Re: не стартует база  [new]
listener31
Guest
Гуру, помогите!
Может у кого-нибудь есть мысль что делать тут!
6 июн 08, 12:41    [5769783]     Ответить | Цитировать Сообщить модератору
 Re: не стартует база  [new]
listener31
Guest
База переходт в состоянии mount, потом при старте выдает ошибку
ora-03113
6 июн 08, 12:45    [5769819]     Ответить | Цитировать Сообщить модератору
 Re: не стартует база  [new]
listener31
Guest
SQL> srartup open
SP2-0734: unknown command beginning "srartup op..." - rest of line ignored.
SQL> startup
ORACLE instance started.

Total System Global Area 9926833392 bytes
Fixed Size 738544 bytes
Variable Size 1325400064 bytes
Database Buffers 8589934592 bytes
Redo Buffers 10760192 bytes
Database mounted.
ORA-03113: end-of-file on communication channel
6 июн 08, 12:48    [5769847]     Ответить | Цитировать Сообщить модератору
 Re: не стартует база  [new]
concepts
Member

Откуда: из засады
Сообщений: 279
listener31
Гуру, помогите!
Может у кого-нибудь есть мысль что делать тут!

Выложи кусок алерта в момент, когда база упала, т.е. не когда пытаешься поднять, а до этого.
Включи 10046 уровня 12 на сессию, открывающую экземпляр (само открытие делай из sqlplus'а).
Сырой трейс заархивируй и приложи сюда вложением.

p.s. а что говорит тех. поддержка? и это еще, бекап есть? ;-)
6 июн 08, 12:49    [5769852]     Ответить | Цитировать Сообщить модератору
 Re: не стартует база  [new]
listener31
Guest
Thu Jun 5 18:14:30 2008
Recovery of Online Redo Log: Thread 1 Group 5 Seq 3655 Reading mem 0
Mem# 0 errs 0: /opt/oracle/oradata2/realty/redo05a.log
Mem# 1 errs 0: /opt/oracle/oradata3/realty/redo05b.log
completed block recovery at rba:3655.37784.624, scn:1.563138818
Doing block recovery for fno: 361 blk: 28415
block recovery range from rba 3654.171671.0 to scn 1.563135301
Thu Jun 5 18:14:30 2008
Recovery of Online Redo Log: Thread 1 Group 4 Seq 3654 Reading mem 0
Mem# 0 errs 0: /opt/oracle/oradata2/realty/redo04a.log
Mem# 1 errs 0: /opt/oracle/oradata3/realty/redo04b.log
completed block recovery at rba:3654.172020.16, scn:1.563135302
Thu Jun 5 18:14:39 2008
Errors in file /opt/oracle/admin/realty/udump/realty_ora_5933.trc:
ORA-00600: internal error code, arguments: [6101], [0], [40], [0], [], [], [], []
Thu Jun 5 18:14:40 2008
Errors in file /opt/oracle/admin/realty/udump/realty_ora_5933.trc:
ORA-00600: internal error code, arguments: [kghfrempty:ds], [0x60000000005B2E28], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [6101], [0], [40], [0], [], [], [], []
Thu Jun 5 18:14:42 2008
Errors in file /opt/oracle/admin/realty/udump/realty_ora_5933.trc:
ORA-00600: internal error code, arguments: [kghfrempty:ds], [0x60000000005B2E28], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [6101], [0], [40], [0], [], [], [], []
Thu Jun 5 18:14:42 2008
Errors in file /opt/oracle/admin/realty/udump/realty_ora_5933.trc:
ORA-00600: internal error code, arguments: [711], [2], [0x60000000005B3D70], [], [], [], [], []
ORA-00600: internal error code, arguments: [6101], [0], [40], [0], [], [], [], []
Thu Jun 5 18:14:43 2008
Doing block recovery for fno: 221 blk: 10288
Thu Jun 5 18:14:43 2008
Errors in file /opt/oracle/admin/realty/udump/realty_ora_5933.trc:
ORA-00600: internal error code, arguments: [kghfrempty:ds], [0x60000000005B2E28], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [711], [2], [0x60000000005B3D70], [], [], [], [], []
ORA-00600: internal error code, arguments: [6101], [0], [40], [0], [], [], [], []
Thu Jun 5 18:14:43 2008
Errors in file /opt/oracle/admin/realty/udump/realty_ora_5933.trc:
ORA-00600: internal error code, arguments: [kghfrempty:ds], [0x60000000005B2E28], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [711], [2], [0x60000000005B3D70], [], [], [], [], []
ORA-00600: internal error code, arguments: [6101], [0], [40], [0], [], [], [], []
Thu Jun 5 18:14:45 2008
Doing block recovery for fno: 221 blk: 10288
block recovery range from rba 3655.37873.0 to scn 1.563138834
Thu Jun 5 18:14:45 2008
Recovery of Online Redo Log: Thread 1 Group 5 Seq 3655 Reading mem 0
Mem# 0 errs 0: /opt/oracle/oradata2/realty/redo05a.log
Mem# 1 errs 0: /opt/oracle/oradata3/realty/redo05b.log
completed block recovery at rba:3655.38029.0, scn:1.563138835
Doing block recovery for fno: 361 blk: 28415
block recovery range from rba 3654.171671.0 to scn 1.563135301
Thu Jun 5 18:14:45 2008
Recovery of Online Redo Log: Thread 1 Group 4 Seq 3654 Reading mem 0
Mem# 0 errs 0: /opt/oracle/oradata2/realty/redo04a.log
Mem# 1 errs 0: /opt/oracle/oradata3/realty/redo04b.log
completed block recovery at rba:3654.172020.16, scn:1.563135302
Thu Jun 5 18:15:03 2008
Errors in file /opt/oracle/admin/realty/udump/realty_ora_6181.trc:
ORA-00600: internal error code, arguments: [6101], [0], [40], [0], [], [], [], []
Thu Jun 5 18:15:05 2008
Errors in file /opt/oracle/admin/realty/udump/realty_ora_6181.trc:
ORA-00600: internal error code, arguments: [kghfrempty:ds], [0x60000000005B2E28], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [6101], [0], [40], [0], [], [], [], []
Thu Jun 5 18:15:06 2008
Errors in file /opt/oracle/admin/realty/udump/realty_ora_6181.trc:
ORA-00600: internal error code, arguments: [kghfrempty:ds], [0x60000000005B2E28], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [6101], [0], [40], [0], [], [], [], []
Thu Jun 5 18:15:06 2008
Errors in file /opt/oracle/admin/realty/udump/realty_ora_6181.trc:
ORA-00600: internal error code, arguments: [711], [2], [0x60000000005B3D70], [], [], [], [], []
ORA-00600: internal error code, arguments: [6101], [0], [40], [0], [], [], [], []
Thu Jun 5 18:15:06 2008
Doing block recovery for fno: 310 blk: 7347
Thu Jun 5 18:15:07 2008
Errors in file /opt/oracle/admin/realty/udump/realty_ora_6181.trc:
ORA-00600: internal error code, arguments: [kghfrempty:ds], [0x60000000005B2E28], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [711], [2], [0x60000000005B3D70], [], [], [], [], []
ORA-00600: internal error code, arguments: [6101], [0], [40], [0], [], [], [], []
Thu Jun 5 18:15:07 2008
Errors in file /opt/oracle/admin/realty/udump/realty_ora_6181.trc:
ORA-00600: internal error code, arguments: [kghfrempty:ds], [0x60000000005B2E28], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [711], [2], [0x60000000005B3D70], [], [], [], [], []
ORA-00600: internal error code, arguments: [6101], [0], [40], [0], [], [], [], []
Thu Jun 5 18:15:07 2008
Doing block recovery for fno: 310 blk: 7347
block recovery range from rba 3655.39123.0 to scn 1.563138902
Thu Jun 5 18:15:07 2008
Recovery of Online Redo Log: Thread 1 Group 5 Seq 3655 Reading mem 0
Mem# 0 errs 0: /opt/oracle/oradata2/realty/redo05a.log
Mem# 1 errs 0: /opt/oracle/oradata3/realty/redo05b.log
completed block recovery at rba:3655.39314.200, scn:1.563138903
Doing block recovery for fno: 361 blk: 28415
block recovery range from rba 3654.171671.0 to scn 1.563135301
Thu Jun 5 18:15:08 2008
Recovery of Online Redo Log: Thread 1 Group 4 Seq 3654 Reading mem 0
Mem# 0 errs 0: /opt/oracle/oradata2/realty/redo04a.log
Mem# 1 errs 0: /opt/oracle/oradata3/realty/redo04b.log
completed block recovery at rba:3654.172020.16, scn:1.563135302
Thu Jun 5 18:15:10 2008
Errors in file /opt/oracle/admin/realty/bdump/realty_arc1_19405.trc:
6 июн 08, 13:09    [5770030]     Ответить | Цитировать Сообщить модератору
 Re: не стартует база  [new]
redo.log
Guest
concepts
listener31
Гуру, помогите!
Может у кого-нибудь есть мысль что делать тут!

Выложи кусок алерта в момент, когда база упала, т.е. не когда пытаешься поднять, а до этого.
Включи 10046 уровня 12 на сессию, открывающую экземпляр (само открытие делай из sqlplus'а).
Сырой трейс заархивируй и приложи сюда вложением.

p.s. а что говорит тех. поддержка? и это еще, бекап есть? ;-)

Судя по конфигу, у него стендбай есть, т.е можно и с него восстановиться.
Главное убедиться, что все арх.логи, сгенерированные на основной базе, были переданы и применены на standby.
6 июн 08, 13:46    [5770382]     Ответить | Цитировать Сообщить модератору
 Re: не стартует база  [new]
redo.log
Guest
istener31 , базу у тебя не открывается потому, что для какого то индекса не хватило места.
Проверь место на дисках. Если с местом все впорядке, то значит скорее всего в табличном прострастве оно закончилось и это табличное пространство не авторясширяемое.

Эта же проблема скорее всего и в стенбай передалась кроме "blocks need recovery".

А то, что blocks need recovery, скорее всего оракл гасили насильственным образом, по причине останова.
6 июн 08, 14:13    [5770624]     Ответить | Цитировать Сообщить модератору
 Re: не стартует база  [new]
listaner31
Guest
Ну датафайл не сможем добавить, ведь база не открыта..
Места на диске достаточно!
6 июн 08, 15:25    [5771253]     Ответить | Цитировать Сообщить модератору
 Re: не стартует база  [new]
redo.log
Guest
Когда делали бекап и делали ли вообще?
1. Сделайте холодный бекап того, что у Вас сейчас есть и затем пытайтесь восстановить блоки.
2. Проверьте алерт у стендбая. Возможно он еще не накатил арх.лог по причине аварийного останова основной базы. Если со стендбаем все ОК, то можете перевести его в режим read-only и в нем проверить сколько места в табличных пространствах приблизительно так:
select tablespace_name,sum(sizes), sum(occupied), sum(free),round(sum(persent)/count(*),2) from
(SELECT
t.tablespace_name ,
t.status,
ROUND((MAX(d.bytes)/1024/1024) - (SUM(decode(f.bytes, NULL,0, f.bytes))/1024/1024),2) +ROUND(SUM(decode(f.bytes, NULL,0, f.bytes))/1024/1024,2) as sizes,
ROUND((MAX(d.bytes)/1024/1024) - (SUM(decode(f.bytes, NULL,0, f.bytes))/1024/1024),2) as occupied,
ROUND(SUM(decode(f.bytes, NULL,0, f.bytes))/1024/1024,2) as free,
ROUND((ROUND((MAX(d.bytes)/1024/1024) - (SUM(decode(f.bytes, NULL,0, f.bytes))/1024/1024),2) /
(ROUND((MAX(d.bytes)/1024/1024) - (SUM(decode(f.bytes, NULL,0, f.bytes))/1024/1024),2) +
ROUND(SUM(decode(f.bytes, NULL,0, f.bytes))/1024/1024,2)) )*100,3) as persent,
t.initial_extent ,
t.next_extent ,
t.min_extents ,
t.max_extents ,
t.pct_increase
,SUBSTR(d.file_name,1,80)
FROM DBA_FREE_SPACE f , DBA_DATA_FILES d , DBA_TABLESPACES t
WHERE t.tablespace_name = d.tablespace_name AND f.tablespace_name(+) = d.tablespace_name
 AND f.file_id(+) = d.file_id
GROUP BY t.tablespace_name , d.file_name , t.initial_extent , t.next_extent , t.min_extents , t.max_extents ,
t.pct_increase , t.status ORDER BY 1,3 DESC)
group by tablespace_name order by 1
Ну, а уж если примари восстановить не удастся, то только тогда активизировать стендбай.
6 июн 08, 16:01    [5771657]     Ответить | Цитировать Сообщить модератору
 Re: не стартует база  [new]
DBA - слесарь
Guest
Мессир, проблема серьезная, Вам нужно к доктору, то есть в ТЕХ Поддержку, без анализа специалиста это гадание на коффейной гуще.
Если ТП нет, то ...
Судя по вашим ошибкам у Вас могут быть проблемы:
- INDEX problem (IOT,FK,UNIC,COMPRESS)
- HARDWARE problem

по очереди аккуратно и главное backup текщего состояния
6 июн 08, 16:27    [5771896]     Ответить | Цитировать Сообщить модератору
Все форумы / Oracle Ответить