RMAN restore to ASM - ORA-17503: ksfdopn:2 Failed to open file (Doc ID 336200.1)

Last updated on APRIL 14, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 10.1.0.2 and later
Information in this document applies to any platform.
***Checked for relevance on 10-Dec-2015***

Symptoms

 

You are using Oracle Database 10g and are restoring backups taken using RMAN. The backup was taken on HOST A and you are restoring the database to HOST B. The parameter DB_CREATE_FILE_DEST is set to a new location. Almost all of the files restore without error but there are some files that show failure and their restore job will failover and spawn a new process to execute the failed RPC. The restore fails with the error:

        Errors in file /db/db01/home/oracle/admin/dm2gp/bdump/dm2gp1_dbw0_26350.trc:
        ORA-01157: cannot identify/lock data file 51 - see DBWR trace file
        ORA-01110: data file 51: '+DISKGRP1/dm2gp/datafile/data_part02_1'
        ORA-17503: ksfdopn:2 Failed to open file +DISKGRP1/dm2gp/datafile/data_part02_1
        ORA-15173: entry 'dm2gp' does not exist in directory '/'

Note that the datafile name is not an OMF name. If it were an OMF name a different error is raised:

        Errors in file /db/db01/home/oracle/admin/dm2gp/bdump/dm2gp1_dbw0_26350.trc:
        ORA-01157: cannot identify/lock data file 45 - see DBWR trace file
        ORA-01110: data file 45: '+DISKGRP1/dm2gp/datafile/undotbs02.281.562308511'
        ORA-17503: ksfdopn:2 Failed to open file +DISKGRP1/dm2gp/datafile/undotbs02.281.562308511
        ORA-15012: ASM file '+diskgrp1.281.562308511' does not exist

But the restore succeeds because the file is an OMF file.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms