Database Administration (MOSC)

MOSC Banner

log_archive_format 관련 문의드립니다.

edited Apr 26, 2022 8:45AM in Database Administration (MOSC) 1 commentAnswered ✓

안녕하세요.

Oracle 19.12 Standard Edition 2 이용중입니다.

아래와 같이 파라미터가 설정되어 있는데, archive file이 log_archive_format 형식이 아닌 o1mf_1_xxxxx.arc (OMF) 형식으로 떨어지고 있어서 문의드립니다.

The parameters are set as follows. But the archive file is created in o1mf_1_xxxxx.arc (OMF) format rather than log_archive_format format.


***************************************************************

log_archive_dest_1='LOCATION=USE_DB_RECOVERY_FILE_DEST'

log_archive_format=DBname_%t_%s_%r.arc

db_recovery_file_dest=/arch

db_create_file_dest=''

log_archive_dest=''

***************************************************************

파라미터 조회시 log_archive_format 은 정상적으로 적용되어 있는것으로 보입니다.

추가로 확인해봐야할 사항이 있다면 가이드 부탁드립니다.

When inquiring parameters, log_archive_format seems to be applied normally.

If there are additional things to check, please guide.

감사합니다.

Thank you

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center