Oracle Study Notes: Definitions and usage of log_archive_format

Log_archive_format isCannot alter SystemNon-Basic initialization parameters of, define the archive files of the database in archivelog ModeNaming rules.

AndAppendIt is very interesting to find a valid archive path! If the archive path is invalid, it is converted to another valid path. The priority is as follows:

1. {Log_archive_des | log_archive_dest_n}
2. [Log_archive_duplex_dest]
3. Db_recovery_file_dest
4. % ORACLE_HOME % \ database [DBS]

 

Archive_log_dest [_ n] or DB

Default log_archive_format:Arc % S _ % R. % t

Filesystem characters allowed by any OSYes, but it should passReplace variableImplemented file nameUniqueness!

Replace variables can be either uppercase or lowercase, but the difference is that replace variables in uppercase"0"Fill in the insufficient number of digits.

Replace the variable log_archive_format:

1. % S -- the file serial number of archvied redo File
2. % T -- archiving thread number
3. % D -- dbid. Note that, unlike the % d format in rman, it is the same as % I
4. % R -- resetlogsid number