Some data definition language statements (such as CREATE TABLE) allow the
NOLOGGING clause, which causes some database operations not to generate redo
records in the database redo log. The NOLOGGING setting can speed up operations that
can be easily recovered outside of the database recovery mechanisms, but it can
negatively affect media recovery and standby databases.
Oracle Database lets you force the writing of redo records even when NOLOGGING has
been specified in DDL statements. The database never generates redo records for
temporary tablespaces and temporary segments, so forced logging has no affect for
objects.
指定强制日志模式
1. 有些DDL语句可指定NOLOGGING子句 , 以此在默写数据库操作时将不产生重做日志 .
对于该模式 , 在数据外的恢复机制下容易恢复 , 但对于介质恢复和备用数据库模式则很难
2. 使用force logging , 即使是在DDL语句中包含NOLOGGING也会强制写日志
3. 对于临时表空间和临时段 , 数据库不记重做日志
4. 该模式对于对象无效
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/10599713/viewspace-995746/ ，如需转载，请注明出处，否则将追究法律责任。
-
博文量740
-
访问量2002849
最新文章
- 人力&人手&人才&人物
- oracle树中prior的用法
- Using Supplied Packages to Manage Stored Outlines
- $ORACLE_HOMERDBMSADMIN目录下各SQL的含义
- PRODUCT_USER_PROFILE Table
- Backing Up Server Parameter Files with RMAN
- Backing Up Control Files with RMAN
- Backing Up Individual Tablespaces with RMAN
- Making Whole Database Backups with RMAN
- 目睹奥运火炬传递
