Storage Management (ASM ACFS DNFS ODM) (MOSC)

MOSC Banner

Unable to write to folder in an ASM diskgroup

edited Jun 13, 2016 5:04AM in Storage Management (ASM ACFS DNFS ODM) (MOSC) 1 commentAnswered

I am trying to restore a RAC production database on to non-prod RAC database on ASM. Here is the error.

creating datafile file number=1 name=+QANEXT_DATA/qanext/DATAFILE/system.266.837549057

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of restore command at 06/02/2016 08:19:20

ORA-01180: can not create datafile 1

ORA-01110: data file 1: '+PRD_DATA_DG/ciprod/datafile/system.266.837549057'

I am thinking it RMAN can't create datafile 1 in +QANEXT_DATA/qanext/DATAFILE on the destination.

ASMCMD> ls -l

Type           Redund  Striped  Time             Sys  Name

                                                 Y    ASMPARAMETERFILE/

                                                 Y    CONTROLFILE/

                                                 N    DATAFILE/

                                                 Y    OCRFILE/

                                                 N    ONLINELOG/

                                                 Y    PARAMETERFILE/

                                                 Y    TEMPFILE/

                                                 N    spfileqanext.ora => +QANEXT_DATA/qanext/PARAMETERFILE/spfile.808.864417061

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center