in oracle how to find whether archive mode is enabled or not?
Answers were Sorted based on User's Feedback
Answer / m k hazra
check the parameter 'log_archive_start' in init<SID>.ora
file, if it is set as 'true' then archive is enabled.
Is This Answer Correct ? | 9 Yes | 0 No |
Answer / ramana
go to os level and connect to sqlplus
and type command archive loglist then it shows archive
logmode enabled or disabled.
Regards
Ramana
Is This Answer Correct ? | 4 Yes | 0 No |
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 |
Answer / s.m.feroz ahmed
Hi,
To check whether the Archive Mode is Enabled or not goto
path:
DriveName (C or D):/Oracle/ora81/and type command Archive
and it will show whether it is enabled or disabled.
Is This Answer Correct ? | 0 Yes | 1 No |
What is SAPS?
Mention the use of personalized tab and parameter tab in user master record?
What are the steps to configure TMS?
What are the configuration details of ECC6.0? 1. Server ConfigurationèHDD, RAM, OS, DATABASE. 2. System Configurationè HDD, RAM, OS, DATABASE
How to determine the authorization a user-required for executing particular transaction(s)?
what is the default password for creating client in ecc6.? in 4.7e and 5.0 its default is: username sap* and password: PASS.but i tried in ecc6.0 it shows error. it require min 6 character.
What is redolog file? Path?
How you apply patches on java using JSPM?
In Hardware sizing what is user based sizing? and what is throughput sizing??
How to do client copy fast?
How do I know what threshold values to set
how to install sap help in sap 4.7