温馨提示×

温馨提示×

您好，登录后才能下订单哦！

密码登录×
登录注册×
获取短信验证码
其他方式登录
点击 登录注册 即表示同意《亿速云用户服务条款》
登 录 注册有礼
云服务器 香港服务器 高防服务器
最新更新 网站标签 地图导航
产品

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

发布时间：2021-11-09 14:28:28 来源：亿速云 阅读：299 作者：小新 栏目：关系型数据库

这篇文章主要介绍了如何通过rman为客户实现linux下oracle11.2.0.4到windows下oracle同版本数据库的异机恢复，具有一定借鉴价值，感兴趣的朋友可以参考下，希望大家阅读完这篇文章之后大有收获，下面让小编带着大家一起了解一下。

下面是记录了一个恢复的过程。

[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_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.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_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:\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同版本数据库的异机恢复”这篇文章对大家有帮助，同时也希望大家多多支持亿速云，关注亿速云行业资讯频道，更多相关知识等着你来学习!

向AI问一下细节
推荐阅读：
  1. RMAN异机恢复全过程
  2. 爱数(Version: 6.0.17.0.1704)oracle rac下异机单节点恢复

免责声明：本站发布的内容（图片、视频和文字）以原创、转载和分享为主，文章观点不代表本网站立场，如果涉及侵权请联系站长邮箱：is@yisu.com进行举报，并提供相关证据，一经查实，将立刻删除涉嫌侵权内容。

linux oracle windows

猜你喜欢

最新资讯
相关推荐

相关标签

kalilinuxnethunter linux redis linux进程 linux内核 linux流 linux文件 linux命令行 linux网络编程 linux学习 linux 操作系统 linux入门 嵌入式linux llinux linux apache http redhat linux linux系统安全 suse linux linux发行版本 linux系统管理 linux centos
AI
助
手
产品服务
地区划分
专题活动
帮助支持
关于我们
售后咨询
7*24小时在线电话：400-100-2938
7*24小时在线 QQ：800811969
关注亿速云

亿速云公众号

手机网站二维码

Copyright © Yisu Cloud Ltd. All Rights Reserved. 2018 版权所有

广州亿速云计算有限公司粤ICP备17096448号-1 粤公网安备 44010402001142号增值电信业务经营许可证编号：B1-20181529