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

Thread: 8i RMAN Duplicate DB failure!

  1. #1
    Join Date
    Jan 2005
    Posts
    15

    8i RMAN Duplicate DB failure!

    Hi guys, hope someone can assist.

    Two seperate machines, both windows 2000 and from within Windows I can map drives and access the other machine without a problem. My Oracle services run under the same Admin account that is used for the desktop login. When I try to duplicate the database from one system to the next I get the a failure as below. Also, I can login to each instance from sqlplus on the other workstation and a password file has been created.

    Can someone please help me with this?

    RMAN> run {
    2> allocate auxiliary channel aux1 type disk;
    3> duplicate target database to dupdb
    4> nofilenamecheck;
    5> }

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

    RMAN-03022: compiling command: Duplicate Db

    RMAN-03027: printing stored script: Memory Script
    {
    set until scn 86826;
    set newname for datafile 1 to
    "C:\ORACLE\ORADATA\ICRMDB2\SYSTEM01.DBF";
    set newname for datafile 2 to
    "C:\ORACLE\ORADATA\ICRMDB2\RBS01.DBF";
    set newname for datafile 3 to
    "C:\ORACLE\ORADATA\ICRMDB2\USERS01.DBF";
    set newname for datafile 4 to
    "C:\ORACLE\ORADATA\ICRMDB2\TEMP01.DBF";
    set newname for datafile 5 to
    "C:\ORACLE\ORADATA\ICRMDB2\TOOLS01.DBF";
    set newname for datafile 6 to
    "C:\ORACLE\ORADATA\ICRMDB2\INDX01.DBF";
    set newname for datafile 7 to
    "C:\ORACLE\ORADATA\ICRMDB2\SM_DATA.ORA";
    set newname for datafile 8 to
    "C:\ORACLE\ORADATA\ICRMDB2\CHMART_DATA.ORA";
    set newname for datafile 9 to
    "C:\ORACLE\ORADATA\ICRMDB2\CLTPRO_DATA.ORA";
    restore
    check readonly
    clone database
    ;
    sql clone " CREATE CONTROLFILE REUSE SET DATABASE ^"dupdb^" RESETLOGS ARCHIVE
    LOG
    MAXLOGFILES 32
    MAXLOGMEMBERS 2
    MAXDATAFILES 254
    MAXINSTANCES 1
    MAXLOGHISTORY 904
    LOGFILE
    GROUP 1 ( ''C:\ORACLE\ORADATA\ICRMDB2\REDO01.LOG'' ) SIZE 1048576 REUSE,
    GROUP 2 ( ''C:\ORACLE\ORADATA\ICRMDB2\REDO02.LOG'' ) SIZE 1048576 REUSE,
    GROUP 3 ( ''C:\ORACLE\ORADATA\ICRMDB2\REDO03.LOG'' ) SIZE 1048576 REUSE
    DATAFILE
    ''C:\ORACLE\ORADATA\ICRMDB2\SYSTEM01.DBF''
    CHARACTER SET UTF8";
    }
    RMAN-03021: executing script: Memory Script

    RMAN-03022: compiling command: set

    RMAN-03022: compiling command: set

    RMAN-03022: compiling command: set

    RMAN-03022: compiling command: set

    RMAN-03022: compiling command: set

    RMAN-03022: compiling command: set

    RMAN-03022: compiling command: set

    RMAN-03022: compiling command: set

    RMAN-03022: compiling command: set

    RMAN-03022: compiling command: set

    RMAN-03022: compiling command: restore

    RMAN-03022: compiling command: IRESTORE
    RMAN-03023: executing command: IRESTORE
    RMAN-08016: channel aux1: starting datafile backupset restore
    RMAN-08502: set_count=3 set_stamp=553870784 creation_time=25-MAR-05
    RMAN-08089: channel aux1: specifying datafile(s) to restore from backup set
    RMAN-08523: restoring datafile 00001 to C:\ORACLE\ORADATA\ICRMDB2\SYSTEM01.DBF
    RMAN-08523: restoring datafile 00003 to C:\ORACLE\ORADATA\ICRMDB2\USERS01.DBF
    RMAN-08523: restoring datafile 00004 to C:\ORACLE\ORADATA\ICRMDB2\TEMP01.DBF
    RMAN-08523: restoring datafile 00009 to C:\ORACLE\ORADATA\ICRMDB2\CLTPRO_DATA.OR
    A
    RMAN-03026: error recovery releasing channel resources
    RMAN-08031: released channel: aux1
    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    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: restore
    RMAN-03007: retryable error occurred during execution of command: IRESTORE
    RMAN-07004: unhandled exception during command execution on channel aux1
    RMAN-10035: exception raised in RPC: ORA-19505: failed to identify file "C:\ORAC
    LE\ORA81\DATABASE\03GG6PE0_1_1"
    ORA-27041: unable to open file
    OSD-04002: unable to open file
    O/S-Error: (OS 2) The system cannot find the file specified.
    RMAN-10031: ORA-19624 occurred during call to DBMS_BACKUP_RESTORE.RESTOREBACKUPP
    IECE

  2. #2
    Join Date
    Apr 2003
    Posts
    353
    Check for the
    Ora81.. folder availability at the aux area.

    What is the need for mapping instead you can point to the local folders at the auxiliary area with the help of the pfile.

  3. #3
    Join Date
    Jan 2005
    Posts
    15
    Hi Engiri, how do I do this? I mapped a drive on the auxiliary machine back to the target machine and also added the entries below in the init.ora file of the aux machine...

    DB_FILE_NAME_CONVERT=(c:\ORACLE\ORADATA\ICRMDB2,x:\ORACLE\ORADATA\ICRMDB2)
    LOG_FILE_NAME_CONVERT=("C:\ORACLE\ORADATA\ICRMDB2","x:\ORACLE\ORADATA\ICRMDB2")

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