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

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

999

积分

1

好友

942

主题
1#
发表于 2017-4-15 22:25:04 | 查看: 1366| 回复: 0
本人有一个oracle11.1.0.7.0的数据库是装在WINDOWS2008下的,启动的时候发生错误。现在数据库打不开。错误信息如下。
有高手帮忙看看是什么原因。谢谢
急。。。。。。

Instance terminated by PMON, pid = 3264
Thu Aug 09 14:10:47 2012
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =48
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 11.1.0.7.0.
Using parameter settings in server-side spfile D:\APP\ADMINISTRATOR\PRODUCT\11.1.0\DB_1\DATABASE\SPFILEORCL.ORA
System parameters with non-default values:
  processes                = 400
  sessions                 = 445
  timed_statistics         = TRUE
  sga_max_size             = 1504M
  shared_pool_size         = 80M
  resource_manager_plan    = "FORCE:PLAN_FOR_NDSC_JD_XS"
  sga_target               = 0
  memory_target            = 2G
  memory_max_target        = 2480M
  control_files            = "D:\APP\ADMINISTRATOR\ORADATA\ORCL\CONTROL01.CTL"
  control_files            = "D:\APP\ADMINISTRATOR\ORADATA\ORCL\CONTROL02.CTL"
  control_files            = "D:\APP\ADMINISTRATOR\ORADATA\ORCL\CONTROL03.CTL"
  db_block_size            = 8192
  db_cache_size            = 208M
  compatible               = "11.1.0.0.0"
  db_recovery_file_dest    = "D:\app\Administrator\flash_recovery_area"
  db_recovery_file_dest_size= 4G
  undo_tablespace          = "UNDOTBS1"
  remote_login_passwordfile= "EXCLUSIVE"
  db_domain                = ""
  global_names             = FALSE
  dispatchers              = "(PROTOCOL=TCP) (SERVICE=ORCLXDB)"
  job_queue_processes      = 0
  audit_file_dest          = "D:\APP\ADMINISTRATOR\ADMIN\ORCL\ADUMP"
  audit_trail              = "NONE"
  db_name                  = "ORCL"
  open_cursors             = 300
  _complex_view_merging    = FALSE
  _optimizer_cost_based_transformation= "OFF"
  pga_aggregate_target     = 200M
  diagnostic_dest          = "D:\APP\ADMINISTRATOR"
Thu Aug 09 14:10:48 2012
PMON started with pid=3, OS id=3324
Thu Aug 09 14:10:48 2012
VKTM started with pid=5, OS id=3392 at elevated priority
VKTM running at (20)ms precision
Thu Aug 09 14:10:48 2012
DIAG started with pid=7, OS id=924
Thu Aug 09 14:10:48 2012
DBRM started with pid=9, OS id=3364
Thu Aug 09 14:10:48 2012
PSP0 started with pid=11, OS id=3316
Thu Aug 09 14:10:48 2012
DIA0 started with pid=13, OS id=796
Thu Aug 09 14:10:48 2012
MMAN started with pid=15, OS id=2248
Thu Aug 09 14:10:48 2012
DBW0 started with pid=2, OS id=3420
Thu Aug 09 14:10:48 2012
DBW1 started with pid=17, OS id=3860
Thu Aug 09 14:10:48 2012
LGWR started with pid=19, OS id=888
Thu Aug 09 14:10:48 2012
CKPT started with pid=21, OS id=3868
Thu Aug 09 14:10:48 2012
SMON started with pid=23, OS id=3536
Thu Aug 09 14:10:48 2012
RECO started with pid=25, OS id=3712
Thu Aug 09 14:10:48 2012
MMON started with pid=27, OS id=3636
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Thu Aug 09 14:10:48 2012
MMNL started with pid=29, OS id=3528
starting up 1 shared server(s) ...
ORACLE_BASE from environment = D:\app\Administrator
Thu Aug 09 14:10:49 2012
ALTER DATABASE   MOUNT
Thu Aug 09 14:10:51 2012
Sweep Incident[558014]: completed
Setting recovery target incarnation to 2
Successful mount of redo thread 1, with mount id 3553791146
Database mounted in Exclusive Mode
Lost write protection disabled
Completed: ALTER DATABASE   MOUNT
Thu Aug 09 14:10:54 2012
ALTER DATABASE OPEN
Beginning crash recovery of 1 threads
parallel recovery started with 7 processes
Started redo scan
Completed redo scan
643 redo blocks read, 24 data blocks need recovery
Started redo application at
Thread 1: logseq 150861, block 3
Recovery of Online Redo Log: Thread 1 Group 4 Seq 150861 Reading mem 0
  Mem# 0: D:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO04.LOG
Completed redo application of 0.22MB
Completed crash recovery at
Thread 1: logseq 150861, block 646, scn 12273697812941
24 data blocks read, 24 data blocks written, 643 redo blocks read
Thread 1 advanced to log sequence 150862 (thread open)
Thread 1 opened at log sequence 150862
  Current log# 5 seq# 150862 mem# 0: D:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO05.LOG
Successful open of redo thread 1
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
SMON: enabling cache recovery
Successfully onlined Undo Tablespace 2.
Verifying file header compatibility for 11g tablespace encryption..
Verifying 11g file header compatibility for tablespace encryption completed
SMON: enabling tx recovery
Exception [type: ACCESS_VIOLATION, UNABLE_TO_READ] [ADDR:0x0] [PC:0x52B428E, _intel_fast_memcpy.A()+18]
Database Characterset is ZHS16GBK
Errors in file d:\app\administrator\diag\rdbms\ORCL\ORCL\trace\ORCL_smon_3536.trc  (incident=561214):
ORA-07445: exception encountered: core dump [intel_fast_memcpy.A()+18] [ACCESS_VIOLATION] [ADDR:0x0] [PC:0x52B428E] [UNABLE_TO_READ] []
Incident details in: d:\app\administrator\diag\rdbms\ORCL\ORCL\incident\incdir_561214\ORCL_smon_3536_i561214.trc
Opening with Resource Manager plan: PLAN_FOR_NDSC_JD_XS : on 2 X 4 NUMA system
Starting background process FBDA
Thu Aug 09 14:10:57 2012
FBDA started with pid=18, OS id=1900
replication_dependency_tracking turned off (no async multimaster replication found)
Thu Aug 09 14:10:58 2012
Trace dumping is performing id=[cdmp_20120809141058]
Starting background process QMNC
Thu Aug 09 14:10:59 2012
QMNC started with pid=20, OS id=3668
Thu Aug 09 14:11:00 2012
Errors in file d:\app\administrator\diag\rdbms\ORCL\ORCL\trace\ORCL_pmon_3324.trc:
ORA-00474: SMON process terminated with error
PMON (ospid: 3324): terminating the instance due to error 474
Thu Aug 09 14:11:00 2012
opidrv aborting process S000 ospid (1784_3728) due to error ORA-474
Instance terminated by PMON, pid = 3324
下载专业ORACLE数据库恢复工具PRM-DUL  For Oracle http://www.parnassusdata.com/

如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复!

诗檀软件专业数据库修复团队

服务热线 : 13764045638  QQ: 47079569     邮箱:service@parnassusdata.com
您需要登录后才可以回帖 登录 | 注册

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

GMT+8, 2024-6-18 15:29 , Processed in 0.045407 second(s), 21 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

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