Answers

Question and Answer:

  Home  Oracle Security

⟩ How to specify the Archived log file name format and destination?

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.

 202 views

More Questions for you: