Search <book_title>...

Veritas NetBackup™ for Oracle 管理指南

Last Published: 2018-04-18

Product(s): NetBackup & Alta Data Protection (8.1.1)

从 Copilot 恢复点一步还原到 ASM 存储

以下步骤介绍如何使用 RMAN 从恢复点进行还原。只有当运行了 nborair -create_recovery_point 命令并在目标客户端装入了此恢复点之后，才可执行此步骤。

注意:

GUI 不提供一步还原到 ASM 存储的功能。只能使用 RMAN 运行此功能。

此步骤示例假定已装入恢复点，并以装入点 /db_mp 为例。所有 RMAN 命令都必须从目标主机运行。

从恢复点一步还原到 ASM 存储

从恢复点对备份进行编录。

RMAN> catalog start with '/db_mp/';

searching for all files that match the pattern /db_mp/

List of Files Unknown to the Database
=====================================
File Name: /db_mp/data_D-ORAC112_I-3955369132_TS-SYSAUX_FNO-2_8hrgu3qd_s-1297_I-3955369132
File Name: /db_mp/data_D-ORAC112_I-3955369132_TS-SYSTEM_FNO-1_8irgu3qk_s-1298_I-3955369132
File Name: /db_mp/data_D-ORAC112_I-3955369132_TS-UNDOTBS1_FNO-3_8jrgu3qr_s-1299_I-3955369132
File Name: /db_mp/data_D-ORAC112_I-3955369132_TS-USERS_FNO-4_8krgu3qt_s-1300_I-3955369132
File Name: /db_mp/arch_D-ORAC112_I-3955369132_SCN-5248163_a8rh0s3b
File Name: /db_mp/spfile_D-ORAC112_I-3955369132_T-20160929_a9rh0s3c
File Name: /db_mp/cf_D-ORAC112_I-3955369132_T-20160929_aarh0s3d

Do you really want to catalog the above files (enter YES or NO)? YES
cataloging files...
cataloging done

List of Cataloged Files
=======================
File Name: /db_mp/data_D-ORAC112_I-3955369132_TS-SYSAUX_FNO-2_8hrgu3qd_s-1297_I-3955369132
File Name: /db_mp/data_D-ORAC112_I-3955369132_TS-SYSTEM_FNO-1_8irgu3qk_s-1298_I-3955369132
File Name: /db_mp/data_D-ORAC112_I-3955369132_TS-UNDOTBS1_FNO-3_8jrgu3qr_s-1299_I-3955369132
File Name: /db_mp/data_D-ORAC112_I-3955369132_TS-USERS_FNO-4_8krgu3qt_s-1300_I-3955369132
File Name: /db_mp/arch_D-ORAC112_I-3955369132_SCN-5248163_a8rh0s3b
File Name: /db_mp/spfile_D-ORAC112_I-3955369132_T-20160929_a9rh0s3c
File Name: /db_mp/cf_D-ORAC112_I-3955369132_T-20160929_aarh0s3d

从恢复点的时间点还原数据文件。

以下示例将从磁盘 (DISK) 进行 RMAN 还原。此外，此示例还会使用 NLS_DATE_FORMAT="DD-MM-YYYY-HH24:MI:SS" 命令，此命令是在运行 RMAN 之前在环境中设置的。请使用适用于您环境的日期格式。

RMAN> restore until time '2016-09-29-10:00:00' database;

Starting restore at 2016-10-12:15:51:22
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=193 device type=DISK

channel ORA_DISK_1: restoring datafile 00001
input datafile copy RECID=461 STAMP=925055096 
file name=/demo_2/data_D-ORAC112_I-3955369132_TS-SYSTEM_FNO-1_8irgu3qk_s-1298_I-3955369132
destination for restore of datafile 00001: /db/orac112/app/oradata/orac112/system01.dbf
channel ORA_DISK_1: copied datafile copy of datafile 00001
output file name=/db/orac112/app/oradata/orac112/system01.dbf RECID=0 STAMP=0
Finished restore at 2016-10-12:15:51:34

恢复数据库。

如果无法从磁盘还原存档日志，则这些日志将从 NetBackup (sbt_tape) 进行还原。

RMAN> run
{
allocate channel ch00 type sbt_Tape;
recover database;
release channel ch00;
}

released channel: ORA_DISK_1
allocated channel: ch00
channel ch00: SID=193 device type=SBT_TAPE
channel ch00: Veritas NetBackup for Oracle - Release 8.0 (2016091418)

Starting recover at 2016-10-12:15:54:13

starting media recovery

archived log for thread 1 with sequence 508 is already on disk as file 
/db/orac112/app/fast_recovery_area/ORAC112/archivelog/2016_09_29/o1_mf_1_508_cytbkv22_.arc
archived log for thread 1 with sequence 509 is already on disk as file 
/db/orac112/app/fast_recovery_area/ORAC112/archivelog/2016_09_29/o1_mf_1_509_cytbkv36_.arc
....
archived log file name=
/db/orac112/app/fast_recovery_area/ORAC112/archivelog/2016_09_29/o1_mf_1_508_cytbkv22_.arc 
thread=1 sequence=508
archived log file name=
/db/orac112/app/fast_recovery_area/ORAC112/archivelog/2016_09_29/o1_mf_1_509_cytbkv36_.arc 
thread=1 sequence=509
....
media recovery complete, elapsed time: 00:00:55
Finished recover at 2016-10-12:15:55:09

released channel: ch00

RMAN>

从 Oracle Copilot 映像创建即时恢复点

关于使用适用于 Oracle 备份 (Copilot) 的 NetBackup 设备共享

使用共享在 NetBackup 设备 (Copilot) 上配置 OIP

更多信息

从 Oracle Copilot 映像创建即时恢复点