oracle ora1578,求帮助，ORA-1578，ORA-01092异常，多谢

当前位置:我的异常网» Oracle技术 » 求帮助，ORA-1578，ORA-01092异常，多谢

求帮助，ORA-1578，ORA-01092异常，多谢

www.myexceptions.net  网友分享于：2013-03-16  浏览：51次

求帮助，ORA-1578，ORA-01092错误，谢谢

打开数据库的时候遇到ORA-01092: ORACLE instance terminated. Disconnection forced错误，查看alert日志内容如下：

Tue Nov 15 15:47:39 2011

Starting ORACLE instance (normal)

LICENSE_MAX_SESSION = 0

LICENSE_SESSIONS_WARNING = 0

Picked latch-free SCN scheme 2

Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST

Autotune of undo retention is turned on.

IMODE=BR

ILAT =18

LICENSE_MAX_USERS = 0

SYS auditing is disabled

ksdpec: called for event 13740 prior to event group initialization

Starting up ORACLE RDBMS Version: 10.2.0.1.0.

System parameters with non-default values:

processes = 150

cpu_count = 2

__shared_pool_size = 188743680

__large_pool_size = 4194304

__java_pool_size = 4194304

__streams_pool_size = 0

sga_target = 591396864

control_files = /u01/app/oracle/oradata/orcl/control02.ctl, /u01/app/oracle/oradata/orcl/control03.ctl

db_block_size = 8192

__db_cache_size = 385875968

compatible = 10.2.0.1.0

db_file_multiblock_read_count= 8

db_recovery_file_dest = /u01/app/oracle/flash_recovery_area/

db_recovery_file_dest_size= 2147483648

undo_management = AUTO

undo_tablespace = UNDOTBS1

remote_login_passwordfile= EXCLUSIVE

db_domain =

dispatchers = (PROTOCOL=TCP) (SERVICE=orclXDB)

job_queue_processes = 10

background_dump_dest = /u01/app/oracle/admin/orcl/bdump

user_dump_dest = /u01/app/oracle/admin/orcl/udump

core_dump_dest = /u01/app/oracle/admin/orcl/cdump

audit_file_dest = /u01/app/oracle/admin/orcl/adump

db_name = orcl

open_cursors = 300

pga_aggregate_target = 196083712

PSP0 started with pid=3, OS id=2796

PMON started with pid=2, OS id=2794

MMAN started with pid=4, OS id=2798

DBW0 started with pid=5, OS id=2800

LGWR started with pid=6, OS id=2802

CKPT started with pid=7, OS id=2804

SMON started with pid=8, OS id=2806

RECO started with pid=9, OS id=2808

CJQ0 started with pid=10, OS id=2810

MMON started with pid=11, OS id=2812

Tue Nov 15 15:47:41 2011

starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...

MMNL started with pid=12, OS id=2814

Tue Nov 15 15:47:41 2011

starting up 1 shared server(s) ...

Tue Nov 15 15:47:42 2011

ALTER DATABASE MOUNT

Tue Nov 15 15:47:46 2011

Setting recovery target incarnation to 2

Tue Nov 15 15:47:46 2011

Successful mount of redo thread 1, with mount id 1295059870

Tue Nov 15 15:47:46 2011

Database mounted in Exclusive Mode

Completed: ALTER DATABASE MOUNT

Tue Nov 15 15:47:53 2011

alter database open

Tue Nov 15 15:47:53 2011

Beginning crash recovery of 1 threads

parallel recovery started with 2 processes

Tue Nov 15 15:47:53 2011

Started redo scan

Tue Nov 15 15:47:54 2011

Completed redo scan

1 redo blocks read, 0 data blocks need recovery

Tue Nov 15 15:47:54 2011

Started redo application at

Thread 1: logseq 14, block 2, scn 735161

Tue Nov 15 15:47:54 2011

Recovery of Online Redo Log: Thread 1 Group 1 Seq 14 Reading mem 0

Mem# 0 errs 0: /u01/app/oracle/oradata/orcl/redo01.log

Mem# 1 errs 0: /u01/app/oracle/oradata/orcl/redo01b.log

Tue Nov 15 15:47:54 2011

Completed redo application

Tue Nov 15 15:47:54 2011

Completed crash recovery at

Thread 1: logseq 14, block 3, scn 755163

0 data blocks read, 0 data blocks written, 1 redo blocks read

文章评论