设为首页收藏本站
开启辅助访问 切换到窄版

重庆思庄Oracle、KingBase、PostgreSQL、Redhat认证学习论坛

 找回密码
 注册

QQ登录

只需一步，快速开始

搜索
重庆思庄Oracle、KingBase、PostgreSQL、Redhat认证学习论坛»首页 › 国外商业数据库 › Oracle › 奇怪的ORA-19693: backup piece DB_NA3SBQO1_1_1.BAK al ...
返回列表 发新帖
查看: 783|回复: 0
打印 上一主题 下一主题

[备份恢复] 奇怪的ORA-19693: backup piece DB_NA3SBQO1_1_1.BAK already included

  [复制链接]
郑全
跳转到指定楼层
楼主
发表于 2025-6-20 18:26:08 | 只看该作者 回帖奖励 |倒序浏览 |阅读模式
1.问题现象：   在做异机恢复时，使用了catalog start with 'to path'识别了备份后，再去使用以下命令进行数据库恢复时，结果报ORA-19693错误 ：
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>     allocate channel c5 device type disk;
7>     allocate channel c6 device type disk;
8>     allocate channel c7 device type disk;
9>     allocate channel c8 device type disk;
10>     set newname for database to 'd:\oracle\oradata\orcl\%b';
11>     restore database;
12>     switch datafile all;
13>     switch tempfile all;
14>     recover database;
15>     }

allocated channel: c1
channel c1: SID=488 device type=DISK

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

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

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

allocated channel: c5
channel c5: SID=99 device type=DISK

allocated channel: c6
channel c6: SID=197 device type=DISK

allocated channel: c7
channel c7: SID=295 device type=DISK

allocated channel: c8
channel c8: SID=392 device type=DISK

executing command: SET NEWNAME

Starting restore at 20-JUN-25

channel c1: starting datafile backup set restore
channel c1: specifying datafile(s) to restore from backup set
channel c1: restoring datafile 00002 to d:\oracle\oradata\orcl\O1_MF_UNDOTBS1_KBG0B4H5_.DBF
channel c1: restoring datafile 00005 to d:\oracle\oradata\orcl\APACCT.DBF
channel c1: restoring datafile 00008 to d:\oracle\oradata\orcl\APCARD.DBF
channel c1: restoring datafile 00010 to d:\oracle\oradata\orcl\APECONSTAT.DBF
channel c1: restoring datafile 00030 to d:\oracle\oradata\orcl\TSP_MOPE.DBF
channel c1: restoring datafile 00033 to d:\oracle\oradata\orcl\APORDADM1.DBF
channel c1: restoring datafile 00039 to d:\oracle\oradata\orcl\APPHYEXAM.DBF
channel c1: restoring datafile 00065 to d:\oracle\oradata\orcl\TSP_SINLDO_ZH.DBF
channel c1: restoring datafile 00066 to d:\oracle\oradata\orcl\TSP_HBBWSJ.DBF
released channel: c1
released channel: c2
released channel: c3
released channel: c4
released channel: c5
released channel: c6
released channel: c7
released channel: c8
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 06/20/2025 18:05:05
ORA-19693: backup piece E:\BAK\DB_NA3SBQO1_1_1.BAK already included

RMAN>

2.问题分析：
  检查备份，主要是备份片多余1份导致。

RMAN> list backup of database;

using target database control file instead of recovery catalog

List of Backup Sets
===================


