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
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
Error in the phase import_proper while applying support packages?
What is the purpose of tdevc ?
Explain kernel upgrade?
Explain deletion flag?
How to transport objects from Production to Development?
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 ?
Can you tell me about the landscape migration to cloud ?
Is there any report or table in which user log off time is stored in sap?
What are the Parameters need to be set when connecting EP to r/3 system what are they?
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
What are the activities you done in EP?
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?
What is the difference between consolidation and development route ?
How you can assign an object to 100 roles at time?