Explain How can you 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 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.
Submitted by: Administrator
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.
Submitted by: Administrator
Read Online Database Security Oracle Job Interview Questions And Answers
Top Database Security Oracle Questions
| ☺ | Explain What is Privilege Auditing? |
| ☺ | Explain How you can secure our data in local area Network? |
| ☺ | Explain What are roles? How can you implement roles? |
| ☺ | What are the security features in Oracle? |
| ☺ | Explain How can we enable automatic archiving? |
Top DB Oracle Categories
| ☺ | Oracle PL-SQL Interview Questions. |
| ☺ | Oracle DBA Interview Questions. |
| ☺ | Oracle D2K Interview Questions. |
| ☺ | OCI Interview Questions. |
| ☺ | Forms Reports Interview Questions. |
