暂无图片
分享
攻城狮
2019-03-01
RAC环境下启动orcl实例失败

服务器未知原因故障恢复后,启动数据库实例报错,错误信息如下:

ri Mar 01 10:00:35 2019

RSMN started with pid=43, OS id=11784 

ORACLE_BASE from environment = D:\app\Administrator

Fri Mar 01 10:00:37 2019

ALTER DATABASE MOUNT /* db agent *//* {2:38813:23181} */

This instance was first to mount

NOTE: Loaded library: System 

SUCCESS: diskgroup DATA was mounted

SUCCESS: diskgroup FRA was mounted

NOTE: dependency between database orcl and diskgroup resource ora.DATA.dg is established

NOTE: dependency between database orcl and diskgroup resource ora.FRA.dg is established

Fri Mar 01 10:00:41 2019

Successful mount of redo thread 2, with mount id 1529506885

Database mounted in Shared Mode (CLUSTER_DATABASE=TRUE)

Lost write protection disabled

Completed: ALTER DATABASE MOUNT /* db agent *//* {2:38813:23181} */

ALTER DATABASE OPEN /* db agent *//* {2:38813:23181} */

This instance was first to open

Fri Mar 01 10:00:41 2019

Errors in file D:\APP\ADMINISTRATOR\diag\rdbms\orcl\orcl2\trace\orcl2_dbw0_5844.trc:

ORA-01157: ????/?????? 11 - ??? DBWR ????

ORA-01110: ???? 11: 'D:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\DATABASE\NXPT.DBF'

ORA-27041: ??????

OSD-04002: ÎÞ·¨´ò¿ªÎļþ

O/S-Error: (OS 2) ϵͳÕÒ²»µ½Ö¸¶¨µÄÎļþ¡£

Abort recovery for domain 0

Errors in file D:\APP\ADMINISTRATOR\diag\rdbms\orcl\orcl2\trace\orcl2_ora_7780.trc:

ORA-01157: ????/?????? 11 - ??? DBWR ????

ORA-01110: ???? 11: 'D:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\DATABASE\NXPT.DBF'

ORA-1157 signalled during: ALTER DATABASE OPEN /* db agent *//* {2:38813:23181} */...

Fri Mar 01 10:00:59 2019

Shutting down instance (abort)

License high water mark = 2

USER (ospid: 13460): terminating the instance

Instance terminated by USER, pid = 13460

Fri Mar 01 10:01:16 2019

Instance shutdown complete

Fri Mar 01 10:34:34 2019

Adjusting the default value of parameter parallel_max_servers

from 3200 to 1470 due to the value of parameter processes (1500)

Starting ORACLE instance (normal)

LICENSE_MAX_SESSION = 0

LICENSE_SESSIONS_WARNING = 0

Initial number of CPU is 80

Number of processor cores in the system is 40

Number of processor sockets in the system is 4

Private Interface 'private' configured from GPnP for use as a private interconnect.

  [name='private', type=1, ip=10.10.10.2, mac=a0-36-9f-4c-d8-33, net=10.10.10.0/24, mask=255.255.255.0, use=cluster_interconnect/6]

Public Interface 'pub' configured from GPnP for use as a public interface.

  [name='pub', type=1, ip=172.16.5.2, mac=a0-36-9f-4c-d8-32, net=172.16.5.0/24, mask=255.255.255.0, use=public/1]

Public Interface 'pub' configured from GPnP for use as a public interface.

  [name='pub', type=1, ip=172.16.5.3, mac=a0-36-9f-4c-d8-32, net=172.16.5.0/24, mask=255.255.255.0, use=public/1]

Public Interface 'pub' configured from GPnP for use as a public interface.

  [name='pub', type=1, ip=172.16.5.4, mac=a0-36-9f-4c-d8-32, net=172.16.5.0/24, mask=255.255.255.0, use=public/1]

Public Interface 'pub' configured from GPnP for use as a public interface.

  [name='pub', type=1, ip=172.16.5.5, mac=a0-36-9f-4c-d8-32, net=172.16.5.0/24, mask=255.255.255.0, use=public/1]

Picked latch-free SCN scheme 3

Fri Mar 01 10:35:06 2019

Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST

Autotune of undo retention is turned on. 

LICENSE_MAX_USERS = 0

SYS auditing is disabled

NUMA system with 4 nodes detected

Starting up:

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, Real Application Clusters, Oracle Label Security, OLAP,

Data Mining, Oracle Database Vault and Real Application Testing options.

Windows NT Version V6.1 Service Pack 1 

CPU                 : 40 - type 8664, 40 Physical Cores

Process Affinity    : 0x0x0000000000000000

Memory (Avail/Total): Ph:70363M/262098M, Ph+PgF:102032M/294864M 

Using parameter settings in server-side pfile D:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\DATABASE\INITORCL2.ORA

