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
Is sap a database ?
How you can assign an object to 100 roles at time?
Is it possible to install sap patches when other users are online?
what is the difference b/w 4.7EE & ECC5.0?
What is Unit Testing in SAP?
what is the use of tcode SUSHARE in SAP and how the mass user authorizations compared?
what is the use of psapundo tablespace? what is the error ora -01555 represents.how can u prevent this error?
I want to change five dialog work processes into batch. Where can I do this?
How you can restrict multiple logins of user in sap? What are the thing you have to take care of while writing the id’s?
What is process for applying patches?
What is sap market place?
What settings we have to do in EEWC while using slandalone SAP-CRM system.
How to perform the transport?
what post steps and pre steps db refresh
If you have a long-running Job, how do you analyse?