check the parameter 'log_archive_start' in init<SID>.ora

in oracle how to find whether archive mode is enabled or not?

Question Posted / m k hazra

Answer Posted / m k hazra

check the parameter 'log_archive_start' in init<SID>.ora
file, if it is set as 'true' then archive is enabled.

Is This Answer Correct ?

9 Yes

0 No

Please Help Members By Posting Answers For Below Questions

what is the common storage file for oracle ?

2042

How to see when were the optimizer stats last time run?

1124

How to add authorizations, how you will maintain profiles?

1914

Explain logon load balancing?

1054

How you will give new authorizations?

1786

How client refresh is different than client copy?

1178

How will u send mail after completion of backup?

2102

How do you check the users logs in your system and how many sessions each user is generating?

1007

Explain what is the purpose of tdevc ?

1101

User wants lock ASAP then what will u do?

1862

Where will you change the parameters in three profiles?

1133

Is there a way to perform sapgui 640 roll out using a centralized server?

1062

How will go about doing a client copy ?

1011

Is there any report or table in which user log off time is stored in sap?

1058

How many times bdls transaction executes for 2 clients

1828