How to 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 Oracle Security Job Interview Questions And Answers
Top Oracle Security Questions
☺ | What is snapshots? |
☺ | How to specify the Archived log file name format and destination? |
☺ | Explain What are the dictionary tables used to monitor a database spaces? |
☺ | How to prevent unauthorized use of privileges granted to a Role? |
☺ | Explain snapshot log? |
Top DB Oracle Categories
☺ | Oracle PL-SQL Interview Questions. |
☺ | Oracle DBA Interview Questions. |
☺ | Oracle D2K Interview Questions. |
☺ | OCI Interview Questions. |
☺ | Oracle RMAN Interview Questions. |