Where would you look to find out if a redo log was corrupted assuming you are using oracle mirrored redo logs?
Answer / Praveen Kumar Pravendra
If you suspect a corrupted redo log while using Oracle mirrored redo logs, check the alert log files for any error messages related to redo log errors. Additionally, examine the V$LOG_HISTORY view to identify any inconsistencies in the redo log records.
| Is This Answer Correct ? | 0 Yes | 0 No |
Explain dual table. Is any data internally stored in dual table. Lot of users is accessing select sysdate from dual and they getting some millisecond differences. If we execute select sysdate from emp; what error will we get. Why?
What is the difference between cold backup and hot backup?
How to uncatalog backup?
What do you mean by oracle dba and what is its role?
What is the most common database language that a db administrator needs to know?
What operator tests column for the absence of data?
You have taken import of a table in a database. You have got the integrity constraint violation error. How you are going to resolve it.
What kinds of responsibilities does a dba have in a database environment?
Is oracle dba in demand?
If you have an example table, what is the best way to get sizing data for the production table implementation?
Which process writes data from data files to database buffer cache?
How to drop an oracle database?