Chinaunix首页 | 论坛 | 博客
  • 博客访问: 55734
  • 博文数量: 38
  • 博客积分: 10
  • 博客等级: 民兵
  • 技术积分: 360
  • 用 户 组: 普通用户
  • 注册时间: 2012-07-11 14:02



发布时间:2017-12-07 13:48:14

保護模式Maximum protection mode因某些故障在事務提交前,如主庫online redo log不能傳輸到至少一組備庫的standby redo log file中,主庫將自動關閉。必須用LGWR SYNC AFFIRM Maximum availability modeLike maximum protection mode, a transaction will not commit until the redo needed to recover that.........【阅读全文】

阅读(1413) | 评论(0) | 转发(0)

发布时间:2017-12-07 13:48:14

1.   LGWRLGWR參數在log buffer寫入redo log file的同時利用LNS進程(LGWR network server)將redo data傳輸到遠程standby中的standby redo log file,再在主庫日志切換時同時standby redo log file歸檔至archived redo log file再產生數據至standby database。如果使用在開啟standby時指定read time apply將.........【阅读全文】

阅读(1466) | 评论(0) | 转发(0)

发布时间:2017-12-07 13:48:14

10) Now restore the datafiles to new locations and recover. Since we are recovering the database here till the archivelog sequence 50 the sequence number in the SET UNTIL SEQUENCE clause should be  50 (+1) RMAN> run  {  set until sequence 51;  set newnam.........【阅读全文】

阅读(1424) | 评论(0) | 转发(0)

发布时间:2017-12-07 13:48:14

环境:Red Hat Enterprise Linux AS release 4 (Nahant)      Oracle Database 10g Enterprise Edition Release - Prod备库中:SELECT current_scn+1 FROM V$DATAFILE主库中:[oracle@smt u01]$ rman target /Recovery Manager: Release - Production on 琍戳き 5る 11 .........【阅读全文】

阅读(1533) | 评论(0) | 转发(0)

发布时间:2017-12-07 13:48:14

 When the issue occurred, please perform. the following:1. Please provide the OSWatcher output You can refer following note for details:Note:301137.1 OS Watcher User Guide2. please systemstate and hanganalyze dumpA. Identify the SID you want to traceexport ORACLE_SID=PRODReplace PROD with th.........【阅读全文】

阅读(1509) | 评论(0) | 转发(0)

登录 注册