Chinaunix首页 | 论坛 | 博客
  • 博客访问: 153383
  • 博文数量: 56
  • 博客积分: 1435
  • 博客等级: 上尉
  • 技术积分: 640
  • 用 户 组: 普通用户
  • 注册时间: 2008-11-26 09:58
文章分类

全部博文(56)

文章存档

2009年(52)

2008年(4)

我的朋友

分类: Oracle

2009-02-10 15:50:42

What is the difference between restoring and recovering?
 
from:

Restoring involves copying backup files from secondary storage (backup media) to disk. This can be done to replace damaged files or to copy/move a database to a new location.
Recovery is the process of applying redo logs to the database to roll it forward. One can  roll-forward until a specific point-in-time (before the disaster occurred), or roll-forward until the last transaction recorded in the log files.
 SQL> connect SYS as SYSDBA
 SQL> RECOVER DATABASE UNTIL TIME '2001-03-06:16:00:00' USING BACKUP CONTROLFILE;
 RMAN> run {
   set until time to_date('04-Aug-2004 00:00:00', 'DD-MON-YYYY HH24:MI:SS');
   restore database;
   recover database;
 }
阅读(794) | 评论(0) | 转发(0) |
0

上一篇:几个网站

下一篇:CBO,RBO在ORACLE中的应用

给主人留下些什么吧!~~