DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Help! RMAN Duplicate db Error

Hybrid View

  1. #1
    Join Date
    Jan 2005
    Posts
    15

    Help! RMAN Duplicate db Error

    I've registered both the target and aux db' s with rman, both have the same SID. I tried to duplicate the target to the aux db and got a strange error. Can someone please help?

    RMAN> RUN{
    2> ALLOCATE AUXILIARY CHANNEL CH1 TYPE DISK;
    3> ALLOCATE AUXILIARY CHANNEL CH2 TYPE DISK;
    4> DUPLICATE TARGET DATABASE TO ICRMDB2
    5> NOFILENAMECHECK;
    6> }

    RMAN-03022: compiling command: allocate
    RMAN-03023: executing command: allocate
    RMAN-08030: allocated channel: CH1
    RMAN-08500: channel CH1: sid=15 devtype=DISK

    RMAN-03022: compiling command: allocate
    RMAN-03023: executing command: allocate
    RMAN-08030: allocated channel: CH2
    RMAN-08500: channel CH2: sid=16 devtype=DISK

    RMAN-03022: compiling command: Duplicate Db

    RMAN-03027: printing stored script: Memory Script
    {
    set until scn 1174592;
    set newname for datafile 1 to
    "D:\ORACLE\ORADATA\ICRMDB2\SYSTEM01.DBF";
    set newname for datafile 2 to
    "D:\ORACLE\ORADATA\ICRMDB2\RBS01.DBF";
    set newname for datafile 3 to
    "D:\ORACLE\ORADATA\ICRMDB2\USERS01.DBF";
    set newname for datafile 4 to

    ......

    RMAN-08023: channel CH1: restored backup piece 1
    RMAN-08511: piece handle=E:\ORACLE\ORABKP\ICRMDB2_56_557855581 tag=null params=N
    ULL
    RMAN-08024: channel CH1: restore complete
    RMAN-08016: channel CH1: starting datafile backupset restore
    RMAN-08502: set_count=58 set_stamp=557855581 creation_time=09-MAY-05
    RMAN-08089: channel CH1: specifying datafile(s) to restore from backup set
    RMAN-08523: restoring datafile 00003 to D:\ORACLE\ORADATA\ICRMDB2\USERS01.DBF
    RMAN-08523: restoring datafile 00004 to D:\ORACLE\ORADATA\ICRMDB2\TEMP01.DBF
    RMAN-08523: restoring datafile 00005 to D:\ORACLE\ORADATA\ICRMDB2\TOOLS01.DBF
    RMAN-08523: restoring datafile 00006 to D:\ORACLE\ORADATA\ICRMDB2\INDX01.DBF
    RMAN-08523: restoring datafile 00009 to D:\ORACLE\ORADATA\ICRMDB2\WEBTOP_DATA.OR
    A
    RMAN-08523: restoring datafile 00013 to D:\ORACLE\ORADATA\ICRMDB2\SDR_DATA.ORA
    RMAN-08023: channel CH1: restored backup piece 1
    RMAN-08511: piece handle=E:\ORACLE\ORABKP\ICRMDB2_58_557855581 tag=null params=N
    ULL
    RMAN-08024: channel CH1: restore complete
    RMAN-08023: channel CH2: restored backup piece 1
    RMAN-08511: piece handle=E:\ORACLE\ORABKP\ICRMDB2_57_557855581 tag=null params=N
    ULL

    RMAN-08024: channel CH2: restore complete
    RMAN-06162: sql statement: CREATE CONTROLFILE REUSE SET DATABASE "ICRMDB2" RESET
    LOGS ARCHIVELOG
    MAXLOGFILES 32
    MAXLOGMEMBERS 4
    MAXDATAFILES 254
    MAXINSTANCES 1
    MAXLOGHISTORY 3630
    LOGFILE
    GROUP 1 ( 'D:\ORACLE\ORADATA\ICRMDB2\REDO01.LOG' ) SIZE 1048576 REUSE,
    GROUP 2 ( 'E:\ORACLE\ORADATA\ICRMDB2\REDO02.LOG' ) SIZE 1048576 REUSE,
    GROUP 3 ( 'E:\ORACLE\ORADATA\ICRMDB2\REDO03.LOG' ) SIZE 1048576 REUSE
    DATAFILE
    'D:\ORACLE\ORADATA\ICRMDB2\SYSTEM01.DBF'
    CHARACTER SET UTF8


    RMAN-03027: printing stored script: Memory Script
    {
    switch clone datafile all;
    }
    RMAN-03021: executing script: Memory Script

    RMAN-03022: compiling command: switch
    RMAN-03023: executing command: switch

    RMAN-08015: datafile 2 switched to datafile copy
    RMAN-08507: input datafilecopy recid=1 stamp=557945369 filename=D:\ORACLE\ORADAT
    A\ICRMDB2\RBS01.DBF
    RMAN-08015: datafile 3 switched to datafile copy
    RMAN-08507: input datafilecopy recid=2 stamp=557945369 filename=D:\ORACLE\ORADAT
    A\ICRMDB2\USERS01.DBF
    RMAN-08015: datafile 4 switched to datafile copy
    RMAN-08507: input datafilecopy recid=3 stamp=557945369 filename=D:\ORACLE\ORADAT
    A\ICRMDB2\TEMP01.DBF
    RMAN-08015: datafile 5 switched to datafile copy
    RMAN-08507: input datafilecopy recid=4 stamp=557945369 filename=D:\ORACLE\ORADAT
    A\ICRMDB2\TOOLS01.DBF
    RMAN-08015: datafile 6 switched to datafile copy
    RMAN-08507: input datafilecopy recid=5 stamp=557945369 filename=D:\ORACLE\ORADAT
    A\ICRMDB2\INDX01.DBF
    RMAN-08015: datafile 7 switched to datafile copy
    RMAN-08507: input datafilecopy recid=6 stamp=557945369 filename=D:\ORACLE\ORADAT
    A\ICRMDB2\ENT_DATA.ORA
    RMAN-08015: datafile 8 switched to datafile copy
    RMAN-08507: input datafilecopy recid=7 stamp=557945369 filename=D:\ORACLE\ORADAT
    A\ICRMDB2\CLTPRO_DATA.ORA
    RMAN-08015: datafile 9 switched to datafile copy
    RMAN-08507: input datafilecopy recid=8 stamp=557945369 filename=D:\ORACLE\ORADAT
    A\ICRMDB2\WEBTOP_DATA.ORA
    RMAN-08015: datafile 10 switched to datafile copy

    RMAN-08015: datafile 19 switched to datafile copy
    RMAN-08507: input datafilecopy recid=18 stamp=557945369 filename=D:\ORACLE\ORADA
    TA\ICRMDB2\CLTPRO_DBO_TMP.ORA

    RMAN-03027: printing stored script: Memory Script
    {
    set until scn 1174592;
    recover
    clone database
    check readonly
    ;
    }
    RMAN-03021: executing script: Memory Script

    RMAN-03022: compiling command: set

    RMAN-03022: compiling command: recover

    RMAN-03022: compiling command: recover(1)
    RMAN-03026: error recovery releasing channel resources
    RMAN-08031: released channel: CH1
    RMAN-08031: released channel: CH2
    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

    RMAN-03002: failure during compilation of command
    RMAN-03013: command type: Duplicate Db
    RMAN-03015: error occurred in stored script Memory Script
    RMAN-03002: failure during compilation of command
    RMAN-03013: command type: recover
    RMAN-03002: failure during compilation of command
    RMAN-03013: command type: recover(1)
    RMAN-06136: ORACLE error from auxiliary database: ORA-06550: line 1, column 166:

    PLS-00553: character set name is not recognized
    ORA-06550: line 0, column 0:
    PL/SQL: Compilation unit analysis terminated
    RMAN-06031: could not translate database keyword

    RMAN>

  2. #2
    Join Date
    Oct 2002
    Posts
    807
    See Note 137377.1 on metalink.

  3. #3
    Join Date
    Jan 2005
    Posts
    15
    Thanks for the help. However, I am not getting this error....


    RMAN-08024: channel CH2: restore complete
    RMAN-06162: sql statement: CREATE CONTROLFILE REUSE SET DATABASE "ICRMDB2" RESET
    LOGS ARCHIVELOG
    MAXLOGFILES 32

    RMAN-03026: error recovery releasing channel resources
    RMAN-08031: released channel: CH1
    RMAN-08031: released channel: CH2
    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    RMAN-03002: failure during compilation of command
    RMAN-03013: command type: Duplicate Db
    RMAN-06136: ORACLE error from auxiliary database: ORA-01503: CREATE CONTROLFILE
    failed
    ORA-01504: database name 'ICRMDB2' does not match parameter db_name 'OEMREP'
    RMAN-06097: text of failing SQL statement: CREATE CONTROLFILE REUSE SET DATABASE
    "ICRMDB2" RESETLOGS ARCHIVELOG

  4. #4
    Join Date
    Apr 2003
    Posts
    353
    Initparameter value of duplicate database is not changed.?

  5. #5
    Join Date
    Nov 2004
    Location
    Mumbai, India
    Posts
    452
    db_name parameter in the auxiliary instance should have the same value as in your target db with a different(unique) lock_name_space.
    There are three kinds of lies: Lies, damned lies, and benchmarks...

    Unix is user friendly. It's just very particular about who it's friends are.

    Oracle DBA

  6. #6
    Join Date
    Jan 2005
    Posts
    15
    The db_name parameter is the same for both. This is what has me so confused.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width