BS Key  Type LV Size
------- ---- -- ----------
26123   Full    822.76M
  List of Datafiles in backup set 26123
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  2       Full 17866220305347 18-JUN-25 D:\ORACLE\ORADATA\ORCL\DATAFILE\O1_MF_UNDOTBS1_KBG0B4H5_.DBF
  5       Full 17866220305347 18-JUN-25 D:\ORACLE\ORADATA\ORCL\APACCT.DBF
  8       Full 17866220305347 18-JUN-25 D:\ORACLE\ORADATA\ORCL\APCARD.DBF
  10      Full 17866220305347 18-JUN-25 D:\ORACLE\ORADATA\ORCL\APECONSTAT.DBF
  30      Full 17866220305347 18-JUN-25 D:\ORACLE\ORADATA\ORCL\TSP_MOPE.DBF
  33      Full 17866220305347 18-JUN-25 D:\ORACLE\ORADATA\ORCL\APORDADM1.DBF
  39      Full 17866220305347 18-JUN-25 D:\ORACLE\ORADATA\ORCL\APPHYEXAM.DBF
  65      Full 17866220305347 18-JUN-25 D:\ORACLE\ORADATA\ORCL\TSP_SINLDO_ZH.DBF
  66      Full 17866220305347 18-JUN-25 D:\ORACLE\ORADATA\ORCL\TSP_HBBWSJ.DBF

  Backup Set Copy #1 of backup set 26123
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:03:57     18-JUN-25       YES        TAG20250618T225808

    List of Backup Pieces for backup set 26123 Copy #1
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    26123   1   AVAILABLE   E:\BAK\DB_NA3SBQO1_1_1.BAK

  Backup Set Copy #2 of backup set 26123
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:03:57     20-JUN-25       YES        TAG20250618T225808

    List of Backup Pieces for backup set 26123 Copy #2
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    26135   1   AVAILABLE   E:\BAK\DB_NA3SBQO1_1_1.BAK

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
26126   Full    3.11G      DISK        00:00:00     18-JUN-25
        BP Key: 26136   Status: AVAILABLE  Compressed: YES  Tag: TAG20250618T225808
        Piece Name: E:\BAK\DB_NB3SBQO1_1_1.BAK
  List of Datafiles in backup set 26126
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  9       Full 17866220305348 18-JUN-25 D:\ORACLE\ORADATA\ORCL\APCOMM.DBF
  16      Full 17866220305348 18-JUN-25 D:\ORACLE\ORADATA\ORCL\HISACCOUNT.DBF
  23      Full 17866220305348 18-JUN-25 D:\ORACLE\ORADATA\ORCL\APINPBILL2.DBF
  25      Full 17866220305348 18-JUN-25 D:\ORACLE\ORADATA\ORCL\APINSURANCE.DBF
  35      Full 17866220305348 18-JUN-25 D:\ORACLE\ORADATA\ORCL\APOUTPADM.DBF
  43      Full 17866220305348 18-JUN-25 D:\ORACLE\ORADATA\ORCL\INDX01.DBF
  47      Full 17866220305348 18-JUN-25 D:\ORACLE\ORADATA\ORCL\USRORCL.DBF
  54      Full 17866220305348 18-JUN-25 D:\ORACLE\ORADATA\ORCL\DATAFILE\O2_MF_USERS_88R5JXXS_.DBF
  69      Full 17866220305348 18-JUN-25 D:\ORACLE\ORADATA\ORCL\APLAB2.DBF

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
26127   Full    2.88G      DISK        00:00:00     18-JUN-25
        BP Key: 26137   Status: AVAILABLE  Compressed: YES  Tag: TAG20250618T225808
        Piece Name: E:\BAK\DB_NC3SBQO1_1_1.BAK
  List of Datafiles in backup set 26127
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  4       Full 17866220305349 18-JUN-25 D:\ORACLE\ORADATA\ORCL\DATAFILE\O1_MF_USERS_KBG0ZX74_.DBF
  14      Full 17866220305349 18-JUN-25 D:\ORACLE\ORADATA\ORCL\HACCOUNT.ORA
  18      Full 17866220305349 18-JUN-25 D:\ORACLE\ORADATA\ORCL\INFECTION.DBF
  19      Full 17866220305349 18-JUN-25 D:\ORACLE\ORADATA\ORCL\APINFO.DBF
  22      Full 17866220305349 18-JUN-25 D:\ORACLE\ORADATA\ORCL\APINPBILL1.DBF
  26      Full 17866220305349 18-JUN-25 D:\ORACLE\ORADATA\ORCL\APLAB.DBF
  57      Full 17866220305349 18-JUN-25 D:\ORACLE\ORADATA\ORCL\APLAB1.DBF
  61      Full 17866220305349 18-JUN-25 D:\ORACLE\ORADATA\ORCL\APINPBILL5.DBF
  68      Full 17866220305349 18-JUN-25 D:\ORACLE\ORADATA\ORCL\APOUTPBILL3.DBF

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
26128   Full    2.86G      DISK        00:00:00     18-JUN-25
        BP Key: 26138   Status: AVAILABLE  Compressed: YES  Tag: TAG20250618T225808
        Piece Name: E:\BAK\DB_ND3SBQO1_1_1.BAK
  List of Datafiles in backup set 26128
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  15      Full 17866220305350 18-JUN-25 D:\ORACLE\ORADATA\ORCL\HATEMP.ORA
  27      Full 17866220305350 18-JUN-25 D:\ORACLE\ORADATA\ORCL\APMATERIAL.DBF
  31      Full 17866220305350 18-JUN-25 D:\ORACLE\ORADATA\ORCL\APNURSING.DBF
  44      Full 17866220305350 18-JUN-25 D:\ORACLE\ORADATA\ORCL\APTEMP.DBF
  56      Full 17866220305350 18-JUN-25 D:\ORACLE\ORADATA\ORCL\SINLDO.DBF
  63      Full 17866220305350 18-JUN-25 D:\ORACLE\ORADATA\ORCL\APORDADM4.DBF
  64      Full 17866220305350 18-JUN-25 D:\ORACLE\ORADATA\ORCL\APINPBILL6.DBF
  67      Full 17866220305350 18-JUN-25 D:\ORACLE\ORADATA\ORCL\APINPBILL7.DBF
  70      Full 17866220305350 18-JUN-25 D:\ORACLE\ORADATA\ORCL\APORDADM5.DBF

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
26129   Full    2.45G      DISK        00:00:00     18-JUN-25
        BP Key: 26139   Status: AVAILABLE  Compressed: YES  Tag: TAG20250618T225808
        Piece Name: E:\BAK\DB_NE3SBQO1_1_1.BAK
  List of Datafiles in backup set 26129
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  28      Full 17866220305352 18-JUN-25 D:\ORACLE\ORADATA\ORCL\APMEDADM.DBF
  32      Full 17866220305352 18-JUN-25 D:\ORACLE\ORADATA\ORCL\APORDADM.DBF
  40      Full 17866220305352 18-JUN-25 D:\ORACLE\ORADATA\ORCL\APPUBLIC.DBF
  42      Full 17866220305352 18-JUN-25 D:\ORACLE\ORADATA\ORCL\RBS01.DBF
  45      Full 17866220305352 18-JUN-25 D:\ORACLE\ORADATA\ORCL\RBSORCL.DBF
  50      Full 17866220305352 18-JUN-25 D:\ORACLE\ORADATA\ORCL\APPHARMACY1.DBF
  53      Full 17866220305352 18-JUN-25 D:\ORACLE\ORADATA\ORCL\TSP_SUPCON2.DBF
  55      Full 17866220305352 18-JUN-25 D:\ORACLE\ORADATA\ORCL\TSP_SUPCON3.DBF
  59      Full 17866220305352 18-JUN-25 D:\ORACLE\ORADATA\ORCL\TSP_SUPCON4.DBF

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
26130   Full    2.90G      DISK        00:00:00     18-JUN-25
        BP Key: 26140   Status: AVAILABLE  Compressed: YES  Tag: TAG20250618T225808
        Piece Name: E:\BAK\DB_NF3SBQO2_1_1.BAK
  List of Datafiles in backup set 26130
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  3       Full 17866220305353 18-JUN-25 D:\ORACLE\ORADATA\ORCL\DATAFILE\O1_MF_SYSAUX_KBG2SK26_.DBF
  6       Full 17866220305353 18-JUN-25 D:\ORACLE\ORADATA\ORCL\APBACK.DBF
  13      Full 17866220305353 18-JUN-25 D:\ORACLE\ORADATA\ORCL\APEXAM.DBF
  17      Full 17866220305353 18-JUN-25 D:\ORACLE\ORADATA\ORCL\APINFECT.DBF
  20      Full 17866220305353 18-JUN-25 D:\ORACLE\ORADATA\ORCL\APINPADM.DBF
  38      Full 17866220305353 18-JUN-25 D:\ORACLE\ORADATA\ORCL\APPHARMACY.DBF
  48      Full 17866220305353 18-JUN-25 D:\ORACLE\ORADATA\ORCL\TSP_SUPCON.DBF
  58      Full 17866220305353 18-JUN-25 D:\ORACLE\ORADATA\ORCL\APORDADM3.DBF
  72      Full 17866220305353 18-JUN-25 D:\ORACLE\ORADATA\ORCL\SINLDO2.DBF

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
26131   Full    2.29G      DISK        00:00:00     18-JUN-25
        BP Key: 26141   Status: AVAILABLE  Compressed: YES  Tag: TAG20250618T225808
        Piece Name: E:\BAK\DB_NG3SBQO2_1_1.BAK
  List of Datafiles in backup set 26131
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  7       Full 17866220305354 18-JUN-25 D:\ORACLE\ORADATA\ORCL\APBLDBANK.DBF
  12      Full 17866220305354 18-JUN-25 D:\ORACLE\ORADATA\ORCL\APEQUIPMENT.DBF
  21      Full 17866220305354 18-JUN-25 D:\ORACLE\ORADATA\ORCL\APINPBILL.DBF
  24      Full 17866220305354 18-JUN-25 D:\ORACLE\ORADATA\ORCL\APINPBILL3.DBF
  29      Full 17866220305354 18-JUN-25 D:\ORACLE\ORADATA\ORCL\APMEDREC.DBF
  46      Full 17866220305354 18-JUN-25 D:\ORACLE\ORADATA\ORCL\TEMPORCL.DBF
  49      Full 17866220305354 18-JUN-25 D:\ORACLE\ORADATA\APINPBILL4.DBF
  51      Full 17866220305354 18-JUN-25 D:\ORACLE\ORADATA\ORCL\ASSET.DBF
  52      Full 17866220305354 18-JUN-25 D:\ORACLE\ORADATA\ORCL\TSP_SUPCON1.DBF

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
26132   Full    2.98G      DISK        00:00:00     18-JUN-25
        BP Key: 26142   Status: AVAILABLE  Compressed: YES  Tag: TAG20250618T225808
        Piece Name: E:\BAK\DB_NH3SBQO2_1_1.BAK
  List of Datafiles in backup set 26132
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1       Full 17866220305355 18-JUN-25 D:\ORACLE\ORADATA\ORCL\DATAFILE\O1_MF_SYSTEM_KBG3M4W1_.DBF
  11      Full 17866220305355 18-JUN-25 D:\ORACLE\ORADATA\ORCL\APEMERGOB.DBF
  34      Full 17866220305355 18-JUN-25 D:\ORACLE\ORADATA\ORCL\APORDADM2.DBF
  36      Full 17866220305355 18-JUN-25 D:\ORACLE\ORADATA\ORCL\APOUTPBILL.DBF
  37      Full 17866220305355 18-JUN-25 D:\ORACLE\ORADATA\ORCL\APOUTPBILL1.DBF
  41      Full 17866220305355 18-JUN-25 D:\ORACLE\ORADATA\ORCL\APSURGERY.DBF
  60      Full 17866220305355 18-JUN-25 D:\ORACLE\ORADATA\ORCL\APOUTPBILL2.DBF
  62      Full 17866220305355 18-JUN-25 D:\ORACLE\ORADATA\ORCL\SINLDO1.DBF
  71      Full 17866220305355 18-JUN-25 D:\ORACLE\ORADATA\ORCL\APGGS.DBF

