Oracle 10g跨越Resetlogs时间点进行恢复

来源：pcdog 作者：佚名 出处：巧巧读书 2008-05-05 进入讨论组

• 关 键 词：
• oracle 10g
• oracle数据库
• switch
• 备份数据库
• flash

下一页 1 2 3 4 

原因：日志序号会被置位，以此防止后续日志被应用。resetlogs之前的备份将不能用于进行跨域resetlogs时间点的恢复。

在Oracle数据库10g中，Oracle允许跨越resetlogs时间点进行完全/不完全恢复。

本文将针对此特性介绍一个详细的参考示例:

一、全备份数据库

$ rman target /

Recovery Manager: Release 10.1.0.2.0 - 64bit Production

Copyright (c) 1995, 2004, Oracle. All rights reserved.

connected to target database: EYGLE (DBID=1337390772)

RMAN> backup database plus archivelog delete all input;

Starting backup at 2005-04-05 16:29:08

current log archived

using target database controlfile instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: sid=143 devtype=DISK

channel ORA_DISK_1: starting archive log backupset

channel ORA_DISK_1: specifying archive log(s) in backup set

input archive log thread=1 sequence=3 recid=294 stamp=554823466

input archive log thread=1 sequence=4 recid=295 stamp=554828647

input archive log thread=1 sequence=5 recid=297 stamp=554833749

channel ORA_DISK_1: starting piece 1 at 2005-04-05 16:29:16

channel ORA_DISK_1: finished piece 1 at 2005-04-05 16:29:19

piece handle=/data5/flash_recovery_area/EYGLE/backupset/2005_04_05

/o1_mf_annnn_TAG20050405T162914_154m2woc_.bkp comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:04

channel ORA_DISK_1: deleting archive log(s)

archive log filename=/data5/flash_recovery_area/EYGLE

/archivelog/2005_04_05

/o1_mf_1_3_154919qm_.arc recid=294 stamp=554823466

archive log filename=/data5

/flash_recovery_area/EYGLE/archivelog/2005_04_05

/o1_mf_1_4_154g3728_.arc recid=295 stamp=554828647

archive log filename=/data5/flash_recovery_area/EYGLE/archivelog

/2005_04_05/o1_mf_1_5_154m2og4_.arc recid=297 stamp=554833749

Finished backup at 2005-04-05 16:29:20

Starting backup at 2005-04-05 16:29:21

using channel ORA_DISK_1

channel ORA_DISK_1: starting full datafile backupset

channel ORA_DISK_1: specifying datafile(s) in backupset

input datafile fno=00009 name=/data1/oradata/systemfile/bigtbs.dbf

input datafile fno=00001 name=/opt/oracle/oradata/eygle/system01.dbf

input datafile fno=00006 name=/opt/oracle/oradata/eygle/EYGLE/datafile/o1_mf_test_03xv34ny_.dbf

input datafile fno=00002 name=/opt/oracle/oradata/eygle/undotbs01.dbf

input datafile fno=00003 name=/opt/oracle/oradata/eygle/sysaux01.dbf

input datafile fno=00010 name=/opt/oracle/oradata/eygle/dfmbrc.dbf

input datafile fno=00008 name=/opt/oracle/oradata/eygle/trans01.dbf

channel ORA_DISK_1: starting piece 1 at 2005-04-05 16:29:22

channel ORA_DISK_1: finished piece 1 at 2005-04-05 16:31:07

piece handle=/data5/flash_recovery_area/EYGLE/backupset

/2005_04_05/o1_mf_nnndf_TAG20050405T162921_154m33kf_.bkp comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:01:45

channel ORA_DISK_1: starting full datafile backupset

channel ORA_DISK_1: specifying datafile(s) in backupset

input datafile fno=00005 name=/data1/oradata/systemfile/eygle01.dbf

input datafile fno=00004 name=/opt/oracle/oradata/eygle/users01.dbf

input datafile fno=00007 name=/opt/oracle/oradata/eygle/EYGLE/datafile/o1_mf_itpub_03xv5g66_.dbf

channel ORA_DISK_1: starting piece 1 at 2005-04-05 16:31:08

channel ORA_DISK_1: finished piece 1 at 2005-04-05 16:31:33

piece handle=/data5/flash_recovery_area/EYGLE/backupset/2005_04_05

/o1_mf_nnndf_TAG20050405T162921_154m6dxm_.bkp comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:25

channel ORA_DISK_1: starting full datafile backupset

channel ORA_DISK_1: specifying datafile(s) in backupset

input datafile fno=00011 name=/opt/oracle/oradata/eygle/t2k01.dbf

channel ORA_DISK_1: starting piece 1 at 2005-04-05 16:31:34

channel ORA_DISK_1: finished piece 1 at 2005-04-05 16:31:41

piece handle=/data5/flash_recovery_area/EYGLE/backupset

/2005_04_05/o1_mf_nnndf_TAG20050405T162921_154m76kz_.bkp comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:07

Finished backup at 2005-04-05 16:31:41

Starting backup at 2005-04-05 16:31:41

current log archived

using channel ORA_DISK_1

channel ORA_DISK_1: starting archive log backupset

channel ORA_DISK_1: specifying archive log(s) in backup set

input archive log thread=1 sequence=6 recid=298 stamp=554833902

channel ORA_DISK_1: starting piece 1 at 2005-04-05 16:31:44

channel ORA_DISK_1: finished piece 1 at 2005-04-05 16:31:47

piece handle=/data5/flash_recovery_area/EYGLE/backupset/2005_04_05

/o1_mf_annnn_TAG20050405T163142_154m7jpo_.bkp comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:04

channel ORA_DISK_1: deleting archive log(s)

archive log filename=/data5/flash_recovery_area/EYGLE/archivelog

/2005_04_05/o1_mf_1_6_154m7gb3_.arc recid=298 stamp=554833902

Finished backup at 2005-04-05 16:31:47

更多内容请看Oracle 10g基础应用、Oracle 10g优化恢复、备份恢复专题，或进入讨论组讨论。

下一页 1 2 3 4 

【收藏此文】【大 中 小】【打印】【关闭】

较早的文章：Oracle数据库提供的多种安全性措施

较新的文章：带你快速了解Oracle数据库提供的恢复机制