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 the system's configuration required to implement SAP.
What are the pre requisite for the SAP Installation?
How can a client be locked?
What is the Max No of Dialog Process can you assign using RZ04 ? What are the max No dialog process you can assign my changing the profile
How to fiind if there are an expensive SQL statements running if yes, What to do?
what is diff b/n sm50 and sm66 with explanations and screenshots
how to build index in oracle? how to chk oracle up or not in sql?
how to lock/unlock a client?
What is transport layer and domain controller? In which system you have create domain control?
Hi there, Can any one suggest me a good SAP-BASIS training institute near Indiranagar In Bangalore.
what is the road map of SAP ?
When we are doing cash sales, free goods and discount, How many pricing procedure do we need to create..? Only one PP required or have to create multiple PP..? and how many condition type we need to create..?