inactive表示该日志在实例恢复时不再需要被用到,仅此而已,和是否归档没有任何关系,前端时间看到pub上有人问起这个问题,我们通常看到状态为inactive的日志archived=YES也就是通常都归档了,不太容易观察到archived=no,在9i下可以通过设置log_archive_start=false来控制不归档,但是10g是否不太容易控制,这里通过缩小flash_recovery_area使其没有空间从而不能实现归档来观察一下状态为inactive且archived=no的日志!
SQL> select group#,sequence#,status,archived from v$log;
GROUP# SEQUENCE# STATUS ARC
---------- ---------- ---------------- ---
1 122 INACTIVE NO
2 121 INACTIVE YES
3 123 CURRENT NO
SQL> archive log list;
数据库日志模式 存档模式
自动存档 启用
存档终点 USE_DB_RECOVERY_FILE_DEST
最早的联机日志序列 120
下一个存档日志序列 122
当前日志序列 122
SQL> show parameter recovery
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string E:oracleproduct10.2.0flash
_recovery_area
db_recovery_file_dest_size big integer 2G
recovery_parallelism integer 0
SQL> alter system set db_recovery_file_dest_size=1g;
系统已更改。
SQL> alter system set db_recovery_file_dest_size=500m;
系统已更改。
SQL> alter system set db_recovery_file_dest_size=300m;
系统已更改。
SQL> select group#,sequence#,status,archived from v$log;
GROUP# SEQUENCE# STATUS ARC
---------- ---------- ---------------- ---
1 122 CURRENT NO
2 121 INACTIVE YES
3 120 INACTIVE YES
SQL> alter system switch logfile;
系统已更改。
SQL> select group#,sequence#,status,archived from v$log;
GROUP# SEQUENCE# STATUS ARC
---------- ---------- ---------------- ---
1 122 ACTIVE NO
2 121 INACTIVE YES
3 123 CURRENT NO
SQL> select group#,sequence#,status,archived from v$log;
GROUP# SEQUENCE# STATUS ARC
---------- ---------- ---------------- ---
1 122 ACTIVE NO
2 121 INACTIVE YES
3 123 CURRENT NO
SQL> select group#,sequence#,status,archived from v$log;
GROUP# SEQUENCE# STATUS ARC
---------- ---------- ---------------- ---
1 122 ACTIVE NO
2 121 INACTIVE YES
3 123 CURRENT NO
SQL> select group#,sequence#,status,archived from v$log;
GROUP# SEQUENCE# STATUS ARC
---------- ---------- ---------------- ---
1 122 ACTIVE NO
2 121 INACTIVE YES
3 123 CURRENT NO
SQL> alter system checkpoint;
系统已更改。
SQL> select group#,sequence#,status,archived from v$log;
GROUP# SEQUENCE# STATUS ARC
---------- ---------- ---------------- ---
1 122 INACTIVE NO
2 121 INACTIVE YES
3 123 CURRENT NO
SQL>
SQL> desc v$flash_recovery_area_usage
名称 是否为空? 类型
----------------------------------------- -------- ----------------------------
FILE_TYPE VARCHAR2(12)
PERCENT_SPACE_USED NUMBER
PERCENT_SPACE_RECLAIMABLE NUMBER
NUMBER_OF_FILES NUMBER
SQL> select* from v$flash_recovery_area_usage;
FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES
------------ ------------------ ------------------------- ---------------
CONTROLFILE 2.34 0 1
ONLINELOG 0 0 0
ARCHIVELOG 99.83 0 46
BACKUPPIECE 0 0 0
IMAGECOPY 0 0 0
FLASHBACKLOG 30.4 26.79 16
已选择6行。
SQL>
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/19602/viewspace-1007330/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/19602/viewspace-1007330/