通过rman为客户实现linux下oracle11.2.0.4到windows下oracle同版本数据库的异机恢复。
在恢复的过程中参考了下面链接，非常感谢：
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>