Shulou(Shulou.com)06/01 Report--

If you want to test something today, log in to the test library; it is found that the instance is closed

SQL > startup

ORACLE instance started.

Total System Global Area 2722467840 bytes

Fixed Size 2231472 bytes

Variable Size 1476395856 bytes

Database Buffers 1241513984 bytes

Redo Buffers 2326528 bytes

Database mounted.

ORA-03113: end-of-file on communication channel

Process ID: 23281

Session ID: 1 Serial number: 5

View the log

SUCCESS: diskgroup ORAARCH was mounted

ARCH: Error 19504 Creating archive log file to'+ ORAARCH'

Errors in file / u01/app/oracle/diag/rdbms/xhdb/xhdb1/trace/xhdb1_ora_23565.trc:

ORA-16038: log 5 sequence# 345 cannot be archived

ORA-19504: failed to create file ""

ORA-00312: onlinelog 5 thread 1:'+ ORADATA/xhdb/onlinelog/group_5.272.857422319'

USER (ospid: 23565): terminating the instance due to error 16038

System state dump requested by (instance=1, osid=23565), summary= [abnormal instance termination].

System State dumped to trace file / u01/app/oracle/diag/rdbms/xhdb/xhdb1/trace/xh db1_diag_23451.trc

Dumping diagnostic data in directory= [CDMP _ 20141218102056], requested by (instance = 1, osid=23565), summary= [abnormal instance termination].

Instance terminated by USER, pid = 23565

Fdisk to see that the disks are all there; switching to the grid cluster is also running, and the asm disk groups are all there; maybe there is not enough archive space; start the database instance of node 1 to the mount state

SQL > startup mount

ORACLE instance started.

Total System Global Area 2722467840 bytes

Fixed Size 2231472 bytes

Variable Size 1476395856 bytes

Database Buffers 1241513984 bytes

Redo Buffers 2326528 bytes

Database mounted.

SQL > archive log list

Database log mode Archive Mode

Automatic archival Enabled

Archive destination + ORAARCH

Oldest online log sequence 345

Next log sequence to archive 345

SQL > select group_number,name,state,total_mb,free_mb from v$asm_diskgroup

GROUP_NUMBER NAME STATE TOTAL_MB FREE_MB

1 CRS MOUNTED 998 600

2 ORAARCH MOUNTED 8189 11

3 ORADATA CONNECTED 20473 16198

It is found that there is not enough oraarch archive space, so node 1 logs in to rman and deletes the archive log; start the database instance on node 1 and node 2, which is normal

RMAN > crosscheck archivelog all

RMAN > delete archivelog all

SQL > select group_number,name,state,total_mb,free_mb from v$asm_diskgroup

GROUP_NUMBER NAME STATE TOTAL_MB FREE_MB

1 CRS MOUNTED 998 600

2 ORAARCH CONNECTED 8189 5123

3 ORADATA CONNECTED 20473 16198

SQL > alter database open

Database altered.

Node 2 can also be opened normally.

[oracle@rac2 ~] $sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Thu Dec 18 10:56:54 2014

Copyright (c) 1982, 2011, Oracle. All rights reserved.

Connected to an idle instance.

SQL > startup

ORACLE instance started.

Total System Global Area 2722467840 bytes

Fixed Size 2231472 bytes

Variable Size 1191183184 bytes

Database Buffers 1526726656 bytes

Redo Buffers 2326528 bytes

Database mounted.

Database opened.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.