• 053370


    Why should you back up a duplicated tablespace after a TSPITR is complete?
    A. The tablespace cannot be duplicated or restored to any point in time after the duplication.
    B. The tablespace cannot be duplicated or restored to the point in time before the duplication.
    C. The entire database cannot be restored after a TSPITR, so a backup is required.
    D. You cannot bring the tablespace online until its been backed up.
    E. There is no requirement to do so, as RMAN will back up the tablespace after the TSPITR.

      After you perform a TSPITR,you should back up the tablespace/datafile.If you do not,you will not be able to do a TSPITR to any point in time before the original TSPITR.
    执行完全自动执行的 TSPITR
    1. 配置在目标实例上执行 TSPITR 所需的通道。
    2. 使用 AUXILIARY DESTINATION 选项指定辅助目标。
    RMAN> CONNECT TARGET
    RMAN> RECOVER TABLESPACE users, example
    > UNTIL TIME '2007-06-29:08:00:00'
    > AUXILIARY DESTINATION
    > '/u01/app/oracle/oradata/aux'; 
    3. 备份恢复的表空间并使它们联机。
    RMAN>BACKUP TABLESPACE users, example;
    RMAN> SQL "ALTER TABLESPACE users, example ONLINE";
    执行完全自动执行的 TSPITR 时,还必须:
    • 配置在目标实例上执行 TSPITR 所需的任何通道
    • 指定 RMAN 用于数据文件辅助集和其它辅助实例文件的目标
    在 TSPITR 完成之后,备份恢复的表空间并使它们联机。执行 TSPITR 之后,不能使用
    TSPITR 之前创建的参与执行 TSPITR 的表空间的备份。 

  • 相关阅读:
    数据结构-线性表-链表
    [poj 2991]Crane[线段树表示向量之和,而非数量]
    vector要注意的点
    vector与deque的区别
    sendfile复习
    GPU和CPU的区别
    常用Linux命令 mount df dd
    可省略的关键字
    父类与子类的virtual
    加快编译的技巧 & mount及tmpfs
  • 原文地址:https://www.cnblogs.com/Babylon/p/7826205.html
Copyright © 2020-2023  润新知