Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Active Duplicate failing with ORA-15041

rchemDec 5 2017 — edited Dec 5 2017

Hello  ,

Thanks for your time.

Oracle DB Version: 12.1.0.2

Oracle Linux 6.5

While trying to perform active duplicate , duplication failing with below errors, DATA diskgroup is having sufficient space when I verify from  ASM instance.

I have used regular duplicate command as below. Source database is in non-asm and I am trying to duplicate the DB to ASM.

DUPLICATE TARGET DATABASE TO PERFSP2 from active database;

ORA-19660: some files in the backup set could not be verified

ORA-19661: datafile 4 could not be verified

ORA-19849: error while reading backup piece from service perfsp3

ORA-19504: failed to create file "+DATA"

ORA-17502: ksfdcre:4 Failed to create file +DATA

ORA-15041: diskgroup "DATA" space exhausted

SQL> select name, state, type, total_mb, free_mb from v$asm_diskgroup where name = 'DATA';

NAME                           STATE       TYPE     TOTAL_MB    FREE_MB

------------------------------ ----------- ------ ---------- ----------

DATA                           MOUNTED     EXTERN    1757808    1750080

I have verified the MOS note 1987552.1 and set SQLNET.USE_ZERO_COPY_IO=0 , but it doesn't seem to be working.  Would like to know if any community members come across similar issue.

Regards

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 2 2018
Added on Dec 5 2017
2 comments
755 views