Skip to Main Content

Database Software

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

How to recover?

Ariz - Apps DBAMar 9 2017 — edited Mar 20 2017

Hi All

How to recover from this error while restoring/duplicating database into other server?

channel ORA_DISK_1: starting datafile backup set restore

channel ORA_DISK_1: specifying datafile(s) to restore from backup set

channel ORA_DISK_1: restoring datafile 00010 to  /backup/TEST/datafiles/TEST_03.dbf

channel ORA_DISK_1: reading from backup piece /backup/rmanbkup_TEST_21022017/TEST_online_full_936565204_13863_1.bck

channel ORA_DISK_1: ORA-19870: error while restoring backup piece /backup/rmanbkup_TEST_21022017/TEST_online_full_936565204_13863_1.bck

ORA-19504: failed to create file "/u01/oracle/product/11.2.0.3/dbhome_1/dbs/ /backup/TEST/datafiles/TEST_03.dbf"

ORA-27040: file create error, unable to create file

IBM AIX RISC System/6000 Error: 2: No such file or directory

Additional information: 1

failover to previous backup

creating datafile file number=10 name= /backup/TEST/datafiles/TEST_03.dbf

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

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

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

RMAN-03002: failure of restore command at 03/09/2017 07:35:07

ORA-01119: error in creating database file ' /backup/TEST/datafiles/TEST_03.dbf'

ORA-27040: file create error, unable to create file

IBM AIX RISC System/6000 Error: 2: No such file or directory

Additional information: 1

RMAN-06956: create datafile failed; retry after removing  /backup/TEST/datafiles/TEST_03.dbf from OS

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Apr 17 2017
Added on Mar 9 2017
23 comments
1,177 views