Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

How can we specify the Archived log file name format and destination ?

April 26, 2017destination file format log specify

0

Posted

How can we specify the Archived log file name format and destination ?

2 Answers

0

Posted

By setting the following values in init.ora file LOG_ARCHIVE_FORMAT = arch%S/s/T/t.arc (%S – Log sequence number and is zero left-paded, %s – Log sequence number not paded, %T – Thread number left-zero-paded and %t – Thread number not paded). The file name created is arch0001.arc %S is used. LOG_ARCHIEVE_DEST = path Shut the database and change these parameters in init.ora files.

0

Posted

– 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 padded, %s – Log sequence number not padded. %T – Thread number left-zero- padded and %t – Thread number not padded). The file name created is arch 0001 are if %S is used. LOG_ARCHIVE_DEST = path.