Re: RMAN backup to remote dir. - how ?
Use map network drive on your target machine and define the drive as a directory on your recovery machine. I mean: map drive K on the target machine as f:\backup on the recovery machine. Then backup to drive K. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, September 11, 2002 12:48 PM Guys, I have a target DB and a recovery catalog DB. both r on two diff. machines in two diff. network ; both on oracle 8.1.6/win2k. i have created the recovery catalog and registered the target database. i want to backup a datafile DF1 in the target database. when i say, RMAN run { allocate channel c1 type disk; copy datadile DF1 to 'f:\backup'; } f:\backup -- this is a directory on the recovery DB machine. I get the error below. RMAN-00571: === RMAN-00569: === ERROR MESSAGE STACK FOLLOWS === RMAN-00571: === RMAN-03007: retryable error occurred during execution of command: copy RMAN-07004: unhandled exception during command execution on channel c1 RMAN-10035: exception raised in RPC: ORA-19504: failed to create file F:\DF1.D AT.BAK ORA-27040: skgfrcre: create error, unable to create file OSD-04002: ¢¢¢ O/S-Error: (OS 3) ORA-19600: input file is datafile 9 (D:\ORACLE\DF1.DAT) ORA-19601: output file is datafile-copy 0 (F:\DF1.DAT.BAK) RMAN-10031: ORA-19624 occurred during call to DBMS_BACKUP_RESTORE.COPYDATAFILE backup to local directory on target DB is okay. but can i backup to a remote machine on which my reco. DB resides ? if so , how do i do it ? kindly explaine me. TIA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: oraora oraora INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RMAN backup to remote dir. - how ?
Guys, I have a target DB and a recovery catalog DB. both r on two diff. machines in two diff. network ; both on oracle 8.1.6/win2k. i have created the recovery catalog and registered the target database. i want to backup a datafile DF1 in the target database. when i say, RMAN run { allocate channel c1 type disk; copy datadile DF1 to 'f:\backup'; } f:\backup -- this is a directory on the recovery DB machine. I get the error below. RMAN-00571: === RMAN-00569: === ERROR MESSAGE STACK FOLLOWS === RMAN-00571: === RMAN-03007: retryable error occurred during execution of command: copy RMAN-07004: unhandled exception during command execution on channel c1 RMAN-10035: exception raised in RPC: ORA-19504: failed to create file F:\DF1.D AT.BAK ORA-27040: skgfrcre: create error, unable to create file OSD-04002: ¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢ O/S-Error: (OS 3) ¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢ ORA-19600: input file is datafile 9 (D:\ORACLE\DF1.DAT) ORA-19601: output file is datafile-copy 0 (F:\DF1.DAT.BAK) RMAN-10031: ORA-19624 occurred during call to DBMS_BACKUP_RESTORE.COPYDATAFILE backup to local directory on target DB is okay. but can i backup to a remote machine on which my reco. DB resides ? if so , how do i do it ? kindly explaine me. TIA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: oraora oraora INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: RMAN backup to remote dir. - how ?
Well since you haven't gotten a reply from anyone else yet, I'll take a crack at it, but I don't use Oracle on Windows so I may be totally off base. I'm assuming that your f drive is a mapped drive to your catalog db server. I don't recall the details, but I believe that just because you have mapped a share that you can see, doesn't mean that Oracle can see the same mapped share. I think Oracle has fewer privileges than necessary to see the mapped drive. I don't recall the solution, but I'm pretty sure it was covered on MetaClunk. -- Philip - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, September 11, 2002 6:48 AM Guys, I have a target DB and a recovery catalog DB. both r on two diff. machines in two diff. network ; both on oracle 8.1.6/win2k. i have created the recovery catalog and registered the target database. i want to backup a datafile DF1 in the target database. when i say, RMAN run { allocate channel c1 type disk; copy datadile DF1 to 'f:\backup'; } f:\backup -- this is a directory on the recovery DB machine. I get the error below. RMAN-00571: === RMAN-00569: === ERROR MESSAGE STACK FOLLOWS === RMAN-00571: === RMAN-03007: retryable error occurred during execution of command: copy RMAN-07004: unhandled exception during command execution on channel c1 RMAN-10035: exception raised in RPC: ORA-19504: failed to create file F:\DF1.D AT.BAK ORA-27040: skgfrcre: create error, unable to create file OSD-04002: ¢¢¢ O/S-Error: (OS 3) ORA-19600: input file is datafile 9 (D:\ORACLE\DF1.DAT) ORA-19601: output file is datafile-copy 0 (F:\DF1.DAT.BAK) RMAN-10031: ORA-19624 occurred during call to DBMS_BACKUP_RESTORE.COPYDATAFILE backup to local directory on target DB is okay. but can i backup to a remote machine on which my reco. DB resides ? if so , how do i do it ? kindly explaine me. TIA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: oraora oraora INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Philip Douglass INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).