|
-
I am using Rman to duplicate a database. The following script is created according to Oracle DOC. However, it does not work and create a lot of errors. Can somebody help?
run {
allocate auxiliary channel dupdb1 type disk;
allocate auxiliary channel dupdb2 type disk;
allocate auxiliary channel dupdb3 type disk;
allocate auxiliary channel dupdb4 type disk;
set newname for datafile 1 to '/u02/oradata/onyx/tyttem01.dbf';
set newname for datafile 2 to '/u02/oradata/onyx/toolt01.dbf';
set newname for datafile 3 to '/u02/oradata/onyx/rbt01.dbf';
set newname for datafile 4 to '/u02/oradata/onyx/temp01.dbf';
set newname for datafile 5 to '/u02/oradata/onyx/utert01.dbf';
set newname for datafile 6 to '/u02/oradata/onyx/indx01.dbf';
set newname for datafile 7 to '/u05/oradata/onyx/aenetit_dxtx_01_p01.dbf';
set newname for datafile 8 to '/u05/oradata/onyx/aenetit_index_01_p01.dbf';
set newname for datafile 9 to '/u05/oradata/onyx/internet_dxtx_01_p01.dbf';
set newname for datafile 10 to '/u05/oradata/onyx/internet_index_01_p01.dbf';
set newname for datafile 11 to '/u05/oradata/onyx/keb_loxd_dxtx_01_p01.dbf';
set newname for datafile 12 to '/u05/oradata/onyx/keb_loxd_index_01_p01.dbf';
set newname for datafile 13 to '/u01/oradata/onyx/fiji_dxtx_01_p01.dbf';
set newname for datafile 14 to '/u01/oradata/onyx/fiji_index_01_p01.dbf';
set newname for datafile 15 to '/u01/oradata/onyx/chxd_dxtx_01_p01.dbf';
set newname for datafile 16 to '/u01/oradata/onyx/chxd_index_01_p01.dbf';
set newname for datafile 17 to '/u01/oradata/onyx/jxzz_index_01_p01.dbf';
set newname for datafile 18 to '/u05/oradata/onyx/xdemco_dxtx_01_p01.dbf';
set newname for datafile 19 to '/u05/oradata/onyx/xvnet_dxtx_01_p01.dbf';
set newname for datafile 20 to '/u05/oradata/onyx/xvnet_dxtx_01_p02.dbf';
set newname for datafile 21 to '/u05/oradata/onyx/xvnet_index_01_p01.dbf';
set newname for datafile 22 to '/u05/oradata/onyx/xrrok_dxtx_01_p01.dbf';
set newname for datafile 23 to '/u05/oradata/onyx/xrrok_index_01_p01.dbf';
set newname for datafile 24 to '/u01/oradata/onyx/xtix_dxtx_01_p01.dbf';
set newname for datafile 25 to '/u01/oradata/onyx/xtix_dxtx_01_p02.dbf';
set newname for datafile 26 to '/u01/oradata/onyx/xtix_dxtx_01_p03.dbf';
set newname for datafile 27 to '/u01/oradata/onyx/xtix_dxtx_01_p04.dbf';
set newname for datafile 28 to '/u01/oradata/onyx/xtix_dxtx_01_p05.dbf';
set newname for datafile 29 to '/u01/oradata/onyx/xtix_dxtx_01_p06.dbf';
set newname for datafile 30 to '/u01/oradata/onyx/xtix_dxtx_01_p07.dbf';
set newname for datafile 31 to '/u01/oradata/onyx/xtix_dxtx_01_p08.dbf';
set newname for datafile 32 to '/u01/oradata/onyx/xtix_index_01_p01.dbf';
set newname for datafile 33 to '/u01/oradata/onyx/xtix_index_01_p02.dbf';
set newname for datafile 34 to '/u01/oradata/onyx/xtix_dxtx_03_p01.dbf';
set newname for datafile 35 to '/u01/oradata/onyx/xtix_index_03_p01.dbf';
set newname for datafile 36 to '/u01/oradata/onyx/tcxle_dxtx_01_p01.dbf';
set newname for datafile 37 to '/u01/oradata/onyx/mxcroloxd_dxtx_01_p01.dbf';
set newname for datafile 38 to '/u01/oradata/onyx/rmxn_dxtx_01_p01.dbf';
set newname for datafile 39 to '/u01/oradata/onyx/clexrquett_dxtx_01.dbf';
set newname for datafile 40 to '/u01/oradata/onyx/clexrquett_dxtx_02.dbf';
set newname for datafile 41 to '/u01/oradata/onyx/jxzz_dxtx_01_p01.dbf';
set newname for datafile 42 to '/u01/oradata/onyx/xtix_dxtx_02_p01.dbf';
set newname for datafile 43 to '/u01/oradata/onyx/xtix_index_02_p01.dbf';
set newname for datafile 44 to '/u05/oradata/onyx/vice_dxtx_01_p01.dbf';
set newname for datafile 46 to '/u05/oradata/onyx/peru_dxtx_01_p01.dbf';
set newname for datafile 47 to '/u01/oradata/onyx/peru_index_01_p01.dbf';
set newname for datafile 48 to '/u05/oradata/onyx/xtonce_dxtx_p01.dbf';
set newname for datafile 49 to '/u05/oradata/onyx/xtonce_index_p01.dbf';
set newname for datafile 50 to '/u05/oradata/onyx/tcxledev_dxtx_p01.dbf';
set newname for datafile 51 to '/u05/oradata/onyx/tcxledemo_dxtx_p01.dbf';
set newname for datafile 52 to '/u05/oradata/onyx/fiji_dxtx_02_p01.dbf';
set newname for datafile 53 to '/u05/oradata/onyx/fiji_index_02_p01.dbf';
set newname for datafile 54 to '/u05/oradata/onyx/bo_dxtx_p01.dbf';
set newname for datafile 55 to '/u05/oradata/onyx/xdemco_index_01_p01.dbf';
set newname for datafile 56 to '/u05/oradata/onyx/tolectron2_dxtx_01_p01.dbf';
set newname for datafile 57 to '/u05/oradata/onyx/tolectron2_index_01_p01.dbf';
duplicate target database to onyx logfile
group 1 ('/redo1/oradata/onyx/redo01.log',
'/redo2/oradata/onyx/redo01.log') size 8388608 ,
group 2 ('/redo1/oradata/onyx/redo02.log',
'/redo2/oradata/onyx/redo02.log') size 8388608 ,
group 3 ('/redo1/oradata/onyx/redo03.log',
'/redo2/oradata/onyx/redo03.log') size 8388608 ,
group 4 ('/redo1/oradata/onyx/redo04.log',
'/redo2/oradata/onyx/redo04.log') size 8388608 ,
group 5 ('/redo1/oradata/onyx/redo05.log',
'/redo2/oradata/onyx/redo05.log') size 8388608 ,
group 6 ('/redo1/oradata/onyx/redo06.log',
'/redo2/oradata/onyx/redo06.log') size 8388608 ,
group 7 ('/redo1/oradata/onyx/redo07.log',
'/redo2/oradata/onyx/redo07.log') size 8388608 ,
group 8 ('/redo1/oradata/onyx/redo08.log',
'/redo2/oradata/onyx/redo08.log') size 8388608 ,
group 9 ('/redo1/oradata/onyx/redo09.log',
'/redo2/oradata/onyx/redo09.log') size 8388608 ;
}
errors:
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01005: syntax error: found "newname": expecting one of: "auxname, clonename, dbid, echo, snapshot"
RMAN-01007: at line 1 column 6 file: standard input
RMAN>
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01005: syntax error: found "newname": expecting one of: "auxname, clonename, dbid, echo, snapshot"
RMAN-01007: at line 1 column 6 file: standard input
RMAN>
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01005: syntax error: found "newname": expecting one of: "auxname, clonename, dbid, echo, snapshot"
RMAN-01007: at line 1 column 6 file: standard input
RMAN>
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01005: syntax error: found "newname": expecting one of: "auxname, clonename, dbid, echo, snapshot"
RMAN-01007: at line 1 column 6 file: standard input
RMAN>
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01005: syntax error: found "newname": expecting one of: "auxname, clonename, dbid, echo, snapshot"
RMAN-01007: at line 1 column 6 file: standard input
RMAN>
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01005: syntax error: found "newname": expecting one of: "auxname, clonename, dbid, echo, snapshot"
RMAN-01007: at line 1 column 6 file: standard input
RMAN>
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01005: syntax error: found "newname": expecting one of: "auxname, clonename, dbid, echo, snapshot"
RMAN-01007: at line 1 column 6 file: standard input
RMAN>
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01005: syntax error: found "newname": expecting one of: "auxname, clonename, dbid, echo, snapshot"
RMAN-01007: at line 1 column 6 file: standard input
RMAN>
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01005: syntax error: found "newname": expecting one of: "auxname, clonename, dbid, echo, snapshot"
RMAN-01007: at line 1 column 6 file: standard input
RMAN>
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01005: syntax error: found "newname": expecting one of: "auxname, clonename, dbid, echo, snapshot"
RMAN-01007: at line 1 column 6 file: standard input
RMAN>
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01005: syntax error: found "newname": expecting one of: "auxname, clonename, dbid, echo, snapshot"
RMAN-01007: at line 1 column 6 file: standard input
RMAN>
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01005: syntax error: found "newname": expecting one of: "auxname, clonename, dbid, echo, snapshot"
RMAN-01007: at line 1 column 6 file: standard input
RMAN>
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01005: syntax error: found "newname": expecting one of: "auxname, clonename, dbid, echo, snapshot"
RMAN-01007: at line 1 column 6 file: standard input
RMAN>
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01005: syntax error: found "newname": expecting one of: "auxname, clonename, dbid, echo, snapshot"
RMAN-01007: at line 1 column 6 file: standard input
RMAN>
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01005: syntax error: found "newname": expecting one of: "auxname, clonename, dbid, echo, snapshot"
RMAN-01007: at line 1 column 6 file: standard input
RMAN>
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01005: syntax error: found "newname": expecting one of: "auxname, clonename, dbid, echo, snapshot"
RMAN-01007: at line 1 column 6 file: standard input
RMAN>
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01005: syntax error: found "newname": expecting one of: "auxname, clonename, dbid, echo, snapshot"
RMAN-01007: at line 1 column 6 file: standard input
RMAN>
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01005: syntax error: found "newname": expecting one of: "auxname, clonename, dbid, echo, snapshot"
RMAN-01007: at line 1 column 6 file: standard input
RMAN>
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01005: syntax error: found "newname": expecting one of: "auxname, clonename, dbid, echo, snapshot"
RMAN-01007: at line 1 column 6 file: standard input
-
Check this link and make sure that you have made the appropriate changes on to your instance.
http://technet.oracle.com/doc/oracle...pdb.htm#442304
Hope you would have had a chance to go through this, if not take a look 
Good luck,
Sam
Thanx
Sam
Life is a journey, not a destination!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote