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!

RMAN remote backup/duplicate failures

1006110Apr 29 2013 — edited May 2 2013
Hi everybody,

I'm trying to restore a level 0, 11g Standard One (on RedHat 6.2), 19GB db on a remote server.

Although there are over 45GB free disk space and both user oracle and group oinstall have create/delete rights on folder backupset, I get the following error when I try to backup (and no folder 2013_04_26 is created):

RMAN-03009: failure of backup command on ORA_DISK_1 channel at 04/26/2013 11:31:58
ORA-19502: write error on file "/home/oracle/rman/ORCL/backupset/2013_04_26/o1_mf_nnnd0_TAG20130426T042617_8qngkl50_.bkp", block number 120320 (block size=8192)
ORA-27072: File I/O error
Additional information: 4
Additional information: 120320
Additional information: 462848

Please note that local backup worked fine.

I also tried to duplicate the db (from the auxiliary server) without success, getting for all target files following errors (here I copied those for only one of them), although all backup files exist in their corresponding folders:

channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: restoring control file
channel ORA_AUX_DISK_1: reading from backup piece /home/oracle/rman/ORCL/backupset/2013_04_09/o1_mf_ncsn0_TAG20130409T062510_8p7v48nq_.bkp
channel ORA_AUX_DISK_1: ORA-19870: error while restoring backup piece /home/oracle/rman/ORCL/backupset/2013_04_09/o1_mf_ncsn0_TAG20130409T062510_8p7v48nq_.bkp
ORA-19505: failed to identify file "/home/oracle/rman/ORCL/backupset/2013_04_09/o1_mf_ncsn0_TAG20130409T062510_8p7v48nq_.bkp"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3

failover to previous backup

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 04/26/2013 15:30:28
RMAN-03015: error occurred in stored script Memory Script
RMAN-06026: some targets not found - aborting restore
RMAN-06024: no backup or copy of the control file found to restore

Please note that I checked the existence of the controlfile.

Thank you very much in advance for your help,
Christian Mancas
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 30 2013
Added on Apr 29 2013
6 comments
3,937 views