- 论坛徽章:
- 0
|
两台机子oracle原先都能正常启动切换,现发现B机cluster的IP和阵列能切过来,oracle不能启动(两机都没启动归档)
log如下:
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.4.0.
System parameters with non-default values:
processes = 500
timed_statistics = TRUE
shared_pool_size = 268435456
large_pool_size = 16777216
java_pool_size = 83886080
spfile = /oradata1/dbs/spfilekkk.ora
control_files = /oradata1/kkk/control01.ctl, /oradata2/kkk/control02.ctl, /oradata3/kkk/control03.ctl
db_block_size = 8192
db_cache_size = 838860800
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain = local
instance_name = kkk
dispatchers = (PROTOCOL=TCP) (SERVICE=kkkXDB)
job_queue_processes = 30
hash_join_enabled = TRUE
background_dump_dest = /opt/ora9/admin/kkk/bdump
user_dump_dest = /opt/ora9/admin/kkk/udump
core_dump_dest = /opt/ora9/admin/kkk/cdump
sort_area_size = 524288
db_name = kkk
open_cursors = 300
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 314572800
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 1 23:29:43 2006
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Fri Dec 1 23:29:43 2006
ALTER DATABASE MOUNT
Fri Dec 1 23:29:47 2006
Successful mount of redo thread 1, with mount id 762133223.
Fri Dec 1 23:29:47 2006
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Fri Dec 1 23:29:47 2006
ALTER DATABASE OPEN
ORA-1113 signalled during: ALTER DATABASE OPEN...
Fri Dec 1 23:30:43 2006
Restarting dead background process QMN0
QMN0 started with pid=9
Fri Dec 1 23:35:44 2006
Restarting dead background process QMN0
QMN0 started with pid=9
Fri Dec 1 23:40:45 2006
Restarting dead background process QMN0
QMN0 started with pid=9
Fri Dec 1 23:41:13 2006
Shutting down instance: further logons disabled
Shutting down instance (immediate)
去掉双机配置,单机启动oracle 的log如下:
SQL> STARTUP NOMOUNT;
ALTER DATABASE MOUNT;
ALTER DATABASE OPEN; ORACLE instance started.
Total System Global Area 1242634520 bytes
Fixed Size 452888 bytes
Variable Size 402653184 bytes
Database Buffers 838860800 bytes
Redo Buffers 667648 bytes
SQL>
Database altered.
SQL>
ALTER DATABASE OPEN
*
ERROR at line 1:
ORA-01113: file 3 needs media recovery
ORA-01110: data file 3: '/opt/ora9/oradata/kkk/cwmlite01.dbf'
SQL> shutdown immediate
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down. |
|