Database Administrator (DBA) Question: Download Questions PDF
How can we 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 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.
Download Database Administrator (DBA) Interview Questions And Answers
PDF
| Previous Question | Next Question |
| What are the minimum parameters should exist in the parameter file (init.ora)? | What is user Account in Oracle database? |