Apres une grande requete par un developpeur. J'ai essayé de faire un shutdown immediate sur ma base, puisque celle-ci ramer completement, maintenant voila 2h que la base essaye de s'arreter mais en vain, j'ai bien peur quelle ne fasse pas granchose, dans mes fichires de logs j'ai les messages suivants :
puis dans le trace :
Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31 Thread 1 advanced to log sequence 650 Current log# 2 seq# 650 mem# 0: D:\ORACLE\ORADATA\SIDDEV\REDO02.LOG Fri Jan 20 11:08:00 2006 ALTER SYSTEM SET pga_aggregate_target='83886080' SCOPE=MEMORY; Fri Jan 20 11:08:02 2006 ALTER SYSTEM SET pga_aggregate_target='83886080' SCOPE=SPFILE; Fri Jan 20 11:21:15 2006 Thread 1 advanced to log sequence 651 Current log# 3 seq# 651 mem# 0: D:\ORACLE\ORADATA\SIDDEV\REDO03.LOG Fri Jan 20 11:22:09 2006 Shutting down instance: further logons disabled Fri Jan 20 11:22:38 2006 Shutting down instance (immediate) License high water mark = 13 All dispatchers and shared servers shutdown Fri Jan 20 11:22:45 2006 ALTER DATABASE CLOSE NORMAL Fri Jan 20 11:27:56 2006 Waiting for smon to disable tx recovery. Fri Jan 20 11:52:33 2006 Thread 1 advanced to log sequence 652 Current log# 1 seq# 652 mem# 0: D:\ORACLE\ORADATA\SIDDEV\REDO01.LOG Fri Jan 20 12:26:47 2006 Thread 1 advanced to log sequence 653 Current log# 2 seq# 653 mem# 0: D:\ORACLE\ORADATA\SIDDEV\REDO02.LOG Fri Jan 20 13:00:28 2006 Thread 1 advanced to log sequence 654 Current log# 3 seq# 654 mem# 0: D:\ORACLE\ORADATA\SIDDEV\REDO03.LOG Fri Jan 20 13:37:53 2006 Thread 1 advanced to log sequence 655 Current log# 1 seq# 655 mem# 0: D:\ORACLE\ORADATA\SIDDEV\REDO01.LOG
Merci de votre aide.
Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74 Dump file d:\oracle\admin\siddev\udump\siddev_ora_3216.trc Fri Jan 20 11:27:56 2006 ORACLE V9.2.0.3.0 - Production vsnsta=0 vsnsql=12 vsnxtr=3 Windows 2000 Version 5.2 Service Pack 1, CPU type 586 Oracle9i Enterprise Edition Release 9.2.0.3.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.3.0 - Production Windows 2000 Version 5.2 Service Pack 1, CPU type 586 Instance name: siddev Redo thread mounted by this instance: 1 Oracle process number: 10 Windows thread id: 3216, image: ORACLE.EXE *** SESSION ID:(16.9696) 2006-01-20 11:27:56.000 Waiting for smon to disable tx recovery. *** 2006-01-20 11:33:07.000 Waiting for smon to disable tx recovery. *** 2006-01-20 11:38:19.000 Waiting for smon to disable tx recovery. *** 2006-01-20 11:43:30.000 Waiting for smon to disable tx recovery. *** 2006-01-20 11:48:42.000 Waiting for smon to disable tx recovery. *** 2006-01-20 11:53:53.000 Waiting for smon to disable tx recovery. *** 2006-01-20 11:59:05.000 Waiting for smon to disable tx recovery. *** 2006-01-20 12:04:16.000 Waiting for smon to disable tx recovery. *** 2006-01-20 12:09:27.000 Waiting for smon to disable tx recovery. *** 2006-01-20 12:14:39.000 Waiting for smon to disable tx recovery. *** 2006-01-20 12:19:50.000 Waiting for smon to disable tx recovery. *** 2006-01-20 12:25:02.000 Waiting for smon to disable tx recovery. *** 2006-01-20 12:30:13.000 Waiting for smon to disable tx recovery. *** 2006-01-20 12:35:25.000 Waiting for smon to disable tx recovery. *** 2006-01-20 12:40:36.000 Waiting for smon to disable tx recovery. *** 2006-01-20 12:45:47.000 Waiting for smon to disable tx recovery. *** 2006-01-20 12:50:59.000 Waiting for smon to disable tx recovery. *** 2006-01-20 12:56:10.000 Waiting for smon to disable tx recovery. *** 2006-01-20 13:01:22.000 Waiting for smon to disable tx recovery. *** 2006-01-20 13:06:33.000 Waiting for smon to disable tx recovery. *** 2006-01-20 13:11:45.000 Waiting for smon to disable tx recovery. *** 2006-01-20 13:16:56.000 Waiting for smon to disable tx recovery. *** 2006-01-20 13:22:08.000 Waiting for smon to disable tx recovery. *** 2006-01-20 13:27:19.000 Waiting for smon to disable tx recovery. *** 2006-01-20 13:32:30.000 Waiting for smon to disable tx recovery. *** 2006-01-20 13:37:42.000 Waiting for smon to disable tx recovery. *** 2006-01-20 13:42:53.000 Waiting for smon to disable tx recovery. *** 2006-01-20 13:48:05.000 Waiting for smon to disable tx recovery.
Partager