Networker

[Networker] question "duplication"

2005-04-07 20:20:47
Subject: [Networker] question "duplication"
From: darings <snoop AT BECSOLUTIONS DOT COM>
To: NETWORKER AT LISTSERV.TEMPLE DOT EDU
Date: Thu, 7 Apr 2005 20:13:44 -0400
I backuped up data in Disk from RMAN
I can show list of backup by RMAN's command
During duplication database , it can't process good..
why ?



RMAN> run {
2> allocate auxiliary channel c1  type disk;
3> duplicate target database to protosdup;
4> release channel c1;
5>
6> }

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

Starting Duplicate Db at 08-APR-05

printing stored script: Memory Script
{
   set until scn  245617;
   set newname for datafile  1 to
 "/testoracle/oracle/oradata/protosdup/system01.dbf";
   set newname for datafile  2 to
 "/testoracle/oracle/oradata/protosdup/undotbs01.dbf";
   set newname for datafile  3 to
 "/testoracle/oracle/oradata/protosdup/cwmlite01.dbf";
   set newname for datafile  4 to
 "/testoracle/oracle/oradata/protosdup/drsys01.dbf";
   set newname for datafile  5 to
 "/testoracle/oracle/oradata/protosdup/example01.dbf";
   set newname for datafile  6 to
 "/testoracle/oracle/oradata/protosdup/indx01.dbf";
   set newname for datafile  7 to
 "/testoracle/oracle/oradata/protosdup/odm01.dbf";
   set newname for datafile  8 to
 "/testoracle/oracle/oradata/protosdup/tools01.dbf";
   set newname for datafile  9 to
 "/testoracle/oracle/oradata/protosdup/users01.dbf";
   set newname for datafile  10 to
 "/testoracle/oracle/oradata/protosdup/xdb01.dbf";
   restore
   check readonly
   clone database
   ;
}
executing script: 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

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting restore at 08-APR-05

released channel: c1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 04/08/2005 09:11:36
RMAN-03015: error occurred in stored script Memory Script
RMAN-06026: some targets not found - aborting restore
RMAN-06100: no channel to restore a backup or copy of datafile 10
RMAN-06100: no channel to restore a backup or copy of datafile 9
RMAN-06100: no channel to restore a backup or copy of datafile 8
RMAN-06100: no channel to restore a backup or copy of datafile 7
RMAN-06100: no channel to restore a backup or copy of datafile 6
RMAN-06100: no channel to restore a backup or copy of datafile 5
RMAN-06100: no channel to restore a backup or copy of datafile 4
RMAN-06100: no channel to restore a backup or copy of datafile 3
RMAN-06100: no channel to restore a backup or copy of datafile 2
RMAN-06100: no channel to restore a backup or copy of datafile 1



rman> list backup

137     Full    493M       DISK        00:00:10     08-APR-05
        BP Key: 138   Status: AVAILABLE   Tag: TAG20050408T004717
        Piece Name: /testoracle/oracle/dbs/0dghabol_1_1
  List of Datafiles in backup set 137
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1       Full 286995     08-APR-
05 /testoracle/oracle/oradata/protos/system01.dbf
  2       Full 286995     08-APR-
05 /testoracle/oracle/oradata/protos/undotbs01.dbf
  3       Full 286995     08-APR-
05 /testoracle/oracle/oradata/protos/cwmlite01.dbf
  4       Full 286995     08-APR-
05 /testoracle/oracle/oradata/protos/drsys01.dbf
  5       Full 286995     08-APR-
05 /testoracle/oracle/oradata/protos/example01.dbf
  6       Full 286995     08-APR-
05 /testoracle/oracle/oradata/protos/indx01.dbf
  7       Full 286995     08-APR-
05 /testoracle/oracle/oradata/protos/odm01.dbf
  8       Full 286995     08-APR-
05 /testoracle/oracle/oradata/protos/tools01.dbf
  9       Full 286995     08-APR-
05 /testoracle/oracle/oradata/protos/users01.dbf
  10      Full 286995     08-APR-
05 /testoracle/oracle/oradata/protos/xdb01.dbf
  11      Full 286995     08-APR-
05 /testoracle/oracle/oradata/protos/snoop1.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
151     Full    1M         DISK        00:00:00     08-APR-05
        BP Key: 152   Status: AVAILABLE   Tag:
        Piece Name: /testoracle/oracle/dbs/c-2648007149-20050408-01
  Controlfile Included: Ckp SCN: 287000       Ckp time: 08-APR-05

--
Note: To sign off this list, send a "signoff networker" command via email
to listserv AT listserv.temple DOT edu or visit the list's Web site at
http://listserv.temple.edu/archives/networker.html where you can
also view and post messages to the list. Questions regarding this list
should be sent to stan AT temple DOT edu
=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=

<Prev in Thread] Current Thread [Next in Thread>
  • [Networker] question "duplication", darings <=