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 can you record information about current session?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
What is a deadlock and what is a live lock? How will you go about resolving deadlocks?
What would you do with an "in-doubt" distributed transaction?
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
what is ora 600?
What is checkpoint?
What are the different types of upgrades that can be performed in sql server? : sql server DBA
Explain the difference between a data block, an extent and a segment.
Explain how you would restore a database using RMAN to Point in Time?
WHEN DOWN TIME WHAT CAN U DO?
Where do you find the default index fill factor and how to change it? : sql server DBA