郭老师的帖子,咱也凑凑热闹总结一下自己!
以下均物理data guard
1、Data Guard的核心操作是什么?
redo send、redo receive、redo apply
redo send==>log_archive_dest_2;log_archive_dest_state_2=enable;LNSn(lgwr network server process)|LGWR
==>log_archive_dest_2;log_archive_dest_state_2=enable;ARCH|ARCH
redo receive==>redo buffer write to SRL;RFS(remote file server process)|LGWR
==>archivelog to archivelog;RFS(remote file server process)|ARCH
redo apply==>from SRL or archivelog to read redo data and application;MRP|LGWR
==>from archivelog to read redo data and application;MRP|ARCH
2、Data Guard日志的传输模式有几种,分别是什么,可以具体说说它们的工作模式吗?
2种、LGWR,ARCH、工作模式主库的不考虑了,只考虑与备库有关如下
LGWR==>redo buffer->standby redo logfiles;LNSn->RFS->SRL,MRP从SRL读取redo data并应用
ARCH==>logswitch->archivelog;ARCH->RFS->archivelog,MRP从archivelog读取redo data并应用
3、在部署Data Guard时,遇到最多的问题是什么?
细心度不够,参数不正确问题
GAP问题,主库归档存在可以重新注册,如果归档不存在且数据量巨大可以考虑基于SCN的增量备份来恢复data guard
4、Data Gurad主库备无法切换,存在的问题有可能是哪些?(OCM的考试中大部分人Data Guard做主备切换时,切不过去?)
切换次数不多,省略不总结了
5、Data Guard故障排:平时管理维护中碰到的错误及对应的解决方法?
问题
1、GAP
http://space.itpub.net/26442936/viewspace-722309
2、PROTECTION_MODE is UNPROTECTED at standby database
http://space.itpub.net/26442936/viewspace-750323
3、duplicate ora-19505 (controlfile 不可用)
http://space.itpub.net/26442936/viewspace-767942
4、duplicate ORA-01405: fetched column value is NULL
http://space.itpub.net/26442936/viewspace-767943
5、connected to auxiliary database (not started)
解决方法:sqlplus sys/oracle@orcl as sysdba保证能连接到启动的实例即可
6、ORA-19573: cannot obtain exclusive enqueue for datafile
以下均物理data guard
1、Data Guard的核心操作是什么?
redo send、redo receive、redo apply
redo send==>log_archive_dest_2;log_archive_dest_state_2=enable;LNSn(lgwr network server process)|LGWR
==>log_archive_dest_2;log_archive_dest_state_2=enable;ARCH|ARCH
redo receive==>redo buffer write to SRL;RFS(remote file server process)|LGWR
==>archivelog to archivelog;RFS(remote file server process)|ARCH
redo apply==>from SRL or archivelog to read redo data and application;MRP|LGWR
==>from archivelog to read redo data and application;MRP|ARCH
2、Data Guard日志的传输模式有几种,分别是什么,可以具体说说它们的工作模式吗?
2种、LGWR,ARCH、工作模式主库的不考虑了,只考虑与备库有关如下
LGWR==>redo buffer->standby redo logfiles;LNSn->RFS->SRL,MRP从SRL读取redo data并应用
ARCH==>logswitch->archivelog;ARCH->RFS->archivelog,MRP从archivelog读取redo data并应用
3、在部署Data Guard时,遇到最多的问题是什么?
细心度不够,参数不正确问题
GAP问题,主库归档存在可以重新注册,如果归档不存在且数据量巨大可以考虑基于SCN的增量备份来恢复data guard
4、Data Gurad主库备无法切换,存在的问题有可能是哪些?(OCM的考试中大部分人Data Guard做主备切换时,切不过去?)
切换次数不多,省略不总结了
5、Data Guard故障排:平时管理维护中碰到的错误及对应的解决方法?
问题
1、GAP
http://space.itpub.net/26442936/viewspace-722309
2、PROTECTION_MODE is UNPROTECTED at standby database
http://space.itpub.net/26442936/viewspace-750323
3、duplicate ora-19505 (controlfile 不可用)
http://space.itpub.net/26442936/viewspace-767942
4、duplicate ORA-01405: fetched column value is NULL
http://space.itpub.net/26442936/viewspace-767943
5、connected to auxiliary database (not started)
解决方法:sqlplus sys/oracle@orcl as sysdba保证能连接到启动的实例即可
6、ORA-19573: cannot obtain exclusive enqueue for datafile
http://space.itpub.net/26442936/viewspace-753432
总结是一种学习的态度!