ITPub博客

首页 > Linux操作系统 > Linux操作系统 > rman_restore controlfile_and_autobackup之关系测试

rman_restore controlfile_and_autobackup之关系测试

原创 Linux操作系统 作者:wisdomone1 时间:2010-01-30 21:02:47 0 删除 编辑

1,如下表明:控制文件完完情况下,恢复控制文件从autobackup去找对应备份,所以你一定要形成配置spfile和controlfile自动备份的好习惯,不然,呵呵
RMAN> restore controlfile;

Starting restore at 30-JAN-10
using channel ORA_DISK_1

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 01/30/2010 20:55:50
RMAN-06563: control file or SPFILE must be restored using FROM AUTOBACKUP

2,再次证明,还是另外配置一个catalog库吧,不然你直接用生产库跑rman,哪就玩完了,呵呵,一旦生产库的控制文件没了,而且你呢,没搞备份,哈哈,你所作的所有备份没有一点用



3,再次引录一节我的小测试

RMAN> set dbid=3005679176;

executing command: SET DBID

RMAN> restore spfile to '/oracle/spfilecentos.ora' from autobackup;

Starting restore at 30-JAN-10
using channel ORA_DISK_1

recovery area destination: /oracle/flash_recovery_area
database name (or database unique name) used for search: CENTOS
channel ORA_DISK_1: no autobackups found in the recovery area
channel ORA_DISK_1: looking for autobackup on day: 20100130
channel ORA_DISK_1: looking for autobackup on day: 20100129
channel ORA_DISK_1: looking for autobackup on day: 20100128
channel ORA_DISK_1: looking for autobackup on day: 20100127
channel ORA_DISK_1: looking for autobackup on day: 20100126
channel ORA_DISK_1: looking for autobackup on day: 20100125
channel ORA_DISK_1: looking for autobackup on day: 20100124
channel ORA_DISK_1: no autobackup in 7 days found
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 01/30/2010 20:55:00
RMAN-06172: no autobackup found or specified handle is not a valid copy or piece


4,以上所作皆与data guard有关,为模拟主库控制文件完完,但之前对控制文件作了备份

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

请登录后发表评论 登录
全部评论
提供针对oracle初学者及进阶的数据库培训,欢迎大家咨询: 微信: wisdomone 微信公众号: lovedb 工作经历: 中国普天 北京科蓝 北京云和恩墨 北京神州新桥

注册时间:2008-04-04

  • 博文量
    2189
  • 访问量
    12689910