[每日一题] 11gOCP 1z0-053 :2013-10-9 backup with the KEEP option(二)
will be obsolete on date 08-NOV-13
archived logs required to recover from this backup will be backed up
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current SPFILE in backup set
channel ORA_DISK_1: starting piece 1 at 09-OCT-13
channel ORA_DISK_1: finished piece 1 at 09-OCT-13
piece handle=/backup/rman/18om02ik_1_1 tag=TAG20131009T165347 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
current log archived
using channel ORA_DISK_1
backup will be obsolete on date 08-NOV-13
archived logs required to recover from this backup will be backed up
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=88 RECID=74 STAMP=828377685
channel ORA_DISK_1: starting piece 1 at 09-OCT-13
channel ORA_DISK_1: finished piece 1 at 09-OCT-13
piece handle=/backup/rman/19om02im_1_1 tag=TAG20131009T165347 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
using channel ORA_DISK_1
backup will be obsolete on date 08-NOV-13
archived logs required to recover from this backup will be backed up
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current control file in backup set
channel ORA_DISK_1: starting piece 1 at 09-OCT-13
channel ORA_DISK_1: finished piece 1 at 09-OCT-13
piece handle=/backup/rman/1aom02in_1_1 tag=TAG20131009T165347 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 09-OCT-13
这个例子中使用了keep until time子句，它使RMAN在指定(sysdate+30)时间一过就标记此备份为废弃的。当然，如果指定的是keep forever子句，此备份将永不废弃。也就是说，此备份将永远不被备份保留策略删除。
[html]
RMAN> backup database
2> format '/backup/rman/%U'
3> keep forever
4> restore point firstforever;
Starting backup at 09-OCT-13
current log archived
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 10/09/2013 17:00:13
RMAN-06522: KEEP FOREVER option is not supported without the recovery catalog
注：keep forever一定要有恢复目录！！！
方法二：用更改命令更改现在有备份状态。
使用change命令的keep选项更改普通备份的状态为归档备份的状态。
[html]
RMAN> change backup
Tar ‘guoyJoe_bkp’
keep forever;
其中，change命令把一个例行的备份转换为永不废弃(keep forever)的一个归档备份。因此，change命令更改一个备份或副本相对于配置保留策略的exemption状态。如果想使用一个长期的备份(不可删除)成为一个可以删除的备份，可通过执行以下命令：
[html]
RMAN> change copy of database controlfile nokeep;
注：对于存储在闪回恢复区中的备份文件，不能使用change …keep命令。
Nokeep选项使数据文件和控制文件备份的长期镜像副本处于配置只留策略的管辖范围内，从而保证它们最终变成废弃状态。
5、 还原归档备份
还原一个归档备份的最简单办法就是创建一个临时实例后使用duplicate命令。下面是个过程的简要汇总。
（1） 准备辅助实例，包括创建一个辅助实例的duplicate命令的常用预备步骤，如创建口令文件和初始化参数文件等。还必须对辅助实例建立
Oracle Net连接并启动辅助实例。
（2） 连接到恢复目录、目标和辅助实例
[html]
RMAN > connect target sys/oracle@guoyJoe
RMAN >connect catalog rc_admin/rc_admin@gyj
RMAN>connect auxiliary /