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 deletion flag. Where is it used in archiving process?
Explain what is the importance of table t000?
Explain how client refresh is different than client copy?
What is the difference between asynchronous and synchronous transport?
Why can't we do it thru some other client?
can anyone tellme java instance startup sequence?
How can you find the list of objects that have been repaired in the system?
What is process for applying patches?
What is Unit Testing in SAP?
What are the DVD's Download for implementation?
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?
Explain reference and service user in sap. What are their uses?
At os level how you can change the number of work process? How you can analyze the status of work process at os level?
What is development class? Why to create the development class?
What is the system's configuration required to implement SAP.