GeekInterview.com
Series: Subject: Topic:
Question: 11 of 32

How can we specify the Archived log file name format and destination?

 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.
Asked by: Interview Candidate | Asked on: Sep 6th, 2004

This Question is not yet answered!

Related Answered Questions

Related Open Questions

User Panel

Register
Login
Lost Password
Get Activation Code

Categories

Backup and Recovery

Basics

Concepts and Architecture

D2K

Data Access

Database Administration

Database security

Database Tuning

Distributed Processing

General

Memory Management

Oracle Forms 4.0

PL/SQL

Programmatic Constructs

RMAN Interview Questions

Scenarios

SQL

SQL Plus

System Architecture

Interview Coaching

Importance of an MBA for an entrepreneur

Describe a time when you had to convince a friend ?

What was the most important decision you ever had to make?

Does a problem make you a better person?

What are the career opportunities available for MCA Graduates?

Have you experienced being given too many tasks?

How to Overcome Employment Gap during interview.

Has there been a time when you were presented a problem and solved it?

How to handle academic gap while applying for a job?

How do you handle workplace problems?

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.

Subscribe