通过rman为客户实现linux下oracle11.2.0.4到windows下oracle同版本数据库的异机恢复。

来源：这里教程网时间：2026-03-03 12:51:56 作者：

在恢复的过程中参考了下面链接，非常感谢： https://blog.csdn.net/dsc1245/article/details/53508571 下面是记录了一个恢复的过程。 [root@emrdg ~]# su - oracle [oracle@emrdg ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Tue Jan 8 16:39:12 2019 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options SQL> select status from v$instance; STATUS ------------------------ MOUNTED --================== 首先要在mount下通过rman对数据库做一个全备份： [oracle@emrdg ~]$ rman target / Recovery Manager: Release 11.2.0.4.0 - Production on Tue Jan 8 16:32:39 2019 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. connected to target database: ZLEMR (DBID=88360475, not open) RMAN> run{ 2> allocate channel c1 device type disk; 3> allocate channel c2 device type disk; 4> allocate channel c3 device type disk; 5> allocate channel c4 device type disk; 6> backup as compressed backupset database format '\dbbak\full_%U'; 7> } using target database control file instead of recovery catalog allocated channel: c1 channel c1: SID=762 device type=DISK allocated channel: c2 channel c2: SID=1519 device type=DISK allocated channel: c3 channel c3: SID=2276 device type=DISK allocated channel: c4 channel c4: SID=7 device type=DISK Starting backup at 2019-01-08 16:32:49 channel c1: starting compressed full datafile backup set channel c1: specifying datafile(s) in backup set input datafile file number=00009 name=+DATA/zlemrdg/zldocxml.dbf input datafile file number=00008 name=+DATA/zlemrdg/zldocdataindex.dbf input datafile file number=00005 name=+DATA/zlemrdg/zldocbase.dbf channel c1: starting piece 1 at 2019-01-08 16:32:49 channel c2: starting compressed full datafile backup set channel c2: specifying datafile(s) in backup set input datafile file number=00011 name=+DATA/zlemrdg/zldocxml01.dbf input datafile file number=00012 name=+DATA/zlemrdg/zldocdataindex01.dbf input datafile file number=00006 name=+DATA/zlemrdg/zldocindex.dbf channel c2: starting piece 1 at 2019-01-08 16:32:50 channel c3: starting compressed full datafile backup set channel c3: specifying datafile(s) in backup set input datafile file number=00002 name=+DATA/zlemrdg/sysaux01.dbf input datafile file number=00007 name=+DATA/zlemrdg/zldocdata.dbf input datafile file number=00004 name=+DATA/zlemrdg/users01.dbf channel c3: starting piece 1 at 2019-01-08 16:32:50 channel c4: starting compressed full datafile backup set channel c4: specifying datafile(s) in backup set input datafile file number=00010 name=+DATA/zlemrdg/sysaux02.dbf input datafile file number=00001 name=+DATA/zlemrdg/system01.dbf input datafile file number=00003 name=+DATA/zlemrdg/undotbs01.dbf channel c4: starting piece 1 at 2019-01-08 16:32:50 channel c4: finished piece 1 at 2019-01-08 16:35:25 piece handle=/u01/app/oracle/product/11.2.0.4/dbhome_1/dbs/dbbakfull_77tmqt9i_1_1 tag=TAG20190108T163249 comment=NONE channel c4: backup set complete, elapsed time: 00:02:35 channel c4: starting compressed full datafile backup set channel c4: specifying datafile(s) in backup set including current control file in backup set channel c4: starting piece 1 at 2019-01-08 16:35:28 channel c4: finished piece 1 at 2019-01-08 16:35:29 piece handle=/u01/app/oracle/product/11.2.0.4/dbhome_1/dbs/dbbakfull_78tmqted_1_1 tag=TAG20190108T163249 comment=NONE channel c4: backup set complete, elapsed time: 00:00:01 channel c4: starting compressed full datafile backup set channel c4: specifying datafile(s) in backup set including current SPFILE in backup set channel c4: starting piece 1 at 2019-01-08 16:35:29 channel c4: finished piece 1 at 2019-01-08 16:35:30 piece handle=/u01/app/oracle/product/11.2.0.4/dbhome_1/dbs/dbbakfull_79tmqteh_1_1 tag=TAG20190108T163249 comment=NONE channel c4: backup set complete, elapsed time: 00:00:01 channel c3: finished piece 1 at 2019-01-08 16:37:04 piece handle=/u01/app/oracle/product/11.2.0.4/dbhome_1/dbs/dbbakfull_76tmqt9i_1_1 tag=TAG20190108T163249 comment=NONE channel c3: backup set complete, elapsed time: 00:04:14 channel c2: finished piece 1 at 2019-01-08 16:38:14 piece handle=/u01/app/oracle/product/11.2.0.4/dbhome_1/dbs/dbbakfull_75tmqt9h_1_1 tag=TAG20190108T163249 comment=NONE channel c2: backup set complete, elapsed time: 00:05:24 channel c1: finished piece 1 at 2019-01-08 16:55:44 piece handle=/u01/app/oracle/product/11.2.0.4/dbhome_1/dbs/dbbakfull_74tmqt9h_1_1 tag=TAG20190108T163249 comment=NONE channel c1: backup set complete, elapsed time: 00:22:55 Finished backup at 2019-01-08 16:55:44 released channel: c1 released channel: c2 released channel: c3 released channel: c4 RMAN> RMAN> RMAN> RMAN> RMAN> RMAN> RMAN> backup current controlfile format '/dbbak/control_%U'; Starting backup at 2019-01-08 16:56:43 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=762 device type=DISK channel ORA_DISK_1: starting compressed full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set including current control file in backup set channel ORA_DISK_1: starting piece 1 at 2019-01-08 16:56:44 channel ORA_DISK_1: finished piece 1 at 2019-01-08 16:56:45 piece handle=/dbbak/control_7atmqumb_1_1 tag=TAG20190108T165643 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01 Finished backup at 2019-01-08 16:56:45 RMAN> SQL> col units format a10 SQL> Select sofar,totalwork,units,TIME_REMAINING, ELAPSED_SECONDS from v$session_longops where sofar<>totalwork; SOFAR TOTALWORK UNITS TIME_REMAINING ELAPSED_SECONDS ---------- ---------- ---------- -------------- --------------- 4423032 8528960 Blocks 486 524 1184638 2435456 Blocks 660 625 1145749 0 Blocks 625 2914993 0 Blocks 398 SQL> Select sofar,totalwork,units,TIME_REMAINING, ELAPSED_SECONDS from v$session_longops where sofar<>totalwork; SOFAR TOTALWORK UNITS TIME_REMAINING ELAPSED_SECONDS ---------- ---------- ---------- -------------- --------------- 4423032 8528960 Blocks 486 524 1203326 2435456 Blocks 654 639 1164437 0 Blocks 639 2914993 0 Blocks 398 SQL> Select sofar,totalwork,units,TIME_REMAINING, ELAPSED_SECONDS from v$session_longops where sofar<>totalwork; SOFAR TOTALWORK UNITS TIME_REMAINING ELAPSED_SECONDS ---------- ---------- ---------- -------------- --------------- 4601336 8528960 Blocks 551 645 1228926 2435456 Blocks 643 655 1190037 0 Blocks 655 3093297 0 Blocks 519 SQL> Select sofar,totalwork,units,TIME_REMAINING, ELAPSED_SECONDS from v$session_longops where sofar<>totalwork; SOFAR TOTALWORK UNITS TIME_REMAINING ELAPSED_SECONDS ---------- ---------- ---------- -------------- --------------- 4601336 8528960 Blocks 551 645 1252350 2435456 Blocks 634 671 1213461 0 Blocks 671 3093297 0 Blocks 519 SQL> Select sofar,totalwork,units,TIME_REMAINING, ELAPSED_SECONDS from v$session_longops where sofar<>totalwork; SOFAR TOTALWORK UNITS TIME_REMAINING ELAPSED_SECONDS ---------- ---------- ---------- -------------- --------------- 4601336 8528960 Blocks 551 645 1260798 2435456 Blocks 631 677 1221909 0 Blocks 677 3093297 0 Blocks 519 SQL> Select sofar,totalwork,units,TIME_REMAINING, ELAPSED_SECONDS from v$session_longops where sofar<>totalwork; SOFAR TOTALWORK UNITS TIME_REMAINING ELAPSED_SECONDS ---------- ---------- ---------- -------------- --------------- 4973816 8528960 Blocks 633 885 1714046 2435456 Blocks 407 967 1675120 0 Blocks 967 3465769 0 Blocks 759 SQL> Select sofar,totalwork,units,TIME_REMAINING, ELAPSED_SECONDS from v$session_longops where sofar<>totalwork; SOFAR TOTALWORK UNITS TIME_REMAINING ELAPSED_SECONDS ---------- ---------- ---------- -------------- --------------- 5338872 8528960 Blocks 672 1125 2066046 2435456 Blocks 213 1190 2026076 0 Blocks 1190 3830226 0 Blocks 999 SQL> host [oracle@emrdg ~]$ pwd /home/oracle [oracle@emrdg ~]$ exit exit SQL> Select sofar,totalwork,units,TIME_REMAINING, ELAPSED_SECONDS from v$session_longops where sofar<>totalwork; SOFAR TOTALWORK UNITS TIME_REMAINING ELAPSED_SECONDS ---------- ---------- ---------- -------------- --------------- 5338872 8528960 Blocks 672 1125 2120190 2435456 Blocks 182 1223 2080220 0 Blocks 1223 3830226 0 Blocks 999 SQL> select group#,status,bytes v$log; select group#,status,bytes v$log * ERROR at line 1: ORA-00923: FROM keyword not found where expected SQL> select group#,status,bytes from v$log; GROUP# STATUS BYTES ---------- -------------------------------- ---------- 1 CURRENT 52428800 3 INACTIVE 52428800 2 INACTIVE 52428800 SQL> select member from v$logfile; MEMBER -------------------------------------------------------------------------------- +DATA/zlemrdg/redo03.log +DATA/zlemrdg/redo02.log +DATA/zlemrdg/redo01.log +DATA/zlemrdg/std_redo04.log +DATA/zlemrdg/std_redo05.log +DATA/zlemrdg/std_redo06.log +DATA/zlemrdg/std_redo07.log 7 rows selected. SQL> desc v$logfile; Name Null? Type ----------------------------------------- -------- ---------------------------- GROUP# NUMBER STATUS VARCHAR2(7) TYPE VARCHAR2(7) MEMBER VARCHAR2(513) IS_RECOVERY_DEST_FILE VARCHAR2(3) SQL> col member format a40 SQL> SELECT TYPE,STATUS,MEMBER FROM V$LOGFILE; TYPE STATUS MEMBER -------------- -------------- ---------------------------------------- ONLINE +DATA/zlemrdg/redo03.log ONLINE +DATA/zlemrdg/redo02.log ONLINE +DATA/zlemrdg/redo01.log STANDBY +DATA/zlemrdg/std_redo04.log STANDBY +DATA/zlemrdg/std_redo05.log STANDBY +DATA/zlemrdg/std_redo06.log STANDBY +DATA/zlemrdg/std_redo07.log 7 rows selected. SQL> Select sofar,totalwork,units,TIME_REMAINING, ELAPSED_SECONDS from v$session_longops where sofar<>totalwork; SOFAR TOTALWORK UNITS TIME_REMAINING ELAPSED_SECONDS ---------- ---------- ---------- -------------- --------------- 5542264 8528960 Blocks 671 1245 2343806 2435456 Blocks 53 1363 2303228 0 Blocks 1363 4033140 0 Blocks 1119 SQL> Select sofar,totalwork,units,TIME_REMAINING, ELAPSED_SECONDS from v$session_longops where sofar<>totalwork; no rows selected SQL> HOST [oracle@emrdg ~]$ ls dbbak oradiag_oracle orapwzlemr pfile pfile.ora temp [oracle@emrdg ~]$ cd /dbbak [oracle@emrdg dbbak]$ ls control_7atmqumb_1_1 [oracle@emrdg dbbak]$ exit exit SQL> alter database open; Database altered. SQL> --========================== C:\>rman target / 恢复管理器: Release 11.2.0.4.0 - Production on 星期二 1月 8 17:04:12 2019 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. 已连接到目标数据库: EMRTEST1 (未装载) RMAN> restore controlfile from 2> 'd:/dbbak/control_7atmqumb_1_1'; 启动 restore 于 08-1月 -19 使用目标数据库控制文件替代恢复目录分配的通道: ORA_DISK_1 通道 ORA_DISK_1: SID=10 设备类型=DISK 通道 ORA_DISK_1: 正在还原控制文件通道 ORA_DISK_1: 还原完成, 用时: 00:00:01 输出文件名=D:\ORADATA\EMRTEST1\CONTROL01.CTL 输出文件名=C:\APP\ADMINISTRATOR\FAST_RECOVERY_AREA\EMRTEST1\CONTROL02.CTL 完成 restore 于 08-1月 -19 RMAN> RMAN> exit 恢复管理器完成。 C:\>sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on 星期二 1月 8 17:05:47 2019 Copyright (c) 1982, 2013, Oracle. All rights reserved. 连接到: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> show parameter control_files NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ control_files string D:\ORADATA\EMRTEST1\CONTROL01. CTL, C:\APP\ADMINISTRATOR\FAST _RECOVERY_AREA\EMRTEST1\CONTRO L02.CTL SQL> alter database mount; alter database mount * 第 1 行出现错误: ORA-01103: 控制文件中的数据库名 ''ZLEMR'' 不是 ''EMRTEST1'' SQL> shutdown immediate ORA-01507: 未装载数据库 ORACLE 例程已经关闭。 SQL> --============================= C:\>sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on 星期二 1月 8 17:23:16 2019 Copyright (c) 1982, 2013, Oracle. All rights reserved. 已连接到空闲例程。 SQL> startup nomount ORACLE 例程已经启动。 Total System Global Area 4175568896 bytes Fixed Size 2287832 bytes Variable Size 1140852520 bytes Database Buffers 3019898880 bytes Redo Buffers 12529664 bytes SQL> exit 从 Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options 断开 C:\>rman target / 恢复管理器: Release 11.2.0.4.0 - Production on 星期二 1月 8 17:23:28 2019 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. 已连接到目标数据库: ZLEMR (未装载) RMAN> restore controlfile from 'd:\dbbak\control_7atmqumb_1_1'; 启动 restore 于 08-1月 -19 使用目标数据库控制文件替代恢复目录分配的通道: ORA_DISK_1 通道 ORA_DISK_1: SID=772 设备类型=DISK 通道 ORA_DISK_1: 正在还原控制文件通道 ORA_DISK_1: 还原完成, 用时: 00:00:01 输出文件名=D:\ORADATA\ZLEMR\CONTROL01.CTL 输出文件名=C:\APP\ADMINISTRATOR\FAST_RECOVERY_AREA\ZLEMR\CONTROL02.CTL 完成 restore 于 08-1月 -19 RMAN> alter database mount; 数据库已装载释放的通道: ORA_DISK_1 RMAN> RMAN> crosscheck backup; 启动 implicit crosscheck backup 于 08-1月 -19 分配的通道: ORA_DISK_1 通道 ORA_DISK_1: SID=772 设备类型=DISK 已交叉检验的 62 对象完成 implicit crosscheck backup 于 08-1月 -19 启动 implicit crosscheck copy 于 08-1月 -19 使用通道 ORA_DISK_1 完成 implicit crosscheck copy 于 08-1月 -19 搜索恢复区中的所有文件正在编制文件目录... 没有为文件编制目录使用通道 ORA_DISK_1 交叉校验备份片段: 找到为 'EXPIRED' 备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190101_5ctm9465_1_1.bak RECID=13759 STAMP=996446405 交叉校验备份片段: 找到为 'EXPIRED' 备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190101_5ctm9465_2_1.bak RECID=13760 STAMP=996447567 交叉校验备份片段: 找到为 'EXPIRED' 备份片段句柄=+ARCH/backup/arch_20190101_5htm95mt_1_1.bak RECID=13761 STAMP=996447965 交叉校验备份片段: 找到为 'EXPIRED' 备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190102_5ltmboi6_1_1.bak RECID=13765 STAMP=996532806 交叉校验备份片段: 找到为 'EXPIRED' 备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190102_5mtmbp0n_1_1.bak RECID=13766 STAMP=996533272 交叉校验备份片段: 找到为 'EXPIRED' 备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190102_5ktmboi6_1_1.bak RECID=13768 STAMP=996532806 交叉校验备份片段: 找到为 'EXPIRED' 备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190102_5ktmboi6_2_1.bak RECID=13769 STAMP=996533958 交叉校验备份片段: 找到为 'EXPIRED' 备份片段句柄=+ARCH/backup/arch_20190102_5otmbq2j_1_1.bak RECID=13770 STAMP=996534355 交叉校验备份片段: 找到为 'EXPIRED' 备份片段句柄=+ARCH/backup/arch_20190102_5ptmbq2j_1_1.bak RECID=13771 STAMP=996534355 交叉校验备份片段: 找到为 'EXPIRED' 备份片段句柄=+ARCH/backup/spfile_wyhis_20190102_5qtmbq2r_1_1.ora RECID=13772 STAMP=996534363 交叉校验备份片段: 找到为 'EXPIRED' 备份片段句柄=+ARCH/backup/ctrl_wyhis_20190102_5rtmbq2s_1_1.bak RECID=13773 STAMP=996534365 交叉校验备份片段: 找到为 'EXPIRED' 备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190103_5ttmecu5_1_1.bak RECID=13774 STAMP=996619205 交叉校验备份片段: 找到为 'EXPIRED' 备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190103_5utmedcm_1_1.bak RECID=13775 STAMP=996619671 交叉校验备份片段: 找到为 'EXPIRED' 备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190103_5vtmedco_1_1.bak RECID=13776 STAMP=996619672 交叉校验备份片段: 找到为 'EXPIRED' 备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190103_5stmecu5_1_1.bak RECID=13777 STAMP=996619205 交叉校验备份片段: 找到为 'EXPIRED' 备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190103_5stmecu5_2_1.bak RECID=13778 STAMP=996620358 交叉校验备份片段: 找到为 'EXPIRED' 备份片段句柄=+ARCH/backup/arch_20190103_61tmeeej_1_1.bak RECID=13779 STAMP=996620755 交叉校验备份片段: 找到为 'EXPIRED' 备份片段句柄=+ARCH/backup/arch_20190103_60tmeeej_1_1.bak RECID=13780 STAMP=996620755 交叉校验备份片段: 找到为 'EXPIRED' 备份片段句柄=+ARCH/backup/spfile_wyhis_20190103_62tmeeeq_1_1.ora RECID=13781 STAMP=996620762 交叉校验备份片段: 找到为 'EXPIRED' 备份片段句柄=+ARCH/backup/ctrl_wyhis_20190103_63tmeeer_1_1.bak RECID=13782 STAMP=996620764 交叉校验备份片段: 找到为 'EXPIRED' 备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190104_65tmh1a5_1_1.bak RECID=13783 STAMP=996705605 交叉校验备份片段: 找到为 'EXPIRED' 备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190104_66tmh1om_1_1.bak RECID=13784 STAMP=996706071 交叉校验备份片段: 找到为 'EXPIRED' 备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190104_67tmh1oo_1_1.bak RECID=13785 STAMP=996706072 交叉校验备份片段: 找到为 'EXPIRED' 备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190104_64tmh1a5_1_1.bak RECID=13786 STAMP=996705605 交叉校验备份片段: 找到为 'EXPIRED' 备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190104_64tmh1a5_2_1.bak RECID=13787 STAMP=996706768 交叉校验备份片段: 找到为 'EXPIRED' 备份片段句柄=+ARCH/backup/arch_20190104_68tmh2qu_1_1.bak RECID=13788 STAMP=996707166 交叉校验备份片段: 找到为 'EXPIRED' 备份片段句柄=+ARCH/backup/arch_20190104_69tmh2qu_1_1.bak RECID=13789 STAMP=996707166 交叉校验备份片段: 找到为 'EXPIRED' 备份片段句柄=+ARCH/backup/spfile_wyhis_20190104_6atmh2r5_1_1.ora RECID=13790 STAMP=996707173 交叉校验备份片段: 找到为 'EXPIRED' 备份片段句柄=+ARCH/backup/ctrl_wyhis_20190104_6btmh2r6_1_1.bak RECID=13791 STAMP=996707175 交叉校验备份片段: 找到为 'EXPIRED' 备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190105_6dtmjlm5_1_1.bak RECID=13792 STAMP=996792006 交叉校验备份片段: 找到为 'EXPIRED' 备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190105_6etmjm4n_1_1.bak RECID=13793 STAMP=996792472 交叉校验备份片段: 找到为 'EXPIRED' 备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190105_6ftmjm4p_1_1.bak RECID=13794 STAMP=996792473 交叉校验备份片段: 找到为 'EXPIRED' 备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190105_6ctmjlm5_1_1.bak RECID=13795 STAMP=996792005 交叉校验备份片段: 找到为 'EXPIRED' 备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190105_6ctmjlm5_2_1.bak RECID=13796 STAMP=996793168 交叉校验备份片段: 找到为 'EXPIRED' 备份片段句柄=+ARCH/backup/arch_20190105_6htmjn6s_1_1.bak RECID=13797 STAMP=996793564 交叉校验备份片段: 找到为 'EXPIRED' 备份片段句柄=+ARCH/backup/arch_20190105_6gtmjn6s_1_1.bak RECID=13798 STAMP=996793564 交叉校验备份片段: 找到为 'EXPIRED' 备份片段句柄=+ARCH/backup/spfile_wyhis_20190105_6itmjn74_1_1.ora RECID=13799 STAMP=996793572 交叉校验备份片段: 找到为 'EXPIRED' 备份片段句柄=+ARCH/backup/ctrl_wyhis_20190105_6jtmjn75_1_1.bak RECID=13800 STAMP=996793574 交叉校验备份片段: 找到为 'EXPIRED' 备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190106_6ltmma25_1_1.bak RECID=13801 STAMP=996878406 交叉校验备份片段: 找到为 'EXPIRED' 备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190106_6mtmmagn_1_1.bak RECID=13802 STAMP=996878872 交叉校验备份片段: 找到为 'EXPIRED' 备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190106_6ntmmagp_1_1.bak RECID=13803 STAMP=996878873 交叉校验备份片段: 找到为 'EXPIRED' 备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190106_6ktmma25_1_1.bak RECID=13804 STAMP=996878405 交叉校验备份片段: 找到为 'EXPIRED' 备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190106_6ktmma25_2_1.bak RECID=13805 STAMP=996879568 交叉校验备份片段: 找到为 'EXPIRED' 备份片段句柄=+ARCH/backup/arch_20190106_6ptmmbj8_1_1.bak RECID=13806 STAMP=996879976 交叉校验备份片段: 找到为 'EXPIRED' 备份片段句柄=+ARCH/backup/arch_20190106_6otmmbj8_1_1.bak RECID=13807 STAMP=996879976 交叉校验备份片段: 找到为 'EXPIRED' 备份片段句柄=+ARCH/backup/spfile_wyhis_20190106_6qtmmbjf_1_1.ora RECID=13808 STAMP=996879983 交叉校验备份片段: 找到为 'EXPIRED' 备份片段句柄=+ARCH/backup/ctrl_wyhis_20190106_6rtmmbjg_1_1.bak RECID=13809 STAMP=996879985 交叉校验备份片段: 找到为 'EXPIRED' 备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190107_6ttmoue6_1_1.bak RECID=13810 STAMP=996964806 交叉校验备份片段: 找到为 'EXPIRED' 备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190107_6utmousn_1_1.bak RECID=13811 STAMP=996965272 交叉校验备份片段: 找到为 'EXPIRED' 备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190107_6vtmousp_1_1.bak RECID=13812 STAMP=996965273 交叉校验备份片段: 找到为 'EXPIRED' 备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190107_6stmoue6_1_1.bak RECID=13813 STAMP=996964806 交叉校验备份片段: 找到为 'EXPIRED' 备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190107_6stmoue6_2_1.bak RECID=13814 STAMP=996965959 交叉校验备份片段: 找到为 'EXPIRED' 备份片段句柄=+ARCH/backup/arch_20190107_71tmovuj_1_1.bak RECID=13815 STAMP=996966355 交叉校验备份片段: 找到为 'EXPIRED' 备份片段句柄=+ARCH/backup/arch_20190107_70tmovuj_1_1.bak RECID=13816 STAMP=996966355 交叉校验备份片段: 找到为 'EXPIRED' 备份片段句柄=+ARCH/backup/spfile_wyhis_20190107_72tmovuq_1_1.ora RECID=13817 STAMP=996966362 交叉校验备份片段: 找到为 'EXPIRED' 备份片段句柄=+ARCH/backup/ctrl_wyhis_20190107_73tmovur_1_1.bak RECID=13818 STAMP=996966364 交叉校验备份片段: 找到为 'EXPIRED' 备份片段句柄=/u01/app/oracle/product/11.2.0.4/dbhome_1/dbs/dbbakfull_77tmqt9i_1_1 RECID=13819 STAMP=997029170 交叉校验备份片段: 找到为 'EXPIRED' 备份片段句柄=/u01/app/oracle/product/11.2.0.4/dbhome_1/dbs/dbbakfull_78tmqted_1_1 RECID=13820 STAMP=997029328 交叉校验备份片段: 找到为 'EXPIRED' 备份片段句柄=/u01/app/oracle/product/11.2.0.4/dbhome_1/dbs/dbbakfull_79tmqteh_1_1 RECID=13821 STAMP=997029329 交叉校验备份片段: 找到为 'EXPIRED' 备份片段句柄=/u01/app/oracle/product/11.2.0.4/dbhome_1/dbs/dbbakfull_76tmqt9i_1_1 RECID=13822 STAMP=997029170 交叉校验备份片段: 找到为 'EXPIRED' 备份片段句柄=/u01/app/oracle/product/11.2.0.4/dbhome_1/dbs/dbbakfull_75tmqt9h_1_1 RECID=13823 STAMP=997029170 交叉校验备份片段: 找到为 'EXPIRED' 备份片段句柄=/u01/app/oracle/product/11.2.0.4/dbhome_1/dbs/dbbakfull_74tmqt9h_1_1 RECID=13824 STAMP=997029169 已交叉检验的 62 对象 RMAN> RMAN> delete expired backup; 使用通道 ORA_DISK_1 备份片段列表 BP 关键字 BS 关键字 Pc# Cp# 状态设备类型段名称 ------- ------- --- --- ----------- ----------- ---------- 13759 13466 1 1 EXPIRED DISK +ARCH/backup/zlemr_dbwhole_20190101_5ctm9465_1_1.bak 13760 13466 2 1 EXPIRED DISK +ARCH/backup/zlemr_dbwhole_20190101_5ctm9465_2_1.bak 13761 13467 1 1 EXPIRED DISK +ARCH/backup/arch_20190101_5htm95mt_1_1.bak 13765 13471 1 1 EXPIRED DISK +ARCH/backup/zlemr_dbwhole_20190102_5ltmboi6_1_1.bak 13766 13472 1 1 EXPIRED DISK +ARCH/backup/zlemr_dbwhole_20190102_5mtmbp0n_1_1.bak 13768 13474 1 1 EXPIRED DISK +ARCH/backup/zlemr_dbwhole_20190102_5ktmboi6_1_1.bak 13769 13474 2 1 EXPIRED DISK +ARCH/backup/zlemr_dbwhole_20190102_5ktmboi6_2_1.bak 13770 13475 1 1 EXPIRED DISK +ARCH/backup/arch_20190102_5otmbq2j_1_1.bak 13771 13476 1 1 EXPIRED DISK +ARCH/backup/arch_20190102_5ptmbq2j_1_1.bak 13772 13477 1 1 EXPIRED DISK +ARCH/backup/spfile_wyhis_20190102_5qtmbq2r_1_1.ora 13773 13478 1 1 EXPIRED DISK +ARCH/backup/ctrl_wyhis_20190102_5rtmbq2s_1_1.bak 13774 13479 1 1 EXPIRED DISK +ARCH/backup/zlemr_dbwhole_20190103_5ttmecu5_1_1.bak 13775 13480 1 1 EXPIRED DISK +ARCH/backup/zlemr_dbwhole_20190103_5utmedcm_1_1.bak 13776 13481 1 1 EXPIRED DISK +ARCH/backup/zlemr_dbwhole_20190103_5vtmedco_1_1.bak 13777 13482 1 1 EXPIRED DISK +ARCH/backup/zlemr_dbwhole_20190103_5stmecu5_1_1.bak 13778 13482 2 1 EXPIRED DISK +ARCH/backup/zlemr_dbwhole_20190103_5stmecu5_2_1.bak 13779 13483 1 1 EXPIRED DISK +ARCH/backup/arch_20190103_61tmeeej_1_1.bak 13780 13484 1 1 EXPIRED DISK +ARCH/backup/arch_20190103_60tmeeej_1_1.bak 13781 13485 1 1 EXPIRED DISK +ARCH/backup/spfile_wyhis_20190103_62tmeeeq_1_1.ora 13782 13486 1 1 EXPIRED DISK +ARCH/backup/ctrl_wyhis_20190103_63tmeeer_1_1.bak 13783 13487 1 1 EXPIRED DISK +ARCH/backup/zlemr_dbwhole_20190104_65tmh1a5_1_1.bak 13784 13488 1 1 EXPIRED DISK +ARCH/backup/zlemr_dbwhole_20190104_66tmh1om_1_1.bak 13785 13489 1 1 EXPIRED DISK +ARCH/backup/zlemr_dbwhole_20190104_67tmh1oo_1_1.bak 13786 13490 1 1 EXPIRED DISK +ARCH/backup/zlemr_dbwhole_20190104_64tmh1a5_1_1.bak 13787 13490 2 1 EXPIRED DISK +ARCH/backup/zlemr_dbwhole_20190104_64tmh1a5_2_1.bak 13788 13491 1 1 EXPIRED DISK +ARCH/backup/arch_20190104_68tmh2qu_1_1.bak 13789 13492 1 1 EXPIRED DISK +ARCH/backup/arch_20190104_69tmh2qu_1_1.bak 13790 13493 1 1 EXPIRED DISK +ARCH/backup/spfile_wyhis_20190104_6atmh2r5_1_1.ora 13791 13494 1 1 EXPIRED DISK +ARCH/backup/ctrl_wyhis_20190104_6btmh2r6_1_1.bak 13792 13495 1 1 EXPIRED DISK +ARCH/backup/zlemr_dbwhole_20190105_6dtmjlm5_1_1.bak 13793 13496 1 1 EXPIRED DISK +ARCH/backup/zlemr_dbwhole_20190105_6etmjm4n_1_1.bak 13794 13497 1 1 EXPIRED DISK +ARCH/backup/zlemr_dbwhole_20190105_6ftmjm4p_1_1.bak 13795 13498 1 1 EXPIRED DISK +ARCH/backup/zlemr_dbwhole_20190105_6ctmjlm5_1_1.bak 13796 13498 2 1 EXPIRED DISK +ARCH/backup/zlemr_dbwhole_20190105_6ctmjlm5_2_1.bak 13797 13499 1 1 EXPIRED DISK +ARCH/backup/arch_20190105_6htmjn6s_1_1.bak 13798 13500 1 1 EXPIRED DISK +ARCH/backup/arch_20190105_6gtmjn6s_1_1.bak 13799 13501 1 1 EXPIRED DISK +ARCH/backup/spfile_wyhis_20190105_6itmjn74_1_1.ora 13800 13502 1 1 EXPIRED DISK +ARCH/backup/ctrl_wyhis_20190105_6jtmjn75_1_1.bak 13801 13503 1 1 EXPIRED DISK +ARCH/backup/zlemr_dbwhole_20190106_6ltmma25_1_1.bak 13802 13504 1 1 EXPIRED DISK +ARCH/backup/zlemr_dbwhole_20190106_6mtmmagn_1_1.bak 13803 13505 1 1 EXPIRED DISK +ARCH/backup/zlemr_dbwhole_20190106_6ntmmagp_1_1.bak 13804 13506 1 1 EXPIRED DISK +ARCH/backup/zlemr_dbwhole_20190106_6ktmma25_1_1.bak 13805 13506 2 1 EXPIRED DISK +ARCH/backup/zlemr_dbwhole_20190106_6ktmma25_2_1.bak 13806 13507 1 1 EXPIRED DISK +ARCH/backup/arch_20190106_6ptmmbj8_1_1.bak 13807 13508 1 1 EXPIRED DISK +ARCH/backup/arch_20190106_6otmmbj8_1_1.bak 13808 13509 1 1 EXPIRED DISK +ARCH/backup/spfile_wyhis_20190106_6qtmmbjf_1_1.ora 13809 13510 1 1 EXPIRED DISK +ARCH/backup/ctrl_wyhis_20190106_6rtmmbjg_1_1.bak 13810 13511 1 1 EXPIRED DISK +ARCH/backup/zlemr_dbwhole_20190107_6ttmoue6_1_1.bak 13811 13512 1 1 EXPIRED DISK +ARCH/backup/zlemr_dbwhole_20190107_6utmousn_1_1.bak 13812 13513 1 1 EXPIRED DISK +ARCH/backup/zlemr_dbwhole_20190107_6vtmousp_1_1.bak 13813 13514 1 1 EXPIRED DISK +ARCH/backup/zlemr_dbwhole_20190107_6stmoue6_1_1.bak 13814 13514 2 1 EXPIRED DISK +ARCH/backup/zlemr_dbwhole_20190107_6stmoue6_2_1.bak 13815 13515 1 1 EXPIRED DISK +ARCH/backup/arch_20190107_71tmovuj_1_1.bak 13816 13516 1 1 EXPIRED DISK +ARCH/backup/arch_20190107_70tmovuj_1_1.bak 13817 13517 1 1 EXPIRED DISK +ARCH/backup/spfile_wyhis_20190107_72tmovuq_1_1.ora 13818 13518 1 1 EXPIRED DISK +ARCH/backup/ctrl_wyhis_20190107_73tmovur_1_1.bak 13819 13519 1 1 EXPIRED DISK /u01/app/oracle/product/11.2.0.4/dbhome_1/dbs/dbbakfull_77tmqt9i_1_1 13820 13520 1 1 EXPIRED DISK /u01/app/oracle/product/11.2.0.4/dbhome_1/dbs/dbbakfull_78tmqted_1_1 13821 13521 1 1 EXPIRED DISK /u01/app/oracle/product/11.2.0.4/dbhome_1/dbs/dbbakfull_79tmqteh_1_1 13822 13522 1 1 EXPIRED DISK /u01/app/oracle/product/11.2.0.4/dbhome_1/dbs/dbbakfull_76tmqt9i_1_1 13823 13523 1 1 EXPIRED DISK /u01/app/oracle/product/11.2.0.4/dbhome_1/dbs/dbbakfull_75tmqt9h_1_1 13824 13524 1 1 EXPIRED DISK /u01/app/oracle/product/11.2.0.4/dbhome_1/dbs/dbbakfull_74tmqt9h_1_1 是否确定要删除以上对象 (输入 YES 或 NO)? yes 已删除备份片段备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190101_5ctm9465_1_1.bak RECID=13759 STAMP=996446405 已删除备份片段备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190101_5ctm9465_2_1.bak RECID=13760 STAMP=996447567 已删除备份片段备份片段句柄=+ARCH/backup/arch_20190101_5htm95mt_1_1.bak RECID=13761 STAMP=996447965 已删除备份片段备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190102_5ltmboi6_1_1.bak RECID=13765 STAMP=996532806 已删除备份片段备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190102_5mtmbp0n_1_1.bak RECID=13766 STAMP=996533272 已删除备份片段备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190102_5ktmboi6_1_1.bak RECID=13768 STAMP=996532806 已删除备份片段备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190102_5ktmboi6_2_1.bak RECID=13769 STAMP=996533958 已删除备份片段备份片段句柄=+ARCH/backup/arch_20190102_5otmbq2j_1_1.bak RECID=13770 STAMP=996534355 已删除备份片段备份片段句柄=+ARCH/backup/arch_20190102_5ptmbq2j_1_1.bak RECID=13771 STAMP=996534355 已删除备份片段备份片段句柄=+ARCH/backup/spfile_wyhis_20190102_5qtmbq2r_1_1.ora RECID=13772 STAMP=996534363 已删除备份片段备份片段句柄=+ARCH/backup/ctrl_wyhis_20190102_5rtmbq2s_1_1.bak RECID=13773 STAMP=996534365 已删除备份片段备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190103_5ttmecu5_1_1.bak RECID=13774 STAMP=996619205 已删除备份片段备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190103_5utmedcm_1_1.bak RECID=13775 STAMP=996619671 已删除备份片段备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190103_5vtmedco_1_1.bak RECID=13776 STAMP=996619672 已删除备份片段备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190103_5stmecu5_1_1.bak RECID=13777 STAMP=996619205 已删除备份片段备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190103_5stmecu5_2_1.bak RECID=13778 STAMP=996620358 已删除备份片段备份片段句柄=+ARCH/backup/arch_20190103_61tmeeej_1_1.bak RECID=13779 STAMP=996620755 已删除备份片段备份片段句柄=+ARCH/backup/arch_20190103_60tmeeej_1_1.bak RECID=13780 STAMP=996620755 已删除备份片段备份片段句柄=+ARCH/backup/spfile_wyhis_20190103_62tmeeeq_1_1.ora RECID=13781 STAMP=996620762 已删除备份片段备份片段句柄=+ARCH/backup/ctrl_wyhis_20190103_63tmeeer_1_1.bak RECID=13782 STAMP=996620764 已删除备份片段备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190104_65tmh1a5_1_1.bak RECID=13783 STAMP=996705605 已删除备份片段备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190104_66tmh1om_1_1.bak RECID=13784 STAMP=996706071 已删除备份片段备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190104_67tmh1oo_1_1.bak RECID=13785 STAMP=996706072 已删除备份片段备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190104_64tmh1a5_1_1.bak RECID=13786 STAMP=996705605 已删除备份片段备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190104_64tmh1a5_2_1.bak RECID=13787 STAMP=996706768 已删除备份片段备份片段句柄=+ARCH/backup/arch_20190104_68tmh2qu_1_1.bak RECID=13788 STAMP=996707166 已删除备份片段备份片段句柄=+ARCH/backup/arch_20190104_69tmh2qu_1_1.bak RECID=13789 STAMP=996707166 已删除备份片段备份片段句柄=+ARCH/backup/spfile_wyhis_20190104_6atmh2r5_1_1.ora RECID=13790 STAMP=996707173 已删除备份片段备份片段句柄=+ARCH/backup/ctrl_wyhis_20190104_6btmh2r6_1_1.bak RECID=13791 STAMP=996707175 已删除备份片段备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190105_6dtmjlm5_1_1.bak RECID=13792 STAMP=996792006 已删除备份片段备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190105_6etmjm4n_1_1.bak RECID=13793 STAMP=996792472 已删除备份片段备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190105_6ftmjm4p_1_1.bak RECID=13794 STAMP=996792473 已删除备份片段备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190105_6ctmjlm5_1_1.bak RECID=13795 STAMP=996792005 已删除备份片段备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190105_6ctmjlm5_2_1.bak RECID=13796 STAMP=996793168 已删除备份片段备份片段句柄=+ARCH/backup/arch_20190105_6htmjn6s_1_1.bak RECID=13797 STAMP=996793564 已删除备份片段备份片段句柄=+ARCH/backup/arch_20190105_6gtmjn6s_1_1.bak RECID=13798 STAMP=996793564 已删除备份片段备份片段句柄=+ARCH/backup/spfile_wyhis_20190105_6itmjn74_1_1.ora RECID=13799 STAMP=996793572 已删除备份片段备份片段句柄=+ARCH/backup/ctrl_wyhis_20190105_6jtmjn75_1_1.bak RECID=13800 STAMP=996793574 已删除备份片段备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190106_6ltmma25_1_1.bak RECID=13801 STAMP=996878406 已删除备份片段备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190106_6mtmmagn_1_1.bak RECID=13802 STAMP=996878872 已删除备份片段备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190106_6ntmmagp_1_1.bak RECID=13803 STAMP=996878873 已删除备份片段备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190106_6ktmma25_1_1.bak RECID=13804 STAMP=996878405 已删除备份片段备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190106_6ktmma25_2_1.bak RECID=13805 STAMP=996879568 已删除备份片段备份片段句柄=+ARCH/backup/arch_20190106_6ptmmbj8_1_1.bak RECID=13806 STAMP=996879976 已删除备份片段备份片段句柄=+ARCH/backup/arch_20190106_6otmmbj8_1_1.bak RECID=13807 STAMP=996879976 已删除备份片段备份片段句柄=+ARCH/backup/spfile_wyhis_20190106_6qtmmbjf_1_1.ora RECID=13808 STAMP=996879983 已删除备份片段备份片段句柄=+ARCH/backup/ctrl_wyhis_20190106_6rtmmbjg_1_1.bak RECID=13809 STAMP=996879985 已删除备份片段备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190107_6ttmoue6_1_1.bak RECID=13810 STAMP=996964806 已删除备份片段备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190107_6utmousn_1_1.bak RECID=13811 STAMP=996965272 已删除备份片段备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190107_6vtmousp_1_1.bak RECID=13812 STAMP=996965273 已删除备份片段备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190107_6stmoue6_1_1.bak RECID=13813 STAMP=996964806 已删除备份片段备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190107_6stmoue6_2_1.bak RECID=13814 STAMP=996965959 已删除备份片段备份片段句柄=+ARCH/backup/arch_20190107_71tmovuj_1_1.bak RECID=13815 STAMP=996966355 已删除备份片段备份片段句柄=+ARCH/backup/arch_20190107_70tmovuj_1_1.bak RECID=13816 STAMP=996966355 已删除备份片段备份片段句柄=+ARCH/backup/spfile_wyhis_20190107_72tmovuq_1_1.ora RECID=13817 STAMP=996966362 已删除备份片段备份片段句柄=+ARCH/backup/ctrl_wyhis_20190107_73tmovur_1_1.bak RECID=13818 STAMP=996966364 已删除备份片段备份片段句柄=/u01/app/oracle/product/11.2.0.4/dbhome_1/dbs/dbbakfull_77tmqt9i_1_1 RECID=13819 STAMP=997029170 已删除备份片段备份片段句柄=/u01/app/oracle/product/11.2.0.4/dbhome_1/dbs/dbbakfull_78tmqted_1_1 RECID=13820 STAMP=997029328 已删除备份片段备份片段句柄=/u01/app/oracle/product/11.2.0.4/dbhome_1/dbs/dbbakfull_79tmqteh_1_1 RECID=13821 STAMP=997029329 已删除备份片段备份片段句柄=/u01/app/oracle/product/11.2.0.4/dbhome_1/dbs/dbbakfull_76tmqt9i_1_1 RECID=13822 STAMP=997029170 已删除备份片段备份片段句柄=/u01/app/oracle/product/11.2.0.4/dbhome_1/dbs/dbbakfull_75tmqt9h_1_1 RECID=13823 STAMP=997029170 已删除备份片段备份片段句柄=/u01/app/oracle/product/11.2.0.4/dbhome_1/dbs/dbbakfull_74tmqt9h_1_1 RECID=13824 STAMP=997029169 62 EXPIRED 对象已删除 RMAN> RMAN> catalog start with 'd:\dbbak\'; 搜索与样式 d:\dbbak\ 匹配的所有文件数据库未知文件的列表 ===================================== 文件名: D:\DBBAK\control_7atmqumb_1_1 文件名: D:\DBBAK\dbbakfull_74tmqt9h_1_1 文件名: D:\DBBAK\dbbakfull_75tmqt9h_1_1 文件名: D:\DBBAK\dbbakfull_76tmqt9i_1_1 文件名: D:\DBBAK\dbbakfull_77tmqt9i_1_1 文件名: D:\DBBAK\dbbakfull_78tmqted_1_1 文件名: D:\DBBAK\dbbakfull_79tmqteh_1_1 是否确实要将上述文件列入目录 (输入 YES 或 NO)? yes 正在编制文件目录... 目录编制完毕已列入目录的文件的列表 ======================= 文件名: D:\DBBAK\control_7atmqumb_1_1 文件名: D:\DBBAK\dbbakfull_74tmqt9h_1_1 文件名: D:\DBBAK\dbbakfull_75tmqt9h_1_1 文件名: D:\DBBAK\dbbakfull_76tmqt9i_1_1 文件名: D:\DBBAK\dbbakfull_77tmqt9i_1_1 文件名: D:\DBBAK\dbbakfull_78tmqted_1_1 文件名: D:\DBBAK\dbbakfull_79tmqteh_1_1 RMAN> RMAN> run{ 2> set newname for database to 'D:\oradata\zlemr\%d'; 3> restore database; 4> } 正在执行命令: SET NEWNAME RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: set 命令 (在 01/08/2019 17:41:49 上) 失败 RMAN-06970: 数据库的 NEWNAME 'D:\oradata\zlemr\%d' 必须包含 %f 或 %U 格式 RMAN> run{ 2> set newname for database to 'D:\oradata\zlemr\%b'; 3> restore database; 4> } 正在执行命令: SET NEWNAME 启动 restore 于 08-1月 -19 使用通道 ORA_DISK_1 通道 ORA_DISK_1: 正在开始还原数据文件备份集通道 ORA_DISK_1: 正在指定从备份集还原的数据文件通道 ORA_DISK_1: 将数据文件 00005 还原到 D:\oradata\zlemr\+DATA/zlemrdg/zldocbase.dbf 通道 ORA_DISK_1: 将数据文件 00008 还原到 D:\oradata\zlemr\+DATA/zlemrdg/zldocdataindex.dbf 通道 ORA_DISK_1: 将数据文件 00009 还原到 D:\oradata\zlemr\+DATA/zlemrdg/zldocxml.dbf 通道 ORA_DISK_1: 正在读取备份片段 D:\DBBAK\DBBAKFULL_74TMQT9H_1_1 通道 ORA_DISK_1: ORA-19870: 还原备份片段 D:\DBBAK\DBBAKFULL_74TMQT9H_1_1 时出错 ORA-19504: 无法创建文件"D:\ORADATA\ZLEMR\+DATA\ZLEMRDG\ZLDOCXML.DBF" ORA-27040: 文件创建错误, 无法创建文件 OSD-04002: ？???？？? O/S-Error: (OS 3) ？？？????？???？????? 通道 ORA_DISK_1: 正在开始还原数据文件备份集通道 ORA_DISK_1: 正在指定从备份集还原的数据文件通道 ORA_DISK_1: 将数据文件 00001 还原到 D:\oradata\zlemr\+DATA/zlemrdg/system01.dbf 通道 ORA_DISK_1: 将数据文件 00003 还原到 D:\oradata\zlemr\+DATA/zlemrdg/undotbs01.dbf 通道 ORA_DISK_1: 将数据文件 00010 还原到 D:\oradata\zlemr\+DATA/zlemrdg/sysaux02.dbf 通道 ORA_DISK_1: 正在读取备份片段 D:\DBBAK\DBBAKFULL_77TMQT9I_1_1 通道 ORA_DISK_1: ORA-19870: 还原备份片段 D:\DBBAK\DBBAKFULL_77TMQT9I_1_1 时出错 ORA-19504: 无法创建文件"D:\ORADATA\ZLEMR\+DATA\ZLEMRDG\SYSAUX02.DBF" ORA-27040: 文件创建错误, 无法创建文件 OSD-04002: ？???？？? O/S-Error: (OS 3) ？？？????？???？????? 通道 ORA_DISK_1: 正在开始还原数据文件备份集通道 ORA_DISK_1: 正在指定从备份集还原的数据文件通道 ORA_DISK_1: 将数据文件 00002 还原到 D:\oradata\zlemr\+DATA/zlemrdg/sysaux01.dbf 通道 ORA_DISK_1: 将数据文件 00004 还原到 D:\oradata\zlemr\+DATA/zlemrdg/users01.dbf 通道 ORA_DISK_1: 将数据文件 00007 还原到 D:\oradata\zlemr\+DATA/zlemrdg/zldocdata.dbf 通道 ORA_DISK_1: 正在读取备份片段 D:\DBBAK\DBBAKFULL_76TMQT9I_1_1 通道 ORA_DISK_1: ORA-19870: 还原备份片段 D:\DBBAK\DBBAKFULL_76TMQT9I_1_1 时出错 ORA-19504: 无法创建文件"D:\ORADATA\ZLEMR\+DATA\ZLEMRDG\SYSAUX01.DBF" ORA-27040: 文件创建错误, 无法创建文件 OSD-04002: ？???？？? O/S-Error: (OS 3) ？？？????？???？????? 通道 ORA_DISK_1: 正在开始还原数据文件备份集通道 ORA_DISK_1: 正在指定从备份集还原的数据文件通道 ORA_DISK_1: 将数据文件 00006 还原到 D:\oradata\zlemr\+DATA/zlemrdg/zldocindex.dbf 通道 ORA_DISK_1: 将数据文件 00011 还原到 D:\oradata\zlemr\+DATA/zlemrdg/zldocxml01.dbf 通道 ORA_DISK_1: 将数据文件 00012 还原到 D:\oradata\zlemr\+DATA/zlemrdg/zldocdataindex01.dbf 通道 ORA_DISK_1: 正在读取备份片段 D:\DBBAK\DBBAKFULL_75TMQT9H_1_1 通道 ORA_DISK_1: ORA-19870: 还原备份片段 D:\DBBAK\DBBAKFULL_75TMQT9H_1_1 时出错 ORA-19504: 无法创建文件"D:\ORADATA\ZLEMR\+DATA\ZLEMRDG\ZLDOCXML01.DBF" ORA-27040: 文件创建错误, 无法创建文件 OSD-04002: ？???？？? O/S-Error: (OS 3) ？？？????？???？????? 故障转移到上一个备份 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: restore 命令 (在 01/08/2019 17:42:43 上) 失败 RMAN-06026: 有些目标没有找到 - 终止还原 RMAN-06023: 没有找到数据文件4的副本来还原 RMAN-06023: 没有找到数据文件3的副本来还原 RMAN-06023: 没有找到数据文件2的副本来还原 RMAN-06023: 没有找到数据文件1的副本来还原 RMAN> RMAN> run{ 2> set newname for datafile '+DATA/zlemrdg/zldocbase.dbf' to 'D:\oradata\zlemr\zldocbase.dbf'; 3> set newname for datafile '+DATA/zlemrdg/zldocdataindex.dbf' to 'D:\oradata\zlemr\zldocdataindex.dbf'; 4> set newname for datafile '+DATA/zlemrdg/zldocxml.dbf' to 'D:\oradata\zlemr\zldocxml.dbf'; 5> set newname for datafile '+DATA/zlemrdg/system01.dbf' to 'D:\oradata\zlemr\system01.dbf'; 6> set newname for datafile '+DATA/zlemrdg/undotbs01.dbf' to 'D:\oradata\zlemr\undotbs01.dbf'; 7> set newname for datafile '+DATA/zlemrdg/sysaux02.dbf' to 'D:\oradata\zlemr\sysaux02.dbf'; 8> set newname for datafile '+DATA/zlemrdg/zldocindex.dbf' to 'D:\oradata\zlemr\zldocindex.dbf'; 9> set newname for datafile '+DATA/zlemrdg/zldocxml01.dbf' to 'D:\oradata\zlemr\zldocxml01.dbf'; 10> set newname for datafile '+DATA/zlemrdg/zldocdataindex01.dbf' to 'D:\oradata\zlemr\zldocdataindex01.dbf'; 11> set newname for datafile '+DATA/zlemrdg/sysaux01.dbf' to 'D:\oradata\zlemr\sysaux01.dbf'; 12> set newname for datafile '+DATA/zlemrdg/zldocdata.dbf' to 'D:\oradata\zlemr\zldocdata.dbf'; 13> set newname for datafile '+DATA/zlemrdg/users01.dbf' to 'D:\oradata\zlemr\users01.dbf'; 14> 15> restore database; 16> } 正在执行命令: SET NEWNAME 正在执行命令: SET NEWNAME 正在执行命令: SET NEWNAME 正在执行命令: SET NEWNAME 正在执行命令: SET NEWNAME 正在执行命令: SET NEWNAME 正在执行命令: SET NEWNAME 正在执行命令: SET NEWNAME 正在执行命令: SET NEWNAME 正在执行命令: SET NEWNAME 正在执行命令: SET NEWNAME 正在执行命令: SET NEWNAME 启动 restore 于 08-1月 -19 使用通道 ORA_DISK_1 通道 ORA_DISK_1: 正在开始还原数据文件备份集通道 ORA_DISK_1: 正在指定从备份集还原的数据文件通道 ORA_DISK_1: 将数据文件 00005 还原到 D:\oradata\zlemr\zldocbase.dbf 通道 ORA_DISK_1: 将数据文件 00008 还原到 D:\oradata\zlemr\zldocdataindex.dbf 通道 ORA_DISK_1: 将数据文件 00009 还原到 D:\oradata\zlemr\zldocxml.dbf 通道 ORA_DISK_1: 正在读取备份片段 D:\DBBAK\DBBAKFULL_74TMQT9H_1_1 通道 ORA_DISK_1: 段句柄 = D:\DBBAK\DBBAKFULL_74TMQT9H_1_1 标记 = TAG20190108T163249 通道 ORA_DISK_1: 已还原备份片段 1 通道 ORA_DISK_1: 还原完成, 用时: 00:24:18 通道 ORA_DISK_1: 正在开始还原数据文件备份集通道 ORA_DISK_1: 正在指定从备份集还原的数据文件通道 ORA_DISK_1: 将数据文件 00001 还原到 D:\oradata\zlemr\system01.dbf 通道 ORA_DISK_1: 将数据文件 00003 还原到 D:\oradata\zlemr\undotbs01.dbf 通道 ORA_DISK_1: 将数据文件 00010 还原到 D:\oradata\zlemr\sysaux02.dbf 通道 ORA_DISK_1: 正在读取备份片段 D:\DBBAK\DBBAKFULL_77TMQT9I_1_1 通道 ORA_DISK_1: 段句柄 = D:\DBBAK\DBBAKFULL_77TMQT9I_1_1 标记 = TAG20190108T163249 通道 ORA_DISK_1: 已还原备份片段 1 通道 ORA_DISK_1: 还原完成, 用时: 00:04:35 通道 ORA_DISK_1: 正在开始还原数据文件备份集通道 ORA_DISK_1: 正在指定从备份集还原的数据文件通道 ORA_DISK_1: 将数据文件 00002 还原到 D:\oradata\zlemr\sysaux01.dbf 通道 ORA_DISK_1: 将数据文件 00004 还原到 D:\oradata\zlemr\users01.dbf 通道 ORA_DISK_1: 将数据文件 00007 还原到 D:\oradata\zlemr\zldocdata.dbf 通道 ORA_DISK_1: 正在读取备份片段 D:\DBBAK\DBBAKFULL_76TMQT9I_1_1 通道 ORA_DISK_1: 段句柄 = D:\DBBAK\DBBAKFULL_76TMQT9I_1_1 标记 = TAG20190108T163249 通道 ORA_DISK_1: 已还原备份片段 1 通道 ORA_DISK_1: 还原完成, 用时: 00:07:46 通道 ORA_DISK_1: 正在开始还原数据文件备份集通道 ORA_DISK_1: 正在指定从备份集还原的数据文件通道 ORA_DISK_1: 将数据文件 00006 还原到 D:\oradata\zlemr\zldocindex.dbf 通道 ORA_DISK_1: 将数据文件 00011 还原到 D:\oradata\zlemr\zldocxml01.dbf 通道 ORA_DISK_1: 将数据文件 00012 还原到 D:\oradata\zlemr\zldocdataindex01.dbf 通道 ORA_DISK_1: 正在读取备份片段 D:\DBBAK\DBBAKFULL_75TMQT9H_1_1 通道 ORA_DISK_1: 段句柄 = D:\DBBAK\DBBAKFULL_75TMQT9H_1_1 标记 = TAG20190108T163249 通道 ORA_DISK_1: 已还原备份片段 1 通道 ORA_DISK_1: 还原完成, 用时: 00:09:06 完成 restore 于 08-1月 -19 RMAN> RMAN> RMAN> switch database to copy; 数据文件 1 已切换成数据文件副本 "D:\ORADATA\ZLEMR\SYSTEM01.DBF" 数据文件 2 已切换成数据文件副本 "D:\ORADATA\ZLEMR\SYSAUX01.DBF" 数据文件 3 已切换成数据文件副本 "D:\ORADATA\ZLEMR\UNDOTBS01.DBF" 数据文件 4 已切换成数据文件副本 "D:\ORADATA\ZLEMR\USERS01.DBF" 数据文件 5 已切换成数据文件副本 "D:\ORADATA\ZLEMR\ZLDOCBASE.DBF" 数据文件 6 已切换成数据文件副本 "D:\ORADATA\ZLEMR\ZLDOCINDEX.DBF" 数据文件 7 已切换成数据文件副本 "D:\ORADATA\ZLEMR\ZLDOCDATA.DBF" 数据文件 8 已切换成数据文件副本 "D:\ORADATA\ZLEMR\ZLDOCDATAINDEX.DBF" 数据文件 9 已切换成数据文件副本 "D:\ORADATA\ZLEMR\ZLDOCXML.DBF" 数据文件 10 已切换成数据文件副本 "D:\ORADATA\ZLEMR\SYSAUX02.DBF" 数据文件 11 已切换成数据文件副本 "D:\ORADATA\ZLEMR\ZLDOCXML01.DBF" 数据文件 12 已切换成数据文件副本 "D:\ORADATA\ZLEMR\ZLDOCDATAINDEX01.DBF" RMAN> SQL> select member from v$logfile; MEMBER ------------------------------------------------------------------------------------------------------------------------ +DATA/zlemrdg/redo03.log +DATA/zlemrdg/redo02.log +DATA/zlemrdg/redo01.log +DATA/zlemrdg/std_redo04.log +DATA/zlemrdg/std_redo05.log +DATA/zlemrdg/std_redo06.log +DATA/zlemrdg/std_redo07.log 已选择7行。 SQL> alter database rename file '+DATA/zlemrdg/redo03.log' to 'D:\oradata\zlemr\redo03.log'; 数据库已更改。 SQL> alter database rename file '+DATA/zlemrdg/redo02.log' to 'D:\oradata\zlemr\redo03.log'; alter database rename file '+DATA/zlemrdg/redo02.log' to 'D:\oradata\zlemr\redo03.log' * 第 1 行出现错误: ORA-01511: 重命名日志/数据文件时出错 ORA-01523: 无法将数据文件重命名为 'D:\oradata\zlemr\redo03.log' - 文件已是数据库的一部分 SQL> alter database rename file '+DATA/zlemrdg/redo02.log' to 'D:\oradata\zlemr\redo02.log'; 数据库已更改。 SQL> alter database rename file '+DATA/zlemrdg/redo01.log' to 'D:\oradata\zlemr\redo01.log'; 数据库已更改。 SQL> alter database drop standby logfile '+DATA/zlemrdg/std_redo04.log'; 数据库已更改。 SQL> alter database drop standby logfile '+DATA/zlemrdg/std_redo05.log'; 数据库已更改。 SQL> alter database drop standby logfile '+DATA/zlemrdg/std_redo06.log'; 数据库已更改。 SQL> alter database drop standby logfile '+DATA/zlemrdg/std_redo07.log'; 数据库已更改。 SQL> select member from v$logfile; MEMBER ------------------------------------------------------------------------------------------------------------------------ D:\ORADATA\ZLEMR\REDO03.LOG D:\ORADATA\ZLEMR\REDO02.LOG D:\ORADATA\ZLEMR\REDO01.LOG SQL> alter database open resetlogs; 数据库已更改。 SQL> select file_name from dba_temp_files; select file_name from dba_temp_files * 第 1 行出现错误: ORA-01157: 无法标识/锁定数据文件 201 - 请参阅 DBWR 跟踪文件 ORA-01110: 数据文件 201: '+DATA/zlemrdg/temp01.dbf' SQL> create temporary tablespace temp1 tempfile 'D:\oradata\zlemr\temp02.dbf' size 1g autoextend on next 100m; 表空间已创建。 SQL> alter database default temporary tablespace temp1; 数据库已更改。 SQL> drop tablespace temp; 表空间已删除。 SQL> select file_name from dba_temp_files; FILE_NAME ------------------------------------------------------------------------------------------------------------------------ D:\ORADATA\ZLEMR\TEMP02.DBF SQL>

编辑推荐：

返回列表

通过rman为客户实现linux下oracle11.2.0.4到windows下oracle同版本数据库的异机恢复。

编辑推荐：

相关推荐

excel表格怎样在数字前输入0

excel表格里怎么替换数据

excel表格里面如何插入圆形

excel表格里怎么添加表格数据透视表

excel表格中怎么添加线边框

excel表格里怎样设置条件自动排序

excel表格例怎样导入数据库

Excel表格如何设置数据排序

excel表格里怎么选择性粘贴快捷键

excel表格怎么插入分隔符号

excel表格怎么设置多行多列数据内容排序

Excel表格如何设置行和列相互转换

excel表格连接公式怎么使用

excel表格怎样链接到cad中

雷神推出 MIX PRO II 迷你主机：基于 Ultra 200H，玻璃上盖 + ARGB 灯效

制造商 Musnap 推出彩色墨水屏电纸书 Ocean C：支持手写笔、第三方安卓应用

最新软件资讯

热文推荐

天极热推