System parameters with non-default values:

  processes                = 1500

  sessions                 = 2320

  spfile                   = "+DATA/orcl/spfileorcl.ora"

  nls_language             = "SIMPLIFIED CHINESE"

  nls_territory            = "CHINA"

  memory_target            = 153G

  control_files            = "+DATA/orcl/controlfile/current.256.869510033"

  control_files            = "+FRA/orcl/controlfile/current.256.869510033"

  db_block_size            = 8192

  compatible               = "11.2.0.4.0"

  cluster_database         = TRUE

  db_create_file_dest      = "+DATA"

  db_recovery_file_dest    = "+FRA"

  db_recovery_file_dest_size= 522000M

  thread                   = 2

  undo_tablespace          = "UNDOTBS2"

  instance_number          = 2

  remote_login_passwordfile= "EXCLUSIVE"

  db_domain                = ""

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

  remote_listener          = "zwdbscan:1521"

  audit_file_dest          = "D:\APP\ADMINISTRATOR\ADMIN\ORCL\ADUMP"

  audit_trail              = "DB"

  db_name                  = "orcl"

  open_cursors             = 300

  deferred_segment_creation= TRUE

  diagnostic_dest          = "D:\APP\ADMINISTRATOR"

Cluster communication is configured to use the following interface(s) for this instance

  10.10.10.2

cluster interconnect IPC version:Oracle 11 Winsock2 TCP/IP IPC

IPC Vendor 1 proto 1

  Version 2.0

Fri Mar 01 10:35:07 2019

PMON started with pid=2, OS id=12844 

Fri Mar 01 10:35:07 2019

PSP0 started with pid=3, OS id=8584 

Fri Mar 01 10:35:08 2019

VKTM started with pid=4, OS id=9832 at elevated priority

VKTM running at (10)millisec precision with DBRM quantum (100)ms

Fri Mar 01 10:35:08 2019

GEN0 started with pid=5, OS id=13556 

Fri Mar 01 10:35:08 2019

DIAG started with pid=6, OS id=12340 

Fri Mar 01 10:35:08 2019

DBRM started with pid=7, OS id=13508 

Fri Mar 01 10:35:08 2019

PING started with pid=8, OS id=12524 

Fri Mar 01 10:35:08 2019

ACMS started with pid=9, OS id=13776 

Fri Mar 01 10:35:08 2019

DIA0 started with pid=10, OS id=5380 

Fri Mar 01 10:35:08 2019

LMON started with pid=11, OS id=14296 

Fri Mar 01 10:35:08 2019

LMD0 started with pid=12, OS id=13956 

* CPU Monitor used for high load check 

* New Low - High Load Threshold Range = [60 - 80] 

Fri Mar 01 10:35:08 2019

LMS0 started with pid=13, OS id=13080 at elevated priority

Fri Mar 01 10:35:08 2019

LMS1 started with pid=14, OS id=8316 at elevated priority

Fri Mar 01 10:35:08 2019

LMS2 started with pid=15, OS id=13396 at elevated priority

Fri Mar 01 10:35:08 2019

LMS3 started with pid=16, OS id=11456 at elevated priority

Fri Mar 01 10:35:08 2019

RMS0 started with pid=17, OS id=8484 

Fri Mar 01 10:35:08 2019

LMHB started with pid=18, OS id=11784 

Fri Mar 01 10:35:08 2019

MMAN started with pid=19, OS id=1716 

Fri Mar 01 10:35:08 2019

DBW0 started with pid=20, OS id=10132 

Fri Mar 01 10:35:08 2019

DBW1 started with pid=21, OS id=10236 

Fri Mar 01 10:35:08 2019

DBW2 started with pid=22, OS id=9264 

Fri Mar 01 10:35:08 2019

DBW3 started with pid=23, OS id=13736 

Fri Mar 01 10:35:08 2019

DBW4 started with pid=24, OS id=11268 

Fri Mar 01 10:35:08 2019

DBW5 started with pid=25, OS id=12324 

Fri Mar 01 10:35:08 2019

DBW6 started with pid=26, OS id=14160 

Fri Mar 01 10:35:08 2019

DBW7 started with pid=27, OS id=6504 

Fri Mar 01 10:35:08 2019

DBW8 started with pid=28, OS id=9692 

Fri Mar 01 10:35:08 2019

DBW9 started with pid=29, OS id=10776 

Fri Mar 01 10:35:08 2019

LGWR started with pid=30, OS id=11792 

Fri Mar 01 10:35:08 2019

CKPT started with pid=31, OS id=11060 

Fri Mar 01 10:35:08 2019

SMON started with pid=32, OS id=13684 

Fri Mar 01 10:35:08 2019

RECO started with pid=33, OS id=10432 

Fri Mar 01 10:35:08 2019

RBAL started with pid=34, OS id=14068 

Fri Mar 01 10:35:08 2019

ASMB started with pid=35, OS id=4908 

Fri Mar 01 10:35:08 2019

MMON started with pid=36, OS id=14188 

Fri Mar 01 10:35:08 2019

MMNL started with pid=37, OS id=1632 

