"tbbnc">
好几天没开VM学习ORACLE 今天启动出现下面错误： [root@web1 bdump]# pwd /opt/oracle/admin/testdb2/bdump [root@web1 bdump]# cat alert_oradb.log undo_tablespace = UNDOTBS1 remote_login_passwordfile= EXCLUSIVE db_domain = dispatchers = (PROTOCOL=TCP) (SERVICE=testdb2XDB) job_queue_processes = 10 background_dump_dest = /opt/oracle/admin/testdb2/bdump user_dump_dest = /opt/oracle/admin/testdb2/udump core_dump_dest = /opt/oracle/admin/testdb2/cdump audit_file_dest = /opt/oracle/admin/testdb2/adump db_name = testdb2 open_cursors = 300 pga_aggregate_target = 16777216 MMAN started with pid=4, OS id=3760 PSP0 started with pid=3, OS id=3758 PMON started with pid=2, OS id=3756 LGWR started with pid=6, OS id=3764 DBW0 started with pid=5, OS id=3762 CKPT started with pid=7, OS id=3766 SMON started with pid=8, OS id=3768 RECO started with pid=9, OS id=3770 CJQ0 started with pid=10, OS id=3772 MMON started with pid=11, OS id=3774 Fri Aug 21 07:51:00 2009 starting up 1 dispatcher(s) for network address (ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP)) ... MMNL started with pid=12, OS id=3776 Fri Aug 21 07:51:00 2009 starting up 1 shared server(s) ... Fri Aug 21 07:51:01 2009 ALTER DATABASE MOUNT Fri Aug 21 07:51:05 2009 Setting recovery target incarnation to 5 Fri Aug 21 07:51:05 2009 Successful mount of redo thread 1, with mount id 1017141349 Fri Aug 21 07:51:05 2009 Database mounted in Exclusive Mode Completed: ALTER DATABASE MOUNT Fri Aug 21 07:51:05 2009 ALTER DATABASE OPEN Fri Aug 21 07:51:06 2009 LGWR: STARTING ARCH PROCESSES ARC0 started with pid=16, OS id=3784 Fri Aug 21 07:51:06 2009 ARC0: Archival started ARC1: Archival started LGWR: STARTING ARCH PROCESSES COMPLETE ARC1 started with pid=17, OS id=3786 Fri Aug 21 07:51:06 2009 ARC0: STARTING ARCH PROCESSES Fri Aug 21 07:51:06 2009 ARC1: Becoming the no FAL ARCH ARC1: Becoming the no SRL ARCH Fri Aug 21 07:51:06 2009 Thread 1 opened at log sequence 14 Current log# 1 seq# 14 mem# 0: /oradata/testdb2/redo01.log Successful open of redo thread 1 Fri Aug 21 07:51:06 2009 MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set Fri Aug 21 07:51:06 2009 SMON: enabling cache recovery Fri Aug 21 07:51:06 2009 ARC2: Archival started ARC0: STARTING ARCH PROCESSES COMPLETE ARC0: Becoming the heartbeat ARCH ARC2 started with pid=18, OS id=3788 Fri Aug 21 07:51:08 2009 Successfully onlined Undo Tablespace 1. Fri Aug 21 07:51:08 2009 SMON: enabling tx recovery Fri Aug 21 07:51:08 2009 Database Characterset is WE8ISO8859P1 replication_dependency_tracking turned off (no async multimaster replication found) Starting background process QMNC QMNC started with pid=19, OS id=3790 Fri Aug 21 07:51:16 2009 Completed: ALTER DATABASE OPEN Fri Aug 21 07:51:17 2009