这篇文章主要介绍了如何通过rman为客户实现linux下oracle11.2.0.4到windows下oracle同版本数据库的异机恢复，具有一定借鉴价值，感兴趣的朋友可以参考下，希望大家阅读完这篇文章之后大有收获，下面让小编带着大家一起了解一下。下面是记录了一个恢复的过程。[root@emrdg ~]# su – oracle
[oracle@emrdg ~]$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.4.0 Production on Tue Jan 8 16:39:12 2019Copyright (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 optionsSQL> 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 2019Copyright (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 ‘dbbakfull_%U’;
7> }using target database control file instead of recovery catalog
allocated channel: c1
channel c1: SID=762 device type=DISKallocated channel: c2
channel c2: SID=1519 device type=DISKallocated channel: c3
channel c3: SID=2276 device type=DISKallocated channel: c4
channel c4: SID=7 device type=DISKStarting 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:01channel 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:14channel 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: c4RMAN>
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:45RMAN>
SQL> col units format a10
SQL> Select sofar,totalwork,units,TIME_REMAINING, ELAPSED_SECONDS from v$session_longops where sofartotalwork; SOFAR TOTALWORK UNITS TIME_REMAINING ELAPSED_SECONDS
———- ———- ———- ————– —————
4423032 8528960 Blocks 486 524
1184638 2435456 Blocks 660 625
1145749 0 Blocks 625
2914993 0 Blocks 398SQL> Select sofar,totalwork,units,TIME_REMAINING, ELAPSED_SECONDS from v$session_longops where sofartotalwork; SOFAR TOTALWORK UNITS TIME_REMAINING ELAPSED_SECONDS
———- ———- ———- ————– —————
4423032 8528960 Blocks 486 524
1203326 2435456 Blocks 654 639
1164437 0 Blocks 639
2914993 0 Blocks 398SQL> Select sofar,totalwork,units,TIME_REMAINING, ELAPSED_SECONDS from v$session_longops where sofartotalwork; SOFAR TOTALWORK UNITS TIME_REMAINING ELAPSED_SECONDS
———- ———- ———- ————– —————
4601336 8528960 Blocks 551 645
1228926 2435456 Blocks 643 655
1190037 0 Blocks 655
3093297 0 Blocks 519SQL> Select sofar,totalwork,units,TIME_REMAINING, ELAPSED_SECONDS from v$session_longops where sofartotalwork; SOFAR TOTALWORK UNITS TIME_REMAINING ELAPSED_SECONDS
———- ———- ———- ————– —————
4601336 8528960 Blocks 551 645
1252350 2435456 Blocks 634 671
1213461 0 Blocks 671
3093297 0 Blocks 519SQL> Select sofar,totalwork,units,TIME_REMAINING, ELAPSED_SECONDS from v$session_longops where sofartotalwork; SOFAR TOTALWORK UNITS TIME_REMAINING ELAPSED_SECONDS
———- ———- ———- ————– —————
4601336 8528960 Blocks 551 645
1260798 2435456 Blocks 631 677
1221909 0 Blocks 677
3093297 0 Blocks 519SQL> Select sofar,totalwork,units,TIME_REMAINING, ELAPSED_SECONDS from v$session_longops where sofartotalwork; SOFAR TOTALWORK UNITS TIME_REMAINING ELAPSED_SECONDS
———- ———- ———- ————– —————
4973816 8528960 Blocks 633 885
1714046 2435456 Blocks 407 967
1675120 0 Blocks 967
3465769 0 Blocks 759SQL> Select sofar,totalwork,units,TIME_REMAINING, ELAPSED_SECONDS from v$session_longops where sofartotalwork; SOFAR TOTALWORK UNITS TIME_REMAINING ELAPSED_SECONDS
———- ———- ———- ————– —————
5338872 8528960 Blocks 672 1125
2066046 2435456 Blocks 213 1190
2026076 0 Blocks 1190
3830226 0 Blocks 999SQL> host
[oracle@emrdg ~]$ pwd
/home/oracle
[oracle@emrdg ~]$ exit
exitSQL> Select sofar,totalwork,units,TIME_REMAINING, ELAPSED_SECONDS from v$session_longops where sofartotalwork; SOFAR TOTALWORK UNITS TIME_REMAINING ELAPSED_SECONDS
———- ———- ———- ————– —————
5338872 8528960 Blocks 672 1125
2120190 2435456 Blocks 182 1223
2080220 0 Blocks 1223
3830226 0 Blocks 999SQL> 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 52428800SQL> 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.log7 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.log7 rows selected.SQL> Select sofar,totalwork,units,TIME_REMAINING, ELAPSED_SECONDS from v$session_longops where sofartotalwork; SOFAR TOTALWORK UNITS TIME_REMAINING ELAPSED_SECONDS
———- ———- ———- ————– —————
5542264 8528960 Blocks 671 1245
2343806 2435456 Blocks 53 1363
2303228 0 Blocks 1363
4033140 0 Blocks 1119SQL> Select sofar,totalwork,units,TIME_REMAINING, ELAPSED_SECONDS from v$session_longops where sofartotalwork;no rows selectedSQL> 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
exitSQL> alter database open;Database altered.SQL>–==========================
C:>rman target /恢复管理器: Release 11.2.0.4.0 – Production on 星期二 1月 8 17:04:12 2019Copyright (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:ORADATAEMRTEST1CONTROL01.CTL
输出文件名=C:APPADMINISTRATORFAST_RECOVERY_AREAEMRTEST1CONTROL02.CTL
完成 restore 于 08-1月 -19RMAN>RMAN> exit
恢复管理器完成。C:>sqlplus / as sysdbaSQL*Plus: Release 11.2.0.4.0 Production on 星期二 1月 8 17:05:47 2019Copyright (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 optionsSQL> show parameter control_filesNAME TYPE VALUE
———————————— ———– ——————————
control_files string D:ORADATAEMRTEST1CONTROL01.
CTL, C:APPADMINISTRATORFAST
_RECOVERY_AREAEMRTEST1CONTRO
L02.CTL
SQL> alter database mount;
alter database mount
*
第 1 行出现错误:
ORA-01103: 控制文件中的数据库名 ”ZLEMR” 不是 ”EMRTEST1”
SQL> shutdown immediate
ORA-01507: 未装载数据库
ORACLE 例程已经关闭。
SQL>–=============================
C:>sqlplus / as sysdbaSQL*Plus: Release 11.2.0.4.0 Production on 星期二 1月 8 17:23:16 2019Copyright (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 2019Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.已连接到目标数据库: ZLEMR (未装载)RMAN> restore controlfile from ‘d:dbbakcontrol_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:ORADATAZLEMRCONTROL01.CTL
输出文件名=C:APPADMINISTRATORFAST_RECOVERY_AREAZLEMRCONTROL02.CTL
完成 restore 于 08-1月 -19RMAN> alter database mount;数据库已装载
释放的通道: ORA_DISK_1RMAN>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_65tmh2a5_1_1.bak RECID=13783 STAMP=996705605
交叉校验备份片段: 找到为 ‘EXPIRED’
备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190104_66tmh2om_1_1.bak RECID=13784 STAMP=996706071
交叉校验备份片段: 找到为 ‘EXPIRED’
备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190104_67tmh2oo_1_1.bak RECID=13785 STAMP=996706072
交叉校验备份片段: 找到为 ‘EXPIRED’
备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190104_64tmh2a5_1_1.bak RECID=13786 STAMP=996705605
交叉校验备份片段: 找到为 ‘EXPIRED’
备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190104_64tmh2a5_2_1.bak RECID=13787 STAMP=996706768
交叉校验备份片段: 找到为 ‘EXPIRED’
备份片段句柄=+ARCH/backup/arch_20190104_68tmh3qu_1_1.bak RECID=13788 STAMP=996707166
交叉校验备份片段: 找到为 ‘EXPIRED’
备份片段句柄=+ARCH/backup/arch_20190104_69tmh3qu_1_1.bak RECID=13789 STAMP=996707166
交叉校验备份片段: 找到为 ‘EXPIRED’
备份片段句柄=+ARCH/backup/spfile_wyhis_20190104_6atmh3r5_1_1.ora RECID=13790 STAMP=996707173
交叉校验备份片段: 找到为 ‘EXPIRED’
备份片段句柄=+ARCH/backup/ctrl_wyhis_20190104_6btmh3r6_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_65tmh2a5_1_1.bak
13784 13488 1 1 EXPIRED DISK +ARCH/backup/zlemr_dbwhole_20190104_66tmh2om_1_1.bak
13785 13489 1 1 EXPIRED DISK +ARCH/backup/zlemr_dbwhole_20190104_67tmh2oo_1_1.bak
13786 13490 1 1 EXPIRED DISK +ARCH/backup/zlemr_dbwhole_20190104_64tmh2a5_1_1.bak
13787 13490 2 1 EXPIRED DISK +ARCH/backup/zlemr_dbwhole_20190104_64tmh2a5_2_1.bak
13788 13491 1 1 EXPIRED DISK +ARCH/backup/arch_20190104_68tmh3qu_1_1.bak
13789 13492 1 1 EXPIRED DISK +ARCH/backup/arch_20190104_69tmh3qu_1_1.bak
13790 13493 1 1 EXPIRED DISK +ARCH/backup/spfile_wyhis_20190104_6atmh3r5_1_1.ora
13791 13494 1 1 EXPIRED DISK +ARCH/backup/ctrl_wyhis_20190104_6btmh3r6_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.ba免费云主机域名k
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_65tmh2a5_1_1.bak RECID=13783 STAMP=996705605
已删除备份片段
备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190104_66tmh2om_1_1.bak RECID=13784 STAMP=996706071
已删除备份片段
备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190104_67tmh2oo_1_1.bak RECID=13785 STAMP=996706072
已删除备份片段
备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190104_64tmh2a5_1_1.bak RECID=13786 STAMP=996705605
已删除备份片段
备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190104_64tmh2a5_2_1.bak RECID=13787 STAMP=996706768
已删除备份片段
备份片段句柄=+ARCH/backup/arch_20190104_68tmh3qu_1_1.bak RECID=13788 STAMP=996707166
已删除备份片段
备份片段句柄=+ARCH/backup/arch_20190104_69tmh3qu_1_1.bak RECID=13789 STAMP=996707166
已删除备份片段
备份片段句柄=+ARCH/backup/spfile_wyhis_20190104_6atmh3r5_1_1.ora RECID=13790 STAMP=996707173
已删除备份片段
备份片段句柄=+ARCH/backup/ctrl_wyhis_20190104_6btmh3r6_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:DBBAKcontrol_7atmqumb_1_1
文件名: D:DBBAKdbbakfull_74tmqt9h_1_1
文件名: D:DBBAKdbbakfull_75tmqt9h_1_1
文件名: D:DBBAKdbbakfull_76tmqt9i_1_1
文件名: D:DBBAKdbbakfull_77tmqt9i_1_1
文件名: D:DBBAKdbbakfull_78tmqted_1_1
文件名: D:DBBAKdbbakfull_79tmqteh_1_1是否确实要将上述文件列入目录 (输入 YES 或 NO)? yes
正在编制文件目录…
目录编制完毕已列入目录的文件的列表
=======================
文件名: D:DBBAKcontrol_7atmqumb_1_1
文件名: D:DBBAKdbbakfull_74tmqt9h_1_1
文件名: D:DBBAKdbbakfull_75tmqt9h_1_1
文件名: D:DBBAKdbbakfull_76tmqt9i_1_1
文件名: D:DBBAKdbbakfull_77tmqt9i_1_1
文件名: D:DBBAKdbbakfull_78tmqted_1_1
文件名: D:DBBAKdbbakfull_79tmqteh_1_1RMAN>RMAN> run{
2> set newname for database to ‘D:oradatazlemr%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:oradatazlemr%d’ 必须包含 %f 或 %U 格式RMAN> run{
2> set newname for database to ‘D:oradatazlemr%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:oradatazlemr+DATA/zlemrdg/zldocbase.dbf
通道 ORA_DISK_1: 将数据文件 00008 还原到 D:oradatazlemr+DATA/zlemrdg/zldocdataindex.dbf
通道 ORA_DISK_1: 将数据文件 00009 还原到 D:oradatazlemr+DATA/zlemrdg/zldocxml.dbf
通道 ORA_DISK_1: 正在读取备份片段 D:DBBAKDBBAKFULL_74TMQT9H_1_1
通道 ORA_DISK_1: ORA-19870: 还原备份片段 D:DBBAKDBBAKFULL_74TMQT9H_1_1 时出错
ORA-19504: 无法创建文件”D:ORADATAZLEMR+DATAZLEMRDGZLDOCXML.DBF”
ORA-27040: 文件创建错误, 无法创建文件
OSD-04002: ？???？？?
O/S-Error: (OS 3) ？？？????？???？?????通道 ORA_DISK_1: 正在开始还原数据文件备份集
通道 ORA_DISK_1: 正在指定从备份集还原的数据文件
通道 ORA_DISK_1: 将数据文件 00001 还原到 D:oradatazlemr+DATA/zlemrdg/system01.dbf
通道 ORA_DISK_1: 将数据文件 00003 还原到 D:oradatazlemr+DATA/zlemrdg/undotbs01.dbf
通道 ORA_DISK_1: 将数据文件 00010 还原到 D:oradatazlemr+DATA/zlemrdg/sysaux02.dbf
通道 ORA_DISK_1: 正在读取备份片段 D:DBBAKDBBAKFULL_77TMQT9I_1_1
通道 ORA_DISK_1: ORA-19870: 还原备份片段 D:DBBAKDBBAKFULL_77TMQT9I_1_1 时出错
ORA-19504: 无法创建文件”D:ORADATAZLEMR+DATAZLEMRDGSYSAUX02.DBF”
ORA-27040: 文件创建错误, 无法创建文件
OSD-04002: ？???？？?
O/S-Error: (OS 3) ？？？????？???？?????通道 ORA_DISK_1: 正在开始还原数据文件备份集
通道 ORA_DISK_1: 正在指定从备份集还原的数据文件
通道 ORA_DISK_1: 将数据文件 00002 还原到 D:oradatazlemr+DATA/zlemrdg/sysaux01.dbf
通道 ORA_DISK_1: 将数据文件 00004 还原到 D:oradatazlemr+DATA/zlemrdg/users01.dbf
通道 ORA_DISK_1: 将数据文件 00007 还原到 D:oradatazlemr+DATA/zlemrdg/zldocdata.dbf
通道 ORA_DISK_1: 正在读取备份片段 D:DBBAKDBBAKFULL_76TMQT9I_1_1
通道 ORA_DISK_1: ORA-19870: 还原备份片段 D:DBBAKDBBAKFULL_76TMQT9I_1_1 时出错
ORA-19504: 无法创建文件”D:ORADATAZLEMR+DATAZLEMRDGSYSAUX01.DBF”
ORA-27040: 文件创建错误, 无法创建文件
OSD-04002: ？???？？?
O/S-Error: (OS 3) ？？？????？???？?????通道 ORA_DISK_1: 正在开始还原数据文件备份集
通道 ORA_DISK_1: 正在指定从备份集还原的数据文件
通道 ORA_DISK_1: 将数据文件 00006 还原到 D:oradatazlemr+DATA/zlemrdg/zldocindex.dbf
通道 ORA_DISK_1: 将数据文件 00011 还原到 D:oradatazlemr+DATA/zlemrdg/zldocxml01.dbf
通道 ORA_DISK_1: 将数据文件 00012 还原到 D:oradatazlemr+DATA/zlemrdg/zldocdataindex01.dbf
通道 ORA_DISK_1: 正在读取备份片段 D:DBBAKDBBAKFULL_75TMQT9H_1_1
通道 ORA_DISK_1: ORA-19870: 还原备份片段 D:DBBAKDBBAKFULL_75TMQT9H_1_1 时出错
ORA-19504: 无法创建文件”D:ORADATAZLEMR+DATAZLEMRDGZLDOCXML01.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:oradatazlemrzldocbase.dbf’;
3> set newname for datafile ‘+DATA/zlemrdg/zldocdataindex.dbf’ to ‘D:oradatazlemrzldocdataindex.dbf’;
4> set newname for datafile ‘+DATA/zlemrdg/zldocxml.dbf’ to ‘D:oradatazlemrzldocxml.dbf’;
5> set newname for datafile ‘+DATA/zlemrdg/system01.dbf’ to ‘D:oradatazlemrsystem01.dbf’;
6> set newname for datafile ‘+DATA/zlemrdg/undotbs01.dbf’ to ‘D:oradatazlemrundotbs01.dbf’;
7> set newname for datafile ‘+DATA/zlemrdg/sysaux02.dbf’ to ‘D:oradatazlemrsysaux02.dbf’;
8> set newname for datafile ‘+DATA/zlemrdg/zldocindex.dbf’ to ‘D:oradatazlemrzldocindex.dbf’;
9> set newname for datafile ‘+DATA/zlemrdg/zldocxml01.dbf’ to ‘D:oradatazlemrzldocxml01.dbf’;
10> set newname for datafile ‘+DATA/zlemrdg/zldocdataindex01.dbf’ to ‘D:oradatazlemrzldocdataindex01.dbf’;
11> set newname for datafile ‘+DATA/zlemrdg/sysaux01.dbf’ to ‘D:oradatazlemrsysaux01.dbf’;
12> set newname for datafile ‘+DATA/zlemrdg/zldocdata.dbf’ to ‘D:oradatazlemrzldocdata.dbf’;
13> set newname for datafile ‘+DATA/zlemrdg/users01.dbf’ to ‘D:oradatazlemrusers01.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:oradatazlemrzldocbase.dbf
通道 ORA_DISK_1: 将数据文件 00008 还原到 D:oradatazlemrzldocdataindex.dbf
通道 ORA_DISK_1: 将数据文件 00009 还原到 D:oradatazlemrzldocxml.dbf
通道 ORA_DISK_1: 正在读取备份片段 D:DBBAKDBBAKFULL_74TMQT9H_1_1
通道 ORA_DISK_1: 段句柄 = D:DBBAKDBBAKFULL_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:oradatazlemrsystem01.dbf
通道 ORA_DISK_1: 将数据文件 00003 还原到 D:oradatazlemrundotbs01.dbf
通道 ORA_DISK_1: 将数据文件 00010 还原到 D:oradatazlemrsysaux02.dbf
通道 ORA_DISK_1: 正在读取备份片段 D:DBBAKDBBAKFULL_77TMQT9I_1_1
通道 ORA_DISK_1: 段句柄 = D:DBBAKDBBAKFULL_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:oradatazlemrsysaux01.dbf
通道 ORA_DISK_1: 将数据文件 00004 还原到 D:oradatazlemrusers01.dbf
通道 ORA_DISK_1: 将数据文件 00007 还原到 D:oradatazlemrzldocdata.dbf
通道 ORA_DISK_1: 正在读取备份片段 D:DBBAKDBBAKFULL_76TMQT9I_1_1
通道 ORA_DISK_1: 段句柄 = D:DBBAKDBBAKFULL_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:oradatazlemrzldocindex.dbf
通道 ORA_DISK_1: 将数据文件 00011 还原到 D:oradatazlemrzldocxml01.dbf
通道 ORA_DISK_1: 将数据文件 00012 还原到 D:oradatazlemrzldocdataindex01.dbf
通道 ORA_DISK_1: 正在读取备份片段 D:DBBAKDBBAKFULL_75TMQT9H_1_1
通道 ORA_DISK_1: 段句柄 = D:DBBAKDBBAKFULL_75TMQT9H_1_1 标记 = TAG20190108T163249
通道 ORA_DISK_1: 已还原备份片段 1
通道 ORA_DISK_1: 还原完成, 用时: 00:09:06
完成 restore 于 08-1月 -19RMAN>RMAN>RMAN> switch database to copy;数据文件 1 已切换成数据文件副本 “D:ORADATAZLEMRSYSTEM01.DBF”
数据文件 2 已切换成数据文件副本 “D:ORADATAZLEMRSYSAUX01.DBF”
数据文件 3 已切换成数据文件副本 “D:ORADATAZLEMRUNDOTBS01.DBF”
数据文件 4 已切换成数据文件副本 “D:ORADATAZLEMRUSERS01.DBF”
数据文件 5 已切换成数据文件副本 “D:ORADATAZLEMRZLDOCBASE.DBF”
数据文件 6 已切换成数据文件副本 “D:ORADATAZLEMRZLDOCINDEX.DBF”
数据文件 7 已切换成数据文件副本 “D:ORADATAZLEMRZLDOCDATA.DBF”
数据文件 8 已切换成数据文件副本 “D:ORADATAZLEMRZLDOCDATAINDEX.DBF”
数据文件 9 已切换成数据文件副本 “D:ORADATAZLEMRZLDOCXML.DBF”
数据文件 10 已切换成数据文件副本 “D:ORADATAZLEMRSYSAUX02.DBF”
数据文件 11 已切换成数据文件副本 “D:ORADATAZLEMRZLDOCXML01.DBF”
数据文件 12 已切换成数据文件副本 “D:ORADATAZLEMRZLDOCDATAINDEX01.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:oradatazlemrredo03.log’;数据库已更改。SQL> alter database rename file ‘+DATA/zlemrdg/redo02.log’ to ‘D:oradatazlemrredo03.log’;
alter database rename file ‘+DATA/zlemrdg/redo02.log’ to ‘D:oradatazlemrredo03.log’
*
第 1 行出现错误:
ORA-01511: 重命名日志/数据文件时出错
ORA-01523: 无法将数据文件重命名为 ‘D:oradatazlemrredo03.log’ – 文件已是数据库的一部分
SQL> alter database rename file ‘+DATA/zlemrdg/redo02.log’ to ‘D:oradatazlemrredo02.log’;数据库已更改。SQL> alter database rename file ‘+DATA/zlemrdg/redo01.log’ to ‘D:oradatazlemrredo01.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:ORADATAZLEMRREDO03.LOG
D:ORADATAZLEMRREDO02.LOG
D:ORADATAZLEMRREDO01.LOGSQL> 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:oradatazlemrtemp02.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:ORADATAZLEMRTEMP02.DBFSQL>感谢你能够认真阅读完这篇文章，希望小编分享的“如何通过rman为客户实现linux下oracle11.2.0.4到windows下oracle同版本数据库的异机恢复”这篇文章对大家有帮助，同时也希望大家多多支持百云，关注百云行业资讯频道，更多相关知识等着你来学习!
相关推荐: Oracle在Centos7.5安装遇到的问题及解决方法
本篇内容主要讲解“Oracle在Centos7.5安装遇到的问题及解决方法”，感兴趣的朋友不妨来看看。本文介绍的方法操作简单快捷，实用性强。下面就让小编来带大家学习“Oracle在Centos7.5安装遇到的问题及解决方法”吧!一般在安装oracle时，当确定…
免责声明：本站发布的图片视频文字，以转载和分享为主，文章观点不代表本站立场，本站不承担相关法律责任；如果涉及侵权请联系邮箱：360163164@qq.com举报，并提供相关证据，经查实将立刻删除涉嫌侵权内容。
微信扫一扫 
