ORA-0314
- From
- Eugene Grosbein (2:5006/1)
- To
- All (2:5054/37.63)
- Date
- 2005-03-21T11:30:36Z
- Area
- RU.RDBMS.ORACLE
Reply-To: eugen@grosbein.pp.ru
Привет!
Как бороться с ORA-0314?
Работает база Oracle 8.0.5.1.0/Linux в режиме ARCHIVELOG.
При создании были указаны такие redo logs:
LOGFILE GROUP 1 ('/var/oracle/lg1/log1a', '/var/oracle/lg1/log1b') size 16M,
GROUP 2 ('/var/oracle/lg2/log2a', '/var/oracle/lg2/log2b') size 16M
После падения по питанию база не встает. В alert.log следующее:
<тут система еще жила>
Mon Mar 21 01:23:33 2005
Thread 1 advanced to log sequence 6530
Current log# 2 seq# 6530 mem# 0: /var/oracle/lg2/log2a
Current log# 2 seq# 6530 mem# 1: /var/oracle/lg2/log2b
Mon Mar 21 01:27:00 2005
Thread 1 advanced to log sequence 6531
Current log# 1 seq# 6531 mem# 0: /var/oracle/lg1/log1a
Current log# 1 seq# 6531 mem# 1: /var/oracle/lg1/log1b
<тут система поднимается после пропадания питания>
Mon Mar 21 01:34:57 2005
Shutting down instance (abort)
Mon Mar 21 01:34:58 2005
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
LICENSE_MAX_USERS = 0
Starting up ORACLE RDBMS Version: 8.0.5.1.0.
System parameters with non-default values:
processes = 100
shared_pool_size = 5000000
nls_date_format = DD-MON-YYYY HH24:MI:SS
control_files =
/var/oracle/ctrl1/ora_control1a,/var/oracle/ctrl1/ora_control1b,
/var/oracle/ctrl2/ora_control2a,/var/oracle/ctrl2/ora_control2b
db_block_buffers = 550
log_archive_start = TRUE
log_archive_dest = /var/oracle/arch
log_archive_format = arch_T%t_S%s.arc
log_buffer = 8192
log_checkpoint_interval = 10000
db_files = 400
db_file_multiblock_read_count= 16
sequence_cache_entries = 30
sequence_cache_hash_buckets= 23
db_domain = XXX
global_names = TRUE
sort_area_size = 16777216
db_name = ORCL
utl_file_dir = *
job_queue_processes = 5
job_queue_interval = 60
parallel_max_servers = 5
max_dump_file_size = 10240
PMON started with pid=2
DBW0 started with pid=3
ARCH started with pid=4
LGWR started with pid=5
CKPT started with pid=6
SMON started with pid=7
RECO started with pid=8
SNP0 started with pid=9
SNP1 started with pid=10
SNP2 started with pid=11
SNP3 started with pid=12
SNP4 started with pid=13
Mon Mar 21 01:34:59 2005
alter database mount
Mon Mar 21 01:35:03 2005
Successful mount of redo thread 1, with mount id 1081246919.
Mon Mar 21 01:35:03 2005
Database mounted in Exclusive Mode.
Completed: alter database mount
Mon Mar 21 01:35:03 2005
alter database open
Beginning crash recovery of 1 threads
Recovery of Online Redo Log: Thread 1 Group 1 Seq 6531 Reading mem 0
Mem# 0 errs 0: /var/oracle/lg1/log1a
Mem# 1 errs 0: /var/oracle/lg1/log1b
Crash recovery completed successfully
Mon Mar 21 01:35:04 2005
Errors in file /usr/local/oracle/rdbms/log/lgwr_orcl_378.trc:
ORA-00314: log 2 of thread 1, expected sequence# 6530 doesn't match 6532
ORA-00312: online log 2 thread 1: '/var/oracle/lg2/log2b
ORA-00314: log 2 of thread 1, expected sequence# 6530 doesn't match 6532
ORA-00312: online log 2 thread 1: '/var/oracle/lg2/log2a'
Mon Mar 21 01:35:04 2005
Errors in file /usr/local/oracle/rdbms/log/lgwr_orcl_378.trc:
ORA-00314: log 2 of thread 1, expected sequence# 6530 doesn't match 6532
ORA-00312: online log 2 thread 1: '/var/oracle/lg2/log2b'
ORA-00314: log 2 of thread 1, expected sequence# 6530 doesn't match 6532
ORA-00312: online log 2 thread 1: '/var/oracle/lg2/log2a'
ORA-314 signalled during: alter database open ...
Пробовал recover database - говорит, не требуется восстановление.
Как такое лечится?
Eugene
--- slrn/0.9.8.0 (FreeBSD)
* Origin: Svyaz Service JSC (2:5006/1@fidonet)
SEEN-BY: 50/203 520 450/159 186 451/30 452/25 454/9 461/33 43 74 106 640
SEEN-BY: 464/34 465/204 469/125 999 550/5068 4623/56 4625/8 9 4626/100 4627/10
SEEN-BY: 4641/444 4646/1 4653/10 4657/50 5000/76 5000 5001/5001 5002/76 5002
SEEN-BY: 5003/34 57 5004/58 5006/1 8 14 17 5007/1 5010/53 70 5011/13 5015/4 28
SEEN-BY: 5020/20 52 104 115 118 128 150 175 194 400 401 545 600 639 642 715
SEEN-BY: 5020/758 794 894 921 968 982 1057 1100 1169 1212 1234 1356 1604 1626
SEEN-BY: 5020/1642 1835 1873 1909 1930 2013 2020 2200 2238 4400 4441 12000
SEEN-BY: 5021/3 44 5022/128 5023/11 5025/19 151 750 5026/14 45 78 5030/69 195
SEEN-BY: 5030/382 920 966 1016 1063 1339 1900 5032/11 16 5033/21 35 5034/8
SEEN-BY: 5035/10 5036/1 13 5037/21 5040/33 47 5041/4 10 5042/13 5045/7 42
SEEN-BY: 5049/157 5050/9 41 5051/15 35 5053/16 5054/1 8 9 28 35 37 45 50
SEEN-BY: 5056/16 5057/1 5058/77 5059/20 5060/88 90 5061/15 5062/1 5063/5 41 51
SEEN-BY: 5064/7 35 36 5066/18 5070/26 66 1222 5071/22 5079/23 49 5080/80 1003
SEEN-BY: 5081/2 5082/6 5083/13 21 5090/23 5093/27 57 5100/113 6000/12 6001/3
PATH: 5006/1 5020/400 4441 52 5054/1 37