Bonjour à tous,
Je travaille avec une BD 9.2 sous Windows 2000.
La BD n'est pas en mode archivelog.
Je ne dispose que d'export journalier du schéma du seul User de la BD.
J'ai trouvé ceci dans le fichier alert.log :
Il y a eu des problèmes de coupures électriques à répétition.
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
75
76 alter database open Fri Dec 03 14:53:31 2010 Beginning crash recovery of 1 threads Fri Dec 03 14:53:31 2010 Started recovery at Thread 1: logseq 229, block 613, scn 0.0 Recovery of Online Redo Log: Thread 1 Group 1 Seq 229 Reading mem 0 Mem# 0 errs 0: E:\ORACLE\ORADATA\ORC2\REDO01.LOG Dump file e:\oracle\admin\orc2\bdump\alert_orc2.log Fri Dec 03 14:58:26 2010 ORACLE V9.2.0.1.0 - Production vsnsta=0 vsnsql=12 vsnxtr=3 Windows 2000 Version 5.0 Service Pack 4, CPU type 586 Fri Dec 03 14:58:26 2010 Starting ORACLE instance (normal) Fri Dec 03 14:58:27 2010 Running with 1 strand for Non-Enterprise Edition LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 SCN scheme 2 Using log_archive_dest parameter default value Running with 1 strand for Non-Enterprise Edition LICENSE_MAX_USERS = 0 SYS auditing is disabled Starting up ORACLE RDBMS Version: 9.2.0.1.0. System parameters with non-default values: processes = 150 timed_statistics = TRUE shared_pool_size = 50331648 large_pool_size = 8388608 java_pool_size = 0 control_files = E:\oracle\oradata\orc2\control01.ctl, E:\oracle\oradata\orc2\control02.ctl, E:\oracle\oradata\orc2\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 = 0 undo_management = AUTO undo_tablespace = UNDOTBS1 undo_retention = 10800 remote_login_passwordfile= EXCLUSIVE db_domain = instance_name = orc2 job_queue_processes = 10 hash_join_enabled = TRUE background_dump_dest = E:\oracle\admin\orc2\bdump user_dump_dest = E:\oracle\admin\orc2\udump core_dump_dest = E:\oracle\admin\orc2\cdump sort_area_size = 524288 db_name = orc2 open_cursors = 300 star_transformation_enabled= FALSE query_rewrite_enabled = FALSE pga_aggregate_target = 25165824 aq_tm_processes = 1 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 QMN0 started with pid=9 Fri Dec 03 14:58:36 2010 Oracle Data Guard is not available in this edition of Oracle. Fri Dec 03 14:58:39 2010 alter database mount exclusive Fri Dec 03 14:58:48 2010 Successful mount of redo thread 1, with mount id 1429374240. Fri Dec 03 14:58:48 2010 Database mounted in Exclusive Mode. Completed: alter database mount exclusive Fri Dec 03 14:58:48 2010 alter database open ORA-1113 signalled during: alter database open... Dump file e:\oracle\admin\orc2\bdump\alert_orc2.log
Il semble qu'une coupure soit intervenue pendant un crash recovery.
Que puis-je faire ?
Est-il possible de tenter manuellement :
Merci pour votre aide.
Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3 RECOVER DATABASE; ALTER DATABASE OPEN;
Partager