主页 / dba / 问题 / 222366
Accepted
rfusca
Asked: 2018-11-13 10:52:53 +0800 CST

还原重复项时缺少归档日志

  • 772

我们通过带有在线完整备份和每小时归档日志的时间点 RMAN Duplicate 将备份从生产中恢复到我们的测试系统。每个蓝月亮都会出现问题（努力单独解决），我最终没有存档日志。它花费数小时恢复数据文件，获取归档日志，然后进行轰炸。

在开始显着推送数据之前，我如何验证 RMAN 是否具有要还原的所有正确存档日志和数据文件？

oracle rman

1 个回答

  1. Best Answer

    使用RESTORE ... PREVIEW. 我故意删除了一些归档日志，所以我没有它们的备份。

    现在我想检查是否可以将数据库恢复到指定时间：

    run
{
  set until time "to_date('2018-11-12 19:58:00', 'YYYY-MM-DD HH24:MI:SS')";
  restore database preview;
}

    输出：

    executing command: SET until clause

Starting restore at 12-NOV-18
using channel ORA_DISK_1


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


BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
4       Full    1.11G      DISK        00:00:03     11-NOV-18
        BP Key: 4   Status: AVAILABLE  Compressed: NO  Tag: TAG20181111T221533
        Piece Name: /oracle_backup/DOMINO_O77/04thvv85_1_1
  List of Datafiles in backup set 4
  File LV Type Ckp SCN    Ckp Time  Abs Fuz SCN Sparse Name
  ---- -- ---- ---------- --------- ----------- ------ ----
  1       Full 2397081    11-NOV-18              NO    +DATA/DOMINO_O77/DATAFILE/system.257.991918055
  3       Full 2397081    11-NOV-18              NO    +DATA/DOMINO_O77/DATAFILE/sysaux.258.991918107
  4       Full 2397081    11-NOV-18              NO    +DATA/DOMINO_O77/DATAFILE/undotbs1.259.991918131
  7       Full 2397081    11-NOV-18              NO    +DATA/DOMINO_O77/DATAFILE/users.260.991918133

no backup of archived log for thread 1 with sequence 63 and starting SCN of 2784642 found to restore
no backup of archived log for thread 1 with sequence 64 and starting SCN of 2784723 found to restore
no backup of archived log for thread 1 with sequence 68 and starting SCN of 2784830 found to restore

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


BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
7       151.71M    DISK        00:00:01     12-NOV-18
        BP Key: 7   Status: AVAILABLE  Compressed: NO  Tag: TAG20181112T195537
        Piece Name: /oracle_backup/DOMINO_O77/09ti2bdp_1_1

  List of Archived Logs in backup set 7
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    43      2396293    11-NOV-18 2397794    11-NOV-18
  1    44      2397794    11-NOV-18 2398565    11-NOV-18
  1    45      2398565    11-NOV-18 2398568    11-NOV-18
  1    46      2398568    11-NOV-18 2398574    11-NOV-18
  1    47      2398574    11-NOV-18 2398581    11-NOV-18
  1    48      2398581    11-NOV-18 2398588    11-NOV-18
  1    49      2398588    11-NOV-18 2398606    11-NOV-18
  1    50      2398606    11-NOV-18 2398912    11-NOV-18
  1    51      2398912    11-NOV-18 2498959    11-NOV-18
  1    52      2498959    11-NOV-18 2498962    11-NOV-18
  1    53      2498962    11-NOV-18 2499076    11-NOV-18
  1    54      2499076    11-NOV-18 2499560    11-NOV-18
  1    55      2499560    11-NOV-18 2499580    11-NOV-18
  1    56      2499580    11-NOV-18 2601155    11-NOV-18
  1    57      2601155    11-NOV-18 2601158    11-NOV-18
  1    58      2601158    11-NOV-18 2601263    11-NOV-18
  1    59      2601263    11-NOV-18 2601701    11-NOV-18
  1    60      2601701    11-NOV-18 2601705    11-NOV-18
  1    61      2601705    11-NOV-18 2601709    11-NOV-18
  1    62      2601709    11-NOV-18 2784642    12-NOV-18

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
9       13.50K     DISK        00:00:00     12-NOV-18
        BP Key: 9   Status: AVAILABLE  Compressed: NO  Tag: TAG20181112T195610
        Piece Name: /oracle_backup/DOMINO_O77/0bti2beq_1_1

  List of Archived Logs in backup set 9
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    65      2784741    12-NOV-18 2784798    12-NOV-18
  1    66      2784798    12-NOV-18 2784812    12-NOV-18
  1    67      2784812    12-NOV-18 2784830    12-NOV-18
recovery will be done up to SCN 2784849
Media recovery start SCN is 2397081
Recovery must be done beyond SCN 2397081 to clear datafile fuzziness
Finished restore at 12-NOV-18

    完全恢复是不可能的，并且 RMAN 报告了丢失的归档日志备份：

    no backup of archived log for thread 1 with sequence 63 and starting SCN of 2784642 found to restore
no backup of archived log for thread 1 with sequence 64 and starting SCN of 2784723 found to restore
no backup of archived log for thread 1 with sequence 68 and starting SCN of 2784830 found to restore
    • 2

相关问题