How can we specify the Archived log file name format and destination?
Submitted by: AdministratorBy 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.
Submitted by: Administrator
Submitted by: Administrator
Read Online Database Administrator (DBA) Job Interview Questions And Answers
Top Database Administrator (DBA) Questions
☺ | Name three advisory statistics you can collect. |
☺ | How would you determine who has added a row to a table? |
☺ | What are the ways to monitor the performance of the report? |
☺ | What DBA activities did you to do today? |
☺ | What is the maximum no of chars the parameter can store? |
Top Databases Programming Categories
☺ | RDBMS Interview Questions. |
☺ | SQL Interview Questions. |
☺ | SSRS Interview Questions. |
☺ | Sybase Interview Questions. |
☺ | Database Administrator (DBA) Interview Questions. |