how will u see whether the dabase is in archive log mode or not?
Answer Posted / kittu
in two ways we can check
1) archive log list
2) select log_mode from v$database;
| Is This Answer Correct ? | 10 Yes | 0 No |
Post New Answer View All Answers
What are the different ways you can create databases in sql server? : sql server DBA
What is the difference between dropping a database and taking a database offline? : sql server DBA
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
What is a system database and what is a user database? : sql server DBA
What are the commands used in dcl? : sql server DBA
What is replication? : sql server DBA
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA
what is a user-defined lock?
what are the differences of where and if in SAS?
how can you generate profile of pl/sql applications to identify performance bottlenecks?
How do you trace the traffic hitting a sql server? : sql server DBA
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
What is the difference between clustered and non-clustered index? : sql server DBA