아카이브 로그 조회
DB CAFE
thumb_up 추천메뉴 바로가기
- DBA { Oracle DBA 명령어 > DBA 초급 과정 > DBA 고급 과정 }
- 튜닝 { 오라클 튜닝 목록 }
- 모델링 { 데이터 모델링 가이드 }
아카이브 리두 로그 파일 조회 뷰[편집]
- Archived Redo Log Files Views
Dynamic Performance View | 설명 |
---|---|
Dynamic Performance View | Description |
V$DATABASE |
Shows if the database is in ARCHIVELOG or NOARCHIVELOG mode and if MANUAL (archiving mode) has been specified. |
V$ARCHIVED_LOG |
Displays historical archived log information from the control file. If you use a recovery catalog, the RC_ARCHIVED_LOG view contains similar information. |
V$ARCHIVE_DEST |
Describes the current instance, all archive destinations, and the current value, mode, and status of these destinations. |
V$ARCHIVE_PROCESSES |
Displays information about the state of the various archive processes for an instance. |
V$BACKUP_REDOLOG |
Contains information about any backups of archived logs. If you use a recovery catalog, the RC_BACKUP_REDOLOG contains similar information. |
V$LOG |
Displays all redo log groups for the database and indicates which need to be archived. |
V$LOG_HISTORY |
Contains log history information such as which logs have been archived and the SCN range for each archived log. |