- 论坛徽章:
- 0
|
1. sqlplus 连接出错：
ORA-01033: ORACLE initialization or shutdown in progress.
2. 检查配置没问题. 我的版本是：Oracle 7.3.4 at Tur64 Unix V4.0F
3. 因为有ORA-01033, 于是我执行下列命令，但是不管用：
data1: svrmgrl
SVRMGR>; connect internal;
SVRMGR>; shutdown abort;
SVRMGR>; startup;
SVRMGR>; quit;
4. 在 alert_ECS.log 有：
Fri Sep 5 15:31:03 2003
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
LICENSE_MAX_USERS = 0
Starting up ORACLE RDBMS Version: 7.3.4.0.0.
System parameters with non-default values:
processes = 100
timed_statistics = TRUE
shared_pool_size = 28000000
nls_language = simplified chinese
nls_territory = China
control_files = /data/oradata/ECS/control01.ctl, /index/oradata/ECS/control02.ctl, /log/oradata/ECS/control03.ctl
compatible = 7.3.4
log_buffer = 1024000
log_checkpoint_interval = 2684354560
db_files = 99
checkpoint_process = TRUE
log_checkpoints_to_alert = TRUE
rollback_segments = r01, r02, r03, r04
sequence_cache_hash_buckets= 10
remote_login_passwordfile= NONE
mts_service = ECS
mts_servers = 0
mts_max_servers = 0
mts_max_dispatchers = 0
audit_trail = FALSE
sort_area_size = 2048000
sort_area_retained_size = 2048000
sort_direct_writes = AUTO
db_name = ECS
open_cursors = 100
ifile = /usr/local/app/oracle/admin/ECS/pfile/configECS.ora
partition_view_enabled = TRUE
job_queue_processes = 8
background_dump_dest = /usr/local/app/oracle/admin/ECS/bdump
user_dump_dest = /usr/local/app/oracle/admin/ECS/udump
core_dump_dest = /usr/local/app/oracle/admin/ECS/cdump
PMON started
DBWR started
LGWR started
CKPT started
RECO started
SNP0 started
SNP1 started
SNP2 started
SNP3 started
SNP4 started
SNP5 started
SNP6 started
SNP7 started
Fri Sep 5 15:31:03 2003
alter database mount exclusive
Fri Sep 5 15:31:03 2003
Successful mount of redo thread 1.
Fri Sep 5 15:31:03 2003
Completed: alter database mount exclusive
Fri Sep 5 15:31:03 2003
alter database open
Beginning crash recovery of 1 threads
Recovery of Online Redo Log: Thread 1 Group 2 Seq 389 Reading mem 0
Mem# 0 errs 0: /index/oradata/ECS/redoECS02.log
ORA-1172 signalled during: alter database open...
Shutting down instance (normal)
License high water mark = 9
Fri Sep 5 15:31:05 2003
ALTER DATABASE CLOSE NORMAL
ORA-1109 signalled during: ALTER DATABASE CLOSE NORMAL...
Fri Sep 5 15:31:05 2003
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
4. 在startup.log 有:
Copyright (c) Oracle Corporation 1994, 1995. All rights reserved.
Oracle7 Server Release 7.3.4.0.0 with the 64-bit option - Production
With the distributed and paTNSLSNR for DEC OSF/1 AXP: Version 2.3.4.0.0 - Production
System parameter file is /usr/local/app/oracle/product/7.3.4/network/admin/listener.ora
Log messages written to /usr/local/app/oracle/product/7.3.4/network/log/listener.log
Listening on: (ADDRESS=(PROTOCOL=tcp)(DEV=6)(HOST=172.16.24.102)(PORT=1521))
Connecting to (ADDRESS=(PROTOCOL=TCP)(Host=data)(Port=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for DEC OSF/1 AXP: Version 2.3.4.0.0 - Production
Start Date 05-SEP-03 18:13:30
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File /usr/local/app/oracle/product/7.3.4/network/admin/listener.ora
Listener Log File /usr/local/app/oracle/product/7.3.4/network/log/listener.log
Services Summary...
ECS has 1 service handler(s)
The command completed successfully
/sbin/init.d/oracle: starting up
Mon Sep 8 08:18:37 CST 2003
LSNRCTL for DEC OSF/1 AXP: Version 2.3.4.0.0 - Production on 08-SEP-03 08:18:37
Copyright (c) Oracle Corporation 1994. All rights reserved.
Oracle Server Manager Release 2.3.4.0.0 - Production
Copyright (c) Oracle Corporation 1994, 1995. All rights reserved.
Oracle7 Server Release 7.3.4.0.0 with the 64-bit option - Production
With the distributed and parallel query options
PL/SQL Release 2.3.4.0.0 - Production
SVRMGR>; Connected to an idle instance.
SVRMGR>; ORACLE instance started.
Total System Global Area 55884096 bytes
Fixed Size 50832 bytes
Variable Size 30233264 bytes
Database Buffers 24576000 bytes
Redo Buffers 1024000 bytes
Database mounted.
ORA-01172: recovery of thread 1 stuck at block 6785 of file 10
ORA-01151: use media recovery to recover block, restore backup if needed
SVRMGR>;
Server Manager complete.
Database "ECS" warm started.
Mon Sep 8 08:33:29 CST 2003 /sbin/init.d/oracle: Executing with argument stop
Mon Sep 8 08:33:29 CST 2003 stopping V2 listener
LSNRCTL for DEC OSF/1 AXP: Version 2.3.4.0.0 - Production on 08-SEP-03 08:33:29
Copyright (c) Oracle Corporation 1994. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=TCP)(Host=data)(Port=1521))
The command completed successfully
stopping Oracle databases
uid=0(root) gid=1(daemon)
/proj/etc
Mon Sep 8 08:33:40 CST 2003 /sbin/init.d/oracle: Finished
/sbin/init.d/oracle: starting up
Mon Sep 8 08:33:50 CST 2003
LSNRCTL for DEC OSF/1 AXP: Version 2.3.4.0.0 - Production on 08-SEP-03 08:33:50
6. 因为有ORA-01172, ORA-01151, 于是我执行下列命令，进行数据库恢复。
但是不管用, 并报错：
SVRMGR>; connect internal;
SVRMGR>; shutdown abort;
SVRMGR>; startup mount;
SVRMGR>; alter database datafile '/data/oradata/ECS/his03ECS.dbf' offline;
*
ORA-01145: offline immediate disallowed unless media recovery enable. |
|
免费注册
发表于 2003-09-08 19:47
