node-)rmantoRAC(迁移)(二)

2014-11-24 11:21:58 · 作者: · 浏览: 1
ting command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME Starting restore at 21-JUN-14 Starting implicit crosscheck backup at 21-JUN-14 allocated channel: ORA_DISK_1 Crosschecked 3 objects Finished implicit crosscheck backup at 21-JUN-14 Starting implicit crosscheck copy at 21-JUN-14 using channel ORA_DISK_1 Finished implicit crosscheck copy at 21-JUN-14 searching for all files in the recovery area cataloging files... cataloging done List of Cataloged Files ======================= File Name: +log_disk/dominic/controlfile/current.257.850853325 File Name: +log_disk/dominic/controlfile/current.256.850853775 using channel ORA_DISK_1 channel ORA_DISK_1: starting datafile backup set restore channel ORA_DISK_1: specifying datafile(s) to restore from backup set channel ORA_DISK_1: restoring datafile 00001 to +DATA_DISK/DOMINIC/datafile/system01.dbf channel ORA_DISK_1: restoring datafile 00002 to +DATA_DISK/DOMINIC/datafile/undotbs01.dbf channel ORA_DISK_1: restoring datafile 00003 to +DATA_DISK/DOMINIC/datafile/users01.dbf channel ORA_DISK_1: restoring datafile 00004 to +DATA_DISK/DOMINIC/datafile/undotbs01.dbf channel ORA_DISK_1: restoring datafile 00005 to +DATA_DISK/DOMINIC/datafile/example01.dbf channel ORA_DISK_1: restoring datafile 00006 to +DATA_DISK/DOMINIC/datafile/dominic_tbs01.dbf channel ORA_DISK_1: reading from backup piece /dba/app/rmanbak/DOMINIC_dbfull_08p9pjgn_20140601.DB channel ORA_DISK_1: ORA-19870: error while restoring backup piece /dba/app/rmanbak/DOMINIC_dbfull_08p9pjgn_20140601.DB ORA-19504: failed to create file "+DATA_DISK/dominic/datafile/undotbs01.dbf" ORA-17502: ksfdcre:4 Failed to create file +DATA_DISK/dominic/datafile/undotbs01.dbf ORA-15005: name "dominic/datafile/undotbs01.dbf" is already used by an existing alias failover to previous backup RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of restore command at 06/21/2014 20:29:11 RMAN-06026: some targets not found - aborting restore RMAN-06023: no backup or copy of datafile 5 found to restore --上次也抱这错,好好思考一下(node asm ->
rman filesys node) 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 --ASM 只需要写磁盘组即可 2、注册备份集 RMAN> catalog start with '/dba/app/rmanbk/';
最后我改写成这样, set newname for datafile 1 to '+DATA_DISK'; 成功了,不报RMAN-6023错, 而且rman 恢复路径也按照前定义好的。
====================成功le 案例============================ [oracle@dominic1 rmanbak]$ rman target / Recovery Manager: Release 11.2.0.4.0 - Production on Sat Jun 21 20:42:11 2014 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. connected to target database: DOMINIC (DBID=1978806569, not open) RMAN> run { 2> set newname for datafile 1 to '+DATA_DISK'; 3> set newname for datafile 2 to '+DATA_DISK'; 4> set newname for datafile 3 to '+DATA_DISK'; 5> set newname for datafile 4 to '+DATA_DISK'; 6> set newname for datafile 5 to '+DATA_DISK'; 7> set newname for datafile 6 to '+DATA_DISK'; 8> restore database; 9> switch datafile all; 10> switch tempfile