RE: RMAN Question

From: Gerald Cunningham <gcunningham_at_proteuseng.com>
Date: Wed, 6 Mar 2013 10:51:26 -0500
Message-ID: <68F9DD51BF61E943BFA45D744048A7A731067CB755_at_nbp-ex01.proteus-technologies.com>

Hey Scott,

Make sure you "convert" parameters are set correctly, you may be trying to write a file for your auxiliary with the same name as a file on your primary.

Jerry

---

From: oracle-l-bounce_at_freelists.org [oracle-l-bounce_at_freelists.org] On Behalf Of Scott Canaan [srcdco_at_rit.edu] Sent: Wednesday, March 06, 2013 9:24 AM
To: oracle-l_at_freelists.org
Subject: RMAN Question

I am running Oracle 11.2.0.3 on Linux, 64-bit. I am trying to create a physical standby database. Both databases are on the same physical server - this is just to work out the procedure. Normally we clone databases to make copies, but that just ends up making another Primary database and I can't get it to change to standby, so I'm trying to follow the directions for creating a standby via RMAN. I am following the directions online (found in two places), using the script found online, modified for our environment, and keep getting an ORA-19505. Normally, I would not have any problem with this, but unlike the examples online, it doesn't tell me which file it can't access, so I don't know how to fix the problem. The end of the run looks like: Starting backup at 06-MAR-13
channel prmy1: starting datafile copy
copying standby control file

released channel: prmy1
released channel: prmy2
released channel: prmy3
released channel: prmy4
released channel: stby
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 03/06/2013 09:19:11
RMAN-05501: aborting duplication of target database

RMAN-03015: error occurred in stored script Memory Script RMAN-03009: failure of backup command on prmy1 channel at 03/06/2013 09:19:11 ORA-17628: Oracle error 19505 returned by remote Oracle server

RMAN> **end-of-file**

RMAN> How do I figure out what file is causing the ORA-19505?

Scott Canaan '88 (srcdco_at_rit.edu<mailto:Scott.Canaan_at_rit.edu>) (585) 475-7886 - work (585) 339-8659 - cell "Life is like a sewer, what you get out of it depends on what you put into it." - Tom Lehrer.

--
http://www.freelists.org/webpage/oracle-l--
http://www.freelists.org/webpage/oracle-l

Received on Wed Mar 06 2013 - 16:51:26 CET