Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
发新帖

2135

积分

502

好友

184

主题
1#
发表于 2012-2-28 22:30:09 | 查看: 7634| 回复: 3
Question :recover database until scn 100 ,包不包含100这个时刻的数据?
下载专业ORACLE数据库恢复工具PRM-DUL  For Oracle http://www.parnassusdata.com/zh-hans/emergency-services

如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复!

诗檀软件专业数据库修复团队

服务热线 : 13764045638  QQ: 47079569   
4#
发表于 2012-12-21 14:47:56
如果指定恢复到until change 123,那么不包含到123,是到122
但是datafile恢复的checkpoint_change#却是123
db:9.2.0.4
os:windows 2003 32 bit

如下
SQL> recover database using backup controlfile until change 46778968271
ORA-00279: change 46778968269 generated at 12/19/2012 11:28:47 needed for
thread 1
ORA-00289: suggestion : E:\ARCHIVELOG\ARC1154506.001
ORA-00280: change 46778968269 for thread 1 is in sequence #1154506


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
auto
Log applied.
Media recovery complete.
SQL> select distinct checkpoint_change# from v$datafile_header;

CHECKPOINT_CHANGE#
------------------
        4.6779E+10

SQL> set numw 12
SQL> r
  1* select distinct checkpoint_change# from v$datafile_header

CHECKPOINT_CHANGE#
------------------
       46778968271

SQL>

回复 只看该作者 道具 举报

3#
发表于 2012-2-28 22:46:58
其他的选项如 until sequence 、 until time 也是类似的:

Following are examples of typical date settings in RMAN commands:

BACKUP ARCHIVELOG FROM TIME 'SYSDATE-31' UNTIL TIME 'SYSDATE-14';
RESTORE DATABASE UNTIL TIME "TO_DATE('09/20/00','MM/DD/YY')";
Keywords and Parameters

Syntax Element         Description
UNTIL TIME = 'date_string'

Specifies a time as an upper limit. RMAN selects only files that can be used to recover up to but not including the specified time. For example, LIST BACKUP UNTIL TIME 'SYSDATE-7' lists all backups that could be used to recover to a point one week ago.

UNTIL SCN = integer

Specifies an SCN as an upper limit. RMAN selects only files that can be used to recover up to but not including the specified SCN. For example, RESTORE DATABASE UNTIL SCN 1000 chooses only backups that could be used to recover to SCN 1000.

UNTIL SEQUENCE = integer THREAD = integer

Specifies a redo log sequence number and thread as an upper limit. RMAN selects only files that can be used to recover up to but not including the specified sequence number. For example, REPORT OBSOLETE UNTIL SEQUENCE 8000 THREAD 1 reports only backups that could be used to recover through log sequence 7999.

回复 只看该作者 道具 举报

2#
发表于 2012-2-28 22:31:31
Answer:

Until change
Performs a incomplete recovery.
The number that follows until change is an SCN. In order to recover up to and including SCN 999, use recover until change 1000.

recover until  scn 100  , 不recover 到包含scn 100 时刻的数据变化,  但是recover 包含 到scn 99的数据变化。

回复 只看该作者 道具 举报

您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-11-16 07:47 , Processed in 0.047481 second(s), 21 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569