Oracle Security Question:
How to specify the Archived log file name format and destination?
Answer:
By setting the following values in init.ora file.
LOG_ARCHIVE_FORMAT = arch %S/s/T/tarc (%S - Log sequence
number and is zero left paded, %s - Log sequence
number not padded. %T - Thread number lef-zero-paded and
%t - Thread number not padded). The file name created is
arch 0001 are if %S is used.
LOG_ARCHIVE_DEST = path.
LOG_ARCHIVE_FORMAT = arch %S/s/T/tarc (%S - Log sequence
number and is zero left paded, %s - Log sequence
number not padded. %T - Thread number lef-zero-paded and
%t - Thread number not padded). The file name created is
arch 0001 are if %S is used.
LOG_ARCHIVE_DEST = path.
| Previous Question | Next Question |
| Explain What is the use of ANALYZE command? | How to enable automatic archiving? |