创建控制文件快照

530阅读 0评论2022-05-04 brjl
分类:Oracle

如果备库控制文件损坏,adg需要继续保持同步,那么如何修复
应该从主库拿最新的控制文件,然后配置一下

  1. sqlplus / as sysdba
  2. alter database create standby controlfile as '/tmp/prod_for_standby.ctl';

  3. rman target /
  4. backup format='/tmp/prod_standby.ctl' current controlfile for standby;


  5. backup format='/tmp/prod_standby.ctl' as copy current controlfile for standby;


  6. run {
  7. allocate channel d1 device type disk format '/backup/%U';
  8. allocate channel d2 device type disk format '/backup/%U';
  9. sql 'alter system archive log current'
  10. backup database include current controlfile for standby;
  11. sql 'alter system archive log current';
  12. backup archivelog all;
  13. }

上一篇:数据库启不来,很怕怕 ora-600 ORA_NPI_ERROR
下一篇:在备库发起一个一致的备份