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. |
☺ | Oracle RMAN Interview Questions. |