RE: 10.2.0.4 solaris 10 rman duplicate help
Date: Fri, 24 Jul 2009 19:13:30 -0500
Message-ID: <565F609E6D736D439837F1A1A797F341020CCA18_at_ADMINMAIL1.ui.uillinois.edu>
Replying to myself, sorry, it's late on a Friday J Quick metalink search shows that after creating the standby control file, you've got to switch a few logs or you'll get the error. Strange correlation if you ask me.
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Newman, Christopher
Sent: Friday, July 24, 2009 7:07 PM
To: oracle-l_at_freelists.org
Subject: 10.2.0.4 solaris 10 rman duplicate help
Greetings,
Trying to duplicate a database using rman, never had an issue before,
but having problems now. I've created the standby controlfile on the
primary via alter database create standby controlfile as
'/u02/backup/$SOURCE_SID/stndby_$ORACLE_SID.ctl'; and scp'd that over to
the standby, as well as a fresh full RMAN backup taken prior to the
controlfile creation.
I've set my default RMAN settings on the standby to match the primary,
ie 'CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT
'/u02/backup/%d/%U_%I';', but I'm getting the following when trying to
run my rman script:
RMAN-03002: failure of Duplicate Db command at 07/24/2009 19:01:12
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
My connect string is: rman target sys/pass_at_PRIMARY AUXILIARY /
Rman script:
run {
allocate auxiliary channel C1 device type disk;
...
allocate auxiliary channel C15 device type disk;
duplicate target database for standby
DORECOVER NOFILENAMECHECK; }
I'm sure it's something trivial... I just did this exact procedure on a different box and it worked fine, what am I missing?
Chris Newman
Database Specialist
AITS, University of Illinois
217-333-5429
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Jul 24 2009 - 19:13:30 CDT