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 is logical system in sap basis
Explain materialized views and how they are used.
What is dcl? : sql server DBA
If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA
how can you enable flashback feature?
what is asm?
how can you communicate with operating system files from oracle?
what do you understand by fine-grained auditing?
what are the performance views in an oracle rac environment?
Can you redefine a table online?
What authentication modes does sql server support? : sql server DBA
what is ora 24313?what is the procedure to exclude that error?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me
What are the recovery models for a database? : sql server DBA