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!

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.

Rman duplication issue

2796227Feb 7 2018 — edited Feb 7 2018

Hi All,

I am try to configure data guard using rman backup.My primary side backup location different from secondary side.when I create data guard using below command

rman>duplicate target database for standby BACKUP LOCATION '/u01/backup/mil11g/2018-02-06_1702' nofilenamecheck

It generate below error

channel ORA_AUX_DISK_1: starting datafile backup set restore

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

channel ORA_AUX_DISK_1: restoring datafile 00057 to +DATA/mil11gdr/datafile/i_smvi01.dbf

channel ORA_AUX_DISK_1: restoring datafile 00058 to +DATA/mil11gdr/datafile/t_vcsm01.dbf

channel ORA_AUX_DISK_1: restoring datafile 00059 to +DATA/mil11gdr/datafile/i_vcsm01.dbf

channel ORA_AUX_DISK_1: restoring datafile 00060 to +DATA/mil11gdr/datafile/t_dbsbbnktrn01.dbf

channel ORA_AUX_DISK_1: restoring datafile 00061 to +DATA/mil11gdr/datafile/i_dbsbbnktrn01.dbf

channel ORA_AUX_DISK_1: restoring datafile 00062 to +DATA/mil11gdr/datafile/t_dbmontsk01.dbf

channel ORA_AUX_DISK_1: restoring datafile 00063 to +DATA/mil11gdr/datafile/i_dbmontsk01.dbf

channel ORA_AUX_DISK_1: restoring datafile 00064 to +DATA/mil11gdr/datafile/t_miweb01.dbf

channel ORA_AUX_DISK_1: reading from backup piece /rman/rman_backup/backup/mil11g/2018-02-05_0130/DB_mcsqe8fl_1_1

channel ORA_AUX_DISK_1: ORA-19870: error while restoring backup piece /rman/rman_backup/backup/mil11g/2018-02-05_0130/DB_mcsqe8fl_1_1

ORA-19505: failed to identify file "/rman/rman_backup/backup/mil11g/2018-02-05_0130/DB_mcsqe8fl_1_1"

ORA-27037: unable to obtain file status

Linux-x86_64 Error: 2: No such file or directory

Additional information: 3

before run the duplicate command.I have run below mention command

rman target sys/oracle123@mil11g auxiliary /

Recovery Manager: Release 11.2.0.4.0 - Production on Tue feb 07 12:09:52 2018

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to target database: MIL11G (DBID=855901387)

connected to auxiliary database: MIL11GDR (not mounted)

rman>catalog start with '/u01/backup/mil11g/2018-02-06_1702' noprompt;

Oracle version-Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

OS version-Oracle Linux Server release 6.8

Please guide me solve this issue

Comments

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

Post Details

Locked on Mar 7 2018
Added on Feb 7 2018
3 comments
291 views