Interested to Buy Any Domain ? << Click Here >> for more details...
in oracle how to find whether archive mode is enabled or not?
- 4 Answers
- 9886 Views
- iGate, I also Faced
- E-Mail Answers
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
What are the regular activities u do in solution manager and how
Where XML file is generated in solution manager?
What is osp$ mean?
Explain the developer trace?
How do you check the users logs in your system and how many sessions each user is generating?
What is oracle Architecture?
what is the use of tcode SUSHARE in SAP and how the mass user authorizations compared?
What is the information derived from OSS notes?
If brtools is not working how you will add datafile?
How you can apply sap notes to sap system?
I want to let sap skip printing cover pages during printing for any kind of report. How can this be done?
What are the different types of job status? Can you unschedule an active job?
What is private mode? When does user switch to user mode?
A transport is imported into QAS in 2 min. time the same transport when imported into PRD is taking more than 20 min. why? What to do?
what is garbage collector. is there any way to set the time to gc?
