Results 1 to 3 of 3

Thread: rman

  1. #1
    Join Date
    Apr 2011
    Posts
    16

    Unanswered: rman

    hey,
    i have one dbt regarding RMAN..im using 10g release 2 Os in linux 5.
    WE have taken the backup of database as well as archive log SO i hav backup of database with me...bt while doing doing duplication of database.. we are getting the following error...whats the reason of this error and how to get rid of that..

    [oracle@station24 ~]$ rman target / auxiliary sys/oracle@dupli cmdfile=/u01/app/dupli_script/dup

    Recovery Manager: Release 10.2.0.1.0 - Production on Wed Mar 16 12:13:33 2011

    Copyright (c) 1982, 2005, Oracle. All rights reserved.

    connected to target database: ORCL (DBID=1266965067)
    connected to auxiliary database: DUPLI (not mounted)

    RMAN> run
    2> {
    3> set newname for datafile 1 to '/u01/app/oracle/oradata/dupli/system01.dbf';
    4> set newname for datafile 2 to '/u01/app/oracle/oradata/dupli/dundotbs01.dbf';
    5> set newname for datafile 3 to '/u01/app/oracle/oradata/dupli/sysaux01.dbf';
    6> set newname for datafile 4 to '/u01/app/oracle/oradata/dupli/dusers01.dbf';
    7> set newname for datafile 5 to '/u01/app/oracle/oradata/dupli/dexample01.dbf';
    8> set newname for tempfile '/u01/app/oracle/oradata/orcl/temp01.dbf' to
    9> '/u01/app/oracle/oradata/dupli/dtemp01.dbf';
    10> allocate auxiliary channel c1 type disk;
    11> allocate auxiliary channel c2 type disk;
    12> allocate auxiliary channel c3 type disk;
    13> allocate auxiliary channel c4 type disk;
    14> duplicate target database to dupli
    15> pfile='/u01/app/oracle/admin/dupli/pfile/init.ora'
    16> nofilenamecheck
    17> logfile
    18> group 1 ('/u01/app/oracle/oradata/dupli/redo1a.log') size 10m reuse,
    19> group 2 ('/u01/app/oracle/oradata/dupli/redo2a.log') size 10m reuse,
    20> group 3 ('/u01/app/oracle/oradata/dupli/redo3a.log') size 10m reuse;
    21> }
    22>
    executing command: SET NEWNAME
    using target database control file instead of recovery catalog

    executing command: SET NEWNAME

    executing command: SET NEWNAME

    executing command: SET NEWNAME

    executing command: SET NEWNAME

    executing command: SET NEWNAME

    allocated channel: c1
    channel c1: sid=155 devtype=DISK

    allocated channel: c2
    channel c2: sid=154 devtype=DISK

    allocated channel: c3
    channel c3: sid=153 devtype=DISK

    allocated channel: c4
    channel c4: sid=152 devtype=DISK

    Starting Duplicate Db at 16-MAR-11

    contents of Memory Script:
    {
    set until scn 955108;
    set newname for datafile 1 to
    "/u01/app/oracle/oradata/dupli/system01.dbf";
    set newname for datafile 2 to
    "/u01/app/oracle/oradata/dupli/dundotbs01.dbf";
    set newname for datafile 3 to
    "/u01/app/oracle/oradata/dupli/sysaux01.dbf";
    set newname for datafile 4 to
    "/u01/app/oracle/oradata/dupli/dusers01.dbf";
    set newname for datafile 5 to
    "/u01/app/oracle/oradata/dupli/dexample01.dbf";
    restore
    check readonly
    clone database
    ;
    }
    executing Memory Script

    executing command: SET until clause

    executing command: SET NEWNAME

    executing command: SET NEWNAME

    executing command: SET NEWNAME

    executing command: SET NEWNAME

    executing command: SET NEWNAME

    Starting restore at 16-MAR-11

    released channel: c1
    released channel: c2
    released channel: c3
    released channel: c4
    RMAN-00571: ================================================== =========
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ================================================== =========
    RMAN-03002: failure of Duplicate Db command at 03/16/2011 12:13:38
    RMAN-03015: error occurred in stored script Memory Script
    RMAN-06026: some targets not found - aborting restore
    RMAN-06023: no backup or copy of datafile 5 found to restore
    RMAN-06023: no backup or copy of datafile 4 found to restore
    RMAN-06023: no backup or copy of datafile 3 found to restore
    RMAN-06023: no backup or copy of datafile 2 found to restore
    RMAN-06023: no backup or copy of datafile 1 found to restore

    Recovery Manager complete.
    [oracle@station24 ~]$ rman target /

    Recovery Manager: Release 10.2.0.1.0 - Production on Wed Mar 16 12:14:00 2011

    Copyright (c) 1982, 2005, Oracle. All rights reserved.

    connected to target database: ORCL (DBID=1266965067)

    RMAN> list backup of database;

    using target database control file instead of recovery catalog

    List of Backup Sets
    ===================

    BS Key Type LV Size Device Type Elapsed Time Completion Time
    ------- ---- -- ---------- ----------- ------------ ---------------
    98 Full 497.19M DISK 00:00:47 16-MAR-11
    BP Key: 100 Status: AVAILABLE Compressed: NO Tag: TAG20110316T120128
    Piece Name: /u01/app/oracle/oradata/orcl/bac/3mm7c3ko_1_1
    List of Datafiles in backup set 98
    File LV Type Ckp SCN Ckp Time Name
    ---- -- ---- ---------- --------- ----
    1 Full 955474 16-MAR-11 /u01/app/oracle/oradata/orcl/system01.dbf
    3 Full 955474 16-MAR-11 /u01/app/oracle/oradata/orcl/sysaux01.dbf

    BS Key Type LV Size Device Type Elapsed Time Completion Time
    ------- ---- -- ---------- ----------- ------------ ---------------
    99 Full 711.48M DISK 00:01:00 16-MAR-11
    BP Key: 101 Status: AVAILABLE Compressed: NO Tag: TAG20110316T120128
    Piece Name: /u01/app/oracle/oradata/orcl/bac/3lm7c3ko_1_1
    List of Datafiles in backup set 99
    File LV Type Ckp SCN Ckp Time Name
    ---- -- ---- ---------- --------- ----
    2 Full 955473 16-MAR-11 /u01/app/oracle/oradata/orcl/undotbs01.dbf
    4 Full 955473 16-MAR-11 /u01/app/oracle/oradata/orcl/users01.dbf
    5 Full 955473 16-MAR-11 /u01/app/oracle/oradata/orcl/example01.dbf

    BS Key Type LV Size Device Type Elapsed Time Completion Time
    ------- ---- -- ---------- ----------- ------------ ---------------
    102 Full 497.19M DISK 00:00:37 16-MAR-11
    BP Key: 104 Status: AVAILABLE Compressed: NO Tag: TAG20110316T120523
    Piece Name: /u01/app/oracle/oradata/orcl/bac/3sm7c3s4_1_1
    List of Datafiles in backup set 102
    File LV Type Ckp SCN Ckp Time Name
    ---- -- ---- ---------- --------- ----
    1 Full 955631 16-MAR-11 /u01/app/oracle/oradata/orcl/system01.dbf
    3 Full 955631 16-MAR-11 /u01/app/oracle/oradata/orcl/sysaux01.dbf

    BS Key Type LV Size Device Type Elapsed Time Completion Time
    ------- ---- -- ---------- ----------- ------------ ---------------
    103 Full 711.48M DISK 00:00:55 16-MAR-11
    BP Key: 105 Status: AVAILABLE Compressed: NO Tag: TAG20110316T120523
    Piece Name: /u01/app/oracle/oradata/orcl/bac/3rm7c3s4_1_1
    List of Datafiles in backup set 103
    File LV Type Ckp SCN Ckp Time Name
    ---- -- ---- ---------- --------- ----
    2 Full 955630 16-MAR-11 /u01/app/oracle/oradata/orcl/undotbs01.dbf
    4 Full 955630 16-MAR-11 /u01/app/oracle/oradata/orcl/users01.dbf
    5 Full 955630 16-MAR-11 /u01/app/oracle/oradata/orcl/example01.dbf

    RMAN>

  2. #2
    Join Date
    Jun 2004
    Posts
    796
    Provided Answers: 1
    I haven't tried this myself, but other users have had the same issue, and this seemed to work:

    shutdown abort target database
    startup target database
    rerun duplicate comand
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

  3. #3
    Join Date
    Apr 2011
    Posts
    16
    ok...

    but i want to know the reason...coz i hav backup still it is showing me error

Posting Permissions

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