有个表数据被删除了,我用CV恢复表,自动生成一段脚本,可运行的时候报错
..................
set newname for datafile296 to
"/sata1t/stage/21175/a_txn_data94.dbf";
set newname for datafile301 to
"/sata1t/stage/21175/a_txn_data95.dbf";
set newname for datafile307 to
"/sata1t/stage/21175/a_txn_data96.dbf";
restore
check readonly
clone database
skip tablespaceS_NQ_INSTANCE,
SYSAEMX,
SYSAEMD,
REPORT,
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00601: fatal error in recovery manager
RMAN-03012: fatal error during compilation of command
RMAN-03028: fatal error code for command Duplicate Db : 600
RMAN-00600: internal error, arguments [8049] [] [] [] []
RMAN-01009: syntax error: found "report": expecting one of: "double-quoted-string, identifier, single-quoted-string"
RMAN-01007: at line 293 column 2 file: Memory Script
]
脚本如下:
******DATA RESTORE SCRIPT******
run {
allocate auxiliary channel ch1 type 'sbt_tape'
PARMS="SBT_LIBRARY=/opt/simpana/Base64/libobk.so,BLKSIZE=262144,ENV=(CV_mmsApiVsn=2,CV_channelPar=ch1)"
TRACE 0;
set newname for datafile '/data/PROD/ora/proddata/a_txn_data36.dbf' to '/sata1t/stage/21172/a_txn_data36.dbf';
set newname for datafile '/data/PROD/ora/proddata/a_txn_data34.dbf' to '/sata1t/stage/21172/a_txn_data34.dbf';
set newname for datafile '/data/PROD/ora/proddata/a_txn_data35.dbf' to '/sata1t/stage/21172/a_txn_data35.dbf';
set newname for datafile '/data/PROD/ora/proddata/a_txn_data37.dbf' to '/sata1t/stage/21172/a_txn_data37.dbf';
set newname for datafile '/data/PROD/ora/proddata/a_txn_data38.dbf' to '/sata1t/stage/21172/a_txn_data38.dbf';
set newname for datafile '/data/PROD/ora/proddata/a_txn_data39.dbf' to '/sata1t/stage/21172/a_txn_data39.dbf';
set newname for datafile '/data/PROD/ora/proddata/a_txn_data40.dbf' to '/sata1t/stage/21172/a_txn_data40.dbf';
set newname for datafile '/data/PROD/ora/proddata/a_txn_data41.dbf' to '/sata1t/stage/21172/a_txn_data41.dbf';
set newname for datafile '/data/PROD/ora/proddata/a_txn_data42.dbf' to '/sata1t/stage/21172/a_txn_data42.dbf';
set newname for datafile '/data/PROD/ora/proddata/a_txn_data43.dbf' to '/sata1t/stage/21172/a_txn_data43.dbf';
set newname for datafile '/data/PROD/ora/proddata/a_txn_data44.dbf' to '/sata1t/stage/21172/a_txn_data44.dbf';
set newname for datafile '/data/PROD/ora/proddata/a_txn_data45.dbf' to '/sata1t/stage/21172/a_txn_data45.dbf';
set newname for datafile '/data/PROD/ora/proddata/a_txn_data01.dbf' to '/sata1t/stage/21172/a_txn_data01.dbf';
set newname for datafile '/data/PROD/ora/proddata/a_txn_data02.dbf' to '/sata1t/stage/21172/a_txn_data02.dbf';
set newname for datafile '/data/PROD/ora/proddata/a_txn_data03.dbf' to '/sata1t/stage/21172/a_txn_data03.dbf';
set newname for datafile '/data/PROD/ora/proddata/a_txn_data04.dbf' to '/sata1t/stage/21172/a_txn_data04.dbf';
set newname for datafile '/data/PROD/ora/proddata/a_txn_data05.dbf' to '/sata1t/stage/21172/a_txn_data05.dbf';
set newname for datafile '/data/PROD/ora/proddata/a_txn_data06.dbf' to '/sata1t/stage/21172/a_txn_data06.dbf';
set newname for datafile '/data/PROD/ora/proddata/a_txn_data07.dbf' to '/sata1t/stage/21172/a_txn_data07.dbf';
set newname for datafile '/data/PROD/ora/proddata/a_txn_data08.dbf' to '/sata1t/stage/21172/a_txn_data08.dbf';
set newname for datafile '/data/PROD/ora/proddata/a_txn_data09.dbf' to '/sata1t/stage/21172/a_txn_data09.dbf';
set newname for datafile '/data/PROD/ora/proddata/a_txn_data10.dbf' to '/sata1t/stage/21172/a_txn_data10.dbf';
set newname for datafile '/data/PROD/ora/proddata/a_txn_data11.dbf' to '/sata1t/stage/21172/a_txn_data11.dbf';
set newname for datafile '/data/PROD/ora/proddata/a_txn_data12.dbf' to '/sata1t/stage/21172/a_txn_data12.dbf';
set newname for datafile '/data/PROD/ora/proddata/a_txn_data13.dbf' to '/sata1t/stage/21172/a_txn_data13.dbf';
set newname for datafile '/data/PROD/ora/proddata/a_txn_data14.dbf' to '/sata1t/stage/21172/a_txn_data14.dbf';
set newname for datafile '/data/PROD/ora/proddata/a_txn_data15.dbf' to '/sata1t/stage/21172/a_txn_data15.dbf';
set newname for datafile '/data/PROD/ora/proddata/a_txn_data16.dbf' to '/sata1t/stage/21172/a_txn_data16.dbf';
set newname for datafile '/data/PROD/ora/proddata/a_txn_data17.dbf' to '/sata1t/stage/21172/a_txn_data17.dbf';
set newname for datafile '/data/PROD/ora/proddata/a_txn_data18.dbf' to '/sata1t/stage/21172/a_txn_data18.dbf';
set newname for datafile '/data/PROD/ora/proddata/a_txn_data19.dbf' to '/sata1t/stage/21172/a_txn_data19.dbf';
set newname for datafile '/data/PROD/ora/proddata/a_txn_data20.dbf' to '/sata1t/stage/21172/a_txn_data20.dbf';
set newname for datafile '/data/PROD/ora/proddata/a_txn_data21.dbf' to '/sata1t/stage/21172/a_txn_data21.dbf';
set newname for datafile '/data/PROD/ora/proddata/a_txn_data22.dbf' to '/sata1t/stage/21172/a_txn_data22.dbf';
set newname for datafile '/data/PROD/ora/proddata/a_txn_data23.dbf' to '/sata1t/stage/21172/a_txn_data23.dbf';
set newname for datafile '/data/PROD/ora/proddata/a_txn_data24.dbf' to '/sata1t/stage/21172/a_txn_data24.dbf';
set newname for datafile '/data/PROD/ora/proddata/a_txn_data25.dbf' to '/sata1t/stage/21172/a_txn_data25.dbf';
set newname for datafile '/data/PROD/ora/proddata/a_txn_data26.dbf' to '/sata1t/stage/21172/a_txn_data26.dbf';
set newname for datafile '/data/PROD/ora/proddata/a_txn_data27.dbf' to '/sata1t/stage/21172/a_txn_data27.dbf';
set newname for datafile '/data/PROD/ora/proddata/a_txn_data28.dbf' to '/sata1t/stage/21172/a_txn_data28.dbf';
set newname for datafile '/data/PROD/ora/proddata/a_txn_data29.dbf' to '/sata1t/stage/21172/a_txn_data29.dbf';
set newname for datafile '/data/PROD/ora/proddata/a_txn_data30.dbf' to '/sata1t/stage/21172/a_txn_data30.dbf';
set newname for datafile '/data/PROD/ora/proddata/a_txn_data31.dbf' to '/sata1t/stage/21172/a_txn_data31.dbf';
set newname for datafile '/data/PROD/ora/proddata/a_txn_data32.dbf' to '/sata1t/stage/21172/a_txn_data32.dbf';
set newname for datafile '/data/PROD/ora/proddata/a_txn_data33.dbf' to '/sata1t/stage/21172/a_txn_data33.dbf';
set newname for datafile '/data/PROD/ora/proddata/a_txn_data46.dbf' to '/sata1t/stage/21172/a_txn_data46.dbf';
set newname for datafile '/data/PROD/ora/proddata/a_txn_data47.dbf' to '/sata1t/stage/21172/a_txn_data47.dbf';
set newname for datafile '/data/PROD/ora/proddata/a_txn_data48.dbf' to '/sata1t/stage/21172/a_txn_data48.dbf';
set newname for datafile '/data/PROD/ora/proddata/a_txn_data49.dbf' to '/sata1t/stage/21172/a_txn_data49.dbf';
set newname for datafile '/data/PROD/ora/proddata/a_txn_data50.dbf' to '/sata1t/stage/21172/a_txn_data50.dbf';
set newname for datafile '/data/PROD/ora/proddata/a_txn_data85.dbf' to '/sata1t/stage/21172/a_txn_data85.dbf';
set newname for datafile '/data/PROD/ora/proddata/a_txn_data86.dbf' to '/sata1t/stage/21172/a_txn_data86.dbf';
set newname for datafile '/data/PROD/ora/proddata/a_txn_data87.dbf' to '/sata1t/stage/21172/a_txn_data87.dbf';
set newname for datafile '/data/PROD/ora/proddata/a_txn_data88.dbf' to '/sata1t/stage/21172/a_txn_data88.dbf';
set newname for datafile '/data/PROD/ora/proddata/a_txn_data89.dbf' to '/sata1t/stage/21172/a_txn_data89.dbf';
set newname for datafile '/data/PROD/ora/proddata/a_txn_data90.dbf' to '/sata1t/stage/21172/a_txn_data90.dbf';
set newname for datafile '/data/PROD/ora/proddata/a_txn_data91.dbf' to '/sata1t/stage/21172/a_txn_data91.dbf';
set newname for datafile '/data/PROD/ora/proddata/a_txn_data92.dbf' to '/sata1t/stage/21172/a_txn_data92.dbf';
set newname for datafile '/data/PROD/ora/proddata/a_txn_data93.dbf' to '/sata1t/stage/21172/a_txn_data93.dbf';
set newname for datafile '/data/PROD/ora/proddata/a_txn_data94.dbf' to '/sata1t/stage/21172/a_txn_data94.dbf';
set newname for datafile '/data/PROD/ora/proddata/a_txn_data95.dbf' to '/sata1t/stage/21172/a_txn_data95.dbf';
set newname for datafile '/data/PROD/ora/proddata/a_txn_data96.dbf' to '/sata1t/stage/21172/a_txn_data96.dbf';
set newname for datafile '/data/PROD/ora/proddata/a_txn_data51.dbf' to '/sata1t/stage/21172/a_txn_data51.dbf';
set newname for datafile '/data/PROD/ora/proddata/a_txn_data52.dbf' to '/sata1t/stage/21172/a_txn_data52.dbf';
set newname for datafile '/data/PROD/ora/proddata/a_txn_data53.dbf' to '/sata1t/stage/21172/a_txn_data53.dbf';
set newname for datafile '/data/PROD/ora/proddata/a_txn_data54.dbf' to '/sata1t/stage/21172/a_txn_data54.dbf';
set newname for datafile '/data/PROD/ora/proddata/a_txn_data55.dbf' to '/sata1t/stage/21172/a_txn_data55.dbf';
set newname for datafile '/data/PROD/ora/proddata/a_txn_data56.dbf' to '/sata1t/stage/21172/a_txn_data56.dbf';
set newname for datafile '/data/PROD/ora/proddata/a_txn_data57.dbf' to '/sata1t/stage/21172/a_txn_data57.dbf';
set newname for datafile '/data/PROD/ora/proddata/a_txn_data58.dbf' to '/sata1t/stage/21172/a_txn_data58.dbf';
set newname for datafile '/data/PROD/ora/proddata/a_txn_data59.dbf' to '/sata1t/stage/21172/a_txn_data59.dbf';
set newname for datafile '/data/PROD/ora/proddata/a_txn_data60.dbf' to '/sata1t/stage/21172/a_txn_data60.dbf';
set newname for datafile '/data/PROD/ora/proddata/a_txn_data61.dbf' to '/sata1t/stage/21172/a_txn_data61.dbf';
set newname for datafile '/data/PROD/ora/proddata/a_txn_data62.dbf' to '/sata1t/stage/21172/a_txn_data62.dbf';
set newname for datafile '/data/PROD/ora/proddata/a_txn_data63.dbf' to '/sata1t/stage/21172/a_txn_data63.dbf';
set newname for datafile '/data/PROD/ora/proddata/a_txn_data64.dbf' to '/sata1t/stage/21172/a_txn_data64.dbf';
set newname for datafile '/data/PROD/ora/proddata/a_txn_data65.dbf' to '/sata1t/stage/21172/a_txn_data65.dbf';
set newname for datafile '/data/PROD/ora/proddata/a_txn_data66.dbf' to '/sata1t/stage/21172/a_txn_data66.dbf';
set newname for datafile '/data/PROD/ora/proddata/a_txn_data67.dbf' to '/sata1t/stage/21172/a_txn_data67.dbf';
set newname for datafile '/data/PROD/ora/proddata/a_txn_data68.dbf' to '/sata1t/stage/21172/a_txn_data68.dbf';
set newname for datafile '/data/PROD/ora/proddata/a_txn_data69.dbf' to '/sata1t/stage/21172/a_txn_data69.dbf';
set newname for datafile '/data/PROD/ora/proddata/a_txn_data70.dbf' to '/sata1t/stage/21172/a_txn_data70.dbf';
set newname for datafile '/data/PROD/ora/proddata/a_txn_data71.dbf' to '/sata1t/stage/21172/a_txn_data71.dbf';
set newname for datafile '/data/PROD/ora/proddata/a_txn_data72.dbf' to '/sata1t/stage/21172/a_txn_data72.dbf';
set newname for datafile '/data/PROD/ora/proddata/a_txn_data73.dbf' to '/sata1t/stage/21172/a_txn_data73.dbf';
set newname for datafile '/data/PROD/ora/proddata/a_txn_data74.dbf' to '/sata1t/stage/21172/a_txn_data74.dbf';
set newname for datafile '/data/PROD/ora/proddata/a_txn_data75.dbf' to '/sata1t/stage/21172/a_txn_data75.dbf';
set newname for datafile '/data/PROD/ora/proddata/a_txn_data76.dbf' to '/sata1t/stage/21172/a_txn_data76.dbf';
set newname for datafile '/data/PROD/ora/proddata/a_txn_data77.dbf' to '/sata1t/stage/21172/a_txn_data77.dbf';
set newname for datafile '/data/PROD/ora/proddata/a_txn_data78.dbf' to '/sata1t/stage/21172/a_txn_data78.dbf';
set newname for datafile '/data/PROD/ora/proddata/a_txn_data79.dbf' to '/sata1t/stage/21172/a_txn_data79.dbf';
set newname for datafile '/data/PROD/ora/proddata/a_txn_data80.dbf' to '/sata1t/stage/21172/a_txn_data80.dbf';
set newname for datafile '/data/PROD/ora/proddata/a_txn_data81.dbf' to '/sata1t/stage/21172/a_txn_data81.dbf';
set newname for datafile '/data/PROD/ora/proddata/a_txn_data82.dbf' to '/sata1t/stage/21172/a_txn_data82.dbf';
set newname for datafile '/data/PROD/ora/proddata/a_txn_data83.dbf' to '/sata1t/stage/21172/a_txn_data83.dbf';
set newname for datafile '/data/PROD/ora/proddata/a_txn_data84.dbf' to '/sata1t/stage/21172/a_txn_data84.dbf';
set newname for datafile '/data/PROD/ora/proddata/cuxd06.dbf' to '/sata1t/stage/21172/cuxd06.dbf';
set newname for datafile '/data/PROD/ora/proddata/cuxd02.dbf' to '/sata1t/stage/21172/cuxd02.dbf';
set newname for datafile '/data/PROD/ora/proddata/cuxd03.dbf' to '/sata1t/stage/21172/cuxd03.dbf';
set newname for datafile '/data/PROD/ora/proddata/cuxd04.dbf' to '/sata1t/stage/21172/cuxd04.dbf';
set newname for datafile '/data/PROD/ora/proddata/cuxd05.dbf' to '/sata1t/stage/21172/cuxd05.dbf';
set newname for datafile '/data/PROD/ora/proddata/cuxd01.dbf' to '/sata1t/stage/21172/cuxd01.dbf';
set newname for datafile '/data/PROD/ora/proddata/cuxd07.dbf' to '/sata1t/stage/21172/cuxd07.dbf';
set newname for datafile '/data/PROD/ora/proddata/cuxd08.dbf' to '/sata1t/stage/21172/cuxd08.dbf';
set newname for datafile '/data/PROD/ora/proddata/cuxd09.dbf' to '/sata1t/stage/21172/cuxd09.dbf';
set newname for datafile '/data/PROD/ora/proddata/cuxd18.dbf' to '/sata1t/stage/21172/cuxd18.dbf';
set newname for datafile '/data/PROD/ora/proddata/cuxd17.dbf' to '/sata1t/stage/21172/cuxd17.dbf';
set newname for datafile '/data/PROD/ora/proddata/cuxd16.dbf' to '/sata1t/stage/21172/cuxd16.dbf';
set newname for datafile '/data/PROD/ora/proddata/cuxd15.dbf' to '/sata1t/stage/21172/cuxd15.dbf';
set newname for datafile '/data/PROD/ora/proddata/cuxd14.dbf' to '/sata1t/stage/21172/cuxd14.dbf';
set newname for datafile '/data/PROD/ora/proddata/cuxd13.dbf' to '/sata1t/stage/21172/cuxd13.dbf';
set newname for datafile '/data/PROD/ora/proddata/cuxd10.dbf' to '/sata1t/stage/21172/cuxd10.dbf';
set newname for datafile '/data/PROD/ora/proddata/cuxd11.dbf' to '/sata1t/stage/21172/cuxd11.dbf';
set newname for datafile '/data/PROD/ora/proddata/cuxd12.dbf' to '/sata1t/stage/21172/cuxd12.dbf';
set newname for datafile '/data/PROD/ora/proddata/cuxx04.dbf' to '/sata1t/stage/21172/cuxx04.dbf';
set newname for datafile '/data/PROD/ora/proddata/cuxx03.dbf' to '/sata1t/stage/21172/cuxx03.dbf';
set newname for datafile '/data/PROD/ora/proddata/cuxx02.dbf' to '/sata1t/stage/21172/cuxx02.dbf';
set newname for datafile '/data/PROD/ora/proddata/cuxx01.dbf' to '/sata1t/stage/21172/cuxx01.dbf';
set newname for datafile '/data/PROD/ora/proddata/cuxx05.dbf' to '/sata1t/stage/21172/cuxx05.dbf';
set newname for datafile '/data/PROD/ora/proddata/cuxx06.dbf' to '/sata1t/stage/21172/cuxx06.dbf';
set newname for datafile '/data/PROD/ora/proddata/und004dbf' to '/sata1t/stage/21172/und004dbf';
set newname for datafile '/data/PROD/ora/proddata/undo01.dbf' to '/sata1t/stage/21172/undo01.dbf';
set newname for datafile '/data/PROD/ora/proddata/undo02.dbf' to '/sata1t/stage/21172/undo02.dbf';
set newname for datafile '/data/PROD/ora/proddata/undo03.dbf' to '/sata1t/stage/21172/undo03.dbf';
set newname for datafile '/data/PROD/ora/proddata/undo09.dbf' to '/sata1t/stage/21172/undo09.dbf';
set newname for datafile '/data/PROD/ora/proddata/undo06.dbf' to '/sata1t/stage/21172/undo06.dbf';
set newname for datafile '/data/PROD/ora/proddata/undo07.dbf' to '/sata1t/stage/21172/undo07.dbf';
set newname for datafile '/data/PROD/ora/proddata/undo08.dbf' to '/sata1t/stage/21172/undo08.dbf';
set newname for datafile '/data/PROD/ora/proddata/undo05.dbf' to '/sata1t/stage/21172/undo05.dbf';
set newname for datafile '/data/PROD/ora/proddata/sysaux01.dbf' to '/sata1t/stage/21172/sysaux01.dbf';
set newname for datafile '/data/PROD/ora/proddata/sysaux02.dbf' to '/sata1t/stage/21172/sysaux02.dbf';
set newname for datafile '/data/PROD/ora/proddata/system01.dbf' to '/sata1t/stage/21172/system01.dbf';
set newname for datafile '/data/PROD/ora/proddata/system04.dbf' to '/sata1t/stage/21172/system04.dbf';
set newname for datafile '/data/PROD/ora/proddata/system10.dbf' to '/sata1t/stage/21172/system10.dbf';
set newname for datafile '/data/PROD/ora/proddata/system05.dbf' to '/sata1t/stage/21172/system05.dbf';
set newname for datafile '/data/PROD/ora/proddata/system02.dbf' to '/sata1t/stage/21172/system02.dbf';
set newname for datafile '/data/PROD/ora/proddata/system06.dbf' to '/sata1t/stage/21172/system06.dbf';
set newname for datafile '/data/PROD/ora/proddata/system09.dbf' to '/sata1t/stage/21172/system09.dbf';
set newname for datafile '/data/PROD/ora/proddata/system07.dbf' to '/sata1t/stage/21172/system07.dbf';
set newname for datafile '/data/PROD/ora/proddata/system03.dbf' to '/sata1t/stage/21172/system03.dbf';
set newname for datafile '/data/PROD/ora/proddata/system08.dbf' to '/sata1t/stage/21172/system08.dbf';
set newname for datafile '/data/PROD/ora/proddata/system11.dbf' to '/sata1t/stage/21172/system11.dbf';
set until time = "TO_DATE('08/31/2014 00:25:23','MM/DD/YYYY HH24:MI:SS')" ;
duplicate target database to 'tsrst172'
SKIP TABLESPACE 'ACSTD', 'ACSTX', 'AFIND', 'APPS_TS_ARCHIVE', 'APPS_TS_INTERFACE', 'APPS_TS_MEDIA', 'APPS_TS_NOLOGGING', 'APPS_TS_QUEUES', 'APPS_TS_SEED', 'APPS_TS_SUMMARY', 'APPS_TS_TX_IDX', 'BOSUN', 'BSCC', 'CTXD', 'DISCOVERER', 'INTF_IMP', 'ODM', 'OLAP', 'OWAPUB', 'PDM', 'PERFSTAT', 'PORTAL', 'REPORT', 'SYSAEMD', 'SYSAEMX', 'S_NQ_INSTANCE', 'MOSSD', 'MOSSX', 'EC_BSD', 'EC_BSX', 'BSCUXD', 'BSCUXX', 'AFINX'
PFILE= '/sata1t/stage/tsrst172init.ora'
LOGFILE
'/sata1t/stage/21172/redo01.log' SIZE 4096K reuse,
'/sata1t/stage/21172/redo02.log' SIZE 4096K reuse,
'/sata1t/stage/21172/redo03.log' SIZE 4096K reuse;
}
exit;
到底为什么啊
|
