Concept of Flashback Query in Oracle (10g in particular)

Whats the Concept of Flashback Query in Oracle (10g in particular) and how is it beneficial?

Due to human errors, valuable data gets deleted or misentered. Oracle Flashback Technology provides a set of new features to view and undo the data back and forth.

The benefits of flashback querying are:

- The capability of querying the historical data,
- perform change analysis, and
- perform self-service repair to recover from logical corruptions while the database is online
What is mean live lock and deadlock? How to prevent it?
A deadlock can occur when two or more processes that strive to acquire resources are not able to acquire them due to some of the following reasons:.....
What is Partial Backup?
A partial backup is similar to a full database backup, but a it does not contain all the filegroups....
What is Mirrored on-line Redo Log?
Due to Mirrored online redo logs and disk array mirroring, the occurrence of redo log corruptions has dropped to practically zero......
Post your comment

Related Content

Follow us

▲