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


Please Help Members By Posting Answers For Below Questions

i'm new for security, pls help if assign the t-code to parent it wll effect to child role or not. can we assign to t-code directly to child role? it wll work or not?

3779


Have you done any parameter changes using configtool and visual admin tool?

1370


What are patches you applied?

801


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

682


What is a background processing batch scheduler?

685






i am arun, as of now i am working in a power plant. I did B.E mech and have completed PGDC in thermal power plant engineering from NPTI(NATIONAL POWER TRAINING INSTITUTE). I started my career in software oly , as i dono any software languages i got failed in conformation exam. Pls help me , i want to enter software field. in this powerplant field 6 working days for week and holiday is also not sunday, i am not able 2 tc of my family... pls help me how to enter sf fielf. my frds sujjested me 2 try as functional after 2 years. wats the procedure for that... pls pls help me in this issue I have 1 year exp in power plant, i knew mechanical design software. my id : arun0029@gmail.com

1672


What is transport domain?

1414


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?

1838


How you can assign an object to 100 roles at time?

905


Can you tell me about the landscape migration to cloud ?

1232


Some transactions in sap are seen as customizing, for instance ovrf (updating routes). In some systems this is set as master data and can be set open. Where do you do this?

607


What is the difference between central instance & application server?

607


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?

2651


How do you generate (recover) old system logs in a newly created SLOG00?

1699


What are the different options available for scheduling a background job? What start conditions type can be used?

604