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

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

原创 Oracle 作者:warehouse 时间:2019-01-15 16:14:10 831 0

在恢复的过程中参考了下面链接,非常感谢:

https://blog.csdn.net/dsc1245/article/details/53508571


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

[root@emrdg ~]# su - oracle
[oracle@emrdg ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Tue Jan 8 16:39:12 2019

Copyright (c) 1982, 2013, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options

SQL> select status from v$instance;

STATUS
------------------------
MOUNTED

--==================
首先要在mount下通过rman对数据库做一个全备份:
[oracle@emrdg ~]$ rman target /

Recovery Manager: Release 11.2.0.4.0 - Production on Tue Jan 8 16:32:39 2019

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to target database: ZLEMR (DBID=88360475, not open)

RMAN> run{
2> allocate channel c1 device type disk;
3> allocate channel c2 device type disk;
4> allocate channel c3 device type disk;
5> allocate channel c4 device type disk;
6> backup as compressed backupset database format ‘\dbbak\full_%U‘;
7> }

using target database control file instead of recovery catalog
allocated channel: c1
channel c1: SID=762 device type=DISK

allocated channel: c2
channel c2: SID=1519 device type=DISK

allocated channel: c3
channel c3: SID=2276 device type=DISK

allocated channel: c4
channel c4: SID=7 device type=DISK

Starting backup at 2019-01-08 16:32:49
channel c1: starting compressed full datafile backup set
channel c1: specifying datafile(s) in backup set
input datafile file number=00009 name=+DATA/zlemrdg/zldocxml.dbf
input datafile file number=00008 name=+DATA/zlemrdg/zldocdataindex.dbf
input datafile file number=00005 name=+DATA/zlemrdg/zldocbase.dbf
channel c1: starting piece 1 at 2019-01-08 16:32:49
channel c2: starting compressed full datafile backup set
channel c2: specifying datafile(s) in backup set
input datafile file number=00011 name=+DATA/zlemrdg/zldocxml01.dbf
input datafile file number=00012 name=+DATA/zlemrdg/zldocdataindex01.dbf
input datafile file number=00006 name=+DATA/zlemrdg/zldocindex.dbf
channel c2: starting piece 1 at 2019-01-08 16:32:50
channel c3: starting compressed full datafile backup set
channel c3: specifying datafile(s) in backup set
input datafile file number=00002 name=+DATA/zlemrdg/sysaux01.dbf
input datafile file number=00007 name=+DATA/zlemrdg/zldocdata.dbf
input datafile file number=00004 name=+DATA/zlemrdg/users01.dbf
channel c3: starting piece 1 at 2019-01-08 16:32:50
channel c4: starting compressed full datafile backup set
channel c4: specifying datafile(s) in backup set
input datafile file number=00010 name=+DATA/zlemrdg/sysaux02.dbf
input datafile file number=00001 name=+DATA/zlemrdg/system01.dbf
input datafile file number=00003 name=+DATA/zlemrdg/undotbs01.dbf
channel c4: starting piece 1 at 2019-01-08 16:32:50
channel c4: finished piece 1 at 2019-01-08 16:35:25
piece handle=/u01/app/oracle/product/11.2.0.4/dbhome_1/dbs/dbbakfull_77tmqt9i_1_1 tag=TAG20190108T163249 comment=NONE
channel c4: backup set complete, elapsed time: 00:02:35
channel c4: starting compressed full datafile backup set
channel c4: specifying datafile(s) in backup set
including current control file in backup set
channel c4: starting piece 1 at 2019-01-08 16:35:28
channel c4: finished piece 1 at 2019-01-08 16:35:29
piece handle=/u01/app/oracle/product/11.2.0.4/dbhome_1/dbs/dbbakfull_78tmqted_1_1 tag=TAG20190108T163249 comment=NONE
channel c4: backup set complete, elapsed time: 00:00:01
channel c4: starting compressed full datafile backup set
channel c4: specifying datafile(s) in backup set
including current SPFILE in backup set
channel c4: starting piece 1 at 2019-01-08 16:35:29
channel c4: finished piece 1 at 2019-01-08 16:35:30
piece handle=/u01/app/oracle/product/11.2.0.4/dbhome_1/dbs/dbbakfull_79tmqteh_1_1 tag=TAG20190108T163249 comment=NONE
channel c4: backup set complete, elapsed time: 00:00:01

channel c3: finished piece 1 at 2019-01-08 16:37:04
piece handle=/u01/app/oracle/product/11.2.0.4/dbhome_1/dbs/dbbakfull_76tmqt9i_1_1 tag=TAG20190108T163249 comment=NONE
channel c3: backup set complete, elapsed time: 00:04:14

channel c2: finished piece 1 at 2019-01-08 16:38:14
piece handle=/u01/app/oracle/product/11.2.0.4/dbhome_1/dbs/dbbakfull_75tmqt9h_1_1 tag=TAG20190108T163249 comment=NONE
channel c2: backup set complete, elapsed time: 00:05:24



channel c1: finished piece 1 at 2019-01-08 16:55:44
piece handle=/u01/app/oracle/product/11.2.0.4/dbhome_1/dbs/dbbakfull_74tmqt9h_1_1 tag=TAG20190108T163249 comment=NONE
channel c1: backup set complete, elapsed time: 00:22:55
Finished backup at 2019-01-08 16:55:44
released channel: c1
released channel: c2
released channel: c3
released channel: c4

RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN> backup current controlfile format ‘/dbbak/control_%U‘;

Starting backup at 2019-01-08 16:56:43
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=762 device type=DISK
channel ORA_DISK_1: starting compressed full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current control file in backup set
channel ORA_DISK_1: starting piece 1 at 2019-01-08 16:56:44
channel ORA_DISK_1: finished piece 1 at 2019-01-08 16:56:45
piece handle=/dbbak/control_7atmqumb_1_1 tag=TAG20190108T165643 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 2019-01-08 16:56:45

RMAN>


SQL> col units format a10
SQL> Select sofar,totalwork,units,TIME_REMAINING, ELAPSED_SECONDS from v$session_longops where sofar<>totalwork;

     SOFAR  TOTALWORK UNITS      TIME_REMAINING ELAPSED_SECONDS
---------- ---------- ---------- -------------- ---------------
   4423032    8528960 Blocks                486             524
   1184638    2435456 Blocks                660             625
   1145749          0 Blocks                                625
   2914993          0 Blocks                                398

SQL> Select sofar,totalwork,units,TIME_REMAINING, ELAPSED_SECONDS from v$session_longops where sofar<>totalwork;

     SOFAR  TOTALWORK UNITS      TIME_REMAINING ELAPSED_SECONDS
---------- ---------- ---------- -------------- ---------------
   4423032    8528960 Blocks                486             524
   1203326    2435456 Blocks                654             639
   1164437          0 Blocks                                639
   2914993          0 Blocks                                398

SQL> Select sofar,totalwork,units,TIME_REMAINING, ELAPSED_SECONDS from v$session_longops where sofar<>totalwork;

     SOFAR  TOTALWORK UNITS      TIME_REMAINING ELAPSED_SECONDS
---------- ---------- ---------- -------------- ---------------
   4601336    8528960 Blocks                551             645
   1228926    2435456 Blocks                643             655
   1190037          0 Blocks                                655
   3093297          0 Blocks                                519

SQL> Select sofar,totalwork,units,TIME_REMAINING, ELAPSED_SECONDS from v$session_longops where sofar<>totalwork;

     SOFAR  TOTALWORK UNITS      TIME_REMAINING ELAPSED_SECONDS
---------- ---------- ---------- -------------- ---------------
   4601336    8528960 Blocks                551             645
   1252350    2435456 Blocks                634             671
   1213461          0 Blocks                                671
   3093297          0 Blocks                                519

SQL> Select sofar,totalwork,units,TIME_REMAINING, ELAPSED_SECONDS from v$session_longops where sofar<>totalwork;

     SOFAR  TOTALWORK UNITS      TIME_REMAINING ELAPSED_SECONDS
---------- ---------- ---------- -------------- ---------------
   4601336    8528960 Blocks                551             645
   1260798    2435456 Blocks                631             677
   1221909          0 Blocks                                677
   3093297          0 Blocks                                519

SQL> Select sofar,totalwork,units,TIME_REMAINING, ELAPSED_SECONDS from v$session_longops where sofar<>totalwork;

     SOFAR  TOTALWORK UNITS      TIME_REMAINING ELAPSED_SECONDS
---------- ---------- ---------- -------------- ---------------
   4973816    8528960 Blocks                633             885
   1714046    2435456 Blocks                407             967
   1675120          0 Blocks                                967
   3465769          0 Blocks                                759

SQL> Select sofar,totalwork,units,TIME_REMAINING, ELAPSED_SECONDS from v$session_longops where sofar<>totalwork;

     SOFAR  TOTALWORK UNITS      TIME_REMAINING ELAPSED_SECONDS
---------- ---------- ---------- -------------- ---------------
   5338872    8528960 Blocks                672            1125
   2066046    2435456 Blocks                213            1190
   2026076          0 Blocks                               1190
   3830226          0 Blocks                                999

SQL> host
[oracle@emrdg ~]$ pwd
/home/oracle
[oracle@emrdg ~]$ exit
exit

SQL> Select sofar,totalwork,units,TIME_REMAINING, ELAPSED_SECONDS from v$session_longops where sofar<>totalwork;

     SOFAR  TOTALWORK UNITS      TIME_REMAINING ELAPSED_SECONDS
---------- ---------- ---------- -------------- ---------------
   5338872    8528960 Blocks                672            1125
   2120190    2435456 Blocks                182            1223
   2080220          0 Blocks                               1223
   3830226          0 Blocks                                999

SQL> select group#,status,bytes v$log;
select group#,status,bytes v$log
                               *
ERROR at line 1:
ORA-00923: FROM keyword not found where expected


SQL> select group#,status,bytes from v$log;

    GROUP# STATUS                                BYTES
---------- -------------------------------- ----------
         1 CURRENT                            52428800
         3 INACTIVE                           52428800
         2 INACTIVE                           52428800

SQL> select member from v$logfile;

MEMBER
--------------------------------------------------------------------------------
+DATA/zlemrdg/redo03.log
+DATA/zlemrdg/redo02.log
+DATA/zlemrdg/redo01.log
+DATA/zlemrdg/std_redo04.log
+DATA/zlemrdg/std_redo05.log
+DATA/zlemrdg/std_redo06.log
+DATA/zlemrdg/std_redo07.log

7 rows selected.

SQL> desc v$logfile;
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 GROUP#                                             NUMBER
 STATUS                                             VARCHAR2(7)
 TYPE                                               VARCHAR2(7)
 MEMBER                                             VARCHAR2(513)
 IS_RECOVERY_DEST_FILE                              VARCHAR2(3)

SQL> col member format a40
SQL> SELECT TYPE,STATUS,MEMBER FROM V$LOGFILE;

TYPE           STATUS         MEMBER
-------------- -------------- ----------------------------------------
ONLINE                        +DATA/zlemrdg/redo03.log
ONLINE                        +DATA/zlemrdg/redo02.log
ONLINE                        +DATA/zlemrdg/redo01.log
STANDBY                       +DATA/zlemrdg/std_redo04.log
STANDBY                       +DATA/zlemrdg/std_redo05.log
STANDBY                       +DATA/zlemrdg/std_redo06.log
STANDBY                       +DATA/zlemrdg/std_redo07.log

7 rows selected.

SQL> Select sofar,totalwork,units,TIME_REMAINING, ELAPSED_SECONDS from v$session_longops where sofar<>totalwork;

     SOFAR  TOTALWORK UNITS      TIME_REMAINING ELAPSED_SECONDS
---------- ---------- ---------- -------------- ---------------
   5542264    8528960 Blocks                671            1245
   2343806    2435456 Blocks                 53            1363
   2303228          0 Blocks                               1363
   4033140          0 Blocks                               1119

SQL> Select sofar,totalwork,units,TIME_REMAINING, ELAPSED_SECONDS from v$session_longops where sofar<>totalwork;

no rows selected

SQL> HOST
[oracle@emrdg ~]$ ls
dbbak  oradiag_oracle  orapwzlemr  pfile  pfile.ora  temp
[oracle@emrdg ~]$ cd /dbbak
[oracle@emrdg dbbak]$ ls
control_7atmqumb_1_1
[oracle@emrdg dbbak]$ exit
exit

SQL> alter database open;

Database altered.

SQL>

--==========================
C:\>rman target /

恢复管理器: Release 11.2.0.4.0 - Production on 星期二 1月 8 17:04:12 2019

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

已连接到目标数据库: EMRTEST1 (未装载)

RMAN> restore controlfile from
2>  ‘d:/dbbak/control_7atmqumb_1_1‘;

启动 restore 于 08-1月 -19
使用目标数据库控制文件替代恢复目录
分配的通道: ORA_DISK_1
通道 ORA_DISK_1: SID=10 设备类型=DISK

通道 ORA_DISK_1: 正在还原控制文件
通道 ORA_DISK_1: 还原完成, 用时: 00:00:01
输出文件名=D:\ORADATA\EMRTEST1\CONTROL01.CTL
输出文件名=C:\APP\ADMINISTRATOR\FAST_RECOVERY_AREA\EMRTEST1\CONTROL02.CTL
完成 restore 于 08-1月 -19

RMAN>

RMAN> exit


恢复管理器完成。

C:\>sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on 星期二 1月 8 17:05:47 2019

Copyright (c) 1982, 2013, Oracle.  All rights reserved.


连接到:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> show parameter control_files

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
control_files                        string      D:\ORADATA\EMRTEST1\CONTROL01.
                                                 CTL, C:\APP\ADMINISTRATOR\FAST
                                                 _RECOVERY_AREA\EMRTEST1\CONTRO
                                                 L02.CTL
SQL> alter database mount;
alter database mount
*
第 1 行出现错误:
ORA-01103: 控制文件中的数据库名 ‘‘ZLEMR‘‘ 不是 ‘‘EMRTEST1‘‘


SQL> shutdown immediate
ORA-01507: 未装载数据库


ORACLE 例程已经关闭。
SQL>

--=============================
C:\>sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on 星期二 1月 8 17:23:16 2019

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

已连接到空闲例程。

SQL> startup nomount
ORACLE 例程已经启动。

Total System Global Area 4175568896 bytes
Fixed Size                  2287832 bytes
Variable Size            1140852520 bytes
Database Buffers         3019898880 bytes
Redo Buffers               12529664 bytes
SQL> exit
从 Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options 断开

C:\>rman target /

恢复管理器: Release 11.2.0.4.0 - Production on 星期二 1月 8 17:23:28 2019

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

已连接到目标数据库: ZLEMR (未装载)

RMAN> restore controlfile from ‘d:\dbbak\control_7atmqumb_1_1‘;

启动 restore 于 08-1月 -19
使用目标数据库控制文件替代恢复目录
分配的通道: ORA_DISK_1
通道 ORA_DISK_1: SID=772 设备类型=DISK

通道 ORA_DISK_1: 正在还原控制文件
通道 ORA_DISK_1: 还原完成, 用时: 00:00:01
输出文件名=D:\ORADATA\ZLEMR\CONTROL01.CTL
输出文件名=C:\APP\ADMINISTRATOR\FAST_RECOVERY_AREA\ZLEMR\CONTROL02.CTL
完成 restore 于 08-1月 -19

RMAN> alter database mount;

数据库已装载
释放的通道: ORA_DISK_1

RMAN>

RMAN> crosscheck backup;

启动 implicit crosscheck backup 于 08-1月 -19
分配的通道: ORA_DISK_1
通道 ORA_DISK_1: SID=772 设备类型=DISK
已交叉检验的 62 对象
完成 implicit crosscheck backup 于 08-1月 -19

启动 implicit crosscheck copy 于 08-1月 -19
使用通道 ORA_DISK_1
完成 implicit crosscheck copy 于 08-1月 -19

搜索恢复区中的所有文件
正在编制文件目录...
没有为文件编制目录

使用通道 ORA_DISK_1
交叉校验备份片段: 找到为 ‘EXPIRED‘
备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190101_5ctm9465_1_1.bak RECID=13759 STAMP=996446405
交叉校验备份片段: 找到为 ‘EXPIRED‘
备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190101_5ctm9465_2_1.bak RECID=13760 STAMP=996447567
交叉校验备份片段: 找到为 ‘EXPIRED‘
备份片段句柄=+ARCH/backup/arch_20190101_5htm95mt_1_1.bak RECID=13761 STAMP=996447965
交叉校验备份片段: 找到为 ‘EXPIRED‘
备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190102_5ltmboi6_1_1.bak RECID=13765 STAMP=996532806
交叉校验备份片段: 找到为 ‘EXPIRED‘
备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190102_5mtmbp0n_1_1.bak RECID=13766 STAMP=996533272
交叉校验备份片段: 找到为 ‘EXPIRED‘
备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190102_5ktmboi6_1_1.bak RECID=13768 STAMP=996532806
交叉校验备份片段: 找到为 ‘EXPIRED‘
备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190102_5ktmboi6_2_1.bak RECID=13769 STAMP=996533958
交叉校验备份片段: 找到为 ‘EXPIRED‘
备份片段句柄=+ARCH/backup/arch_20190102_5otmbq2j_1_1.bak RECID=13770 STAMP=996534355
交叉校验备份片段: 找到为 ‘EXPIRED‘
备份片段句柄=+ARCH/backup/arch_20190102_5ptmbq2j_1_1.bak RECID=13771 STAMP=996534355
交叉校验备份片段: 找到为 ‘EXPIRED‘
备份片段句柄=+ARCH/backup/spfile_wyhis_20190102_5qtmbq2r_1_1.ora RECID=13772 STAMP=996534363
交叉校验备份片段: 找到为 ‘EXPIRED‘
备份片段句柄=+ARCH/backup/ctrl_wyhis_20190102_5rtmbq2s_1_1.bak RECID=13773 STAMP=996534365
交叉校验备份片段: 找到为 ‘EXPIRED‘
备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190103_5ttmecu5_1_1.bak RECID=13774 STAMP=996619205
交叉校验备份片段: 找到为 ‘EXPIRED‘
备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190103_5utmedcm_1_1.bak RECID=13775 STAMP=996619671
交叉校验备份片段: 找到为 ‘EXPIRED‘
备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190103_5vtmedco_1_1.bak RECID=13776 STAMP=996619672
交叉校验备份片段: 找到为 ‘EXPIRED‘
备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190103_5stmecu5_1_1.bak RECID=13777 STAMP=996619205
交叉校验备份片段: 找到为 ‘EXPIRED‘
备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190103_5stmecu5_2_1.bak RECID=13778 STAMP=996620358
交叉校验备份片段: 找到为 ‘EXPIRED‘
备份片段句柄=+ARCH/backup/arch_20190103_61tmeeej_1_1.bak RECID=13779 STAMP=996620755
交叉校验备份片段: 找到为 ‘EXPIRED‘
备份片段句柄=+ARCH/backup/arch_20190103_60tmeeej_1_1.bak RECID=13780 STAMP=996620755
交叉校验备份片段: 找到为 ‘EXPIRED‘
备份片段句柄=+ARCH/backup/spfile_wyhis_20190103_62tmeeeq_1_1.ora RECID=13781 STAMP=996620762
交叉校验备份片段: 找到为 ‘EXPIRED‘
备份片段句柄=+ARCH/backup/ctrl_wyhis_20190103_63tmeeer_1_1.bak RECID=13782 STAMP=996620764
交叉校验备份片段: 找到为 ‘EXPIRED‘
备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190104_65tmh1a5_1_1.bak RECID=13783 STAMP=996705605
交叉校验备份片段: 找到为 ‘EXPIRED‘
备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190104_66tmh1om_1_1.bak RECID=13784 STAMP=996706071
交叉校验备份片段: 找到为 ‘EXPIRED‘
备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190104_67tmh1oo_1_1.bak RECID=13785 STAMP=996706072
交叉校验备份片段: 找到为 ‘EXPIRED‘
备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190104_64tmh1a5_1_1.bak RECID=13786 STAMP=996705605
交叉校验备份片段: 找到为 ‘EXPIRED‘
备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190104_64tmh1a5_2_1.bak RECID=13787 STAMP=996706768
交叉校验备份片段: 找到为 ‘EXPIRED‘
备份片段句柄=+ARCH/backup/arch_20190104_68tmh2qu_1_1.bak RECID=13788 STAMP=996707166
交叉校验备份片段: 找到为 ‘EXPIRED‘
备份片段句柄=+ARCH/backup/arch_20190104_69tmh2qu_1_1.bak RECID=13789 STAMP=996707166
交叉校验备份片段: 找到为 ‘EXPIRED‘
备份片段句柄=+ARCH/backup/spfile_wyhis_20190104_6atmh2r5_1_1.ora RECID=13790 STAMP=996707173
交叉校验备份片段: 找到为 ‘EXPIRED‘
备份片段句柄=+ARCH/backup/ctrl_wyhis_20190104_6btmh2r6_1_1.bak RECID=13791 STAMP=996707175
交叉校验备份片段: 找到为 ‘EXPIRED‘
备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190105_6dtmjlm5_1_1.bak RECID=13792 STAMP=996792006
交叉校验备份片段: 找到为 ‘EXPIRED‘
备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190105_6etmjm4n_1_1.bak RECID=13793 STAMP=996792472
交叉校验备份片段: 找到为 ‘EXPIRED‘
备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190105_6ftmjm4p_1_1.bak RECID=13794 STAMP=996792473
交叉校验备份片段: 找到为 ‘EXPIRED‘
备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190105_6ctmjlm5_1_1.bak RECID=13795 STAMP=996792005
交叉校验备份片段: 找到为 ‘EXPIRED‘
备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190105_6ctmjlm5_2_1.bak RECID=13796 STAMP=996793168
交叉校验备份片段: 找到为 ‘EXPIRED‘
备份片段句柄=+ARCH/backup/arch_20190105_6htmjn6s_1_1.bak RECID=13797 STAMP=996793564
交叉校验备份片段: 找到为 ‘EXPIRED‘
备份片段句柄=+ARCH/backup/arch_20190105_6gtmjn6s_1_1.bak RECID=13798 STAMP=996793564
交叉校验备份片段: 找到为 ‘EXPIRED‘
备份片段句柄=+ARCH/backup/spfile_wyhis_20190105_6itmjn74_1_1.ora RECID=13799 STAMP=996793572
交叉校验备份片段: 找到为 ‘EXPIRED‘
备份片段句柄=+ARCH/backup/ctrl_wyhis_20190105_6jtmjn75_1_1.bak RECID=13800 STAMP=996793574
交叉校验备份片段: 找到为 ‘EXPIRED‘
备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190106_6ltmma25_1_1.bak RECID=13801 STAMP=996878406
交叉校验备份片段: 找到为 ‘EXPIRED‘
备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190106_6mtmmagn_1_1.bak RECID=13802 STAMP=996878872
交叉校验备份片段: 找到为 ‘EXPIRED‘
备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190106_6ntmmagp_1_1.bak RECID=13803 STAMP=996878873
交叉校验备份片段: 找到为 ‘EXPIRED‘
备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190106_6ktmma25_1_1.bak RECID=13804 STAMP=996878405
交叉校验备份片段: 找到为 ‘EXPIRED‘
备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190106_6ktmma25_2_1.bak RECID=13805 STAMP=996879568
交叉校验备份片段: 找到为 ‘EXPIRED‘
备份片段句柄=+ARCH/backup/arch_20190106_6ptmmbj8_1_1.bak RECID=13806 STAMP=996879976
交叉校验备份片段: 找到为 ‘EXPIRED‘
备份片段句柄=+ARCH/backup/arch_20190106_6otmmbj8_1_1.bak RECID=13807 STAMP=996879976
交叉校验备份片段: 找到为 ‘EXPIRED‘
备份片段句柄=+ARCH/backup/spfile_wyhis_20190106_6qtmmbjf_1_1.ora RECID=13808 STAMP=996879983
交叉校验备份片段: 找到为 ‘EXPIRED‘
备份片段句柄=+ARCH/backup/ctrl_wyhis_20190106_6rtmmbjg_1_1.bak RECID=13809 STAMP=996879985
交叉校验备份片段: 找到为 ‘EXPIRED‘
备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190107_6ttmoue6_1_1.bak RECID=13810 STAMP=996964806
交叉校验备份片段: 找到为 ‘EXPIRED‘
备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190107_6utmousn_1_1.bak RECID=13811 STAMP=996965272
交叉校验备份片段: 找到为 ‘EXPIRED‘
备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190107_6vtmousp_1_1.bak RECID=13812 STAMP=996965273
交叉校验备份片段: 找到为 ‘EXPIRED‘
备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190107_6stmoue6_1_1.bak RECID=13813 STAMP=996964806
交叉校验备份片段: 找到为 ‘EXPIRED‘
备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190107_6stmoue6_2_1.bak RECID=13814 STAMP=996965959
交叉校验备份片段: 找到为 ‘EXPIRED‘
备份片段句柄=+ARCH/backup/arch_20190107_71tmovuj_1_1.bak RECID=13815 STAMP=996966355
交叉校验备份片段: 找到为 ‘EXPIRED‘
备份片段句柄=+ARCH/backup/arch_20190107_70tmovuj_1_1.bak RECID=13816 STAMP=996966355
交叉校验备份片段: 找到为 ‘EXPIRED‘
备份片段句柄=+ARCH/backup/spfile_wyhis_20190107_72tmovuq_1_1.ora RECID=13817 STAMP=996966362
交叉校验备份片段: 找到为 ‘EXPIRED‘
备份片段句柄=+ARCH/backup/ctrl_wyhis_20190107_73tmovur_1_1.bak RECID=13818 STAMP=996966364
交叉校验备份片段: 找到为 ‘EXPIRED‘
备份片段句柄=/u01/app/oracle/product/11.2.0.4/dbhome_1/dbs/dbbakfull_77tmqt9i_1_1 RECID=13819 STAMP=997029170
交叉校验备份片段: 找到为 ‘EXPIRED‘
备份片段句柄=/u01/app/oracle/product/11.2.0.4/dbhome_1/dbs/dbbakfull_78tmqted_1_1 RECID=13820 STAMP=997029328
交叉校验备份片段: 找到为 ‘EXPIRED‘
备份片段句柄=/u01/app/oracle/product/11.2.0.4/dbhome_1/dbs/dbbakfull_79tmqteh_1_1 RECID=13821 STAMP=997029329
交叉校验备份片段: 找到为 ‘EXPIRED‘
备份片段句柄=/u01/app/oracle/product/11.2.0.4/dbhome_1/dbs/dbbakfull_76tmqt9i_1_1 RECID=13822 STAMP=997029170
交叉校验备份片段: 找到为 ‘EXPIRED‘
备份片段句柄=/u01/app/oracle/product/11.2.0.4/dbhome_1/dbs/dbbakfull_75tmqt9h_1_1 RECID=13823 STAMP=997029170
交叉校验备份片段: 找到为 ‘EXPIRED‘
备份片段句柄=/u01/app/oracle/product/11.2.0.4/dbhome_1/dbs/dbbakfull_74tmqt9h_1_1 RECID=13824 STAMP=997029169
已交叉检验的 62 对象


RMAN>
RMAN> delete expired backup;

使用通道 ORA_DISK_1

备份片段列表
BP 关键字  BS 关键字  Pc# Cp# 状态      设备类型段名称
------- ------- --- --- ----------- ----------- ----------
13759   13466   1   1   EXPIRED     DISK        +ARCH/backup/zlemr_dbwhole_20190101_5ctm9465_1_1.bak
13760   13466   2   1   EXPIRED     DISK        +ARCH/backup/zlemr_dbwhole_20190101_5ctm9465_2_1.bak
13761   13467   1   1   EXPIRED     DISK        +ARCH/backup/arch_20190101_5htm95mt_1_1.bak
13765   13471   1   1   EXPIRED     DISK        +ARCH/backup/zlemr_dbwhole_20190102_5ltmboi6_1_1.bak
13766   13472   1   1   EXPIRED     DISK        +ARCH/backup/zlemr_dbwhole_20190102_5mtmbp0n_1_1.bak
13768   13474   1   1   EXPIRED     DISK        +ARCH/backup/zlemr_dbwhole_20190102_5ktmboi6_1_1.bak
13769   13474   2   1   EXPIRED     DISK        +ARCH/backup/zlemr_dbwhole_20190102_5ktmboi6_2_1.bak
13770   13475   1   1   EXPIRED     DISK        +ARCH/backup/arch_20190102_5otmbq2j_1_1.bak
13771   13476   1   1   EXPIRED     DISK        +ARCH/backup/arch_20190102_5ptmbq2j_1_1.bak
13772   13477   1   1   EXPIRED     DISK        +ARCH/backup/spfile_wyhis_20190102_5qtmbq2r_1_1.ora
13773   13478   1   1   EXPIRED     DISK        +ARCH/backup/ctrl_wyhis_20190102_5rtmbq2s_1_1.bak
13774   13479   1   1   EXPIRED     DISK        +ARCH/backup/zlemr_dbwhole_20190103_5ttmecu5_1_1.bak
13775   13480   1   1   EXPIRED     DISK        +ARCH/backup/zlemr_dbwhole_20190103_5utmedcm_1_1.bak
13776   13481   1   1   EXPIRED     DISK        +ARCH/backup/zlemr_dbwhole_20190103_5vtmedco_1_1.bak
13777   13482   1   1   EXPIRED     DISK        +ARCH/backup/zlemr_dbwhole_20190103_5stmecu5_1_1.bak
13778   13482   2   1   EXPIRED     DISK        +ARCH/backup/zlemr_dbwhole_20190103_5stmecu5_2_1.bak
13779   13483   1   1   EXPIRED     DISK        +ARCH/backup/arch_20190103_61tmeeej_1_1.bak
13780   13484   1   1   EXPIRED     DISK        +ARCH/backup/arch_20190103_60tmeeej_1_1.bak
13781   13485   1   1   EXPIRED     DISK        +ARCH/backup/spfile_wyhis_20190103_62tmeeeq_1_1.ora
13782   13486   1   1   EXPIRED     DISK        +ARCH/backup/ctrl_wyhis_20190103_63tmeeer_1_1.bak
13783   13487   1   1   EXPIRED     DISK        +ARCH/backup/zlemr_dbwhole_20190104_65tmh1a5_1_1.bak
13784   13488   1   1   EXPIRED     DISK        +ARCH/backup/zlemr_dbwhole_20190104_66tmh1om_1_1.bak
13785   13489   1   1   EXPIRED     DISK        +ARCH/backup/zlemr_dbwhole_20190104_67tmh1oo_1_1.bak
13786   13490   1   1   EXPIRED     DISK        +ARCH/backup/zlemr_dbwhole_20190104_64tmh1a5_1_1.bak
13787   13490   2   1   EXPIRED     DISK        +ARCH/backup/zlemr_dbwhole_20190104_64tmh1a5_2_1.bak
13788   13491   1   1   EXPIRED     DISK        +ARCH/backup/arch_20190104_68tmh2qu_1_1.bak
13789   13492   1   1   EXPIRED     DISK        +ARCH/backup/arch_20190104_69tmh2qu_1_1.bak
13790   13493   1   1   EXPIRED     DISK        +ARCH/backup/spfile_wyhis_20190104_6atmh2r5_1_1.ora
13791   13494   1   1   EXPIRED     DISK        +ARCH/backup/ctrl_wyhis_20190104_6btmh2r6_1_1.bak
13792   13495   1   1   EXPIRED     DISK        +ARCH/backup/zlemr_dbwhole_20190105_6dtmjlm5_1_1.bak
13793   13496   1   1   EXPIRED     DISK        +ARCH/backup/zlemr_dbwhole_20190105_6etmjm4n_1_1.bak
13794   13497   1   1   EXPIRED     DISK        +ARCH/backup/zlemr_dbwhole_20190105_6ftmjm4p_1_1.bak
13795   13498   1   1   EXPIRED     DISK        +ARCH/backup/zlemr_dbwhole_20190105_6ctmjlm5_1_1.bak
13796   13498   2   1   EXPIRED     DISK        +ARCH/backup/zlemr_dbwhole_20190105_6ctmjlm5_2_1.bak
13797   13499   1   1   EXPIRED     DISK        +ARCH/backup/arch_20190105_6htmjn6s_1_1.bak
13798   13500   1   1   EXPIRED     DISK        +ARCH/backup/arch_20190105_6gtmjn6s_1_1.bak
13799   13501   1   1   EXPIRED     DISK        +ARCH/backup/spfile_wyhis_20190105_6itmjn74_1_1.ora
13800   13502   1   1   EXPIRED     DISK        +ARCH/backup/ctrl_wyhis_20190105_6jtmjn75_1_1.bak
13801   13503   1   1   EXPIRED     DISK        +ARCH/backup/zlemr_dbwhole_20190106_6ltmma25_1_1.bak
13802   13504   1   1   EXPIRED     DISK        +ARCH/backup/zlemr_dbwhole_20190106_6mtmmagn_1_1.bak
13803   13505   1   1   EXPIRED     DISK        +ARCH/backup/zlemr_dbwhole_20190106_6ntmmagp_1_1.bak
13804   13506   1   1   EXPIRED     DISK        +ARCH/backup/zlemr_dbwhole_20190106_6ktmma25_1_1.bak
13805   13506   2   1   EXPIRED     DISK        +ARCH/backup/zlemr_dbwhole_20190106_6ktmma25_2_1.bak
13806   13507   1   1   EXPIRED     DISK        +ARCH/backup/arch_20190106_6ptmmbj8_1_1.bak
13807   13508   1   1   EXPIRED     DISK        +ARCH/backup/arch_20190106_6otmmbj8_1_1.bak
13808   13509   1   1   EXPIRED     DISK        +ARCH/backup/spfile_wyhis_20190106_6qtmmbjf_1_1.ora
13809   13510   1   1   EXPIRED     DISK        +ARCH/backup/ctrl_wyhis_20190106_6rtmmbjg_1_1.bak
13810   13511   1   1   EXPIRED     DISK        +ARCH/backup/zlemr_dbwhole_20190107_6ttmoue6_1_1.bak
13811   13512   1   1   EXPIRED     DISK        +ARCH/backup/zlemr_dbwhole_20190107_6utmousn_1_1.bak
13812   13513   1   1   EXPIRED     DISK        +ARCH/backup/zlemr_dbwhole_20190107_6vtmousp_1_1.bak
13813   13514   1   1   EXPIRED     DISK        +ARCH/backup/zlemr_dbwhole_20190107_6stmoue6_1_1.bak
13814   13514   2   1   EXPIRED     DISK        +ARCH/backup/zlemr_dbwhole_20190107_6stmoue6_2_1.bak
13815   13515   1   1   EXPIRED     DISK        +ARCH/backup/arch_20190107_71tmovuj_1_1.bak
13816   13516   1   1   EXPIRED     DISK        +ARCH/backup/arch_20190107_70tmovuj_1_1.bak
13817   13517   1   1   EXPIRED     DISK        +ARCH/backup/spfile_wyhis_20190107_72tmovuq_1_1.ora
13818   13518   1   1   EXPIRED     DISK        +ARCH/backup/ctrl_wyhis_20190107_73tmovur_1_1.bak
13819   13519   1   1   EXPIRED     DISK        /u01/app/oracle/product/11.2.0.4/dbhome_1/dbs/dbbakfull_77tmqt9i_1_1
13820   13520   1   1   EXPIRED     DISK        /u01/app/oracle/product/11.2.0.4/dbhome_1/dbs/dbbakfull_78tmqted_1_1
13821   13521   1   1   EXPIRED     DISK        /u01/app/oracle/product/11.2.0.4/dbhome_1/dbs/dbbakfull_79tmqteh_1_1
13822   13522   1   1   EXPIRED     DISK        /u01/app/oracle/product/11.2.0.4/dbhome_1/dbs/dbbakfull_76tmqt9i_1_1
13823   13523   1   1   EXPIRED     DISK        /u01/app/oracle/product/11.2.0.4/dbhome_1/dbs/dbbakfull_75tmqt9h_1_1
13824   13524   1   1   EXPIRED     DISK        /u01/app/oracle/product/11.2.0.4/dbhome_1/dbs/dbbakfull_74tmqt9h_1_1

是否确定要删除以上对象 (输入 YES 或 NO)? yes
已删除备份片段
备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190101_5ctm9465_1_1.bak RECID=13759 STAMP=996446405
已删除备份片段
备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190101_5ctm9465_2_1.bak RECID=13760 STAMP=996447567
已删除备份片段
备份片段句柄=+ARCH/backup/arch_20190101_5htm95mt_1_1.bak RECID=13761 STAMP=996447965
已删除备份片段
备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190102_5ltmboi6_1_1.bak RECID=13765 STAMP=996532806
已删除备份片段
备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190102_5mtmbp0n_1_1.bak RECID=13766 STAMP=996533272
已删除备份片段
备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190102_5ktmboi6_1_1.bak RECID=13768 STAMP=996532806
已删除备份片段
备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190102_5ktmboi6_2_1.bak RECID=13769 STAMP=996533958
已删除备份片段
备份片段句柄=+ARCH/backup/arch_20190102_5otmbq2j_1_1.bak RECID=13770 STAMP=996534355
已删除备份片段
备份片段句柄=+ARCH/backup/arch_20190102_5ptmbq2j_1_1.bak RECID=13771 STAMP=996534355
已删除备份片段
备份片段句柄=+ARCH/backup/spfile_wyhis_20190102_5qtmbq2r_1_1.ora RECID=13772 STAMP=996534363
已删除备份片段
备份片段句柄=+ARCH/backup/ctrl_wyhis_20190102_5rtmbq2s_1_1.bak RECID=13773 STAMP=996534365
已删除备份片段
备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190103_5ttmecu5_1_1.bak RECID=13774 STAMP=996619205
已删除备份片段
备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190103_5utmedcm_1_1.bak RECID=13775 STAMP=996619671
已删除备份片段
备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190103_5vtmedco_1_1.bak RECID=13776 STAMP=996619672
已删除备份片段
备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190103_5stmecu5_1_1.bak RECID=13777 STAMP=996619205
已删除备份片段
备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190103_5stmecu5_2_1.bak RECID=13778 STAMP=996620358
已删除备份片段
备份片段句柄=+ARCH/backup/arch_20190103_61tmeeej_1_1.bak RECID=13779 STAMP=996620755
已删除备份片段
备份片段句柄=+ARCH/backup/arch_20190103_60tmeeej_1_1.bak RECID=13780 STAMP=996620755
已删除备份片段
备份片段句柄=+ARCH/backup/spfile_wyhis_20190103_62tmeeeq_1_1.ora RECID=13781 STAMP=996620762
已删除备份片段
备份片段句柄=+ARCH/backup/ctrl_wyhis_20190103_63tmeeer_1_1.bak RECID=13782 STAMP=996620764
已删除备份片段
备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190104_65tmh1a5_1_1.bak RECID=13783 STAMP=996705605
已删除备份片段
备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190104_66tmh1om_1_1.bak RECID=13784 STAMP=996706071
已删除备份片段
备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190104_67tmh1oo_1_1.bak RECID=13785 STAMP=996706072
已删除备份片段
备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190104_64tmh1a5_1_1.bak RECID=13786 STAMP=996705605
已删除备份片段
备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190104_64tmh1a5_2_1.bak RECID=13787 STAMP=996706768
已删除备份片段
备份片段句柄=+ARCH/backup/arch_20190104_68tmh2qu_1_1.bak RECID=13788 STAMP=996707166
已删除备份片段
备份片段句柄=+ARCH/backup/arch_20190104_69tmh2qu_1_1.bak RECID=13789 STAMP=996707166
已删除备份片段
备份片段句柄=+ARCH/backup/spfile_wyhis_20190104_6atmh2r5_1_1.ora RECID=13790 STAMP=996707173
已删除备份片段
备份片段句柄=+ARCH/backup/ctrl_wyhis_20190104_6btmh2r6_1_1.bak RECID=13791 STAMP=996707175
已删除备份片段
备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190105_6dtmjlm5_1_1.bak RECID=13792 STAMP=996792006
已删除备份片段
备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190105_6etmjm4n_1_1.bak RECID=13793 STAMP=996792472
已删除备份片段
备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190105_6ftmjm4p_1_1.bak RECID=13794 STAMP=996792473
已删除备份片段
备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190105_6ctmjlm5_1_1.bak RECID=13795 STAMP=996792005
已删除备份片段
备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190105_6ctmjlm5_2_1.bak RECID=13796 STAMP=996793168
已删除备份片段
备份片段句柄=+ARCH/backup/arch_20190105_6htmjn6s_1_1.bak RECID=13797 STAMP=996793564
已删除备份片段
备份片段句柄=+ARCH/backup/arch_20190105_6gtmjn6s_1_1.bak RECID=13798 STAMP=996793564
已删除备份片段
备份片段句柄=+ARCH/backup/spfile_wyhis_20190105_6itmjn74_1_1.ora RECID=13799 STAMP=996793572
已删除备份片段
备份片段句柄=+ARCH/backup/ctrl_wyhis_20190105_6jtmjn75_1_1.bak RECID=13800 STAMP=996793574
已删除备份片段
备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190106_6ltmma25_1_1.bak RECID=13801 STAMP=996878406
已删除备份片段
备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190106_6mtmmagn_1_1.bak RECID=13802 STAMP=996878872
已删除备份片段
备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190106_6ntmmagp_1_1.bak RECID=13803 STAMP=996878873
已删除备份片段
备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190106_6ktmma25_1_1.bak RECID=13804 STAMP=996878405
已删除备份片段
备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190106_6ktmma25_2_1.bak RECID=13805 STAMP=996879568
已删除备份片段
备份片段句柄=+ARCH/backup/arch_20190106_6ptmmbj8_1_1.bak RECID=13806 STAMP=996879976
已删除备份片段
备份片段句柄=+ARCH/backup/arch_20190106_6otmmbj8_1_1.bak RECID=13807 STAMP=996879976
已删除备份片段
备份片段句柄=+ARCH/backup/spfile_wyhis_20190106_6qtmmbjf_1_1.ora RECID=13808 STAMP=996879983
已删除备份片段
备份片段句柄=+ARCH/backup/ctrl_wyhis_20190106_6rtmmbjg_1_1.bak RECID=13809 STAMP=996879985
已删除备份片段
备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190107_6ttmoue6_1_1.bak RECID=13810 STAMP=996964806
已删除备份片段
备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190107_6utmousn_1_1.bak RECID=13811 STAMP=996965272
已删除备份片段
备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190107_6vtmousp_1_1.bak RECID=13812 STAMP=996965273
已删除备份片段
备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190107_6stmoue6_1_1.bak RECID=13813 STAMP=996964806
已删除备份片段
备份片段句柄=+ARCH/backup/zlemr_dbwhole_20190107_6stmoue6_2_1.bak RECID=13814 STAMP=996965959
已删除备份片段
备份片段句柄=+ARCH/backup/arch_20190107_71tmovuj_1_1.bak RECID=13815 STAMP=996966355
已删除备份片段
备份片段句柄=+ARCH/backup/arch_20190107_70tmovuj_1_1.bak RECID=13816 STAMP=996966355
已删除备份片段
备份片段句柄=+ARCH/backup/spfile_wyhis_20190107_72tmovuq_1_1.ora RECID=13817 STAMP=996966362
已删除备份片段
备份片段句柄=+ARCH/backup/ctrl_wyhis_20190107_73tmovur_1_1.bak RECID=13818 STAMP=996966364
已删除备份片段
备份片段句柄=/u01/app/oracle/product/11.2.0.4/dbhome_1/dbs/dbbakfull_77tmqt9i_1_1 RECID=13819 STAMP=997029170
已删除备份片段
备份片段句柄=/u01/app/oracle/product/11.2.0.4/dbhome_1/dbs/dbbakfull_78tmqted_1_1 RECID=13820 STAMP=997029328
已删除备份片段
备份片段句柄=/u01/app/oracle/product/11.2.0.4/dbhome_1/dbs/dbbakfull_79tmqteh_1_1 RECID=13821 STAMP=997029329
已删除备份片段
备份片段句柄=/u01/app/oracle/product/11.2.0.4/dbhome_1/dbs/dbbakfull_76tmqt9i_1_1 RECID=13822 STAMP=997029170
已删除备份片段
备份片段句柄=/u01/app/oracle/product/11.2.0.4/dbhome_1/dbs/dbbakfull_75tmqt9h_1_1 RECID=13823 STAMP=997029170
已删除备份片段
备份片段句柄=/u01/app/oracle/product/11.2.0.4/dbhome_1/dbs/dbbakfull_74tmqt9h_1_1 RECID=13824 STAMP=997029169
62 EXPIRED 对象已删除


RMAN>
RMAN> catalog start with ‘d:\dbbak\‘;

搜索与样式 d:\dbbak\ 匹配的所有文件

数据库未知文件的列表
=====================================
文件名: D:\DBBAK\control_7atmqumb_1_1
文件名: D:\DBBAK\dbbakfull_74tmqt9h_1_1
文件名: D:\DBBAK\dbbakfull_75tmqt9h_1_1
文件名: D:\DBBAK\dbbakfull_76tmqt9i_1_1
文件名: D:\DBBAK\dbbakfull_77tmqt9i_1_1
文件名: D:\DBBAK\dbbakfull_78tmqted_1_1
文件名: D:\DBBAK\dbbakfull_79tmqteh_1_1

是否确实要将上述文件列入目录 (输入 YES 或 NO)? yes
正在编制文件目录...
目录编制完毕

已列入目录的文件的列表
=======================
文件名: D:\DBBAK\control_7atmqumb_1_1
文件名: D:\DBBAK\dbbakfull_74tmqt9h_1_1
文件名: D:\DBBAK\dbbakfull_75tmqt9h_1_1
文件名: D:\DBBAK\dbbakfull_76tmqt9i_1_1
文件名: D:\DBBAK\dbbakfull_77tmqt9i_1_1
文件名: D:\DBBAK\dbbakfull_78tmqted_1_1
文件名: D:\DBBAK\dbbakfull_79tmqteh_1_1

RMAN>

RMAN> run{
2> set newname for database to ‘D:\oradata\zlemr\%d‘;
3> restore database;
4> }

正在执行命令: SET NEWNAME
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: set 命令 (在 01/08/2019 17:41:49 上) 失败
RMAN-06970: 数据库的 NEWNAME ‘D:\oradata\zlemr\%d‘ 必须包含 %f 或 %U 格式

RMAN> run{
2> set newname for database to ‘D:\oradata\zlemr\%b‘;
3> restore database;
4> }

正在执行命令: SET NEWNAME

启动 restore 于 08-1月 -19
使用通道 ORA_DISK_1

通道 ORA_DISK_1: 正在开始还原数据文件备份集
通道 ORA_DISK_1: 正在指定从备份集还原的数据文件
通道 ORA_DISK_1: 将数据文件 00005 还原到 D:\oradata\zlemr\+DATA/zlemrdg/zldocbase.dbf
通道 ORA_DISK_1: 将数据文件 00008 还原到 D:\oradata\zlemr\+DATA/zlemrdg/zldocdataindex.dbf
通道 ORA_DISK_1: 将数据文件 00009 还原到 D:\oradata\zlemr\+DATA/zlemrdg/zldocxml.dbf
通道 ORA_DISK_1: 正在读取备份片段 D:\DBBAK\DBBAKFULL_74TMQT9H_1_1
通道 ORA_DISK_1: ORA-19870: 还原备份片段 D:\DBBAK\DBBAKFULL_74TMQT9H_1_1 时出错
ORA-19504: 无法创建文件"D:\ORADATA\ZLEMR\+DATA\ZLEMRDG\ZLDOCXML.DBF"
ORA-27040: 文件创建错误, 无法创建文件
OSD-04002: ???????
O/S-Error: (OS 3) ?????????????????

通道 ORA_DISK_1: 正在开始还原数据文件备份集
通道 ORA_DISK_1: 正在指定从备份集还原的数据文件
通道 ORA_DISK_1: 将数据文件 00001 还原到 D:\oradata\zlemr\+DATA/zlemrdg/system01.dbf
通道 ORA_DISK_1: 将数据文件 00003 还原到 D:\oradata\zlemr\+DATA/zlemrdg/undotbs01.dbf
通道 ORA_DISK_1: 将数据文件 00010 还原到 D:\oradata\zlemr\+DATA/zlemrdg/sysaux02.dbf
通道 ORA_DISK_1: 正在读取备份片段 D:\DBBAK\DBBAKFULL_77TMQT9I_1_1
通道 ORA_DISK_1: ORA-19870: 还原备份片段 D:\DBBAK\DBBAKFULL_77TMQT9I_1_1 时出错
ORA-19504: 无法创建文件"D:\ORADATA\ZLEMR\+DATA\ZLEMRDG\SYSAUX02.DBF"
ORA-27040: 文件创建错误, 无法创建文件
OSD-04002: ???????
O/S-Error: (OS 3) ?????????????????

通道 ORA_DISK_1: 正在开始还原数据文件备份集
通道 ORA_DISK_1: 正在指定从备份集还原的数据文件
通道 ORA_DISK_1: 将数据文件 00002 还原到 D:\oradata\zlemr\+DATA/zlemrdg/sysaux01.dbf
通道 ORA_DISK_1: 将数据文件 00004 还原到 D:\oradata\zlemr\+DATA/zlemrdg/users01.dbf
通道 ORA_DISK_1: 将数据文件 00007 还原到 D:\oradata\zlemr\+DATA/zlemrdg/zldocdata.dbf
通道 ORA_DISK_1: 正在读取备份片段 D:\DBBAK\DBBAKFULL_76TMQT9I_1_1
通道 ORA_DISK_1: ORA-19870: 还原备份片段 D:\DBBAK\DBBAKFULL_76TMQT9I_1_1 时出错
ORA-19504: 无法创建文件"D:\ORADATA\ZLEMR\+DATA\ZLEMRDG\SYSAUX01.DBF"
ORA-27040: 文件创建错误, 无法创建文件
OSD-04002: ???????
O/S-Error: (OS 3) ?????????????????

通道 ORA_DISK_1: 正在开始还原数据文件备份集
通道 ORA_DISK_1: 正在指定从备份集还原的数据文件
通道 ORA_DISK_1: 将数据文件 00006 还原到 D:\oradata\zlemr\+DATA/zlemrdg/zldocindex.dbf
通道 ORA_DISK_1: 将数据文件 00011 还原到 D:\oradata\zlemr\+DATA/zlemrdg/zldocxml01.dbf
通道 ORA_DISK_1: 将数据文件 00012 还原到 D:\oradata\zlemr\+DATA/zlemrdg/zldocdataindex01.dbf
通道 ORA_DISK_1: 正在读取备份片段 D:\DBBAK\DBBAKFULL_75TMQT9H_1_1
通道 ORA_DISK_1: ORA-19870: 还原备份片段 D:\DBBAK\DBBAKFULL_75TMQT9H_1_1 时出错
ORA-19504: 无法创建文件"D:\ORADATA\ZLEMR\+DATA\ZLEMRDG\ZLDOCXML01.DBF"
ORA-27040: 文件创建错误, 无法创建文件
OSD-04002: ???????
O/S-Error: (OS 3) ?????????????????

故障转移到上一个备份

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: restore 命令 (在 01/08/2019 17:42:43 上) 失败
RMAN-06026: 有些目标没有找到 - 终止还原
RMAN-06023: 没有找到数据文件4的副本来还原
RMAN-06023: 没有找到数据文件3的副本来还原
RMAN-06023: 没有找到数据文件2的副本来还原
RMAN-06023: 没有找到数据文件1的副本来还原

RMAN>

RMAN> run{
2> set newname for datafile ‘+DATA/zlemrdg/zldocbase.dbf‘ to ‘D:\oradata\zlemr\zldocbase.dbf‘;
3> set newname for datafile ‘+DATA/zlemrdg/zldocdataindex.dbf‘ to ‘D:\oradata\zlemr\zldocdataindex.dbf‘;
4> set newname for datafile ‘+DATA/zlemrdg/zldocxml.dbf‘ to ‘D:\oradata\zlemr\zldocxml.dbf‘;
5> set newname for datafile ‘+DATA/zlemrdg/system01.dbf‘ to ‘D:\oradata\zlemr\system01.dbf‘;
6> set newname for datafile ‘+DATA/zlemrdg/undotbs01.dbf‘ to ‘D:\oradata\zlemr\undotbs01.dbf‘;
7> set newname for datafile ‘+DATA/zlemrdg/sysaux02.dbf‘ to ‘D:\oradata\zlemr\sysaux02.dbf‘;
8> set newname for datafile ‘+DATA/zlemrdg/zldocindex.dbf‘ to ‘D:\oradata\zlemr\zldocindex.dbf‘;
9> set newname for datafile ‘+DATA/zlemrdg/zldocxml01.dbf‘ to ‘D:\oradata\zlemr\zldocxml01.dbf‘;
10> set newname for datafile ‘+DATA/zlemrdg/zldocdataindex01.dbf‘ to ‘D:\oradata\zlemr\zldocdataindex01.dbf‘;
11> set newname for datafile ‘+DATA/zlemrdg/sysaux01.dbf‘ to ‘D:\oradata\zlemr\sysaux01.dbf‘;
12> set newname for datafile ‘+DATA/zlemrdg/zldocdata.dbf‘ to ‘D:\oradata\zlemr\zldocdata.dbf‘;
13> set newname for datafile ‘+DATA/zlemrdg/users01.dbf‘ to ‘D:\oradata\zlemr\users01.dbf‘;
14>
15> restore database;
16> }

正在执行命令: SET NEWNAME

正在执行命令: SET NEWNAME

正在执行命令: SET NEWNAME

正在执行命令: SET NEWNAME

正在执行命令: SET NEWNAME

正在执行命令: SET NEWNAME

正在执行命令: SET NEWNAME

正在执行命令: SET NEWNAME

正在执行命令: SET NEWNAME

正在执行命令: SET NEWNAME

正在执行命令: SET NEWNAME

正在执行命令: SET NEWNAME

启动 restore 于 08-1月 -19
使用通道 ORA_DISK_1

通道 ORA_DISK_1: 正在开始还原数据文件备份集
通道 ORA_DISK_1: 正在指定从备份集还原的数据文件
通道 ORA_DISK_1: 将数据文件 00005 还原到 D:\oradata\zlemr\zldocbase.dbf
通道 ORA_DISK_1: 将数据文件 00008 还原到 D:\oradata\zlemr\zldocdataindex.dbf
通道 ORA_DISK_1: 将数据文件 00009 还原到 D:\oradata\zlemr\zldocxml.dbf
通道 ORA_DISK_1: 正在读取备份片段 D:\DBBAK\DBBAKFULL_74TMQT9H_1_1
通道 ORA_DISK_1: 段句柄 = D:\DBBAK\DBBAKFULL_74TMQT9H_1_1 标记 = TAG20190108T163249
通道 ORA_DISK_1: 已还原备份片段 1
通道 ORA_DISK_1: 还原完成, 用时: 00:24:18
通道 ORA_DISK_1: 正在开始还原数据文件备份集
通道 ORA_DISK_1: 正在指定从备份集还原的数据文件
通道 ORA_DISK_1: 将数据文件 00001 还原到 D:\oradata\zlemr\system01.dbf
通道 ORA_DISK_1: 将数据文件 00003 还原到 D:\oradata\zlemr\undotbs01.dbf
通道 ORA_DISK_1: 将数据文件 00010 还原到 D:\oradata\zlemr\sysaux02.dbf
通道 ORA_DISK_1: 正在读取备份片段 D:\DBBAK\DBBAKFULL_77TMQT9I_1_1
通道 ORA_DISK_1: 段句柄 = D:\DBBAK\DBBAKFULL_77TMQT9I_1_1 标记 = TAG20190108T163249
通道 ORA_DISK_1: 已还原备份片段 1
通道 ORA_DISK_1: 还原完成, 用时: 00:04:35
通道 ORA_DISK_1: 正在开始还原数据文件备份集
通道 ORA_DISK_1: 正在指定从备份集还原的数据文件
通道 ORA_DISK_1: 将数据文件 00002 还原到 D:\oradata\zlemr\sysaux01.dbf
通道 ORA_DISK_1: 将数据文件 00004 还原到 D:\oradata\zlemr\users01.dbf
通道 ORA_DISK_1: 将数据文件 00007 还原到 D:\oradata\zlemr\zldocdata.dbf
通道 ORA_DISK_1: 正在读取备份片段 D:\DBBAK\DBBAKFULL_76TMQT9I_1_1
通道 ORA_DISK_1: 段句柄 = D:\DBBAK\DBBAKFULL_76TMQT9I_1_1 标记 = TAG20190108T163249
通道 ORA_DISK_1: 已还原备份片段 1
通道 ORA_DISK_1: 还原完成, 用时: 00:07:46
通道 ORA_DISK_1: 正在开始还原数据文件备份集
通道 ORA_DISK_1: 正在指定从备份集还原的数据文件
通道 ORA_DISK_1: 将数据文件 00006 还原到 D:\oradata\zlemr\zldocindex.dbf
通道 ORA_DISK_1: 将数据文件 00011 还原到 D:\oradata\zlemr\zldocxml01.dbf
通道 ORA_DISK_1: 将数据文件 00012 还原到 D:\oradata\zlemr\zldocdataindex01.dbf
通道 ORA_DISK_1: 正在读取备份片段 D:\DBBAK\DBBAKFULL_75TMQT9H_1_1
通道 ORA_DISK_1: 段句柄 = D:\DBBAK\DBBAKFULL_75TMQT9H_1_1 标记 = TAG20190108T163249
通道 ORA_DISK_1: 已还原备份片段 1
通道 ORA_DISK_1: 还原完成, 用时: 00:09:06
完成 restore 于 08-1月 -19

RMAN>

RMAN>

RMAN> switch database to copy;

数据文件 1 已切换成数据文件副本 "D:\ORADATA\ZLEMR\SYSTEM01.DBF"
数据文件 2 已切换成数据文件副本 "D:\ORADATA\ZLEMR\SYSAUX01.DBF"
数据文件 3 已切换成数据文件副本 "D:\ORADATA\ZLEMR\UNDOTBS01.DBF"
数据文件 4 已切换成数据文件副本 "D:\ORADATA\ZLEMR\USERS01.DBF"
数据文件 5 已切换成数据文件副本 "D:\ORADATA\ZLEMR\ZLDOCBASE.DBF"
数据文件 6 已切换成数据文件副本 "D:\ORADATA\ZLEMR\ZLDOCINDEX.DBF"
数据文件 7 已切换成数据文件副本 "D:\ORADATA\ZLEMR\ZLDOCDATA.DBF"
数据文件 8 已切换成数据文件副本 "D:\ORADATA\ZLEMR\ZLDOCDATAINDEX.DBF"
数据文件 9 已切换成数据文件副本 "D:\ORADATA\ZLEMR\ZLDOCXML.DBF"
数据文件 10 已切换成数据文件副本 "D:\ORADATA\ZLEMR\SYSAUX02.DBF"
数据文件 11 已切换成数据文件副本 "D:\ORADATA\ZLEMR\ZLDOCXML01.DBF"
数据文件 12 已切换成数据文件副本 "D:\ORADATA\ZLEMR\ZLDOCDATAINDEX01.DBF"

RMAN>

SQL> select member from v$logfile;

MEMBER
------------------------------------------------------------------------------------------------------------------------

+DATA/zlemrdg/redo03.log
+DATA/zlemrdg/redo02.log
+DATA/zlemrdg/redo01.log
+DATA/zlemrdg/std_redo04.log
+DATA/zlemrdg/std_redo05.log
+DATA/zlemrdg/std_redo06.log
+DATA/zlemrdg/std_redo07.log

已选择7行。

SQL> alter database rename file ‘+DATA/zlemrdg/redo03.log‘ to ‘D:\oradata\zlemr\redo03.log‘;

数据库已更改。

SQL> alter database rename file ‘+DATA/zlemrdg/redo02.log‘ to ‘D:\oradata\zlemr\redo03.log‘;
alter database rename file ‘+DATA/zlemrdg/redo02.log‘ to ‘D:\oradata\zlemr\redo03.log‘
*
第 1 行出现错误:
ORA-01511: 重命名日志/数据文件时出错
ORA-01523: 无法将数据文件重命名为 ‘D:\oradata\zlemr\redo03.log‘ - 文件已是数据库的一部分


SQL> alter database rename file ‘+DATA/zlemrdg/redo02.log‘ to ‘D:\oradata\zlemr\redo02.log‘;

数据库已更改。

SQL> alter database rename file ‘+DATA/zlemrdg/redo01.log‘ to ‘D:\oradata\zlemr\redo01.log‘;

数据库已更改。

SQL> alter database drop standby logfile ‘+DATA/zlemrdg/std_redo04.log‘;

数据库已更改。

SQL> alter database drop standby logfile ‘+DATA/zlemrdg/std_redo05.log‘;

数据库已更改。

SQL> alter database drop standby logfile ‘+DATA/zlemrdg/std_redo06.log‘;

数据库已更改。

SQL> alter database drop standby logfile ‘+DATA/zlemrdg/std_redo07.log‘;

数据库已更改。

SQL> select member from v$logfile;

MEMBER
------------------------------------------------------------------------------------------------------------------------

D:\ORADATA\ZLEMR\REDO03.LOG
D:\ORADATA\ZLEMR\REDO02.LOG
D:\ORADATA\ZLEMR\REDO01.LOG

SQL> alter database open resetlogs;

数据库已更改。

SQL> select file_name from dba_temp_files;
select file_name from dba_temp_files
                      *
第 1 行出现错误:
ORA-01157: 无法标识/锁定数据文件 201 - 请参阅 DBWR 跟踪文件
ORA-01110: 数据文件 201: ‘+DATA/zlemrdg/temp01.dbf‘


SQL> create temporary tablespace temp1 tempfile ‘D:\oradata\zlemr\temp02.dbf‘ size 1g autoextend on next 100m;

表空间已创建。

SQL> alter database default temporary tablespace temp1;

数据库已更改。

SQL> drop  tablespace temp;

表空间已删除。

SQL> select file_name from dba_temp_files;

FILE_NAME
------------------------------------------------------------------------------------------------------------------------

D:\ORADATA\ZLEMR\TEMP02.DBF

SQL>

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

上一篇:oracle: default role 详解(转)


下一篇:Sqlyog禁用更新