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

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

999

积分

1

好友

942

主题
1#
发表于 2017-4-15 10:40:12 | 查看: 1912| 回复: 0

数据库版本:Release 11.2.0.1.0

1. startup nomount阶段,可以正常。启动到mount状态时,报错:
SQL> startup nomount pfile='/home/oracle/pfile.ora';
ORACLE instance started.
Total System Global Area 2.0310E+10 bytes
Fixed Size      2212976 bytes
Variable Size   1.0737E+10 bytes
Database Buffers  9395240960 bytes
Redo Buffers    175132672 bytes
SQL> alter database mount;
alter database mount
*
ERROR at line 1:
ORA-03135: connection lost contact
Process ID: 27427
Session ID: 919 Serial number: 5

2. 如果直接startup mount:
SQL> create spfile from pfile='/home/oracle/pfile05.ora';
File created.
SQL> startup mount
ORACLE instance started.
Total System Global Area 2.0310E+10 bytes
Fixed Size      2212976 bytes
Variable Size   1.0737E+10 bytes
Database Buffers  9395240960 bytes
Redo Buffers    175132672 bytes
ORA-03113: end-of-file on communication channel
Process ID: 27573
Session ID: 919 Serial number: 3

3.alter里的信息:


Thu Jan 31 08:59:05 2013
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Thu Jan 31 08:59:17 2013
MAX_CONNECTIONS 20 too high - Using 5 connections.
Autotune of undo retention is turned on.
IMODE=BR
ILAT =134
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
Using parameter settings in server-side spfile /home/oracle/oracle/product/10.2.0/db_1/dbs/spfileorcl.ora
System parameters with non-default values:
  processes                = 800
  memory_target            = 19G
  control_files            = "/u/oracle/oradata/sdb/control01.ctl"
  db_file_name_convert     = "orcl"
  db_file_name_convert     = "sdb"
  log_file_name_convert    = "orcl"
  log_file_name_convert    = "sdb"
  control_file_record_keep_time= 60
  db_block_size            = 8192
  compatible               = "11.2.0.0.0"
  log_archive_dest_1       = "LOCATION=USE_DB_RECOVERY_FILE_DEST VALID_FOR=(all_logfiles,all_roles) db_unique_name=sdb"
  log_archive_dest_2       = "service=orcl noaffirm async delay=0 net_timeout=600 reopen=10 max_connections=20 valid_for=(online_logfiles,primary_role) db_unique_name=orcl"
  log_archive_dest_state_1 = "ENABLE"
  log_archive_dest_state_2 = "enable"
  log_archive_dest_state_3 = "ENABLE"
  fal_client               = "sdb"
  fal_server               = "orcl"
  log_archive_config       = "DG_CONFIG=(orcl,sdb)"
  log_archive_format       = "%t_%s_%r.arc"
  log_archive_max_processes= 30
  db_recovery_file_dest    = "/u/oracle/oradata/sdb/flash_recovery_area"
  db_recovery_file_dest_size= 500G
  standby_file_management  = "AUTO"
  undo_tablespace          = "UNDOTBS1"
  remote_login_passwordfile= "EXCLUSIVE"
  db_domain                = ""
  dispatchers              = "(PROTOCOL=TCP) (SERVICE=orclXDB)"
  local_listener           = "LISTENER_ORCL"
  audit_file_dest          = "/home/oracle/oracle/admin/orcl/adump"
  audit_trail              = "DB"
  db_name                  = "orcl"
  db_unique_name           = "sdb"
  open_cursors             = 300
  diagnostic_dest          = "/home/oracle/oracle"
Thu Jan 31 08:59:23 2013
PMON started with pid=2, OS id=27523
Thu Jan 31 08:59:23 2013
VKTM started with pid=3, OS id=27525 at elevated priority
VKTM running at (10)millisec precision with DBRM quantum (100)ms
Thu Jan 31 08:59:23 2013
GEN0 started with pid=4, OS id=27529
Thu Jan 31 08:59:23 2013
DIAG started with pid=5, OS id=27531
Thu Jan 31 08:59:23 2013
DBRM started with pid=6, OS id=27533
Thu Jan 31 08:59:23 2013
PSP0 started with pid=7, OS id=27535
Thu Jan 31 08:59:23 2013
DIA0 started with pid=8, OS id=27537
Thu Jan 31 08:59:23 2013
MMAN started with pid=9, OS id=27539
Thu Jan 31 08:59:23 2013
DBW0 started with pid=10, OS id=27541
Thu Jan 31 08:59:23 2013
LGWR started with pid=11, OS id=27543
Thu Jan 31 08:59:23 2013
CKPT started with pid=12, OS id=27545
Thu Jan 31 08:59:23 2013
SMON started with pid=13, OS id=27547
Thu Jan 31 08:59:23 2013
RECO started with pid=14, OS id=27549
Thu Jan 31 08:59:23 2013
MMON started with pid=15, OS id=27551
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Thu Jan 31 08:59:23 2013
MMNL started with pid=16, OS id=27553
starting up 1 shared server(s) ...
ORACLE_BASE from environment = /home/oracle/oracle
Spfile /home/oracle/oracle/product/10.2.0/db_1/dbs/spfileorcl.ora is in old pre-11 format and compatible >= 11.0.0; converting to new H.A.R.D. compliant format.
Thu Jan 31 08:59:33 2013
ALTER DATABASE   MOUNT
Thu Jan 31 09:00:27 2013
RECO (ospid: 27549): terminating the instance due to error 472
Instance terminated by RECO, pid = 27549

请问这个error 472到底代表什么?到底是什么原因呢?



再次尝试,会报如下错误:
Thu Jan 31 09:34:02 2013
ALTER DATABASE   MOUNT
Thu Jan 31 09:35:01 2013
MMNL (ospid: 28345): terminating the instance due to error 472
Instance terminated by MMNL, pid = 28345


主备库用的是同版本的数据库,参数文件也是在主库上创建来的。
下载专业ORACLE数据库恢复工具PRM-DUL  For Oracle http://www.parnassusdata.com/

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

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

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

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

GMT+8, 2024-6-1 18:35 , Processed in 0.048640 second(s), 21 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

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