RE: 10.2.0.4 solaris 10 rman duplicate help
- From: "Newman, Christopher" <cjnewman@xxxxxxxxxxxxx>
- To: "Newman, Christopher" <cjnewman@xxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 24 Jul 2009 19:13:30 -0500
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Newman, Christopher
Sent: Friday, July 24, 2009 7:07 PM
To: oracle-l@xxxxxxxxxxxxx
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@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
Other related posts:
