oracle的日志文件组中,活动组和当前组各是什么含意呢?怎么查询呢?通过 select * from v$log; 得到的 STATUS 列中的内容,是不是表示 当前组呢?那么,活动组怎么查询到呢?
解决方案 »
- 请教:存储过程中重复数据排除方法
- oracle9i创建临时表时报错 不知什么原因
- oracle高手请进!!求教不定行转列建视图的问题
- 获得外键名称
- 这个rollup要怎么写?
- 从网上搜了一个ORACLE发送邮件的过程,目前邮件可以正常发送,但接收到的附件都是空的,请大神帮忙看看啥情况?
- OracleServiceORCL服务过一段时间需要重启,否则连接超时?
- ora9i中的system,sys的密码怎么恢复!!!
- Oracle8i 服务OracleOraHome81ManagementServer不能启动(OS is Win2000)
- orcal如何判断查询截取的字符串是否等于某个字符串
- Oracl查询时间取最大时间?
- 如何添加字段
Every Oracle database has a set of two or more online redo log files. Oracle assigns every redo log file a unique log sequence number to identify it. The set of redo log files for a database is collectively known as the database's redo log. Oracle uses the redo log to record all changes made to the database.Archived Redo Log Files
An archived redo log is an online redo log that Oracle has filled with redo entries, rendered inactive, and copied to one or more destinations specified in the parameter file. You can run Oracle in either of two archive modes: ARCHIVELOG
Oracle archives the filled online redo log files before reusing them in the cycle.
NOARCHIVELOG
Oracle does not archive the filled online redo log files before reusing them in the cycle.
Note that you should not back up the online redo log files, nor should you ever need to restore them; you keep redo logs by archiving them.