ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Tablespace Point-in-Time Recovery

Tablespace Point-in-Time Recovery

原创 Linux操作系统 作者:abp0109 时间:2011-03-25 16:40:48 0 删除 编辑

Recovery Manager automated Tablespace Point-in-Time Recovery(TSPITR) enables you to recovery one or more tablespaces to a point in time that is different from that of the rest of the database.RMAN TSPITR is more useful in these cases:

★ To recovery from an erroneous drop or truncate table operation.

★ To recovery a table that has become logically corrupted.

★ To recovery from an incorrect batch job or other DML statement that has affected only a subset of the database.

★ In cases where there are multiple logical schemas in separate tablespaces of one physical database,and where one schema must be recovered to a point different from that of the rest of the physical database.

★ For VLDBs(Very Large Databases),even if a full database point-in-time recovery would suffice,you might choose to do tablespace point-in-time recovery rather than restore the whole database from a backup and perform. a complete database roll forward.

Similar to a table export,RMAN TSPITR enables you to recovery a consistent data set;however,the data set is the entire tablespace rather than a single object.

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/23219371/viewspace-690513/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2010-01-21

  • 博文量
    17
  • 访问量
    30651