how will u see whether the dabase is in archive log mode or not?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / krishna
archive log list
select log_mode from v$database;
Is This Answer Correct ? | 1 Yes | 0 No |
How do you increase the OS limitation for open files (LINUX and/or Solaris)?
what r the types of backup?
What are the different ways of moving data or databases between servers and databases in SQL Server?
how can you schedule a job in database?
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
What are the steps you will take to improve performance of a poor performing query?
How to make a replica of existing oracle server to another server?
Which dictionary tables and/or views would you look at to diagnose a locking issue?
How would you go about increasing the buffer cache hit ratio?
How would you best determine why your MVIEW couldn't FAST REFRESH?