Interested to Buy Any Domain ? << Click Here >> for more details...
How can we specify the Archived log file name format and
destination ?
- 2 Answers
- 7170 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / guest
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 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.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / shailendra kumar
We can spacifice archive archive log in init.ora file
LOG_ARCHIVE_DEST = /disk/SIDDB/admin/SID/arch
LOG_ARCHIVE_FORMAT = 'log%t_%s_%r.arc'
| Is This Answer Correct ? | 1 Yes | 1 No |
What are roles ? How can we implement roles ?
What dynamic data replication ?
How will you enforce security using stored procedures ?
What is a trace file and how is it created ?
What is default tablespace ?
What are the dictionary tables used to monitor a database spaces ?
What are the responsibilities of a Database Administrator ?
What is Object Auditing ?
How can you Enforce Refrencial Integrity in snapshots ?
What is snapshots ?
What are the use of Roles ?
What are the benefits of distributed options in databases ?
Oracle General 
