Oracle DBA Question:
Download Questions PDF

Explain FORCE LOGGING feature in 9i.

Answer:

By setting FORCE LOGGING to TRUE, all transactions will generate REDO. This is used for Data Guard, so no data will be missed (i.e. transactions that were run with NOLOGGING option) in Standby database

Download Oracle DBA Interview Questions And Answers PDF

Previous QuestionNext Question
How can you tell if an index on particular table is USED or NOT USED in 9i?Is it necessary to have database in archive log mode in configuration dataguard , if yes then why?