服务器未知原因故障恢复后,启动数据库实例报错,错误信息如下:
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
墨值悬赏

评论
