in oracle how to find whether archive mode is enabled or not?
Answer Posted / srinivas (apcpdcl)
1ST: T-CODE DB03-----CLICK ON INIT<SID>.ORA TAB
Here 'log_archive_start' set to TRUE, Then it is in
archive log mode
2ND: Login as ora<sid> and check the init<sid>.ora file
check the parameter 'log_archive_start' in init<SID>.ora
file, if it is set as 'true' then archive is enabled.
3rd :SQL>archive loglist then it shows
archive logmode enabled or disabled.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Explain how to define logon groups?
If client copy is stopped in middle, what happens if you want to start it again?
Is there any report or table in which user log off time is stored in sap?
Mention what is the difference between central instance & application server?
In the Sap Easy Access Menu I see the menu System -> User Profiles ->Own Data. Other options Hold Data is to keep data values that you have entered in a field of an application for the duration of the session; SET DATA not to overwrite the data and DELETE DATA to delete the set data. Can somebody explain me the Hold Data, Set Data and Delete Data with examples, i mean giving an example of fields?
How database extend?
What is GRIR, GRIR effect, why it is imp, How it is analysed, What is expected out GRIR, What is auto write off & Manual GRIR write off?
What is the use of Trusted system? I know that there is no need of UID and PWD to communicate with partner system. In what situation it is good to go for Trusted system?
How to identify a particular T_Code has been modified or not? If yes, how to identify who modified particular T_Code in current system?
what is the procedure for java stack upgradation?
What is oracle Architecture?
What is “data sets” in sap?
A user moved the transport request from dev to qua. How would you trace him?
what is your project architecture?
What are the different types of rfc and explain what transactional rfc is?