主页 / dba / 问题 / 56326
Accepted
kupa
Asked: 2014-01-08 22:50:36 +0800 CST

RMAN 列出恢复指定备份所需的归档日志

  • 772

我在 2013 年 12 月 31 日备份了数据文件。它成功完成了数据文件备份，但归档日志备份失败。

现在，我想确定应该备份哪些归档日志，以确保在恢复 31.12.2013 数据文件备份后可以恢复我的数据库。

oracle recovery

2 个回答

  1. 根据您的要求以及此后您所做的其他备份，您可以使用（来自http://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmreprt.htm#BRADV89594）：

    REPORT NEED BACKUP RECOVERY WINDOW OF n DAYS
Displays objects requiring backup to satisfy a recovery window-based retention policy.

REPORT NEED BACKUP REDUNDANCY n
Displays objects requiring backup to satisfy a redundancy-based retention policy.

REPORT NEED BACKUP DAYS n
Displays files that require more than n days' worth of archived redo log files for recovery.

REPORT NEED BACKUP INCREMENTAL n
Displays files that require application of more than n incremental backups for recovery.

    这些将告诉您需要备份哪些文件以提供“n”天的恢复能力或“n”冗余。

    • 3
  2. Best Answer

    您可以尝试（至少需要 Oracle 10g）：

    RESTORE DATABASE PREVIEW;

    您至少需要在整个备份操作期间生成的存档日志。

    快速演示：

    C:\Users>rman target /

Recovery Manager: Release 12.1.0.1.0 - Production on Wed Jan 8 14:34:28 2014

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

connected to target database: CDB12C (DBID=4034496039)

RMAN> list backup of database summary completed after 'sysdate - 1';

using target database control file instead of recovery catalog

List of Backups
===============
Key     TY LV S Device Type Completion Time    #Pieces #Copies Compressed Tag
------- -- -- - ----------- ------------------ ------- ------- ---------- ---
1       B  F  A DISK        08-jan-14:14:23:45 1       1       NO         TAG20140108T141855
2       B  F  A DISK        08-jan-14:14:24:48 1       1       NO         TAG20140108T141855
3       B  F  A DISK        08-jan-14:14:25:46 1       1       NO         TAG20140108T141855

RMAN> restore database preview summary from tag = TAG20140108T141855;

Starting restore at 08-jan-14:14:34:47
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=30 device type=DISK


List of Backups
===============
Key     TY LV S Device Type Completion Time    #Pieces #Copies Compressed Tag
------- -- -- - ----------- ------------------ ------- ------- ---------- ---
1       B  F  A DISK        08-jan-14:14:23:44 1       1       NO         TAG20140108T141855
3       B  F  A DISK        08-jan-14:14:25:30 1       1       NO         TAG20140108T141855
2       B  F  A DISK        08-jan-14:14:24:31 1       1       NO         TAG20140108T141855
using channel ORA_DISK_1

List of Archived Log Copies for database with db_unique_name CDB12C
=====================================================================

Key     Thrd Seq     S Low Time
------- ---- ------- - ------------------
1       1    13      A 03-jan-14:15:01:14
        Name: C:\APP\ORACLE\FAST_RECOVERY_AREA\CDB12C\ARCHIVELOG\2014_01_08\O1_MF_1_13_9DTNSSGR_.ARC

Media recovery start SCN is 2475111
Recovery must be done beyond SCN 2475373 to clear datafile fuzziness
Finished restore at 08-jan-14:14:34:49



RMAN> list archivelog from scn 2475111 until scn 2475374;

List of Archived Log Copies for database with db_unique_name CDB12C
=====================================================================

Key     Thrd Seq     S Low Time
------- ---- ------- - ------------------
1       1    13      A 03-jan-14:15:01:14
        Name: C:\APP\ORACLE\FAST_RECOVERY_AREA\CDB12C\ARCHIVELOG\2014_01_08\O1_MF_1_13_9DTNSSGR_.ARC

    请注意restore ... preview输出中的 scn min-max 指示：

    媒体恢复开始 SCN 为 2475111 必须在 SCN 2475373 之后进行恢复以清除数据文件的模糊性

    因此，为了超出指定的 scn，我们搜索包含 scn 2475373 + 1 的归档日志。

    如果要手动验证，请检查以下 MOS 注意：
    如何确定 RMAN 备份恢复的最小端点（文档 ID 1329415.1）

    • 3

相关问题