一. 问题描述:
DG搭建后之后发现备库无法打开
SQL> alter database open read only;
alter database open read only
*
ERROR at line 1:
ORA-00221: error on write to control file
ORA-00206: error in writing (block 17, # blocks 1) of control file
ORA-00202: control file: '+DATA/stdo/controlfile/current.259.929097275'
ORA-15081: failed to submit an I/O operation to a disk
ORA-15081: failed to submit an I/O operation to a disk
ORA-00206: error in writing (block 17, # blocks 1) of control file
ORA-00202: control file: '+DATA/stdo/controlfile/current.258.929097275'
ORA-15081: failed to submit an I/O operation to a disk
ORA-15081: failed to submit an I/O operation to a disk
重启后亦无法mount
SQL> shutdown immediate
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options
[oracle@adminm dbs]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Mon Nov 28 11:19:36 2016
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup nomount pfile='/u01/app/oracle/product/11.2/db_1/dbs/initstdo.ora';
ORACLE instance started.
Total System Global Area 1.4665E+10 bytes
Fixed Size 2267424 bytes
Variable Size 2684356320 bytes
Database Buffers 1.1945E+10 bytes
Redo Buffers 32624640 bytes
SQL> alter database mount standby database;
alter database mount standby database
*
ERROR at line 1:
ORA-00221: error on write to control file
ORA-00206: error in writing (block 1, # blocks 1) of control file
ORA-00202: control file: '+DATA/stdo/controlfile/current.258.929097275'
ORA-15081: failed to submit an I/O operation to a disk
ORA-15081: failed to submit an I/O operation to a disk
SQL>
SQL>
二. 问题分析:
-rwsr-s--x 1 oracle oinstall 239840842 Nov 24 11:18 /u01/app/oracle/product/11.2/db_1/bin/oracle
[oracle@adminm dbs]$
三. 问题解决:
[grid@adminm ~]$
[grid@adminm ~]$ cd $ORACLE_HOME
[grid@adminm grid]$ pwd
/u01/app/11.2.0/grid
[grid@adminm grid]$ cd bin
[grid@adminm bin]$ ls setasmgidwrap
setasmgidwrap
[grid@adminm bin]$ ./setasmgidwrap o=/u01/app/oracle/product/11.2/db_1/bin/oracle
[grid@adminm bin]$
-rwsr-s--x 1 oracle asmadmin 239840842 Nov 24 11:18 /u01/app/oracle/product/11.2/db_1/bin/oracle
[oracle@adminm ~]$