Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

Is sap a database ?

1101


How you can assign an object to 100 roles at time?

1427


Is it possible to install sap patches when other users are online?

1040


what is the difference b/w 4.7EE & ECC5.0?

2416


What is Unit Testing in SAP?

1263


what is the use of tcode SUSHARE in SAP and how the mass user authorizations compared?

2529


what is the use of psapundo tablespace? what is the error ora -01555 represents.how can u prevent this error?

12131


I want to change five dialog work processes into batch. Where can I do this?

1191


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?

1253


What is process for applying patches?

1141


What is sap market place?

1143


What settings we have to do in EEWC while using slandalone SAP-CRM system.

2680


How to perform the transport?

1158


what post steps and pre steps db refresh

3242


If you have a long-running Job, how do you analyse?

1138