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
How to apply job on OS Level?
What is the difference between developer trace, system log and system trace?
Explain what is the use of reference and service user in sap?
What is the database backup strategy in your company?
How do you kill a job in SAP?
How can you find a list of objects that have been repaired in the system?
What do you understand by transport management in sap basis?
What are the key activities that you perform as part of sap basis support?
How do you distribute the load?
How to check CPU usage in EP? If java path is down the how to do trouble shoot? What is the transport group? What is the SLD system in PI? How to take back up in EP? How to create logical system? Is it possible to change the name logical system in SSC4? How you will take the online Backup and incremental Backup? What is the backup strategy? How many application servers you have in Production System? Difference between oracle 9i and oracle 10g? What is EHP4? What is your enhancement package and support package? how to find RAM size on Unix? How to find OS level at command Prompt? While doing kernel upgrade what is exe files? What is client comparison? How to apply job on Os level? What are the recent challenges faced? How to apply support package in solution manager? Difference between SPDD/SPAU If SAP* is not working ? If job is slow? how you will trouble shoot? What are software files required for SAP 4.7?
How to transport objects from Production to Development?
I want to change five dialog work processes into batch. Where can I do this?
I also wanna work with Webdynpros? What are the requirements? I mean SAP 4.7 ee or ECC 5 or 6? Netweaver developer Studio? Also with win 2003 i have the activation problem every month. SO do i get a cd that doesnt ask for the activation? i have win 2000 but can it be installed on HP pavilion laptops that are coming preinstalled with Vista OS?
i want my company code and controlling area defaut as 'ABC" through out SAP what to do ? and my plantcode also default to some value
How to check cpu usage in EP?