Re: Database Will Not Mount: ORA-00205

Thanks Martin, I did. There is something 'strange' in or on or with the ASM directories however.

First, let me show you the controlfile entries:

SQL> show parameter control_files

NAME                                 TYPE        VALUE
------------------------------------ -----------
------------------------------
control_files                        string
+DATA/ORCL/CONTROLFILE/current
                                                 .263.881061111,
+DATA/ORCL/CON
                                                 TROLFILE/current.270.

Then from asmcmd:

ASMCMD> pwd
+data/orcl/controlfile
ASMCMD> ls
Current.263.881061111
Current.270.881061111

But here's the strange part. There is a directory in +data/orcl for a subdirectory in hex:

ASMCMD> pwd
+data/orcl
ASMCMD> ls
CONTROLFILE/
DATAFILE/
FD9AC20F64D244D7E043B6A9E80A2F2F/
ONLINELOG/
PARAMETERFILE/
PASSWORD/
TEMPFILE/
spfileorcl.ora

That directory also has an empty /data directory. I don't know where this directory came from or how it came to be. The hex doesn't match up with any of the SAN disk designations in /etc/multipath.conf.

The diskgroup will unmount and remount. This anomaly may or may not have something to do with the problem and probably does, but until I can figure out why, I'm loathe to trash the DB and restore as I am not sure at this point if that would even work.

Both the GI DB and the Database DB show the diskgroup as mounted. I've shut down the database and from the ASM DB:

  1 select a.disk_number, a.name, b.name, b.state from v$asm_disk a   2 join v$asm_diskgroup b on a.group_number=b.group_number   3 where b.name = 'DATA'
  4* order by b.name, a.disk_number
SQL> /

DISK_NUMBER NAME                           NAME

----------- ------------------------------ ------------------------------
-----------
          0 DATA_0000                      DATA
 MOUNTED
          1 DATA_0001                      DATA
 MOUNTED
          2 DATA_0002                      DATA
 MOUNTED
          3 DATA_0003                      DATA

ASMCMD> lsdg
State Type Rebal Sector Logical_Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name

MOUNTED  EXTERN  N         512             512   4096  1048576   2048000
2015692                0         2015692              0             N  DATA/
MOUNTED  EXTERN  N         512             512   4096  1048576   2097152
1995639                0         1995639              0             N  FRA/
MOUNTED  NORMAL  N         512             512   4096  1048576    131072
 121325            32768           44278              0             Y  GRID/
MOUNTED  EXTERN  N         512             512   4096  1048576   5242880
 866751                0          866751              0             N
PRDREPDATA01/
MOUNTED  EXTERN  N         512             512   4096  1048576    131072
58531                0           58531              0             N
PRDREPFRA/
MOUNTED  EXTERN  N         512             512   4096  1048576     51200
51097                0           51097              0             N  REDO1/
MOUNTED  EXTERN  N         512             512   4096  1048576     51200
51097                0           51097              0             N  REDO2/

If I run the command: alter diskgroup data check norepair;

The alert log shows this:

SQL> alter diskgroup data check norepair 2018-02-11T08:02:18.336101-06:00
NOTE: starting check of diskgroup DATA
2018-02-11T08:02:18.809062-06:00
GMON querying group 1 at 72 for pid 36, osid 44682 GMON checking disk 0 for group 1 at 73 for pid 36, osid 44682 GMON querying group 1 at 74 for pid 36, osid 44682 GMON checking disk 1 for group 1 at 75 for pid 36, osid 44682 GMON querying group 1 at 76 for pid 36, osid 44682 GMON checking disk 2 for group 1 at 77 for pid 36, osid 44682 GMON querying group 1 at 78 for pid 36, osid 44682 GMON checking disk 3 for group 1 at 79 for pid 36, osid 44682 2018-02-11T08:02:19.679724-06:00
SUCCESS: check of diskgroup DATA found no errors 2018-02-11T08:02:19.679963-06:00
SUCCESS: alter diskgroup data check norepair

What the heck is going on?

On Sun, Feb 11, 2018 at 7:24 AM, Martin Decker < martin.decker_at_ora-solutions.net> wrote:

> Hi David,
>
> did you check alert log?
>
> It will refer you to the filename of the control file. You can then check
> if the file exists with asmcmd.
>
> Regards,
> Martin
>
> --
> --
>
>
>
> Martin Decker
> Dipl.-Ing. (FH)
> Oracle 10g/11g/12c Certified Master
>
> +43 (0) 699 1131 6463 <+43%20699%2011316463>
>
> martin.decker_at_ora-solutions.net
> http://www.ora-solutions.net
>
>
>
>

--
http://www.freelists.org/webpage/oracle-l