how will u see whether the dabase is in archive log mode or not?

Answer Posted / krishna

archive log list
select log_mode from v$database;

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is ora 24313?what is the procedure to exclude that error?

2107


What purpose does the model database server? : sql server DBA

631


What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA

604


when does an alert gets signaled?

586


Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

1705






How do you troubleshoot errors in a sql server agent job? : sql server DBA

569


What is a correlated sub-query? : sql server DBA

585


how can you get actual data change values from previous transactions in oracle?

619


what are the types of connection load-balancing?

564


What are the operating modes in which database mirroring runs? : sql server DBA

617


what is the role of dip user in our database?

2053


What types of replication are supported in sql server? : sql server DBA

605


what do you understand by flashback feature of oracle?

564


how can you communicate with operating system files from oracle?

565


How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?

1909