9i Standby 添加Datafile自动维护
关键: standby_file_management=auto
例子：
Media Recovery Log
/home/oracle/9.2.0/dbs/archarch1_792.dbf
Mon Dec 22 16:32:51 2003
Recovery created file /oradata/misc/filter02.dbf
Successfully added datafile 5 to media recoveryDatafile #5: '/oradata/misc/filter02.dbf'
Media Recovery Waiting for thread 1 seq# 793
Nologging操作（8i）
1。DBA管理规范：一般情况下，不允许进行Nologging操作
2。事后补救：
Media Recovery Log /archivelog/biddbstandby/biddb_arch_1_36640.arc
Recovery is repairing media corrupt block 11 of file 17
Recovery is repairing media corrupt block 12 of file 17
Recovery is repairing media corrupt block 13 of file 17
Recovery is repairing media corrupt block 14 of file 17
Recovery is repairing media corrupt block 15 of file 17
SQL>SELECT NAME, UNRECOVERABLE_CHANGE# FROM V$DATAFILE order by 2 asc比较Production和Standby的结果。
把受影响的Datafile从Production重新备份，恢复到Standby
Nologging操作(9i)
SQL> select force_logging from v$database;
FORCE_LOGGING
---
NO
SQL> alter database force logging;
Database altered.
SQL> select force_logging from v$database;
FORCE_LOGGING
---
YES
Standby + RAC
Prod：RAC 多节点Standby：可以是RAC单节点或者多节点这个是Oracle推荐的RAC 高可用性解决方案RAC—解决节点失败，OS失败等问题DataGuard—解决存储失败，Site失败等问题。
百度搜索“77cn”或“免费范文网”即可找到本站免费阅读全部范文。收藏本站方便下次阅读，免费范文网，提供经典小说医药卫生Oracle Standby Database - Unix技术网 = 全球最大 …(2)在线全文阅读。
相关推荐：