RMAN DUPLICATE FAILES WITH ORA-01503 RMAN-06136 ORA-01504
(Doc ID 269801.1)
Last updated on JANUARY 17, 2023
Applies to:
Oracle Database - Enterprise Edition - Version 9.2.0.1 to 9.2.0.8 [Release 9.2]Information in this document applies to any platform.
Symptoms
NOTE: In the images and/or the document content below, the user information and environment data used represents fictitious
data from the Oracle sample schema(s),Public Documentation delivered with an Oracle database product or other training material.
Any similarity to actual environments, actual persons, living or dead, is purely coincidental and not intended in any manner.
For the purposes of this document, the following fictitious environment is used as an example
to describe the procedure:
Database/Instance Name = RMANDUP
Directory = F:\ORA92\DATABASE, F:\ORA92\ORADATA\RMANDUP and all subdirectories
While duplicating the database using RMAN you get following errors:
printing stored script: Memory Script
{
shutdown clone;
startup clone nomount ;
}
executing script: Memory Script
database dismounted
Oracle instance shut down
connected to auxiliary database (not started)
startup failed: ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file 'F:\ORA92\DATABASE\INITRMANDUP.ORA'
trying to start the Oracle instance without parameter files ...
Oracle instance started
Total System Global Area 97589952 bytes
Fixed Size 453312 bytes
Variable Size 46137344 bytes
Database Buffers 50331648 bytes
Redo Buffers 667648 bytes
sql statement: CREATE CONTROLFILE REUSE SET DATABASE "RMANDUP" RESETLOGS ARCHIVE
LOG
MAXLOGFILES 5
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 1
MAXLOGHISTORY 453
LOGFILE
GROUP 1 ( 'F:\ORA92\ORADATA\RMANDUP\REDO01.LOG', 'F:\ORA92\ORADATA\RMANDUP\REDO01-2.LOG' ) SIZE 1228800 ,
GROUP 2 ( 'F:\ORA92\ORADATA\RMANDUP\REDO02.LOG', 'F:\ORA92\ORADATA\RMANDUP\REDO02-2.LOG' ) SIZE 1228800 ,
GROUP 3 ( 'F:\ORA92\ORADATA\RMANDUP\REDO03.LOG', 'F:\ORA92\ORADATA\RMANDUP\REDO03-2.LOG' ) SIZE 1228800
DATAFILE 'F:\ORA92\ORADATA\RMANDUP\SYSTEM01.DBF'
CHARACTER SET WE8MSWIN1252
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 04/17/2003 12:24:14
RMAN-06136: ORACLE error from auxiliary database: ORA-01503: CREATE CONTROLFILE failed
ORA-01504: database name 'RMANDUP' does not match parameter db_name 'RMAN'
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |