Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
发新帖

164

积分

0

好友

16

主题
1#
发表于 2012-3-9 11:04:18 | 查看: 4733| 回复: 1
sun m4000 s10u7+oracle11.2.0.2 dg
今天突然实例停止了,不知什么原因,后再手工启动正常,求解.
alert...
Fri Mar 09 08:09:25 2012
Media Recovery Log /oraarch/tjmchis/1_48579_768246832.dbf
Media Recovery Log /oraarch/tjmchis/1_48580_768246832.dbf
Fri Mar 09 08:09:45 2012
Media Recovery Log /oraarch/tjmchis/1_48581_768246832.dbf
Fri Mar 09 08:09:52 2012
PMON (ospid: 851): terminating the instance due to error 471
Fri Mar 09 08:09:52 2012
System state dump requested by (instance=1, osid=851 (PMON)), summary=[abnormal instance termination].
System State dumped to trace file /app/oracle/diag/rdbms/tjmchisdg/tjmchis/trace/tjmchis_diag_861.trc
Dumping diagnostic data in directory=[cdmp_20120309080952], requested by (instance=1, osid=851 (PMON)), summary=[abnormal instance termination].
Instance terminated by PMON, pid = 851
Fri Mar 09 10:04:30 2012
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Autotune of undo retention is turned on.
IMODE=BR
ILAT =168
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
Using parameter settings in server-side spfile /app/oracle/product/11.2.0/db_1/dbs/spfiletjmchis.ora
System parameters with non-default values:
  processes                = 1000
  sessions                 = 1536
  nls_language             = "SIMPLIFIED CHINESE"
  nls_territory            = "CHINA"
  memory_target            = 16G
  control_files            = "/oradata/tjmchis/controlfile/control01.ctl"
  control_files            = "/oradata/tjmchis/controlfile/control02.ctl"
  db_file_name_convert     = "+ORADATA/tjmchis/datafile"
  db_file_name_convert     = "/oradata/tjmchis/datafile"
  db_file_name_convert     = "+ORADATA/tjmchis/tempfile"
  db_file_name_convert     = "/oradata/tjmchis/tempfile"
  log_file_name_convert    = "+ORADATA/tjmchis/onlinelog"
  log_file_name_convert    = "/oradata/tjmchis/onlinelog1"
  log_file_name_convert    = "+ORAARCH/tjmchis/onlinelog"
  log_file_name_convert    = "/oradata/tjmchis/onlinelog2"
  db_block_size            = 16384
  compatible               = "11.2.0.0.0"
  log_archive_dest_1       = "location=/oraarch/tjmchis VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=tjmchisdg"
  log_archive_dest_2       = "SERVICE=primary LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=tjmchis"
  log_archive_dest_state_1 = "ENABLE"
  log_archive_dest_state_2 = "ENABLE"
  fal_client               = "standby"
  fal_server               = "primary"
  log_archive_config       = "dg_config=(tjmchis,tjmchisdg)"
  log_archive_format       = "%t_%s_%r.dbf"
  standby_file_management  = "AUTO"
  undo_tablespace          = "UNDOTBS1"
  remote_login_passwordfile= "EXCLUSIVE"
  db_domain                = ""
  dispatchers              = "(PROTOCOL=TCP) (SERVICE=tjmchisXDB)"
  utl_file_dir             = "/export/home/oracle/"
  audit_file_dest          = "/app/oracle/admin/tjmchis/adump"
  audit_trail              = "DB"
  db_name                  = "tjmchis"
  db_unique_name           = "tjmchisdg"
  open_cursors             = 300
  deferred_segment_creation= FALSE
  diagnostic_dest          = "/app/oracle"
Fri Mar 09 10:04:35 2012
PMON started with pid=2, OS id=7278
Fri Mar 09 10:04:35 2012
PSP0 started with pid=3, OS id=7280
Fri Mar 09 10:04:36 2012
VKTM started with pid=4, OS id=7282 at elevated priority
VKTM running at (10)millisec precision with DBRM quantum (100)ms
Fri Mar 09 10:04:36 2012
GEN0 started with pid=5, OS id=7286
Fri Mar 09 10:04:36 2012
DIAG started with pid=6, OS id=7288
Fri Mar 09 10:04:36 2012
DBRM started with pid=7, OS id=7290
Fri Mar 09 10:04:36 2012
DIA0 started with pid=8, OS id=7292
Fri Mar 09 10:04:36 2012
MMAN started with pid=9, OS id=7294
Fri Mar 09 10:04:36 2012
DBW0 started with pid=10, OS id=7296
Fri Mar 09 10:04:36 2012
DBW1 started with pid=11, OS id=7298
Fri Mar 09 10:04:36 2012
LGWR started with pid=12, OS id=7300
Fri Mar 09 10:04:36 2012
CKPT started with pid=13, OS id=7302
Fri Mar 09 10:04:37 2012
SMON started with pid=14, OS id=7304
Fri Mar 09 10:04:37 2012
RECO started with pid=15, OS id=7306
Fri Mar 09 10:04:37 2012
MMON started with pid=16, OS id=7308
Fri Mar 09 10:04:37 2012
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...MMNL started with pid=17, OS id=7310
starting up 1 shared server(s) ...
DISM started, OS id=7316
Fri Mar 09 10:04:47 2012
ORACLE_BASE from environment = /app/oracle
Fri Mar 09 10:04:47 2012
ALTER DATABASE   MOUNT
ARCH: STARTING ARCH PROCESSES
Fri Mar 09 10:04:52 2012
ARC0 started with pid=21, OS id=7323
ARC0: Archival started
ARCH: STARTING ARCH PROCESSES COMPLETE
ARC0: STARTING ARCH PROCESSES
Fri Mar 09 10:04:53 2012
ARC1 started with pid=22, OS id=7325
Fri Mar 09 10:04:53 2012
ARC2 started with pid=23, OS id=7327
Fri Mar 09 10:04:53 2012
Successful mount of redo thread 1, with mount id 267473535
Physical Standby Database mounted.
Lost write protection disabled
Fri Mar 09 10:04:53 2012
ARC3 started with pid=24, OS id=7329
ARC1: Archival started
ARC2: Archival started
ARC1: Becoming the 'no FAL' ARCH
ARC2: Becoming the heartbeat ARCH
ARC2: Becoming the active heartbeat ARCH
Completed: ALTER DATABASE   MOUNT
Fri Mar 09 10:04:53 2012
ALTER DATABASE OPEN
AUDIT_TRAIL initialization parameter is changed to OS, as DB is NOT compatible for database opened with read-only access
Beginning standby crash recovery.
Serial Media Recovery started
Managed Standby Recovery starting Real Time Apply
Fri Mar 09 10:04:54 2012
Using STANDBY_ARCHIVE_DEST parameter default value as /oraarch/tjmchis
ARC3: Archival started
ARC0: STARTING ARCH PROCESSES COMPLETE
Media Recovery Log /oraarch/tjmchis/1_48580_768246832.dbf
Media Recovery Log /oraarch/tjmchis/2_90500_768246832.dbf
Media Recovery Log /oraarch/tjmchis/1_48581_768246832.dbf

tjmchis_diag_861.rar

68.43 KB, 下载次数: 619

2#
发表于 2012-3-9 15:42:51
1. 这种帖子不要设置附件金钱数!


2.

PMON (ospid: 851): terminating the instance due to error 471


[oracle@vrh8 ~]$ oerr ora 471
00471, 00000, "DBWR process terminated with error"
// *Cause:  The database writer process died
// *Action: Warm start instance


请上传 pmon (SPID 851) 和 dbwr 的当时的trace 文件

回复 只看该作者 道具 举报

您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-12-24 00:12 , Processed in 0.053200 second(s), 25 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569