1. 상태 확인 SQL> select * from v$log; redo log file의 상태를 확인 v$log 의 status 컬럼 UNUSED - Online redo log has never been written to. This is the state of a redo log that was just added, or just after a RESETLOGS, when it is not the current redo log. CURRENT - Current redo log. This implies that the redo log is active. The redo log could be open or closed. ACTIVE - Log is active but is not the current ..
[ORACLE] Database 관리 : Redo log file 관리
1. 상태 확인 SQL> select * from v$log; redo log file의 상태를 확인 v$log 의 status 컬럼 UNUSED - Online redo log has never been written to. This is the state of a redo log that was just added, or just after a RESETLOGS, when it is not the current redo log. CURRENT - Current redo log. This implies that the redo log is active. The redo log could be open or closed. ACTIVE - Log is active but is not the current ..
2010.04.06