NOTE: initiating MARK startup 

Starting background process MARK

Fri Mar 01 10:35:08 2019

MARK started with pid=38, OS id=12596 

NOTE: MARK has subscribed 

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

starting up 1 shared server(s) ...

lmon registered with NM - instance number 2 (internal mem no 1)

Reconfiguration started (old inc 0, new inc 2)

List of instances:

 2 (myinst: 2) 

 Global Resource Directory frozen

* allocate domain 0, invalid = TRUE 

 Communication channels reestablished

 Master broadcasted resource hash value bitmaps

 Non-local Process blocks cleaned out

 LMS 2: 0 GCS shadows cancelled, 0 closed, 0 Xw survived

 LMS 1: 0 GCS shadows cancelled, 0 closed, 0 Xw survived

 LMS 3: 0 GCS shadows cancelled, 0 closed, 0 Xw survived

 LMS 0: 0 GCS shadows cancelled, 0 closed, 0 Xw survived

 Set master node info 

 Submitted all remote-enqueue requests

 Dwn-cvts replayed, VALBLKs dubious

 All grantable enqueues granted

 Post SMON to start 1st pass IR

 Submitted all GCS remote-cache requests

 Post SMON to start 1st pass IR

 Fix write in gcs resources

Reconfiguration complete

Fri Mar 01 10:35:13 2019

LCK0 started with pid=42, OS id=9776 

Starting background process RSMN

Fri Mar 01 10:35:13 2019

RSMN started with pid=43, OS id=12804 

ORACLE_BASE from environment = D:\app\Administrator

Fri Mar 01 10:35:15 2019

ALTER DATABASE MOUNT /* db agent *//* {2:38813:24530} */

This instance was first to mount

NOTE: Loaded library: System 

SUCCESS: diskgroup DATA was mounted

SUCCESS: diskgroup FRA was mounted

NOTE: dependency between database orcl and diskgroup resource ora.DATA.dg is established

NOTE: dependency between database orcl and diskgroup resource ora.FRA.dg is established

Fri Mar 01 10:35:22 2019

Successful mount of redo thread 2, with mount id 1529508963

Database mounted in Shared Mode (CLUSTER_DATABASE=TRUE)

Lost write protection disabled

Completed: ALTER DATABASE MOUNT /* db agent *//* {2:38813:24530} */

ALTER DATABASE OPEN /* db agent *//* {2:38813:24530} */

This instance was first to open

Fri Mar 01 10:35:22 2019

Errors in file D:\APP\ADMINISTRATOR\diag\rdbms\orcl\orcl2\trace\orcl2_dbw0_10132.trc:

ORA-01157: ????/?????? 11 - ??? DBWR ????

ORA-01110: ???? 11: 'D:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\DATABASE\NXPT.DBF'

ORA-27041: ??????

OSD-04002: ÎÞ·¨´ò¿ªÎļþ

O/S-Error: (OS 2) ϵͳÕÒ²»µ½Ö¸¶¨µÄÎļþ¡£

Abort recovery for domain 0

Errors in file D:\APP\ADMINISTRATOR\diag\rdbms\orcl\orcl2\trace\orcl2_ora_13540.trc:

ORA-01157: ????/?????? 11 - ??? DBWR ????

ORA-01110: ???? 11: 'D:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\DATABASE\NXPT.DBF'

ORA-1157 signalled during: ALTER DATABASE OPEN /* db agent *//* {2:38813:24530} */...

Fri Mar 01 10:35:33 2019

Shutting down instance (abort)

License high water mark = 1

USER (ospid: 11700): terminating the instance

Fri Mar 01 10:35:44 2019

Instance terminated by USER, pid = 11700

Fri Mar 01 10:35:53 2019

Instance shutdown complete


收藏
分享
6条回答
默认
最新
攻城狮
上传附件:alert_orcl.log
暂无图片 评论
暂无图片 有用 0
Moone

从报错看,这个是一个本地数据文件'D:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\DATABASE\NXPT.DBF',应该是你们将RAC中的数据库文件误建到本地磁盘,所以其他实例无法启动,导致错误。

处理方法:

1、将此数据文件脱机,实例可以马上拉起,然后将此数据文件移动到共享存储,视数据文件大小会有一定时间不能读写;

2、使用rman copy到共享存储中,脱机做一次switch datafile to copy,不可用读写时间更小。但是完成迁移后实例才能拉起。

暂无图片 评论
暂无图片 有用 0
攻城狮

谢谢!

我随后检查下数据文件

暂无图片 评论
暂无图片 有用 0
Kamus

请问一下,问题是否已经解决

暂无图片 评论
暂无图片 有用 0
攻城狮

已解决,谢谢

暂无图片 评论
暂无图片 有用 0
章芋文
问题已关闭: 问题已经得到解决
暂无图片 评论
暂无图片 有用 0
回答交流
提交
问题信息
请登录之后查看
附件列表
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
暂无图片墨值悬赏