Oracle文档学习 笔记(五)

27.Data Guard
Note: To protect against unlogged direct writes in the primary
database that cannot be propagated to the standby database, turn
on FORCE LOGGING at the primary database before taking datafile
backups for standby creation. Keep the database (or at least
important tablespaces) in FORCE LOGGING mode as long as the
standby database is active.
(在为备份库做数据备份前，主库需设置强迫提交属性(如何设置?))
As application transactions make changes to the primary database, the changes are
logged locally in redo logs, which are sent to the standby databases by log transport
services and applied by log apply services.
For physical standby databases, the changes are applied to each physical standby
database that is running in managed recovery mode. For logical standby databases,
the changes are applied using SQL regenerated from the archived redo logs.
(主库中应用事务的改变被记录到重做日志，通过日志传送服务及应用服务发送到备库)
(作为物理的备库必须运行在备份模式下，作为逻辑的备库应用的改变由归档日志通过SQL语句来应用)即：
SQL>startup nomount pfile=’ D:\oracle\admin\pennon\pfile\init.ora’
SQL>alter database mount standby database;
SQL>alter database recover managed standby database disconnect from session;
SQL>alter database recover managed standby database cancel;
SQL>alter database open read only;