1.

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.

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.


Discussion

No Comment Found

Related InterviewSolutions