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

if i want to limit the condition record validity for forst 10 orders how can i do tht plz ans i hve interview in 2/3 days

1538


Error in the phase import_proper while applying support packages?

1338


What is the purpose of tdevc ?

952


Explain kernel upgrade?

621


Explain deletion flag?

709






How to transport objects from Production to Development?

1690


Hi ,All What is the multi-threading and max connections for rfc. Actually i am facing problem while send large amount of idocs to external system using middle ware tibco r3 adapter. And how to enable these in SAP ?

1936


Can you tell me about the landscape migration to cloud ?

1230


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

679


What are the Parameters need to be set when connecting EP to r/3 system what are they?

1372


IN FUNCTIONAL MODULE SD WE UNFORTUNETLY DELETE OUR ONE ITEM CATEGORY "TAN" FOR THAT WE WANT RECOVER IT WHAT ARE THE PROCEDURES. IS THERE ANY PROCEDURES LIKE RECYCLEBIN. TELL US DETAIL PROCEDURES STEP BY STEP PLEASE

1619


What are the activities you done in EP?

1306


I am attempting to complete a system copy of bw. When I try to go in to rsa1 afterwards I get the error message, "entry in inbound table already exists." What should I do to solve the problem?

771


What is the difference between consolidation and development route ?

741


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

902