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
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
how can you record information about current session?
what are the differences of where and if in SAS?
What are the commands you'd issue to show the explain plan for "select * from dual"?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB
what functionality does oracle provide to secure sensitive information?
what is grd?
How can you control the amount of free space in your index pages? : sql server DBA
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?
What would you do with an "in-doubt" distributed transaction?
how can you initialize log miner?
What purpose does the model database server? : sql server DBA
What the different topologies in which replication can be configured? : sql server DBA