RMAN>


3.解决办法：



取消多于一份的备份片：

RMAN> change backuppiece 26135 uncatalog;

uncataloged backup piece
backup piece handle=E:\BAK\DB_NA3SBQO1_1_1.BAK RECID=26135 STAMP=1204307110
Uncataloged 1 objects


再去检查，发现没有多于1份的备份了：

RMAN> list backup of database;


List of Backup Sets
===================


BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
26123   Full    822.76M    DISK        00:03:57     18-JUN-25
        BP Key: 26123   Status: AVAILABLE  Compressed: YES  Tag: TAG20250618T225808
        Piece Name: E:\BAK\DB_NA3SBQO1_1_1.BAK
  List of Datafiles in backup set 26123
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  2       Full 17866220305347 18-JUN-25 D:\ORACLE\ORADATA\ORCL\DATAFILE\O1_MF_UNDOTBS1_KBG0B4H5_.DBF
  5       Full 17866220305347 18-JUN-25 D:\ORACLE\ORADATA\ORCL\APACCT.DBF
  8       Full 17866220305347 18-JUN-25 D:\ORACLE\ORADATA\ORCL\APCARD.DBF
  10      Full 17866220305347 18-JUN-25 D:\ORACLE\ORADATA\ORCL\APECONSTAT.DBF
  30      Full 17866220305347 18-JUN-25 D:\ORACLE\ORADATA\ORCL\TSP_MOPE.DBF
  33      Full 17866220305347 18-JUN-25 D:\ORACLE\ORADATA\ORCL\APORDADM1.DBF
  39      Full 17866220305347 18-JUN-25 D:\ORACLE\ORADATA\ORCL\APPHYEXAM.DBF
  65      Full 17866220305347 18-JUN-25 D:\ORACLE\ORADATA\ORCL\TSP_SINLDO_ZH.DBF
  66      Full 17866220305347 18-JUN-25 D:\ORACLE\ORADATA\ORCL\TSP_HBBWSJ.DBF

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
26126   Full    3.11G      DISK        00:00:00     18-JUN-25
        BP Key: 26136   Status: AVAILABLE  Compressed: YES  Tag: TAG20250618T225808
        Piece Name: E:\BAK\DB_NB3SBQO1_1_1.BAK
  List of Datafiles in backup set 26126
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  9       Full 17866220305348 18-JUN-25 D:\ORACLE\ORADATA\ORCL\APCOMM.DBF
  16      Full 17866220305348 18-JUN-25 D:\ORACLE\ORADATA\ORCL\HISACCOUNT.DBF
  23      Full 17866220305348 18-JUN-25 D:\ORACLE\ORADATA\ORCL\APINPBILL2.DBF
  25      Full 17866220305348 18-JUN-25 D:\ORACLE\ORADATA\ORCL\APINSURANCE.DBF
  35      Full 17866220305348 18-JUN-25 D:\ORACLE\ORADATA\ORCL\APOUTPADM.DBF
  43      Full 17866220305348 18-JUN-25 D:\ORACLE\ORADATA\ORCL\INDX01.DBF
  47      Full 17866220305348 18-JUN-25 D:\ORACLE\ORADATA\ORCL\USRORCL.DBF
  54      Full 17866220305348 18-JUN-25 D:\ORACLE\ORADATA\ORCL\DATAFILE\O2_MF_USERS_88R5JXXS_.DBF
  69      Full 17866220305348 18-JUN-25 D:\ORACLE\ORADATA\ORCL\APLAB2.DBF

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
26127   Full    2.88G      DISK        00:00:00     18-JUN-25
        BP Key: 26137   Status: AVAILABLE  Compressed: YES  Tag: TAG20250618T225808
        Piece Name: E:\BAK\DB_NC3SBQO1_1_1.BAK
  List of Datafiles in backup set 26127
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  4       Full 17866220305349 18-JUN-25 D:\ORACLE\ORADATA\ORCL\DATAFILE\O1_MF_USERS_KBG0ZX74_.DBF
  14      Full 17866220305349 18-JUN-25 D:\ORACLE\ORADATA\ORCL\HACCOUNT.ORA
  18      Full 17866220305349 18-JUN-25 D:\ORACLE\ORADATA\ORCL\INFECTION.DBF
  19      Full 17866220305349 18-JUN-25 D:\ORACLE\ORADATA\ORCL\APINFO.DBF
  22      Full 17866220305349 18-JUN-25 D:\ORACLE\ORADATA\ORCL\APINPBILL1.DBF
  26      Full 17866220305349 18-JUN-25 D:\ORACLE\ORADATA\ORCL\APLAB.DBF
  57      Full 17866220305349 18-JUN-25 D:\ORACLE\ORADATA\ORCL\APLAB1.DBF
  61      Full 17866220305349 18-JUN-25 D:\ORACLE\ORADATA\ORCL\APINPBILL5.DBF
  68      Full 17866220305349 18-JUN-25 D:\ORACLE\ORADATA\ORCL\APOUTPBILL3.DBF

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
26128   Full    2.86G      DISK        00:00:00     18-JUN-25
        BP Key: 26138   Status: AVAILABLE  Compressed: YES  Tag: TAG20250618T225808
        Piece Name: E:\BAK\DB_ND3SBQO1_1_1.BAK
  List of Datafiles in backup set 26128
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  15      Full 17866220305350 18-JUN-25 D:\ORACLE\ORADATA\ORCL\HATEMP.ORA
  27      Full 17866220305350 18-JUN-25 D:\ORACLE\ORADATA\ORCL\APMATERIAL.DBF
  31      Full 17866220305350 18-JUN-25 D:\ORACLE\ORADATA\ORCL\APNURSING.DBF
  44      Full 17866220305350 18-JUN-25 D:\ORACLE\ORADATA\ORCL\APTEMP.DBF
  56      Full 17866220305350 18-JUN-25 D:\ORACLE\ORADATA\ORCL\SINLDO.DBF
  63      Full 17866220305350 18-JUN-25 D:\ORACLE\ORADATA\ORCL\APORDADM4.DBF
  64      Full 17866220305350 18-JUN-25 D:\ORACLE\ORADATA\ORCL\APINPBILL6.DBF
  67      Full 17866220305350 18-JUN-25 D:\ORACLE\ORADATA\ORCL\APINPBILL7.DBF
  70      Full 17866220305350 18-JUN-25 D:\ORACLE\ORADATA\ORCL\APORDADM5.DBF

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
26129   Full    2.45G      DISK        00:00:00     18-JUN-25
        BP Key: 26139   Status: AVAILABLE  Compressed: YES  Tag: TAG20250618T225808
        Piece Name: E:\BAK\DB_NE3SBQO1_1_1.BAK
  List of Datafiles in backup set 26129
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  28      Full 17866220305352 18-JUN-25 D:\ORACLE\ORADATA\ORCL\APMEDADM.DBF
  32      Full 17866220305352 18-JUN-25 D:\ORACLE\ORADATA\ORCL\APORDADM.DBF
  40      Full 17866220305352 18-JUN-25 D:\ORACLE\ORADATA\ORCL\APPUBLIC.DBF
  42      Full 17866220305352 18-JUN-25 D:\ORACLE\ORADATA\ORCL\RBS01.DBF
  45      Full 17866220305352 18-JUN-25 D:\ORACLE\ORADATA\ORCL\RBSORCL.DBF
  50      Full 17866220305352 18-JUN-25 D:\ORACLE\ORADATA\ORCL\APPHARMACY1.DBF
  53      Full 17866220305352 18-JUN-25 D:\ORACLE\ORADATA\ORCL\TSP_SUPCON2.DBF
  55      Full 17866220305352 18-JUN-25 D:\ORACLE\ORADATA\ORCL\TSP_SUPCON3.DBF
  59      Full 17866220305352 18-JUN-25 D:\ORACLE\ORADATA\ORCL\TSP_SUPCON4.DBF

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
26130   Full    2.90G      DISK        00:00:00     18-JUN-25
        BP Key: 26140   Status: AVAILABLE  Compressed: YES  Tag: TAG20250618T225808
        Piece Name: E:\BAK\DB_NF3SBQO2_1_1.BAK
  List of Datafiles in backup set 26130
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  3       Full 17866220305353 18-JUN-25 D:\ORACLE\ORADATA\ORCL\DATAFILE\O1_MF_SYSAUX_KBG2SK26_.DBF
  6       Full 17866220305353 18-JUN-25 D:\ORACLE\ORADATA\ORCL\APBACK.DBF
  13      Full 17866220305353 18-JUN-25 D:\ORACLE\ORADATA\ORCL\APEXAM.DBF
  17      Full 17866220305353 18-JUN-25 D:\ORACLE\ORADATA\ORCL\APINFECT.DBF
  20      Full 17866220305353 18-JUN-25 D:\ORACLE\ORADATA\ORCL\APINPADM.DBF
  38      Full 17866220305353 18-JUN-25 D:\ORACLE\ORADATA\ORCL\APPHARMACY.DBF
  48      Full 17866220305353 18-JUN-25 D:\ORACLE\ORADATA\ORCL\TSP_SUPCON.DBF
  58      Full 17866220305353 18-JUN-25 D:\ORACLE\ORADATA\ORCL\APORDADM3.DBF
  72      Full 17866220305353 18-JUN-25 D:\ORACLE\ORADATA\ORCL\SINLDO2.DBF

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
26131   Full    2.29G      DISK        00:00:00     18-JUN-25
        BP Key: 26141   Status: AVAILABLE  Compressed: YES  Tag: TAG20250618T225808
        Piece Name: E:\BAK\DB_NG3SBQO2_1_1.BAK
  List of Datafiles in backup set 26131
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  7       Full 17866220305354 18-JUN-25 D:\ORACLE\ORADATA\ORCL\APBLDBANK.DBF
  12      Full 17866220305354 18-JUN-25 D:\ORACLE\ORADATA\ORCL\APEQUIPMENT.DBF
  21      Full 17866220305354 18-JUN-25 D:\ORACLE\ORADATA\ORCL\APINPBILL.DBF
  24      Full 17866220305354 18-JUN-25 D:\ORACLE\ORADATA\ORCL\APINPBILL3.DBF
  29      Full 17866220305354 18-JUN-25 D:\ORACLE\ORADATA\ORCL\APMEDREC.DBF
  46      Full 17866220305354 18-JUN-25 D:\ORACLE\ORADATA\ORCL\TEMPORCL.DBF
  49      Full 17866220305354 18-JUN-25 D:\ORACLE\ORADATA\APINPBILL4.DBF
  51      Full 17866220305354 18-JUN-25 D:\ORACLE\ORADATA\ORCL\ASSET.DBF
  52      Full 17866220305354 18-JUN-25 D:\ORACLE\ORADATA\ORCL\TSP_SUPCON1.DBF

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
26132   Full    2.98G      DISK        00:00:00     18-JUN-25
        BP Key: 26142   Status: AVAILABLE  Compressed: YES  Tag: TAG20250618T225808
        Piece Name: E:\BAK\DB_NH3SBQO2_1_1.BAK
  List of Datafiles in backup set 26132
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1       Full 17866220305355 18-JUN-25 D:\ORACLE\ORADATA\ORCL\DATAFILE\O1_MF_SYSTEM_KBG3M4W1_.DBF
  11      Full 17866220305355 18-JUN-25 D:\ORACLE\ORADATA\ORCL\APEMERGOB.DBF
  34      Full 17866220305355 18-JUN-25 D:\ORACLE\ORADATA\ORCL\APORDADM2.DBF
  36      Full 17866220305355 18-JUN-25 D:\ORACLE\ORADATA\ORCL\APOUTPBILL.DBF
  37      Full 17866220305355 18-JUN-25 D:\ORACLE\ORADATA\ORCL\APOUTPBILL1.DBF
  41      Full 17866220305355 18-JUN-25 D:\ORACLE\ORADATA\ORCL\APSURGERY.DBF
  60      Full 17866220305355 18-JUN-25 D:\ORACLE\ORADATA\ORCL\APOUTPBILL2.DBF
  62      Full 17866220305355 18-JUN-25 D:\ORACLE\ORADATA\ORCL\SINLDO1.DBF
  71      Full 17866220305355 18-JUN-25 D:\ORACLE\ORADATA\ORCL\APGGS.DBF

