oracle的日志文件组中,活动组和当前组各是什么含意呢?怎么查询呢?
oracle的日志文件组中,活动组和当前组各是什么含意呢?怎么查询呢?
通过 select * from v$log; 得到的 STATUS 列中的内容,是不是表示 当前组呢?那么,活动组怎么查询到呢?
------解决方案--------------------Online Redo Log Files
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.