Database Administration (MOSC)

MOSC Banner

Remove OMF from Archived Redo Logs

edited Jan 26, 2010 12:38AM in Database Administration (MOSC) 11 commentsAnswered ✓
 Hi all

I have created the database with command line manually (without dbca). 
Oracle saves the ARCH Files in the FRA with an OMF Syntax. I don't like OMF...

How it's possible to remove them?

Oracle 11.1.0.7.0

Show Parameter
*********************
db_create_file_dest                  string
db_create_online_log_dest_1          string
log_archive_format                   string      ARC%s_%r_%t.arc
log_archive_dest_10                  string      LOCATION=USE_DB_RECOVERY_FILE_DEST
db_recovery_file_dest                string      F:\choE\FRA
db_recovery_file_dest_size           big integer 1047483648

creates files like this
**************************
F:\choE\FRA\CHOE\ARCHIVELOG\2010_01_21 1 O1_MF_1_3_5OJTP2KX_.ARC

Thank's for your advice

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