RMAN>


5.再去恢复，就OK了

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>     allocate channel c5 device type disk;
7>     allocate channel c6 device type disk;
8>     allocate channel c7 device type disk;
9>     allocate channel c8 device type disk;
10>     set newname for database to 'd:\oracle\oradata\orcl\%b';
11>     restore database;
12>     switch datafile all;
13>     switch tempfile all;
14>     recover database;
15>     }

allocated channel: c1
channel c1: SID=488 device type=DISK

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

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

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

allocated channel: c5
channel c5: SID=99 device type=DISK

allocated channel: c6
channel c6: SID=197 device type=DISK

allocated channel: c7
channel c7: SID=295 device type=DISK

allocated channel: c8
channel c8: SID=392 device type=DISK

executing command: SET NEWNAME

Starting restore at 20-JUN-25

channel c1: starting datafile backup set restore
channel c1: specifying datafile(s) to restore from backup set
channel c1: restoring datafile 00002 to d:\oracle\oradata\orcl\O1_MF_UNDOTBS1_KBG0B4H5_.DBF
channel c1: restoring datafile 00005 to d:\oracle\oradata\orcl\APACCT.DBF
channel c1: restoring datafile 00008 to d:\oracle\oradata\orcl\APCARD.DBF
channel c1: restoring datafile 00010 to d:\oracle\oradata\orcl\APECONSTAT.DBF
channel c1: restoring datafile 00030 to d:\oracle\oradata\orcl\TSP_MOPE.DBF
channel c1: restoring datafile 00033 to d:\oracle\oradata\orcl\APORDADM1.DBF
channel c1: restoring datafile 00039 to d:\oracle\oradata\orcl\APPHYEXAM.DBF
channel c1: restoring datafile 00065 to d:\oracle\oradata\orcl\TSP_SINLDO_ZH.DBF
channel c1: restoring datafile 00066 to d:\oracle\oradata\orcl\TSP_HBBWSJ.DBF
channel c1: reading from backup piece E:\BAK\DB_NA3SBQO1_1_1.BAK
channel c2: starting datafile backup set restore
channel c2: specifying datafile(s) to restore from backup set

。。。





分享到:  QQ好友和群QQ好友和群 QQ空间QQ空间 腾讯微博腾讯微博 腾讯朋友腾讯朋友
收藏收藏 支持支持1 反对反对
回复

使用道具 举报

返回列表 发新帖
高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 | 注册

本版积分规则

QQ|手机版|小黑屋|重庆思庄Oracle、Redhat认证学习论坛 ( 渝ICP备12004239号-4 )

GMT+8, 2026-5-26 12:08 , Processed in 0.234889 second(s), 20 queries .

重庆思庄学习中心论坛-重庆思庄科技有限公司论坛

© 2001-2020

快速回复 返回顶部 返回列表