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.edu or visit the list's Web site at
http://listserv.temple.edu/archives/networker.html where you can
should be sent to stan < at > temple.edu
